Recording · Day 1

Council meeting - Public hearing

Technical details
Recording ID 830
Meeting ID 28
File path 4c953311-8dc0-4e39-bfa8-09e9e9953c29.mkv
All recordings
Recording information
Status
Completed
Duration
10h14m
Start time
2026-05-12 13:30
End time
2026-05-13 05:43
Extract audio
Extract WAV audio for transcription and diarization
Storage & files
File type Storage Path / Key Status Action
Video S3 4c953311-8dc0-4e39-bfa8-09e9e9953c29.mkv Exists
Transcript S3 e5ac6bd3-adf8-4902-a8a2-ba2f2441b468.json Exists
WAV S3 7a17177e-2c6e-47b3-b267-6283227399d8.wav Exists
Diarization Pyannote S3 5555e65c-fc83-40df-97cd-b84d408e41e9.json Exists
Diarization Consolidated S3 54c6ad38-ee84-44a5-983e-c147e8da04df.json Exists
Transcription progress
Completed
Loading transcription status…
Transcript & diarization
Full recording transcript and speaker diarization data available for download.
Processing logs
87 entries 2 errors 1 warning
16:23:30 [INFO] Consolidation completed: 968 segments (reduced from 3048)
16:23:30 [INFO] {"step": "consolidation", "status": "completed", "updated_at": "2026-06-30T10:23:30.191760-06:00", "consolidated_path": "3b6a6a55-5f63-43ea-9726-b632dc8b1552.diarization.consolidated.json", "stats": {"original_segment_count": 3048, "consolidated_segment_count": 968, "reduction_percent": 68.24}}
16:23:28 [INFO] {"step": "consolidation", "status": "processing", "updated_at": "2026-06-30T10:23:28.851269-06:00"}
20:01:50 [INFO] Chunk 2: Starting Gemini API call (model: gemini-2.5-pro, prompt length: 218000 chars)...
20:01:50 [INFO] Saved chunk input: /tmp/tmpb34nvipj/4c953311-8dc0-4e39-bfa8-09e9e9953c29.mkv.gemini_debug/chunk_002_input.json
20:01:50 [INFO] Time range: 23616.1s - 36547.7s
20:01:50 [INFO] Processing chunk 2/3 (1505 segments)
20:01:50 [INFO] --------------------------------------------------------------------------------
20:01:50 [DEBUG] Saved chunk 1 state to database
20:01:50 [INFO] Chunk 1: ✓ Refined successfully. Total speaker mappings: 28
20:01:50 [INFO] Chunk 1: Added 28 new speaker mappings. Total: 28
20:01:50 [INFO] Chunk 1: Gemini returned 50 speakers (6 refined: Councillor A. Chabot, Councillor A. Yule, Councillor D. McLean, Councillor H. Clark, Councillor L. Johnston, Mayor J. Farkas)
20:01:50 [INFO] Chunk 1: Successfully refined 8 segments with sparse mapping
20:01:49 [INFO] Saved parsed JSON: /tmp/tmpb34nvipj/4c953311-8dc0-4e39-bfa8-09e9e9953c29.mkv.gemini_debug/chunk_001_parsed.json
20:01:49 [INFO] Saved chunk response: /tmp/tmpb34nvipj/4c953311-8dc0-4e39-bfa8-09e9e9953c29.mkv.gemini_debug/chunk_001_response.txt
20:01:49 [INFO] Chunk 1: Gemini finish_reason: FinishReason.STOP
20:01:49 [INFO] Chunk 1: Received Gemini API response in 52.0s
20:00:57 [INFO] Chunk 1: Starting Gemini API call (model: gemini-2.5-pro, prompt length: 258539 chars)...
20:00:57 [INFO] Saved chunk input: /tmp/tmpb34nvipj/4c953311-8dc0-4e39-bfa8-09e9e9953c29.mkv.gemini_debug/chunk_001_input.json
20:00:57 [INFO] Time range: 775.7s - 23609.0s
20:00:57 [INFO] Processing chunk 1/3 (1500 segments)
20:00:57 [INFO] --------------------------------------------------------------------------------
20:00:57 [INFO] Prior run found but no chunks completed. Starting from chunk 1/3
20:00:57 [INFO] Chunk tracking initialized in database
20:00:57 [INFO] Creating chunk tracking records for 3 chunks
20:00:56 [INFO] Split into 3 chunks
20:00:56 [INFO] ================================================================================
20:00:56 [INFO] Councillor R. Ward, Councillor A. Yule, Councillor J. Pantazopoulos, Councillor M. Jamieson, Councillor H. Clark, Councillor R. Dhaliwal, Councillor M. Atkinson, Councillor K. Tyers, Councillor D.J. Kelly, Councillor A. Chabot, Councillor N. Schmidt, Councillor J. Wyness, Councillor L. Johnston, Councillor D. McLean, Mayor J. Farkas, Chief Administrative Officer D. Duckworth, Chief Operating Officer S. Dalgleish, City Solicitor and General Counsel J. Floen, Chief Financial Officer L. Tochor, General Manager K. Black, General Manager D. Morgan, General Manager M. Thompson, General Manager D. Hamilton, A/General Manager J. Kapala, Assistant City Solicitor T. Wobeser, Manager C. Lee, City Clerk K. Martin, Leader, Legislative Services M. A. Cario, Senior Legislative Specialist K. Picketts, Legislative Specialist A. Gagliardi, Public Speaker There were no public speakers in this section., Public Speaker No public speakers were mentioned in this section., Public Speaker No public speakers were mentioned in this section. The text only lists the names of Councillors and the Mayor who voted on the bylaw., Public Speaker There were no public speakers listed in this section., Public Speaker There are no public speakers listed in this section. The individuals named are all council members or the Mayor., Public Speaker Jack Moddle, Public Speaker There are no public speakers listed in the provided text., Public Speaker Grant Mihalcheon, Public Speaker There were no public speakers listed in this section. The names provided are all council members or the mayor., Public Speaker Brian Horton, Public Speaker Brogan Gordon-Cooper, Public Speaker There are no public speakers mentioned in the provided text., Public Speaker Jennifer Dobbin, Public Speaker Philip Bryden, Public Speaker Lei Wang, Public Speaker There are no public speakers listed in this section. The individuals mentioned are all council members or the mayor, who are excluded by the instructions., Public Speaker No public speakers were mentioned in the provided text., Public Speaker Stefan Slot, Public Speaker Collin Hnetka, Public Speaker There were no public speakers mentioned in this section., Public Speaker There were no public speakers listed in this section. The text only contains the names of council members and the mayor who voted., Public Speaker Paul Needham, Public Speaker Chris Wiebe, Public Speaker There are no public speakers mentioned in this section., Public Speaker Tony Gregov, Public Speaker Richard Craig, Public Speaker Colin Cui, Public Speaker Amaan Hameed, Public Speaker Gilberto Ancheta, Public Speaker Armando Fontelera, Public Speaker Lenin Cadang, Public Speaker Andrew Ling, Public Speaker There were no public speakers listed in this section. The text only lists the names of Councillors and the Mayor who voted., Public Speaker Shaun Thiessen, Public Speaker There are no public speakers listed in this section., Public Speaker There are no public speakers listed in this section. The text only lists the names of Councillors and the Mayor who voted., Public Speaker There were no public speakers listed in this section. The individuals named were all council members or the mayor, who are excluded by the instructions., Public Speaker Amelia Iwanicki, Public Speaker No public speakers were found in this section., Public Speaker Mya Khan, Public Speaker Oleksandr Prysyazhnyy, Public Speaker There are no public speakers listed in this section. The text only lists council members and the mayor who voted., Public Speaker Elton Ma, Public Speaker David Yee, Public Speaker There were no public speakers for this item., Public Speaker There were no public speakers mentioned in this section. The individuals listed are all council members or the mayor., Public Speaker There are no public speakers listed in this section. The names provided are all council members or the mayor.
20:00:56 [INFO] ================================================================================
20:00:56 [INFO] CHUNKING STRATEGY: Speaker list being used:
20:00:56 [INFO] ================================================================================
20:00:56 [INFO] CHUNKING: Processing 3048 segments in chunks of 1500
20:00:56 [INFO] ================================================================================
20:00:56 [WARNING] Creating debug folder: /tmp/tmpb34nvipj/4c953311-8dc0-4e39-bfa8-09e9e9953c29.mkv.gemini_debug. These folders are not auto-cleaned. Clean up with: rm -rf *.gemini_debug/
20:00:56 [INFO] Large meeting detected (3048 segments). Using chunking strategy.
20:00:48 [INFO] Starting speaker refinement
20:00:46 [INFO] Cleanup completed: 204 segments corrected
20:00:46 [INFO] {"step": "cleanup", "status": "completed", "updated_at": "2026-06-17T14:00:46.946395-06:00", "applied_count": 204}
20:00:46 [INFO] {"step": "cleanup", "status": "processing", "updated_at": "2026-06-17T14:00:46.296132-06:00"}
20:00:46 [INFO] Starting name cleanup step
20:00:46 [INFO] Diarization completed and attached: /tmp/tmpb34nvipj/4c953311-8dc0-4e39-bfa8-09e9e9953c29.mkv.diarization.pyannote.json
20:00:46 [INFO] Diarization completed successfully!
20:00:46 [INFO] {"step": "diarization", "status": "completed", "updated_at": "2026-06-17T14:00:46.216969-06:00", "output_path": "/tmp/tmpb34nvipj/4c953311-8dc0-4e39-bfa8-09e9e9953c29.mkv.diarization.pyannote.json"}
20:00:45 [INFO] Extracted 3048 turn-based segments
20:00:45 [INFO] Diarization results saved to /tmp/tmpb34nvipj/4c953311-8dc0-4e39-bfa8-09e9e9953c29.mkv.diarization.pyannote.json
20:00:45 [INFO] Job completed! Retrieving results...
20:00:45 [INFO] Job status: completed
20:00:45 [INFO] Speaker diarization completed
20:00:45 [INFO] Speaker diarization completed
20:00:45 [INFO] Poll #1: Status: succeeded
20:00:31 [INFO] Diarization job started (Job ID: 0954cd4a-5d85-4eb2-a8f3-087be07c8f50). Processing audio...
20:00:31 [INFO] Job 0954cd4a-5d85-4eb2-a8f3-087be07c8f50 already completed. Using existing results.
20:00:27 [INFO] Found existing pyannote job (ID: 0954cd4a-5d85-4eb2-a8f3-087be07c8f50). Checking status...
20:00:27 [INFO] Found existing pyannote job (ID: 0954cd4a-5d85-4eb2-a8f3-087be07c8f50). Checking status...
20:00:27 [INFO] Starting speaker diarization via pyannote.ai API
20:00:27 [INFO] Starting speaker diarization via pyannote.ai API
20:00:22 [INFO] Using S3 pre-signed URL for diarization
20:00:22 [INFO] {"step": "diarization", "status": "processing", "updated_at": "2026-06-17T14:00:22.586382-06:00"}
20:00:22 [INFO] Starting transcription + diarization
20:00:22 [INFO] Audio extracted and attached: /tmp/tmpb34nvipj/4c953311-8dc0-4e39-bfa8-09e9e9953c29.wav
20:00:22 [INFO] {"step": "extraction", "status": "completed", "updated_at": "2026-06-17T14:00:22.572153-06:00", "wav_path": "/tmp/tmpb34nvipj/4c953311-8dc0-4e39-bfa8-09e9e9953c29.wav"}
19:59:52 [INFO] Audio extracted to /tmp/tmpb34nvipj/4c953311-8dc0-4e39-bfa8-09e9e9953c29.wav
19:53:56 [INFO] Extracting audio to WAV format
19:53:56 [INFO] Extracting audio to WAV format
19:53:56 [INFO] {"step": "extraction", "status": "processing", "updated_at": "2026-06-17T13:53:56.543548-06:00"}
19:53:56 [INFO] Starting audio extraction
19:52:51 [INFO] Downloading video from S3 for processing
19:34:16 [INFO] Job submitted successfully via webhook. Returning early.
19:34:16 [INFO] Webhooks enabled: https://ccai-api.pixeltree.ca/api/webhooks/pyannote
19:34:16 [INFO] Submitting diarization + transcription job to pyannote.ai (URL: https://ccai-prod.s3.amazonaws.com/e18e1d23-00ed-4f9a-85f5-60fc9ae3cf0a.wav?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAQK6LNXA7XP5KSEWG%2F20260617%2Fca-central-1%2Fs3%2Faws4_request&X-Amz-Date=20260617T193415Z&X-Amz-Expires=3600&X-Amz-SignedHeaders=host&X-Amz-Signature=34a31d64afe53b7ab47b4ed585d6a8bc44fe7db222be3db611479e8724757dad)
19:34:16 [INFO] Starting speaker diarization via pyannote.ai API
19:34:16 [INFO] Starting speaker diarization via pyannote.ai API
19:34:15 [INFO] Using S3 pre-signed URL for diarization
19:34:15 [INFO] {"step": "diarization", "status": "processing", "updated_at": "2026-06-17T13:34:15.612047-06:00"}
19:34:15 [INFO] Starting transcription + diarization
19:34:15 [INFO] Audio extracted and attached: /tmp/tmpnjg57lbw/4c953311-8dc0-4e39-bfa8-09e9e9953c29.wav
19:34:15 [INFO] {"step": "extraction", "status": "completed", "updated_at": "2026-06-17T13:34:15.588127-06:00", "wav_path": "/tmp/tmpnjg57lbw/4c953311-8dc0-4e39-bfa8-09e9e9953c29.wav"}
19:33:44 [INFO] Audio extracted to /tmp/tmpnjg57lbw/4c953311-8dc0-4e39-bfa8-09e9e9953c29.wav
19:28:06 [INFO] Extracting audio to WAV format
19:28:06 [INFO] Extracting audio to WAV format
19:28:06 [INFO] {"step": "extraction", "status": "processing", "updated_at": "2026-06-17T13:28:06.550979-06:00"}
19:28:06 [INFO] Starting audio extraction
19:26:55 [INFO] Downloading video from S3 for processing
19:15:48 [INFO] Download completed successfully
19:09:54 [INFO] Manual retry initiated by user
16:51:52 [ERROR] Step full failed: Recording 830 has no file path
16:41:18 [ERROR] Step full failed: Recording 830 has no file path