Entity error using mikro-orm with vitest #4733

sawa-ko · 2023-09-23T03:45:39Z

sawa-ko
Sep 23, 2023

Describe the bug
I am trying to do unit testing with vites, nestjs (testing module) and mikro-orm. My problem is that the first test suite runs successfully, but when trying to run the next test suite, I get an error.

The error says that I have already loaded the entities and therefore I can no longer load it in suit 2, but I don't understand why if I already closed the mikro-orm client in suit 1.

So, I don't know if I'm closing the client wrong in the suits, or I don't know what's going on.

Stack trace

MetadataError: Duplicate entity names are not allowed: AuthTokensEntity, AuthUserEntity, AuthPasswordEntity, AuthEmailsEntity
 ❯ Function.duplicateEntityDiscovered node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+migrations@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+seed_q2p7vclko5a5n7ds3hwttx3ria/node_modules/@mikro-orm/core/errors.js:172:16     
 ❯ MetadataValidator.validateDiscovered node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+migrations@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+seed_q2p7vclko5a5n7ds3hwttx3ria/node_modules/@mikro-orm/core/metadata/MetadataValidator.js:53:42
 ❯ MetadataDiscovery.findEntities node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+migrations@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+seed_q2p7vclko5a5n7ds3hwttx3ria/node_modules/@mikro-orm/core/metadata/MetadataDiscovery.js:94:24
 ❯ MetadataDiscovery.discover node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+migrations@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+seed_q2p7vclko5a5n7ds3hwttx3ria/node_modules/@mikro-orm/core/metadata/MetadataDiscovery.js:34:9
 ❯ MikroORM.discoverEntities node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+migrations@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+seed_q2p7vclko5a5n7ds3hwttx3ria/node_modules/@mikro-orm/core/MikroORM.js:119:25
 ❯ Function.init node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+migrations@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+seed_q2p7vclko5a5n7ds3hwttx3ria/node_modules/@mikro-orm/core/MikroORM.js:34:9
 ❯ TestingInjector.instantiateClass node_modules/.pnpm/@nestjs+core@10.2.6_@nestjs+common@10.2.6_@nestjs+platform-express@10.2.6_reflect-metadata@0.1.13_rxjs@7.8.1/node_modules/@nestjs/core/injector/injector.js:369:37
 ❯ callback node_modules/.pnpm/@nestjs+core@10.2.6_@nestjs+common@10.2.6_@nestjs+platform-express@10.2.6_reflect-metadata@0.1.13_rxjs@7.8.1/node_modules/@nestjs/core/injector/injector.js:65:34
 ❯ TestingInjector.resolveConstructorParams node_modules/.pnpm/@nestjs+core@10.2.6_@nestjs+common@10.2.6_@nestjs+platform-express@10.2.6_reflect-metadata@0.1.13_rxjs@7.8.1/node_modules/@nestjs/core/injector/injector.js:144:24   
 ❯ TestingInjector.loadInstance node_modules/.pnpm/@nestjs+core@10.2.6_@nestjs+common@10.2.6_@nestjs+platform-express@10.2.6_reflect-metadata@0.1.13_rxjs@7.8.1/node_modules/@nestjs/core/injector/injector.js:70:13
...

To Reproduce
Steps to reproduce the behavior:

Clone repro: https://github.com/sawa-ko/bug-bug
Prepare DB
Prepare test
Run pnpm test
See error

Expected behavior
No error on entities, since I do not understand the reason why this happens if they are two totally different suits.

Additional context
I think the problem is in await orm.getSchemaGenerator().refreshDatabase();, but I am not sure.

Versions

Dependency	Version
node	20.7.0
typescript	5.2.2
mikro-orm	5.8.2
your-driver	postgresql

B4nan · 2023-09-23T06:32:34Z

B4nan
Sep 23, 2023
Maintainer

This is not about closing the ORM, but rather about how autoLoadEntities works. There was a similar report some time ago here about vitest and nestjs with autoLoadEntities. But that particular problem should have been fixed with the 5.2.1 of that adapter (which I see you use already)...

Will take a closer look.

8 replies

sawa-ko Sep 23, 2023
Author

Perfect, the error is gone! But now I see that using await orm.getSchemaGenerator().refreshDatabase(); is not clearing the constraints, as I get the following error:

@Entity({
  tableName: 'a',
})
export class AEntity {
  @PrimaryKey()
  public id: number;

