chaoss / chaoss/CollectOSS

Update celery to 5.6.0 to avoid task id none error during exception handling while executing a task chain within a chord

Open
#152 7 comments 0 reactions 0 assignees View on GitHub
bug dependencies deployed version
Dominant language
Python
Stars
13
Forks
17
Avg merge
6h 59m
Merged PRs (30d)
1

Description

> [!NOTE]
> Migrated from [augurlabs/augur#3458](https://github.com/augurlabs/augur/issues/3458)
> Originally opened by `@MoralCode` on 2025-12-11

---

task: augur.tasks.git.facade_tasks.analyze_commits_in_parallel
exception: ValueError('task_id must not be empty. Got None instead.')
repo: https://github.com/frrouting/frr

Stack Trace

```
[...]
[SQL: INSERT INTO augur_data.commits (repo_id, cmt_commit_hash, cmt_author_name, cmt_author_raw_email, cmt_author_email, cmt_author_date, cmt_committer_name, cmt_committer_raw_email, cmt_committer_email, cmt_committer_date, cmt_added, cmt_removed, cmt_whit ... 79829 characters truncated ... s, %(cmt_author_timestamp__154)s, %(tool_source__154)s, %(tool_version__154)s, %(data_source__154)s)]
[parameters: {'cmt_whitespace__0': 0, 'cmt_removed__0': 1, 'cmt_committer_date__0': '2025-11-17', 'cmt_author_raw_email__0': 'chirag@nvidia.com', 'cmt_author_date__0': '2025-11-17', 'cmt_author_timestamp__0': '2025-11-17 10:51:16 -0800', 'data_source__0': 'git', 'cmt_filename__0': 'tests/topotests/bgp_evpn_three_tier_clos_topo1/ipv4/tor-21/frr.conf', 'cmt_author_name__0': '', 'tool_source__0': 'Facade', 'cmt_committer_email__0': 'chiragshah6@gmail.com', 'repo_id__0': 78307, 'cmt_committer_name__0': 'Chirag Shah', 'tool_version__0': '0.80', 'cmt_added__0': 2, 'cmt_committer_raw_email__0': 'chirag@nvidia.com', 'cmt_author_email__0': 'chiragshah6@gmail.com', 'cmt_date_attempted__0': '2025-11-17', 'cmt_commit_hash__0': '77008266fbd536f0f8c13582c9b381c8ad34fcf4', 'cmt_committer_timestamp__0': '2025-11-17 16:20:04 -0800', 'cmt_whitespace__1': 0, 'cmt_removed__1': 1, 'cmt_committer_date__1': '2025-11-17', 'cmt_author_raw_email__1': 'chirag@nvidia.com', 'cmt_author_date__1': '2025-11-17', 'cmt_author_timestamp__1': '2025-11-17 10:51:16 -0800', 'data_source__1': 'git', 'cmt_filename__1': 'tests/topotests/bgp_evpn_three_tier_clos_topo1/ipv4/tor-22/frr.conf', 'cmt_author_name__1': '', 'tool_source__1': 'Facade', 'cmt_committer_email__1': 'chiragshah6@gmail.com', 'repo_id__1': 78307, 'cmt_committer_name__1': 'Chirag Shah', 'tool_version__1': '0.80', 'cmt_added__1': 2, 'cmt_committer_raw_email__1': 'chirag@nvidia.com', 'cmt_author_email__1': 'chiragshah6@gmail.com', 'cmt_date_attempted__1': '2025-11-17', 'cmt_commit_hash__1': '77008266fbd536f0f8c13582c9b381c8ad34fcf4', 'cmt_committer_timestamp__1': '2025-11-17 16:20:04 -0800', 'cmt_whitespace__2': 0, 'cmt_removed__2': 1, 'cmt_committer_date__2': '2025-11-17', 'cmt_author_raw_email__2': 'chirag@nvidia.com', 'cmt_author_date__2': '2025-11-17', 'cmt_author_timestamp__2': '2025-11-17 10:51:16 -0800', 'data_source__2': 'git', 'cmt_filename__2': 'tests/topotests/bgp_evpn_three_tier_clos_topo1/ipv6/bordertor-11/frr.conf', 'cmt_author_name__2': '', 'tool_source__2': 'Facade' ... 3000 parameters truncated ... 'cmt_committer_email__152': 'noreply@github.com', 'repo_id__152': 78307, 'cmt_committer_name__152': 'GitHub', 'tool_version__152': '0.80', 'cmt_added__152': 0, 'cmt_committer_raw_email__152': 'noreply@github.com', 'cmt_author_email__152': 'donaldsharp72@gmail.com', 'cmt_date_attempted__152': '2025-12-09', 'cmt_commit_hash__152': '8992f78e98440a87a6ca195c6048a3d069384b2c', 'cmt_committer_timestamp__152': '2025-12-09 11:53:58 -0500', 'cmt_whitespace__153': 0, 'cmt_removed__153': 0, 'cmt_committer_date__153': '2025-11-18', 'cmt_author_raw_email__153': 'donatas@opensourcerouting.org', 'cmt_author_date__153': '2025-11-18', 'cmt_author_timestamp__153': '2025-11-18 18:41:06 +0200', 'data_source__153': 'git', 'cmt_filename__153': '(Merge commit)', 'cmt_author_name__153': '', 'tool_source__153': 'Facade', 'cmt_committer_email__153': 'noreply@github.com', 'repo_id__153': 78307, 'cmt_committer_name__153': 'GitHub', 'tool_version__153': '0.80', 'cmt_added__153': 0, 'cmt_committer_raw_email__153': 'noreply@github.com', 'cmt_author_email__153': 'donatas@opensourcerouting.org', 'cmt_date_attempted__153': '2025-11-18', 'cmt_commit_hash__153': '50de2d636d160e6983e103714faec29d2406acd0', 'cmt_committer_timestamp__153': '2025-11-18 18:41:06 +0200', 'cmt_whitespace__154': 4, 'cmt_removed__154': 1, 'cmt_committer_date__154': '2025-11-07', 'cmt_author_raw_email__154': 'ashred@nvidia.com', 'cmt_author_date__154': '2025-10-23', 'cmt_author_timestamp__154': '2025-10-23 10:10:41 -0700', 'data_source__154': 'git', 'cmt_filename__154': 'bgpd/bgpd.c', 'cmt_author_name__154': '', 'tool_source__154': 'Facade', 'cmt_committer_email__154': 'ashred@nvidia.com', 'repo_id__154': 78307, 'cmt_committer_name__154': 'Ashwini Reddy', 'tool_version__154': '0.80', 'cmt_added__154': 20, 'cmt_committer_raw_email__154': 'ashred@nvidia.com', 'cmt_author_email__154': 'ashred@nvidia.com', 'cmt_date_attempted__154': '2025-11-07', 'cmt_commit_hash__154': '6b5828d651ff3a2fe49fedb855081e00f8b16e68', 'cmt_committer_timestamp__154': '2025-11-07 13:28:40 -0800'}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.InvalidTimeZoneDisplacementValue: time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

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

Traceback (most recent call last):
File "/augur/augur/application/db/lib.py", line 183, in facade_bulk_insert_commits
session.execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2306, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2188, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1262, in orm_execute_statement
result = _bulk_insert(
^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 199, in _bulk_insert
result = persistence._emit_insert_statements(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1043, in _emit_insert_statements
result = connection.execute(
^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
return meth(
^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context
return self._exec_insertmany_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2120, in _exec_insertmany_context
self._handle_dbapi_exception(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTimeZoneDisplacementValue) time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

[SQL: INSERT INTO augur_data.commits (repo_id, cmt_commit_hash, cmt_author_name, cmt_author_raw_email, cmt_author_email, cmt_author_date, cmt_committer_name, cmt_committer_raw_email, cmt_committer_email, cmt_committer_date, cmt_added, cmt_removed, cmt_whit ... 39027 characters truncated ... _76)s, %(cmt_author_timestamp__76)s, %(tool_source__76)s, %(tool_version__76)s, %(data_source__76)s)]
[parameters: {'cmt_whitespace__0': 0, 'cmt_removed__0': 1, 'cmt_committer_date__0': '2025-11-17', 'cmt_author_raw_email__0': 'chirag@nvidia.com', 'cmt_author_date__0': '2025-11-17', 'cmt_author_timestamp__0': '2025-11-17 10:51:16 -0800', 'data_source__0': 'git', 'cmt_filename__0': 'tests/topotests/bgp_evpn_three_tier_clos_topo1/ipv4/tor-21/frr.conf', 'cmt_author_name__0': '', 'tool_source__0': 'Facade', 'cmt_committer_email__0': 'chiragshah6@gmail.com', 'repo_id__0': 78307, 'cmt_committer_name__0': 'Chirag Shah', 'tool_version__0': '0.80', 'cmt_added__0': 2, 'cmt_committer_raw_email__0': 'chirag@nvidia.com', 'cmt_author_email__0': 'chiragshah6@gmail.com', 'cmt_date_attempted__0': '2025-11-17', 'cmt_commit_hash__0': '77008266fbd536f0f8c13582c9b381c8ad34fcf4', 'cmt_committer_timestamp__0': '2025-11-17 16:20:04 -0800', 'cmt_whitespace__1': 0, 'cmt_removed__1': 1, 'cmt_committer_date__1': '2025-11-17', 'cmt_author_raw_email__1': 'chirag@nvidia.com', 'cmt_author_date__1': '2025-11-17', 'cmt_author_timestamp__1': '2025-11-17 10:51:16 -0800', 'data_source__1': 'git', 'cmt_filename__1': 'tests/topotests/bgp_evpn_three_tier_clos_topo1/ipv4/tor-22/frr.conf', 'cmt_author_name__1': '', 'tool_source__1': 'Facade', 'cmt_committer_email__1': 'chiragshah6@gmail.com', 'repo_id__1': 78307, 'cmt_committer_name__1': 'Chirag Shah', 'tool_version__1': '0.80', 'cmt_added__1': 2, 'cmt_committer_raw_email__1': 'chirag@nvidia.com', 'cmt_author_email__1': 'chiragshah6@gmail.com', 'cmt_date_attempted__1': '2025-11-17', 'cmt_commit_hash__1': '77008266fbd536f0f8c13582c9b381c8ad34fcf4', 'cmt_committer_timestamp__1': '2025-11-17 16:20:04 -0800', 'cmt_whitespace__2': 0, 'cmt_removed__2': 1, 'cmt_committer_date__2': '2025-11-17', 'cmt_author_raw_email__2': 'chirag@nvidia.com', 'cmt_author_date__2': '2025-11-17', 'cmt_author_timestamp__2': '2025-11-17 10:51:16 -0800', 'data_source__2': 'git', 'cmt_filename__2': 'tests/topotests/bgp_evpn_three_tier_clos_topo1/ipv6/bordertor-11/frr.conf', 'cmt_author_name__2': '', 'tool_source__2': 'Facade' ... 1440 parameters truncated ... 'cmt_committer_email__74': 'mjs.ietf@gmail.com', 'repo_id__74': 78307, 'cmt_committer_name__74': 'Mark Stapp', 'tool_version__74': '0.80', 'cmt_added__74': 87, 'cmt_committer_raw_email__74': 'mjs@cisco.com', 'cmt_author_email__74': 'mjs.ietf@gmail.com', 'cmt_date_attempted__74': '2025-12-05', 'cmt_commit_hash__74': 'ff05cdcc153fcda62413646bef063f668edbaa21', 'cmt_committer_timestamp__74': '2025-12-05 08:58:26 -0500', 'cmt_whitespace__75': 0, 'cmt_removed__75': 2, 'cmt_committer_date__75': '2025-12-05', 'cmt_author_raw_email__75': 'mjs@cisco.com', 'cmt_author_date__75': '2025-12-04', 'cmt_author_timestamp__75': '2025-12-04 14:50:34 -0500', 'data_source__75': 'git', 'cmt_filename__75': 'lib/frr_pthread.c', 'cmt_author_name__75': '', 'tool_source__75': 'Facade', 'cmt_committer_email__75': 'mjs.ietf@gmail.com', 'repo_id__75': 78307, 'cmt_committer_name__75': 'Mark Stapp', 'tool_version__75': '0.80', 'cmt_added__75': 2, 'cmt_committer_raw_email__75': 'mjs@cisco.com', 'cmt_author_email__75': 'mjs.ietf@gmail.com', 'cmt_date_attempted__75': '2025-12-05', 'cmt_commit_hash__75': 'ff05cdcc153fcda62413646bef063f668edbaa21', 'cmt_committer_timestamp__75': '2025-12-05 08:58:26 -0500', 'cmt_whitespace__76': 2, 'cmt_removed__76': 84, 'cmt_committer_date__76': '2025-12-05', 'cmt_author_raw_email__76': 'mjs@cisco.com', 'cmt_author_date__76': '2025-12-04', 'cmt_author_timestamp__76': '2025-12-04 14:50:34 -0500', 'data_source__76': 'git', 'cmt_filename__76': 'lib/frrevent.h', 'cmt_author_name__76': '', 'tool_source__76': 'Facade', 'cmt_committer_email__76': 'mjs.ietf@gmail.com', 'repo_id__76': 78307, 'cmt_committer_name__76': 'Mark Stapp', 'tool_version__76': '0.80', 'cmt_added__76': 5, 'cmt_committer_raw_email__76': 'mjs@cisco.com', 'cmt_author_email__76': 'mjs.ietf@gmail.com', 'cmt_date_attempted__76': '2025-12-05', 'cmt_commit_hash__76': 'ff05cdcc153fcda62413646bef063f668edbaa21', 'cmt_committer_timestamp__76': '2025-12-05 08:58:26 -0500'}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.InvalidTimeZoneDisplacementValue: time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

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

Traceback (most recent call last):
File "/augur/augur/application/db/lib.py", line 183, in facade_bulk_insert_commits
session.execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2306, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2188, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1262, in orm_execute_statement
result = _bulk_insert(
^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 199, in _bulk_insert
result = persistence._emit_insert_statements(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1043, in _emit_insert_statements
result = connection.execute(
^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
return meth(
^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context
return self._exec_insertmany_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2120, in _exec_insertmany_context
self._handle_dbapi_exception(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTimeZoneDisplacementValue) time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

[SQL: INSERT INTO augur_data.commits (repo_id, cmt_commit_hash, cmt_author_name, cmt_author_raw_email, cmt_author_email, cmt_author_date, cmt_committer_name, cmt_committer_raw_email, cmt_committer_email, cmt_committer_date, cmt_added, cmt_removed, cmt_whit ... 19685 characters truncated ... _38)s, %(cmt_author_timestamp__38)s, %(tool_source__38)s, %(tool_version__38)s, %(data_source__38)s)]
[parameters: {'cmt_whitespace__0': 5, 'cmt_removed__0': 17, 'cmt_committer_date__0': '2025-11-21', 'cmt_author_raw_email__0': 'souroy@nvidia.com', 'cmt_author_date__0': '2025-11-21', 'cmt_author_timestamp__0': '2025-11-21 10:47:55 -0800', 'data_source__0': 'git', 'cmt_filename__0': 'pimd/pim_mlag.c', 'cmt_author_name__0': '', 'tool_source__0': 'Facade', 'cmt_committer_email__0': 'souroy@nvidia.com', 'repo_id__0': 78307, 'cmt_committer_name__0': 'Soumya Roy', 'tool_version__0': '0.80', 'cmt_added__0': 8, 'cmt_committer_raw_email__0': 'souroy@nvidia.com', 'cmt_author_email__0': 'souroy@nvidia.com', 'cmt_date_attempted__0': '2025-11-21', 'cmt_commit_hash__0': '60c0ac1bd84073b2a6287732aeb20d6ec39293f9', 'cmt_committer_timestamp__0': '2025-11-21 11:07:52 -0800', 'cmt_whitespace__1': 1, 'cmt_removed__1': 2, 'cmt_committer_date__1': '2025-11-21', 'cmt_author_raw_email__1': 'souroy@nvidia.com', 'cmt_author_date__1': '2025-11-21', 'cmt_author_timestamp__1': '2025-11-21 10:47:55 -0800', 'data_source__1': 'git', 'cmt_filename__1': 'pimd/pim_register.c', 'cmt_author_name__1': '', 'tool_source__1': 'Facade', 'cmt_committer_email__1': 'souroy@nvidia.com', 'repo_id__1': 78307, 'cmt_committer_name__1': 'Soumya Roy', 'tool_version__1': '0.80', 'cmt_added__1': 1, 'cmt_committer_raw_email__1': 'souroy@nvidia.com', 'cmt_author_email__1': 'souroy@nvidia.com', 'cmt_date_attempted__1': '2025-11-21', 'cmt_commit_hash__1': '60c0ac1bd84073b2a6287732aeb20d6ec39293f9', 'cmt_committer_timestamp__1': '2025-11-21 11:07:52 -0800', 'cmt_whitespace__2': 2, 'cmt_removed__2': 6, 'cmt_committer_date__2': '2025-11-21', 'cmt_author_raw_email__2': 'souroy@nvidia.com', 'cmt_author_date__2': '2025-11-21', 'cmt_author_timestamp__2': '2025-11-21 10:47:55 -0800', 'data_source__2': 'git', 'cmt_filename__2': 'pimd/pim_sock.c', 'cmt_author_name__2': '', 'tool_source__2': 'Facade' ... 680 parameters truncated ... 'cmt_committer_email__36': 'mjs.ietf@gmail.com', 'repo_id__36': 78307, 'cmt_committer_name__36': 'Mark Stapp', 'tool_version__36': '0.80', 'cmt_added__36': 87, 'cmt_committer_raw_email__36': 'mjs@cisco.com', 'cmt_author_email__36': 'mjs.ietf@gmail.com', 'cmt_date_attempted__36': '2025-12-05', 'cmt_commit_hash__36': 'ff05cdcc153fcda62413646bef063f668edbaa21', 'cmt_committer_timestamp__36': '2025-12-05 08:58:26 -0500', 'cmt_whitespace__37': 0, 'cmt_removed__37': 2, 'cmt_committer_date__37': '2025-12-05', 'cmt_author_raw_email__37': 'mjs@cisco.com', 'cmt_author_date__37': '2025-12-04', 'cmt_author_timestamp__37': '2025-12-04 14:50:34 -0500', 'data_source__37': 'git', 'cmt_filename__37': 'lib/frr_pthread.c', 'cmt_author_name__37': '', 'tool_source__37': 'Facade', 'cmt_committer_email__37': 'mjs.ietf@gmail.com', 'repo_id__37': 78307, 'cmt_committer_name__37': 'Mark Stapp', 'tool_version__37': '0.80', 'cmt_added__37': 2, 'cmt_committer_raw_email__37': 'mjs@cisco.com', 'cmt_author_email__37': 'mjs.ietf@gmail.com', 'cmt_date_attempted__37': '2025-12-05', 'cmt_commit_hash__37': 'ff05cdcc153fcda62413646bef063f668edbaa21', 'cmt_committer_timestamp__37': '2025-12-05 08:58:26 -0500', 'cmt_whitespace__38': 2, 'cmt_removed__38': 84, 'cmt_committer_date__38': '2025-12-05', 'cmt_author_raw_email__38': 'mjs@cisco.com', 'cmt_author_date__38': '2025-12-04', 'cmt_author_timestamp__38': '2025-12-04 14:50:34 -0500', 'data_source__38': 'git', 'cmt_filename__38': 'lib/frrevent.h', 'cmt_author_name__38': '', 'tool_source__38': 'Facade', 'cmt_committer_email__38': 'mjs.ietf@gmail.com', 'repo_id__38': 78307, 'cmt_committer_name__38': 'Mark Stapp', 'tool_version__38': '0.80', 'cmt_added__38': 5, 'cmt_committer_raw_email__38': 'mjs@cisco.com', 'cmt_author_email__38': 'mjs.ietf@gmail.com', 'cmt_date_attempted__38': '2025-12-05', 'cmt_commit_hash__38': 'ff05cdcc153fcda62413646bef063f668edbaa21', 'cmt_committer_timestamp__38': '2025-12-05 08:58:26 -0500'}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.InvalidTimeZoneDisplacementValue: time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

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

Traceback (most recent call last):
File "/augur/augur/application/db/lib.py", line 183, in facade_bulk_insert_commits
session.execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2306, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2188, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1262, in orm_execute_statement
result = _bulk_insert(
^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 199, in _bulk_insert
result = persistence._emit_insert_statements(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1043, in _emit_insert_statements
result = connection.execute(
^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
return meth(
^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context
return self._exec_insertmany_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2120, in _exec_insertmany_context
self._handle_dbapi_exception(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTimeZoneDisplacementValue) time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

[SQL: INSERT INTO augur_data.commits (repo_id, cmt_commit_hash, cmt_author_name, cmt_author_raw_email, cmt_author_email, cmt_author_date, cmt_committer_name, cmt_committer_raw_email, cmt_committer_email, cmt_committer_date, cmt_added, cmt_removed, cmt_whit ... 9505 characters truncated ... _18)s, %(cmt_author_timestamp__18)s, %(tool_source__18)s, %(tool_version__18)s, %(data_source__18)s)]
[parameters: {'cmt_whitespace__0': 5, 'cmt_removed__0': 17, 'cmt_committer_date__0': '2025-11-21', 'cmt_author_raw_email__0': 'souroy@nvidia.com', 'cmt_author_date__0': '2025-11-21', 'cmt_author_timestamp__0': '2025-11-21 10:47:55 -0800', 'data_source__0': 'git', 'cmt_filename__0': 'pimd/pim_mlag.c', 'cmt_author_name__0': '', 'tool_source__0': 'Facade', 'cmt_committer_email__0': 'souroy@nvidia.com', 'repo_id__0': 78307, 'cmt_committer_name__0': 'Soumya Roy', 'tool_version__0': '0.80', 'cmt_added__0': 8, 'cmt_committer_raw_email__0': 'souroy@nvidia.com', 'cmt_author_email__0': 'souroy@nvidia.com', 'cmt_date_attempted__0': '2025-11-21', 'cmt_commit_hash__0': '60c0ac1bd84073b2a6287732aeb20d6ec39293f9', 'cmt_committer_timestamp__0': '2025-11-21 11:07:52 -0800', 'cmt_whitespace__1': 1, 'cmt_removed__1': 2, 'cmt_committer_date__1': '2025-11-21', 'cmt_author_raw_email__1': 'souroy@nvidia.com', 'cmt_author_date__1': '2025-11-21', 'cmt_author_timestamp__1': '2025-11-21 10:47:55 -0800', 'data_source__1': 'git', 'cmt_filename__1': 'pimd/pim_register.c', 'cmt_author_name__1': '', 'tool_source__1': 'Facade', 'cmt_committer_email__1': 'souroy@nvidia.com', 'repo_id__1': 78307, 'cmt_committer_name__1': 'Soumya Roy', 'tool_version__1': '0.80', 'cmt_added__1': 1, 'cmt_committer_raw_email__1': 'souroy@nvidia.com', 'cmt_author_email__1': 'souroy@nvidia.com', 'cmt_date_attempted__1': '2025-11-21', 'cmt_commit_hash__1': '60c0ac1bd84073b2a6287732aeb20d6ec39293f9', 'cmt_committer_timestamp__1': '2025-11-21 11:07:52 -0800', 'cmt_whitespace__2': 2, 'cmt_removed__2': 6, 'cmt_committer_date__2': '2025-11-21', 'cmt_author_raw_email__2': 'souroy@nvidia.com', 'cmt_author_date__2': '2025-11-21', 'cmt_author_timestamp__2': '2025-11-21 10:47:55 -0800', 'data_source__2': 'git', 'cmt_filename__2': 'pimd/pim_sock.c', 'cmt_author_name__2': '', 'tool_source__2': 'Facade' ... 280 parameters truncated ... 'cmt_committer_email__16': 'ashred@nvidia.com', 'repo_id__16': 78307, 'cmt_committer_name__16': 'Ashwini Reddy', 'tool_version__16': '0.80', 'cmt_added__16': 202, 'cmt_committer_raw_email__16': 'ashred@nvidia.com', 'cmt_author_email__16': 'ashred@nvidia.com', 'cmt_date_attempted__16': '2025-11-14', 'cmt_commit_hash__16': '8c60f149a5ceff645e65df5c776280191a9f244a', 'cmt_committer_timestamp__16': '2025-11-14 08:35:09 -0800', 'cmt_whitespace__17': 5, 'cmt_removed__17': 21, 'cmt_committer_date__17': '2025-11-27', 'cmt_author_raw_email__17': 'chirag@nvidia.com', 'cmt_author_date__17': '2025-11-27', 'cmt_author_timestamp__17': '2025-11-27 20:55:34 -0800', 'data_source__17': 'git', 'cmt_filename__17': 'tests/topotests/lib/evpn.py', 'cmt_author_name__17': '', 'tool_source__17': 'Facade', 'cmt_committer_email__17': 'chiragshah6@gmail.com', 'repo_id__17': 78307, 'cmt_committer_name__17': 'Chirag Shah', 'tool_version__17': '0.80', 'cmt_added__17': 61, 'cmt_committer_raw_email__17': 'chirag@nvidia.com', 'cmt_author_email__17': 'chiragshah6@gmail.com', 'cmt_date_attempted__17': '2025-11-27', 'cmt_commit_hash__17': 'b61880b8964ac6356480f67cb56e271808d5dc13', 'cmt_committer_timestamp__17': '2025-11-27 21:26:34 -0800', 'cmt_whitespace__18': 2, 'cmt_removed__18': 2, 'cmt_committer_date__18': '2025-12-03', 'cmt_author_raw_email__18': 'donatas@opensourcerouting.org', 'cmt_author_date__18': '2025-12-01', 'cmt_author_timestamp__18': '2025-12-01 22:16:23 +0200', 'data_source__18': 'git', 'cmt_filename__18': 'bgpd/bgp_open.c', 'cmt_author_name__18': '', 'tool_source__18': 'Facade', 'cmt_committer_email__18': 'donatas@opensourcerouting.org', 'repo_id__18': 78307, 'cmt_committer_name__18': 'Donatas Abraitis', 'tool_version__18': '0.80', 'cmt_added__18': 11, 'cmt_committer_raw_email__18': 'donatas@opensourcerouting.org', 'cmt_author_email__18': 'donatas@opensourcerouting.org', 'cmt_date_attempted__18': '2025-12-03', 'cmt_commit_hash__18': '784cf95c4377ec84b25fb5801fdfaa20450325de', 'cmt_committer_timestamp__18': '2025-12-03 13:27:40 +0200'}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.InvalidTimeZoneDisplacementValue: time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

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

Traceback (most recent call last):
File "/augur/augur/application/db/lib.py", line 183, in facade_bulk_insert_commits
session.execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2306, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2188, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1262, in orm_execute_statement
result = _bulk_insert(
^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 199, in _bulk_insert
result = persistence._emit_insert_statements(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1043, in _emit_insert_statements
result = connection.execute(
^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
return meth(
^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context
return self._exec_insertmany_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2120, in _exec_insertmany_context
self._handle_dbapi_exception(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTimeZoneDisplacementValue) time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

[SQL: INSERT INTO augur_data.commits (repo_id, cmt_commit_hash, cmt_author_name, cmt_author_raw_email, cmt_author_email, cmt_author_date, cmt_committer_name, cmt_committer_raw_email, cmt_committer_email, cmt_committer_date, cmt_added, cmt_removed, cmt_whit ... 4924 characters truncated ... tamp__9)s, %(cmt_author_timestamp__9)s, %(tool_source__9)s, %(tool_version__9)s, %(data_source__9)s)]
[parameters: {'cmt_whitespace__0': 1, 'cmt_removed__0': 0, 'cmt_committer_date__0': '2025-11-03', 'cmt_author_raw_email__0': 'rajasekarr@nvidia.com', 'cmt_author_date__0': '2025-10-22', 'cmt_author_timestamp__0': '2025-10-22 15:07:21 -0700', 'data_source__0': 'git', 'cmt_filename__0': 'zebra/zebra_nhg.h', 'cmt_author_name__0': '', 'tool_source__0': 'Facade', 'cmt_committer_email__0': 'rajasekarr@nvidia.com', 'repo_id__0': 78307, 'cmt_committer_name__0': 'Rajasekar Raja', 'tool_version__0': '0.80', 'cmt_added__0': 2, 'cmt_committer_raw_email__0': 'rajasekarr@nvidia.com', 'cmt_author_email__0': 'rajasekarr@nvidia.com', 'cmt_date_attempted__0': '2025-11-03', 'cmt_commit_hash__0': '2d950bdab0404d55e56f85409a948b7e035d40be', 'cmt_committer_timestamp__0': '2025-11-03 14:55:17 -0800', 'cmt_whitespace__1': 44, 'cmt_removed__1': 247, 'cmt_committer_date__1': '2106-02-07', 'cmt_author_raw_email__1': 'mjs@cisco.com', 'cmt_author_date__1': '2025-11-03', 'cmt_author_timestamp__1': '2025-11-03 16:28:43 -0500', 'data_source__1': 'git', 'cmt_filename__1': 'lib/event.c', 'cmt_author_name__1': '', 'tool_source__1': 'Facade', 'cmt_committer_email__1': 'mjs.ietf@gmail.com', 'repo_id__1': 78307, 'cmt_committer_name__1': 'Mark Stapp', 'tool_version__1': '0.80', 'cmt_added__1': 252, 'cmt_committer_raw_email__1': 'mjs@cisco.com', 'cmt_author_email__1': 'mjs.ietf@gmail.com', 'cmt_date_attempted__1': '2106-02-07', 'cmt_commit_hash__1': '5de262a839b04ff4649d4e04784c98c08322d7b4', 'cmt_committer_timestamp__1': '2106-02-07 06:28:23 -13068837', 'cmt_whitespace__2': 3, 'cmt_removed__2': 3, 'cmt_committer_date__2': '2106-02-07', 'cmt_author_raw_email__2': 'mjs@cisco.com', 'cmt_author_date__2': '2025-11-03', 'cmt_author_timestamp__2': '2025-11-03 16:28:43 -0500', 'data_source__2': 'git', 'cmt_filename__2': 'lib/frrevent.h', 'cmt_author_name__2': '', 'tool_source__2': 'Facade' ... 100 parameters truncated ... 'cmt_committer_email__7': 'ashred@nvidia.com', 'repo_id__7': 78307, 'cmt_committer_name__7': 'Ashwini Reddy', 'tool_version__7': '0.80', 'cmt_added__7': 202, 'cmt_committer_raw_email__7': 'ashred@nvidia.com', 'cmt_author_email__7': 'ashred@nvidia.com', 'cmt_date_attempted__7': '2025-11-14', 'cmt_commit_hash__7': '8c60f149a5ceff645e65df5c776280191a9f244a', 'cmt_committer_timestamp__7': '2025-11-14 08:35:09 -0800', 'cmt_whitespace__8': 5, 'cmt_removed__8': 21, 'cmt_committer_date__8': '2025-11-27', 'cmt_author_raw_email__8': 'chirag@nvidia.com', 'cmt_author_date__8': '2025-11-27', 'cmt_author_timestamp__8': '2025-11-27 20:55:34 -0800', 'data_source__8': 'git', 'cmt_filename__8': 'tests/topotests/lib/evpn.py', 'cmt_author_name__8': '', 'tool_source__8': 'Facade', 'cmt_committer_email__8': 'chiragshah6@gmail.com', 'repo_id__8': 78307, 'cmt_committer_name__8': 'Chirag Shah', 'tool_version__8': '0.80', 'cmt_added__8': 61, 'cmt_committer_raw_email__8': 'chirag@nvidia.com', 'cmt_author_email__8': 'chiragshah6@gmail.com', 'cmt_date_attempted__8': '2025-11-27', 'cmt_commit_hash__8': 'b61880b8964ac6356480f67cb56e271808d5dc13', 'cmt_committer_timestamp__8': '2025-11-27 21:26:34 -0800', 'cmt_whitespace__9': 2, 'cmt_removed__9': 2, 'cmt_committer_date__9': '2025-12-03', 'cmt_author_raw_email__9': 'donatas@opensourcerouting.org', 'cmt_author_date__9': '2025-12-01', 'cmt_author_timestamp__9': '2025-12-01 22:16:23 +0200', 'data_source__9': 'git', 'cmt_filename__9': 'bgpd/bgp_open.c', 'cmt_author_name__9': '', 'tool_source__9': 'Facade', 'cmt_committer_email__9': 'donatas@opensourcerouting.org', 'repo_id__9': 78307, 'cmt_committer_name__9': 'Donatas Abraitis', 'tool_version__9': '0.80', 'cmt_added__9': 11, 'cmt_committer_raw_email__9': 'donatas@opensourcerouting.org', 'cmt_author_email__9': 'donatas@opensourcerouting.org', 'cmt_date_attempted__9': '2025-12-03', 'cmt_commit_hash__9': '784cf95c4377ec84b25fb5801fdfaa20450325de', 'cmt_committer_timestamp__9': '2025-12-03 13:27:40 +0200'}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.InvalidTimeZoneDisplacementValue: time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

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

Traceback (most recent call last):
File "/augur/augur/application/db/lib.py", line 183, in facade_bulk_insert_commits
session.execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2306, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2188, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1262, in orm_execute_statement
result = _bulk_insert(
^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 199, in _bulk_insert
result = persistence._emit_insert_statements(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1043, in _emit_insert_statements
result = connection.execute(
^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
return meth(
^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context
return self._exec_insertmany_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2120, in _exec_insertmany_context
self._handle_dbapi_exception(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTimeZoneDisplacementValue) time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

[SQL: INSERT INTO augur_data.commits (repo_id, cmt_commit_hash, cmt_author_name, cmt_author_raw_email, cmt_author_email, cmt_author_date, cmt_committer_name, cmt_committer_raw_email, cmt_committer_email, cmt_committer_date, cmt_added, cmt_removed, cmt_whit ... 2479 characters truncated ... tamp__4)s, %(cmt_author_timestamp__4)s, %(tool_source__4)s, %(tool_version__4)s, %(data_source__4)s)]
[parameters: {'cmt_whitespace__0': 1, 'cmt_removed__0': 0, 'cmt_committer_date__0': '2025-11-03', 'cmt_author_raw_email__0': 'rajasekarr@nvidia.com', 'cmt_author_date__0': '2025-10-22', 'cmt_author_timestamp__0': '2025-10-22 15:07:21 -0700', 'data_source__0': 'git', 'cmt_filename__0': 'zebra/zebra_nhg.h', 'cmt_author_name__0': '', 'tool_source__0': 'Facade', 'cmt_committer_email__0': 'rajasekarr@nvidia.com', 'repo_id__0': 78307, 'cmt_committer_name__0': 'Rajasekar Raja', 'tool_version__0': '0.80', 'cmt_added__0': 2, 'cmt_committer_raw_email__0': 'rajasekarr@nvidia.com', 'cmt_author_email__0': 'rajasekarr@nvidia.com', 'cmt_date_attempted__0': '2025-11-03', 'cmt_commit_hash__0': '2d950bdab0404d55e56f85409a948b7e035d40be', 'cmt_committer_timestamp__0': '2025-11-03 14:55:17 -0800', 'cmt_whitespace__1': 44, 'cmt_removed__1': 247, 'cmt_committer_date__1': '2106-02-07', 'cmt_author_raw_email__1': 'mjs@cisco.com', 'cmt_author_date__1': '2025-11-03', 'cmt_author_timestamp__1': '2025-11-03 16:28:43 -0500', 'data_source__1': 'git', 'cmt_filename__1': 'lib/event.c', 'cmt_author_name__1': '', 'tool_source__1': 'Facade', 'cmt_committer_email__1': 'mjs.ietf@gmail.com', 'repo_id__1': 78307, 'cmt_committer_name__1': 'Mark Stapp', 'tool_version__1': '0.80', 'cmt_added__1': 252, 'cmt_committer_raw_email__1': 'mjs@cisco.com', 'cmt_author_email__1': 'mjs.ietf@gmail.com', 'cmt_date_attempted__1': '2106-02-07', 'cmt_commit_hash__1': '5de262a839b04ff4649d4e04784c98c08322d7b4', 'cmt_committer_timestamp__1': '2106-02-07 06:28:23 -13068837', 'cmt_whitespace__2': 3, 'cmt_removed__2': 3, 'cmt_committer_date__2': '2106-02-07', 'cmt_author_raw_email__2': 'mjs@cisco.com', 'cmt_author_date__2': '2025-11-03', 'cmt_author_timestamp__2': '2025-11-03 16:28:43 -0500', 'data_source__2': 'git', 'cmt_filename__2': 'lib/frrevent.h', 'cmt_author_name__2': '', 'tool_source__2': 'Facade', 'cmt_committer_email__2': 'mjs.ietf@gmail.com', 'repo_id__2': 78307, 'cmt_committer_name__2': 'Mark Stapp', 'tool_version__2': '0.80', 'cmt_added__2': 8, 'cmt_committer_raw_email__2': 'mjs@cisco.com', 'cmt_author_email__2': 'mjs.ietf@gmail.com', 'cmt_date_attempted__2': '2106-02-07', 'cmt_commit_hash__2': '5de262a839b04ff4649d4e04784c98c08322d7b4', 'cmt_committer_timestamp__2': '2106-02-07 06:28:23 -13068837', 'cmt_whitespace__3': 1, 'cmt_removed__3': 1, 'cmt_committer_date__3': '2025-11-14', 'cmt_author_raw_email__3': 'ashred@nvidia.com', 'cmt_author_date__3': '2025-11-13', 'cmt_author_timestamp__3': '2025-11-13 08:17:46 -0800', 'data_source__3': 'git', 'cmt_filename__3': 'tests/topotests/bgp_aspath_list_policy_change/__init__.py', 'cmt_author_name__3': '', 'tool_source__3': 'Facade', 'cmt_committer_email__3': 'ashred@nvidia.com', 'repo_id__3': 78307, 'cmt_committer_name__3': 'Ashwini Reddy', 'tool_version__3': '0.80', 'cmt_added__3': 1, 'cmt_committer_raw_email__3': 'ashred@nvidia.com', 'cmt_author_email__3': 'ashred@nvidia.com', 'cmt_date_attempted__3': '2025-11-14', 'cmt_commit_hash__3': '8c60f149a5ceff645e65df5c776280191a9f244a', 'cmt_committer_timestamp__3': '2025-11-14 08:35:09 -0800', 'cmt_whitespace__4': 1, 'cmt_removed__4': 1, 'cmt_committer_date__4': '2025-11-14', 'cmt_author_raw_email__4': 'ashred@nvidia.com', 'cmt_author_date__4': '2025-11-13', 'cmt_author_timestamp__4': '2025-11-13 08:17:46 -0800', 'data_source__4': 'git', 'cmt_filename__4': 'tests/topotests/bgp_aspath_list_policy_change/r1/frr.conf', 'cmt_author_name__4': '', 'tool_source__4': 'Facade', 'cmt_committer_email__4': 'ashred@nvidia.com', 'repo_id__4': 78307, 'cmt_committer_name__4': 'Ashwini Reddy', 'tool_version__4': '0.80', 'cmt_added__4': 14, 'cmt_committer_raw_email__4': 'ashred@nvidia.com', 'cmt_author_email__4': 'ashred@nvidia.com', 'cmt_date_attempted__4': '2025-11-14', 'cmt_commit_hash__4': '8c60f149a5ceff645e65df5c776280191a9f244a', 'cmt_committer_timestamp__4': '2025-11-14 08:35:09 -0800'}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.InvalidTimeZoneDisplacementValue: time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

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

Traceback (most recent call last):
File "/augur/augur/application/db/lib.py", line 183, in facade_bulk_insert_commits
session.execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2306, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2188, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1262, in orm_execute_statement
result = _bulk_insert(
^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 199, in _bulk_insert
result = persistence._emit_insert_statements(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1043, in _emit_insert_statements
result = connection.execute(
^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
return meth(
^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context
return self._exec_insertmany_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2120, in _exec_insertmany_context
self._handle_dbapi_exception(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2112, in _exec_insertmany_context
dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTimeZoneDisplacementValue) time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

[SQL: INSERT INTO augur_data.commits (repo_id, cmt_commit_hash, cmt_author_name, cmt_author_raw_email, cmt_author_email, cmt_author_date, cmt_committer_name, cmt_committer_raw_email, cmt_committer_email, cmt_committer_date, cmt_added, cmt_removed, cmt_whit ... 1012 characters truncated ... tamp__1)s, %(cmt_author_timestamp__1)s, %(tool_source__1)s, %(tool_version__1)s, %(data_source__1)s)]
[parameters: {'cmt_whitespace__0': 1, 'cmt_removed__0': 0, 'cmt_committer_date__0': '2025-11-03', 'cmt_author_raw_email__0': 'rajasekarr@nvidia.com', 'cmt_author_date__0': '2025-10-22', 'cmt_author_timestamp__0': '2025-10-22 15:07:21 -0700', 'data_source__0': 'git', 'cmt_filename__0': 'zebra/zebra_nhg.h', 'cmt_author_name__0': '', 'tool_source__0': 'Facade', 'cmt_committer_email__0': 'rajasekarr@nvidia.com', 'repo_id__0': 78307, 'cmt_committer_name__0': 'Rajasekar Raja', 'tool_version__0': '0.80', 'cmt_added__0': 2, 'cmt_committer_raw_email__0': 'rajasekarr@nvidia.com', 'cmt_author_email__0': 'rajasekarr@nvidia.com', 'cmt_date_attempted__0': '2025-11-03', 'cmt_commit_hash__0': '2d950bdab0404d55e56f85409a948b7e035d40be', 'cmt_committer_timestamp__0': '2025-11-03 14:55:17 -0800', 'cmt_whitespace__1': 44, 'cmt_removed__1': 247, 'cmt_committer_date__1': '2106-02-07', 'cmt_author_raw_email__1': 'mjs@cisco.com', 'cmt_author_date__1': '2025-11-03', 'cmt_author_timestamp__1': '2025-11-03 16:28:43 -0500', 'data_source__1': 'git', 'cmt_filename__1': 'lib/event.c', 'cmt_author_name__1': '', 'tool_source__1': 'Facade', 'cmt_committer_email__1': 'mjs.ietf@gmail.com', 'repo_id__1': 78307, 'cmt_committer_name__1': 'Mark Stapp', 'tool_version__1': '0.80', 'cmt_added__1': 252, 'cmt_committer_raw_email__1': 'mjs@cisco.com', 'cmt_author_email__1': 'mjs.ietf@gmail.com', 'cmt_date_attempted__1': '2106-02-07', 'cmt_commit_hash__1': '5de262a839b04ff4649d4e04784c98c08322d7b4', 'cmt_committer_timestamp__1': '2106-02-07 06:28:23 -13068837'}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.InvalidTimeZoneDisplacementValue: time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

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

Traceback (most recent call last):
File "/augur/.venv/lib/python3.11/site-packages/celery/app/trace.py", line 453, in trace_task
R = retval = fun(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/celery/app/trace.py", line 736, in __protected_call__
return self.run(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/augur/tasks/git/facade_tasks.py", line 332, in analyze_commits_in_parallel
facade_bulk_insert_commits(logger, pendingCommitRecordsToInsert)
File "/augur/augur/application/db/lib.py", line 196, in facade_bulk_insert_commits
facade_bulk_insert_commits(logger, firsthalfRecords)
File "/augur/augur/application/db/lib.py", line 197, in facade_bulk_insert_commits
facade_bulk_insert_commits(logger, secondhalfRecords)
File "/augur/augur/application/db/lib.py", line 196, in facade_bulk_insert_commits
facade_bulk_insert_commits(logger, firsthalfRecords)
File "/augur/augur/application/db/lib.py", line 197, in facade_bulk_insert_commits
facade_bulk_insert_commits(logger, secondhalfRecords)
File "/augur/augur/application/db/lib.py", line 196, in facade_bulk_insert_commits
facade_bulk_insert_commits(logger, firsthalfRecords)
File "/augur/augur/application/db/lib.py", line 197, in facade_bulk_insert_commits
facade_bulk_insert_commits(logger, secondhalfRecords)
File "/augur/augur/application/db/lib.py", line 196, in facade_bulk_insert_commits
facade_bulk_insert_commits(logger, firsthalfRecords)
File "/augur/augur/application/db/lib.py", line 196, in facade_bulk_insert_commits
facade_bulk_insert_commits(logger, firsthalfRecords)
File "/augur/augur/application/db/lib.py", line 197, in facade_bulk_insert_commits
facade_bulk_insert_commits(logger, secondhalfRecords)
File "/augur/augur/application/db/lib.py", line 224, in facade_bulk_insert_commits
raise e
File "/augur/augur/application/db/lib.py", line 183, in facade_bulk_insert_commits
session.execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2306, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2188, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1262, in orm_execute_statement
result = _bulk_insert(
^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 199, in _bulk_insert
result = persistence._emit_insert_statements(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1043, in _emit_insert_statements
result = connection.execute(
^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
return meth(
^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1848, in _execute_context
return self._exec_single_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1988, in _exec_single_context
self._handle_dbapi_exception(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/augur/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTimeZoneDisplacementValue) time zone displacement out of range: "2106-02-07 06:28:23 -13068837"
LINE 1: ...2-07', 252, 247, 44, 'lib/event.c', '2106-02-07', '2106-02-0...
^

[SQL: INSERT INTO augur_data.commits (repo_id, cmt_commit_hash, cmt_author_name, cmt_author_raw_email, cmt_author_email, cmt_author_date, cmt_committer_name, cmt_committer_raw_email, cmt_committer_email, cmt_committer_date, cmt_added, cmt_removed, cmt_whitespace, cmt_filename, cmt_date_attempted, cmt_committer_timestamp, cmt_author_timestamp, tool_source, tool_version, data_source) VALUES (%(repo_id)s, %(cmt_commit_hash)s, %(cmt_author_name)s, %(cmt_author_raw_email)s, %(cmt_author_email)s, %(cmt_author_date)s, %(cmt_committer_name)s, %(cmt_committer_raw_email)s, %(cmt_committer_email)s, %(cmt_committer_date)s, %(cmt_added)s, %(cmt_removed)s, %(cmt_whitespace)s, %(cmt_filename)s, %(cmt_date_attempted)s, %(cmt_committer_timestamp)s, %(cmt_author_timestamp)s, %(tool_source)s, %(tool_version)s, %(data_source)s) RETURNING augur_data.commits.cmt_id]
[parameters: {'repo_id': 78307, 'cmt_commit_hash': '5de262a839b04ff4649d4e04784c98c08322d7b4', 'cmt_author_name': '', 'cmt_author_raw_email': 'mjs@cisco.com', 'cmt_author_email': 'mjs.ietf@gmail.com', 'cmt_author_date': '2025-11-03', 'cmt_committer_name': 'Mark Stapp', 'cmt_committer_raw_email': 'mjs@cisco.com', 'cmt_committer_email': 'mjs.ietf@gmail.com', 'cmt_committer_date': '2106-02-07', 'cmt_added': 252, 'cmt_removed': 247, 'cmt_whitespace': 44, 'cmt_filename': 'lib/event.c', 'cmt_date_attempted': '2106-02-07', 'cmt_committer_timestamp': '2106-02-07 06:28:23 -13068837', 'cmt_author_timestamp': '2025-11-03 16:28:43 -0500', 'tool_source': 'Facade', 'tool_version': '0.80', 'data_source': 'git'}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/redis.py", line 533, in on_chord_part_return
resl = [unpack(tup, decode) for tup in resl]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/redis.py", line 533, in
resl = [unpack(tup, decode) for tup in resl]
^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/redis.py", line 439, in _unpack_chord_result
raise ChordError(f'Dependency {tid} raised {retval!r}')
celery.exceptions.ChordError: Dependency 279b47d9-2085-4cde-9482-a96a1da234a1 raised Exception('([\'(psycopg2.errors.InvalidTimeZoneDisplacementValue) time zone displacement out of range: "2106-02-07 06:28:23 -13068837"\\nLINE 1: ...2-07\\\', 252, 247, 44, \\\'lib/event.c\\\', \\\'2106-02-07\\\', \\\'2106-02-0...\\n ^\\n\'])')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/augur/.venv/lib/python3.11/site-packages/celery/app/trace.py", line 470, in trace_task
I, R, state, retval = on_error(task_request, exc)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/celery/app/trace.py", line 381, in on_error
R = I.handle_error_state(
^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/celery/app/trace.py", line 175, in handle_error_state
return {
^
File "/augur/.venv/lib/python3.11/site-packages/celery/app/trace.py", line 227, in handle_failure
task.backend.mark_as_failure(
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/base.py", line 212, in mark_as_failure
self.on_chord_part_return(chain_elem_ctx, state, exc)
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/redis.py", line 552, in on_chord_part_return
return self.chord_error_from_stack(callback, exc)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/base.py", line 304, in chord_error_from_stack
return backend.fail_from_current_stack(callback.id, exc=exc)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/base.py", line 311, in fail_from_current_stack
self.mark_as_failure(task_id, exc, exception_info.traceback)
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/base.py", line 167, in mark_as_failure
self.store_result(task_id, exc, state,
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/base.py", line 526, in store_result
self._store_result(task_id, result, state, traceback,
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/base.py", line 975, in _store_result
current_meta = self._get_task_meta_for(task_id)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/base.py", line 997, in _get_task_meta_for
meta = self.get(self.get_key_for_task(task_id))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/augur/.venv/lib/python3.11/site-packages/celery/backends/base.py", line 871, in get_key_for_task
raise ValueError(f'task_id must not be empty. Got {task_id} instead.')
ValueError: task_id must not be empty. Got None instead.

```

this may be affected by the recursive nature of the insertion of data.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.