City of Chandler · Meeting 145 failed
2021-10-11 · Study Session
Items: 45 / 45
City Council Study Session
Synced: 2026-06-03 13:19 AZ
Last attempted: 2026-07-10 14:59 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/20211011_145/955_4218_Amendment_1_Legal_Initialed_Vendor_Signed.docx.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 ... 38368 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '145', 'scraped_at__0': datetime.datetime(2026, 7, 10, 21, 59, 41, 551339, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211011_145/955_4218_Amendment_1_Legal_Initialed_Vendor_Signed.docx.pdf', 'meeting_db_id__0': 4713, '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, 59, 41, 587482, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 21, 59, 41, 587475, tzinfo=datetime.timezone.utc), 'document_title__0': '4218 Amendment 1', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '145', 'scraped_at__1': datetime.datetime(2026, 7, 10, 21, 59, 41, 551440, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211011_145/1001_Resolution_No._5529_Legal_Initialed.pdf', 'meeting_db_id__1': 4713, '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, 59, 41, 587486, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 21, 59, 41, 587484, tzinfo=datetime.timezone.utc), 'document_title__1': 'Resolution No. 5529', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '145', 'scraped_at__2': datetime.datetime(2026, 7, 10, 21, 59, 41, 551514, tzinfo=datetime.timezone.utc) ... 1532 parameters truncated ... 'file_name__65': None, 'jurisdiction_id__65': None, 'meeting_id__66': '145', 'scraped_at__66': datetime.datetime(2026, 7, 10, 21, 59, 41, 555976, tzinfo=datetime.timezone.utc), 'file_extension__66': 'pdf', 'c_number__66': None, 'document_url__66': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211011_145/953_Signed_PZ_RM_Sept_1.pdf', 'meeting_db_id__66': 4713, 'text_extracted_at__66': None, 'content_hash__66': None, 'extraction_duration_ms__66': None, 'text_extraction_method__66': None, 'agenda_item_number__66': '40', 'text_content__66': None, 'body__66': 'chandler-cc', 'document_type__66': None, 'c_number_revision__66': None, 'c_number_base__66': None, 'local_path__66': None, 'updated_at__66': datetime.datetime(2026, 7, 10, 21, 59, 41, 587659, tzinfo=datetime.timezone.utc), 'agenda_item_id__66': 0, 'created_at__66': datetime.datetime(2026, 7, 10, 21, 59, 41, 587657, tzinfo=datetime.timezone.utc), 'document_title__66': 'September 1, 2021 Regular Meeting Minutes', 'search_vector__66': None, 'file_name__66': None, 'jurisdiction_id__66': None, 'meeting_id__67': '145', 'scraped_at__67': datetime.datetime(2026, 7, 10, 21, 59, 41, 556042, tzinfo=datetime.timezone.utc), 'file_extension__67': 'pdf', 'c_number__67': None, 'document_url__67': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211011_145/959_10.14.21_Special_Event_Liquor_and_Liquor_License_Extensions.pdf', 'meeting_db_id__67': 4713, 'text_extracted_at__67': None, 'content_hash__67': None, 'extraction_duration_ms__67': None, 'text_extraction_method__67': None, 'agenda_item_number__67': '41', 'text_content__67': None, 'body__67': 'chandler-cc', 'document_type__67': None, 'c_number_revision__67': None, 'c_number_base__67': None, 'local_path__67': None, 'updated_at__67': datetime.datetime(2026, 7, 10, 21, 59, 41, 587661, tzinfo=datetime.timezone.utc), 'agenda_item_id__67': 0, 'created_at__67': datetime.datetime(2026, 7, 10, 21, 59, 41, 587660, tzinfo=datetime.timezone.utc), 'document_title__67': 'Special Event Liquor and Extensions of Liquor License Premises Approvals', 'search_vector__67': None, 'file_name__67': None, 'jurisdiction_id__67': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 14:59 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/20211011_145/955_4218_Amendment_1_Legal_Initialed_Vendor_Signed.docx.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 ... 38368 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '145', 'scraped_at__0': datetime.datetime(2026, 7, 10, 21, 59, 41, 551339, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211011_145/955_4218_Amendment_1_Legal_Initialed_Vendor_Signed.docx.pdf', 'meeting_db_id__0': 4713, '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, 59, 41, 587482, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 21, 59, 41, 587475, tzinfo=datetime.timezone.utc), 'document_title__0': '4218 Amendment 1', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '145', 'scraped_at__1': datetime.datetime(2026, 7, 10, 21, 59, 41, 551440, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211011_145/1001_Resolution_No._5529_Legal_Initialed.pdf', 'meeting_db_id__1': 4713, '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, 59, 41, 587486, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 21, 59, 41, 587484, tzinfo=datetime.timezone.utc), 'document_title__1': 'Resolution No. 5529', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '145', 'scraped_at__2': datetime.datetime(2026, 7, 10, 21, 59, 41, 551514, tzinfo=datetime.timezone.utc) ... 1532 parameters truncated ... 'file_name__65': None, 'jurisdiction_id__65': None, 'meeting_id__66': '145', 'scraped_at__66': datetime.datetime(2026, 7, 10, 21, 59, 41, 555976, tzinfo=datetime.timezone.utc), 'file_extension__66': 'pdf', 'c_number__66': None, 'document_url__66': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211011_145/953_Signed_PZ_RM_Sept_1.pdf', 'meeting_db_id__66': 4713, 'text_extracted_at__66': None, 'content_hash__66': None, 'extraction_duration_ms__66': None, 'text_extraction_method__66': None, 'agenda_item_number__66': '40', 'text_content__66': None, 'body__66': 'chandler-cc', 'document_type__66': None, 'c_number_revision__66': None, 'c_number_base__66': None, 'local_path__66': None, 'updated_at__66': datetime.datetime(2026, 7, 10, 21, 59, 41, 587659, tzinfo=datetime.timezone.utc), 'agenda_item_id__66': 0, 'created_at__66': datetime.datetime(2026, 7, 10, 21, 59, 41, 587657, tzinfo=datetime.timezone.utc), 'document_title__66': 'September 1, 2021 Regular Meeting Minutes', 'search_vector__66': None, 'file_name__66': None, 'jurisdiction_id__66': None, 'meeting_id__67': '145', 'scraped_at__67': datetime.datetime(2026, 7, 10, 21, 59, 41, 556042, tzinfo=datetime.timezone.utc), 'file_extension__67': 'pdf', 'c_number__67': None, 'document_url__67': 'https://public.destinyhosted.com/chanddocs/2021/CC/20211011_145/959_10.14.21_Special_Event_Liquor_and_Liquor_License_Extensions.pdf', 'meeting_db_id__67': 4713, 'text_extracted_at__67': None, 'content_hash__67': None, 'extraction_duration_ms__67': None, 'text_extraction_method__67': None, 'agenda_item_number__67': '41', 'text_content__67': None, 'body__67': 'chandler-cc', 'document_type__67': None, 'c_number_revision__67': None, 'c_number_base__67': None, 'local_path__67': None, 'updated_at__67': datetime.datetime(2026, 7, 10, 21, 59, 41, 587661, tzinfo=datetime.timezone.utc), 'agenda_item_id__67': 0, 'created_at__67': datetime.datetime(2026, 7, 10, 21, 59, 41, 587660, tzinfo=datetime.timezone.utc), 'document_title__67': 'Special Event Liquor and Extensions of Liquor License Premises Approvals', 'search_vector__67': None, 'file_name__67': None, 'jurisdiction_id__67': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
41 item(s)