  @Property({
    check: "name ~* '^[A-Za-z0-9_-]+$'", // <-----
    columnType: 'varchar',
    comment: 'Unique username per user.',
    length: 30,
    type: 'string',
    unique: true,
  })
  public name!: string;
}

 FAIL  src/tests/b.spec.ts > AppService B > should create a row
DriverException: set names 'utf8';
set session_replication_role = 'replica';
create table "a" ("id" serial primary key, "name" varchar not null, constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'));
comment on column "a"."name" is 'Unique username per user.';
alter table "a" add constraint "a_name_unique" unique ("name");
create table "b" ("id" serial primary key, "name" varchar not null, constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'));
comment on column "b"."name" is 'Unique username per user.';
alter table "b" add constraint "b_name_unique" unique ("name");
set session_replication_role = 'origin'; - check constraint "a_name_check" already exists
 ❯ PostgreSqlExceptionConverter.convertException node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/platforms/ExceptionConverter.js:8:16
 ❯ PostgreSqlExceptionConverter.convertException node_modules/.pnpm/@mikro-orm+postgresql@5.8.2_@mikro-orm+core@5.8.2_sqlite3@5.1.6/node_modules/@mikro-orm/postgresql/PostgreSqlExceptionConverter.js:42:22
 ❯ PostgreSqlDriver.convertException node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/drivers/DatabaseDriver.js:197:54
 ❯ node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/drivers/DatabaseDriver.js:201:24
 ❯ SchemaGenerator.execute node_modules/.pnpm/@mikro-orm+knex@5.8.2_@mikro-orm+core@5.8.2_pg@8.11.3_sqlite3@5.1.6/node_modules/@mikro-orm/knex/schema/SchemaGenerator.js:377:25
 ❯ SchemaGenerator.createSchema node_modules/.pnpm/@mikro-orm+knex@5.8.2_@mikro-orm+core@5.8.2_pg@8.11.3_sqlite3@5.1.6/node_modules/@mikro-orm/knex/schema/SchemaGenerator.js:30:9
 ❯ SchemaGenerator.refreshDatabase node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/utils/AbstractSchemaGenerator.js:31:9
 ❯ src/tests/b.spec.ts:36:5
     34|     em = app.get<EntityManager>(EntityManager);
     35|
     36|     await orm.getSchemaGenerator().refreshDatabase();
       |     ^
     37|   });
     38|
 ❯ Parser.parseErrorMessage node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/parser.ts:369:69
 ❯ Parser.handlePacket node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/parser.ts:188:21
 ❯ Parser.parse node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/parser.ts:103:30
 ❯ Socket.<anonymous> node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/index.ts:7:48
 ❯ Socket.emit node:events:514:28

⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯
Serialized Error: { length: 115, severity: 'ERROR', code: '42710', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'heap.c', line: '2399', routine: 'AddRelationNewConstraints' }

B4nan Sep 23, 2023
Maintainer

It works fine for me locally. Maybe you have safe mode enabled? As you don't have any drop table queries there either.

sawa-ko Sep 23, 2023
Author

Hum, strange that it work for you, did you try the last changes I uploaded? Here is the complete log of the test.

> vitest run


 RUN  v0.34.5 C:/Users/USSIMBLPT07/Documents/bug-testing-mikro-orm

stdout | src/tests/a.spec.ts > AppService A > should be defined
[info] MikroORM version: 5.8.2
[discovery] ORM entity discovery started, using ReflectMetadataProvider
[discovery] - processing entity AEntity
[discovery] - processing entity BEntity
[discovery] - entity discovery finished, found 2 entities, took 14 ms

stdout | src/tests/a.spec.ts > AppService A > should be defined
[info] MikroORM successfully connected to database kento-testing on postgres://postgres:*****@127.0.0.1:5432
[query] select 1 from pg_database where datname = 'kento-testing' [took 2 ms, 1 result]

stdout | src/tests/a.spec.ts > AppService A > should be defined
[query] select table_name, table_schema as schema_name, (select pg_catalog.obj_description(c.oid) from pg_catalog.pg_class c where c.oid = (select ('"' || table_schema || '"."' || table_name || '"')::regclass::oid) and c.relname = table_name) as table_comment from information_schema.tables where "table_schema" not like 'pg_%' and "table_schema" not like 'crdb_%' and "table_schema" not like '_timescaledb_%' and "table_schema" not in ('information_schema', 'tiger', 'topology') and table_name != 'geometry_columns' and table_name != 'spatial_ref_sys' and table_type != 'VIEW' order by table_name [took 9 ms, 0 result]

