Name: Study Session Meeting — City Council Study Session — Jan 23, 2023
Start: 2023-01-23

← Back to meetings

City of Chandler · Meeting 668 failed

2023-01-23 · Study Session

Items: 40 / 40
Votes: 1

City Council Study Session

View on Agenda Online ↗

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/2023/CC/20230123_672/3499_01122022_regular_meeting_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 ... 37810 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 Regular Meeting of January 12, 2023', 'content_hash__0': None, 'body__0': 'chandler-cc', 'jurisdiction_id__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230123_672/3499_01122022_regular_meeting_FINAL.pdf', 'agenda_item_number__0': '1', 'text_content__0': None, 'created_at__0': datetime.datetime(2026, 7, 10, 22, 22, 26, 521768, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'meeting_db_id__0': 1912, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 22, 26, 521774, 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': '668', 'search_vector__0': None, 'agenda_item_id__0': 0, 'document_type__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 22, 26, 488497, 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 Special Meeting of January 12, 2023', 'content_hash__1': None, 'body__1': 'chandler-cc', 'jurisdiction_id__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230123_672/3499_01122022_special_meeting_installation_FINAL.pdf', 'agenda_item_number__1': '1', 'text_content__1': None, 'created_at__1': datetime.datetime(2026, 7, 10, 22, 22, 26, 521776, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'meeting_db_id__1': 1912, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 22, 26, 521777, 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': '668', 'search_vector__1': None, 'agenda_item_id__1': 0, 'document_type__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 22, 26, 488609, 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': 'Agreement No. CAPA2-918-4421_Amendment_1', 'content_hash__2': None ... 1508 parameters truncated ... 'c_number_base__64': None, 'extraction_duration_ms__64': None, 'document_title__65': 'Claims Report - December 31, 2022', 'content_hash__65': None, 'body__65': 'chandler-cc', 'jurisdiction_id__65': None, 'document_url__65': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230123_672/3444_10-1-22_to_12-31-22_AP_Claims_Report.pdf', 'agenda_item_number__65': '33', 'text_content__65': None, 'created_at__65': datetime.datetime(2026, 7, 10, 22, 22, 26, 521944, tzinfo=datetime.timezone.utc), 'text_extraction_method__65': None, 'meeting_db_id__65': 1912, 'updated_at__65': datetime.datetime(2026, 7, 10, 22, 22, 26, 521945, tzinfo=datetime.timezone.utc), 'text_extracted_at__65': None, 'local_path__65': None, 'c_number_revision__65': None, 'c_number__65': None, 'meeting_id__65': '668', 'search_vector__65': None, 'agenda_item_id__65': 0, 'document_type__65': None, 'scraped_at__65': datetime.datetime(2026, 7, 10, 22, 22, 26, 493095, tzinfo=datetime.timezone.utc), 'file_extension__65': 'pdf', 'file_name__65': None, 'c_number_base__65': None, 'extraction_duration_ms__65': None, 'document_title__66': 'Contracts and Agreements Valued Between $50,000 and $99,999 Administratively Approved', 'content_hash__66': None, 'body__66': 'chandler-cc', 'jurisdiction_id__66': None, 'document_url__66': 'https://public.destinyhosted.com/chanddocs/2023/CC/20230123_672/3463_1.26.23_Informational_Procurement_Council_Item.pdf', 'agenda_item_number__66': '34', 'text_content__66': None, 'created_at__66': datetime.datetime(2026, 7, 10, 22, 22, 26, 521946, tzinfo=datetime.timezone.utc), 'text_extraction_method__66': None, 'meeting_db_id__66': 1912, 'updated_at__66': datetime.datetime(2026, 7, 10, 22, 22, 26, 521948, tzinfo=datetime.timezone.utc), 'text_extracted_at__66': None, 'local_path__66': None, 'c_number_revision__66': None, 'c_number__66': None, 'meeting_id__66': '668', 'search_vector__66': None, 'agenda_item_id__66': 0, 'document_type__66': None, 'scraped_at__66': datetime.datetime(2026, 7, 10, 22, 22, 26, 493160, tzinfo=datetime.timezone.utc), 'file_extension__66': 'pdf', 'file_name__66': None, 'c_number_base__66': None, 'extraction_duration_ms__66': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)