gistfile1.txt

2025-10-13 20:10:34,954 - INFO - backend.pgroll_migrations - Current pgroll status: {
plaicin-backend-1       |   "schema": "public",
plaicin-backend-1       |   "version": "028_add_pdfs_table_trigger",
plaicin-backend-1       |   "status": "Complete"
plaicin-backend-1       | }
plaicin-backend-1       | 
plaicin-backend-1       | 2025-10-13 20:10:34,954 - INFO - backend.pgroll_migrations - Running all pending migrations with auto-complete...
plaicin-backend-1       | 2025-10-13 20:10:34,954 - INFO - backend.pgroll_migrations - Note: In local mode, all migrations auto-complete (including manual ones)
plaicin-backend-1       | 2025-10-13 20:10:35,066 - ERROR - backend.pgroll_migrations - pgroll command failed: Error: failed to get migrations to apply: remote migration does not match local migration: remote="028_add_pdfs_table_trigger_20251008192816798073", local="029_add_status_to_variant_tables"
plaicin-backend-1       | 
plaicin-backend-1       | 2025-10-13 20:10:35,075 - ERROR - backend.pgroll_migrations - pgroll migrate failed: Error: failed to get migrations to apply: remote migration does not match local migration: remote="028_add_pdfs_table_trigger_20251008192816798073", local="029_add_status_to_variant_tables"
plaicin-backend-1       | 
plaicin-backend-1       | 2025-10-13 20:10:35,080 - ERROR - backend.pgroll_migrations - Migration batch failed
plaicin-backend-1       | 2025-10-13 20:10:35,084 - INFO - backend.pgroll_migrations - You can debug individual migrations using:
plaicin-backend-1       | 2025-10-13 20:10:35,084 - INFO - backend.pgroll_migrations -   1. Check status: pgroll status
plaicin-backend-1       | 2025-10-13 20:10:35,084 - INFO - backend.pgroll_migrations -   2. Complete manually: pgroll complete
plaicin-backend-1       | 2025-10-13 20:10:35,084 - INFO - backend.pgroll_migrations -   3. Rollback if needed: pgroll rollback
plaicin-backend-1       | 2025-10-13 20:10:35,084 - INFO - backend.main - Migrations completed successfully
plaicin-backend-1       | 2025-10-13 20:10:35,084 - INFO - backend.main - Initializing Firebase
plaicin-backend-1       | 2025-10-13 20:10:35,113 - INFO - backend.main - Initializing ARQ
plaicin-backend-1       | 2025-10-13 20:10:35,114 - INFO - backend.arq - ARQ Redis pool created successfully
plaicin-backend-1       | 2025-10-13 20:10:35,114 - INFO - backend.main - Syncing world types
plaicin-backend-1       | 2025-10-13 20:10:35,114 - INFO - backend.api.v1.utils.world_types - Syncing world types from filesystem
plaicin-backend-1       | 2025-10-13 20:10:35,125 - INFO - backend.api.v1.utils.world_types - Updating world type: Video Interactive Story 1.0.1
plaicin-db-1            | 2025-10-13 20:10:35.126 UTC [43] ERROR:  column "cinematographer_prompt" of relation "world_types" does not exist at character 2156
plaicin-db-1            | 2025-10-13 20:10:35.126 UTC [43] STATEMENT:  
plaicin-db-1            |                               UPDATE world_types SET
plaicin-db-1            |                                   description = $1,
plaicin-db-1            |                                   ui = $2,
plaicin-db-1            |                                   is_active = $3,
plaicin-db-1            |                                   settings = $4,
plaicin-db-1            |                                   world_input_json_schema = $5,
plaicin-db-1            |                                   world_prompt = $6,
plaicin-db-1            |                                   world_properties_json_schema = $7,
plaicin-db-1            |                                   characters_prompt = $8,
plaicin-db-1            |                                   character_properties_json_schema = $9,
plaicin-db-1            |                                   locations_prompt = $10,
plaicin-db-1            |                                   location_properties_json_schema = $11,
plaicin-db-1            |                                   items_prompt = $12,
plaicin-db-1            |                                   item_properties_json_schema = $13,
plaicin-db-1            |                                   plan_prompt = $14,
plaicin-db-1            |                                   intro_plan_prompt = $15,
plaicin-db-1            |                                   plan_tools = $16,
plaicin-db-1            |                                   entity_prompt = $17,
plaicin-db-1            |                                   entity_tools = $18,
plaicin-db-1            |                                   message_prompt = $19,
plaicin-db-1            |                                   message_content_json_schema = $20,
plaicin-db-1            |                                   message_tools = $21,
plaicin-db-1            |                                   cutscenes_prompt = $22,
plaicin-db-1            |                                   cutscene_properties_json_schema = $23,
plaicin-db-1            |                                   memory_prompt = $24,
plaicin-db-1            |                                   memory_json_schema = $25,
plaicin-db-1            |                                   intro_message_prompt = $26,
plaicin-db-1            |                                   state_initialize_prompt = $27,
plaicin-db-1            |                                   state_initialize_tools = $28,
plaicin-db-1            |                                   edit_prompt = $29,
plaicin-db-1            |                                   edit_tools = $30,
plaicin-db-1            |                                   late_join_summary_prompt = $31,
plaicin-db-1            |                                   fast_message_prompt = $32,
plaicin-db-1            |                                   world_input_enhance_prompt = $33,
plaicin-db-1            |                                   character_variant_prompt = $34,
plaicin-db-1            |                                   location_variant_prompt = $35,
plaicin-db-1            |                                   item_variant_prompt = $36,
plaicin-db-1            |                                   ideation_prompt = $37,
plaicin-db-1            |                                   ideation_tools = $38,
plaicin-db-1            |                                   world_tools = $39,
plaicin-db-1            |                                   cinematographer_prompt = $40,
plaicin-db-1            |                                   cinematographer_tools = $41
plaicin-db-1            |                               WHERE name = $42 AND version = $43
plaicin-db-1            |                               
plaicin-backend-1       | 2025-10-13 20:10:35,127 - ERROR - backend.db - Error in execute_query: 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/db.py", line 138, in execute_query
plaicin-backend-1       |     await cur.execute(query, params if params else None)
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/psycopg/cursor_async.py", line 97, in execute
plaicin-backend-1       |     raise ex.with_traceback(None)
plaicin-backend-1       | psycopg.errors.UndefinedColumn: column "cinematographer_prompt" of relation "world_types" does not exist
plaicin-backend-1       | LINE 42:                             cinematographer_prompt = $40,
plaicin-backend-1       |                                      ^
plaicin-backend-1       | 2025-10-13 20:10:35,130 - ERROR - backend.api.v1.utils.world_types - Error syncing world type Video Interactive Story/1.0.1: 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/db.py", line 138, in execute_query
plaicin-backend-1       |     await cur.execute(query, params if params else None)
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/psycopg/cursor_async.py", line 97, in execute
plaicin-backend-1       |     raise ex.with_traceback(None)
plaicin-backend-1       | psycopg.errors.UndefinedColumn: column "cinematographer_prompt" of relation "world_types" does not exist
plaicin-backend-1       | LINE 42:                             cinematographer_prompt = $40,
plaicin-backend-1       |                                      ^
plaicin-backend-1       | 
plaicin-backend-1       | During handling of the above exception, another exception occurred:
plaicin-backend-1       | 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/api/v1/utils/world_types.py", line 408, in sync_world_types
plaicin-backend-1       |     await db.execute_query(
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 189, in async_wrapped
plaicin-backend-1       |     return await copy(fn, *args, **kwargs)
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 111, in __call__
plaicin-backend-1       |     do = await self.iter(retry_state=retry_state)
plaicin-backend-1       |          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 153, in iter
plaicin-backend-1       |     result = await action(retry_state)
plaicin-backend-1       |              ^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/_utils.py", line 99, in inner
plaicin-backend-1       |     return call(*args, **kwargs)
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/__init__.py", line 398, in <lambda>
plaicin-backend-1       |     self._add_action_func(lambda rs: rs.outcome.result())
plaicin-backend-1       |                                      ^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/concurrent/futures/_base.py", line 449, in result
plaicin-backend-1       |     return self.__get_result()
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/concurrent/futures/_base.py", line 401, in __get_result
plaicin-backend-1       |     raise self._exception
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 114, in __call__
plaicin-backend-1       |     result = await fn(*args, **kwargs)
plaicin-backend-1       |              ^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/app/backend/db.py", line 150, in execute_query
plaicin-backend-1       |     raise HTTPException(status_code=500, detail="Database error")
plaicin-backend-1       | fastapi.exceptions.HTTPException: 500: Database error
plaicin-backend-1       | 2025-10-13 20:10:35,150 - INFO - backend.api.v1.utils.world_types - Updating world type: Visual Interactive Story 1.0.1
plaicin-db-1            | 2025-10-13 20:10:35.151 UTC [45] ERROR:  column "cinematographer_prompt" of relation "world_types" does not exist at character 2156
plaicin-db-1            | 2025-10-13 20:10:35.151 UTC [45] STATEMENT:  
plaicin-db-1            |                               UPDATE world_types SET
plaicin-db-1            |                                   description = $1,
plaicin-db-1            |                                   ui = $2,
plaicin-db-1            |                                   is_active = $3,
plaicin-db-1            |                                   settings = $4,
plaicin-db-1            |                                   world_input_json_schema = $5,
plaicin-db-1            |                                   world_prompt = $6,
plaicin-db-1            |                                   world_properties_json_schema = $7,
plaicin-db-1            |                                   characters_prompt = $8,
plaicin-db-1            |                                   character_properties_json_schema = $9,
plaicin-db-1            |                                   locations_prompt = $10,
plaicin-db-1            |                                   location_properties_json_schema = $11,
plaicin-db-1            |                                   items_prompt = $12,
plaicin-db-1            |                                   item_properties_json_schema = $13,
plaicin-db-1            |                                   plan_prompt = $14,
plaicin-db-1            |                                   intro_plan_prompt = $15,
plaicin-db-1            |                                   plan_tools = $16,
plaicin-db-1            |                                   entity_prompt = $17,
plaicin-db-1            |                                   entity_tools = $18,
plaicin-db-1            |                                   message_prompt = $19,
plaicin-db-1            |                                   message_content_json_schema = $20,
plaicin-db-1            |                                   message_tools = $21,
plaicin-db-1            |                                   cutscenes_prompt = $22,
plaicin-db-1            |                                   cutscene_properties_json_schema = $23,
plaicin-db-1            |                                   memory_prompt = $24,
plaicin-db-1            |                                   memory_json_schema = $25,
plaicin-db-1            |                                   intro_message_prompt = $26,
plaicin-db-1            |                                   state_initialize_prompt = $27,
plaicin-db-1            |                                   state_initialize_tools = $28,
plaicin-db-1            |                                   edit_prompt = $29,
plaicin-db-1            |                                   edit_tools = $30,
plaicin-db-1            |                                   late_join_summary_prompt = $31,
plaicin-db-1            |                                   fast_message_prompt = $32,
plaicin-db-1            |                                   world_input_enhance_prompt = $33,
plaicin-db-1            |                                   character_variant_prompt = $34,
plaicin-db-1            |                                   location_variant_prompt = $35,
plaicin-db-1            |                                   item_variant_prompt = $36,
plaicin-db-1            |                                   ideation_prompt = $37,
plaicin-db-1            |                                   ideation_tools = $38,
plaicin-db-1            |                                   world_tools = $39,
plaicin-db-1            |                                   cinematographer_prompt = $40,
plaicin-db-1            |                                   cinematographer_tools = $41
plaicin-db-1            |                               WHERE name = $42 AND version = $43
plaicin-db-1            |                               
plaicin-backend-1       | 2025-10-13 20:10:35,152 - ERROR - backend.db - Error in execute_query: 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/db.py", line 138, in execute_query
plaicin-backend-1       |     await cur.execute(query, params if params else None)
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/psycopg/cursor_async.py", line 97, in execute
plaicin-backend-1       |     raise ex.with_traceback(None)
plaicin-backend-1       | psycopg.errors.UndefinedColumn: column "cinematographer_prompt" of relation "world_types" does not exist
plaicin-backend-1       | LINE 42:                             cinematographer_prompt = $40,
plaicin-backend-1       |                                      ^
plaicin-backend-1       | 2025-10-13 20:10:35,155 - ERROR - backend.api.v1.utils.world_types - Error syncing world type Visual Interactive Story/1.0.1: 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/db.py", line 138, in execute_query
plaicin-backend-1       |     await cur.execute(query, params if params else None)
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/psycopg/cursor_async.py", line 97, in execute
plaicin-backend-1       |     raise ex.with_traceback(None)
plaicin-backend-1       | psycopg.errors.UndefinedColumn: column "cinematographer_prompt" of relation "world_types" does not exist
plaicin-backend-1       | LINE 42:                             cinematographer_prompt = $40,
plaicin-backend-1       |                                      ^
plaicin-backend-1       | 
plaicin-backend-1       | During handling of the above exception, another exception occurred:
plaicin-backend-1       | 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/api/v1/utils/world_types.py", line 408, in sync_world_types
plaicin-backend-1       |     await db.execute_query(
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 189, in async_wrapped
plaicin-backend-1       |     return await copy(fn, *args, **kwargs)
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 111, in __call__
plaicin-backend-1       |     do = await self.iter(retry_state=retry_state)
plaicin-backend-1       |          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 153, in iter
plaicin-backend-1       |     result = await action(retry_state)
plaicin-backend-1       |              ^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/_utils.py", line 99, in inner
plaicin-backend-1       |     return call(*args, **kwargs)
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/__init__.py", line 398, in <lambda>
plaicin-backend-1       |     self._add_action_func(lambda rs: rs.outcome.result())
plaicin-backend-1       |                                      ^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/concurrent/futures/_base.py", line 449, in result
plaicin-backend-1       |     return self.__get_result()
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/concurrent/futures/_base.py", line 401, in __get_result
plaicin-backend-1       |     raise self._exception
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 114, in __call__
plaicin-backend-1       |     result = await fn(*args, **kwargs)
plaicin-backend-1       |              ^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/app/backend/db.py", line 150, in execute_query
plaicin-backend-1       |     raise HTTPException(status_code=500, detail="Database error")
plaicin-backend-1       | fastapi.exceptions.HTTPException: 500: Database error
plaicin-backend-1       | 2025-10-13 20:10:35,171 - INFO - backend.api.v1.utils.world_types - Updating world type: Visual Interactive Story 1.1.0
plaicin-db-1            | 2025-10-13 20:10:35.171 UTC [42] ERROR:  column "cinematographer_prompt" of relation "world_types" does not exist at character 2156
plaicin-db-1            | 2025-10-13 20:10:35.171 UTC [42] STATEMENT:  
plaicin-db-1            |                               UPDATE world_types SET
plaicin-db-1            |                                   description = $1,
plaicin-db-1            |                                   ui = $2,
plaicin-db-1            |                                   is_active = $3,
plaicin-db-1            |                                   settings = $4,
plaicin-db-1            |                                   world_input_json_schema = $5,
plaicin-db-1            |                                   world_prompt = $6,
plaicin-db-1            |                                   world_properties_json_schema = $7,
plaicin-db-1            |                                   characters_prompt = $8,
plaicin-db-1            |                                   character_properties_json_schema = $9,
plaicin-db-1            |                                   locations_prompt = $10,
plaicin-db-1            |                                   location_properties_json_schema = $11,
plaicin-db-1            |                                   items_prompt = $12,
plaicin-db-1            |                                   item_properties_json_schema = $13,
plaicin-db-1            |                                   plan_prompt = $14,
plaicin-db-1            |                                   intro_plan_prompt = $15,
plaicin-db-1            |                                   plan_tools = $16,
plaicin-db-1            |                                   entity_prompt = $17,
plaicin-db-1            |                                   entity_tools = $18,
plaicin-db-1            |                                   message_prompt = $19,
plaicin-db-1            |                                   message_content_json_schema = $20,
plaicin-db-1            |                                   message_tools = $21,
plaicin-db-1            |                                   cutscenes_prompt = $22,
plaicin-db-1            |                                   cutscene_properties_json_schema = $23,
plaicin-db-1            |                                   memory_prompt = $24,
plaicin-db-1            |                                   memory_json_schema = $25,
plaicin-db-1            |                                   intro_message_prompt = $26,
plaicin-db-1            |                                   state_initialize_prompt = $27,
plaicin-db-1            |                                   state_initialize_tools = $28,
plaicin-db-1            |                                   edit_prompt = $29,
plaicin-db-1            |                                   edit_tools = $30,
plaicin-db-1            |                                   late_join_summary_prompt = $31,
plaicin-db-1            |                                   fast_message_prompt = $32,
plaicin-db-1            |                                   world_input_enhance_prompt = $33,
plaicin-db-1            |                                   character_variant_prompt = $34,
plaicin-db-1            |                                   location_variant_prompt = $35,
plaicin-db-1            |                                   item_variant_prompt = $36,
plaicin-db-1            |                                   ideation_prompt = $37,
plaicin-db-1            |                                   ideation_tools = $38,
plaicin-db-1            |                                   world_tools = $39,
plaicin-db-1            |                                   cinematographer_prompt = $40,
plaicin-db-1            |                                   cinematographer_tools = $41
plaicin-db-1            |                               WHERE name = $42 AND version = $43
plaicin-db-1            |                               
plaicin-backend-1       | 2025-10-13 20:10:35,172 - ERROR - backend.db - Error in execute_query: 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/db.py", line 138, in execute_query
plaicin-backend-1       |     await cur.execute(query, params if params else None)
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/psycopg/cursor_async.py", line 97, in execute
plaicin-backend-1       |     raise ex.with_traceback(None)
plaicin-backend-1       | psycopg.errors.UndefinedColumn: column "cinematographer_prompt" of relation "world_types" does not exist
plaicin-backend-1       | LINE 42:                             cinematographer_prompt = $40,
plaicin-backend-1       |                                      ^
plaicin-backend-1       | 2025-10-13 20:10:35,175 - ERROR - backend.api.v1.utils.world_types - Error syncing world type Visual Interactive Story/1.1.0: 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/db.py", line 138, in execute_query
plaicin-backend-1       |     await cur.execute(query, params if params else None)
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/psycopg/cursor_async.py", line 97, in execute
plaicin-backend-1       |     raise ex.with_traceback(None)
plaicin-backend-1       | psycopg.errors.UndefinedColumn: column "cinematographer_prompt" of relation "world_types" does not exist
plaicin-backend-1       | LINE 42:                             cinematographer_prompt = $40,
plaicin-backend-1       |                                      ^
plaicin-backend-1       | 
plaicin-backend-1       | During handling of the above exception, another exception occurred:
plaicin-backend-1       | 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/api/v1/utils/world_types.py", line 408, in sync_world_types
plaicin-backend-1       |     await db.execute_query(
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 189, in async_wrapped
plaicin-backend-1       |     return await copy(fn, *args, **kwargs)
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 111, in __call__
plaicin-backend-1       |     do = await self.iter(retry_state=retry_state)
plaicin-backend-1       |          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 153, in iter
plaicin-backend-1       |     result = await action(retry_state)
plaicin-backend-1       |              ^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/_utils.py", line 99, in inner
plaicin-backend-1       |     return call(*args, **kwargs)
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/__init__.py", line 398, in <lambda>
plaicin-backend-1       |     self._add_action_func(lambda rs: rs.outcome.result())
plaicin-backend-1       |                                      ^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/concurrent/futures/_base.py", line 449, in result
plaicin-backend-1       |     return self.__get_result()
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/concurrent/futures/_base.py", line 401, in __get_result
plaicin-backend-1       |     raise self._exception
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 114, in __call__
plaicin-backend-1       |     result = await fn(*args, **kwargs)
plaicin-backend-1       |              ^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/app/backend/db.py", line 150, in execute_query
plaicin-backend-1       |     raise HTTPException(status_code=500, detail="Database error")
plaicin-backend-1       | fastapi.exceptions.HTTPException: 500: Database error
plaicin-backend-1       | 2025-10-13 20:10:35,189 - INFO - backend.api.v1.utils.world_types - Updating world type: Text Interactive Story 1.0.1
plaicin-db-1            | 2025-10-13 20:10:35.189 UTC [44] ERROR:  column "cinematographer_prompt" of relation "world_types" does not exist at character 2156
plaicin-db-1            | 2025-10-13 20:10:35.189 UTC [44] STATEMENT:  
plaicin-db-1            |                               UPDATE world_types SET
plaicin-db-1            |                                   description = $1,
plaicin-db-1            |                                   ui = $2,
plaicin-db-1            |                                   is_active = $3,
plaicin-db-1            |                                   settings = $4,
plaicin-db-1            |                                   world_input_json_schema = $5,
plaicin-db-1            |                                   world_prompt = $6,
plaicin-db-1            |                                   world_properties_json_schema = $7,
plaicin-db-1            |                                   characters_prompt = $8,
plaicin-db-1            |                                   character_properties_json_schema = $9,
plaicin-db-1            |                                   locations_prompt = $10,
plaicin-db-1            |                                   location_properties_json_schema = $11,
plaicin-db-1            |                                   items_prompt = $12,
plaicin-db-1            |                                   item_properties_json_schema = $13,
plaicin-db-1            |                                   plan_prompt = $14,
plaicin-db-1            |                                   intro_plan_prompt = $15,
plaicin-db-1            |                                   plan_tools = $16,
plaicin-db-1            |                                   entity_prompt = $17,
plaicin-db-1            |                                   entity_tools = $18,
plaicin-db-1            |                                   message_prompt = $19,
plaicin-db-1            |                                   message_content_json_schema = $20,
plaicin-db-1            |                                   message_tools = $21,
plaicin-db-1            |                                   cutscenes_prompt = $22,
plaicin-db-1            |                                   cutscene_properties_json_schema = $23,
plaicin-db-1            |                                   memory_prompt = $24,
plaicin-db-1            |                                   memory_json_schema = $25,
plaicin-db-1            |                                   intro_message_prompt = $26,
plaicin-db-1            |                                   state_initialize_prompt = $27,
plaicin-db-1            |                                   state_initialize_tools = $28,
plaicin-db-1            |                                   edit_prompt = $29,
plaicin-db-1            |                                   edit_tools = $30,
plaicin-db-1            |                                   late_join_summary_prompt = $31,
plaicin-db-1            |                                   fast_message_prompt = $32,
plaicin-db-1            |                                   world_input_enhance_prompt = $33,
plaicin-db-1            |                                   character_variant_prompt = $34,
plaicin-db-1            |                                   location_variant_prompt = $35,
plaicin-db-1            |                                   item_variant_prompt = $36,
plaicin-db-1            |                                   ideation_prompt = $37,
plaicin-db-1            |                                   ideation_tools = $38,
plaicin-db-1            |                                   world_tools = $39,
plaicin-db-1            |                                   cinematographer_prompt = $40,
plaicin-db-1            |                                   cinematographer_tools = $41
plaicin-db-1            |                               WHERE name = $42 AND version = $43
plaicin-db-1            |                               
plaicin-backend-1       | 2025-10-13 20:10:35,190 - ERROR - backend.db - Error in execute_query: 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/db.py", line 138, in execute_query
plaicin-backend-1       |     await cur.execute(query, params if params else None)
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/psycopg/cursor_async.py", line 97, in execute
plaicin-backend-1       |     raise ex.with_traceback(None)
plaicin-backend-1       | psycopg.errors.UndefinedColumn: column "cinematographer_prompt" of relation "world_types" does not exist
plaicin-backend-1       | LINE 42:                             cinematographer_prompt = $40,
plaicin-backend-1       |                                      ^
plaicin-backend-1       | 2025-10-13 20:10:35,192 - ERROR - backend.api.v1.utils.world_types - Error syncing world type Text Interactive Story/1.0.1: 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/db.py", line 138, in execute_query
plaicin-backend-1       |     await cur.execute(query, params if params else None)
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/psycopg/cursor_async.py", line 97, in execute
plaicin-backend-1       |     raise ex.with_traceback(None)
plaicin-backend-1       | psycopg.errors.UndefinedColumn: column "cinematographer_prompt" of relation "world_types" does not exist
plaicin-backend-1       | LINE 42:                             cinematographer_prompt = $40,
plaicin-backend-1       |                                      ^
plaicin-backend-1       | 
plaicin-backend-1       | During handling of the above exception, another exception occurred:
plaicin-backend-1       | 
plaicin-backend-1       | Traceback (most recent call last):
plaicin-backend-1       |   File "/app/backend/api/v1/utils/world_types.py", line 408, in sync_world_types
plaicin-backend-1       |     await db.execute_query(
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 189, in async_wrapped
plaicin-backend-1       |     return await copy(fn, *args, **kwargs)
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 111, in __call__
plaicin-backend-1       |     do = await self.iter(retry_state=retry_state)
plaicin-backend-1       |          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 153, in iter
plaicin-backend-1       |     result = await action(retry_state)
plaicin-backend-1       |              ^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/_utils.py", line 99, in inner
plaicin-backend-1       |     return call(*args, **kwargs)
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/__init__.py", line 398, in <lambda>
plaicin-backend-1       |     self._add_action_func(lambda rs: rs.outcome.result())
plaicin-backend-1       |                                      ^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/concurrent/futures/_base.py", line 449, in result
plaicin-backend-1       |     return self.__get_result()
plaicin-backend-1       |            ^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/usr/local/lib/python3.12/concurrent/futures/_base.py", line 401, in __get_result
plaicin-backend-1       |     raise self._exception
plaicin-backend-1       |   File "/usr/local/lib/python3.12/site-packages/tenacity/asyncio/__init__.py", line 114, in __call__
plaicin-backend-1       |     result = await fn(*args, **kwargs)
plaicin-backend-1       |              ^^^^^^^^^^^^^^^^^^^^^^^^^
plaicin-backend-1       |   File "/app/backend/db.py", line 150, in execute_query
plaicin-backend-1       |     raise HTTPException(status_code=500, detail="Database error")
plaicin-backend-1       | fastapi.exceptions.HTTPException: 500: Database error
plaicin-backend-1       | 2025-10-13 20:10:35,198 - INFO - backend.main - Syncing static assets with S3
plaicin-backend-1       | 2025-10-13 20:10:37,616 - INFO - backend.main - Initializing shared HTTP client
plaicin-backend-1       | 2025-10-13 20:10:37,627 - INFO - backend.http_client - Created shared HTTP client
plaicin-backend-1       | 2025-10-13 20:10:37,627 - INFO - backend.main - Starting monitoring tasks
plaicin-backend-1       | 2025-10-13 20:10:37,627 - INFO - backend.main - Starting WebSocket monitoring
plaicin-backend-1       | INFO:     Application startup complete.