City of Chandler · Meeting 61 failed
2021-02-22 · Study Session
Items: 32 / 32
City Council Study Session
Synced: 2026-06-03 13:18 AZ
Last attempted: 2026-07-10 14:49 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/20210222_61/219_02082021_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 ... 34462 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '61', 'scraped_at__0': datetime.datetime(2026, 7, 10, 21, 49, 40, 629882, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210222_61/219_02082021_SP_Exec_FINAL_.pdf', 'meeting_db_id__0': 4616, '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, 49, 40, 732918, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 21, 49, 40, 732909, tzinfo=datetime.timezone.utc), 'document_title__0': 'February 8, 2021, Special Meeting Minutes', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '61', 'scraped_at__1': datetime.datetime(2026, 7, 10, 21, 49, 40, 630008, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210222_61/219_02082021__Study_Session_FINAL.pdf', 'meeting_db_id__1': 4616, '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, 49, 40, 732922, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 21, 49, 40, 732921, tzinfo=datetime.timezone.utc), 'document_title__1': 'February 8, 2021, Study Session Minutes', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '61', 'scraped_at__2': datetime.datetime(2026, 7, 10, 21, 49, 40, 630081, tzinfo=datetime.timezone.utc) ... 1364 parameters truncated ... 'file_name__58': None, 'jurisdiction_id__58': None, 'meeting_id__59': '61', 'scraped_at__59': datetime.datetime(2026, 7, 10, 21, 49, 40, 633961, tzinfo=datetime.timezone.utc), 'file_extension__59': 'pdf', 'c_number__59': None, 'document_url__59': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210222_61/204_3-Proposed_Modified_Fee_Web_Posting.pdf', 'meeting_db_id__59': 4616, 'text_extracted_at__59': None, 'content_hash__59': None, 'extraction_duration_ms__59': None, 'text_extraction_method__59': None, 'agenda_item_number__59': '32', 'text_content__59': None, 'body__59': 'chandler-cc', 'document_type__59': None, 'c_number_revision__59': None, 'c_number_base__59': None, 'local_path__59': None, 'updated_at__59': datetime.datetime(2026, 7, 10, 21, 49, 40, 733075, tzinfo=datetime.timezone.utc), 'agenda_item_id__59': 0, 'created_at__59': datetime.datetime(2026, 7, 10, 21, 49, 40, 733073, tzinfo=datetime.timezone.utc), 'document_title__59': 'Attachment 3 - Web Posting', 'search_vector__59': None, 'file_name__59': None, 'jurisdiction_id__59': None, 'meeting_id__60': '61', 'scraped_at__60': datetime.datetime(2026, 7, 10, 21, 49, 40, 634018, tzinfo=datetime.timezone.utc), 'file_extension__60': 'pdf', 'c_number__60': None, 'document_url__60': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210222_61/204_4-2021_Notice_of_Intention.pdf', 'meeting_db_id__60': 4616, 'text_extracted_at__60': None, 'content_hash__60': None, 'extraction_duration_ms__60': None, 'text_extraction_method__60': None, 'agenda_item_number__60': '32', 'text_content__60': None, 'body__60': 'chandler-cc', 'document_type__60': None, 'c_number_revision__60': None, 'c_number_base__60': None, 'local_path__60': None, 'updated_at__60': datetime.datetime(2026, 7, 10, 21, 49, 40, 733077, tzinfo=datetime.timezone.utc), 'agenda_item_id__60': 0, 'created_at__60': datetime.datetime(2026, 7, 10, 21, 49, 40, 733076, tzinfo=datetime.timezone.utc), 'document_title__60': 'Attachment 4 - Notice of Intent', 'search_vector__60': None, 'file_name__60': None, 'jurisdiction_id__60': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 14:49 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/20210222_61/219_02082021_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 ... 34462 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '61', 'scraped_at__0': datetime.datetime(2026, 7, 10, 21, 49, 40, 629882, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210222_61/219_02082021_SP_Exec_FINAL_.pdf', 'meeting_db_id__0': 4616, '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, 49, 40, 732918, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 21, 49, 40, 732909, tzinfo=datetime.timezone.utc), 'document_title__0': 'February 8, 2021, Special Meeting Minutes', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '61', 'scraped_at__1': datetime.datetime(2026, 7, 10, 21, 49, 40, 630008, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210222_61/219_02082021__Study_Session_FINAL.pdf', 'meeting_db_id__1': 4616, '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, 49, 40, 732922, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 21, 49, 40, 732921, tzinfo=datetime.timezone.utc), 'document_title__1': 'February 8, 2021, Study Session Minutes', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '61', 'scraped_at__2': datetime.datetime(2026, 7, 10, 21, 49, 40, 630081, tzinfo=datetime.timezone.utc) ... 1364 parameters truncated ... 'file_name__58': None, 'jurisdiction_id__58': None, 'meeting_id__59': '61', 'scraped_at__59': datetime.datetime(2026, 7, 10, 21, 49, 40, 633961, tzinfo=datetime.timezone.utc), 'file_extension__59': 'pdf', 'c_number__59': None, 'document_url__59': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210222_61/204_3-Proposed_Modified_Fee_Web_Posting.pdf', 'meeting_db_id__59': 4616, 'text_extracted_at__59': None, 'content_hash__59': None, 'extraction_duration_ms__59': None, 'text_extraction_method__59': None, 'agenda_item_number__59': '32', 'text_content__59': None, 'body__59': 'chandler-cc', 'document_type__59': None, 'c_number_revision__59': None, 'c_number_base__59': None, 'local_path__59': None, 'updated_at__59': datetime.datetime(2026, 7, 10, 21, 49, 40, 733075, tzinfo=datetime.timezone.utc), 'agenda_item_id__59': 0, 'created_at__59': datetime.datetime(2026, 7, 10, 21, 49, 40, 733073, tzinfo=datetime.timezone.utc), 'document_title__59': 'Attachment 3 - Web Posting', 'search_vector__59': None, 'file_name__59': None, 'jurisdiction_id__59': None, 'meeting_id__60': '61', 'scraped_at__60': datetime.datetime(2026, 7, 10, 21, 49, 40, 634018, tzinfo=datetime.timezone.utc), 'file_extension__60': 'pdf', 'c_number__60': None, 'document_url__60': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210222_61/204_4-2021_Notice_of_Intention.pdf', 'meeting_db_id__60': 4616, 'text_extracted_at__60': None, 'content_hash__60': None, 'extraction_duration_ms__60': None, 'text_extraction_method__60': None, 'agenda_item_number__60': '32', 'text_content__60': None, 'body__60': 'chandler-cc', 'document_type__60': None, 'c_number_revision__60': None, 'c_number_base__60': None, 'local_path__60': None, 'updated_at__60': datetime.datetime(2026, 7, 10, 21, 49, 40, 733077, tzinfo=datetime.timezone.utc), 'agenda_item_id__60': 0, 'created_at__60': datetime.datetime(2026, 7, 10, 21, 49, 40, 733076, tzinfo=datetime.timezone.utc), 'document_title__60': 'Attachment 4 - Notice of Intent', 'search_vector__60': None, 'file_name__60': None, 'jurisdiction_id__60': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
32 item(s)