-
- Notifications
You must be signed in to change notification settings - Fork 74
Closed
Labels
Description
environment
asp core 9
entityframeworkcore.firebird 12.0.0-beta1
project aspnet core blazor with identity default
when im try execute database update, it get error "Invalid time zone region: .21.5440". you can see detail error below
info: Microsoft.EntityFrameworkCore.Database.Command[20101] Executed DbCommand (33ms) [Parameters=[], CommandType='Text', CommandTimeout='0'] EXECUTE BLOCK AS BEGIN BEGIN EXECUTE STATEMENT 'CREATE TABLE "__EFMigrationsLock" ( "Id" INT NOT NULL CONSTRAINT "PK___EFMigrationsLock" PRIMARY KEY, "Timestamp" TIMESTAMP NOT NULL )'; WHEN SQLSTATE '42S01' DO BEGIN END END END fail: Microsoft.EntityFrameworkCore.Database.Command[20102] Failed executing DbCommand (21ms) [Parameters=[], CommandType='Text', CommandTimeout='0'] EXECUTE BLOCK RETURNS (ROWS_AFFECTED INT) AS BEGIN ROWS_AFFECTED = 1; BEGIN INSERT INTO "__EFMigrationsLock" ("Id", "Timestamp") VALUES (1, CAST('2024-12-21 11.42.21.5440' AS TIMESTAMP)); WHEN SQLSTATE '23000' DO BEGIN ROWS_AFFECTED = 0; END END SUSPEND; END Failed executing DbCommand (21ms) [Parameters=[], CommandType='Text', CommandTimeout='0'] EXECUTE BLOCK RETURNS (ROWS_AFFECTED INT) AS BEGIN ROWS_AFFECTED = 1; BEGIN INSERT INTO "__EFMigrationsLock" ("Id", "Timestamp") VALUES (1, CAST('2024-12-21 11.42.21.5440' AS TIMESTAMP)); WHEN SQLSTATE '23000' DO BEGIN ROWS_AFFECTED = 0; END END SUSPEND; END FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Invalid time zone region: .21.5440 At block line: 7, col: 3 ---> FirebirdSql.Data.Common.IscException: Invalid time zone region: .21.5440 At block line: 7, col: 3 at FirebirdSql.Data.Client.Managed.IResponseExtensions.HandleResponseException(IResponse response) at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse(Int32 operation) at FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch() at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar() at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar() at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteScalar(RelationalCommandParameterObject parameterObject) at FirebirdSql.EntityFrameworkCore.Firebird.Migrations.Internal.FbHistoryRepository.AcquireDatabaseLock() at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
change project to net core 8 fix this error.