SOMETIMES say "Error establishing a database connection"

Thanks for that log @hrr!

I’m seeing a few errors that look something like:

{"thread":"main","errno":-4048,"code":"EPERM","syscall":"open","path":"C:\\Users\\Acer\\Local Sites\\ridingcolombiarivas\\app\\sql\\local.sql.tmp","level":"error","stack":"Error: EPERM: operation not permitted, open 'C:\\Users\\Acer\\Local Sites\\ridingcolombiarivas\\app\\sql\\local.sql.tmp'","message":"EPERM: operation not permitted, open 'C:\\Users\\Acer\\Local Sites\\ridingcolombiarivas\\app\\sql\\local.sql.tmp'","timestamp":"2020-10-02T01:22:30.523Z"}
{"thread":"main","class":"","stack":"Error: EPERM: operation not permitted, stat 'C:\\Users\\Acer\\Local Sites\\ridingcolombiarivas\\app\\sql\\local.sql.tmp'","level":"error","message":"Unable to dump database.","timestamp":"2020-10-02T01:22:55.783Z"}

as well as:

{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"Sat Aug 29 17:02:07 2020 (3496): Fatal Error Unable to open base address file","timestamp":"2020-08-29T22:02:07.402Z"}

and:

{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2020-08-26T21:13:24.308894Z 1 [ERROR] [MY-012271] [InnoDB] The innodb_system data file 'ibdata1' must be writable","timestamp":"2020-08-26T21:13:24.307Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2020-08-26T21:13:24.308929Z 1 [ERROR] [MY-012278] [InnoDB] The innodb_system data file 'ibdata1' must be writable","timestamp":"2020-08-26T21:13:24.308Z"}

What appears to be happening is that for some reason, Local doesn’t have the correct permissions to do what it needs to do, especially as it relates to the database.

The most likely reason is that there is some sort of antivirus preventing this sort of thing – do you have anything like that installed?

Another potential issue could be that there isn’t enough hard-drive space, or perhaps the hard-drive is getting old and is corrupting the data?

One possible thing you can try is restoring the site to a new one in Local. You can use a backup of the site, or try using the files for the site by following the steps outlined in the “Restoring From Only Local Site files” section of this help doc: