City of Chandler · Meeting 1971 failed
2025-10-13 · Study Session
City Council Study Session
Last attempted: 2026-07-10 16:34 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/2025/CC/20251013_1975/8708_Resolution_5941_-_Accept_ADOT_Grant_for_S_Rwy_Rehab.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 ... 35020 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'text_content__0': None, 'document_title__0': 'Resolution No. 5941', 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2025/CC/20251013_1975/8708_Resolution_5941_-_Accept_ADOT_Grant_for_S_Rwy_Rehab.pdf', 'created_at__0': datetime.datetime(2026, 7, 10, 23, 34, 8, 758271, tzinfo=datetime.timezone.utc), 'text_extracted_at__0': None, 'local_path__0': None, 'c_number_revision__0': None, 'document_type__0': None, 'updated_at__0': datetime.datetime(2026, 7, 10, 23, 34, 8, 758276, tzinfo=datetime.timezone.utc), 'scraped_at__0': datetime.datetime(2026, 7, 10, 23, 34, 8, 728183, tzinfo=datetime.timezone.utc), 'body__0': 'chandler-cc', 'c_number_base__0': None, 'jurisdiction_id__0': None, 'agenda_item_number__0': '1', 'search_vector__0': None, 'agenda_item_id__0': 0, 'meeting_db_id__0': 2095, 'content_hash__0': None, 'extraction_duration_ms__0': None, 'text_extraction_method__0': None, 'c_number__0': None, 'meeting_id__0': '1971', 'file_name__0': None, 'file_extension__0': 'pdf', 'text_content__1': None, 'document_title__1': 'Notice of Intention', 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2025/CC/20251013_1975/8746_FY_2025-2026_Notice_of_Intention_2026_Utility_Rates.pdf', 'created_at__1': datetime.datetime(2026, 7, 10, 23, 34, 8, 758277, tzinfo=datetime.timezone.utc), 'text_extracted_at__1': None, 'local_path__1': None, 'c_number_revision__1': None, 'document_type__1': None, 'updated_at__1': datetime.datetime(2026, 7, 10, 23, 34, 8, 758277, tzinfo=datetime.timezone.utc), 'scraped_at__1': datetime.datetime(2026, 7, 10, 23, 34, 8, 728233, tzinfo=datetime.timezone.utc), 'body__1': 'chandler-cc', 'c_number_base__1': None, 'jurisdiction_id__1': None, 'agenda_item_number__1': '2', 'search_vector__1': None, 'agenda_item_id__1': 0, 'meeting_db_id__1': 2095, 'content_hash__1': None, 'extraction_duration_ms__1': None, 'text_extraction_method__1': None, 'c_number__1': None, 'meeting_id__1': '1971', 'file_name__1': None, 'file_extension__1': 'pdf', 'text_content__2': None, 'document_title__2': 'Utility Rate Adjustment Summary' ... 1388 parameters truncated ... 'file_name__59': None, 'file_extension__59': 'pdf', 'text_content__60': None, 'document_title__60': 'Special Event Liquor', 'document_url__60': 'https://public.destinyhosted.com/chanddocs/2025/CC/20251013_1975/8718_10.16.25_Special_Event_Liquor_Licenses_and_Tempary_and_Permanent_Extensions%C2%A0of_Liquor_License_Premises_Administratively_Approved_.pdf', 'created_at__60': datetime.datetime(2026, 7, 10, 23, 34, 8, 758326, tzinfo=datetime.timezone.utc), 'text_extracted_at__60': None, 'local_path__60': None, 'c_number_revision__60': None, 'document_type__60': None, 'updated_at__60': datetime.datetime(2026, 7, 10, 23, 34, 8, 758326, tzinfo=datetime.timezone.utc), 'scraped_at__60': datetime.datetime(2026, 7, 10, 23, 34, 8, 729665, tzinfo=datetime.timezone.utc), 'body__60': 'chandler-cc', 'c_number_base__60': None, 'jurisdiction_id__60': None, 'agenda_item_number__60': '41', 'search_vector__60': None, 'agenda_item_id__60': 0, 'meeting_db_id__60': 2095, 'content_hash__60': None, 'extraction_duration_ms__60': None, 'text_extraction_method__60': None, 'c_number__60': None, 'meeting_id__60': '1971', 'file_name__60': None, 'file_extension__60': 'pdf', 'text_content__61': None, 'document_title__61': 'Contracts and Agreements Administratively Approved', 'document_url__61': 'https://public.destinyhosted.com/chanddocs/2025/CC/20251013_1975/8740_10.16.25_Informational_Procurement_Council_Item.pdf', 'created_at__61': datetime.datetime(2026, 7, 10, 23, 34, 8, 758327, tzinfo=datetime.timezone.utc), 'text_extracted_at__61': None, 'local_path__61': None, 'c_number_revision__61': None, 'document_type__61': None, 'updated_at__61': datetime.datetime(2026, 7, 10, 23, 34, 8, 758327, tzinfo=datetime.timezone.utc), 'scraped_at__61': datetime.datetime(2026, 7, 10, 23, 34, 8, 729686, tzinfo=datetime.timezone.utc), 'body__61': 'chandler-cc', 'c_number_base__61': None, 'jurisdiction_id__61': None, 'agenda_item_number__61': '42', 'search_vector__61': None, 'agenda_item_id__61': 0, 'meeting_db_id__61': 2095, 'content_hash__61': None, 'extraction_duration_ms__61': None, 'text_extraction_method__61': None, 'c_number__61': None, 'meeting_id__61': '1971', 'file_name__61': None, 'file_extension__61': 'pdf'}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
CTR070553
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-24-0030
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-25-0019
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-25-0011
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
CTR062668
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
CTR076065
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
CTR052847
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
42 item(s)