Comments (6)
peteygao
commented on May 22, 2024
1
Why not use Postgres as the default database instead of MySQL?
from open-paperless.
zhoubear
commented on May 22, 2024
The default database used is SQLite which doesn't support too many open connections at the same time. Working on making MySQL the default database manage.
from open-paperless.
zhoubear
commented on May 22, 2024
I gave Postgres a try but the user creation and authentication stumped me. If you have some experience with Postgres and could provide a step by step for creating users and such I could give it another try.
from open-paperless.
Floehe
commented on May 22, 2024
...I understand the limitations of SQLite but I do not open any connections deliberately. I just added a new new source folder and manually started a check on this folder. Also there are many manage.py tasks running, maybe they all want to access the DB?
this comes approx. 10 times in a ps-ef:
python manage.py celery worker --settings=mayan.settings.production -B -Ofair -l ERROR
from open-paperless.
mbnoimi
commented on May 22, 2024
I've same issue which stopped my from using it.
I only added one pdf file!!!
[2018-01-02 13:21:45,268: ERROR/Beat] Database error while sync: OperationalError('database is locked',)
Traceback (most recent call last):
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/djcelery/schedulers.py", line 212, in sync
self.schedule[name].save()
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/djcelery/schedulers.py", line 102, in save
obj.save()
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/djcelery/models.py", line 281, in save
super(PeriodicTask, self).save(*args, **kwargs)
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/django/db/models/base.py", line 796, in save
force_update=force_update, update_fields=update_fields)
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/django/db/models/base.py", line 824, in save_base
updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/django/db/models/base.py", line 889, in _save_table
forced_update)
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/django/db/models/base.py", line 939, in _do_update
return filtered._update(values) > 0
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/django/db/models/query.py", line 654, in _update
return query.get_compiler(self.db).execute_sql(CURSOR)
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 1148, in execute_sql
cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 835, in execute_sql
cursor.execute(sql, params)
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/home/mbnoimi/Downloads/open-paperless-master/venv/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 337, in execute
return Database.Cursor.execute(self, query, params)
OperationalError: database is locked
from open-paperless.
kawael
commented on May 22, 2024
Same Problem
from open-paperless.
Related Issues (14)
- request: Docker version HOT 2
- Travis testing is not yet turned on for this repo HOT 1
- Running on localhost HOT 4
- can this run on raspberry pi 3? HOT 1
- Documentation is somewhat lacking
- can this run at OSX or Windows systems? HOT 9
- Landscape Documents do not OCR correctly. HOT 1
- Error when running run.sh HOT 6
- Documents Storage
- This is a direct copy and license change of Mayan EDMS HOT 3
- Project Discontinued? HOT 5
- User input document label
- Any chance you could containerize? HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from open-paperless.