City of Chandler · Meeting 823 failed
2023-04-10 · Study Session
Items: 23 / 23
City Council Study Session
Synced: 2026-05-31 07:13 AZ
Last attempted: 2026-07-10 15:28 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/2023/CC/20230410_827/3858_03202023_work_session_budget_workshop_2_FINAL.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 ... 19396 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 Work Session - Budget Workshop #2 of March 20, 2023', 'content_hash__0': None, 'body__0': 'chandler-cc', 'jurisdiction_id__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230410_827/3858_03202023_work_session_budget_workshop_2_FINAL.pdf', 'agenda_item_number__0': '1', 'text_content__0': None, 'created_at__0': datetime.datetime(2026, 7, 10, 22, 28, 2, 224340, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'meeting_db_id__0': 3876, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 28, 2, 224348, 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': '823', 'search_vector__0': None, 'agenda_item_id__0': 0, 'document_type__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 28, 2, 200075, 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 Regular Meeting of March 20, 2023', 'content_hash__1': None, 'body__1': 'chandler-cc', 'jurisdiction_id__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230410_827/3858_03202023_regular_FINAL.pdf', 'agenda_item_number__1': '1', 'text_content__1': None, 'created_at__1': datetime.datetime(2026, 7, 10, 22, 28, 2, 224351, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'meeting_db_id__1': 3876, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 28, 2, 224352, 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': '823', 'search_vector__1': None, 'agenda_item_id__1': 0, 'document_type__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 28, 2, 200149, 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 Study Session of March 20, 2023', 'content_hash__2': None ... 716 parameters truncated ... 'c_number_base__31': None, 'extraction_duration_ms__31': None, 'document_title__32': 'Agreement - Technology Construction', 'content_hash__32': None, 'body__32': 'chandler-cc', 'jurisdiction_id__32': None, 'document_url__32': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230410_827/3752_ST2110.401_READY_3.pdf', 'agenda_item_number__32': '16', 'text_content__32': None, 'created_at__32': datetime.datetime(2026, 7, 10, 22, 28, 2, 224432, tzinfo=datetime.timezone.utc), 'text_extraction_method__32': None, 'meeting_db_id__32': 3876, 'updated_at__32': datetime.datetime(2026, 7, 10, 22, 28, 2, 224434, tzinfo=datetime.timezone.utc), 'text_extracted_at__32': None, 'local_path__32': None, 'c_number_revision__32': None, 'c_number__32': None, 'meeting_id__32': '823', 'search_vector__32': None, 'agenda_item_id__32': 0, 'document_type__32': None, 'scraped_at__32': datetime.datetime(2026, 7, 10, 22, 28, 2, 201556, tzinfo=datetime.timezone.utc), 'file_extension__32': 'pdf', 'file_name__32': None, 'c_number_base__32': None, 'extraction_duration_ms__32': None, 'document_title__33': 'Special Event Liquor Licenses and Temporary and Permanent Extensions of Liquor License Premises Administratively Approved', 'content_hash__33': None, 'body__33': 'chandler-cc', 'jurisdiction_id__33': None, 'document_url__33': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230410_827/3766_4.13.23_Special_Event_Liquor_and_Liquor_License_Extensions.pdf', 'agenda_item_number__33': '19', 'text_content__33': None, 'created_at__33': datetime.datetime(2026, 7, 10, 22, 28, 2, 224435, tzinfo=datetime.timezone.utc), 'text_extraction_method__33': None, 'meeting_db_id__33': 3876, 'updated_at__33': datetime.datetime(2026, 7, 10, 22, 28, 2, 224436, tzinfo=datetime.timezone.utc), 'text_extracted_at__33': None, 'local_path__33': None, 'c_number_revision__33': None, 'c_number__33': None, 'meeting_id__33': '823', 'search_vector__33': None, 'agenda_item_id__33': 0, 'document_type__33': None, 'scraped_at__33': datetime.datetime(2026, 7, 10, 22, 28, 2, 201602, tzinfo=datetime.timezone.utc), 'file_extension__33': 'pdf', 'file_name__33': None, 'c_number_base__33': None, 'extraction_duration_ms__33': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 15:28 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/2023/CC/20230410_827/3858_03202023_work_session_budget_workshop_2_FINAL.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 ... 19396 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 Work Session - Budget Workshop #2 of March 20, 2023', 'content_hash__0': None, 'body__0': 'chandler-cc', 'jurisdiction_id__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230410_827/3858_03202023_work_session_budget_workshop_2_FINAL.pdf', 'agenda_item_number__0': '1', 'text_content__0': None, 'created_at__0': datetime.datetime(2026, 7, 10, 22, 28, 2, 224340, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'meeting_db_id__0': 3876, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 28, 2, 224348, 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': '823', 'search_vector__0': None, 'agenda_item_id__0': 0, 'document_type__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 28, 2, 200075, 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 Regular Meeting of March 20, 2023', 'content_hash__1': None, 'body__1': 'chandler-cc', 'jurisdiction_id__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230410_827/3858_03202023_regular_FINAL.pdf', 'agenda_item_number__1': '1', 'text_content__1': None, 'created_at__1': datetime.datetime(2026, 7, 10, 22, 28, 2, 224351, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'meeting_db_id__1': 3876, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 28, 2, 224352, 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': '823', 'search_vector__1': None, 'agenda_item_id__1': 0, 'document_type__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 28, 2, 200149, 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 Study Session of March 20, 2023', 'content_hash__2': None ... 716 parameters truncated ... 'c_number_base__31': None, 'extraction_duration_ms__31': None, 'document_title__32': 'Agreement - Technology Construction', 'content_hash__32': None, 'body__32': 'chandler-cc', 'jurisdiction_id__32': None, 'document_url__32': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230410_827/3752_ST2110.401_READY_3.pdf', 'agenda_item_number__32': '16', 'text_content__32': None, 'created_at__32': datetime.datetime(2026, 7, 10, 22, 28, 2, 224432, tzinfo=datetime.timezone.utc), 'text_extraction_method__32': None, 'meeting_db_id__32': 3876, 'updated_at__32': datetime.datetime(2026, 7, 10, 22, 28, 2, 224434, tzinfo=datetime.timezone.utc), 'text_extracted_at__32': None, 'local_path__32': None, 'c_number_revision__32': None, 'c_number__32': None, 'meeting_id__32': '823', 'search_vector__32': None, 'agenda_item_id__32': 0, 'document_type__32': None, 'scraped_at__32': datetime.datetime(2026, 7, 10, 22, 28, 2, 201556, tzinfo=datetime.timezone.utc), 'file_extension__32': 'pdf', 'file_name__32': None, 'c_number_base__32': None, 'extraction_duration_ms__32': None, 'document_title__33': 'Special Event Liquor Licenses and Temporary and Permanent Extensions of Liquor License Premises Administratively Approved', 'content_hash__33': None, 'body__33': 'chandler-cc', 'jurisdiction_id__33': None, 'document_url__33': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230410_827/3766_4.13.23_Special_Event_Liquor_and_Liquor_License_Extensions.pdf', 'agenda_item_number__33': '19', 'text_content__33': None, 'created_at__33': datetime.datetime(2026, 7, 10, 22, 28, 2, 224435, tzinfo=datetime.timezone.utc), 'text_extraction_method__33': None, 'meeting_db_id__33': 3876, 'updated_at__33': datetime.datetime(2026, 7, 10, 22, 28, 2, 224436, tzinfo=datetime.timezone.utc), 'text_extracted_at__33': None, 'local_path__33': None, 'c_number_revision__33': None, 'c_number__33': None, 'meeting_id__33': '823', 'search_vector__33': None, 'agenda_item_id__33': 0, 'document_type__33': None, 'scraped_at__33': datetime.datetime(2026, 7, 10, 22, 28, 2, 201602, tzinfo=datetime.timezone.utc), 'file_extension__33': 'pdf', 'file_name__33': None, 'c_number_base__33': None, 'extraction_duration_ms__33': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
23 item(s)