Adrian Edwards

ah yep, it looks like this table is using repo_id and name as the natural key/unique constraint https://github.com/chaoss/augur/blob/4221cba76e6ce93e8d4e2f2676f1525bfeacc8ca/augur/application/db/models/augur_data.py#L1996 It looks like maybe https://github.com/chaoss/augur/commit/b26fb371a8dd6b1649c36b560c53aa7e04d3b99b was made to, in part, change this...

i think for the purposes of this issue, having a way to get any known historical/alternate URLs for a repo, or even resolve a repo to a stable content-based identifier...

augur User in slack affected by this on a bare metal install. Repo https://github.com/dbus2/busd was in augur, got moved to https://github.com/z-galaxy/busd, and https://github.com/z-galaxy/busd was added as part of a new...

i suspect this procedure would replicate the issue: 1. create a public repo on github with something in it 2. add that repo to augur 3. allow it to collect...

ive seen the `KeyError('author_timestamp')` thing on these repos: tianocore/edk2 tianocore/edk2-1 tianocore/edk2-codereview   not sure where the ` TypeError('sequence item 1: expected a bytes-like object, NoneType found')` is coming from though All...

problematic date values: - "2018-01-24 22:36:22 -3407" (confidential-containers/edk2 and the other edk derived repos) - offending commit: https://github.com/tianocore/edk2/commit/630cb8507b2f1d7d7af3ac0f992d40f209dc1cee (seems like GH interperets the 3000 as a number of hours and...

``` 2025-10-17 22:57:24 kate analyze_commits_in_parallel[551620] DEBUG Analyzing commit e2b0828ea9fe7071ce5b0dc1a35de23ca95dd8f1 for repo_id=299384 2025-10-17 22:57:24 kate analyze_commits_in_parallel[551626] ERROR Ran into issue when trying to insert commits Error: (psycopg2.errors.InvalidTimeZoneDisplacementValue) time zone displacement out...

this was reported by a contributor today as well: ``` File "/Users/admin/augur_venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "pull-request-insert-unique" DETAIL: Key (pr_url)=(https://api.github.com/repos/z-galaxy/busd/pulls/271)...

Seems like this issue may be related to adding repos via the CLI and/or CSV files per @sgoggins [analysis](https://chaoss-workspace.slack.com/archives/C0226ELG6R4/p1761753197312659?thread_ts=1761730900.920429&cid=C0226ELG6R4): > augur/tasks/frontend.py has the method called first. (add_new_github_repos) > augur/application/cli/db.py seems...

`pull-request-insert-unique` as a constraint is defined at https://github.com/chaoss/augur/blob/4221cba76e6ce93e8d4e2f2676f1525bfeacc8ca/augur/application/db/models/augur_data.py#L1696 It looks like the underlying issue is likely to be a duplicate URL issue