Open Closed

ABP.io upgrade from 7 to 8 getting error as relation "AbpSessions" does not exist #7893


User avatar
0
ramkumar.subramanian created

Hi Support,

We are migrating from abp.io 7.2 to version 8.2,

During our docker deployment, we are getting below error message.

Are we missing the table- "AbpSessions" ? (provide me the table structure)

Please help me to fix below issue

Exception - Npgsql.PostgresException (0x80004005): 42P01: relation "AbpSessions" does not exist

POSITION: 13 at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder1.StateMachineBox1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Volo.Abp.Domain.Repositories.EntityFrameworkCore.EfCoreRepository2.DeleteDirectAsync(Expression1 predicate, CancellationToken cancellationToken) at Volo.Abp.Identity.EntityFrameworkCore.EfCoreIdentitySessionRepository.DeleteAllAsync(TimeSpan inactiveTimeSpan, CancellationToken cancellationToken) at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func3 proceed) at Volo.Abp.Identity.IdentitySessionManager.DeleteAllAsync(TimeSpan inactiveTimeSpan) at Volo.Abp.Identity.Session.IdentitySessionCleanupService.CleanAsync() Exception data: Severity: ERROR SqlState: 42P01 MessageText: relation "AbpSessions" does not exist Position: 13 File: parse_relation.c Line: 1409 Routine: parserOpenTable


3 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi

    Please update your EF Core migrations and update the database.

  • User Avatar
    0
    ramkumar.subramanian created

    We are not following the migration approch. Can you please provide me table schema with columns.

  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi

    I don't have the schema. We just use EF Core migration.

Made with ❤️ on ABP v9.1.0-preview. Updated on December 13, 2024, 06:09