• Login
  • Register
  • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below
  • Forum
  • Website
  • GitHub
  • Status
  • Translation
  • Features
  • Team
  • Rules
  • Help
  • Feeds
User Links
  • Login
  • Register
  • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below

    Useful Links Forum Website GitHub Status Translation Features Team Rules Help Feeds
    Jellyfin Forum Support Troubleshooting Media Scanning & Identification SOLVED: Media scanning failing, and unable to use migration fix

    Pages (2): 1 2 Next »

     
    • 0 Vote(s) - 0 Average

    SOLVED: Media scanning failing, and unable to use migration fix

    Noneuclidery
    Offline

    Junior Member

    Posts: 12
    Threads: 3
    Joined: 2023 Aug
    Reputation: 0
    #1
    2024-09-02, 03:19 AM
    I've seen a lot of people with this error:

    Code:
    [2024-09-02 13:04:29.474 +10:00] [ERR] Error executing Scheduled Task
    System.InvalidOperationException: The data is NULL at ordinal 1. This method can't be called on NULL values. Check using IsDBNull before calling.
      at Microsoft.Data.Sqlite.SqliteDataRecord.GetNull[T](Int32 ordinal)
      at Microsoft.Data.Sqlite.SqliteValueReader.GetBlob(Int32 ordinal)
      at Microsoft.Data.Sqlite.SqliteDataRecord.GetBlob(Int32 ordinal)
      at Microsoft.Data.Sqlite.SqliteDataRecord.GetCachedBlob(Int32 ordinal)
      at Microsoft.Data.Sqlite.SqliteDataRecord.GetStream(Int32 ordinal)
      at Microsoft.Data.Sqlite.SqliteDataReader.GetStream(Int32 ordinal)
      at Emby.Server.Implementations.Data.SqliteItemRepository.GetItem(SqliteDataReader reader, InternalItemsQuery query, Boolean enableProgramAttributes, Boolean hasEpisodeAttributes, Boolean hasServiceName, Boolean queryHasStartDate, Boolean hasTrailerTypes, Boolean hasArtistFields, Boolean hasSeriesFields, Boolean skipDeserialization)
      at Emby.Server.Implementations.Data.SqliteItemRepository.GetItemList(InternalItemsQuery query)
      at MediaBrowser.Controller.Entities.Folder.GetCachedChildren()
      at MediaBrowser.Controller.Entities.Folder.LoadChildren()
      at MediaBrowser.Controller.Entities.Folder.get_Children()
      at MediaBrowser.Controller.Entities.Audio.MusicArtist.get_Children()
      at MediaBrowser.Controller.Entities.Folder.GetActualChildrenDictionary()
      at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal2(IProgress`1 progress, Boolean recursive, Boolean refreshChildMetadata, Boolean allowRemoveRoot, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService, CancellationToken cancellationToken)
      at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, Boolean recursive, Boolean refreshChildMetadata, Boolean allowRemoveRoot, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService, CancellationToken cancellationToken)
      at MediaBrowser.Controller.Entities.Folder.<>c__DisplayClass69_0`1.<<RunTasks>b__1>d.MoveNext()
    --- End of stack trace from previous location ---
      at MediaBrowser.Controller.Entities.Folder.RunTasks[T](Func`3 task, IList`1 children, IProgress`1 progress, CancellationToken cancellationToken)
      at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal2(IProgress`1 progress, Boolean recursive, Boolean refreshChildMetadata, Boolean allowRemoveRoot, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService, CancellationToken cancellationToken)
      at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, Boolean recursive, Boolean refreshChildMetadata, Boolean allowRemoveRoot, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService, CancellationToken cancellationToken)
      at MediaBrowser.Controller.Entities.Folder.<>c__DisplayClass69_0`1.<<RunTasks>b__1>d.MoveNext()
    --- End of stack trace from previous location ---
      at MediaBrowser.Controller.Entities.Folder.RunTasks[T](Func`3 task, IList`1 children, IProgress`1 progress, CancellationToken cancellationToken)
      at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal2(IProgress`1 progress, Boolean recursive, Boolean refreshChildMetadata, Boolean allowRemoveRoot, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService, CancellationToken cancellationToken)
      at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, Boolean recursive, Boolean refreshChildMetadata, Boolean allowRemoveRoot, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService, CancellationToken cancellationToken)
      at MediaBrowser.Controller.Entities.AggregateFolder.ValidateChildrenInternal(IProgress`1 progress, Boolean recursive, Boolean refreshChildMetadata, Boolean allowRemoveRoot, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService, CancellationToken cancellationToken)
      at Emby.Server.Implementations.Library.LibraryManager.PerformLibraryValidation(IProgress`1 progress, CancellationToken cancellationToken)
      at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal(IProgress`1 progress, CancellationToken cancellationToken)
      at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)
    [2024-09-02 13:04:29.475 +10:00] [INF] "Scan Media Library" Failed after 0 minute(s) and 0 seconds

    Or this one:

    Code:
    [2024-09-02 13:04:35.590 +10:00] [ERR] Error processing request. URL "GET" "/Users/f9a836173a0d47d3b404533f7282e33a/Items/Latest".
    System.InvalidOperationException: The data is NULL at ordinal 1. This method can't be called on NULL values. Check using IsDBNull before calling.
      at Microsoft.Data.Sqlite.SqliteDataRecord.GetNull[T](Int32 ordinal)
      at Microsoft.Data.Sqlite.SqliteValueReader.GetBlob(Int32 ordinal)
      at Microsoft.Data.Sqlite.SqliteDataRecord.GetCachedBlob(Int32 ordinal)
      at Microsoft.Data.Sqlite.SqliteDataRecord.GetStream(Int32 ordinal)
      at Emby.Server.Implementations.Data.SqliteItemRepository.GetItem(SqliteDataReader reader, InternalItemsQuery query, Boolean enableProgramAttributes, Boolean hasEpisodeAttributes, Boolean hasServiceName, Boolean queryHasStartDate, Boolean hasTrailerTypes, Boolean hasArtistFields, Boolean hasSeriesFields, Boolean skipDeserialization)
      at Emby.Server.Implementations.Data.SqliteItemRepository.GetItemList(InternalItemsQuery query)
      at Emby.Server.Implementations.Library.LibraryManager.GetItemList(InternalItemsQuery query, List`1 parents)
      at Emby.Server.Implementations.Library.UserViewManager.GetItemsForLatestItems(User user, LatestItemsQuery request, DtoOptions options)
      at Emby.Server.Implementations.Library.UserViewManager.GetLatestItems(LatestItemsQuery request, DtoOptions options)
      at Jellyfin.Api.Controllers.UserLibraryController.GetLatestMedia(Nullable`1 userId, Nullable`1 parentId, ItemFields[] fields, BaseItemKind[] includeItemTypes, Nullable`1 isPlayed, Nullable`1 enableImages, Nullable`1 imageTypeLimit, ImageType[] enableImageTypes, Nullable`1 enableUserData, Int32 limit, Boolean groupItems)
      at lambda_method849(Closure, Object, Object[])
      at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
      at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
      at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
      at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
    --- End of stack trace from previous location ---
      at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
      at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
      at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
    --- End of stack trace from previous location ---
      at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
      at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
      at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
      at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync()
    --- End of stack trace from previous location ---
      at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
      at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
      at Jellyfin.Api.Middleware.ServerStartupMessageMiddleware.Invoke(HttpContext httpContext, IServerApplicationHost serverApplicationHost, ILocalizationManager localizationManager)
      at Jellyfin.Api.Middleware.WebSocketHandlerMiddleware.Invoke(HttpContext httpContext, IWebSocketManager webSocketManager)
      at Jellyfin.Api.Middleware.IPBasedAccessValidationMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager)
      at Jellyfin.Api.Middleware.LanFilteringMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager, IServerConfigurationManager serverConfigurationManager)
      at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
      at Jellyfin.Api.Middleware.QueryStringDecodingMiddleware.Invoke(HttpContext httpContext)
      at Swashbuckle.AspNetCore.ReDoc.ReDocMiddleware.Invoke(HttpContext httpContext)
      at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext)
      at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider)
      at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
      at Jellyfin.Api.Middleware.RobotsRedirectionMiddleware.Invoke(HttpContext httpContext)
      at Jellyfin.Api.Middleware.LegacyEmbyRouteRewriteMiddleware.Invoke(HttpContext httpContext)
      at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.InvokeCore(HttpContext context)
      at Jellyfin.Api.Middleware.ResponseTimeMiddleware.Invoke(HttpContext context, IServerConfigurationManager serverConfigurationManager)
      at Jellyfin.Api.Middleware.ExceptionMiddleware.Invoke(HttpContext context)

    And the fix is always

    Quote:Stop Jellyfin, remove the entry below from your migrations.xml in the config folder and restart Jellyfin. Wait until the migration completes;
    Code:
        <ValueTupleOfGuidString>
          <Item1>cf6fabc2-9fbe-4933-84a5-ffe52ef22a58</Item1>
          <Item2>FixAudioData</Item2>
        </ValueTupleOfGuidString>

    But my migrations file does not have that entry. In fact, the migrations.xml in my user config hasn't been modified since November last year. What does that mean? What should I do now?

    Server version: 10.9.9
    OS: Arch Linux
    Not a docker image. Installed by package manager and run by systemd for the last couple of years, with regular computer restarts.
    Go to solution
    TheDreadPirate
    Offline

    Community Moderator

    Posts: 15,374
    Threads: 10
    Joined: 2023 Jun
    Reputation: 460
    Country:United States
    #2
    2024-09-02, 03:23 AM
    Rename migrations.xml and restart jellyfin.
    Jellyfin 10.10.7 (Docker)
    Ubuntu 24.04.2 LTS w/HWE
    Intel i3 12100
    Intel Arc A380
    OS drive - SK Hynix P41 1TB
    Storage
        4x WD Red Pro 6TB CMR in RAIDZ1
    [Image: GitHub%20Sponsors-grey?logo=github]
    Noneuclidery
    Offline

    Junior Member

    Posts: 12
    Threads: 3
    Joined: 2023 Aug
    Reputation: 0
    #3
    2024-09-02, 03:53 AM
    Hmm, it did not try to recreate it. What would have changed since November to make it stop using that file?

    ... Actually, that's shortly before I became homeless for six months and had to move my computer to someone else's network, but I'm not sure why that would affect it.
    TheDreadPirate
    Offline

    Community Moderator

    Posts: 15,374
    Threads: 10
    Joined: 2023 Jun
    Reputation: 460
    Country:United States
    #4
    2024-09-02, 04:19 AM
    What OS is your server running? If Linux, how are you stopping and starting Jellyfin?
    Jellyfin 10.10.7 (Docker)
    Ubuntu 24.04.2 LTS w/HWE
    Intel i3 12100
    Intel Arc A380
    OS drive - SK Hynix P41 1TB
    Storage
        4x WD Red Pro 6TB CMR in RAIDZ1
    [Image: GitHub%20Sponsors-grey?logo=github]
    Noneuclidery
    Offline

    Junior Member

    Posts: 12
    Threads: 3
    Joined: 2023 Aug
    Reputation: 0
    #5
    2024-09-02, 04:34 AM
    It's running on my desktop, which is ArchLinux, and only connected locally (not accessible from outside the local network). The server is running on systemd at startup, and I'm stopping and starting it with commands like sudo systemctl start jellyfin.service.
    TheDreadPirate
    Offline

    Community Moderator

    Posts: 15,374
    Threads: 10
    Joined: 2023 Jun
    Reputation: 460
    Country:United States
    #6
    2024-09-02, 04:46 AM
    Run this command and copy and paste the output to pastebin.

    Code:
    sudo journalctl -u jellyfin -n 200 --no-pager
    Jellyfin 10.10.7 (Docker)
    Ubuntu 24.04.2 LTS w/HWE
    Intel i3 12100
    Intel Arc A380
    OS drive - SK Hynix P41 1TB
    Storage
        4x WD Red Pro 6TB CMR in RAIDZ1
    [Image: GitHub%20Sponsors-grey?logo=github]
    Noneuclidery
    Offline

    Junior Member

    Posts: 12
    Threads: 3
    Joined: 2023 Aug
    Reputation: 0
    #7
    2024-09-02, 04:56 AM
    https://pastebin.com/ne7TDquu

    (There are a few logs of my housemate watching something, but I have warned zem I might need to restart the server again. XD )
    TheDreadPirate
    Offline

    Community Moderator

    Posts: 15,374
    Threads: 10
    Joined: 2023 Jun
    Reputation: 460
    Country:United States
    #8
    2024-09-02, 02:54 PM
    Unfortunately, your database is likely broken.
    Jellyfin 10.10.7 (Docker)
    Ubuntu 24.04.2 LTS w/HWE
    Intel i3 12100
    Intel Arc A380
    OS drive - SK Hynix P41 1TB
    Storage
        4x WD Red Pro 6TB CMR in RAIDZ1
    [Image: GitHub%20Sponsors-grey?logo=github]
    Noneuclidery
    Offline

    Junior Member

    Posts: 12
    Threads: 3
    Joined: 2023 Aug
    Reputation: 0
    #9
    2024-09-03, 04:05 AM
    Ah. Damn.

    ... So is that a reinstall? Can I keep my posters and such (I chose custom posters for everything) while recreating the database? How can I avoid this in the future?
    TheDreadPirate
    Offline

    Community Moderator

    Posts: 15,374
    Threads: 10
    Joined: 2023 Jun
    Reputation: 460
    Country:United States
    #10
    2024-09-03, 01:48 PM
    You don't have to reinstall, but you will need to clear out /var/lib/jellyfin.

    Code:
    sudo systemctl stop jellyfin
    sudo mv /var/lib/jellyfin /var/lib/origJellyfin
    sudo mkdir /var/lib/jellyfin
    sudo chown jellyfin: /var/lib/jellyfin
    sudo systemctl start jellyfin

    If the posters are saved in your media directory, you can reuse them. If not, you'll have to start over.

    You have a couple options to help preserve any customized metadata.

    1) Enable NFO saver and/or enable saving of images to the media directory in the library settings.
    2) Create a cronjob to backup Jellyfin's data directory.
    Jellyfin 10.10.7 (Docker)
    Ubuntu 24.04.2 LTS w/HWE
    Intel i3 12100
    Intel Arc A380
    OS drive - SK Hynix P41 1TB
    Storage
        4x WD Red Pro 6TB CMR in RAIDZ1
    [Image: GitHub%20Sponsors-grey?logo=github]
    Pages (2): 1 2 Next »

    « Next Oldest | Next Newest »

    Users browsing this thread: 1 Guest(s)


    • View a Printable Version
    • Subscribe to this thread
    Forum Jump:

    Home · Team · Help · Contact
    © Designed by D&D - Powered by MyBB
    L


    Jellyfin

    The Free Software Media System

    Linear Mode
    Threaded Mode