[Mayan EDMS: 1951] Database is locked

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Mayan EDMS: 1951] Database is locked

Gökhan Topcuoğlu
Hello,

I want to upload pdf documents to EDMS but I am getting "Database is locked" error but the files appear in document_storage folder. What can i do for this error. Thank you

Best Regards

--

---
You received this message because you are subscribed to the Google Groups "Mayan EDMS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.

Screenshot_20170730_123710.png (89K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Mayan EDMS: 1952] Re: Database is locked

David Kornahrens
I would start by restarting the instance.  Did you deploy through Docker?

--

---
You received this message because you are subscribed to the Google Groups "Mayan EDMS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Mayan EDMS: 1953] Re: Database is locked

rosarior
Administrator
In reply to this post by Gökhan Topcuoğlu
Hi,

This is an issue with the default database manager used to make installations simple: SQLite. SQLite is a lightweight database manager it is very good and ideal for getting started for the trade off is lower concurrency than other database managers like PostgreSQL or MySQL. You specific usage/hardware/OS, or others combination is hitting the concurrency limit. Here is a longer explanation: https://stackoverflow.com/questions/28958580/django-sqlite-database-is-locked#28959683

If you are using the Docker method you can deploy with Postgres or MySQL. The Mayan Docker image has support out-of-the-box for both. Here is a blog post explaining how to deploy Mayan EDMS using Docker with MySQL as the database: https://www.mayan-edms.com/post/deploy-mayan-docker-mysql/

In the meantime, to unlock the database just restart the container with:

docker restart mayan-edms


On Sunday, July 30, 2017 at 5:44:58 AM UTC-4, Gökhan Topcuoğlu wrote:
Hello,

I want to upload pdf documents to EDMS but I am getting "Database is locked" error but the files appear in document_storage folder. What can i do for this error. Thank you

Best Regards

--

---
You received this message because you are subscribed to the Google Groups "Mayan EDMS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Mayan EDMS: 1956] Re: Database is locked

Gökhan Topcuoğlu
Hi,

My problem is solved with MySQL

Thank you


31 Temmuz 2017 Pazartesi 03:37:08 UTC+3 tarihinde Roberto Rosario yazdı:
Hi,

This is an issue with the default database manager used to make installations simple: SQLite. SQLite is a lightweight database manager it is very good and ideal for getting started for the trade off is lower concurrency than other database managers like PostgreSQL or MySQL. You specific usage/hardware/OS, or others combination is hitting the concurrency limit. Here is a longer explanation: <a href="https://stackoverflow.com/questions/28958580/django-sqlite-database-is-locked#28959683" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F28958580%2Fdjango-sqlite-database-is-locked%2328959683\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNFr0EbgWdlD389jiuh1QbFiP8Tqsw&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F28958580%2Fdjango-sqlite-database-is-locked%2328959683\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNFr0EbgWdlD389jiuh1QbFiP8Tqsw&#39;;return true;">https://stackoverflow.com/questions/28958580/django-sqlite-database-is-locked#28959683

If you are using the Docker method you can deploy with Postgres or MySQL. The Mayan Docker image has support out-of-the-box for both. Here is a blog post explaining how to deploy Mayan EDMS using Docker with MySQL as the database: <a href="https://www.mayan-edms.com/post/deploy-mayan-docker-mysql/" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.mayan-edms.com%2Fpost%2Fdeploy-mayan-docker-mysql%2F\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNH2m38sg-Su3DixA2C9CtHwIA-L7A&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.mayan-edms.com%2Fpost%2Fdeploy-mayan-docker-mysql%2F\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNH2m38sg-Su3DixA2C9CtHwIA-L7A&#39;;return true;">https://www.mayan-edms.com/post/deploy-mayan-docker-mysql/

In the meantime, to unlock the database just restart the container with:

docker restart mayan-edms


On Sunday, July 30, 2017 at 5:44:58 AM UTC-4, Gökhan Topcuoğlu wrote:
Hello,

I want to upload pdf documents to EDMS but I am getting "Database is locked" error but the files appear in document_storage folder. What can i do for this error. Thank you

Best Regards

--

---
You received this message because you are subscribed to the Google Groups "Mayan EDMS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.
Loading...