City of Chandler · Meeting 685 failed
2023-01-12 · Regular Meeting
Items: 9 / 9
Votes: 1
Votes: 1
City Council Regular Meeting
Synced: 2026-05-31 07:12 AZ
Last attempted: 2026-07-10 15:22 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/20221208_683/3361_ORDINANCE_NO._5045_-_Salary_Adjustments.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 ... 13258 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'document_title__0': 'Minutes of the Study Session Meeting of December 5, 2022', 'content_hash__0': None, 'body__0': 'chandler-cc', 'jurisdiction_id__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230112_689/3430_12052022_study_session_FINAL.pdf', 'agenda_item_number__0': '1', 'text_content__0': None, 'created_at__0': datetime.datetime(2026, 7, 10, 22, 22, 54, 241023, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'meeting_db_id__0': 1929, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 22, 54, 241030, tzinfo=datetime.timezone.utc), 'text_extracted_at__0': None, 'local_path__0': None, 'c_number_revision__0': None, 'c_number__0': None, 'meeting_id__0': '685', 'search_vector__0': None, 'agenda_item_id__0': 0, 'document_type__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 22, 54, 222702, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'file_name__0': None, 'c_number_base__0': None, 'extraction_duration_ms__0': None, 'document_title__1': 'Minutes of the Work Session of December 5, 2022', 'content_hash__1': None, 'body__1': 'chandler-cc', 'jurisdiction_id__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230112_689/3430_12052022_Work_Session_FINAL.pdf', 'agenda_item_number__1': '1', 'text_content__1': None, 'created_at__1': datetime.datetime(2026, 7, 10, 22, 22, 54, 241032, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'meeting_db_id__1': 1929, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 22, 54, 241032, tzinfo=datetime.timezone.utc), 'text_extracted_at__1': None, 'local_path__1': None, 'c_number_revision__1': None, 'c_number__1': None, 'meeting_id__1': '685', 'search_vector__1': None, 'agenda_item_id__1': 0, 'document_type__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 22, 54, 222823, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'file_name__1': None, 'c_number_base__1': None, 'extraction_duration_ms__1': None, 'document_title__2': 'Minutes of the Regular Meeting of December 5, 2022', 'content_hash__2': None ... 452 parameters truncated ... 'c_number_base__20': None, 'extraction_duration_ms__20': None, 'document_title__21': 'November 16, 2022 Study Session Minutes', 'content_hash__21': None, 'body__21': 'chandler-cc', 'jurisdiction_id__21': None, 'document_url__21': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230112_689/3398_11.16.2022_Study_Session.pdf', 'agenda_item_number__21': '9', 'text_content__21': None, 'created_at__21': datetime.datetime(2026, 7, 10, 22, 22, 54, 241065, tzinfo=datetime.timezone.utc), 'text_extraction_method__21': None, 'meeting_db_id__21': 1929, 'updated_at__21': datetime.datetime(2026, 7, 10, 22, 22, 54, 241066, tzinfo=datetime.timezone.utc), 'text_extracted_at__21': None, 'local_path__21': None, 'c_number_revision__21': None, 'c_number__21': None, 'meeting_id__21': '685', 'search_vector__21': None, 'agenda_item_id__21': 0, 'document_type__21': None, 'scraped_at__21': datetime.datetime(2026, 7, 10, 22, 22, 54, 224294, tzinfo=datetime.timezone.utc), 'file_extension__21': 'pdf', 'file_name__21': None, 'c_number_base__21': None, 'extraction_duration_ms__21': None, 'document_title__22': 'November 16, 2022 Regular Meeting Minutes', 'content_hash__22': None, 'body__22': 'chandler-cc', 'jurisdiction_id__22': None, 'document_url__22': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230112_689/3398_11.16.2022_Regular_Meeting.pdf', 'agenda_item_number__22': '9', 'text_content__22': None, 'created_at__22': datetime.datetime(2026, 7, 10, 22, 22, 54, 241067, tzinfo=datetime.timezone.utc), 'text_extraction_method__22': None, 'meeting_db_id__22': 1929, 'updated_at__22': datetime.datetime(2026, 7, 10, 22, 22, 54, 241067, tzinfo=datetime.timezone.utc), 'text_extracted_at__22': None, 'local_path__22': None, 'c_number_revision__22': None, 'c_number__22': None, 'meeting_id__22': '685', 'search_vector__22': None, 'agenda_item_id__22': 0, 'document_type__22': None, 'scraped_at__22': datetime.datetime(2026, 7, 10, 22, 22, 54, 224367, tzinfo=datetime.timezone.utc), 'file_extension__22': 'pdf', 'file_name__22': None, 'c_number_base__22': None, 'extraction_duration_ms__22': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 15:22 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/20221208_683/3361_ORDINANCE_NO._5045_-_Salary_Adjustments.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 ... 13258 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'document_title__0': 'Minutes of the Study Session Meeting of December 5, 2022', 'content_hash__0': None, 'body__0': 'chandler-cc', 'jurisdiction_id__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230112_689/3430_12052022_study_session_FINAL.pdf', 'agenda_item_number__0': '1', 'text_content__0': None, 'created_at__0': datetime.datetime(2026, 7, 10, 22, 22, 54, 241023, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'meeting_db_id__0': 1929, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 22, 54, 241030, tzinfo=datetime.timezone.utc), 'text_extracted_at__0': None, 'local_path__0': None, 'c_number_revision__0': None, 'c_number__0': None, 'meeting_id__0': '685', 'search_vector__0': None, 'agenda_item_id__0': 0, 'document_type__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 22, 54, 222702, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'file_name__0': None, 'c_number_base__0': None, 'extraction_duration_ms__0': None, 'document_title__1': 'Minutes of the Work Session of December 5, 2022', 'content_hash__1': None, 'body__1': 'chandler-cc', 'jurisdiction_id__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230112_689/3430_12052022_Work_Session_FINAL.pdf', 'agenda_item_number__1': '1', 'text_content__1': None, 'created_at__1': datetime.datetime(2026, 7, 10, 22, 22, 54, 241032, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'meeting_db_id__1': 1929, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 22, 54, 241032, tzinfo=datetime.timezone.utc), 'text_extracted_at__1': None, 'local_path__1': None, 'c_number_revision__1': None, 'c_number__1': None, 'meeting_id__1': '685', 'search_vector__1': None, 'agenda_item_id__1': 0, 'document_type__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 22, 54, 222823, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'file_name__1': None, 'c_number_base__1': None, 'extraction_duration_ms__1': None, 'document_title__2': 'Minutes of the Regular Meeting of December 5, 2022', 'content_hash__2': None ... 452 parameters truncated ... 'c_number_base__20': None, 'extraction_duration_ms__20': None, 'document_title__21': 'November 16, 2022 Study Session Minutes', 'content_hash__21': None, 'body__21': 'chandler-cc', 'jurisdiction_id__21': None, 'document_url__21': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230112_689/3398_11.16.2022_Study_Session.pdf', 'agenda_item_number__21': '9', 'text_content__21': None, 'created_at__21': datetime.datetime(2026, 7, 10, 22, 22, 54, 241065, tzinfo=datetime.timezone.utc), 'text_extraction_method__21': None, 'meeting_db_id__21': 1929, 'updated_at__21': datetime.datetime(2026, 7, 10, 22, 22, 54, 241066, tzinfo=datetime.timezone.utc), 'text_extracted_at__21': None, 'local_path__21': None, 'c_number_revision__21': None, 'c_number__21': None, 'meeting_id__21': '685', 'search_vector__21': None, 'agenda_item_id__21': 0, 'document_type__21': None, 'scraped_at__21': datetime.datetime(2026, 7, 10, 22, 22, 54, 224294, tzinfo=datetime.timezone.utc), 'file_extension__21': 'pdf', 'file_name__21': None, 'c_number_base__21': None, 'extraction_duration_ms__21': None, 'document_title__22': 'November 16, 2022 Regular Meeting Minutes', 'content_hash__22': None, 'body__22': 'chandler-cc', 'jurisdiction_id__22': None, 'document_url__22': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230112_689/3398_11.16.2022_Regular_Meeting.pdf', 'agenda_item_number__22': '9', 'text_content__22': None, 'created_at__22': datetime.datetime(2026, 7, 10, 22, 22, 54, 241067, tzinfo=datetime.timezone.utc), 'text_extraction_method__22': None, 'meeting_db_id__22': 1929, 'updated_at__22': datetime.datetime(2026, 7, 10, 22, 22, 54, 241067, tzinfo=datetime.timezone.utc), 'text_extracted_at__22': None, 'local_path__22': None, 'c_number_revision__22': None, 'c_number__22': None, 'meeting_id__22': '685', 'search_vector__22': None, 'agenda_item_id__22': 0, 'document_type__22': None, 'scraped_at__22': datetime.datetime(2026, 7, 10, 22, 22, 54, 224367, tzinfo=datetime.timezone.utc), 'file_extension__22': 'pdf', 'file_name__22': None, 'c_number_base__22': None, 'extraction_duration_ms__22': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
9 item(s)