Login

kro · 2024-06-20, 07:53 PM

Hello, I ran into a very similar issue as this one : https://forum.jellyfin.org/t-failed-to-s...dia-server

Same thing - disk full, empty config/migrations.xml file, I deleted it manually and now this error :

Code:
jellyfin  | [19:34:21] [INF] [1] Jellyfin.Server.Migrations.MigrationRunner: Applying migration 'MigrateActivityLogDatabase'

jellyfin  | [19:34:21] [WRN] [1] Jellyfin.Server.Migrations.Routines.MigrateActivityLogDb: Migrating the activity database may take a while, do not stop Jellyfin.

jellyfin  | [19:34:21] [ERR] [1] Jellyfin.Server.Migrations.MigrationRunner: Could not apply migration 'MigrateActivityLogDatabase'

jellyfin  | Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: ActivityLog'.

The only difference is I am running docker.

I feel dumb because I was not automating backups at this moment, my last backup is 3 months old and there has been quite some changes since then...

I also have a 3 months old backup of this file migrations.xml then, should I try to restore it ?

Or maybe try to restore an ActivityLog table with empty fileds ?

Thanks a lot for any help !

TheDreadPirate · 2024-06-20, 07:57 PM

Try simply deleting migrations.xml and restarting jellyfin.

kro · 2024-06-20, 08:17 PM

This is what I have done already, sorry if I was not clear. Then I run into this error message I posted above.

TheDreadPirate · 2024-06-20, 08:35 PM

My bad. Missed that part. In migrations.xml, look for this block and delete it since this is the database migration it is failing on. Then try starting up Jellyfin.

Code:
<ValueTupleOfGuidString>

      <Item1>3793eb59-bc8c-456c-8b9f-bd5a62a42978</Item1>

      <Item2>MigrateActivityLogDatabase</Item2>

    </ValueTupleOfGuidString>

kro · 2024-06-20, 08:42 PM

Thanks for your help !

This is the content of the actual migration.xml after recreation. There is nothing related to ActivityLog :

Code:
<?xml version="1.0" encoding="utf-8"?>

<MigrationOptions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <Applied>

    <ValueTupleOfGuidString>

      <Item1>9b354818-94d5-4b68-ac49-e35cb85f9d84</Item1>

      <Item2>CreateNetworkConfiguration</Item2>

    </ValueTupleOfGuidString>

    <ValueTupleOfGuidString>

      <Item1>a6dcacf4-c057-4ef9-80d3-61cef9ddb4f0</Item1>

      <Item2>MigrateMusicBrainzTimeout</Item2>

    </ValueTupleOfGuidString>

    <ValueTupleOfGuidString>

      <Item1>4fb5c950-1991-11ee-9b4b-0800200c9a66</Item1>

      <Item2>MigrateNetworkConfiguration</Item2>

    </ValueTupleOfGuidString>

    <ValueTupleOfGuidString>

      <Item1>4124c2cd-e939-4ffb-9be9-9b311c413638</Item1>

      <Item2>DisableTranscodingThrottling</Item2>

    </ValueTupleOfGuidString>

    <ValueTupleOfGuidString>

      <Item1>ef103419-8451-40d8-9f34-d1a8e93a1679</Item1>

      <Item2>CreateLoggingConfigHeirarchy</Item2>

    </ValueTupleOfGuidString>

  </Applied>

</MigrationOptions>

kro · (This post was last modified: 2024-06-20, 08:54 PM by kro.)

I've just checked the data directory and users.db and activitylog.db are both empty / 0 bytes Confused-face

I guess trying to wildly restore this files from a 3 months old backup would not be the greatest idea ?
I don't think the jellyfin docker image is dumping or backing up the db automatically or anything ?

maybe I could dump this tables from the backup and import them to the current database ?

kro · 2024-06-20, 08:58 PM

It looks a bit complicated though...
this would be the Dockerfile :
https://hub.docker.com/layers/jellyfin/j...xt=explore
(I use jellyfin/jellyfin without tags)

I could use a database engine, is it mariaDB or MySQL or Postgre ? How could I get the appropriate version ?

kro · (This post was last modified: 2024-06-20, 09:06 PM by kro.)

The weird thing is my backup doesn't contain these files and the files it contains seem to be pretty old :

Code:
kro@monopoutre /media/kro/advance/backups/micropoutre/srv/jellyfin/data/data  ll

total 706M

-rw-r--r--  1 kro kro 8,7M  6 déc.  2020 activitylog.db.old

-rw-r--r--  1 kro kro    0  6 déc.  2020 activitylog.db.old-journal

drwxr-xr-x  4 kro kro 4,0K 18 juin  2021 attachments/

-rw-r--r--  1 kro kro 232K 28 juin  2022 authentication.db.old

