We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
I occasionally see these when loading data
Exception in thread Thread-2: Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1224, in _execute_context cursor, statement, parameters, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 752, in do_executemany cursor.executemany(statement, parameters) psycopg2.errors.SerializationFailure: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_CLIENT_REJECT): "sql txn" id=7f9beccd key=/Table/55/1/"chicago"/"\xee\"`y\v=D\x10\xa8u\x1d\x055YL\xe5"/0 rw=true pri=0.00809371 stat=ABORTED epo=0 ts=1555185981.751461551,1 orig=1555185981.183401182,0 max=1555185981.683401182,0 wto=false seq=52 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2874, in _bulk_save_mappings render_nulls, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 102, in _bulk_insert bookkeeping=return_defaults, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 1066, in _emit_insert_statements c = cached_connections[connection].execute(statement, multiparams) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute return meth(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement distilled_params, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context e, statement, parameters, cursor, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception util.raise_from_cause(sqlalchemy_exception, exc_info) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 128, in reraise raise value.with_traceback(tb) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1224, in _execute_context cursor, statement, parameters, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 752, in do_executemany cursor.executemany(statement, parameters) sqlalchemy.exc.OperationalError: (psycopg2.errors.SerializationFailure) restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_CLIENT_REJECT): "sql txn" id=7f9beccd key=/Table/55/1/"chicago"/"\xee\"`y\v=D\x10\xa8u\x1d\x055YL\xe5"/0 rw=true pri=0.00809371 stat=ABORTED epo=0 ts=1555185981.751461551,1 orig=1555185981.183401182,0 max=1555185981.683401182,0 wto=false seq=52 [SQL: INSERT INTO vehicles (id, city, type, owner_id, creation_time, status, current_location, ext) VALUES (%(id)s, %(city)s, %(type)s, %(owner_id)s, %(creation_time)s, %(status)s, %(current_location)s, %(ext)s)] [parameters: ({'id': UUID('ee226079-0b3d-4410-a875-1d0535594ce5'), 'city': 'chicago', 'type': 'scooter', 'owner_id': UUID('a6beebe7-278f-4e14-aeb7-9972403769c2'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 214896), 'status': 'in_use', 'current_location': '6535 Hall Harbor\nZunigaborough, AR 96732', 'ext': '{"color": "blue"}'}, {'id': UUID('df4858a2-ee55-4dc2-b92c-0425e8dab131'), 'city': 'chicago', 'type': 'scooter', 'owner_id': UUID('2f804081-9942-4ec6-88c6-e6db50c764c4'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 214911), 'status': 'lost', 'current_location': '0287 Lisa Square Suite 036\nPort Joshuahaven, AK 29649', 'ext': '{"color": "red"}'}, {'id': UUID('9b1c30cf-7072-4669-baed-175981fd96ac'), 'city': 'chicago', 'type': 'scooter', 'owner_id': UUID('f31cf09b-e542-4075-90d8-c90ef40a3eb4'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 214914), 'status': 'in_use', 'current_location': '7188 Kylie Lodge\nAdamland, NY 22502', 'ext': '{"color": "blue"}'}, {'id': UUID('984ca012-2454-402a-af22-93a73ef94408'), 'city': 'chicago', 'type': 'skateboard', 'owner_id': UUID('b1995a9a-6817-4222-954a-a541c727450f'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 214917), 'status': 'in_use', 'current_location': '59173 Perry Radial\nNorth Alyssahaven, MN 23131', 'ext': '{"color": "green"}'}, {'id': UUID('db2681e3-92b5-4fb1-8986-89218058f120'), 'city': 'chicago', 'type': 'bike', 'owner_id': UUID('fde9ed2a-d091-4446-a127-064e55403b2f'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 214920), 'status': 'in_use', 'current_location': '99922 Ryan Courts\nSouth Adam, NV 17235', 'ext': '{"color": "red", "brand": "Santa Cruz"}'}, {'id': UUID('0db83874-a2de-4c06-b3e0-2215d094025c'), 'city': 'chicago', 'type': 'scooter', 'owner_id': UUID('fa41a8e0-bd1d-4291-b583-2856d188e2ba'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 214923), 'status': 'in_use', 'current_location': '720 Hutchinson Islands\nMichaelside, LA 27909', 'ext': '{"color": "green"}'}, {'id': UUID('0fbef233-780a-4b21-92a1-12ef1d031ad7'), 'city': 'chicago', 'type': 'bike', 'owner_id': UUID('d9853d5a-af28-4b06-8e37-a8c6d5470998'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 214926), 'status': 'in_use', 'current_location': '7414 Ryan Pass Apt. 707\nSouth Sabrina, AZ 95146', 'ext': '{"color": "blue", "brand": "Schwinn"}'}, {'id': UUID('3ca85c44-635b-4eae-8305-5c9a4f9a538a'), 'city': 'chicago', 'type': 'scooter', 'owner_id': UUID('77346888-c7d6-43f1-a945-819f7d744f43'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 214929), 'status': 'in_use', 'current_location': '32529 Rebekah Isle\nNew Alexandramouth, NC 12537', 'ext': '{"color": "green"}'} ... displaying 10 of 34 total bound parameter sets ... {'id': UUID('ffb32ce7-d022-41d5-a092-fcfaabac3654'), 'city': 'chicago', 'type': 'bike', 'owner_id': UUID('1dd31627-7da5-445a-bbea-02046521ba79'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 215004), 'status': 'available', 'current_location': '2864 Dylan Cove\nSouth Stephaniemouth, GA 99430', 'ext': '{"color": "black", "brand": "Schwinn"}'}, {'id': UUID('cb6abda5-0eec-4ae2-b2ff-221d2e12c428'), 'city': 'chicago', 'type': 'skateboard', 'owner_id': UUID('aff971b2-d3c0-480e-95d6-25a3cc825afd'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 215006), 'status': 'in_use', 'current_location': '4520 Jones Summit\nPhillipsmouth, NC 08981', 'ext': '{"color": "green"}'})] (Background on this error at: http://sqlalche.me/e/e3q8) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context cursor, statement, parameters, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute cursor.execute(statement, parameters) psycopg2.errors.InvalidSavepointSpecification: SAVEPOINT "cockroach_restart" is in use The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/local/lib/python3.7/threading.py", line 917, in _bootstrap_inner self.run() File "/usr/local/lib/python3.7/threading.py", line 865, in run self._target(*self._args, **self._kwargs) File "./loadmovr.py", line 71, in load_movr_data add_vehicles(engine, num_vehicles, city) File "./loadmovr.py", line 395, in add_vehicles lambda s: add_vehicles_helper(s, chunk, min(chunk + chunk_size, num_vehicles))) File "/usr/local/lib/python3.7/site-packages/cockroachdb/sqlalchemy/transaction.py", line 31, in run_transaction return _txn_retry_loop(session, callback) File "/usr/local/lib/python3.7/site-packages/cockroachdb/sqlalchemy/transaction.py", line 75, in _txn_retry_loop ret = callback(conn) File "./loadmovr.py", line 395, in <lambda> lambda s: add_vehicles_helper(s, chunk, min(chunk + chunk_size, num_vehicles))) File "./loadmovr.py", line 391, in add_vehicles_helper sess.bulk_save_objects(vehicles) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2692, in bulk_save_objects False, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2880, in _bulk_save_mappings transaction.rollback(_capture_exception=True) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 79, in __exit__ compat.reraise(type_, value, traceback) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 129, in reraise raise value File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2880, in _bulk_save_mappings transaction.rollback(_capture_exception=True) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 563, in rollback util.reraise(*rollback_err) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 129, in reraise raise value File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 523, in rollback t[1].rollback() File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1705, in rollback self._do_rollback() File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1767, in _do_rollback self._savepoint, self._parent File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 792, in _rollback_to_savepoint_impl self.engine.dialect.do_rollback_to_savepoint(self, name) File "/usr/local/lib/python3.7/site-packages/cockroachdb/sqlalchemy/dialect.py", line 434, in do_rollback_to_savepoint super(CockroachDBDialect, self).do_rollback_to_savepoint(connection, name) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 543, in do_rollback_to_savepoint connection.execute(expression.RollbackToSavepointClause(name)) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute return meth(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement distilled_params, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context e, statement, parameters, cursor, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception util.raise_from_cause(sqlalchemy_exception, exc_info) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 128, in reraise raise value.with_traceback(tb) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context cursor, statement, parameters, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.InternalError: (psycopg2.errors.InvalidSavepointSpecification) SAVEPOINT "cockroach_restart" is in use [SQL: ROLLBACK TO SAVEPOINT sa_savepoint_1] (Background on this error at: http://sqlalche.me/e/2j85) Exception in thread Thread-3: Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1224, in _execute_context cursor, statement, parameters, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 752, in do_executemany cursor.executemany(statement, parameters) psycopg2.errors.SerializationFailure: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_CLIENT_REJECT): "sql txn" id=69b34082 key=/Table/55/1/"seattle"/"\xff\x0e{\b\xec\x0eI/\x98\x87\xcf\xdb\u007f;\xc9\x12"/0 rw=true pri=0.01686662 stat=ABORTED epo=0 ts=1555185981.751461551,1 orig=1555185981.707290184,0 max=1555185982.207290184,0 wto=false seq=54 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2874, in _bulk_save_mappings render_nulls, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 102, in _bulk_insert bookkeeping=return_defaults, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 1066, in _emit_insert_statements c = cached_connections[connection].execute(statement, multiparams) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute return meth(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement distilled_params, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context e, statement, parameters, cursor, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception util.raise_from_cause(sqlalchemy_exception, exc_info) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 128, in reraise raise value.with_traceback(tb) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1224, in _execute_context cursor, statement, parameters, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 752, in do_executemany cursor.executemany(statement, parameters) sqlalchemy.exc.OperationalError: (psycopg2.errors.SerializationFailure) restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_CLIENT_REJECT): "sql txn" id=69b34082 key=/Table/55/1/"seattle"/"\xff\x0e{\b\xec\x0eI/\x98\x87\xcf\xdb\u007f;\xc9\x12"/0 rw=true pri=0.01686662 stat=ABORTED epo=0 ts=1555185981.751461551,1 orig=1555185981.707290184,0 max=1555185982.207290184,0 wto=false seq=54 [SQL: INSERT INTO vehicles (id, city, type, owner_id, creation_time, status, current_location, ext) VALUES (%(id)s, %(city)s, %(type)s, %(owner_id)s, %(creation_time)s, %(status)s, %(current_location)s, %(ext)s)] [parameters: ({'id': UUID('ff0e7b08-ec0e-492f-9887-cfdb7f3bc912'), 'city': 'seattle', 'type': 'skateboard', 'owner_id': UUID('775db966-2e4f-434e-a240-5973041198d7'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 740361), 'status': 'available', 'current_location': '3499 Stokes Shoals Suite 680\nLake Ethan, SD 26252', 'ext': '{"color": "yellow"}'}, {'id': UUID('53c1347e-0205-47cf-b47c-c14cd189009b'), 'city': 'seattle', 'type': 'skateboard', 'owner_id': UUID('549745e0-495b-4aae-9a34-7ac289b85bf5'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 740378), 'status': 'in_use', 'current_location': '209 Roberts Hills Apt. 278\nDanieltown, NE 81389', 'ext': '{"color": "blue"}'}, {'id': UUID('f4564fe6-f58f-4061-ba19-e04abf7e322e'), 'city': 'seattle', 'type': 'skateboard', 'owner_id': UUID('a35884c5-ddd6-4a1f-b44b-671f94eb7fa9'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 740381), 'status': 'available', 'current_location': '9189 Munoz Gardens\nChristinamouth, DC 02843', 'ext': '{"color": "black"}'}, {'id': UUID('c8ea872f-3c9e-4065-b40e-08ac3865b30c'), 'city': 'seattle', 'type': 'bike', 'owner_id': UUID('19713462-54ec-402f-a2c4-4b3a484d70f6'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 740384), 'status': 'in_use', 'current_location': '3352 Knight Circle\nPerryfurt, CO 40278', 'ext': '{"color": "red", "brand": "Schwinn"}'}, {'id': UUID('ed8738c3-fb75-49a2-840e-07849d9a9393'), 'city': 'seattle', 'type': 'scooter', 'owner_id': UUID('96234286-3671-424a-8f30-902a0df0c446'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 740387), 'status': 'in_use', 'current_location': '7529 Amanda Shoal\nNicholasville, MI 94522', 'ext': '{"color": "yellow"}'}, {'id': UUID('98ac0f85-70e0-4653-9aae-a32d442cc5de'), 'city': 'seattle', 'type': 'scooter', 'owner_id': UUID('cf809bca-4885-45ac-bd7c-f2b29db882fb'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 740390), 'status': 'in_use', 'current_location': '16649 Farrell Ports Suite 145\nNew Jessica, NH 44676', 'ext': '{"color": "green"}'}, {'id': UUID('d451707a-2c57-40bd-a143-92af068d8118'), 'city': 'seattle', 'type': 'scooter', 'owner_id': UUID('2de06db8-71c6-4914-9412-2fed07a0bdcc'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 740393), 'status': 'in_use', 'current_location': '33892 Christopher Drives Suite 226\nSouth Christina, CO 87521', 'ext': '{"color": "red"}'}, {'id': UUID('93c3af20-a86b-4f80-b453-77596d0d7a35'), 'city': 'seattle', 'type': 'bike', 'owner_id': UUID('5c81477a-b4d9-42ce-ad32-3353de651e27'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 740396), 'status': 'available', 'current_location': '8141 Joshua Ferry\nWest Codymouth, NM 83859', 'ext': '{"color": "yellow", "brand": "Schwinn"}'} ... displaying 10 of 34 total bound parameter sets ... {'id': UUID('cdfa6f90-3795-4a70-be14-3dc0a6958f48'), 'city': 'seattle', 'type': 'skateboard', 'owner_id': UUID('af996cf8-9f1a-4800-bf6f-ced0d18a7544'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 740469), 'status': 'in_use', 'current_location': '1686 Michael Center Apt. 391\nSouth Aprilland, PA 72900', 'ext': '{"color": "yellow"}'}, {'id': UUID('2526c271-0d48-4dcc-b5e2-7305146ce662'), 'city': 'seattle', 'type': 'scooter', 'owner_id': UUID('5c75282b-801b-4024-8a6c-fb5ec94e3f7c'), 'creation_time': datetime.datetime(2019, 4, 13, 20, 6, 21, 740472), 'status': 'available', 'current_location': '09422 Robert Stream\nLake Carlos, NH 66260', 'ext': '{"color": "black"}'})] (Background on this error at: http://sqlalche.me/e/e3q8) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context cursor, statement, parameters, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute cursor.execute(statement, parameters) psycopg2.errors.InvalidSavepointSpecification: SAVEPOINT "cockroach_restart" is in use The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/local/lib/python3.7/threading.py", line 917, in _bootstrap_inner self.run() File "/usr/local/lib/python3.7/threading.py", line 865, in run self._target(*self._args, **self._kwargs) File "./loadmovr.py", line 71, in load_movr_data add_vehicles(engine, num_vehicles, city) File "./loadmovr.py", line 395, in add_vehicles lambda s: add_vehicles_helper(s, chunk, min(chunk + chunk_size, num_vehicles))) File "/usr/local/lib/python3.7/site-packages/cockroachdb/sqlalchemy/transaction.py", line 31, in run_transaction return _txn_retry_loop(session, callback) File "/usr/local/lib/python3.7/site-packages/cockroachdb/sqlalchemy/transaction.py", line 75, in _txn_retry_loop ret = callback(conn) File "./loadmovr.py", line 395, in <lambda> lambda s: add_vehicles_helper(s, chunk, min(chunk + chunk_size, num_vehicles))) File "./loadmovr.py", line 391, in add_vehicles_helper sess.bulk_save_objects(vehicles) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2692, in bulk_save_objects False, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2880, in _bulk_save_mappings transaction.rollback(_capture_exception=True) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 79, in __exit__ compat.reraise(type_, value, traceback) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 129, in reraise raise value File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2880, in _bulk_save_mappings transaction.rollback(_capture_exception=True) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 563, in rollback util.reraise(*rollback_err) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 129, in reraise raise value File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 523, in rollback t[1].rollback() File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1705, in rollback self._do_rollback() File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1767, in _do_rollback self._savepoint, self._parent File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 792, in _rollback_to_savepoint_impl self.engine.dialect.do_rollback_to_savepoint(self, name) File "/usr/local/lib/python3.7/site-packages/cockroachdb/sqlalchemy/dialect.py", line 434, in do_rollback_to_savepoint super(CockroachDBDialect, self).do_rollback_to_savepoint(connection, name) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 543, in do_rollback_to_savepoint connection.execute(expression.RollbackToSavepointClause(name)) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute return meth(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement distilled_params, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context e, statement, parameters, cursor, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception util.raise_from_cause(sqlalchemy_exception, exc_info) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 128, in reraise raise value.with_traceback(tb) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context cursor, statement, parameters, context File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.InternalError: (psycopg2.errors.InvalidSavepointSpecification) SAVEPOINT "cockroach_restart" is in use [SQL: ROLLBACK TO SAVEPOINT sa_savepoint_1] (Background on this error at: http://sqlalche.me/e/2j85)
The text was updated successfully, but these errors were encountered:
No branches or pull requests
I occasionally see these when loading data
The text was updated successfully, but these errors were encountered: