Name: Study Session Meeting — City Council Study Session — Dec 6, 2021
Start: 2021-12-06

← Back to meetings

City of Chandler · Meeting 255 failed

2021-12-06 · Study Session

Items: 76 / 76

City Council Study Session

View on Agenda Online ↗

Synced: 2026-06-03 13:19 AZ
Last attempted: 2026-07-10 15:02 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/2021/CC/20211206_255/984_Resolution_5538_-_Joint_Project_Agreement_with_ADOA_re_Loop_101_and_202_Freeway.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 ... 64969 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '255', 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 2, 26, 160906, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211206_255/984_Resolution_5538_-_Joint_Project_Agreement_with_ADOA_re_Loop_101_and_202_Freeway.pdf', 'meeting_db_id__0': 4744, 'text_extracted_at__0': None, 'content_hash__0': None, 'extraction_duration_ms__0': None, 'text_extraction_method__0': None, 'agenda_item_number__0': '2', 'text_content__0': None, 'body__0': 'chandler-cc', 'document_type__0': None, 'c_number_revision__0': None, 'c_number_base__0': None, 'local_path__0': None, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 2, 26, 209476, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 22, 2, 26, 209467, tzinfo=datetime.timezone.utc), 'document_title__0': 'Resolution No. 5538', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '255', 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 2, 26, 160964, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211206_255/984_JPA_ADOA_City_of_Chandler_FINAL__%281%29.pdf', 'meeting_db_id__1': 4744, 'text_extracted_at__1': None, 'content_hash__1': None, 'extraction_duration_ms__1': None, 'text_extraction_method__1': None, 'agenda_item_number__1': '2', 'text_content__1': None, 'body__1': 'chandler-cc', 'document_type__1': None, 'c_number_revision__1': None, 'c_number_base__1': None, 'local_path__1': None, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 2, 26, 209480, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 22, 2, 26, 209479, tzinfo=datetime.timezone.utc), 'document_title__1': 'JPA ADOA Loop 101 Watermain', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '255', 'scraped_at__2': datetime.datetime(2026, 7, 10, 22, 2, 26, 160995, tzinfo=datetime.timezone.utc) ... 2660 parameters truncated ... 'file_name__112': None, 'jurisdiction_id__112': None, 'meeting_id__113': '255', 'scraped_at__113': datetime.datetime(2026, 7, 10, 22, 2, 26, 164498, tzinfo=datetime.timezone.utc), 'file_extension__113': 'pdf', 'c_number__113': None, 'document_url__113': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211206_255/1095_Signed_Reg_Meeting_Sept_15_%281%29.pdf', 'meeting_db_id__113': 4744, 'text_extracted_at__113': None, 'content_hash__113': None, 'extraction_duration_ms__113': None, 'text_extraction_method__113': None, 'agenda_item_number__113': '72', 'text_content__113': None, 'body__113': 'chandler-cc', 'document_type__113': None, 'c_number_revision__113': None, 'c_number_base__113': None, 'local_path__113': None, 'updated_at__113': datetime.datetime(2026, 7, 10, 22, 2, 26, 209791, tzinfo=datetime.timezone.utc), 'agenda_item_id__113': 0, 'created_at__113': datetime.datetime(2026, 7, 10, 22, 2, 26, 209790, tzinfo=datetime.timezone.utc), 'document_title__113': 'September 15, 2021 Regular Meeting Minutes', 'search_vector__113': None, 'file_name__113': None, 'jurisdiction_id__113': None, 'meeting_id__114': '255', 'scraped_at__114': datetime.datetime(2026, 7, 10, 22, 2, 26, 164527, tzinfo=datetime.timezone.utc), 'file_extension__114': 'pdf', 'c_number__114': None, 'document_url__114': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211206_255/1095_Signed_Study_Session_Sept_15.pdf', 'meeting_db_id__114': 4744, 'text_extracted_at__114': None, 'content_hash__114': None, 'extraction_duration_ms__114': None, 'text_extraction_method__114': None, 'agenda_item_number__114': '72', 'text_content__114': None, 'body__114': 'chandler-cc', 'document_type__114': None, 'c_number_revision__114': None, 'c_number_base__114': None, 'local_path__114': None, 'updated_at__114': datetime.datetime(2026, 7, 10, 22, 2, 26, 209794, tzinfo=datetime.timezone.utc), 'agenda_item_id__114': 0, 'created_at__114': datetime.datetime(2026, 7, 10, 22, 2, 26, 209792, tzinfo=datetime.timezone.utc), 'document_title__114': 'September 15, 2021 Study Session Minutes', 'search_vector__114': None, 'file_name__114': None, 'jurisdiction_id__114': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)