Name: Study Session Meeting — City Council Study Session — Oct 24, 2022
Start: 2022-10-24

← Back to meetings

City of Chandler · Meeting 579 failed

2022-10-24 · Study Session

Items: 67 / 67
Votes: 1

City Council Study Session

View on Agenda Online ↗

Synced: 2026-05-27 14:07 AZ
Last attempted: 2026-07-10 15:17 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/20221024_583/3014_Resolution_5634_-_Protected_Bike_Lanes_IGA.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 ... 42832 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': '2', '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, 17, 46, 511914, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 17, 46, 548592, tzinfo=datetime.timezone.utc), 'meeting_db_id__0': 4953, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2022/CC/20221024_583/3014_Resolution_5634_-_Protected_Bike_Lanes_IGA.pdf', 'meeting_id__0': '579', 'created_at__0': datetime.datetime(2026, 7, 10, 22, 17, 46, 548585, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'extraction_duration_ms__0': None, 'document_title__0': 'Resolution 5634', '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': '2', '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, 17, 46, 512013, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 17, 46, 548596, tzinfo=datetime.timezone.utc), 'meeting_db_id__1': 4953, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2022/CC/20221024_583/3014_%23_1137-0C_Agreement_with_City_of_Chandler_TO_11_Amended.pdf', 'meeting_id__1': '579', 'created_at__1': datetime.datetime(2026, 7, 10, 22, 17, 46, 548595, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'extraction_duration_ms__1': None, 'document_title__1': 'MAG Agreement for Protected Bike Lanes Study', 'body__1': 'chandler-cc', 'file_name__1': None, 'text_content__2': None, 'document_type__2': None ... 1724 parameters truncated ... 'body__73': 'chandler-cc', 'file_name__73': None, 'text_content__74': None, 'document_type__74': None, 'search_vector__74': None, 'content_hash__74': None, 'text_extracted_at__74': None, 'local_path__74': None, 'c_number_base__74': None, 'agenda_item_number__74': '56', 'agenda_item_id__74': 0, 'c_number__74': None, 'c_number_revision__74': None, 'jurisdiction_id__74': None, 'scraped_at__74': datetime.datetime(2026, 7, 10, 22, 17, 46, 517105, tzinfo=datetime.timezone.utc), 'file_extension__74': 'pdf', 'updated_at__74': datetime.datetime(2026, 7, 10, 22, 17, 46, 548788, tzinfo=datetime.timezone.utc), 'meeting_db_id__74': 4953, 'document_url__74': 'https://public.destinyhosted.com/chanddocs/2022/CC/20221024_583/3075_10.27.22_Special_Event_Liquor_and_Liquor_License_Extensions.pdf', 'meeting_id__74': '579', 'created_at__74': datetime.datetime(2026, 7, 10, 22, 17, 46, 548786, tzinfo=datetime.timezone.utc), 'text_extraction_method__74': None, 'extraction_duration_ms__74': None, 'document_title__74': 'Special Event Liquor Licenses and Temp/Perm Ext. Administratively Approved', 'body__74': 'chandler-cc', 'file_name__74': None, 'text_content__75': None, 'document_type__75': None, 'search_vector__75': None, 'content_hash__75': None, 'text_extracted_at__75': None, 'local_path__75': None, 'c_number_base__75': None, 'agenda_item_number__75': '57', 'agenda_item_id__75': 0, 'c_number__75': None, 'c_number_revision__75': None, 'jurisdiction_id__75': None, 'scraped_at__75': datetime.datetime(2026, 7, 10, 22, 17, 46, 517174, tzinfo=datetime.timezone.utc), 'file_extension__75': 'pdf', 'updated_at__75': datetime.datetime(2026, 7, 10, 22, 17, 46, 548790, tzinfo=datetime.timezone.utc), 'meeting_db_id__75': 4953, 'document_url__75': 'https://public.destinyhosted.com/chanddocs/2022/CC/20221024_583/3048_7-1-22_to_9-30-22_AP_Claims_Report.pdf', 'meeting_id__75': '579', 'created_at__75': datetime.datetime(2026, 7, 10, 22, 17, 46, 548789, tzinfo=datetime.timezone.utc), 'text_extraction_method__75': None, 'extraction_duration_ms__75': None, 'document_title__75': 'Claims Report - July 1 - September 30, 2022', 'body__75': 'chandler-cc', 'file_name__75': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)