City of Chandler · Meeting 122 failed
2021-09-20 · Study Session
Items: 63 / 63
City Council Study Session
Synced: 2026-06-03 13:19 AZ
Last attempted: 2026-07-10 14:58 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/20210920_122/794_Amendment_to_IGA_with_RPTA.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 ... 52318 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '122', 'scraped_at__0': datetime.datetime(2026, 7, 10, 21, 58, 6, 524861, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210920_122/794_Amendment_to_IGA_with_RPTA.pdf', 'meeting_db_id__0': 4689, 'text_extracted_at__0': None, 'content_hash__0': None, 'extraction_duration_ms__0': None, 'text_extraction_method__0': None, 'agenda_item_number__0': '3', '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, 58, 6, 561296, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 21, 58, 6, 561289, tzinfo=datetime.timezone.utc), 'document_title__0': 'Amendment to IGA with RPTA', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '122', 'scraped_at__1': datetime.datetime(2026, 7, 10, 21, 58, 6, 524965, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210920_122/794_Resolution_5508_RPTA_IGA.pdf', 'meeting_db_id__1': 4689, '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, 21, 58, 6, 561299, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 21, 58, 6, 561298, tzinfo=datetime.timezone.utc), 'document_title__1': 'Resolution 5508', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '122', 'scraped_at__2': datetime.datetime(2026, 7, 10, 21, 58, 6, 525038, tzinfo=datetime.timezone.utc) ... 2132 parameters truncated ... 'file_name__90': None, 'jurisdiction_id__90': None, 'meeting_id__91': '122', 'scraped_at__91': datetime.datetime(2026, 7, 10, 21, 58, 6, 530737, tzinfo=datetime.timezone.utc), 'file_extension__91': 'pdf', 'c_number__91': None, 'document_url__91': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210920_122/879_SIGNED_Regular_Meeting_AUG_18.pdf', 'meeting_db_id__91': 4689, 'text_extracted_at__91': None, 'content_hash__91': None, 'extraction_duration_ms__91': None, 'text_extraction_method__91': None, 'agenda_item_number__91': '56', 'text_content__91': None, 'body__91': 'chandler-cc', 'document_type__91': None, 'c_number_revision__91': None, 'c_number_base__91': None, 'local_path__91': None, 'updated_at__91': datetime.datetime(2026, 7, 10, 21, 58, 6, 561496, tzinfo=datetime.timezone.utc), 'agenda_item_id__91': 0, 'created_at__91': datetime.datetime(2026, 7, 10, 21, 58, 6, 561495, tzinfo=datetime.timezone.utc), 'document_title__91': 'August 18, 2021 Regular Minutes', 'search_vector__91': None, 'file_name__91': None, 'jurisdiction_id__91': None, 'meeting_id__92': '122', 'scraped_at__92': datetime.datetime(2026, 7, 10, 21, 58, 6, 530793, tzinfo=datetime.timezone.utc), 'file_extension__92': 'pdf', 'c_number__92': None, 'document_url__92': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210920_122/879_Signed_PZ_Study_Session_Aug_18.pdf', 'meeting_db_id__92': 4689, 'text_extracted_at__92': None, 'content_hash__92': None, 'extraction_duration_ms__92': None, 'text_extraction_method__92': None, 'agenda_item_number__92': '56', 'text_content__92': None, 'body__92': 'chandler-cc', 'document_type__92': None, 'c_number_revision__92': None, 'c_number_base__92': None, 'local_path__92': None, 'updated_at__92': datetime.datetime(2026, 7, 10, 21, 58, 6, 561498, tzinfo=datetime.timezone.utc), 'agenda_item_id__92': 0, 'created_at__92': datetime.datetime(2026, 7, 10, 21, 58, 6, 561497, tzinfo=datetime.timezone.utc), 'document_title__92': 'August 18, 2021 Study Session Minutes', 'search_vector__92': None, 'file_name__92': None, 'jurisdiction_id__92': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 14:58 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/20210920_122/794_Amendment_to_IGA_with_RPTA.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 ... 52318 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '122', 'scraped_at__0': datetime.datetime(2026, 7, 10, 21, 58, 6, 524861, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210920_122/794_Amendment_to_IGA_with_RPTA.pdf', 'meeting_db_id__0': 4689, 'text_extracted_at__0': None, 'content_hash__0': None, 'extraction_duration_ms__0': None, 'text_extraction_method__0': None, 'agenda_item_number__0': '3', '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, 58, 6, 561296, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 21, 58, 6, 561289, tzinfo=datetime.timezone.utc), 'document_title__0': 'Amendment to IGA with RPTA', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '122', 'scraped_at__1': datetime.datetime(2026, 7, 10, 21, 58, 6, 524965, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210920_122/794_Resolution_5508_RPTA_IGA.pdf', 'meeting_db_id__1': 4689, '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, 21, 58, 6, 561299, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 21, 58, 6, 561298, tzinfo=datetime.timezone.utc), 'document_title__1': 'Resolution 5508', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '122', 'scraped_at__2': datetime.datetime(2026, 7, 10, 21, 58, 6, 525038, tzinfo=datetime.timezone.utc) ... 2132 parameters truncated ... 'file_name__90': None, 'jurisdiction_id__90': None, 'meeting_id__91': '122', 'scraped_at__91': datetime.datetime(2026, 7, 10, 21, 58, 6, 530737, tzinfo=datetime.timezone.utc), 'file_extension__91': 'pdf', 'c_number__91': None, 'document_url__91': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210920_122/879_SIGNED_Regular_Meeting_AUG_18.pdf', 'meeting_db_id__91': 4689, 'text_extracted_at__91': None, 'content_hash__91': None, 'extraction_duration_ms__91': None, 'text_extraction_method__91': None, 'agenda_item_number__91': '56', 'text_content__91': None, 'body__91': 'chandler-cc', 'document_type__91': None, 'c_number_revision__91': None, 'c_number_base__91': None, 'local_path__91': None, 'updated_at__91': datetime.datetime(2026, 7, 10, 21, 58, 6, 561496, tzinfo=datetime.timezone.utc), 'agenda_item_id__91': 0, 'created_at__91': datetime.datetime(2026, 7, 10, 21, 58, 6, 561495, tzinfo=datetime.timezone.utc), 'document_title__91': 'August 18, 2021 Regular Minutes', 'search_vector__91': None, 'file_name__91': None, 'jurisdiction_id__91': None, 'meeting_id__92': '122', 'scraped_at__92': datetime.datetime(2026, 7, 10, 21, 58, 6, 530793, tzinfo=datetime.timezone.utc), 'file_extension__92': 'pdf', 'c_number__92': None, 'document_url__92': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210920_122/879_Signed_PZ_Study_Session_Aug_18.pdf', 'meeting_db_id__92': 4689, 'text_extracted_at__92': None, 'content_hash__92': None, 'extraction_duration_ms__92': None, 'text_extraction_method__92': None, 'agenda_item_number__92': '56', 'text_content__92': None, 'body__92': 'chandler-cc', 'document_type__92': None, 'c_number_revision__92': None, 'c_number_base__92': None, 'local_path__92': None, 'updated_at__92': datetime.datetime(2026, 7, 10, 21, 58, 6, 561498, tzinfo=datetime.timezone.utc), 'agenda_item_id__92': 0, 'created_at__92': datetime.datetime(2026, 7, 10, 21, 58, 6, 561497, tzinfo=datetime.timezone.utc), 'document_title__92': 'August 18, 2021 Study Session Minutes', 'search_vector__92': None, 'file_name__92': None, 'jurisdiction_id__92': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
56 item(s)