Migration fails to complete, relation "frwk_configurationitems" does not exist

[moalamri]

Describe the bug The migration process fails due to missing relation.

To Reproduce Steps to reproduce the behavior:

1. Set database type as PostgreSql, set the connection string.
2. Run the application
3. See error

Desktop (please complete the following information):

• OS: Windows
• Version 22
• PostgreSql 16.1

Additional context The complete migration error.

-------------------------------------------------------------------------------
20230115092299: M20230115092299 migrating
-------------------------------------------------------------------------------
Beginning Transaction
ExecuteSqlStatement delete from
        Frwk_ConfigurationItems
where
        ItemType = 'setting-configuration'
        and not exists (select 1 from Frwk_SettingConfigurations where Id = Frwk_ConfigurationItems.Id)
!!! An error occured executing the following sql:
delete from
        Frwk_ConfigurationItems
where
        ItemType = 'setting-configuration'
        and not exists (select 1 from Frwk_SettingConfigurations where Id = Frwk_ConfigurationItems.Id)
The error was 42P01: relation "frwk_configurationitems" does not exist

POSITION: 16

!!! +- 42P01: relation "frwk_configurationitems" does not exist

POSITION: 16
Rolling back transaction
Application startup exception: System.Exception: An error occured executing the following sql:
delete from
        Frwk_ConfigurationItems
where
        ItemType = 'setting-configuration'
        and not exists (select 1 from Frwk_SettingConfigurations where Id = Frwk_ConfigurationItems.Id)
The error was 42P01: relation "frwk_configurationitems" does not exist

POSITION: 16

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

Before the error occurs, the following migrations are run without errors

-------------------------------------------------------------------------------
VersionMigration migrating
-------------------------------------------------------------------------------
Beginning Transaction
CreateTable VersionInfo
Committing Transaction
VersionMigration migrated
-------------------------------------------------------------------------------
VersionUniqueMigration migrating
-------------------------------------------------------------------------------
Beginning Transaction
CreateIndex VersionInfo (Version)
AlterTable VersionInfo
CreateColumn VersionInfo AppliedOn DateTime
Committing Transaction
VersionUniqueMigration migrated
-------------------------------------------------------------------------------
VersionDescriptionMigration migrating
-------------------------------------------------------------------------------
Beginning Transaction
AlterTable VersionInfo
CreateColumn VersionInfo Description citext
Committing Transaction
VersionDescriptionMigration migrated

The reason could be at the execution order?

[ihouvet]

Hi @moalamri - Thanks for trying Shesha out and providing feedback. We will look into it and @OmolemoBlessingLethuloe will respond on Monday.

[ktsapo]

Hi @moalamri I've confirmed the bug. Now working on a fix