- Added delete button next to 'View Result' for completed jobs in history.html
- Button appears only for completed jobs and includes confirmation dialog
- Uses existing /job/{job_id}/delete route which already handles ownership checks
- Maintains consistent styling with other action buttons

Users can now clean up their completed job history by deleting individual jobs they no longer need.

- Enhanced cluster_master.select_worker_for_job() with more robust GPU detection:
  - Added flexible GPU info parsing with fallbacks
  - Support for incomplete GPU info structures
  - Allow CPU workers as fallback when no GPU workers available
  - Added detailed debug logging for troubleshooting worker selection
- Fixed queue._execute_local_job() to properly poll for backend results:
  - Changed from simulate processing to actual result polling
  - Added timeout handling (10 minutes max)
  - Proper error handling for failed jobs
- Simplified backend.handle_web_message() to use local worker routing:
  - Removed async cluster master calls that were failing
  - Use direct worker socket communication for local processing
- These changes should resolve the 'No suitable distributed worker' issue and make local processing work properly

The system now properly detects GPU workers, falls back to CPU workers if needed, and correctly processes jobs locally when distributed workers aren't available.

- Fixed JavaScript error in analyze.html: 'data.result.substring is not a function' by checking if data.result is a string before calling substring, converting objects to JSON string if needed
- Added debug logging to cluster_master.select_worker_for_job() to diagnose why no distributed workers are found when GPU clients are connected
- Debug logs show available processes and process queue to help identify registration issues

This should resolve the JavaScript console error and help debug why cluster workers aren't being selected for jobs.

- Added cancel_job method to QueueManager for cancelling running jobs
- Added /job/<id>/cancel route in web.py for cancelling jobs via POST
- Updated history.html template to show:
  - Cancel button for processing jobs (orange button)
  - Delete button for cancelled jobs (red button)
  - Cancelled status styling (gray background)
- Added JavaScript updateJobActions function for dynamic action updates
- Modified worker_analysis.py to check for job cancellation during processing:
  - Added check_job_cancelled function to query database
  - Modified analyze_media to check cancellation before each frame and summary
  - Workers now stop processing and return 'Job cancelled by user' message
- Updated queue.py to pass job_id in data sent to workers for cancellation checking
- Job cancellation works for both local and distributed workers

Users can now cancel running analysis jobs from the history page, and cancelled jobs can be deleted from history.

- Made transformers import conditional in models.py to avoid import errors when not installed
- Fixed update_queue_status call to use 'error' parameter instead of 'error_message'
- Added checks for transformers availability before using it in model loading
- This resolves the ModuleNotFoundError and TypeError when running jobs

The system can now handle job scheduling even when transformers library is not available, and properly reports errors when job execution fails.

- Added get_queue_status to the database imports in web.py
- This fixes the NameError when accessing /api/job_status/<job_id>
- The job status API endpoint now works correctly for real-time job monitoring

- Changed analyze route to stay on page after job submission instead of redirecting to history
- Added submitted_job parameter to template to track current job
- Modified sidebar to show for all users (not just admins)
- Added job progress section in sidebar that displays:
  - Job ID and status (queued/processing/completed/failed)
  - Tokens used
  - Result preview
- Added /api/job_status/<job_id> endpoint for real-time job status
- Added JavaScript polling for job status updates every 2 seconds
- Job progress updates automatically without page refresh
- Users can see their analysis job progress in real-time in the sidebar

The analyze page now provides immediate feedback and progress tracking instead of requiring navigation to the history page.

- Fixed process type mapping in queue manager ('analyze' -> 'analysis', 'train' -> 'training')
- Implemented actual job sending in cluster master assign_job_to_worker()
- Modified cluster client to forward jobs to local backend and monitor results
- Added result polling mechanism for cluster jobs
- Jobs should now execute on connected cluster workers instead of remaining queued

The issue was that jobs were being assigned but never sent to workers. Now:
1. Queue manager selects worker using VRAM-aware logic
2. Cluster master assigns job and sends it via websocket
3. Cluster client receives job and forwards to local backend
4. Cluster client polls backend for results and sends back to master
5. Results are properly returned to web interface

