augur icon indicating copy to clipboard operation
augur copied to clipboard

value too long for type character(256) in collect_releases task

Open MoralCode opened this issue 1 week ago • 1 comments

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)

MoralCode avatar Dec 11 '25 20:12 MoralCode

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

MoralCode avatar Dec 12 '25 18:12 MoralCode