App not starting

[qsig-a]

Description: The app is not starting due to an unhandled exception

Expected behavior: App runs

OS: linux x86_64 QTS 5.2.2 (20241116)

Docker version: 27.1.2-qnap4 (API: 1.46)

Total CPU: 12

Total RAM: 32GB

Application version: Latest

Logs:

[18:45:40 INF] Trying to apply migrations...
Unhandled exception. System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'startIndex')
   at System.String.LastIndexOf(Char value, Int32 startIndex, Int32 count)
   at Microsoft.Data.Common.ADP.IsEndpoint(String dataSource, String prefix)
   at Microsoft.Data.Common.ADP.IsAzureSynapseOnDemandEndpoint(String dataSource)
   at Microsoft.Data.SqlClient.SqlConnection.CacheConnectionStringProperties()
   at Microsoft.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
   at Microsoft.Data.SqlClient.SqlConnection..ctor(String connectionString)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.CreateDbConnection()
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationToken cancellationToken, Boolean errorsExpected)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.<>c__DisplayClass20_0.<<ExistsAsync>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.<>c__DisplayClass20_0.<<ExistsAsync>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.ExistsAsync(CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.GetAppliedMigrationsAsync(CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.GetAppliedMigrationsAsync(DatabaseFacade databaseFacade, CancellationToken cancellationToken)
   at BulkRename.Models.PreparationDatabase.TrySeedData(DbContext context) in /build/BulkRename/Models/PreparationDatabase.cs:line 40
   at BulkRename.Models.PreparationDatabase.PreparatePopulation(IApplicationBuilder applicationBuilder, Int32 connectionTimeOut) in /build/BulkRename/Models/PreparationDatabase.cs:line 31
   at BulkRename.Startup.PreparateDatabase(WebApplication app) in /build/BulkRename/Startup.cs:line 97
   at BulkRename.Startup.Configure(WebApplication app) in /build/BulkRename/Startup.cs:line 65
   at Program.<Main>$(String[] args) in /build/BulkRename/Program.cs:line 69
   at Program.<Main>(String[] args)

ENVS:

ASPNET_VERSION | 8.0.11
ASPNETCORE_HTTP_PORTS | 8080
ASPNETCORE_URLS | http://*:8080
DOTNET_GENERATE_ASPNET_CERTIFICATE | false
DOTNET_NOLOGO | true
DOTNET_RUNNING_IN_CONTAINER | true
DOTNET_SDK_VERSION | 8.0.404
DOTNET_SYSTEM_GLOBALIZATION_INVARIANT | false
DOTNET_USE_POLLING_FILE_WATCHER | true
DOTNET_VERSION | 8.0.11
FoldersToIgnore | .@__thumb
NUGET_XMLDOC_MODE | skip
PATH | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
POWERSHELL_DISTRIBUTION_CHANNEL | PSDocker-DotnetSDK-Alpine-3.20
SupportedFileEndings | mkv;mp4;m4v;avi
TZ | America/Toronto

Volumes are mounted to /app/Logs and /app/Files
Networking is NAT

Let me know if you need anything else, thanks!

[wholfeld]

Got the same issue.

[Ramo-Y]

Hi, have you created the database manually? If not, can you create it and try again? And which version of the software are you using? You only need the database if you want to save the history, otherwise you can set the PersistanceMode to None.

[wholfeld]

I haven't tried to do anything with the database I just ran the docker compose file.

version: '3.7'
services:
  bulkrename:
    image: ramoy/bulkrename:latest
    container_name: "bulkrename"
    environment:
      ASPNETCORE_URLS: http://*:8080
      SupportedFileEndings: "mkv;mp4;m4v;avi"
      FoldersToIgnore: ".@__thumb"
      TZ: "Europe/Zurich"
    ports:
      - "8085:8080"
    volumes:
      - "/mnt/serverwd/TV://app//Files//" # folder in which your TV show files must be located at the time of renaming
      - "/DATA/AppData/bulkrename://app//Logs//" # optional to have logs available outside docker

[16:46:57 INF] Trying to apply migrations...
Unhandled exception. System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'startIndex')
at System.String.LastIndexOf(Char value, Int32 startIndex, Int32 count)
at Microsoft.Data.Common.ADP.IsEndpoint(String dataSource, String prefix)
at Microsoft.Data.Common.ADP.IsAzureSynapseOnDemandEndpoint(String dataSource)
at Microsoft.Data.SqlClient.SqlConnection.CacheConnectionStringProperties()
at Microsoft.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
at Microsoft.Data.SqlClient.SqlConnection..ctor(String connectionString)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.CreateDbConnection()
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationToken cancellationToken, Boolean errorsExpected)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.<>c__DisplayClass20_0.<b__0>d.MoveNext()
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.<>c__DisplayClass20_0.<b__0>d.MoveNext()
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_02.<<ExecuteAsync>b__0>d.MoveNext() --- End of stack trace from previous location --- at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func4 operation, Func4 verifySucceeded, TState state, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func4 operation, Func4 verifySucceeded, TState state, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.ExistsAsync(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.GetAppliedMigrationsAsync(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.GetAppliedMigrationsAsync(DatabaseFacade databaseFacade, CancellationToken cancellationToken)
at BulkRename.Models.PreparationDatabase.TrySeedData(DbContext context) in /build/BulkRename/Models/PreparationDatabase.cs:line 40
at BulkRename.Models.PreparationDatabase.PreparatePopulation(IApplicationBuilder applicationBuilder, Int32 connectionTimeOut) in /build/BulkRename/Models/PreparationDatabase.cs:line 31
at BulkRename.Startup.PreparateDatabase(WebApplication app) in /build/BulkRename/Startup.cs:line 97
at BulkRename.Startup.Configure(WebApplication app) in /build/BulkRename/Startup.cs:line 65
at Program.

$(String[] args) in /build/BulkRename/Program.cs:line 69
at Program.(String[] args)

_bulkrename_logs.txt

[Ramo-Y]

I made a mistake in the default settings, please set the environment variable PersistanceMode to None, then it should work. I will fix the bug as soon as possible. Thanks for reporting, and please let me know if it works.

[qsig-a]

I made a mistake in the default settings, please set the environment variable PersistanceMode to None, then it should work. I will fix the bug as soon as possible. Thanks for reporting, and please let me know if it works.

Yep, enabling that env made it run, thank you!

[Ramo-Y]

Hey Andrew, I'm glad that it works! I hope you can make good use of the application. Thanks again for reporting the bug, unfortunately I had never tested it without the database or the environment variable, so I never noticed it. I'll fix it and update the documentation as soon as I have time. Ramo