toddsundsted / ktistec

Single user ActivityPub (https://www.w3.org/TR/activitypub/) server.
GNU Affero General Public License v3.0
360 stars 20 forks source link

Latest Docker build fails after sqlite database migration "create_last_times" #94

Closed oztourer closed 6 months ago

oztourer commented 6 months ago

On rebuilding my Docker image of ktistec from the latest -dist branch I get an error loop from which it fails to recover:

 SQLite3 version 3.40.1
 Unhandled exception: Missing JSON attribute: last_timeline_checked_at
   parsing Temp_20231204140457::State at line 1, column 1
   deserializing Temp_20231204140457#state (DB::MappingException)
   from ???
   from ???
   from ???
   from ???
   from src/env/__libc_start_main.c:95:2 in 'libc_start_main_stage2'
 Caused by: Missing JSON attribute: last_timeline_checked_at
   parsing Temp_20231204140457::State at line 1, column 1 (JSON::SerializableError)
   from ???
   from ???
   from ???
   from ???
   from src/env/__libc_start_main.c:95:2 in 'libc_start_main_stage2'

I browsed the sqlite database and found that migration record 'create_last_times' had been created and that table 'last_times' exists but is empty. The error above repeats indefinitely and always for the same date and time stamp. My only solution for now is to revert to a version of ktistec which does not require this table.

Without doing a deep dive into the source of ktistec I cannot see a way to resolve this so suggestions would be welcome.

toddsundsted commented 6 months ago

this is a duplicate of https://github.com/toddsundsted/ktistec/issues/92

i'd like to move the discussion over there. i will tag you in a comment on that thread.