stdout | src/tests/a.spec.ts > AppService A > should be defined
[query] set names 'utf8';set session_replication_role = 'replica';drop table if exists "b" cascade;drop table if exists "a" cascade;set session_replication_role = 'origin'; [took 8 ms]

stdout | src/tests/a.spec.ts > AppService A > should be defined
[query] set names 'utf8';set session_replication_role = 'replica';create table "a" ("id" serial primary key, "name" varchar not null, constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'));comment on column "a"."name" is 'Unique username per user.';alter table "a" add constraint "a_name_unique" unique ("name");create table "b" ("id" serial primary key, "name" varchar not null, constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'));comment on column "b"."name" is 'Unique username per user.';alter table "b" add constraint "b_name_unique" unique ("name");set session_replication_role = 'origin'; [took 24 ms]

stdout | src/tests/a.spec.ts > AppService A > should create a row
[info] MikroORM version: 5.8.2
[discovery] ORM entity discovery started, using ReflectMetadataProvider
[discovery] - processing entity AEntity
[discovery] - processing entity BEntity
[discovery] - entity discovery finished, found 2 entities, took 3 ms

stdout | src/tests/a.spec.ts > AppService A > should create a row                                                                                                                                                                   
[info] MikroORM successfully connected to database kento-testing on postgres://postgres:*****@127.0.0.1:5432                                                                                                                        
                                                                                                                                                                                                                                    
stdout | src/tests/a.spec.ts > AppService A > should create a row                                                                                                                                                                   
[query] select 1 from pg_database where datname = 'kento-testing' [took 2 ms, 1 result]                                                                                                                                             

stdout | src/tests/a.spec.ts > AppService A > should create a row
[query] select table_name, table_schema as schema_name, (select pg_catalog.obj_description(c.oid) from pg_catalog.pg_class c where c.oid = (select ('"' || table_schema || '"."' || table_name || '"')::regclass::oid) and c.relname
 = table_name) as table_comment from information_schema.tables where "table_schema" not like 'pg_%' and "table_schema" not like 'crdb_%' and "table_schema" not like '_timescaledb_%' and "table_schema" not in ('information_schema', 'tiger', 'topology') and table_name != 'geometry_columns' and table_name != 'spatial_ref_sys' and table_type != 'VIEW' order by table_name [took 4 ms, 2 results]
[query] select table_schema as schema_name, table_name, column_name, column_default, is_nullable, udt_name, coalesce(datetime_precision, character_maximum_length) length, numeric_precision, numeric_scale, data_type, (select pg_c
atalog.col_description(c.oid, cols.ordinal_position::int) from pg_catalog.pg_class c where c.oid = (select ('"' || cols.table_schema || '"."' || cols.table_name || '"')::regclass::oid) and c.relname = cols.table_name) as column_comment from information_schema.columns cols where ((table_schema = 'public' and table_name = 'a') or (table_schema = 'public' and table_name = 'b')) order by ordinal_position [took 6 ms, 4 results]

stdout | src/tests/a.spec.ts > AppService A > should create a row
[query] select indrelid::regclass as table_name, ns.nspname as schema_name, relname as constraint_name, idx.indisunique as unique, idx.indisprimary as primary, array( select pg_get_indexdef(idx.indexrelid, k + 1, true) from generate_subscripts(idx.indkey, 1) as k order by k ) as index_def from pg_index idx join pg_class as i on i.oid = idx.indexrelid join pg_namespace as ns on i.relnamespace = ns.oid where indrelid in ('"public"."a"'::regclass, '"public"."b"'::regclass) order by relname [took 2 ms, 4 results]
[query] select ccu.table_name as table_name, ccu.table_schema as schema_name, pgc.conname as name, conrelid::regclass as table_from, ccu.column_name as column_name, pg_get_constraintdef(pgc.oid) as expression from pg_constraint 
pgc join pg_namespace nsp on nsp.oid = pgc.connamespace join pg_class cls on pgc.conrelid = cls.oid join information_schema.constraint_column_usage ccu on pgc.conname = ccu.constraint_name and nsp.nspname = ccu.constraint_schema where contype = 'c' and (ccu.table_name = 'a' and ccu.table_schema = 'public' or ccu.table_name = 'b' and ccu.table_schema = 'public') order by pgc.conname [took 4 ms, 2 results]

