Name: Study Session Meeting — City Council Study Session — Mar 21, 2022
Start: 2022-03-21

← Back to meetings

City of Chandler · Meeting 379 failed

2022-03-21 · Study Session

Items: 58 / 58

City Council Study Session

View on Agenda Online ↗

Synced: 2026-05-31 07:12 AZ
Last attempted: 2026-07-10 15:06 AZ
Retries: 1
Last error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_supporting_doc_item_url" DETAIL: Key (agenda_item_id, document_url)=(0, https://public.destinyhosted.com/chanddocs/2022/CC/20220321_379/1664_AI2103.401_Initialed-Signed.pdf) already exists. [SQL: INSERT INTO supporting_documents (body, agenda_item_id, meeting_id, meeting_db_id, agenda_item_number, c_number, c_number_base, c_number_revision, document_title, document_url, document_type, file_name, file_extension, local_path, content_hash, scrap ... 54550 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'text_content__0': None, 'document_type__0': None, 'search_vector__0': None, 'content_hash__0': None, 'text_extracted_at__0': None, 'local_path__0': None, 'c_number_base__0': None, 'agenda_item_number__0': '1', 'agenda_item_id__0': 0, 'c_number__0': None, 'c_number_revision__0': None, 'jurisdiction_id__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 6, 24, 234202, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 6, 24, 289345, tzinfo=datetime.timezone.utc), 'meeting_db_id__0': 4801, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220321_379/1664_AI2103.401_Initialed-Signed.pdf', 'meeting_id__0': '379', 'created_at__0': datetime.datetime(2026, 7, 10, 22, 6, 24, 289334, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'extraction_duration_ms__0': None, 'document_title__0': 'Project Agreement', 'body__0': 'chandler-cc', 'file_name__0': None, 'text_content__1': None, 'document_type__1': None, 'search_vector__1': None, 'content_hash__1': None, 'text_extracted_at__1': None, 'local_path__1': None, 'c_number_base__1': None, 'agenda_item_number__1': '1', 'agenda_item_id__1': 0, 'c_number__1': None, 'c_number_revision__1': None, 'jurisdiction_id__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 6, 24, 234311, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 6, 24, 289348, tzinfo=datetime.timezone.utc), 'meeting_db_id__1': 4801, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220321_379/1664_CP22-135_Location_Map.pdf', 'meeting_id__1': '379', 'created_at__1': datetime.datetime(2026, 7, 10, 22, 6, 24, 289347, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'extraction_duration_ms__1': None, 'document_title__1': 'Location Map', 'body__1': 'chandler-cc', 'file_name__1': None, 'text_content__2': None, 'document_type__2': None ... 2228 parameters truncated ... 'body__94': 'chandler-cc', 'file_name__94': None, 'text_content__95': None, 'document_type__95': None, 'search_vector__95': None, 'content_hash__95': None, 'text_extracted_at__95': None, 'local_path__95': None, 'c_number_base__95': None, 'agenda_item_number__95': '54', 'agenda_item_id__95': 0, 'c_number__95': None, 'c_number_revision__95': None, 'jurisdiction_id__95': None, 'scraped_at__95': datetime.datetime(2026, 7, 10, 22, 6, 24, 240788, tzinfo=datetime.timezone.utc), 'file_extension__95': 'pdf', 'updated_at__95': datetime.datetime(2026, 7, 10, 22, 6, 24, 289610, tzinfo=datetime.timezone.utc), 'meeting_db_id__95': 4801, 'document_url__95': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220321_379/1737_01.19.2022_PZ_Study_Session_Minutes.pdf', 'meeting_id__95': '379', 'created_at__95': datetime.datetime(2026, 7, 10, 22, 6, 24, 289609, tzinfo=datetime.timezone.utc), 'text_extraction_method__95': None, 'extraction_duration_ms__95': None, 'document_title__95': 'January 19, 2022 Study Session Minutes', 'body__95': 'chandler-cc', 'file_name__95': None, 'text_content__96': None, 'document_type__96': None, 'search_vector__96': None, 'content_hash__96': None, 'text_extracted_at__96': None, 'local_path__96': None, 'c_number_base__96': None, 'agenda_item_number__96': '54', 'agenda_item_id__96': 0, 'c_number__96': None, 'c_number_revision__96': None, 'jurisdiction_id__96': None, 'scraped_at__96': datetime.datetime(2026, 7, 10, 22, 6, 24, 240855, tzinfo=datetime.timezone.utc), 'file_extension__96': 'pdf', 'updated_at__96': datetime.datetime(2026, 7, 10, 22, 6, 24, 289612, tzinfo=datetime.timezone.utc), 'meeting_db_id__96': 4801, 'document_url__96': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220321_379/1737_01.19.2022_PZ_Regular_Meeting_Minutes.pdf', 'meeting_id__96': '379', 'created_at__96': datetime.datetime(2026, 7, 10, 22, 6, 24, 289611, tzinfo=datetime.timezone.utc), 'text_extraction_method__96': None, 'extraction_duration_ms__96': None, 'document_title__96': 'January 19, 2022, 2021 Regular Meeting Minutes', 'body__96': 'chandler-cc', 'file_name__96': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)