SQLite database locked error

[landyvlad]

I'm not sure where the SQLite comes into it as I am running a mySQL database, but this morning the following two errors (well the same error twice) have appeared.

Can anyone explain why this is happening and how to resolve it?

Thank you

Guest
Today at 01:45 am
8ef25a6f81ee200b523344891f1b63dd
Type of error: General
2: SQLite3::exec(): database is locked
https://commandocomics.org/index.php?https://commandocomics.org/
/home/commando/public_html/Sources/CacheAPI-sqlite.php (Line 99)

Guest
Today at 01:45 am

447dd544c3f33b17ca91e7ab5e8aaeb1
Type of error: General
2: SQLite3::exec(): database is locked
https://commandocomics.org/index.php?https://commandocomics.org/
/home/commando/public_html/Sources/CacheAPI-sqlite.php (Line 99)

I'm unable to upload a file at the moment, but it is the default file with no changes and line 99 is

Code Select Expand

$result = $this->cacheDB->exec($query);

which is contained in the section

Code Select Expand


public function putData($key, $value, $ttl = null)
{
$ttl = $this->cacheTime + $ttl;
$query = 'REPLACE INTO cache VALUES (\'' . $this->cacheDB->escapeString($key) . '\', \'' . $this->cacheDB->escapeString($value) . '\', ' . $this->cacheDB->escapeString($ttl) . ');';
$result = $this->cacheDB->exec($query);

return $result;

[Arantor]

Did you set SQLite as the caching backend?

How to resolve it - don't use SQLite for caching.

[Bigguy]

Why....I have had this error as well and reported it. I no longer use it for caching as it gives errors. I thought it would have been the better choice between that and file based.

[landyvlad]

OK I found the setting/ I chnaged it from SQLlite to 'SMF file based".

Is that the best option, or is it better to turn off file caching?

[albertlast]

In ther best case you don't need caching,
which of the 9(typical not all are available) caching methods is the fastes depends on your enviroment.

You can test this by enable the different methode and use than the debug view of you browser and
open ther the network view.
Ther you see how mutch time it took to display your site,
do this with all methode which you like.

[Arantor]

It doesn't really matter what's fastest if it's bound by constraints like locking...

[landyvlad]

Thanks all

Errors have disappeared as you;d expect. Cheers.