stdout | src/tests/a.spec.ts > AppService A > should create a row
[query] select tco.table_schema as schema_name, kcu.table_name as table_name, rel_kcu.table_name as referenced_table_name, rel_kcu.constraint_schema as referenced_schema_name, kcu.column_name as column_name, rel_kcu.column_name 
as referenced_column_name, kcu.constraint_name, rco.update_rule, rco.delete_rule from information_schema.table_constraints tco join information_schema.key_column_usage kcu on tco.constraint_schema = kcu.constraint_schema and tco
.constraint_name = kcu.constraint_name join information_schema.referential_constraints rco on tco.constraint_schema = rco.constraint_schema and tco.constraint_name = rco.constraint_name join information_schema.key_column_usage r
el_kcu on rco.unique_constraint_schema = rel_kcu.constraint_schema and rco.unique_constraint_name = rel_kcu.constraint_name and kcu.ordinal_position = rel_kcu.ordinal_position where (tco.table_name = 'a' and tco.table_schema = '
public' and tco.constraint_schema = 'public' or tco.table_name = 'b' and tco.table_schema = 'public' and tco.constraint_schema = 'public') and tco.constraint_type = 'FOREIGN KEY' order by kcu.table_schema, kcu.table_name, kcu.ordinal_position, kcu.constraint_name [took 6 ms, 0 result]

stdout | src/tests/a.spec.ts > AppService A > should create a row
[query] set names 'utf8';set session_replication_role = 'replica';drop table if exists "b" cascade;drop table if exists "a" cascade;set session_replication_role = 'origin'; [took 4 ms]

stdout | src/tests/a.spec.ts > AppService A > should create a row
[query] set names 'utf8';set session_replication_role = 'replica';create table "a" ("id" serial primary key, "name" varchar not null, constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'));comment on column "a"."name" is 'Unique username per user.';alter table "a" add constraint "a_name_unique" unique ("name");create table "b" ("id" serial primary key, "name" varchar not null, constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'));comment on column "b"."name" is 'Unique username per user.';alter table "b" add constraint "b_name_unique" unique ("name");set session_replication_role = 'origin'; [took 24 ms]
[query] begin

stdout | src/tests/a.spec.ts > AppService A > should create a row
[query] insert into "a" ("name") values ('a') returning "id" [took 7 ms]
[query] commit

stdout | src/tests/c.spec.ts > AppService C > should be defined                                                                                                                                                                     
[info] MikroORM version: 5.8.2                                                                                                                                                                                                      
[discovery] ORM entity discovery started, using ReflectMetadataProvider                                                                                                                                                             
[discovery] - processing entity AEntity                                                                                                                                                                                             
[discovery] - processing entity BEntity                                                                                                                                                                                             
[discovery] - entity discovery finished, found 2 entities, took 3 ms                                                                                                                                                                

stdout | src/tests/c.spec.ts > AppService C > should be defined                                                                                                                                                                     
[info] MikroORM successfully connected to database kento-testing on postgres://postgres:*****@127.0.0.1:5432                                                                                                                        
[query] select 1 from pg_database where datname = 'kento-testing' [took 2 ms, 1 result]                                                                                                                                             
                                                                                                                                                                                                                                    
stdout | src/tests/c.spec.ts > AppService C > should be defined                                                                                                                                                                     
[query] select table_name, table_schema as schema_name, (select pg_catalog.obj_description(c.oid) from pg_catalog.pg_class c where c.oid = (select ('"' || table_schema || '"."' || table_name || '"')::regclass::oid) and c.relname
 = table_name) as table_comment from information_schema.tables where "table_schema" not like 'pg_%' and "table_schema" not like 'crdb_%' and "table_schema" not like '_timescaledb_%' and "table_schema" not in ('information_schema', 'tiger', 'topology') and table_name != 'geometry_columns' and table_name != 'spatial_ref_sys' and table_type != 'VIEW' order by table_name [took 3 ms, 2 results]

stdout | src/tests/c.spec.ts > AppService C > should be defined                                                                                                                                                                     
[query] select table_schema as schema_name, table_name, column_name, column_default, is_nullable, udt_name, coalesce(datetime_precision, character_maximum_length) length, numeric_precision, numeric_scale, data_type, (select pg_catalog.col_description(c.oid, cols.ordinal_position::int) from pg_catalog.pg_class c where c.oid = (select ('"' || cols.table_schema || '"."' || cols.table_name || '"')::regclass::oid) and c.relname = cols.table_name) as column_comment from information_schema.columns cols where ((table_schema = 'public' and table_name = 'a') or (table_schema = 'public' and table_name = 'b')) order by ordinal_position [took 6 ms, 4 results]                              
                                                                                                                                                                                                                                    