-rw-r--r--  1 kro kro    0 28 juin  2022 authentication.db.old-journal

drwxr-xr-x  2 kro kro 4,0K 29 janv.  2016 camerauploads/

drwxr-xr-x  92 kro kro 4,0K  6 mai  02:56 collections/

-rw-r--r--  1 kro kro  243  6 janv.  2019 connect.txt

drwxr-xr-x 313 kro kro  20K 12 mars  2021 devices/

-rw-r--r--  1 kro kro 588K  6 déc.  2018 devices.db

-rw-r--r--  1 kro kro  35 29 janv.  2016 device.txt

-rw-r--r--  1 kro kro  44K  9 mars  2021 displaypreferences.db.old

-rw-r--r--  1 kro kro    0  9 mars  2021 displaypreferences.db.old-journal

-rw-r--r--  1 kro kro  16K  1 févr.  2016 fileorganization.db

-rw-r--r--  1 kro kro  32K  8 août  2017 fileorganization.db-shm

-rw-r--r--  1 kro kro    0  8 août  2017 fileorganization.db-wal

-rw-r--r--  1 kro kro 463K 19 oct.  2017 imagesizes.json

-rw-r--r--  1 kro kro  30M 20 mai  05:09 jellyfin.db

drwxr-xr-x  18 kro kro 4,0K 30 juil.  2022 keyframes/

-rw-r--r--  1 kro kro  10M 24 août  2022 kodisyncqueue-backup.db

-rw-r--r--  1 kro kro  12M 19 mai  21:44 kodisyncqueue.db

-rw-r--r--  1 kro kro    0 19 mai  21:44 kodisyncqueue-log.db

-rw-r--r--  1 kro kro 362M 20 mai  00:36 library.db

-rw-r--r--  1 kro kro 270M  6 déc.  2020 library.db.bak1

-rw-r--r--  1 kro kro    0 20 mai  00:36 library.db-journal

-rw-r--r--  1 kro kro 356K  7 mai    2018 notifications.db

-rw-r--r--  1 kro kro  32K 19 nov.  2018 notifications.db-shm

-rw-r--r--  1 kro kro 2,4M 19 nov.  2018 notifications.db-wal

drwxr-xr-x  15 kro kro 4,0K 16 févr. 19:01 playlists/

-rw-r--r--  1 kro kro 4,1M 22 août  2016 refreshinfo.db

drwxr-xr-x  2 kro kro 4,0K  9 août  2022 ScheduledTasks/

-rw-r--r--  1 kro kro  16K  8 nov.  2016 shares.db

-rw-r--r--  1 kro kro  32K 30 déc.  2017 shares.db-shm

-rw-r--r--  1 kro kro    0 10 sept.  2017 shares.db-wal

drwxr-xr-x  18 kro kro 4,0K 19 déc.  2016 subtitles/

-rw-r--r--  1 kro kro  40K 17 déc.  2016 sync14.db

-rw-r--r--  1 kro kro  32K  9 janv.  2019 sync14.db-shm

-rw-r--r--  1 kro kro  21K 19 nov.  2018 sync14.db-wal

drwxr-xr-x  2 kro kro 4,0K 11 févr.  2017 SyncData/

-rw-r--r--  1 kro kro 2,5M 20 déc.  2016 userdata_v2.db

-rw-r--r--  1 kro kro  32K 20 déc.  2016 userdata_v2.db-shm

-rw-r--r--  1 kro kro 4,0M 20 déc.  2016 userdata_v2.db-wal

-rw-r--r--  1 kro kro  48K  6 déc.  2020 users.db.old

-rw-r--r--  1 kro kro    0  6 déc.  2020 users.db.old-journal

-rw-rw-r--  1 kro kro  23  1 févr.  2017 wan.dat

-rw-r--r--  1 kro kro  17  1 févr.  2017 wan.txt

I don't get the reason for this, since the other files are 3 years old...
This does really look bad however !

Maybe I should just remove the users.db and activitylog.db files since they are not existing in my backup and they are empty anyway...
I don't get it !

TheDreadPirate · 2024-06-20, 09:08 PM

If you look in the jellyfin log it is likely complaining about another migration failing. Probably different from before. Rinse and repeat until we work through what remains in migrations.xml?

kro · (This post was last modified: 2024-06-20, 09:11 PM by kro.)

update : no still the same error
no such table: ActivityLog

(2024-06-20, 09:08 PM)TheDreadPirate Wrote: Rinse and repeat until we work through what remains in migrations.xml?

do you mean I should remove migrations.xml and re-run jellyfin many times ?
or just remove some parts ? (which ones)

Login

Username/Email:
Password:


Or login with a social network below

Login

Username/Email:
Password:


Or login with a social network below

SOLVED: can't start jellyfin after disk full