Accusys 874d688987 feat: deploy hybrid search (semantic+keyword+identity) with RRF fusion ...

- Replace smart_search with hybrid RRF implementation
- Add speaker_detections table for identity-agent binding
- Fix identity queries: direct SQL to avoid type mismatches
- Add debug logs to job_worker for processor debugging
- Deployed to production (3002) successfully

Key changes:
- search.rs: Complete rewrite with 3 strategies + RRF
- postgres_db.rs: speaker_detections table + identity query fixes
- job_worker.rs: Debug logs for output file checks

Tested:
- Hybrid search works with semantic + keyword + identity
- Identity search: 'identity:Charade' returns correct results
- Chinese keyword search: '調光' matches Charade summaries

Bugs found:
- Case mismatch: 'ASRX' vs 'asrx' in processors field
- Missing CUT dependency for ASRX processor

2026-06-01 15:15:17 +08:00

..

REPORTS

feat: service inventory, ERP reports, sqlite-vec integration, visualize tool

2026-05-13 02:37:45 +08:00

2026-05-06_5w1h_verification.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-06_5w1h_vs_story_comparison.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-06_api_verification.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-06_pipeline_test.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-06_search_test.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-06_vector_data_status.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_ane_embedding_config_change.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_ane_embedding_install_guide.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_ane_embedding_test_plan.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_ane_embedding_test_result.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_embedding_benchmark_final.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_embedding_benchmark_m4.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_embedding_benchmark.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_embedding_models_from_M5.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_export_package_design.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_git_push_ready.md

M5 repo open for push, add guide for M4

2026-05-08 00:41:39 +08:00

2026-05-07_M4_M5_pipeline_division.md

feat: Phase 1 handover - schema migration, correction mechanism, API fixes

2026-05-11 07:03:22 +08:00

2026-05-07_M4_pipeline_failure_analysis.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_M5_proposal_embedding_deployment.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_M5_recent_changes_for_sync.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_M5_release_ready.md

Notify M4: release ready for sync

2026-05-08 01:01:34 +08:00

2026-05-07_M5_sync_ready.md

feat: Phase 1 handover - schema migration, correction mechanism, API fixes

2026-05-11 07:03:22 +08:00

2026-05-07_pdf_processing_discussion.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_pipeline_issues_analysis.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_pipeline_progress_report_template.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_response_to_M5.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-07_single_frame_photo_test_report.md

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

2026-05-08_bitmap_font_to_drawtext.md

M4: suggest replace bitmap font with drawtext filter

2026-05-08 13:21:40 +08:00

2026-05-08_bug_parent_chunks_missing_columns.md

M4: bug report - parent_chunks missing summary_vector/scene_order

2026-05-08 01:26:43 +08:00

2026-05-08_bug_search_uuid_column.md

M4: bug report - search uuid→file_uuid column rename

2026-05-08 01:11:54 +08:00

2026-05-08_bug_smart_search_ollama_migration.md

M4: bug report - smart search still uses Ollama/mxbai

2026-05-08 01:22:31 +08:00

2026-05-08_bug_video_endpoints_500.md

M4: update bug report - found root cause ARG_MAX overflow

2026-05-08 13:03:21 +08:00

2026-05-08_fix_video_endpoints.md

Fix guide for M4 video endpoints 500

2026-05-08 12:52:12 +08:00

2026-05-08_physical_feature_anomaly_experiment.md

feat: Phase 1 handover - schema migration, correction mechanism, API fixes

2026-05-11 07:03:22 +08:00

2026-05-08_release_v1.0.0.md

Release v1.0.0 notification

2026-05-08 01:46:40 +08:00

2026-05-08_release_V1.0.0.md

feat: Phase 1 handover - schema migration, correction mechanism, API fixes

2026-05-11 07:03:22 +08:00

2026-05-08_response_ffmpeg_evaluation.md

M4: add ffmpeg-full licensing evaluation for M5's doc

2026-05-08 13:28:16 +08:00

2026-05-08_standardize_list_pagination.md

feat: Phase 1 handover - schema migration, correction mechanism, API fixes

2026-05-11 07:03:22 +08:00

2026-05-08_video_endpoints_fix.md

Notify M4: video endpoints root cause

2026-05-08 13:16:05 +08:00

2026-05-09_git_bundle_instructions.md

docs: git bundle instructions for M4 (SSH disabled)

2026-05-09 06:25:45 +08:00

2026-05-09_git_pull_instructions.md

feat: Phase 1 handover - schema migration, correction mechanism, API fixes

2026-05-11 07:03:22 +08:00

2026-05-09_M4_status_report.md

feat: Phase 1 handover - schema migration, correction mechanism, API fixes

2026-05-11 07:03:22 +08:00

2026-05-09_M5_design_ready.md

feat: Phase 1 handover - schema migration, correction mechanism, API fixes

2026-05-11 07:03:22 +08:00

2026-05-09_singular_plural_api_review.md

feat: Phase 1 handover - schema migration, correction mechanism, API fixes