stdout | src/tests/c.spec.ts > AppService C > should be defined                                                                                                                                                                     
[query] select indrelid::regclass as table_name, ns.nspname as schema_name, relname as constraint_name, idx.indisunique as unique, idx.indisprimary as primary, array( select pg_get_indexdef(idx.indexrelid, k + 1, true) from gene
rate_subscripts(idx.indkey, 1) as k order by k ) as index_def from pg_index idx join pg_class as i on i.oid = idx.indexrelid join pg_namespace as ns on i.relnamespace = ns.oid where indrelid in ('"public"."a"'::regclass, '"public"."b"'::regclass) order by relname [took 2 ms, 4 results]
[query] select ccu.table_name as table_name, ccu.table_schema as schema_name, pgc.conname as name, conrelid::regclass as table_from, ccu.column_name as column_name, pg_get_constraintdef(pgc.oid) as expression from pg_constraint 
pgc join pg_namespace nsp on nsp.oid = pgc.connamespace join pg_class cls on pgc.conrelid = cls.oid join information_schema.constraint_column_usage ccu on pgc.conname = ccu.constraint_name and nsp.nspname = ccu.constraint_schema where contype = 'c' and (ccu.table_name = 'a' and ccu.table_schema = 'public' or ccu.table_name = 'b' and ccu.table_schema = 'public') order by pgc.conname [took 5 ms, 2 results]

