City of Chandler · Meeting 1436 failed
2024-09-09 · Study Session
City Council Study Session
Last attempted: 2026-07-10 16:13 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/2024/CC/20240909_1440/6755_Domestic-Violence-Commission_Jaime-Fernandez.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 ... 42274 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'content_hash__0': None, 'extraction_duration_ms__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 23, 13, 57, 383110, tzinfo=datetime.timezone.utc), 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240909_1440/6755_Domestic-Violence-Commission_Jaime-Fernandez.pdf', 'search_vector__0': None, 'updated_at__0': datetime.datetime(2026, 7, 10, 23, 13, 57, 424159, tzinfo=datetime.timezone.utc), 'created_at__0': datetime.datetime(2026, 7, 10, 23, 13, 57, 424148, tzinfo=datetime.timezone.utc), 'file_name__0': None, 'c_number_base__0': None, 'text_content__0': None, 'document_type__0': None, 'c_number__0': None, 'agenda_item_number__0': '1', 'jurisdiction_id__0': None, 'body__0': 'chandler-cc', 'text_extracted_at__0': None, 'meeting_id__0': '1436', 'c_number_revision__0': None, 'agenda_item_id__0': 0, 'text_extraction_method__0': None, 'meeting_db_id__0': 3744, 'local_path__0': None, 'document_title__0': 'Domestic Violence Commission Jaime Fernandez', 'file_extension__0': 'pdf', 'content_hash__1': None, 'extraction_duration_ms__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 23, 13, 57, 383219, tzinfo=datetime.timezone.utc), 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240909_1440/6637_4335_Amendment_Three.pdf', 'search_vector__1': None, 'updated_at__1': datetime.datetime(2026, 7, 10, 23, 13, 57, 424163, tzinfo=datetime.timezone.utc), 'created_at__1': datetime.datetime(2026, 7, 10, 23, 13, 57, 424162, tzinfo=datetime.timezone.utc), 'file_name__1': None, 'c_number_base__1': None, 'text_content__1': None, 'document_type__1': None, 'c_number__1': None, 'agenda_item_number__1': '2', 'jurisdiction_id__1': None, 'body__1': 'chandler-cc', 'text_extracted_at__1': None, 'meeting_id__1': '1436', 'c_number_revision__1': None, 'agenda_item_id__1': 0, 'text_extraction_method__1': None, 'meeting_db_id__1': 3744, 'local_path__1': None, 'document_title__1': '#4335 Amendment Three', 'file_extension__1': 'pdf', 'content_hash__2': None, 'extraction_duration_ms__2': None ... 1700 parameters truncated ... 'document_title__72': 'EPA Grant Application', 'file_extension__72': 'pdf', 'content_hash__73': None, 'extraction_duration_ms__73': None, 'scraped_at__73': datetime.datetime(2026, 7, 10, 23, 13, 57, 387787, tzinfo=datetime.timezone.utc), 'document_url__73': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240909_1440/6758_9.13.24_Special_Event_Liquor_Licenses_and_Tempary_and_Permanent_Extensions%C2%A0of_Liquor_License_Premises_Administratively_Approved_.pdf', 'search_vector__73': None, 'updated_at__73': datetime.datetime(2026, 7, 10, 23, 13, 57, 424354, tzinfo=datetime.timezone.utc), 'created_at__73': datetime.datetime(2026, 7, 10, 23, 13, 57, 424353, tzinfo=datetime.timezone.utc), 'file_name__73': None, 'c_number_base__73': None, 'text_content__73': None, 'document_type__73': None, 'c_number__73': None, 'agenda_item_number__73': '48', 'jurisdiction_id__73': None, 'body__73': 'chandler-cc', 'text_extracted_at__73': None, 'meeting_id__73': '1436', 'c_number_revision__73': None, 'agenda_item_id__73': 0, 'text_extraction_method__73': None, 'meeting_db_id__73': 3744, 'local_path__73': None, 'document_title__73': 'Administrative Approvals', 'file_extension__73': 'pdf', 'content_hash__74': None, 'extraction_duration_ms__74': None, 'scraped_at__74': datetime.datetime(2026, 7, 10, 23, 13, 57, 387844, tzinfo=datetime.timezone.utc), 'document_url__74': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240909_1440/6775_9.12.24_Informational_Procurement_Council_Item.pdf', 'search_vector__74': None, 'updated_at__74': datetime.datetime(2026, 7, 10, 23, 13, 57, 424357, tzinfo=datetime.timezone.utc), 'created_at__74': datetime.datetime(2026, 7, 10, 23, 13, 57, 424356, tzinfo=datetime.timezone.utc), 'file_name__74': None, 'c_number_base__74': None, 'text_content__74': None, 'document_type__74': None, 'c_number__74': None, 'agenda_item_number__74': '49', 'jurisdiction_id__74': None, 'body__74': 'chandler-cc', 'text_extracted_at__74': None, 'meeting_id__74': '1436', 'c_number_revision__74': None, 'agenda_item_id__74': 0, 'text_extraction_method__74': None, 'meeting_db_id__74': 3744, 'local_path__74': None, 'document_title__74': 'Contracts and Agreements Administratively Approved', 'file_extension__74': '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 ↗
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 ↗
- Case
-
PLH-23-0065
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-24-0009
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-24-0006
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-24-0014
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-22-0056
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-24-0013
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-24-0007
Item text
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-24-0008
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 ↗
- Case
-
CTR055782
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 ↗
- Case
-
CTR059323
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 ↗
- Case
-
C-20-0792
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 ↗
49 item(s)