City of Chandler · Meeting 60 failed
2021-02-08 · Study Session
Items: 28 / 28
City Council Study Session
Synced: 2026-06-03 13:18 AZ
Last attempted: 2026-07-10 14:50 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/20210208_60/197_01252021_SP_Exec_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 ... 31114 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '60', 'scraped_at__0': datetime.datetime(2026, 7, 10, 21, 50, 5, 624204, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210208_60/197_01252021_SP_Exec_FINAL_.pdf', 'meeting_db_id__0': 4620, 'text_extracted_at__0': None, 'content_hash__0': None, 'extraction_duration_ms__0': None, 'text_extraction_method__0': None, 'agenda_item_number__0': '1', '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, 21, 50, 5, 725192, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 21, 50, 5, 725180, tzinfo=datetime.timezone.utc), 'document_title__0': 'January 25, 2021, Special Meeting Minutes', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '60', 'scraped_at__1': datetime.datetime(2026, 7, 10, 21, 50, 5, 624318, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210208_60/197_01252021__Study_Session_FINAL.pdf', 'meeting_db_id__1': 4620, 'text_extracted_at__1': None, 'content_hash__1': None, 'extraction_duration_ms__1': None, 'text_extraction_method__1': None, 'agenda_item_number__1': '1', '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, 21, 50, 5, 725196, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 21, 50, 5, 725194, tzinfo=datetime.timezone.utc), 'document_title__1': 'January 25, 2021, Study Session Meeting Minutes', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '60', 'scraped_at__2': datetime.datetime(2026, 7, 10, 21, 50, 5, 624390, tzinfo=datetime.timezone.utc) ... 1220 parameters truncated ... 'file_name__52': None, 'jurisdiction_id__52': None, 'meeting_id__53': '60', 'scraped_at__53': datetime.datetime(2026, 7, 10, 21, 50, 5, 627905, tzinfo=datetime.timezone.utc), 'file_extension__53': 'pdf', 'c_number__53': None, 'document_url__53': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210208_60/181_01.06.21_SS_Minutes_Signed.pdf', 'meeting_db_id__53': 4620, 'text_extracted_at__53': None, 'content_hash__53': None, 'extraction_duration_ms__53': None, 'text_extraction_method__53': None, 'agenda_item_number__53': '23', 'text_content__53': None, 'body__53': 'chandler-cc', 'document_type__53': None, 'c_number_revision__53': None, 'c_number_base__53': None, 'local_path__53': None, 'updated_at__53': datetime.datetime(2026, 7, 10, 21, 50, 5, 725334, tzinfo=datetime.timezone.utc), 'agenda_item_id__53': 0, 'created_at__53': datetime.datetime(2026, 7, 10, 21, 50, 5, 725333, tzinfo=datetime.timezone.utc), 'document_title__53': 'Jan 6, 2021 P&Z SS Minutes', 'search_vector__53': None, 'file_name__53': None, 'jurisdiction_id__53': None, 'meeting_id__54': '60', 'scraped_at__54': datetime.datetime(2026, 7, 10, 21, 50, 5, 627973, tzinfo=datetime.timezone.utc), 'file_extension__54': 'pdf', 'c_number__54': None, 'document_url__54': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210208_60/182_01.06.21_PZ_Reg_Minutes_Signed.pdf', 'meeting_db_id__54': 4620, 'text_extracted_at__54': None, 'content_hash__54': None, 'extraction_duration_ms__54': None, 'text_extraction_method__54': None, 'agenda_item_number__54': '24', 'text_content__54': None, 'body__54': 'chandler-cc', 'document_type__54': None, 'c_number_revision__54': None, 'c_number_base__54': None, 'local_path__54': None, 'updated_at__54': datetime.datetime(2026, 7, 10, 21, 50, 5, 725337, tzinfo=datetime.timezone.utc), 'agenda_item_id__54': 0, 'created_at__54': datetime.datetime(2026, 7, 10, 21, 50, 5, 725335, tzinfo=datetime.timezone.utc), 'document_title__54': 'Jan 6, 2021, P&Z Reg. Mtg Minutes', 'search_vector__54': None, 'file_name__54': None, 'jurisdiction_id__54': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 14:50 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/20210208_60/197_01252021_SP_Exec_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 ... 31114 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '60', 'scraped_at__0': datetime.datetime(2026, 7, 10, 21, 50, 5, 624204, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210208_60/197_01252021_SP_Exec_FINAL_.pdf', 'meeting_db_id__0': 4620, 'text_extracted_at__0': None, 'content_hash__0': None, 'extraction_duration_ms__0': None, 'text_extraction_method__0': None, 'agenda_item_number__0': '1', '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, 21, 50, 5, 725192, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 21, 50, 5, 725180, tzinfo=datetime.timezone.utc), 'document_title__0': 'January 25, 2021, Special Meeting Minutes', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '60', 'scraped_at__1': datetime.datetime(2026, 7, 10, 21, 50, 5, 624318, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210208_60/197_01252021__Study_Session_FINAL.pdf', 'meeting_db_id__1': 4620, 'text_extracted_at__1': None, 'content_hash__1': None, 'extraction_duration_ms__1': None, 'text_extraction_method__1': None, 'agenda_item_number__1': '1', '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, 21, 50, 5, 725196, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 21, 50, 5, 725194, tzinfo=datetime.timezone.utc), 'document_title__1': 'January 25, 2021, Study Session Meeting Minutes', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '60', 'scraped_at__2': datetime.datetime(2026, 7, 10, 21, 50, 5, 624390, tzinfo=datetime.timezone.utc) ... 1220 parameters truncated ... 'file_name__52': None, 'jurisdiction_id__52': None, 'meeting_id__53': '60', 'scraped_at__53': datetime.datetime(2026, 7, 10, 21, 50, 5, 627905, tzinfo=datetime.timezone.utc), 'file_extension__53': 'pdf', 'c_number__53': None, 'document_url__53': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210208_60/181_01.06.21_SS_Minutes_Signed.pdf', 'meeting_db_id__53': 4620, 'text_extracted_at__53': None, 'content_hash__53': None, 'extraction_duration_ms__53': None, 'text_extraction_method__53': None, 'agenda_item_number__53': '23', 'text_content__53': None, 'body__53': 'chandler-cc', 'document_type__53': None, 'c_number_revision__53': None, 'c_number_base__53': None, 'local_path__53': None, 'updated_at__53': datetime.datetime(2026, 7, 10, 21, 50, 5, 725334, tzinfo=datetime.timezone.utc), 'agenda_item_id__53': 0, 'created_at__53': datetime.datetime(2026, 7, 10, 21, 50, 5, 725333, tzinfo=datetime.timezone.utc), 'document_title__53': 'Jan 6, 2021 P&Z SS Minutes', 'search_vector__53': None, 'file_name__53': None, 'jurisdiction_id__53': None, 'meeting_id__54': '60', 'scraped_at__54': datetime.datetime(2026, 7, 10, 21, 50, 5, 627973, tzinfo=datetime.timezone.utc), 'file_extension__54': 'pdf', 'c_number__54': None, 'document_url__54': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210208_60/182_01.06.21_PZ_Reg_Minutes_Signed.pdf', 'meeting_db_id__54': 4620, 'text_extracted_at__54': None, 'content_hash__54': None, 'extraction_duration_ms__54': None, 'text_extraction_method__54': None, 'agenda_item_number__54': '24', 'text_content__54': None, 'body__54': 'chandler-cc', 'document_type__54': None, 'c_number_revision__54': None, 'c_number_base__54': None, 'local_path__54': None, 'updated_at__54': datetime.datetime(2026, 7, 10, 21, 50, 5, 725337, tzinfo=datetime.timezone.utc), 'agenda_item_id__54': 0, 'created_at__54': datetime.datetime(2026, 7, 10, 21, 50, 5, 725335, tzinfo=datetime.timezone.utc), 'document_title__54': 'Jan 6, 2021, P&Z Reg. Mtg Minutes', 'search_vector__54': None, 'file_name__54': None, 'jurisdiction_id__54': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
24 item(s)