City of Chandler · Meeting 429 failed
2022-05-23 · Study Session
Items: 30 / 30
City Council Study Session
Synced: 2026-05-31 07:13 AZ
Last attempted: 2026-07-10 15:09 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/2022/CC/20220523_430/2101_05092022_Study_session_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 ... 26092 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, 9, 6, 183752, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 9, 6, 230126, tzinfo=datetime.timezone.utc), 'meeting_db_id__0': 4843, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220523_430/2101_05092022_Study_session_FINAL.pdf', 'meeting_id__0': '429', 'created_at__0': datetime.datetime(2026, 7, 10, 22, 9, 6, 230117, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'extraction_duration_ms__0': None, 'document_title__0': 'Minutes of the Study Session Meeting of May 9, 2022', '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, 9, 6, 183791, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 9, 6, 230128, tzinfo=datetime.timezone.utc), 'meeting_db_id__1': 4843, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220523_430/2101_05122022_Regular_Meeting_FINAL.pdf', 'meeting_id__1': '429', 'created_at__1': datetime.datetime(2026, 7, 10, 22, 9, 6, 230127, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'extraction_duration_ms__1': None, 'document_title__1': 'Minutes of the Regular Meeting of May 12, 2022', 'body__1': 'chandler-cc', 'file_name__1': None, 'text_content__2': None, 'document_type__2': None ... 1004 parameters truncated ... 'body__43': 'chandler-cc', 'file_name__43': None, 'text_content__44': None, 'document_type__44': None, 'search_vector__44': None, 'content_hash__44': None, 'text_extracted_at__44': None, 'local_path__44': None, 'c_number_base__44': None, 'agenda_item_number__44': '28', 'agenda_item_id__44': 0, 'c_number__44': None, 'c_number_revision__44': None, 'jurisdiction_id__44': None, 'scraped_at__44': datetime.datetime(2026, 7, 10, 22, 9, 6, 184699, tzinfo=datetime.timezone.utc), 'file_extension__44': 'pdf', 'updated_at__44': datetime.datetime(2026, 7, 10, 22, 9, 6, 230200, tzinfo=datetime.timezone.utc), 'meeting_db_id__44': 4843, 'document_url__44': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220523_430/2001_WW2005.252_Initialed-Signed_w-recommend.pdf', 'meeting_id__44': '429', 'created_at__44': datetime.datetime(2026, 7, 10, 22, 9, 6, 230199, tzinfo=datetime.timezone.utc), 'text_extraction_method__44': None, 'extraction_duration_ms__44': None, 'document_title__44': 'Contract B&F Contracting', 'body__44': 'chandler-cc', 'file_name__44': None, 'text_content__45': None, 'document_type__45': None, 'search_vector__45': None, 'content_hash__45': None, 'text_extracted_at__45': None, 'local_path__45': None, 'c_number_base__45': None, 'agenda_item_number__45': '28', 'agenda_item_id__45': 0, 'c_number__45': None, 'c_number_revision__45': None, 'jurisdiction_id__45': None, 'scraped_at__45': datetime.datetime(2026, 7, 10, 22, 9, 6, 184720, tzinfo=datetime.timezone.utc), 'file_extension__45': 'pdf', 'updated_at__45': datetime.datetime(2026, 7, 10, 22, 9, 6, 230201, tzinfo=datetime.timezone.utc), 'meeting_db_id__45': 4843, 'document_url__45': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220523_430/2001_CP22-175.pdf', 'meeting_id__45': '429', 'created_at__45': datetime.datetime(2026, 7, 10, 22, 9, 6, 230200, tzinfo=datetime.timezone.utc), 'text_extraction_method__45': None, 'extraction_duration_ms__45': None, 'document_title__45': 'Location Map', 'body__45': 'chandler-cc', 'file_name__45': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 15:09 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/2022/CC/20220523_430/2101_05092022_Study_session_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 ... 26092 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, 9, 6, 183752, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 9, 6, 230126, tzinfo=datetime.timezone.utc), 'meeting_db_id__0': 4843, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220523_430/2101_05092022_Study_session_FINAL.pdf', 'meeting_id__0': '429', 'created_at__0': datetime.datetime(2026, 7, 10, 22, 9, 6, 230117, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'extraction_duration_ms__0': None, 'document_title__0': 'Minutes of the Study Session Meeting of May 9, 2022', '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, 9, 6, 183791, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 9, 6, 230128, tzinfo=datetime.timezone.utc), 'meeting_db_id__1': 4843, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220523_430/2101_05122022_Regular_Meeting_FINAL.pdf', 'meeting_id__1': '429', 'created_at__1': datetime.datetime(2026, 7, 10, 22, 9, 6, 230127, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'extraction_duration_ms__1': None, 'document_title__1': 'Minutes of the Regular Meeting of May 12, 2022', 'body__1': 'chandler-cc', 'file_name__1': None, 'text_content__2': None, 'document_type__2': None ... 1004 parameters truncated ... 'body__43': 'chandler-cc', 'file_name__43': None, 'text_content__44': None, 'document_type__44': None, 'search_vector__44': None, 'content_hash__44': None, 'text_extracted_at__44': None, 'local_path__44': None, 'c_number_base__44': None, 'agenda_item_number__44': '28', 'agenda_item_id__44': 0, 'c_number__44': None, 'c_number_revision__44': None, 'jurisdiction_id__44': None, 'scraped_at__44': datetime.datetime(2026, 7, 10, 22, 9, 6, 184699, tzinfo=datetime.timezone.utc), 'file_extension__44': 'pdf', 'updated_at__44': datetime.datetime(2026, 7, 10, 22, 9, 6, 230200, tzinfo=datetime.timezone.utc), 'meeting_db_id__44': 4843, 'document_url__44': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220523_430/2001_WW2005.252_Initialed-Signed_w-recommend.pdf', 'meeting_id__44': '429', 'created_at__44': datetime.datetime(2026, 7, 10, 22, 9, 6, 230199, tzinfo=datetime.timezone.utc), 'text_extraction_method__44': None, 'extraction_duration_ms__44': None, 'document_title__44': 'Contract B&F Contracting', 'body__44': 'chandler-cc', 'file_name__44': None, 'text_content__45': None, 'document_type__45': None, 'search_vector__45': None, 'content_hash__45': None, 'text_extracted_at__45': None, 'local_path__45': None, 'c_number_base__45': None, 'agenda_item_number__45': '28', 'agenda_item_id__45': 0, 'c_number__45': None, 'c_number_revision__45': None, 'jurisdiction_id__45': None, 'scraped_at__45': datetime.datetime(2026, 7, 10, 22, 9, 6, 184720, tzinfo=datetime.timezone.utc), 'file_extension__45': 'pdf', 'updated_at__45': datetime.datetime(2026, 7, 10, 22, 9, 6, 230201, tzinfo=datetime.timezone.utc), 'meeting_db_id__45': 4843, 'document_url__45': 'https://public.destinyhosted.com/chanddocs/2022/CC/20220523_430/2001_CP22-175.pdf', 'meeting_id__45': '429', 'created_at__45': datetime.datetime(2026, 7, 10, 22, 9, 6, 230200, tzinfo=datetime.timezone.utc), 'text_extraction_method__45': None, 'extraction_duration_ms__45': None, 'document_title__45': 'Location Map', 'body__45': 'chandler-cc', 'file_name__45': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
30 item(s)