Skip to content

Npgsql.PostgresException (0x80004005): 42P01: relation "event_type" does not exist #92

@leighghunt

Description

@leighghunt
fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
2025-07-09T22:53:42.1287540Z       Failed executing DbCommand (320ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
2025-07-09T22:53:42.1287604Z       SELECT EXISTS (
2025-07-09T22:53:42.1287643Z           SELECT 1
2025-07-09T22:53:42.1287678Z           FROM event_type AS e)
2025-07-09T22:53:42.1601152Z fail: Microsoft.EntityFrameworkCore.Query[10100]
2025-07-09T22:53:42.1601988Z       An exception occurred while iterating over the results of a query for context type 'timelapse.infrastructure.AppDbContext'.
2025-07-09T22:53:42.1602075Z       Npgsql.PostgresException (0x80004005): 42P01: relation "event_type" does not exist
2025-07-09T22:53:42.1602111Z
2025-07-09T22:53:42.1602144Z       POSITION: 39
2025-07-09T22:53:42.1602182Z          at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
2025-07-09T22:53:42.1602219Z          at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
2025-07-09T22:53:42.1602269Z          at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
2025-07-09T22:53:42.1602303Z          at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
2025-07-09T22:53:42.1602332Z          at Npgsql.NpgsqlDataReader.NextResult()
2025-07-09T22:53:42.1602367Z          at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
2025-07-09T22:53:42.1602402Z          at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
2025-07-09T22:53:42.1602443Z          at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
2025-07-09T22:53:42.1602476Z          at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
2025-07-09T22:53:42.1602508Z          at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
2025-07-09T22:53:42.1602541Z          at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)
2025-07-09T22:53:42.1602586Z          at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.<>c.<MoveNext>b__21_0(DbContext _, Enumerator enumerator)
2025-07-09T22:53:42.1602636Z          at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
2025-07-09T22:53:42.1602671Z          at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
2025-07-09T22:53:42.1602702Z         Exception data:
2025-07-09T22:53:42.1602731Z           Severity: ERROR
2025-07-09T22:53:42.1602770Z           SqlState: 42P01
2025-07-09T22:53:42.1602801Z           MessageText: relation "event_type" does not exist
2025-07-09T22:53:42.1602831Z           Position: 39
2025-07-09T22:53:42.1602861Z           File: parse_relation.c
2025-07-09T22:53:42.1602892Z           Line: 1449
2025-07-09T22:53:42.1602921Z           Routine: parserOpenTable
2025-07-09T22:53:42.1602957Z       Npgsql.PostgresException (0x80004005): 42P01: relation "event_type" does not exist
2025-07-09T22:53:42.1603002Z
2025-07-09T22:53:42.1603032Z       POSITION: 39
2025-07-09T22:53:42.1603069Z          at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
2025-07-09T22:53:42.1603108Z          at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
2025-07-09T22:53:42.1603167Z          at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
2025-07-09T22:53:42.1603208Z          at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
2025-07-09T22:53:42.1603242Z          at Npgsql.NpgsqlDataReader.NextResult()
2025-07-09T22:53:42.1603281Z          at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
2025-07-09T22:53:42.1603317Z          at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
2025-07-09T22:53:42.1603363Z          at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
2025-07-09T22:53:42.1603399Z          at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
2025-07-09T22:53:42.1603435Z          at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
2025-07-09T22:53:42.1603470Z          at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)
2025-07-09T22:53:42.1603520Z          at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.<>c.<MoveNext>b__21_0(DbContext _, Enumerator enumerator)
2025-07-09T22:53:42.1603556Z          at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
2025-07-09T22:53:42.1603751Z          at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
2025-07-09T22:53:42.1603796Z         Exception data:
2025-07-09T22:53:42.1603829Z           Severity: ERROR
2025-07-09T22:53:42.1603871Z           SqlState: 42P01
2025-07-09T22:53:42.1603909Z           MessageText: relation "event_type" does not exist
2025-07-09T22:53:42.1603941Z           Position: 39
2025-07-09T22:53:42.1603970Z           File: parse_relation.c
2025-07-09T22:53:42.1604001Z           Line: 1449
2025-07-09T22:53:42.1604032Z           Routine: parserOpenTable
2025-07-09T22:53:42.1957538Z fail: Program[0]
2025-07-09T22:53:42.1957855Z       An error occurred while seeding the database.
2025-07-09T22:53:42.1957915Z       Npgsql.PostgresException (0x80004005): 42P01: relation "event_type" does not exist
2025-07-09T22:53:42.1957951Z
2025-07-09T22:53:42.1957987Z       POSITION: 39
2025-07-09T22:53:42.1958030Z          at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
2025-07-09T22:53:42.1958095Z          at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
2025-07-09T22:53:42.1958136Z          at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
2025-07-09T22:53:42.1958174Z          at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
2025-07-09T22:53:42.1958501Z          at Npgsql.NpgsqlDataReader.NextResult()
2025-07-09T22:53:42.1958562Z          at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
2025-07-09T22:53:42.1958617Z          at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
2025-07-09T22:53:42.1958652Z          at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
2025-07-09T22:53:42.1958687Z          at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
2025-07-09T22:53:42.1958727Z          at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
2025-07-09T22:53:42.1958765Z          at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)
2025-07-09T22:53:42.1958819Z          at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.<>c.<MoveNext>b__21_0(DbContext _, Enumerator enumerator)
2025-07-09T22:53:42.1958860Z          at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
2025-07-09T22:53:42.1958898Z          at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
2025-07-09T22:53:42.1958936Z          at System.Linq.Enumerable.TryGetSingle[TSource](IEnumerable`1 source, Boolean& found)
2025-07-09T22:53:42.1958971Z          at lambda_method43(Closure, QueryContext)
2025-07-09T22:53:42.1959020Z          at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query)
2025-07-09T22:53:42.1959073Z          at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression)
2025-07-09T22:53:42.1959118Z          at timelapse.api.Data.DbInitializer.Initialize(AppDbContext context) in /tmp/8ddbee01920402a/timelapse.api/Data/DbInitializer.cs:line 37
2025-07-09T22:53:42.1959156Z          at Program.<Main>$(String[] args) in /tmp/8ddbee01920402a/timelapse.api/Program.cs:line 101
2025-07-09T22:53:42.1959204Z         Exception data:
2025-07-09T22:53:42.1959236Z           Severity: ERROR
2025-07-09T22:53:42.1959268Z           SqlState: 42P01
2025-07-09T22:53:42.1959301Z           MessageText: relation "event_type" does not exist
2025-07-09T22:53:42.1959332Z           Position: 39
2025-07-09T22:53:42.1959363Z           File: parse_relation.c
2025-07-09T22:53:42.1959404Z           Line: 1449
2025-07-09T22:53:42.1959442Z           Routine: parserOpenTable
2025-07-09T22:53:42.3034996Z info: Microsoft.Hosting.Lifetime[14]
2025-07-09T22:53:42.3035381Z       Now listening on: http://[::]:8080
2025-07-09T22:53:42.3040631Z info: Microsoft.Hosting.Lifetime[0]
2025-07-09T22:53:42.3040749Z       Application started. Press Ctrl+C to shut down.
2025-07-09T22:53:42.3042504Z info: Microsoft.Hosting.Lifetime[0]
2025-07-09T22:53:42.3042612Z       Hosting environment: Production
2025-07-09T22:53:42.3043231Z info: Microsoft.Hosting.Lifetime[0]
2025-07-09T22:53:42.3043320Z       Content root path: /home/site/wwwroot
2025-07-09T22:53:42.9429332Z warn: Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3]
2025-07-09T22:53:42.9430357Z       Failed to determine the https port for redirect.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions