cockroachdb / cockroachdb/movr

TransactionAbortedError(ABORT_REASON_CLIENT_REJECT)

Open
#79 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
37
Forks
14
PR merge metrics
No merged PRs in 30d

Description

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 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 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)
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.