Migration #2

New Issue

codey · 2025-03-13T20:56:46-04:00

codey commented

2025-03-13 20:56:46 -04:00

All resources currently residing on boats host are to be migrated to radstor (which is to be renamed).

This currently includes (non-exhaustive list)-

Discord bots
API
Website

All resources currently residing on `boats` host are to be migrated to `radstor` (which is to be renamed). This currently includes (non-exhaustive list)- - Discord bots - API - Website

codey self-assigned this 2025-03-13 20:56:51 -04:00

codey added the due date 2025-03-17

2025-03-13 20:56:58 -04:00

codey commented

2025-03-14 10:44:53 -04:00

Completed (?)-- monitoring

Old host still stands at this time to prevent data loss.

Completed (?)-- monitoring Old host still stands at this time to prevent data loss.

codey commented

2025-03-14 11:14:11 -04:00

Migration Issue Log-

[RESOLVED] API: Dynamic loading of SQLite extensions is broken, leading to an exception during lyric cache storage. Python must be re-compiled with --enable-loadable-sqlite-extensions to correct. Compilation in progress.

  File "/home/api/api/lyric_search/sources/cache.py", line 108, in store
    sqlite_insert_id = await self.sqlite_store(lyr_result)
                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/api/api/lyric_search/sources/cache.py", line 183, in sqlite_store
    if await self.check_existence(artistsong):
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/api/api/lyric_search/sources/cache.py", line 85, in check_existence
    await db_conn.enable_load_extension(True)
  File "/home/api/api/.venv/lib/python3.12/site-packages/aiosqlite/core.py", line 287, in enable_load_extension

Migration Issue Log- 1) [**RESOLVED**] API: Dynamic loading of SQLite extensions is broken, leading to an exception during lyric cache storage. Python must be re-compiled with `--enable-loadable-sqlite-extensions` to correct. Compilation in progress. ```Traceback (most recent call last): File "/home/api/api/lyric_search/sources/cache.py", line 108, in store sqlite_insert_id = await self.sqlite_store(lyr_result) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/api/api/lyric_search/sources/cache.py", line 183, in sqlite_store if await self.check_existence(artistsong): ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/api/api/lyric_search/sources/cache.py", line 85, in check_existence await db_conn.enable_load_extension(True) File "/home/api/api/.venv/lib/python3.12/site-packages/aiosqlite/core.py", line 287, in enable_load_extension ```

codey closed this issue

2025-03-15 06:41:04 -04:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

2025-03-17

Dependencies

No dependencies set.

Reference: codey/codey.lol#2