City of Chandler · Meeting 458 failed
2022-05-12 · Regular Meeting
Items: 19 / 19
City Council Regular Meeting
Synced: 2026-05-31 07:13 AZ
Last attempted: 2026-07-10 15:09 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/20220425_402/1873_Ordinance_No_5007_-_Chapters_44_and_50.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 ... 21070 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, 9, 32, 790573, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 9, 32, 825880, tzinfo=datetime.timezone.utc), 'meeting_db_id__0': 4851, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220509_429/2019_04252022_Work_Session_FINAL.pdf', 'meeting_id__0': '458', 'created_at__0': datetime.datetime(2026, 7, 10, 22, 9, 32, 825865, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'extraction_duration_ms__0': None, 'document_title__0': 'Minutes of the Work Session of April 25, 2022', '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, 9, 32, 790646, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 9, 32, 825884, tzinfo=datetime.timezone.utc), 'meeting_db_id__1': 4851, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220509_429/2019_04252022_study_session_FINAL.pdf', 'meeting_id__1': '458', 'created_at__1': datetime.datetime(2026, 7, 10, 22, 9, 32, 825882, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'extraction_duration_ms__1': None, 'document_title__1': 'Minutes of the Study Session of April 25, 2022', 'body__1': 'chandler-cc', 'file_name__1': None, 'text_content__2': None, 'document_type__2': None ... 788 parameters truncated ... 'body__34': 'chandler-cc', 'file_name__34': None, 'text_content__35': None, 'document_type__35': None, 'search_vector__35': None, 'content_hash__35': None, 'text_extracted_at__35': None, 'local_path__35': None, 'c_number_base__35': None, 'agenda_item_number__35': '19', 'agenda_item_id__35': 0, 'c_number__35': None, 'c_number_revision__35': None, 'jurisdiction_id__35': None, 'scraped_at__35': datetime.datetime(2026, 7, 10, 22, 9, 32, 793347, tzinfo=datetime.timezone.utc), 'file_extension__35': 'pdf', 'updated_at__35': datetime.datetime(2026, 7, 10, 22, 9, 32, 825982, tzinfo=datetime.timezone.utc), 'meeting_db_id__35': 4851, 'document_url__35': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220509_429/1977_03.16.2022_Study_Session_signed.pdf', 'meeting_id__35': '458', 'created_at__35': datetime.datetime(2026, 7, 10, 22, 9, 32, 825981, tzinfo=datetime.timezone.utc), 'text_extraction_method__35': None, 'extraction_duration_ms__35': None, 'document_title__35': 'March 16, 2022 Study Session Minutes', 'body__35': 'chandler-cc', 'file_name__35': None, 'text_content__36': None, 'document_type__36': None, 'search_vector__36': None, 'content_hash__36': None, 'text_extracted_at__36': None, 'local_path__36': None, 'c_number_base__36': None, 'agenda_item_number__36': '19', 'agenda_item_id__36': 0, 'c_number__36': None, 'c_number_revision__36': None, 'jurisdiction_id__36': None, 'scraped_at__36': datetime.datetime(2026, 7, 10, 22, 9, 32, 793372, tzinfo=datetime.timezone.utc), 'file_extension__36': 'pdf', 'updated_at__36': datetime.datetime(2026, 7, 10, 22, 9, 32, 825985, tzinfo=datetime.timezone.utc), 'meeting_db_id__36': 4851, 'document_url__36': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220509_429/1977_03.16.2022_Regular_Meeting_signed.pdf', 'meeting_id__36': '458', 'created_at__36': datetime.datetime(2026, 7, 10, 22, 9, 32, 825983, tzinfo=datetime.timezone.utc), 'text_extraction_method__36': None, 'extraction_duration_ms__36': None, 'document_title__36': 'March 16, 2022 Regular Meeting Minutes', 'body__36': 'chandler-cc', 'file_name__36': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 15:09 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/20220425_402/1873_Ordinance_No_5007_-_Chapters_44_and_50.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 ... 21070 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, 9, 32, 790573, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 9, 32, 825880, tzinfo=datetime.timezone.utc), 'meeting_db_id__0': 4851, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220509_429/2019_04252022_Work_Session_FINAL.pdf', 'meeting_id__0': '458', 'created_at__0': datetime.datetime(2026, 7, 10, 22, 9, 32, 825865, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'extraction_duration_ms__0': None, 'document_title__0': 'Minutes of the Work Session of April 25, 2022', '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, 9, 32, 790646, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 9, 32, 825884, tzinfo=datetime.timezone.utc), 'meeting_db_id__1': 4851, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220509_429/2019_04252022_study_session_FINAL.pdf', 'meeting_id__1': '458', 'created_at__1': datetime.datetime(2026, 7, 10, 22, 9, 32, 825882, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'extraction_duration_ms__1': None, 'document_title__1': 'Minutes of the Study Session of April 25, 2022', 'body__1': 'chandler-cc', 'file_name__1': None, 'text_content__2': None, 'document_type__2': None ... 788 parameters truncated ... 'body__34': 'chandler-cc', 'file_name__34': None, 'text_content__35': None, 'document_type__35': None, 'search_vector__35': None, 'content_hash__35': None, 'text_extracted_at__35': None, 'local_path__35': None, 'c_number_base__35': None, 'agenda_item_number__35': '19', 'agenda_item_id__35': 0, 'c_number__35': None, 'c_number_revision__35': None, 'jurisdiction_id__35': None, 'scraped_at__35': datetime.datetime(2026, 7, 10, 22, 9, 32, 793347, tzinfo=datetime.timezone.utc), 'file_extension__35': 'pdf', 'updated_at__35': datetime.datetime(2026, 7, 10, 22, 9, 32, 825982, tzinfo=datetime.timezone.utc), 'meeting_db_id__35': 4851, 'document_url__35': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220509_429/1977_03.16.2022_Study_Session_signed.pdf', 'meeting_id__35': '458', 'created_at__35': datetime.datetime(2026, 7, 10, 22, 9, 32, 825981, tzinfo=datetime.timezone.utc), 'text_extraction_method__35': None, 'extraction_duration_ms__35': None, 'document_title__35': 'March 16, 2022 Study Session Minutes', 'body__35': 'chandler-cc', 'file_name__35': None, 'text_content__36': None, 'document_type__36': None, 'search_vector__36': None, 'content_hash__36': None, 'text_extracted_at__36': None, 'local_path__36': None, 'c_number_base__36': None, 'agenda_item_number__36': '19', 'agenda_item_id__36': 0, 'c_number__36': None, 'c_number_revision__36': None, 'jurisdiction_id__36': None, 'scraped_at__36': datetime.datetime(2026, 7, 10, 22, 9, 32, 793372, tzinfo=datetime.timezone.utc), 'file_extension__36': 'pdf', 'updated_at__36': datetime.datetime(2026, 7, 10, 22, 9, 32, 825985, tzinfo=datetime.timezone.utc), 'meeting_db_id__36': 4851, 'document_url__36': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220509_429/1977_03.16.2022_Regular_Meeting_signed.pdf', 'meeting_id__36': '458', 'created_at__36': datetime.datetime(2026, 7, 10, 22, 9, 32, 825983, tzinfo=datetime.timezone.utc), 'text_extraction_method__36': None, 'extraction_duration_ms__36': None, 'document_title__36': 'March 16, 2022 Regular Meeting Minutes', 'body__36': 'chandler-cc', 'file_name__36': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
19 item(s)