Code: Select all
--> -->
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 209, in execute
res = self._query(query)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 315, in _query
db.query(q)
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 226, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1442, "Can't update table 'file' in stored function/trigger because it is already used by statement which invoked this stored function/trigger")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/springfiles/upq/www/upload/index.py", line 100, in <module>
msgs = SaveUploadedFile(form)
File "/home/springfiles/upq/www/upload/index.py", line 78, in SaveUploadedFile
output = ParseAndAddFile(filename, accountid, cfg)
File "/home/springfiles/upq/www/upload/index.py", line 94, in ParseAndAddFile
extract_metadata.Extract_metadata(cfg, db, filename, accountid)
File "/home/springfiles/upq/lib/extract_metadata.py", line 649, in Extract_metadata
return extract_metadata_unitsync(cfg, db, filepath, accountid, tmpdir)
File "/home/springfiles/upq/lib/extract_metadata.py", line 631, in extract_metadata_unitsync
insertData(db, data)
File "/home/springfiles/upq/lib/extract_metadata.py", line 443, in insertData
fid=db.insert("file", {
File "/home/springfiles/upq/lib/upqdb.py", line 150, in insert
s.execute(query)
File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 1295, in execute
return self._connection_for_bind(bind, close_with_result=True).execute(
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
ret = self._execute_context(
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
self._handle_dbapi_exception(
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
util.raise_(
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 209, in execute
res = self._query(query)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 315, in _query
db.query(q)
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 226, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1442, "Can't update table 'file' in stored function/trigger because it is already used by statement which invoked this stored function/trigger")
[SQL: INSERT INTO file (uid, filename, path, size, `status`, timestamp, md5, sha1, sha256, name, version, cid, sdp, metadata) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: (1022905, 'otago_redux_1.0.sd7', 'maps', 78932278, 1, datetime.datetime(2022, 6, 15, 0, 23, 16, 422940), 'a2be9ff27f681685894eb284759851d7', 'ff0f6b32e2122601366db3111ef07de5364b636c', 'ddde39701719052b49376b2811aab58bafac2f0981a7425172117af7e377a55f', 'Otago_Redux 1.0', '', 2, 'e696cf02953fb2d890e5452f2264e5e0', '{"Name": "Otago_Redux 1.0", "Author": "Moose", "Description": "Valleys of dry grasslands and dense forests", "Gravity": 100, "MaxWind": 20, "MinWind" ... (440 characters truncated) ... "mapimages": ["b294ee10764ff0c7518946c4721cb629.jpg", "c26889c756bbff70c5c695d9d3f91a1f.jpg", "a48ac33c0aa255601b55a07cf09f6088.jpg"], "splash": []}')]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
https://cdn.discordapp.com/attachments/ ... hot_61.png
EDIT2: Uploaded the map to ZeroK https://zero-k.info/Maps/Detail/61638