2026-05-11 07:03:22 +08:00

2026-05-09_TKG_integration.md

feat: wire TKG builder into worker pipeline + face-face edges

2026-05-09 06:22:27 +08:00

2026-05-11_chunk_detail_endpoint.md

fix: M4 Phase 1 bugs - dev.chunks refs, search_path, uuid column

2026-05-11 10:21:06 +08:00

2026-05-11_copy_import_issue.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-11_delivery_checklist_response.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-11_delivery_checklist.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-11_package_delivery_spec.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-11_Phase1_bug_report.md

fix: M4 Phase 1 bugs - dev.chunks refs, search_path, uuid column

2026-05-11 10:21:06 +08:00

2026-05-11_portal_setup_fix.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-11_release_packaging_v2.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-11_request_post_correction_backup.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-11_v1.0.3_issues.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-12_api_doc_fixes.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-12_api_doc_verification.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-12_docs_structure_proposal.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-12_package_receive_checklist.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-12_tkg_unified_spec.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_111614_test_report.md

M4 handover: coordinate fixes, detector registry, deploy v2, YOLOv8s, identity lifecycle

2026-05-13 20:00:47 +08:00

2026-05-13_api_3002_test_report.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_api_test_v2_compatibility_response.md

fix: M4 api_test v2 compatibility — chunk ID format + response

2026-05-13 05:00:59 +08:00

2026-05-13_api_test_v2_compatibility.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_chunk_vectors_unique_conflict.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_chunk_vectors_unique_response.md

fix: drop redundant chunk_vectors chunk_id unique constraint

2026-05-13 22:42:03 +08:00

2026-05-13_coordinate_registry_report.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_deploy_111614_response.md

fix: deploy.sh build check lenient + per-file import order (M4 feedback)

2026-05-13 20:15:44 +08:00

2026-05-13_deploy_required_files_fix.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_deploy_required_files_response.md

docs: reply to M4 on REQUIRED_FILES fix

2026-05-13 20:20:36 +08:00

2026-05-13_deploy_script_fix.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_deploy_script_response.md

M4 handover: coordinate fixes, detector registry, deploy v2, YOLOv8s, identity lifecycle

2026-05-13 20:00:47 +08:00

2026-05-13_deploy_sh_remaining.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_landmark_coord_mismatch.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_release_binary_owner.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_release_decision_request.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_release_decision_response.md

fix: M5 provides release binary, not M4

2026-05-13 21:05:08 +08:00

2026-05-13_release_delivery.md

docs: release delivery — binary + 2 packages

2026-05-13 21:11:31 +08:00

2026-05-13_release_fixes_required.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_release_fixes_response.md

docs: reply to M4 release fixes — pre-clean all tables + SCHEMA variable

2026-05-13 22:05:53 +08:00

2026-05-13_release_notes.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_release_sop_draft.md

fix: drop redundant chunk_vectors chunk_id unique constraint

2026-05-13 22:42:03 +08:00

2026-05-13_scan_status_issues.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-13_trace_audio_fix_response.md

docs: notify M4 of trace video audio fix + updated binary

2026-05-13 23:46:52 +08:00

2026-05-13_v2_package_issues.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-14_binary_crash_response.md

docs: reclassify — DESIGN→STANDARDS, conversion→M5_workspace, cleanup

2026-05-15 12:18:29 +08:00

2026-05-14_binary_crash.md

docs: reclassify — DESIGN→STANDARDS, conversion→M5_workspace, cleanup

2026-05-15 12:18:29 +08:00

2026-05-14_binary_source_delivery.md

docs: notify M4 of binary + source delivery

2026-05-14 02:34:53 +08:00

2026-05-14_cut_merge_delivery.md

docs: deliver cut-based trace merge package

2026-05-14 03:12:55 +08:00

2026-05-14_deploy_26f2434_response.md

docs: reclassify — DESIGN→STANDARDS, conversion→M5_workspace, cleanup

2026-05-15 12:18:29 +08:00

2026-05-14_deploy_194a3b1_response.md

docs: reclassify — DESIGN→STANDARDS, conversion→M5_workspace, cleanup

2026-05-15 12:18:29 +08:00

2026-05-14_deploy_080830_response.md

docs: reclassify — DESIGN→STANDARDS, conversion→M5_workspace, cleanup

2026-05-15 12:18:29 +08:00

2026-05-14_deploy_fc1d775_response.md

docs: reclassify — DESIGN→STANDARDS, conversion→M5_workspace, cleanup

2026-05-15 12:18:29 +08:00

2026-05-14_deploy_force_flag.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-14_deploy_force_response.md

docs: reply to M4 --force request

2026-05-14 01:54:09 +08:00

2026-05-14_gdino_optimization_design.md

feat: GDINO A+B — time-bounded search (9s vs 130s) + parameterized interval

2026-05-14 13:57:25 +08:00

2026-05-14_inference_down_response.md

docs: reclassify — DESIGN→STANDARDS, conversion→M5_workspace, cleanup

