Untitled

> school-back@0.0.1 migration:run
> npm run typeorm migration:run -- -d src/config/orm.config.ts


> school-back@0.0.1 typeorm
> ts-node -r tsconfig-paths/register --files ./node_modules/typeorm/cli.js migration:run -d src/config/orm.config.ts

query: SELECT * FROM current_schema()
query: CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
query: SELECT version();
query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = 'public' AND "table_name" = 'migrations'
query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
55 migrations are already loaded in the database.
58 migrations were found in the source code.
AddSubjectInitialGradePermissions1738229318477 is the last executed migration. It was executed on Thu Jan 30 2025 09:28:38 GMT+0000 (Coordinated Universal Time).
3 migrations are new migrations must be executed.
query: START TRANSACTION
query: 
            ALTER TABLE "users"
            ALTER COLUMN "gender"
            SET DEFAULT 'MALE'
        
query: INSERT INTO "migrations"("timestamp", "name") VALUES ($1, $2) -- PARAMETERS: [1738332048076,"SetDefaultUserGender1738332048076"]
Migration SetDefaultUserGender1738332048076 has been  executed successfully.
query: 
            CREATE TYPE "public"."questionnaire_results_gender_enum" AS ENUM('MALE', 'FEMALE')
        
query: 
            ALTER TABLE "questionnaire_results"
            ADD "gender" "public"."questionnaire_results_gender_enum"
        
query: 
            ALTER TABLE "questionnaire_results"
            ADD "socialMediaUrls" jsonb
        
query: 
            ALTER TABLE "questionnaire_results"
            ADD "birthday" character varying
        
query: 
            ALTER TABLE "questionnaire_results"
            ADD "country" character varying
        
query: 
            ALTER TABLE "questionnaire_results"
            ADD "description" character varying
        
query: INSERT INTO "migrations"("timestamp", "name") VALUES ($1, $2) -- PARAMETERS: [1738506424145,"AddNewFieldsQuestionnaireResults1738506424145"]
Migration AddNewFieldsQuestionnaireResults1738506424145 has been  executed successfully.
query: 
            ALTER TABLE "users"
            ALTER COLUMN "fields"
            SET NOT NULL
        
query failed: 
            ALTER TABLE "users"
            ALTER COLUMN "fields"
            SET NOT NULL
        
error: error: column "fields" of relation "users" contains null values
Migration "AddDefaultValueFieldsUsers1738510453808" failed, error: column "fields" of relation "users" contains null values
query: ROLLBACK
Error during migration run:
QueryFailedError: column "fields" of relation "users" contains null values
    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/src/driver/postgres/PostgresQueryRunner.ts:331:19)
    at processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async AddDefaultValueFieldsUsers1738510453808.up (/usr/src/app/src/migrations/1738510453808-add-default-value-fields-users.ts:7:5)
    at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/src/migration/MigrationExecutor.ts:336:17)
    at async DataSource.runMigrations (/usr/src/app/node_modules/src/data-source/DataSource.ts:403:13)
    at async Object.handler (/usr/src/app/node_modules/src/commands/MigrationRunCommand.ts:76:13) {
  query: '\n' +
    '            ALTER TABLE "users"\n' +
    '            ALTER COLUMN "fields"\n' +
    '            SET NOT NULL\n' +
    '        ',
  parameters: undefined,
  driverError: error: column "fields" of relation "users" contains null values
      at /usr/src/app/node_modules/pg/lib/client.js:535:17
      at processTicksAndRejections (node:internal/process/task_queues:105:5)
      at async PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/src/driver/postgres/PostgresQueryRunner.ts:260:25)
      at async AddDefaultValueFieldsUsers1738510453808.up (/usr/src/app/src/migrations/1738510453808-add-default-value-fields-users.ts:7:5)
      at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/src/migration/MigrationExecutor.ts:336:17)
      at async DataSource.runMigrations (/usr/src/app/node_modules/src/data-source/DataSource.ts:403:13)
      at async Object.handler (/usr/src/app/node_modules/src/commands/MigrationRunCommand.ts:76:13) {
    length: 142,
    severity: 'ERROR',
    code: '23502',
    detail: undefined,
    hint: undefined,
    position: undefined,
    internalPosition: undefined,
    internalQuery: undefined,
    where: undefined,
    schema: 'public',
    table: 'users',
    column: 'fields',
    dataType: undefined,
    constraint: undefined,
    file: 'tablecmds.c',
    line: '6279',
    routine: 'ATRewriteTable'
  },
  length: 142,
  severity: 'ERROR',
  code: '23502',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: 'public',
  table: 'users',
  column: 'fields',
  dataType: undefined,
  constraint: undefined,
  file: 'tablecmds.c',
  line: '6279',
  routine: 'ATRewriteTable'
}