# Database is locked **URL:** \ **Category:** Pydio 8\ **Created:** [April 12, 2018, 8:59am UTC](https://forum.pydio.com/t/database-is-locked/1000 "2018-04-12T08:59:18Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![florian](https://avatars.discourse-cdn.com/v4/letter/f/898d66/32.png) [@florian](https://forum.pydio.com/u/florian)\ **Post date:** [April 12, 2018, 8:59am UTC](https://forum.pydio.com/t/database-is-locked/1000/1 "2018-04-12T08:59:18Z")
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 ---
**Author:** ![zayn](https://avatars.discourse-cdn.com/v4/letter/z/a87d85/32.png) [@zayn](https://forum.pydio.com/u/zayn)\ **Post date:** [April 12, 2018, 9:01am UTC](https://forum.pydio.com/t/database-is-locked/1000/2 "2018-04-12T09:01:51Z")
Hi, you could try this [tool](https://www.rebasedata.com/convert-sqlite-to-mysql-online) to convert to sql and then use mariadb which should work quickly. ---
**Author:** ![florian](https://avatars.discourse-cdn.com/v4/letter/f/898d66/32.png) [@florian](https://forum.pydio.com/u/florian)\ **Post date:** [April 12, 2018, 9:21am UTC](https://forum.pydio.com/t/database-is-locked/1000/3 "2018-04-12T09:21:29Z")
Thanks @zayn ! Online service for database conversion, we really have to trust such service. ---
**Author:** ![zayn](https://avatars.discourse-cdn.com/v4/letter/z/a87d85/32.png) [@zayn](https://forum.pydio.com/u/zayn)\ **Post date:** [April 12, 2018, 9:38am UTC](https://forum.pydio.com/t/database-is-locked/1000/4 "2018-04-12T09:38:26Z")
Yeah it’s true that you need safety for that as there is confidential data. ---
**Author:** ![zayn](https://avatars.discourse-cdn.com/v4/letter/z/a87d85/32.png) [@zayn](https://forum.pydio.com/u/zayn)\ **Post date:** [April 12, 2018, 9:49am UTC](https://forum.pydio.com/t/database-is-locked/1000/5 "2018-04-12T09:49:28Z")
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](https://www.sqlite.org/docs.html) look at tools ---
**Author:** ![florian](https://avatars.discourse-cdn.com/v4/letter/f/898d66/32.png) [@florian](https://forum.pydio.com/u/florian)\ **Post date:** [April 12, 2018, 10:15am UTC](https://forum.pydio.com/t/database-is-locked/1000/6 "2018-04-12T10:15:36Z")
Thanks for the link, but there is no tool for db conversion.