Database is locked


I’m using Pydio 8.0.2-1 (from dep package) on a Debian jessie server.
I configured the server with sqlite backend. Since the beginning I’m having the message “database is locked” and since few weeks I can see this in my apache2 error.log

[Thu Apr 12 10:45:30.510041 2018] [:error] [pid 23923] [client :51244] Exception while logging, referer: https:///pydio/welcome/ [Thu Apr 12 10:45:30.510658 2018] [:error] [pid 23923] [client :51244] Log message was : IP => | user => shared | level => Error | source => DibiSqlite3Driver.php | prefix => error l.114 | message => message=database is locked, referer: https:///pydio/welcome/ [Thu Apr 12 10:45:30.510754 2018] [:error] [pid 23923] [client :51244] Exception is:database is locked, referer: https:///pydio/welcome/ [Thu Apr 12 10:45:30.510833 2018] [:error] [pid 23923] [client :51244] In /usr/share/pydio/core/src/lib/dibi/drivers/DibiSqlite3Driver.php line 114, referer: https:///pydio/welcome/ [Thu Apr 12 10:45:30.510991 2018] [:error] [pid 23923] [client :51244] #0 /usr/share/pydio/core/src/lib/dibi/libs/DibiConnection.php(324): DibiSqlite3Driver->query('INSERT INTO [aj...')\n#1 /usr/share/pydio/core/src/lib/dibi/libs/DibiConnection.php(246): DibiConnection->nativeQuery('INSERT INTO [aj...')\n#2 /usr/share/pydio/core/src/lib/dibi/libs/Dibi.php(183): DibiConnection->query(Array)\n#3 /usr/share/pydio/plugins/log.sql/SqlLogDriver.php(460): dibi::query('INSERT INTO [aj...', Array)\n#4 /usr/share/pydio/plugins/core.log/Logger.php(126): Pydio\\Log\\Implementation\\SqlLogDriver->write2('Error', '', 'shared', 'no-repository', 'DibiSqlite3Driv...', 'error l.114', 'message=databas...', Array)\n#5 /usr/share/pydio/plugins/core.log/Logger.php(229): Pydio\\Log\\Core\\Logger::log2('Error', 'DibiSqlite3Driv...', 'error l.114', Array)\n#6 /usr/share/pydio/core/src/pydio/Core/Http/Server.php(235): Pydio\\Log\\Core\\Logger::error('DibiSqlite3Driv...', 'error l.114', Array)\n#7 /usr/share/pydio/core/src/pydio/Core/Http/Server.php(284): Pydio\\Core\\Http\\Server->catchError(5, 'database is loc...', '/usr/share/pydi...', 114, Object(DibiDriverException))\n#8 [internal function]: Pydio\\Core\\Http\\Server->catchException(Object(DibiDriverException))\n#9 {main}, referer: https:///pydio/welcome/
After some of this error, the apache2 server crash completely.

I was about to migrate from sqlite to mariadb, but it is a king of a nightmare as there is no good tool to convert a sqlite dump to a mysql format.

Can anyone help me to solve the database issue or help in converting my current db to mysql ?

Many thanks

you could try this tool to convert to sql and then use mariadb which should work quickly.

Thanks @zayn ! Online service for database conversion, we really have to trust such service.

Yeah it’s true that you need safety for that as there is confidential data.

I’ve looked on the SQLite website and there might be tools that allows you to convert check this link

look at tools

Thanks for the link, but there is no tool for db conversion.