Database is locked


#1

Hello,

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
Florian


#2

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


#3

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


#4

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


#5

I’ve looked on the SQLite website and there might be tools that allows you to convert check this link https://www.sqlite.org/docs.html

look at tools


#6

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