City of Chandler · Meeting 226 failed
2021-11-01 · Study Session
Items: 29 / 29
City Council Study Session
Synced: 2026-06-03 13:19 AZ
Last attempted: 2026-07-10 15:00 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/2021/CC/20211101_226/1039_Agreement_Ursula_Gordwin.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 ... 28324 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '226', 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 0, 49, 133951, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211101_226/1039_Agreement_Ursula_Gordwin.pdf', 'meeting_db_id__0': 4730, 'text_extracted_at__0': None, 'content_hash__0': None, 'extraction_duration_ms__0': None, 'text_extraction_method__0': None, 'agenda_item_number__0': '2', 'text_content__0': None, 'body__0': 'chandler-cc', 'document_type__0': None, 'c_number_revision__0': None, 'c_number_base__0': None, 'local_path__0': None, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 0, 49, 174850, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 22, 0, 49, 174842, tzinfo=datetime.timezone.utc), 'document_title__0': 'Agreement - Ursula Gordwin', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '226', 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 0, 49, 134030, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211101_226/966_4389_Softball_Umpires_Agreement.pdf', 'meeting_db_id__1': 4730, 'text_extracted_at__1': None, 'content_hash__1': None, 'extraction_duration_ms__1': None, 'text_extraction_method__1': None, 'agenda_item_number__1': '3', 'text_content__1': None, 'body__1': 'chandler-cc', 'document_type__1': None, 'c_number_revision__1': None, 'c_number_base__1': None, 'local_path__1': None, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 0, 49, 174852, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 22, 0, 49, 174851, tzinfo=datetime.timezone.utc), 'document_title__1': 'Agreement', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '226', 'scraped_at__2': datetime.datetime(2026, 7, 10, 22, 0, 49, 134065, tzinfo=datetime.timezone.utc) ... 1100 parameters truncated ... 'file_name__47': None, 'jurisdiction_id__47': None, 'meeting_id__48': '226', 'scraped_at__48': datetime.datetime(2026, 7, 10, 22, 0, 49, 135503, tzinfo=datetime.timezone.utc), 'file_extension__48': 'pdf', 'c_number__48': None, 'document_url__48': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211101_226/1005_4219_Amendment_No._2_Plumbing_Services_Talis.pdf', 'meeting_db_id__48': 4730, 'text_extracted_at__48': None, 'content_hash__48': None, 'extraction_duration_ms__48': None, 'text_extraction_method__48': None, 'agenda_item_number__48': '25', 'text_content__48': None, 'body__48': 'chandler-cc', 'document_type__48': None, 'c_number_revision__48': None, 'c_number_base__48': None, 'local_path__48': None, 'updated_at__48': datetime.datetime(2026, 7, 10, 22, 0, 49, 174917, tzinfo=datetime.timezone.utc), 'agenda_item_id__48': 0, 'created_at__48': datetime.datetime(2026, 7, 10, 22, 0, 49, 174916, tzinfo=datetime.timezone.utc), 'document_title__48': 'Amendment - Talis', 'search_vector__48': None, 'file_name__48': None, 'jurisdiction_id__48': None, 'meeting_id__49': '226', 'scraped_at__49': datetime.datetime(2026, 7, 10, 22, 0, 49, 135532, tzinfo=datetime.timezone.utc), 'file_extension__49': 'pdf', 'c_number__49': None, 'document_url__49': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211101_226/1025_11.04.21_Special_Event_and_Liquor_License_Extentions.pdf', 'meeting_db_id__49': 4730, 'text_extracted_at__49': None, 'content_hash__49': None, 'extraction_duration_ms__49': None, 'text_extraction_method__49': None, 'agenda_item_number__49': '26', 'text_content__49': None, 'body__49': 'chandler-cc', 'document_type__49': None, 'c_number_revision__49': None, 'c_number_base__49': None, 'local_path__49': None, 'updated_at__49': datetime.datetime(2026, 7, 10, 22, 0, 49, 174918, tzinfo=datetime.timezone.utc), 'agenda_item_id__49': 0, 'created_at__49': datetime.datetime(2026, 7, 10, 22, 0, 49, 174917, tzinfo=datetime.timezone.utc), 'document_title__49': 'Special Event Liquor and Extensions of Liquor License Premises Approvals', 'search_vector__49': None, 'file_name__49': None, 'jurisdiction_id__49': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 15:00 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/2021/CC/20211101_226/1039_Agreement_Ursula_Gordwin.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 ... 28324 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '226', 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 0, 49, 133951, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211101_226/1039_Agreement_Ursula_Gordwin.pdf', 'meeting_db_id__0': 4730, 'text_extracted_at__0': None, 'content_hash__0': None, 'extraction_duration_ms__0': None, 'text_extraction_method__0': None, 'agenda_item_number__0': '2', 'text_content__0': None, 'body__0': 'chandler-cc', 'document_type__0': None, 'c_number_revision__0': None, 'c_number_base__0': None, 'local_path__0': None, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 0, 49, 174850, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 22, 0, 49, 174842, tzinfo=datetime.timezone.utc), 'document_title__0': 'Agreement - Ursula Gordwin', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '226', 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 0, 49, 134030, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211101_226/966_4389_Softball_Umpires_Agreement.pdf', 'meeting_db_id__1': 4730, 'text_extracted_at__1': None, 'content_hash__1': None, 'extraction_duration_ms__1': None, 'text_extraction_method__1': None, 'agenda_item_number__1': '3', 'text_content__1': None, 'body__1': 'chandler-cc', 'document_type__1': None, 'c_number_revision__1': None, 'c_number_base__1': None, 'local_path__1': None, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 0, 49, 174852, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 22, 0, 49, 174851, tzinfo=datetime.timezone.utc), 'document_title__1': 'Agreement', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '226', 'scraped_at__2': datetime.datetime(2026, 7, 10, 22, 0, 49, 134065, tzinfo=datetime.timezone.utc) ... 1100 parameters truncated ... 'file_name__47': None, 'jurisdiction_id__47': None, 'meeting_id__48': '226', 'scraped_at__48': datetime.datetime(2026, 7, 10, 22, 0, 49, 135503, tzinfo=datetime.timezone.utc), 'file_extension__48': 'pdf', 'c_number__48': None, 'document_url__48': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211101_226/1005_4219_Amendment_No._2_Plumbing_Services_Talis.pdf', 'meeting_db_id__48': 4730, 'text_extracted_at__48': None, 'content_hash__48': None, 'extraction_duration_ms__48': None, 'text_extraction_method__48': None, 'agenda_item_number__48': '25', 'text_content__48': None, 'body__48': 'chandler-cc', 'document_type__48': None, 'c_number_revision__48': None, 'c_number_base__48': None, 'local_path__48': None, 'updated_at__48': datetime.datetime(2026, 7, 10, 22, 0, 49, 174917, tzinfo=datetime.timezone.utc), 'agenda_item_id__48': 0, 'created_at__48': datetime.datetime(2026, 7, 10, 22, 0, 49, 174916, tzinfo=datetime.timezone.utc), 'document_title__48': 'Amendment - Talis', 'search_vector__48': None, 'file_name__48': None, 'jurisdiction_id__48': None, 'meeting_id__49': '226', 'scraped_at__49': datetime.datetime(2026, 7, 10, 22, 0, 49, 135532, tzinfo=datetime.timezone.utc), 'file_extension__49': 'pdf', 'c_number__49': None, 'document_url__49': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211101_226/1025_11.04.21_Special_Event_and_Liquor_License_Extentions.pdf', 'meeting_db_id__49': 4730, 'text_extracted_at__49': None, 'content_hash__49': None, 'extraction_duration_ms__49': None, 'text_extraction_method__49': None, 'agenda_item_number__49': '26', 'text_content__49': None, 'body__49': 'chandler-cc', 'document_type__49': None, 'c_number_revision__49': None, 'c_number_base__49': None, 'local_path__49': None, 'updated_at__49': datetime.datetime(2026, 7, 10, 22, 0, 49, 174918, tzinfo=datetime.timezone.utc), 'agenda_item_id__49': 0, 'created_at__49': datetime.datetime(2026, 7, 10, 22, 0, 49, 174917, tzinfo=datetime.timezone.utc), 'document_title__49': 'Special Event Liquor and Extensions of Liquor License Premises Approvals', 'search_vector__49': None, 'file_name__49': None, 'jurisdiction_id__49': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
26 item(s)