Name: Study Session Meeting — City Council Study Session — Jul 12, 2021
Start: 2021-07-12

← Back to meetings

City of Chandler · Meeting 123 failed

2021-07-12 · Study Session

Items: 40 / 40

City Council Study Session

View on Agenda Online ↗

Synced: 2026-06-03 13:19 AZ
Last attempted: 2026-07-10 14:54 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/20210621_110/468_CP21-129_Location_Map.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 ... 32788 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '123', 'scraped_at__0': datetime.datetime(2026, 7, 10, 21, 54, 55, 19522, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210621_110/468_CP21-129_Location_Map.pdf', 'meeting_db_id__0': 4669, '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, 21, 54, 55, 51235, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 21, 54, 55, 51227, tzinfo=datetime.timezone.utc), 'document_title__0': 'Location Map', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '123', 'scraped_at__1': datetime.datetime(2026, 7, 10, 21, 54, 55, 19635, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210621_110/468_Park_and_Ride_Shade_Canopies_Phase_II.pdf', 'meeting_db_id__1': 4669, '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, 21, 54, 55, 51239, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 21, 54, 55, 51237, tzinfo=datetime.timezone.utc), 'document_title__1': 'Contract - TSG Constructors', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '123', 'scraped_at__2': datetime.datetime(2026, 7, 10, 21, 54, 55, 19708, tzinfo=datetime.timezone.utc) ... 1292 parameters truncated ... 'file_name__55': None, 'jurisdiction_id__55': None, 'meeting_id__56': '123', 'scraped_at__56': datetime.datetime(2026, 7, 10, 21, 54, 55, 23542, tzinfo=datetime.timezone.utc), 'file_extension__56': 'pdf', 'c_number__56': None, 'document_url__56': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210712_123/570_Signed_June_2_Meeting_Minutes_.pdf', 'meeting_db_id__56': 4669, 'text_extracted_at__56': None, 'content_hash__56': None, 'extraction_duration_ms__56': None, 'text_extraction_method__56': None, 'agenda_item_number__56': '37', 'text_content__56': None, 'body__56': 'chandler-cc', 'document_type__56': None, 'c_number_revision__56': None, 'c_number_base__56': None, 'local_path__56': None, 'updated_at__56': datetime.datetime(2026, 7, 10, 21, 54, 55, 51383, tzinfo=datetime.timezone.utc), 'agenda_item_id__56': 0, 'created_at__56': datetime.datetime(2026, 7, 10, 21, 54, 55, 51382, tzinfo=datetime.timezone.utc), 'document_title__56': 'June 2, 2021 Regular Meeting Minutes', 'search_vector__56': None, 'file_name__56': None, 'jurisdiction_id__56': None, 'meeting_id__57': '123', 'scraped_at__57': datetime.datetime(2026, 7, 10, 21, 54, 55, 23613, tzinfo=datetime.timezone.utc), 'file_extension__57': 'pdf', 'c_number__57': None, 'document_url__57': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210712_123/580_July_15%2C_2021_Special_Event_Liquor_and_Liquor_License_Extensions.pdf', 'meeting_db_id__57': 4669, 'text_extracted_at__57': None, 'content_hash__57': None, 'extraction_duration_ms__57': None, 'text_extraction_method__57': None, 'agenda_item_number__57': '38', 'text_content__57': None, 'body__57': 'chandler-cc', 'document_type__57': None, 'c_number_revision__57': None, 'c_number_base__57': None, 'local_path__57': None, 'updated_at__57': datetime.datetime(2026, 7, 10, 21, 54, 55, 51386, tzinfo=datetime.timezone.utc), 'agenda_item_id__57': 0, 'created_at__57': datetime.datetime(2026, 7, 10, 21, 54, 55, 51385, tzinfo=datetime.timezone.utc), 'document_title__57': 'Special Event Liquor and Extensions of Liquor License Premises', 'search_vector__57': None, 'file_name__57': None, 'jurisdiction_id__57': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)