City of Chandler · Meeting 324 failed
2022-01-10 · Study Session
Items: 19 / 19
City Council Study Session
Synced: 2026-05-31 07:12 AZ
Last attempted: 2026-07-10 15:03 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/20211206_255/1076_Ordinance_4983.Amending.Boards_etc_w_initials.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 ... 18280 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'text_content__0': None, 'document_type__0': None, 'search_vector__0': None, 'content_hash__0': None, 'text_extracted_at__0': None, 'local_path__0': None, 'c_number_base__0': None, 'agenda_item_number__0': '1', 'agenda_item_id__0': 0, 'c_number__0': None, 'c_number_revision__0': None, 'jurisdiction_id__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 3, 55, 136374, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 3, 55, 157284, tzinfo=datetime.timezone.utc), 'meeting_db_id__0': 4764, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220110_324/1414_12062021_Regular_Meeting_FINAL.pdf', 'meeting_id__0': '324', 'created_at__0': datetime.datetime(2026, 7, 10, 22, 3, 55, 157276, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'extraction_duration_ms__0': None, 'document_title__0': 'Minutes of the Regular Meeting of December 6, 2021', 'body__0': 'chandler-cc', 'file_name__0': None, 'text_content__1': None, 'document_type__1': None, 'search_vector__1': None, 'content_hash__1': None, 'text_extracted_at__1': None, 'local_path__1': None, 'c_number_base__1': None, 'agenda_item_number__1': '1', 'agenda_item_id__1': 0, 'c_number__1': None, 'c_number_revision__1': None, 'jurisdiction_id__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 3, 55, 136483, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 3, 55, 157287, tzinfo=datetime.timezone.utc), 'meeting_db_id__1': 4764, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220110_324/1414_12062021_StudySession_FINAL.pdf', 'meeting_id__1': '324', 'created_at__1': datetime.datetime(2026, 7, 10, 22, 3, 55, 157286, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'extraction_duration_ms__1': None, 'document_title__1': 'Minutes of the Study Session Meeting of December 6, 2021', 'body__1': 'chandler-cc', 'file_name__1': None, 'text_content__2': None, 'document_type__2': None ... 668 parameters truncated ... 'body__29': 'chandler-cc', 'file_name__29': None, 'text_content__30': None, 'document_type__30': None, 'search_vector__30': None, 'content_hash__30': None, 'text_extracted_at__30': None, 'local_path__30': None, 'c_number_base__30': None, 'agenda_item_number__30': '15', 'agenda_item_id__30': 0, 'c_number__30': None, 'c_number_revision__30': None, 'jurisdiction_id__30': None, 'scraped_at__30': datetime.datetime(2026, 7, 10, 22, 3, 55, 138530, tzinfo=datetime.timezone.utc), 'file_extension__30': 'pdf', 'updated_at__30': datetime.datetime(2026, 7, 10, 22, 3, 55, 157366, tzinfo=datetime.timezone.utc), 'meeting_db_id__30': 4764, 'document_url__30': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220110_324/1364_Regular_Meeting.pdf', 'meeting_id__30': '324', 'created_at__30': datetime.datetime(2026, 7, 10, 22, 3, 55, 157364, tzinfo=datetime.timezone.utc), 'text_extraction_method__30': None, 'extraction_duration_ms__30': None, 'document_title__30': 'November17, 2021 Regular Minutes', 'body__30': 'chandler-cc', 'file_name__30': None, 'text_content__31': None, 'document_type__31': None, 'search_vector__31': None, 'content_hash__31': None, 'text_extracted_at__31': None, 'local_path__31': None, 'c_number_base__31': None, 'agenda_item_number__31': '16', 'agenda_item_id__31': 0, 'c_number__31': None, 'c_number_revision__31': None, 'jurisdiction_id__31': None, 'scraped_at__31': datetime.datetime(2026, 7, 10, 22, 3, 55, 138600, tzinfo=datetime.timezone.utc), 'file_extension__31': 'pdf', 'updated_at__31': datetime.datetime(2026, 7, 10, 22, 3, 55, 157369, tzinfo=datetime.timezone.utc), 'meeting_db_id__31': 4764, 'document_url__31': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220110_324/1405_1.13.22_Special_Event_Liquor_and_Liquor_License_Extensions.pdf', 'meeting_id__31': '324', 'created_at__31': datetime.datetime(2026, 7, 10, 22, 3, 55, 157367, tzinfo=datetime.timezone.utc), 'text_extraction_method__31': None, 'extraction_duration_ms__31': None, 'document_title__31': 'Special Event Liquor Licenses and Temporary and Permanent Extensions of Liquor License Premises Administratively Approved', 'body__31': 'chandler-cc', 'file_name__31': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 15:03 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/20211206_255/1076_Ordinance_4983.Amending.Boards_etc_w_initials.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 ... 18280 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'text_content__0': None, 'document_type__0': None, 'search_vector__0': None, 'content_hash__0': None, 'text_extracted_at__0': None, 'local_path__0': None, 'c_number_base__0': None, 'agenda_item_number__0': '1', 'agenda_item_id__0': 0, 'c_number__0': None, 'c_number_revision__0': None, 'jurisdiction_id__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 3, 55, 136374, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 3, 55, 157284, tzinfo=datetime.timezone.utc), 'meeting_db_id__0': 4764, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220110_324/1414_12062021_Regular_Meeting_FINAL.pdf', 'meeting_id__0': '324', 'created_at__0': datetime.datetime(2026, 7, 10, 22, 3, 55, 157276, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'extraction_duration_ms__0': None, 'document_title__0': 'Minutes of the Regular Meeting of December 6, 2021', 'body__0': 'chandler-cc', 'file_name__0': None, 'text_content__1': None, 'document_type__1': None, 'search_vector__1': None, 'content_hash__1': None, 'text_extracted_at__1': None, 'local_path__1': None, 'c_number_base__1': None, 'agenda_item_number__1': '1', 'agenda_item_id__1': 0, 'c_number__1': None, 'c_number_revision__1': None, 'jurisdiction_id__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 3, 55, 136483, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 3, 55, 157287, tzinfo=datetime.timezone.utc), 'meeting_db_id__1': 4764, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220110_324/1414_12062021_StudySession_FINAL.pdf', 'meeting_id__1': '324', 'created_at__1': datetime.datetime(2026, 7, 10, 22, 3, 55, 157286, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'extraction_duration_ms__1': None, 'document_title__1': 'Minutes of the Study Session Meeting of December 6, 2021', 'body__1': 'chandler-cc', 'file_name__1': None, 'text_content__2': None, 'document_type__2': None ... 668 parameters truncated ... 'body__29': 'chandler-cc', 'file_name__29': None, 'text_content__30': None, 'document_type__30': None, 'search_vector__30': None, 'content_hash__30': None, 'text_extracted_at__30': None, 'local_path__30': None, 'c_number_base__30': None, 'agenda_item_number__30': '15', 'agenda_item_id__30': 0, 'c_number__30': None, 'c_number_revision__30': None, 'jurisdiction_id__30': None, 'scraped_at__30': datetime.datetime(2026, 7, 10, 22, 3, 55, 138530, tzinfo=datetime.timezone.utc), 'file_extension__30': 'pdf', 'updated_at__30': datetime.datetime(2026, 7, 10, 22, 3, 55, 157366, tzinfo=datetime.timezone.utc), 'meeting_db_id__30': 4764, 'document_url__30': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220110_324/1364_Regular_Meeting.pdf', 'meeting_id__30': '324', 'created_at__30': datetime.datetime(2026, 7, 10, 22, 3, 55, 157364, tzinfo=datetime.timezone.utc), 'text_extraction_method__30': None, 'extraction_duration_ms__30': None, 'document_title__30': 'November17, 2021 Regular Minutes', 'body__30': 'chandler-cc', 'file_name__30': None, 'text_content__31': None, 'document_type__31': None, 'search_vector__31': None, 'content_hash__31': None, 'text_extracted_at__31': None, 'local_path__31': None, 'c_number_base__31': None, 'agenda_item_number__31': '16', 'agenda_item_id__31': 0, 'c_number__31': None, 'c_number_revision__31': None, 'jurisdiction_id__31': None, 'scraped_at__31': datetime.datetime(2026, 7, 10, 22, 3, 55, 138600, tzinfo=datetime.timezone.utc), 'file_extension__31': 'pdf', 'updated_at__31': datetime.datetime(2026, 7, 10, 22, 3, 55, 157369, tzinfo=datetime.timezone.utc), 'meeting_db_id__31': 4764, 'document_url__31': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220110_324/1405_1.13.22_Special_Event_Liquor_and_Liquor_License_Extensions.pdf', 'meeting_id__31': '324', 'created_at__31': datetime.datetime(2026, 7, 10, 22, 3, 55, 157367, tzinfo=datetime.timezone.utc), 'text_extraction_method__31': None, 'extraction_duration_ms__31': None, 'document_title__31': 'Special Event Liquor Licenses and Temporary and Permanent Extensions of Liquor License Premises Administratively Approved', 'body__31': 'chandler-cc', 'file_name__31': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
19 item(s)