Name: Study Session Meeting — City Council Study Session — Apr 19, 2021
Start: 2021-04-19

← Back to meetings

City of Chandler · Meeting 85 failed

2021-04-19 · Study Session

Items: 38 / 38

City Council Study Session

View on Agenda Online ↗

Synced: 2026-06-03 13:18 AZ
Last attempted: 2026-07-10 14:51 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/20210419_85/279_Sunland_Construction_Contract.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 ... 45622 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'meeting_id__0': '85', 'scraped_at__0': datetime.datetime(2026, 7, 10, 21, 51, 22, 628072, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'c_number__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210419_85/279_Sunland_Construction_Contract.pdf', 'meeting_db_id__0': 4632, '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, 51, 22, 666799, tzinfo=datetime.timezone.utc), 'agenda_item_id__0': 0, 'created_at__0': datetime.datetime(2026, 7, 10, 21, 51, 22, 666789, tzinfo=datetime.timezone.utc), 'document_title__0': 'Construction Contract Sunland', 'search_vector__0': None, 'file_name__0': None, 'jurisdiction_id__0': None, 'meeting_id__1': '85', 'scraped_at__1': datetime.datetime(2026, 7, 10, 21, 51, 22, 628193, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'c_number__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210419_85/279_CP21-084_Location_Map.pdf', 'meeting_db_id__1': 4632, '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, 51, 22, 666803, tzinfo=datetime.timezone.utc), 'agenda_item_id__1': 0, 'created_at__1': datetime.datetime(2026, 7, 10, 21, 51, 22, 666802, tzinfo=datetime.timezone.utc), 'document_title__1': 'Location Map', 'search_vector__1': None, 'file_name__1': None, 'jurisdiction_id__1': None, 'meeting_id__2': '85', 'scraped_at__2': datetime.datetime(2026, 7, 10, 21, 51, 22, 628264, tzinfo=datetime.timezone.utc) ... 1844 parameters truncated ... 'file_name__78': None, 'jurisdiction_id__78': None, 'meeting_id__79': '85', 'scraped_at__79': datetime.datetime(2026, 7, 10, 21, 51, 22, 633458, tzinfo=datetime.timezone.utc), 'file_extension__79': 'pdf', 'c_number__79': None, 'document_url__79': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210419_85/323_4302AgreementLegalInitial_KUV_Signed.pdf', 'meeting_db_id__79': 4632, 'text_extracted_at__79': None, 'content_hash__79': None, 'extraction_duration_ms__79': None, 'text_extraction_method__79': None, 'agenda_item_number__79': '36', 'text_content__79': None, 'body__79': 'chandler-cc', 'document_type__79': None, 'c_number_revision__79': None, 'c_number_base__79': None, 'local_path__79': None, 'updated_at__79': datetime.datetime(2026, 7, 10, 21, 51, 22, 667012, tzinfo=datetime.timezone.utc), 'agenda_item_id__79': 0, 'created_at__79': datetime.datetime(2026, 7, 10, 21, 51, 22, 667011, tzinfo=datetime.timezone.utc), 'document_title__79': 'Agreement - KUV Consultants', 'search_vector__79': None, 'file_name__79': None, 'jurisdiction_id__79': None, 'meeting_id__80': '85', 'scraped_at__80': datetime.datetime(2026, 7, 10, 21, 51, 22, 633525, tzinfo=datetime.timezone.utc), 'file_extension__80': 'pdf', 'c_number__80': None, 'document_url__80': 'https://public.destinyhosted.com/chanddocs/2021/CC/20210408_96/363_3521Amend2Vendor.pdf', 'meeting_db_id__80': 4632, 'text_extracted_at__80': None, 'content_hash__80': None, 'extraction_duration_ms__80': None, 'text_extraction_method__80': None, 'agenda_item_number__80': '38', 'text_content__80': None, 'body__80': 'chandler-cc', 'document_type__80': None, 'c_number_revision__80': None, 'c_number_base__80': None, 'local_path__80': None, 'updated_at__80': datetime.datetime(2026, 7, 10, 21, 51, 22, 667015, tzinfo=datetime.timezone.utc), 'agenda_item_id__80': 0, 'created_at__80': datetime.datetime(2026, 7, 10, 21, 51, 22, 667014, tzinfo=datetime.timezone.utc), 'document_title__80': 'Amendment No. 1 Traffic Solutions', 'search_vector__80': None, 'file_name__80': None, 'jurisdiction_id__80': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)