City of Chandler · Meeting 2197 failed
2026-04-07 · Regular Meeting
Items: 4 / 4
Citizens' Panel Review
Synced: 2026-05-31 04:43 AZ
Last attempted: 2026-07-10 16:43 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/2026/CPRPCUF/20260407_2201/9588_1.6.2026_Meeting_MinutesFINALpdf.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 ... 1740 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'created_at__0': datetime.datetime(2026, 7, 10, 23, 43, 55, 700466, tzinfo=datetime.timezone.utc), 'updated_at__0': datetime.datetime(2026, 7, 10, 23, 43, 55, 700471, tzinfo=datetime.timezone.utc), 'body__0': 'chandler-cc', 'document_type__0': None, 'jurisdiction_id__0': None, 'extraction_duration_ms__0': None, 'c_number_revision__0': None, 'agenda_item_number__0': '1', 'file_extension__0': 'pdf', 'text_extraction_method__0': None, 'c_number_base__0': None, 'file_name__0': None, 'c_number__0': None, 'text_extracted_at__0': None, 'text_content__0': None, 'search_vector__0': None, 'document_title__0': 'January 6 2026 Meeting Minutes', 'scraped_at__0': datetime.datetime(2026, 7, 10, 23, 43, 55, 690285, tzinfo=datetime.timezone.utc), 'content_hash__0': None, 'meeting_id__0': '2197', 'local_path__0': None, 'meeting_db_id__0': 8016, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2026/CPRPCUF/20260407_2201/9588_1.6.2026_Meeting_MinutesFINALpdf.pdf', 'agenda_item_id__0': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 23, 43, 55, 700472, tzinfo=datetime.timezone.utc), 'updated_at__1': datetime.datetime(2026, 7, 10, 23, 43, 55, 700473, tzinfo=datetime.timezone.utc), 'body__1': 'chandler-cc', 'document_type__1': None, 'jurisdiction_id__1': None, 'extraction_duration_ms__1': None, 'c_number_revision__1': None, 'agenda_item_number__1': '3', 'file_extension__1': 'pdf', 'text_extraction_method__1': None, 'c_number_base__1': None, 'file_name__1': None, 'c_number__1': None, 'text_extracted_at__1': None, 'text_content__1': None, 'search_vector__1': None, 'document_title__1': 'Use of Force fourth quarter', 'scraped_at__1': datetime.datetime(2026, 7, 10, 23, 43, 55, 690339, tzinfo=datetime.timezone.utc), 'content_hash__1': None, 'meeting_id__1': '2197', 'local_path__1': None, 'meeting_db_id__1': 8016, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2026/CPRPCUF/20260407_2201/9684_Citizens%27_Panel_Use_of_Force.pdf', 'agenda_item_id__1': 0}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 16:43 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/2026/CPRPCUF/20260407_2201/9588_1.6.2026_Meeting_MinutesFINALpdf.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 ... 1740 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'created_at__0': datetime.datetime(2026, 7, 10, 23, 43, 55, 700466, tzinfo=datetime.timezone.utc), 'updated_at__0': datetime.datetime(2026, 7, 10, 23, 43, 55, 700471, tzinfo=datetime.timezone.utc), 'body__0': 'chandler-cc', 'document_type__0': None, 'jurisdiction_id__0': None, 'extraction_duration_ms__0': None, 'c_number_revision__0': None, 'agenda_item_number__0': '1', 'file_extension__0': 'pdf', 'text_extraction_method__0': None, 'c_number_base__0': None, 'file_name__0': None, 'c_number__0': None, 'text_extracted_at__0': None, 'text_content__0': None, 'search_vector__0': None, 'document_title__0': 'January 6 2026 Meeting Minutes', 'scraped_at__0': datetime.datetime(2026, 7, 10, 23, 43, 55, 690285, tzinfo=datetime.timezone.utc), 'content_hash__0': None, 'meeting_id__0': '2197', 'local_path__0': None, 'meeting_db_id__0': 8016, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2026/CPRPCUF/20260407_2201/9588_1.6.2026_Meeting_MinutesFINALpdf.pdf', 'agenda_item_id__0': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 23, 43, 55, 700472, tzinfo=datetime.timezone.utc), 'updated_at__1': datetime.datetime(2026, 7, 10, 23, 43, 55, 700473, tzinfo=datetime.timezone.utc), 'body__1': 'chandler-cc', 'document_type__1': None, 'jurisdiction_id__1': None, 'extraction_duration_ms__1': None, 'c_number_revision__1': None, 'agenda_item_number__1': '3', 'file_extension__1': 'pdf', 'text_extraction_method__1': None, 'c_number_base__1': None, 'file_name__1': None, 'c_number__1': None, 'text_extracted_at__1': None, 'text_content__1': None, 'search_vector__1': None, 'document_title__1': 'Use of Force fourth quarter', 'scraped_at__1': datetime.datetime(2026, 7, 10, 23, 43, 55, 690339, tzinfo=datetime.timezone.utc), 'content_hash__1': None, 'meeting_id__1': '2197', 'local_path__1': None, 'meeting_db_id__1': 8016, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2026/CPRPCUF/20260407_2201/9684_Citizens%27_Panel_Use_of_Force.pdf', 'agenda_item_id__1': 0}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
4 item(s)