2026-05-15 12:18:29 +08:00

2026-05-14_inference_down.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-14_package_084324_response.md

docs: reclassify — DESIGN→STANDARDS, conversion→M5_workspace, cleanup

2026-05-15 12:18:29 +08:00

2026-05-14_pipeline_services_checklist_response.md

docs: reclassify — DESIGN→STANDARDS, conversion→M5_workspace, cleanup

2026-05-15 12:18:29 +08:00

2026-05-14_pipeline_services_checklist.md

docs: pipeline services checklist for M4

2026-05-14 17:05:18 +08:00

2026-05-14_pipeline_v2_delivery.md

docs: deliver pipeline v2 package to M4 — cut-aware traces + TMDB + TKG

2026-05-14 01:36:26 +08:00

2026-05-14_pipeline_v2_deploy_report.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-14_pipeline_v2_deploy_response.md

docs: reply to M4 deploy report — clarify trace/TKG counts, identities issue

2026-05-14 01:58:43 +08:00

2026-05-14_progress_report.md

docs: M5 progress report — face tracker, bug fixes, pipeline

2026-05-14 03:37:01 +08:00

2026-05-14_register_api_404_response.md

docs: reclassify — DESIGN→STANDARDS, conversion→M5_workspace, cleanup

2026-05-15 12:18:29 +08:00

2026-05-14_register_api_404.md

chore: track M4's register_api_404 report

2026-05-15 03:28:38 +08:00

2026-05-14_schemafix_binary_response.md

docs: reply to M4 with freshly built binary from HEAD

2026-05-14 03:45:55 +08:00

2026-05-14_schemafix_binary_still_dev.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-14_trace_mode_api_update.md

docs: notify M4 of trace video mode param

2026-05-14 02:48:15 +08:00

2026-05-14_trace_schema_fix_response.md

docs: reply to M4 on trace schema hardcode fix

2026-05-14 02:56:59 +08:00

2026-05-14_trace_schema_hardcode.md

docs: fix start/end → start_frame/end_frame in API docs

2026-05-14 17:57:00 +08:00

2026-05-15_delivery_c41f7e0_response.md

docs: add REFERENCE docs, M4 workspace, Caddyfile

2026-05-16 03:11:32 +08:00

2026-05-15_delivery_c41f7e0.md

docs: add REFERENCE docs, M4 workspace, Caddyfile

2026-05-16 03:11:32 +08:00

2026-05-15_deploy_29eca5a_report.md

docs: add REFERENCE docs, M4 workspace, Caddyfile

2026-05-16 03:11:32 +08:00

2026-05-15_m5_wordpress_install_report.md

docs: add REFERENCE docs, M4 workspace, Caddyfile

2026-05-16 03:11:32 +08:00

2026-05-15_portal_api_review.md

docs: add REFERENCE docs, M4 workspace, Caddyfile

2026-05-16 03:11:32 +08:00

2026-05-15_RCA_identity_uuid_and_appearance.md

docs: RCA — identity_uuid missing + file identities NULL appearance

2026-05-15 10:59:23 +08:00

2026-05-15_source_sync_request.md

docs: add REFERENCE docs, M4 workspace, Caddyfile

2026-05-16 03:11:32 +08:00

2026-05-15_worker_crash_response.md

docs: add REFERENCE docs, M4 workspace, Caddyfile

2026-05-16 03:11:32 +08:00

2026-05-15_worker_pool_timeout_followup.md

docs: add REFERENCE docs, M4 workspace, Caddyfile

2026-05-16 03:11:32 +08:00

2026-05-15_worker_pool_timeout_response.md

docs: add REFERENCE docs, M4 workspace, Caddyfile

2026-05-16 03:11:32 +08:00

2026-05-15_worker_status_report.md

docs: add REFERENCE docs, M4 workspace, Caddyfile

2026-05-16 03:11:32 +08:00

2026-05-17_file_uuid_rule.md

docs: file_uuid generation rules for M4

2026-05-17 02:26:09 +08:00

2026-05-29_library_page_flash_filter_fix.md

docs: save handoff - library page flash & filter fix

2026-05-29 23:12:09 +08:00

2026-05-29_wp_api_url_update.md

docs: record WordPress API URL update session progress

2026-05-29 19:06:15 +08:00

2026-06-01_hybrid_search_test_report.md

feat: deploy hybrid search (semantic+keyword+identity) with RRF fusion

2026-06-01 15:15:17 +08:00

convert_embed_to_coreml.py

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

M4_NOTIFICATION_PROTOCOL.md

docs: add M4 notification protocol — standardize response format

2026-05-13 20:01:45 +08:00

Momentry_API_Training_Marcom.md

feat: Phase 1 handover - schema migration, correction mechanism, API fixes

2026-05-11 07:03:22 +08:00

test_coreml_embed.py

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00

test_coreml_full.py

Initial commit: docs_v1.0 structure

2026-05-07 23:42:19 +08:00