stdout | src/tests/c.spec.ts > AppService C > should be defined
[query] select tco.table_schema as schema_name, kcu.table_name as table_name, rel_kcu.table_name as referenced_table_name, rel_kcu.constraint_schema as referenced_schema_name, kcu.column_name as column_name, rel_kcu.column_name 
as referenced_column_name, kcu.constraint_name, rco.update_rule, rco.delete_rule from information_schema.table_constraints tco join information_schema.key_column_usage kcu on tco.constraint_schema = kcu.constraint_schema and tco
.constraint_name = kcu.constraint_name join information_schema.referential_constraints rco on tco.constraint_schema = rco.constraint_schema and tco.constraint_name = rco.constraint_name join information_schema.key_column_usage r
el_kcu on rco.unique_constraint_schema = rel_kcu.constraint_schema and rco.unique_constraint_name = rel_kcu.constraint_name and kcu.ordinal_position = rel_kcu.ordinal_position where (tco.table_name = 'a' and tco.table_schema = '
public' and tco.constraint_schema = 'public' or tco.table_name = 'b' and tco.table_schema = 'public' and tco.constraint_schema = 'public') and tco.constraint_type = 'FOREIGN KEY' order by kcu.table_schema, kcu.table_name, kcu.ordinal_position, kcu.constraint_name [took 6 ms, 0 result]

stdout | src/tests/c.spec.ts > AppService C > should be defined                                                                                                                                                                     
[query] set names 'utf8';set session_replication_role = 'replica';drop table if exists "b" cascade;drop table if exists "a" cascade;set session_replication_role = 'origin'; [took 12 ms]                                           
                                                                                                                                                                                                                                    
stdout | src/tests/c.spec.ts > AppService C > should be defined                                                                                                                                                                     
[query] set names 'utf8';set session_replication_role = 'replica';create table "a" ("id" serial primary key, "name" varchar not null, constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'));comment on column "a"."name" is 'Unique username per user.';alter table "a" add constraint "a_name_unique" unique ("name");create table "b" ("id" serial primary key, "name" varchar not null, constraint 
b_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'));comment on column "b"."name" is 'Unique username per user.';alter table "b" add constraint "b_name_unique" unique ("name");set session_replication_role = 'origin'; [took 6 ms]

stdout | src/tests/c.spec.ts > AppService C > should create a row
[info] MikroORM version: 5.8.2
[discovery] ORM entity discovery started, using ReflectMetadataProvider
[discovery] - processing entity AEntity
[discovery] - processing entity BEntity
[discovery] - entity discovery finished, found 2 entities, took 7 ms

stdout | src/tests/c.spec.ts > AppService C > should create a row
[info] MikroORM successfully connected to database kento-testing on postgres://postgres:*****@127.0.0.1:5432
[query] select 1 from pg_database where datname = 'kento-testing' [took 2 ms, 1 result]

stdout | src/tests/c.spec.ts > AppService C > should create a row
[query] select table_name, table_schema as schema_name, (select pg_catalog.obj_description(c.oid) from pg_catalog.pg_class c where c.oid = (select ('"' || table_schema || '"."' || table_name || '"')::regclass::oid) and c.relname = table_name) as table_comment from information_schema.tables where "table_schema" not like 'pg_%' and "table_schema" not like 'crdb_%' and "table_schema" not like '_timescaledb_%' and "table_schema" not in ('information_schema', 'tiger', 'topology') and table_name != 'geometry_columns' and table_name != 'spatial_ref_sys' and table_type != 'VIEW' order by table_name [took 3 ms, 0 result]
[query] set names 'utf8';set session_replication_role = 'replica';drop table if exists "b" cascade;drop table if exists "a" cascade;set session_replication_role = 'origin'; [took 1 ms]
[query] set names 'utf8';set session_replication_role = 'replica';create table "a" ("id" serial primary key, "name" varchar not null, constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint a_name_check check (nam
e ~* '^[A-Za-z0-9_-]+$'));comment on column "a"."name" is 'Unique username per user.';alter table "a" add constraint "a_name_unique" unique ("name");create table "b" ("id" serial primary key, "name" varchar not null, constraint 
b_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'));comment on column "b"."name" is 'Unique username per user.';alter table "b" add constraint "b_name_unique" unique ("name");set session_replication_role = 'origin'; [took 1 ms]

stdout | src/tests/b.spec.ts > AppService B > should be defined
[info] MikroORM version: 5.8.2
[discovery] ORM entity discovery started, using ReflectMetadataProvider
[discovery] - processing entity AEntity
[discovery] - processing entity BEntity
[discovery] - entity discovery finished, found 2 entities, took 2 ms

stdout | src/tests/b.spec.ts > AppService B > should be defined
[info] MikroORM successfully connected to database kento-testing on postgres://postgres:*****@127.0.0.1:5432
[query] select 1 from pg_database where datname = 'kento-testing' [took 1 ms, 1 result]
[query] select table_name, table_schema as schema_name, (select pg_catalog.obj_description(c.oid) from pg_catalog.pg_class c where c.oid = (select ('"' || table_schema || '"."' || table_name || '"')::regclass::oid) and c.relname = table_name) as table_comment from information_schema.tables where "table_schema" not like 'pg_%' and "table_schema" not like 'crdb_%' and "table_schema" not like '_timescaledb_%' and "table_schema" not in ('information_schema', 'tiger', 'topology') and table_name != 'geometry_columns' and table_name != 'spatial_ref_sys' and table_type != 'VIEW' order by table_name [took 3 ms, 0 result]
[query] set names 'utf8';set session_replication_role = 'replica';drop table if exists "b" cascade;drop table if exists "a" cascade;set session_replication_role = 'origin'; [took 5 ms]

stdout | src/tests/b.spec.ts > AppService B > should be defined
[query] set names 'utf8';set session_replication_role = 'replica';create table "a" ("id" serial primary key, "name" varchar not null, constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'));comment on column "a"."name" is 'Unique username per user.';alter table "a" add constraint "a_name_unique" unique ("name");create table "b" ("id" serial primary key, "name" varchar not null, constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'));comment on column "b"."name" is 'Unique username per user.';alter table "b" add constraint "b_name_unique" unique ("name");set session_replication_role = 'origin'; [took 8 ms]

stdout | src/tests/b.spec.ts > AppService B > should create a row
[info] MikroORM version: 5.8.2
[discovery] ORM entity discovery started, using ReflectMetadataProvider
[discovery] - processing entity AEntity
[discovery] - processing entity BEntity
[discovery] - entity discovery finished, found 2 entities, took 2 ms

stdout | src/tests/b.spec.ts > AppService B > should create a row
[info] MikroORM successfully connected to database kento-testing on postgres://postgres:*****@127.0.0.1:5432
[query] select 1 from pg_database where datname = 'kento-testing' [took 1 ms, 1 result]

stdout | src/tests/b.spec.ts > AppService B > should create a row                                                                                                                                                                   
[query] select table_name, table_schema as schema_name, (select pg_catalog.obj_description(c.oid) from pg_catalog.pg_class c where c.oid = (select ('"' || table_schema || '"."' || table_name || '"')::regclass::oid) and c.relname = table_name) as table_comment from information_schema.tables where "table_schema" not like 'pg_%' and "table_schema" not like 'crdb_%' and "table_schema" not like '_timescaledb_%' and "table_schema" not in ('information_schema', 'tiger', 'topology') and table_name != 'geometry_columns' and table_name != 'spatial_ref_sys' and table_type != 'VIEW' order by table_name [took 9 ms, 0 result]                                                                 
                                                                                                                                                                                                                                    
stdout | src/tests/b.spec.ts > AppService B > should create a row                                                                                                                                                                   
[query] set names 'utf8';set session_replication_role = 'replica';drop table if exists "b" cascade;drop table if exists "a" cascade;set session_replication_role = 'origin'; [took 7 ms]                                            
                                                                                                                                                                                                                                    
stdout | src/tests/b.spec.ts > AppService B > should create a row                                                                                                                                                                   
[query] set names 'utf8';set session_replication_role = 'replica';create table "a" ("id" serial primary key, "name" varchar not null, constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'));comment on column "a"."name" is 'Unique username per user.';alter table "a" add constraint "a_name_unique" unique ("name");create table "b" ("id" serial primary key, "name" varchar not null, constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'));comment on column "b"."name" is 'Unique username per user.';alter table "b" add constraint "b_name_unique" unique ("name");set session_replication_role = 'origin'; [took 2 ms]                                                    
                                                                                                                                                                                                                                    
 ✓ src/tests/a.spec.ts (2)
 ❯ src/tests/c.spec.ts (2)
   ❯ AppService C (2)
     × should be defined
       \ [ beforeEach ]
     × should create a row
       - [ beforeEach ]
 ❯ src/tests/b.spec.ts (2)
   ❯ AppService B (2)
     × should be defined
       - [ beforeEach ]
     × should create a row
       \ [ beforeEach ]

⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Failed Tests 4 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯

 FAIL  src/tests/b.spec.ts > AppService B > should be defined
 FAIL  src/tests/b.spec.ts > AppService B > should create a row
DriverException: set names 'utf8';
set session_replication_role = 'replica';
create table "a" ("id" serial primary key, "name" varchar not null, constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'));
comment on column "a"."name" is 'Unique username per user.';
alter table "a" add constraint "a_name_unique" unique ("name");
create table "b" ("id" serial primary key, "name" varchar not null, constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'));
comment on column "b"."name" is 'Unique username per user.';
alter table "b" add constraint "b_name_unique" unique ("name");
set session_replication_role = 'origin'; - check constraint "a_name_check" already exists
 ❯ PostgreSqlExceptionConverter.convertException node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/platforms/ExceptionConverter.js:8:16
 ❯ PostgreSqlExceptionConverter.convertException node_modules/.pnpm/@mikro-orm+postgresql@5.8.2_@mikro-orm+core@5.8.2_sqlite3@5.1.6/node_modules/@mikro-orm/postgresql/PostgreSqlExceptionConverter.js:42:22
 ❯ PostgreSqlDriver.convertException node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/drivers/DatabaseDriver.js:197:54
 ❯ node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/drivers/DatabaseDriver.js:201:24
 ❯ SchemaGenerator.execute node_modules/.pnpm/@mikro-orm+knex@5.8.2_@mikro-orm+core@5.8.2_pg@8.11.3_sqlite3@5.1.6/node_modules/@mikro-orm/knex/schema/SchemaGenerator.js:377:25
 ❯ SchemaGenerator.createSchema node_modules/.pnpm/@mikro-orm+knex@5.8.2_@mikro-orm+core@5.8.2_pg@8.11.3_sqlite3@5.1.6/node_modules/@mikro-orm/knex/schema/SchemaGenerator.js:30:9
 ❯ SchemaGenerator.refreshDatabase node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/utils/AbstractSchemaGenerator.js:31:9
 ❯ src/tests/b.spec.ts:36:5
     34|     em = app.get<EntityManager>(EntityManager);
     35|
     36|     await orm.getSchemaGenerator().refreshDatabase();
       |     ^
     37|   });
     38|
 ❯ Parser.parseErrorMessage node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/parser.ts:369:69
 ❯ Parser.handlePacket node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/parser.ts:188:21
 ❯ Parser.parse node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/parser.ts:103:30
 ❯ Socket.<anonymous> node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/index.ts:7:48
 ❯ Socket.emit node:events:514:28

⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯
Serialized Error: { length: 115, severity: 'ERROR', code: '42710', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'heap.c', line: '2399', routine: 'AddRelationNewConstraints' }
⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯[1/4]⎯

 FAIL  src/tests/c.spec.ts > AppService C > should be defined
 FAIL  src/tests/c.spec.ts > AppService C > should create a row
DriverException: set names 'utf8';
set session_replication_role = 'replica';
create table "a" ("id" serial primary key, "name" varchar not null, constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'));
comment on column "a"."name" is 'Unique username per user.';
alter table "a" add constraint "a_name_unique" unique ("name");
create table "b" ("id" serial primary key, "name" varchar not null, constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'), constraint b_name_check check (name ~* '^[A-Za-z0-9_-]+$'));
comment on column "b"."name" is 'Unique username per user.';
alter table "b" add constraint "b_name_unique" unique ("name");
set session_replication_role = 'origin'; - check constraint "a_name_check" already exists
 ❯ PostgreSqlExceptionConverter.convertException node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/platforms/ExceptionConverter.js:8:16
 ❯ PostgreSqlExceptionConverter.convertException node_modules/.pnpm/@mikro-orm+postgresql@5.8.2_@mikro-orm+core@5.8.2_sqlite3@5.1.6/node_modules/@mikro-orm/postgresql/PostgreSqlExceptionConverter.js:42:22
 ❯ PostgreSqlDriver.convertException node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/drivers/DatabaseDriver.js:197:54
 ❯ node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/drivers/DatabaseDriver.js:201:24
 ❯ SchemaGenerator.execute node_modules/.pnpm/@mikro-orm+knex@5.8.2_@mikro-orm+core@5.8.2_pg@8.11.3_sqlite3@5.1.6/node_modules/@mikro-orm/knex/schema/SchemaGenerator.js:377:25
 ❯ SchemaGenerator.createSchema node_modules/.pnpm/@mikro-orm+knex@5.8.2_@mikro-orm+core@5.8.2_pg@8.11.3_sqlite3@5.1.6/node_modules/@mikro-orm/knex/schema/SchemaGenerator.js:30:9
 ❯ SchemaGenerator.refreshDatabase node_modules/.pnpm/@mikro-orm+core@5.8.2_@mikro-orm+postgresql@5.8.2_@mikro-orm+sqlite@5.8.2/node_modules/@mikro-orm/core/utils/AbstractSchemaGenerator.js:31:9
 ❯ src/tests/c.spec.ts:36:5
     34|     em = app.get<EntityManager>(EntityManager);
     35|
     36|     await orm.getSchemaGenerator().refreshDatabase();
       |     ^
     37|   });
     38|
 ❯ Parser.parseErrorMessage node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/parser.ts:369:69
 ❯ Parser.handlePacket node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/parser.ts:188:21
 ❯ Parser.parse node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/parser.ts:103:30
 ❯ Socket.<anonymous> node_modules/.pnpm/pg-protocol@1.6.0/node_modules/pg-protocol/src/index.ts:7:48
 ❯ Socket.emit node:events:514:28

⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯
Serialized Error: { length: 115, severity: 'ERROR', code: '42710', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'heap.c', line: '2399', routine: 'AddRelationNewConstraints' }
⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯[2/4]⎯

 Test Files  2 failed | 1 passed (3)
      Tests  4 failed | 2 passed (6)
   Start at  09:15:04
   Duration  2.00s (transform 42ms, setup 0ms, collect 705ms, tests 528ms, environment 0ms, prepare 100ms)

 ELIFECYCLE  Test failed. See above for more details.

B4nan Sep 24, 2023
Maintainer

Ok I see whats happening. Its not about clearing existing things, some queries literally try to create the same constraint multiple times:

create table "a" (
	"id" serial primary key,
	"name" varchar not null,
	constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'),
	constraint a_name_check check (name ~* '^[A-Za-z0-9_-]+$'));

That's because of global/decorator metadata storage is not being cleared, but the require cache is not present apparently. FYI if you remove singleThread: true from your vitest config, things will start to work fine, as you will get isolated contexts.

Will try to do some deduplication during discovery, it should easy, there are more things than just the check constraints that can suffer from this.

edit: here you go fb523c8?w=1

sawa-ko Sep 24, 2023
Author

Thank you, all my errors have been solved!

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Entity error using mikro-orm with vitest #4733

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 1 comment 8 replies

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

Select a reply

Entity error using mikro-orm with vitest #4733

sawa-ko Sep 23, 2023

Replies: 1 comment · 8 replies

B4nan Sep 23, 2023 Maintainer

sawa-ko Sep 23, 2023 Author

B4nan Sep 23, 2023 Maintainer

sawa-ko Sep 23, 2023 Author

B4nan Sep 24, 2023 Maintainer

sawa-ko Sep 24, 2023 Author

sawa-ko
Sep 23, 2023

Replies: 1 comment 8 replies

B4nan
Sep 23, 2023
Maintainer

sawa-ko Sep 23, 2023
Author

B4nan Sep 23, 2023
Maintainer

sawa-ko Sep 23, 2023
Author

B4nan Sep 24, 2023
Maintainer

sawa-ko Sep 24, 2023
Author