- Updated queue manager to use select_worker_for_job() and assign_job_to_worker() instead of unimplemented assign_job_with_model()
- Now properly implements VRAM-aware worker selection based on model requirements
- Jobs will be assigned to distributed workers when available with sufficient VRAM
- Falls back to local processing when no suitable distributed worker is found
- Added proper error handling and logging for job assignment process

- Fixed 'list.append() takes exactly one argument (0 given)' error in update_queue_status
- Removed empty params.append() calls for timestamp fields that use CURRENT_TIMESTAMP directly
- Queue processing should now work correctly without errors

- Add delete_queue_item function to database.py with ownership validation
- Add delete_job method to QueueManager class
- Add /job/<id>/delete endpoint in web.py with user authentication
- Update history.html template to show delete button for queued jobs
- Only allow users to delete their own jobs or admins to delete any job
- Add confirmation dialog for job deletion

- Make assign_job_with_model synchronous and return None to trigger local fallback
- Remove asyncio from queue processing to avoid threading issues
- Jobs now properly execute locally when no distributed workers are available
- Maintain async file transfer infrastructure for future distributed worker support

- Convert assign_job_with_model and assign_job_to_worker to synchronous methods
- Remove asyncio dependencies from queue processing
- Simplify model transfer to avoid async websocket calls for now
- Fix syntax errors in cluster_master.py

- Add VRAM requirement estimation for models
- Implement intelligent worker selection based on VRAM, weight, and load
- Add support for concurrent job execution with VRAM tracking
- Integrate RunPod pod creation and management as fallback
- Implement model loading/unloading logic to avoid redundant transfers
- Add file transfer handling for shared storage and websocket fallback
- Update queue system to use advanced cluster scheduling
- Add job_id column to processing_queue table
- Update web interface to submit jobs through queue system
- Fix function name references in cluster master

Implement advanced job scheduling system with VRAM-aware worker selection, job queuing, RunPod integration, model management, and real-time notifications

- Add VRAM requirement determination for models
- Implement intelligent worker selection based on VRAM availability and weights
- Add job queuing when no workers available with automatic retry
- Integrate RunPod pod creation and management for scaling
- Implement model loading/unloading with reference counting
- Add file transfer support for remote workers (shared storage + websocket)
- Enable concurrent job processing with VRAM tracking
- Create job results page with detailed output display
- Add real-time job completion notifications with result links
- Update history page with live progress updates and result links
- Fix async handling in cluster master websocket communication
- Add database schema updates for job tracking

- When only 1 video-capable model exists, include hidden input field
- Form still submits the correct model_path value
- Maintains proper form functionality while hiding UI when not needed

- Model selection now only shows when there are 2+ video-capable models
- When only 1 model is available, no model selection is shown (uses it automatically)
- Removed the fallback text input that was showing inappropriately

- Show model dropdown only when multiple video-capable models are available
- Filter models by 'video to text' capabilities and availability status
- Admins see all models, regular users see only available ones
- Fall back to text input when only one or no models are available

- Added detect_model_capabilities function that analyzes HF model tags and pipeline
- Auto-detects capabilities for Hugging Face models when adding via admin or --model
- Special handling for known models like Qwen VL, LLaVA, Whisper, etc.
- Updated UI with hints about auto-detection

- Added capabilities TEXT column to models table
- Updated admin interface to show and edit model capabilities
- Default model has 'video to text, image to text' capabilities
- Added Capabilities column to models table

- Added function to retrieve only available models for frontend/API use

- Added available BOOLEAN column to models table
- Default model is marked as available
- Models specified via --model are marked as available
- Updated admin interface to show and edit availability status
- Added Status column to models table showing Available/Hidden

- Added UNIQUE constraint on path column in models table
- Added cleanup query to remove duplicate models, keeping only one per path

- Modified init_db to check for existing default model before inserting
- Prevents multiple insertions of the same model

- Added ensure_model_exists function to database.py
- Modified vidai.py to call ensure_model_exists when --model is specified
- Automatically detects Hugging Face vs local models

- Added models table to database
- Created admin routes for model CRUD operations
- Added models.html template
- Added models link to admin dropdown
- Implemented Hugging Face model download functionality
- Added download_huggingface_model function in utils.py