SQL database locked

[Wildfirebill]

Fresh install and already having trouble with the software.

2: SQLite3::query(): Unable to execute statement: database is locked

/public_html/forum/Sources/Cache/APIs/Sqlite.php (Line 82)

[Kindred]

I did not think that 2.1 supported SQLlite

[shawnb61]

Not as a db, but that is a cache adapter.  I am not familiar with that adapter.

First thing I'd try is a different adapter, to get up and running.

[Oldiesmann]

It means that some other process is currently trying to access the database, or something timed out while trying to access that database. See https://www.sysinfotools.com/blog/sqlite-database-is-locked/ for more. If you're getting errors while trying to use that caching method you should choose a different one.

[Arantor]

Don't use SQLite3 as a cache adapter if your site is busy. It isn't designed for concurrency.

[Wildfirebill]

Yea there is only 2 choices SQLite3 or SMF file based caching. I switched to SMF file based caching and so far no trouble.

[Steve]

Will give this another day then you or one of us on the team can mark this solved.

[Diego Andrés]

I could "reproduce" this issue in one of my sites with very low traffic.
A guest triggered it, definitely related to something funky in SQLite implementation.

[Oldiesmann]

SQLite3 is designed to be lightweight and therefore doesn't support simultaneous write operations. If your site is even remotely busy then you'll run into this issue.

[vbgamer45]

Hmm would there any reason to have it as a cache system then?