augur
augur copied to clipboard
value too long for type character(256) in collect_releases task
Repo: https://github.com/confluentinc/azure-rest-api-specs
Task: augur.tasks.github.releases.tasks.collect_releases
Exception: DataError('(psycopg2.errors.StringDataRightTruncation) value too long for type character(256)\n')
Stack Trace
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.StringDataRightTruncation: value too long for type character(256)
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/github/releases/tasks.py", line 22, in collect_releases
releases_model(session, key_auth, logger, repo_git, repo_id)
File "/augur/augur/tasks/github/releases/core.py", line 205, in releases_model
insert_release(session, logger, repo_id, data['owner'], release, True)
File "/augur/augur/tasks/github/releases/core.py", line 88, in insert_release
bulk_insert_dicts(logger, release_inf,Release,['release_id'], string_fields=string_fields)
File "/augur/augur/application/db/lib.py", line 382, in bulk_insert_dicts
raise e
File "/augur/augur/application/db/lib.py", line 364, in bulk_insert_dicts
connection.execute(stmnt)
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.StringDataRightTruncation) value too long for type character(256)
[SQL: INSERT INTO augur_data.releases (release_id, repo_id, release_name, release_description, release_author, release_tag_name, tag_only) VALUES (%(release_id_m0)s, %(repo_id_m0)s, %(release_name_m0)s, %(release_description_m0)s, %(release_author_m0)s, %(release_tag_name_m0)s, %(tag_only_m0)s) ON CONFLICT (release_id) DO UPDATE SET release_id = coalesce(excluded.release_id, augur_data.releases.release_id), repo_id = coalesce(excluded.repo_id, augur_data.releases.repo_id), release_name = coalesce(excluded.release_name, augur_data.releases.release_name), release_description = coalesce(excluded.release_description, augur_data.releases.release_description), release_author = coalesce(excluded.release_author, augur_data.releases.release_author), release_tag_name = coalesce(excluded.release_tag_name, augur_data.releases.release_tag_name), tag_only = coalesce(excluded.tag_only, augur_data.releases.tag_only)]
[parameters: {'release_id_m0': 'MDM6UmVmMjE3NTc0MjU0OnJlZnMvdGFncy91cGRhdGUtZGV2LWFkaHlicmlkaGVhbHRoc2VydmljZS1NaWNyb3NvZnQuQURIeWJyaWRIZWFsdGhTZXJ2aWNlLTIwMTQtMDEtMDFfX3Jlc291cmNlLW1hbmFnZXJfYWRoeWJyaWRoZWFsdGhzZXJ2aWNlX01pY3Jvc29mdC5BREh5YnJpZEhlYWx0aFNlcnZpY2Vfc3RhYmxlXzIwMTQtMDEtMDFfcGFja2FnZS0yMDE0LTAx', 'repo_id_m0': 82504, 'release_name_m0': 'update-dev-adhybridhealthservice-Microsoft.ADHybridHealthService-2014-01-01__resource-manager_adhybridhealthservice_Microsoft.ADHybridHealthService_stable_2014-01-01_package-2014-01', 'release_description_m0': 'tag_only', 'release_author_m0': 'nobody', 'release_tag_name_m0': 'update-dev-adhybridhealthservice-Microsoft.ADHybridHealthService-2014-01-01__resource-manager_adhybridhealthservice_Microsoft.ADHybridHealthService_stable_2014-01-01_package-2014-01', 'tag_only_m0': True}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)
The offending value base64 decodes to 03:Ref217574254:refs/tags/update-dev-adhybridhealthservice-Microsoft.ADHybridHealthService-2014-01-01__resource-manager_adhybridhealthservice_Microsoft.ADHybridHealthService_stable_2014-01-01_package-2014-01