Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database is locked error upon starting server #260

Open
shanlol opened this issue Mar 28, 2022 · 0 comments
Open

Database is locked error upon starting server #260

shanlol opened this issue Mar 28, 2022 · 0 comments

Comments

@shanlol
Copy link

shanlol commented Mar 28, 2022

Describe the issue
Upon trying to start the server i get this error:

(raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(sqlite3.OperationalError) database is locked
[SQL: UPDATE life SET times_opened=? WHERE life.id = ?]
[parameters: (7, 1)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)

To Reproduce
Steps to reproduce the behavior:

  1. Press Start Server

Expected behavior
The server to start with no errors

Logs
Mar-03 21:28:33--WARNING [core].happypanda.common.config: Empty configuration file
Mar-03 21:28:33--WARNING happypanda.migrate: Failed to remove data/internals.db. Please remove it yourself.
Mar-03 21:32:28--WARNING [core].happypanda.common.config: Empty configuration file
Mar-03 21:32:41--WARNING [core].happypanda.common.config: Empty configuration file
Mar-03 21:37:56--WARNING [server].happypanda.core.server: Error on func 'new_item': UserPermissionError('You do not have permission to perform this action')
Mar-03 21:38:18--WARNING [command].happypanda.core.commands.search_cmd: Search failed on {

'_source': 'id',

'from': 0,

'query': {

    'bool': {

        'filter': [

            {'match_all': {}},

            {

                'bool': {

                    'filter': [

                        {'term': {'metatags.trash': False}},

                        {

                            'nested': {

                                'path': 'user_metatags',

                                'query': {

                                    'bool': {

                                        'filter': [

                                            {

                                                'term': {

                                                    'user_metatags.user_id': {

                                                        'value': None,

                                                    },

                                                },

                                            },

                                            {

                                                'term': {

                                                    'user_metatags.readlater': {

                                                        'value': True,

                                                    },

                                                },

                                            },

                                        ],

                                    },

                                },

                            },

                        },

                    ],

                },

            },

        ],

    },

},

'size': 15,

}
Mar-03 21:38:23--WARNING [server].happypanda.core.server: Error on func 'set_config': UserPermissionError('You do not have permission to perform this action')
Mar-03 21:38:23--WARNING [server].happypanda.core.server: Error on func 'save_config': UserPermissionError('You do not have permission to perform this action')
Mar-03 22:07:05--ERROR [command].happypanda.core.services: Command DeleteItem(782) raised an exception
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.IntegrityError: UNIQUE constraint failed: gallery_userdata.user_id, gallery_userdata.parent_id

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\services.py", line 451, in _callback_wrapper
File "src\gevent\greenlet.py", line 769, in gevent._gevent_cgreenlet.Greenlet.get
File "src\gevent\greenlet.py", line 364, in gevent._gevent_cgreenlet.Greenlet._raise_exception
File "gevent_compat.py", line 65, in reraise
raise value.with_traceback(tb)
File "src\gevent\greenlet.py", line 854, in gevent._gevent_cgreenlet.Greenlet.run
File "happypanda\core\db.py", line 4210, in wrapper
File "happypanda\core\command.py", line 105, in _run
File "happypanda\core\command.py", line 357, in _main_wrap
File "happypanda\core\commands\database_cmd.py", line 1499, in main
File "happypanda\core\async_utils.py", line 347, in get
File "src\gevent\greenlet.py", line 795, in gevent._gevent_cgreenlet.Greenlet.get
File "src\gevent\greenlet.py", line 364, in gevent._gevent_cgreenlet.Greenlet._raise_exception
File "gevent_compat.py", line 65, in reraise
raise value.with_traceback(tb)
File "src\gevent\greenlet.py", line 854, in gevent._gevent_cgreenlet.Greenlet.run
File "gevent\pool.py", line 90, in apply_cb
result = self.apply(func, args, kwds)
File "gevent\pool.py", line 161, in apply
return self.spawn(func, *args, **kwds).get()
File "src\gevent\event.py", line 305, in gevent._gevent_cevent.AsyncResult.get
File "src\gevent\event.py", line 335, in gevent._gevent_cevent.AsyncResult.get
File "src\gevent\event.py", line 323, in gevent._gevent_cevent.AsyncResult.get
File "src\gevent\event.py", line 303, in gevent._gevent_cevent.AsyncResult._raise_exception
File "gevent_compat.py", line 65, in reraise
raise value.with_traceback(tb)
File "gevent\threadpool.py", line 142, in __run_task
thread_result.set(func(*args, **kwargs))
File "happypanda\core\async_utils.py", line 453, in wrapper
File "happypanda\core\async_utils.py", line 435, in cleanup_wrapper
File "happypanda\core\commands\database_cmd.py", line 1483, in _del_from_db
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 419, in execute
File "sqlalchemy\orm\unitofwork.py", line 521, in execute_aggregate
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 245, in save_obj
File "sqlalchemy\orm\persistence.py", line 1136, in _emit_insert_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: gallery_userdata.user_id, gallery_userdata.parent_id
[SQL: INSERT INTO gallery_userdata (times_read, rating, timestamp, _properties, last_updated, user_id, parent_id) VALUES (?, ?, ?, ?, ?, ?, ?)]
[parameters: (0, 0.0, '2022-03-28 20:07:05.201700', '{}', '2022-03-28 20:07:05.201700', 1, 25)]
(Background on this error at: http://sqlalche.me/e/13/gkpj)
Mar-03 22:07:25--ERROR [command].happypanda.core.services: Task _DBIndexer(119) in service indexer_task finished with an exception
Traceback (most recent call last):
File "happypanda\core\services.py", line 922, in _command_wrapper
File "happypanda\core\db.py", line 4210, in wrapper
File "happypanda\core\command.py", line 357, in _main_wrap
File "happypanda\core\commands\search_cmd.py", line 2048, in main
File "happypanda\core\commands\search_cmd.py", line 2037, in _delete_db_items
NotImplementedError
Mar-03 22:11:45--WARNING [server].happypanda.core.server: Error on func 'get_item': DatabaseItemNotFoundError("'Grouping' with id '17' was not found")
Mar-03 22:11:51--WARNING [server].happypanda.core.server: Error on func 'get_item': DatabaseItemNotFoundError("'Grouping' with id '17' was not found")
Mar-03 22:12:07--WARNING [server].happypanda.core.server: Error on func 'get_item': DatabaseItemNotFoundError("'Grouping' with id '17' was not found")
Mar-03 22:12:07--WARNING [server].happypanda.core.server: Error on func 'get_item': DatabaseItemNotFoundError("'Grouping' with id '17' was not found")
Mar-03 22:12:22--WARNING [server].happypanda.core.server: Error on func 'get_item': DatabaseItemNotFoundError("'Grouping' with id '17' was not found")
Mar-03 22:15:48--WARNING [server].happypanda.core.server: Error on func 'get_item': DatabaseItemNotFoundError("'Grouping' with id '12' was not found")
Mar-03 22:15:48--WARNING [server].happypanda.core.server: Error on func 'get_item': DatabaseItemNotFoundError("'Grouping' with id '12' was not found")
Mar-03 22:28:10--WARNING [server].happypanda.core.server: Error on func 'get_item': DatabaseItemNotFoundError("'Grouping' with id '16' was not found")
Mar-03 22:28:30--ERROR [command].happypanda.core.services: Task _DBIndexer(119) in service indexer_task finished with an exception
Traceback (most recent call last):
File "happypanda\core\services.py", line 922, in _command_wrapper
File "happypanda\core\db.py", line 4210, in wrapper
File "happypanda\core\command.py", line 357, in _main_wrap
File "happypanda\core\commands\search_cmd.py", line 2048, in main
File "happypanda\core\commands\search_cmd.py", line 2037, in _delete_db_items
NotImplementedError
Mar-03 22:31:01--ERROR [command].happypanda.core.services: Task _DBIndexer(119) in service indexer_task finished with an exception
Traceback (most recent call last):
File "happypanda\core\services.py", line 922, in _command_wrapper
File "happypanda\core\db.py", line 4210, in wrapper
File "happypanda\core\command.py", line 357, in _main_wrap
File "happypanda\core\commands\search_cmd.py", line 2048, in main
File "happypanda\core\commands\search_cmd.py", line 2037, in _delete_db_items
NotImplementedError
Mar-03 22:35:08--ERROR [server].happypanda.core.server: A database error occured
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\server.py", line 613, in advance
File "happypanda\core\server.py", line 473, in parse
File "happypanda\core\server.py", line 435, in handshake
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 245, in save_obj
File "sqlalchemy\orm\persistence.py", line 1136, in _emit_insert_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO event (_properties, item_id, by_table, timestamp, action, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)]
[parameters: ('{}', None, 'event', '2022-03-28 20:34:38.210281', 'client_connect', '{"name": "webclient", "ip": "10.5.0.2", "port": 60904}', 2)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 22:37:26--ERROR [server].happypanda.core.server: A database error occured
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\server.py", line 624, in advance
File "<C:\Users\shan_\AppData\Local\HappyPanda X\decorator.pyc:decorator-gen-25>", line 2, in call_functions
File "happypanda\common\utils.py", line 1217, in only_cache_if
File "happypanda\core\server.py", line 583, in call_functions
File "src\gevent\greenlet.py", line 769, in gevent._gevent_cgreenlet.Greenlet.get
File "src\gevent\greenlet.py", line 364, in gevent._gevent_cgreenlet.Greenlet._raise_exception
File "gevent_compat.py", line 65, in reraise
raise value.with_traceback(tb)
File "src\gevent\greenlet.py", line 854, in gevent._gevent_cgreenlet.Greenlet.run
File "happypanda\core\db.py", line 4197, in wrapper
File "happypanda\core\db.py", line 4321, in w
File "happypanda\interface\database.py", line 598, in update_metatags
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 236, in save_obj
File "sqlalchemy\orm\persistence.py", line 995, in _emit_update_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: UPDATE gallery SET last_updated=? WHERE gallery.id = ?]
[parameters: ('2022-03-28 20:36:55.943769', 13)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 22:37:56--ERROR [server].happypanda.core.server: A database error occured
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\server.py", line 624, in advance
File "<C:\Users\shan_\AppData\Local\HappyPanda X\decorator.pyc:decorator-gen-25>", line 2, in call_functions
File "happypanda\common\utils.py", line 1217, in only_cache_if
File "happypanda\core\server.py", line 583, in call_functions
File "src\gevent\greenlet.py", line 769, in gevent._gevent_cgreenlet.Greenlet.get
File "src\gevent\greenlet.py", line 364, in gevent._gevent_cgreenlet.Greenlet._raise_exception
File "gevent_compat.py", line 65, in reraise
raise value.with_traceback(tb)
File "src\gevent\greenlet.py", line 854, in gevent._gevent_cgreenlet.Greenlet.run
File "happypanda\core\db.py", line 4197, in wrapper
File "happypanda\core\db.py", line 4321, in w
File "happypanda\interface\database.py", line 598, in update_metatags
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 236, in save_obj
File "sqlalchemy\orm\persistence.py", line 995, in _emit_update_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: UPDATE gallery SET last_updated=? WHERE gallery.id = ?]
[parameters: ('2022-03-28 20:37:26.183925', 12)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 23:31:57--ERROR [server].happypanda.core.server: A database error occured
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\server.py", line 613, in advance
File "happypanda\core\server.py", line 473, in parse
File "happypanda\core\server.py", line 435, in handshake
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 245, in save_obj
File "sqlalchemy\orm\persistence.py", line 1136, in _emit_insert_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO event (_properties, item_id, by_table, timestamp, action, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)]
[parameters: ('{}', None, 'event', '2022-03-28 21:31:27.195602', 'client_connect', '{"name": "webclient", "ip": "10.5.0.2", "port": 50095}', 2)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 23:48:26--ERROR [command].happypanda.core.commands.database_cmd: An error occurred when adding item
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\commands\database_cmd.py", line 1219, in _add_to_db
File "happypanda\core\commands\database_cmd.py", line 1170, in _add_item
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 245, in save_obj
File "sqlalchemy\orm\persistence.py", line 1136, in _emit_insert_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO grouping (_properties, name, status_id, timestamp, user_id) VALUES (?, ?, ?, ?, ?)]
[parameters: ('{}', 'MMMMM (14276682)', None, '2022-03-28 21:47:38.543145', 2)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 23:48:56--ERROR [command].happypanda.core.commands.database_cmd: An error occurred when adding item
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\commands\database_cmd.py", line 1219, in _add_to_db
File "happypanda\core\commands\database_cmd.py", line 1170, in _add_item
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 245, in save_obj
File "sqlalchemy\orm\persistence.py", line 1136, in _emit_insert_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO taggable (timestamp, _properties, last_updated, user_id) VALUES (?, ?, ?, ?)]
[parameters: ('2022-03-28 21:47:39.591635', '{}', '2022-03-28 21:47:39.591635', 2)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 23:49:27--ERROR [command].happypanda.core.commands.database_cmd: An error occurred when adding item
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\commands\database_cmd.py", line 1219, in _add_to_db
File "happypanda\core\commands\database_cmd.py", line 1170, in _add_item
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 245, in save_obj
File "sqlalchemy\orm\persistence.py", line 1136, in _emit_insert_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO grouping (_properties, name, status_id, timestamp, user_id) VALUES (?, ?, ?, ?, ?)]
[parameters: ('{}', 'Fanbox-Hero Neisan', None, '2022-03-28 21:47:37.880946', 2)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 23:49:27--WARNING [command].happypanda.core.commands.database_cmd: Item adding was completed with errors:
Mar-03 23:49:27--ERROR [command].happypanda.core.commands.database_cmd: [

'Traceback (most recent call last):\n',

'  File "sqlalchemy\\engine\\base.py", line 1277, in _execute_context\n',

'  File "sqlalchemy\\engine\\default.py", line 593, in do_execute\n',

'sqlite3.OperationalError: database is locked\n',

'\nThe above exception was the direct cause of the following exception:\n\n',

'Traceback (most recent call last):\n',

'  File "happypanda\\core\\commands\\database_cmd.py", line 1219, in _add_to_db\n',

'  File "happypanda\\core\\commands\\database_cmd.py", line 1170, in _add_item\n',

'  File "sqlalchemy\\orm\\session.py", line 1042, in commit\n',

'  File "sqlalchemy\\orm\\session.py", line 504, in commit\n',

'  File "sqlalchemy\\orm\\session.py", line 483, in _prepare_impl\n',

'  File "sqlalchemy\\orm\\session.py", line 2523, in flush\n',

'  File "sqlalchemy\\orm\\session.py", line 2664, in _flush\n',

'  File "sqlalchemy\\util\\langhelpers.py", line 69, in __exit__\n',

'  File "sqlalchemy\\util\\compat.py", line 182, in raise_\n',

'  File "sqlalchemy\\orm\\session.py", line 2624, in _flush\n',

'  File "sqlalchemy\\orm\\unitofwork.py", line 422, in execute\n',

'  File "sqlalchemy\\orm\\unitofwork.py", line 589, in execute\n',

'  File "sqlalchemy\\orm\\persistence.py", line 245, in save_obj\n',

'  File "sqlalchemy\\orm\\persistence.py", line 1136, in _emit_insert_statements\n',

'  File "sqlalchemy\\engine\\base.py", line 1011, in execute\n',

'  File "sqlalchemy\\sql\\elements.py", line 298, in _execute_on_connection\n',

'  File "sqlalchemy\\engine\\base.py", line 1130, in _execute_clauseelement\n',

'  File "sqlalchemy\\engine\\base.py", line 1317, in _execute_context\n',

'  File "sqlalchemy\\engine\\base.py", line 1511, in _handle_dbapi_exception\n',

'  File "sqlalchemy\\util\\compat.py", line 182, in raise_\n',

'  File "sqlalchemy\\engine\\base.py", line 1277, in _execute_context\n',

'  File "sqlalchemy\\engine\\default.py", line 593, in do_execute\n',

"sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked\n[SQL: INSERT INTO grouping (_properties, name, status_id, timestamp, user_id) VALUES (?, ?, ?, ?, ?)]\n[parameters: ('{}', 'MMMMM (14276682)', None, '2022-03-28 21:47:38.543145', 2)]\n(Background on this error at: http://sqlalche.me/e/13/e3q8)\n",

]
Mar-03 23:49:27--WARNING [command].happypanda.core.commands.database_cmd: Item import failed from('D:\wiiugames\DATA\EMULATORS\Cemu\BIN\BOTW_EN\HentaiEra\[PIXIV] MMMMM (14276682) [HENTAIERA.COM]',):
(sqlite3.OperationalError) database is locked
[SQL: INSERT INTO grouping (_properties, name, status_id, timestamp, user_id) VALUES (?, ?, ?, ?, ?)]
[parameters: ('{}', 'MMMMM (14276682)', None, '2022-03-28 21:47:38.543145', 2)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 23:49:27--ERROR [command].happypanda.core.commands.database_cmd: [

'Traceback (most recent call last):\n',

'  File "sqlalchemy\\engine\\base.py", line 1277, in _execute_context\n',

'  File "sqlalchemy\\engine\\default.py", line 593, in do_execute\n',

'sqlite3.OperationalError: database is locked\n',

'\nThe above exception was the direct cause of the following exception:\n\n',

'Traceback (most recent call last):\n',

'  File "happypanda\\core\\commands\\database_cmd.py", line 1219, in _add_to_db\n',

'  File "happypanda\\core\\commands\\database_cmd.py", line 1170, in _add_item\n',

'  File "sqlalchemy\\orm\\session.py", line 1042, in commit\n',

'  File "sqlalchemy\\orm\\session.py", line 504, in commit\n',

'  File "sqlalchemy\\orm\\session.py", line 483, in _prepare_impl\n',

'  File "sqlalchemy\\orm\\session.py", line 2523, in flush\n',

'  File "sqlalchemy\\orm\\session.py", line 2664, in _flush\n',

'  File "sqlalchemy\\util\\langhelpers.py", line 69, in __exit__\n',

'  File "sqlalchemy\\util\\compat.py", line 182, in raise_\n',

'  File "sqlalchemy\\orm\\session.py", line 2624, in _flush\n',

'  File "sqlalchemy\\orm\\unitofwork.py", line 422, in execute\n',

'  File "sqlalchemy\\orm\\unitofwork.py", line 589, in execute\n',

'  File "sqlalchemy\\orm\\persistence.py", line 245, in save_obj\n',

'  File "sqlalchemy\\orm\\persistence.py", line 1136, in _emit_insert_statements\n',

'  File "sqlalchemy\\engine\\base.py", line 1011, in execute\n',

'  File "sqlalchemy\\sql\\elements.py", line 298, in _execute_on_connection\n',

'  File "sqlalchemy\\engine\\base.py", line 1130, in _execute_clauseelement\n',

'  File "sqlalchemy\\engine\\base.py", line 1317, in _execute_context\n',

'  File "sqlalchemy\\engine\\base.py", line 1511, in _handle_dbapi_exception\n',

'  File "sqlalchemy\\util\\compat.py", line 182, in raise_\n',

'  File "sqlalchemy\\engine\\base.py", line 1277, in _execute_context\n',

'  File "sqlalchemy\\engine\\default.py", line 593, in do_execute\n',

"sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked\n[SQL: INSERT INTO taggable (timestamp, _properties, last_updated, user_id) VALUES (?, ?, ?, ?)]\n[parameters: ('2022-03-28 21:47:39.591635', '{}', '2022-03-28 21:47:39.591635', 2)]\n(Background on this error at: http://sqlalche.me/e/13/e3q8)\n",

]
Mar-03 23:49:27--WARNING [command].happypanda.core.commands.database_cmd: Item import failed from('D:\wiiugames\DATA\EMULATORS\Cemu\BIN\BOTW_EN\HentaiEra\[Ponkotsu] Kiriyama Saori Sensei (2022-01-15) [HENTAIERA.COM]',):
(sqlite3.OperationalError) database is locked
[SQL: INSERT INTO taggable (timestamp, _properties, last_updated, user_id) VALUES (?, ?, ?, ?)]
[parameters: ('2022-03-28 21:47:39.591635', '{}', '2022-03-28 21:47:39.591635', 2)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 23:49:27--ERROR [command].happypanda.core.commands.database_cmd: [

'Traceback (most recent call last):\n',

'  File "sqlalchemy\\engine\\base.py", line 1277, in _execute_context\n',

'  File "sqlalchemy\\engine\\default.py", line 593, in do_execute\n',

'sqlite3.OperationalError: database is locked\n',

'\nThe above exception was the direct cause of the following exception:\n\n',

'Traceback (most recent call last):\n',

'  File "happypanda\\core\\commands\\database_cmd.py", line 1219, in _add_to_db\n',

'  File "happypanda\\core\\commands\\database_cmd.py", line 1170, in _add_item\n',

'  File "sqlalchemy\\orm\\session.py", line 1042, in commit\n',

'  File "sqlalchemy\\orm\\session.py", line 504, in commit\n',

'  File "sqlalchemy\\orm\\session.py", line 483, in _prepare_impl\n',

'  File "sqlalchemy\\orm\\session.py", line 2523, in flush\n',

'  File "sqlalchemy\\orm\\session.py", line 2664, in _flush\n',

'  File "sqlalchemy\\util\\langhelpers.py", line 69, in __exit__\n',

'  File "sqlalchemy\\util\\compat.py", line 182, in raise_\n',

'  File "sqlalchemy\\orm\\session.py", line 2624, in _flush\n',

'  File "sqlalchemy\\orm\\unitofwork.py", line 422, in execute\n',

'  File "sqlalchemy\\orm\\unitofwork.py", line 589, in execute\n',

'  File "sqlalchemy\\orm\\persistence.py", line 245, in save_obj\n',

'  File "sqlalchemy\\orm\\persistence.py", line 1136, in _emit_insert_statements\n',

'  File "sqlalchemy\\engine\\base.py", line 1011, in execute\n',

'  File "sqlalchemy\\sql\\elements.py", line 298, in _execute_on_connection\n',

'  File "sqlalchemy\\engine\\base.py", line 1130, in _execute_clauseelement\n',

'  File "sqlalchemy\\engine\\base.py", line 1317, in _execute_context\n',

'  File "sqlalchemy\\engine\\base.py", line 1511, in _handle_dbapi_exception\n',

'  File "sqlalchemy\\util\\compat.py", line 182, in raise_\n',

'  File "sqlalchemy\\engine\\base.py", line 1277, in _execute_context\n',

'  File "sqlalchemy\\engine\\default.py", line 593, in do_execute\n',

"sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked\n[SQL: INSERT INTO grouping (_properties, name, status_id, timestamp, user_id) VALUES (?, ?, ?, ?, ?)]\n[parameters: ('{}', 'Fanbox-Hero Neisan', None, '2022-03-28 21:47:37.880946', 2)]\n(Background on this error at: http://sqlalche.me/e/13/e3q8)\n",

]
Mar-03 23:49:27--WARNING [command].happypanda.core.commands.database_cmd: Item import failed from('D:\wiiugames\DATA\EMULATORS\Cemu\BIN\BOTW_EN\HentaiEra\Fanbox-Hero Neisan [HENTAIERA.COM]',):
(sqlite3.OperationalError) database is locked
[SQL: INSERT INTO grouping (_properties, name, status_id, timestamp, user_id) VALUES (?, ?, ?, ?, ?)]
[parameters: ('{}', 'Fanbox-Hero Neisan', None, '2022-03-28 21:47:37.880946', 2)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 23:55:48--ERROR [database].happypanda.core.db: Exception raised in non-scoped db session
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\db.py", line 4171, in safe_session
File "happypanda\core\commands\database_cmd.py", line 1405, in _update
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 236, in save_obj
File "sqlalchemy\orm\persistence.py", line 995, in _emit_update_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: UPDATE gallery_userdata SET last_updated=? WHERE gallery_userdata.id = ?]
[parameters: ('2022-03-28 21:55:17.833912', 17)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 23:55:48--ERROR [server].happypanda.core.server: A database error occured
Traceback (most recent call last):
File "happypanda\core\server.py", line 624, in advance
File "<C:\Users\shan
\AppData\Local\HappyPanda X\decorator.pyc:decorator-gen-25>", line 2, in call_functions
File "happypanda\common\utils.py", line 1217, in only_cache_if
File "happypanda\core\server.py", line 583, in call_functions
File "src\gevent\greenlet.py", line 769, in gevent._gevent_cgreenlet.Greenlet.get
File "src\gevent\greenlet.py", line 364, in gevent._gevent_cgreenlet.Greenlet._raise_exception
File "gevent_compat.py", line 65, in reraise
raise value.with_traceback(tb)
File "src\gevent\greenlet.py", line 854, in gevent._gevent_cgreenlet.Greenlet.run
File "happypanda\core\db.py", line 4197, in wrapper
File "happypanda\core\db.py", line 4321, in w
File "happypanda\interface\database.py", line 223, in update_item
File "happypanda\core\command.py", line 357, in _main_wrap
File "happypanda\core\commands\database_cmd.py", line 1421, in main
File "happypanda\core\command.py", line 769, in emit
File "happypanda\core\commands\database_cmd.py", line 1429, in _index_items
File "happypanda\core\db_esearch.py", line 712, in make_indexdata
File "sqlalchemy\orm\attributes.py", line 287, in get
File "sqlalchemy\orm\attributes.py", line 718, in get
File "sqlalchemy\orm\state.py", line 652, in _load_expired
File "sqlalchemy\orm\loading.py", line 1012, in load_scalar_attributes
File "sqlalchemy\orm\loading.py", line 206, in load_on_ident
File "sqlalchemy\orm\loading.py", line 286, in load_on_pk_identity
File "sqlalchemy\orm\query.py", line 3463, in one
File "sqlalchemy\orm\query.py", line 3432, in one_or_none
File "sqlalchemy\orm\query.py", line 3508, in iter
File "sqlalchemy\orm\query.py", line 3530, in _execute_and_instances
File "sqlalchemy\orm\query.py", line 3545, in _get_bind_args
File "sqlalchemy\orm\query.py", line 3523, in _connection_from_session
File "sqlalchemy\orm\session.py", line 1141, in connection
File "sqlalchemy\orm\session.py", line 1147, in _connection_for_bind
File "sqlalchemy\orm\session.py", line 409, in _connection_for_bind
File "sqlalchemy\orm\session.py", line 296, in _assert_active
sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.OperationalError) database is locked
[SQL: UPDATE gallery_userdata SET last_updated=? WHERE gallery_userdata.id = ?]
[parameters: ('2022-03-28 21:55:17.833912', 17)]
(Background on this error at: http://sqlalche.me/e/13/e3q8) (Background on this error at: http://sqlalche.me/e/13/7s2a)
Mar-03 23:57:31--ERROR [server].happypanda.core.server: A database error occured
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\server.py", line 624, in advance
File "<C:\Users\shan_\AppData\Local\HappyPanda X\decorator.pyc:decorator-gen-25>", line 2, in call_functions
File "happypanda\common\utils.py", line 1217, in only_cache_if
File "happypanda\core\server.py", line 583, in call_functions
File "src\gevent\greenlet.py", line 769, in gevent._gevent_cgreenlet.Greenlet.get
File "src\gevent\greenlet.py", line 364, in gevent._gevent_cgreenlet.Greenlet._raise_exception
File "gevent_compat.py", line 65, in reraise
raise value.with_traceback(tb)
File "src\gevent\greenlet.py", line 854, in gevent._gevent_cgreenlet.Greenlet.run
File "happypanda\core\db.py", line 4197, in wrapper
File "happypanda\interface\events.py", line 99, in page_read_event
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 236, in save_obj
File "sqlalchemy\orm\persistence.py", line 995, in _emit_update_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: UPDATE gallery_progress SET last_updated=? WHERE gallery_progress.id = ?]
[parameters: ('2022-03-28 21:57:00.804048', 1)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 00:01:10--ERROR [command].happypanda.core.services: Task _DBIndexer(119) in service indexer_task finished with an exception
Traceback (most recent call last):
File "happypanda\core\services.py", line 922, in _command_wrapper
File "happypanda\core\db.py", line 4210, in wrapper
File "happypanda\core\command.py", line 357, in _main_wrap
File "happypanda\core\commands\search_cmd.py", line 2048, in main
File "happypanda\core\commands\search_cmd.py", line 2037, in _delete_db_items
NotImplementedError
Mar-03 00:01:38--ERROR [server].happypanda.core.server: A database error occured
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\server.py", line 624, in advance
File "<C:\Users\shan_\AppData\Local\HappyPanda X\decorator.pyc:decorator-gen-25>", line 2, in call_functions
File "happypanda\common\utils.py", line 1217, in only_cache_if
File "happypanda\core\server.py", line 583, in call_functions
File "src\gevent\greenlet.py", line 769, in gevent._gevent_cgreenlet.Greenlet.get
File "src\gevent\greenlet.py", line 364, in gevent._gevent_cgreenlet.Greenlet._raise_exception
File "gevent_compat.py", line 65, in reraise
raise value.with_traceback(tb)
File "src\gevent\greenlet.py", line 854, in gevent._gevent_cgreenlet.Greenlet.run
File "happypanda\core\db.py", line 4197, in wrapper
File "happypanda\interface\events.py", line 99, in page_read_event
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 245, in save_obj
File "sqlalchemy\orm\persistence.py", line 1136, in _emit_insert_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO gallery_progress (timestamp, _properties, last_updated, user_id, gallery_id, page_id) VALUES (?, ?, ?, ?, ?, ?)]
[parameters: ('2022-03-28 22:01:08.343073', '{}', '2022-03-28 22:01:08.343073', 2, 23, 845)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 00:02:08--ERROR [server].happypanda.core.server: A database error occured
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\server.py", line 624, in advance
File "<C:\Users\shan_\AppData\Local\HappyPanda X\decorator.pyc:decorator-gen-25>", line 2, in call_functions
File "happypanda\common\utils.py", line 1217, in only_cache_if
File "happypanda\core\server.py", line 583, in call_functions
File "src\gevent\greenlet.py", line 769, in gevent._gevent_cgreenlet.Greenlet.get
File "src\gevent\greenlet.py", line 364, in gevent._gevent_cgreenlet.Greenlet._raise_exception
File "gevent_compat.py", line 65, in reraise
raise value.with_traceback(tb)
File "src\gevent\greenlet.py", line 854, in gevent._gevent_cgreenlet.Greenlet.run
File "happypanda\core\db.py", line 4197, in wrapper
File "happypanda\interface\events.py", line 99, in page_read_event
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 245, in save_obj
File "sqlalchemy\orm\persistence.py", line 1136, in _emit_insert_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO gallery_progress (timestamp, _properties, last_updated, user_id, gallery_id, page_id) VALUES (?, ?, ?, ?, ?, ?)]
[parameters: ('2022-03-28 22:01:38.639578', '{}', '2022-03-28 22:01:38.639578', 2, 23, 847)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Mar-03 00:02:40--ERROR [server].happypanda.core.server: A database error occured
Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "happypanda\core\server.py", line 624, in advance
File "<C:\Users\shan_\AppData\Local\HappyPanda X\decorator.pyc:decorator-gen-25>", line 2, in call_functions
File "happypanda\common\utils.py", line 1217, in only_cache_if
File "happypanda\core\server.py", line 583, in call_functions
File "src\gevent\greenlet.py", line 769, in gevent._gevent_cgreenlet.Greenlet.get
File "src\gevent\greenlet.py", line 364, in gevent._gevent_cgreenlet.Greenlet._raise_exception
File "gevent_compat.py", line 65, in reraise
raise value.with_traceback(tb)
File "src\gevent\greenlet.py", line 854, in gevent._gevent_cgreenlet.Greenlet.run
File "happypanda\core\db.py", line 4197, in wrapper
File "happypanda\interface\events.py", line 99, in page_read_event
File "sqlalchemy\orm\session.py", line 1042, in commit
File "sqlalchemy\orm\session.py", line 504, in commit
File "sqlalchemy\orm\session.py", line 483, in _prepare_impl
File "sqlalchemy\orm\session.py", line 2523, in flush
File "sqlalchemy\orm\session.py", line 2664, in flush
File "sqlalchemy\util\langhelpers.py", line 69, in exit
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\orm\session.py", line 2624, in _flush
File "sqlalchemy\orm\unitofwork.py", line 422, in execute
File "sqlalchemy\orm\unitofwork.py", line 589, in execute
File "sqlalchemy\orm\persistence.py", line 245, in save_obj
File "sqlalchemy\orm\persistence.py", line 1136, in _emit_insert_statements
File "sqlalchemy\engine\base.py", line 1011, in execute
File "sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1317, in _execute_context
File "sqlalchemy\engine\base.py", line 1511, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 182, in raise

File "sqlalchemy\engine\base.py", line 1277, in _execute_context
File "sqlalchemy\engine\default.py", line 593, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO gallery_progress (timestamp, _properties, last_updated, user_id, gallery_id, page_id) VALUES (?, ?, ?, ?, ?, ?)]
[parameters: ('2022-03-28 22:02:10.639658', '{}', '2022-03-28 22:02:10.639658', 2, 23, 847)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)

Screenshots
image

Environment:

  • OS: Windows
  • Browser and browser version Chrome
  • HPX Version 0.13.3

Additional context
Add any other context about the problem

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant