HPNmBHFE

1C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend>npm run typeorm:cli migration:run
2openssl config failed: error:02001003:system library:fopen:No such process
3openssl config failed: error:02001003:system library:fopen:No such process
4
5> enekeskonyv-backend@0.0.1 typeorm:cli C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend
6> ts-node ./node_modules/typeorm/cli -f ormconfig.json "migration:run"
7
8openssl config failed: error:02001003:system library:fopen:No such process
9query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = 'public' AND "table_name" = 'migrations'
10query: SELECT * FROM "public"."migrations" "public.migrations"
110 migrations are already loaded in the database.
124 migrations were found in the source code.
134 migrations are new migrations that needs to be executed.
14query: START TRANSACTION
15query: CREATE SCHEMA IF NOT EXISTS "enekeskonyv"
16query: INSERT INTO "public"."migrations"("timestamp", "name") VALUES ($1, $2) -- PARAMETERS: [1558038478927,"addSchema1558038478927"]
17Migration addSchema1558038478927 has been executed successfully.
18query: CREATE TABLE "enekeskonyv"."song" ("id" SERIAL NOT NULL, "created_at" timestamptz NOT NULL DEFAULT now(), "creator" int NOT NULL, "updated_at" timestamptz NOT NULL DEFAULT now(), "row_version" int NOT NULL DEFAULT 1, "title" text NOT NULL, "song" text NOT NULL, CONSTRAINT "PK_ba8dca3a978d70e0e3dd0bb688a" PRIMARY KEY ("id"))
19query: INSERT INTO "public"."migrations"("timestamp", "name") VALUES ($1, $2) -- PARAMETERS: [1558038478928,"addSongTables1558038478928"]
20Migration addSongTables1558038478928 has been executed successfully.
21query: CREATE TABLE "enekeskonyv"."audit" ("id" SERIAL NOT NULL, "updated_at" timestamptz NOT NULL DEFAULT now(), "updated_by" int NOT NULL, "table" text NOT NULL, "version" int NOT NULL, "modification" json NOT NULL, CONSTRAINT "PK_87b7e7b38d48787e8a95cdb964d" PRIMARY KEY ("id"))
22query: INSERT INTO "public"."migrations"("timestamp", "name") VALUES ($1, $2) -- PARAMETERS: [1558038478929,"addAuditTable1558038478929"]
23Migration addAuditTable1558038478929 has been executed successfully.
24query: SELECT * FROM current_schema()
25query: SELECT * FROM "information_schema"."tables" WHERE ("table_schema" = 'enekeskonyv' AND "table_name" = 'song')
26query: SELECT *, ('"' || "udt_schema" || '"."' || "udt_name" || '"')::"regtype" AS "regtype" FROM "information_schema"."columns" WHERE ("table_schema" = 'enekeskonyv' AND "table_name" = 'song')
27query: SELECT "ns"."nspname" AS "table_schema", "t"."relname" AS "table_name", "cnst"."conname" AS "constraint_name", CASE "cnst"."contype" WHEN 'x' THEN pg_get_constraintdef("cnst"."oid", true) ELSE "cnst"."consrc" END AS "expression", CASE "cnst"."contype" WHEN 'p' THEN 'PRIMARY' WHEN 'u' THEN 'UNIQUE' WHEN 'c' THEN 'CHECK' WHEN 'x' THEN 'EXCLUDE' END AS "constraint_type", "a"."attname" AS "column_name" FROM "pg_constraint" "cnst" INNER JOIN "pg_class" "t" ON "t"."oid" = "cnst"."conrelid" INNER JOIN "pg_namespace" "ns" ON "ns"."oid" = "cnst"."connamespace" LEFT JOIN "pg_attribute" "a" ON "a"."attrelid" = "cnst"."conrelid" AND "a"."attnum" = ANY ("cnst"."conkey") WHERE "t"."relkind" = 'r' AND (("ns"."nspname" = 'enekeskonyv' AND "t"."relname" = 'song'))
28query: SELECT "ns"."nspname" AS "table_schema", "t"."relname" AS "table_name", "i"."relname" AS "constraint_name", "a"."attname" AS "column_name", CASE "ix"."indisunique" WHEN 't' THEN 'TRUE' ELSE'FALSE' END AS "is_unique", pg_get_expr("ix"."indpred", "ix"."indrelid") AS "condition", "types"."typname" AS "type_name" FROM "pg_class" "t" INNER JOIN "pg_index" "ix" ON "ix"."indrelid" = "t"."oid" INNER JOIN "pg_attribute" "a" ON "a"."attrelid" = "t"."oid"  AND "a"."attnum" = ANY ("ix"."indkey") INNER JOIN "pg_namespace" "ns" ON "ns"."oid" = "t"."relnamespace" INNER JOIN "pg_class" "i" ON "i"."oid" = "ix"."indexrelid" INNER JOIN "pg_type" "types" ON "types"."oid" = "a"."atttypid" LEFT JOIN "pg_constraint" "cnst" ON "cnst"."conname" = "i"."relname" WHERE "t"."relkind" = 'r' AND "cnst"."contype" IS NULL AND (("ns"."nspname" = 'enekeskonyv' AND "t"."relname" = 'song'))
29query: SELECT "con"."conname" AS "constraint_name", "con"."nspname" AS "table_schema", "con"."relname" AS "table_name", "att2"."attname" AS "column_name", "ns"."nspname" AS "referenced_table_schema", "cl"."relname" AS "referenced_table_name", "att"."attname" AS "referenced_column_name", "con"."confdeltype" AS "on_delete", "con"."confupdtype" AS "on_update", "con"."condeferrable" AS "deferrable", "con"."condeferred" AS "deferred" FROM ( SELECT UNNEST ("con1"."conkey") AS "parent", UNNEST ("con1"."confkey") AS "child", "con1"."confrelid", "con1"."conrelid", "con1"."conname", "con1"."contype", "ns"."nspname", "cl"."relname", "con1"."condeferrable", CASE WHEN "con1"."condeferred" THEN 'INITIALLY DEFERRED' ELSE 'INITIALLY IMMEDIATE' END as condeferred, CASE "con1"."confdeltype" WHEN 'a' THEN 'NO ACTION' WHEN 'r' THEN 'RESTRICT' WHEN 'c' THEN 'CASCADE' WHEN 'n' THEN 'SET NULL' WHEN 'd' THEN 'SET DEFAULT' END as "confdeltype", CASE "con1"."confupdtype" WHEN 'a' THEN 'NO ACTION' WHEN 'r' THEN 'RESTRICT' WHEN 'c' THEN 'CASCADE' WHEN 'n' THEN 'SET NULL' WHEN 'd' THEN 'SET DEFAULT' END as "confupdtype" FROM "pg_class" "cl" INNER JOIN "pg_namespace" "ns" ON "cl"."relnamespace" = "ns"."oid" INNER JOIN "pg_constraint" "con1" ON "con1"."conrelid" = "cl"."oid" WHERE "con1"."contype" = 'f' AND (("ns"."nspname" = 'enekeskonyv' AND "cl"."relname" = 'song')) ) "con" INNER JOIN "pg_attribute" "att" ON "att"."attrelid" = "con"."confrelid" AND "att"."attnum" = "con"."child" INNER JOIN "pg_class" "cl" ON "cl"."oid" = "con"."confrelid" INNER JOIN "pg_namespace" "ns" ON "cl"."relnamespace" = "ns"."oid" INNER JOIN "pg_attribute" "att2" ON "att2"."attrelid" = "con"."conrelid" AND "att2"."attnum" = "con"."parent"
30query failed: SELECT "ns"."nspname" AS "table_schema", "t"."relname" AS "table_name", "cnst"."conname" AS "constraint_name", CASE "cnst"."contype" WHEN 'x' THEN pg_get_constraintdef("cnst"."oid", true) ELSE "cnst"."consrc" END AS "expression", CASE "cnst"."contype" WHEN 'p' THEN 'PRIMARY' WHEN 'u' THEN 'UNIQUE' WHEN 'c' THEN 'CHECK' WHEN 'x' THEN 'EXCLUDE' END AS "constraint_type", "a"."attname" AS "column_name" FROM "pg_constraint" "cnst" INNER JOIN "pg_class" "t" ON "t"."oid" = "cnst"."conrelid" INNER JOIN "pg_namespace" "ns" ON "ns"."oid" = "cnst"."connamespace" LEFT JOIN "pg_attribute" "a" ON "a"."attrelid" = "cnst"."conrelid" AND "a"."attnum" = ANY ("cnst"."conkey") WHERE "t"."relkind" = 'r' AND (("ns"."nspname" = 'enekeskonyv' AND "t"."relname" = 'song'))
31error: { error: column cnst.consrc does not exist
32    at Connection.parseE (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\connection.js:602:11)
33    at Connection.parseMessage (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\connection.js:399:19)
34    at Socket.<anonymous> (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\connection.js:121:22)
35    at Socket.emit (events.js:182:13)
36    at Socket.EventEmitter.emit (domain.js:441:20)
37    at addChunk (_stream_readable.js:283:12)
38    at readableAddChunk (_stream_readable.js:264:11)
39    at Socket.Readable.push (_stream_readable.js:219:10)
40    at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
41  name: 'error',
42  length: 259,
43  severity: 'ERROR',
44  code: '42703',
45  detail: undefined,
46  hint:
47   'Perhaps you meant to reference the column "cnst.conkey" or the column "cnst.conbin".',
48  position: '194',
49  internalPosition: undefined,
50  internalQuery: undefined,
51  where: undefined,
52  schema: undefined,
53  table: undefined,
54  column: undefined,
55  dataType: undefined,
56  constraint: undefined,
57  file:
58   'd:\\pginstaller_12.auto\\postgres.windows-x64\\src\\backend\\parser\\parse_relation.c',
59  line: '3377',
60  routine: 'errorMissingColumn' }
61query: ROLLBACK
62query failed: SELECT "ns"."nspname" AS "table_schema", "t"."relname" AS "table_name", "i"."relname" AS "constraint_name", "a"."attname" AS "column_name", CASE "ix"."indisunique" WHEN 't' THEN 'TRUE' ELSE'FALSE' END AS "is_unique", pg_get_expr("ix"."indpred", "ix"."indrelid") AS "condition", "types"."typname" AS "type_name" FROM "pg_class" "t" INNER JOIN "pg_index" "ix" ON "ix"."indrelid" = "t"."oid" INNER JOIN "pg_attribute" "a" ON "a"."attrelid" = "t"."oid"  AND "a"."attnum" = ANY ("ix"."indkey") INNER JOIN "pg_namespace" "ns" ON "ns"."oid" = "t"."relnamespace" INNER JOIN "pg_class" "i" ON "i"."oid" = "ix"."indexrelid" INNER JOIN "pg_type" "types" ON "types"."oid" = "a"."atttypid" LEFT JOIN "pg_constraint" "cnst" ON "cnst"."conname" = "i"."relname" WHERE "t"."relkind" = 'r' AND "cnst"."contype" IS NULL AND (("ns"."nspname" = 'enekeskonyv' AND "t"."relname" = 'song'))
63error: { error: current transaction is aborted, commands ignored until end of transaction block
64    at Connection.parseE (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\connection.js:602:11)
65    at Connection.parseMessage (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\connection.js:399:19)
66    at Socket.<anonymous> (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\connection.js:121:22)
67    at Socket.emit (events.js:182:13)
68    at Socket.EventEmitter.emit (domain.js:441:20)
69    at addChunk (_stream_readable.js:283:12)
70    at readableAddChunk (_stream_readable.js:264:11)
71    at Socket.Readable.push (_stream_readable.js:219:10)
72    at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
73  name: 'error',
74  length: 205,
75  severity: 'ERROR',
76  code: '25P02',
77  detail: undefined,
78  hint: undefined,
79  position: undefined,
80  internalPosition: undefined,
81  internalQuery: undefined,
82  where: undefined,
83  schema: undefined,
84  table: undefined,
85  column: undefined,
86  dataType: undefined,
87  constraint: undefined,
88  file:
89   'd:\\pginstaller_12.auto\\postgres.windows-x64\\src\\backend\\tcop\\postgres.c',
90  line: '1105',
91  routine: 'exec_simple_query' }
92query failed: SELECT "con"."conname" AS "constraint_name", "con"."nspname" AS "table_schema", "con"."relname" AS "table_name", "att2"."attname" AS "column_name", "ns"."nspname" AS "referenced_table_schema", "cl"."relname" AS "referenced_table_name", "att"."attname" AS "referenced_column_name", "con"."confdeltype" AS "on_delete", "con"."confupdtype" AS "on_update", "con"."condeferrable" AS "deferrable", "con"."condeferred" AS "deferred" FROM ( SELECT UNNEST ("con1"."conkey") AS "parent", UNNEST ("con1"."confkey") AS "child", "con1"."confrelid", "con1"."conrelid", "con1"."conname", "con1"."contype", "ns"."nspname", "cl"."relname", "con1"."condeferrable", CASE WHEN "con1"."condeferred" THEN 'INITIALLY DEFERRED' ELSE 'INITIALLY IMMEDIATE' END as condeferred, CASE "con1"."confdeltype" WHEN 'a' THEN 'NO ACTION' WHEN 'r' THEN 'RESTRICT' WHEN 'c' THEN 'CASCADE' WHEN 'n' THEN 'SET NULL' WHEN 'd' THEN 'SET DEFAULT' END as "confdeltype", CASE "con1"."confupdtype" WHEN 'a' THEN 'NO ACTION' WHEN 'r' THEN 'RESTRICT' WHEN 'c' THEN 'CASCADE' WHEN 'n' THEN 'SET NULL' WHEN 'd' THEN 'SET DEFAULT' END as "confupdtype" FROM "pg_class" "cl" INNER JOIN "pg_namespace" "ns" ON "cl"."relnamespace" = "ns"."oid" INNER JOIN "pg_constraint" "con1" ON "con1"."conrelid" = "cl"."oid" WHERE "con1"."contype" = 'f' AND (("ns"."nspname" = 'enekeskonyv' AND "cl"."relname" = 'song')) ) "con" INNER JOIN "pg_attribute" "att" ON "att"."attrelid" = "con"."confrelid" AND "att"."attnum" = "con"."child" INNER JOIN "pg_class" "cl" ON "cl"."oid" = "con"."confrelid" INNER JOIN "pg_namespace" "ns" ON "cl"."relnamespace" = "ns"."oid" INNER JOIN "pg_attribute" "att2" ON "att2"."attrelid" = "con"."conrelid" AND "att2"."attnum" = "con"."parent"
93error: { error: current transaction is aborted, commands ignored until end of transaction block
94    at Connection.parseE (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\connection.js:602:11)
95    at Connection.parseMessage (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\connection.js:399:19)
96    at Socket.<anonymous> (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\connection.js:121:22)
97    at Socket.emit (events.js:182:13)
98    at Socket.EventEmitter.emit (domain.js:441:20)
99    at addChunk (_stream_readable.js:283:12)
100    at readableAddChunk (_stream_readable.js:264:11)
101    at Socket.Readable.push (_stream_readable.js:219:10)
102    at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
103  name: 'error',
104  length: 205,
105  severity: 'ERROR',
106  code: '25P02',
107  detail: undefined,
108  hint: undefined,
109  position: undefined,
110  internalPosition: undefined,
111  internalQuery: undefined,
112  where: undefined,
113  schema: undefined,
114  table: undefined,
115  column: undefined,
116  dataType: undefined,
117  constraint: undefined,
118  file:
119   'd:\\pginstaller_12.auto\\postgres.windows-x64\\src\\backend\\tcop\\postgres.c',
120  line: '1105',
121  routine: 'exec_simple_query' }
122Error during migration run:
123{ QueryFailedError: column cnst.consrc does not exist
124    at new QueryFailedError (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\src\error\QueryFailedError.ts:9:9)
125    at Query.callback (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\src\driver\postgres\PostgresQueryRunner.ts:178:30)
126    at Query.handleError (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\query.js:142:17)
127    at Connection.connectedErrorMessageHandler (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\client.js:194:17)
128    at Connection.emit (events.js:182:13)
129    at Connection.EventEmitter.emit (domain.js:441:20)
130    at Socket.<anonymous> (C:\Users\Antal Zoltán\Documents\Énekeskönyv\backend\node_modules\pg\lib\connection.js:126:12)
131    at Socket.emit (events.js:182:13)
132    at Socket.EventEmitter.emit (domain.js:441:20)
133    at addChunk (_stream_readable.js:283:12)
134  message: 'column cnst.consrc does not exist',
135  name: 'QueryFailedError',
136  length: 259,
137  severity: 'ERROR',
138  code: '42703',
139  detail: undefined,
140  hint:
141   'Perhaps you meant to reference the column "cnst.conkey" or the column "cnst.conbin".',
142  position: '194',
143  internalPosition: undefined,
144  internalQuery: undefined,
145  where: undefined,
146  schema: undefined,
147  table: undefined,
148  column: undefined,
149  dataType: undefined,
150  constraint: undefined,
151  file:
152   'd:\\pginstaller_12.auto\\postgres.windows-x64\\src\\backend\\parser\\parse_relation.c',
153  line: '3377',
154  routine: 'errorMissingColumn',
155  query:
156   'SELECT "ns"."nspname" AS "table_schema", "t"."relname" AS "table_name", "cnst"."conname" AS "constraint_name", CASE "cnst"."contype" WHEN \'x\' THEN pg_get_constraintdef("cnst"."oid", true) ELSE "cnst"."consrc" END AS "expression", CASE "cnst"."contype" WHEN \'p\' THEN \'PRIMARY\' WHEN \'u\' THEN \'UNIQUE\' WHEN \'c\' THEN \'CHECK\' WHEN \'x\' THEN \'EXCLUDE\' END AS "constraint_type", "a"."attname" AS "column_name" FROM "pg_constraint" "cnst" INNER JOIN "pg_class" "t" ON "t"."oid" = "cnst"."conrelid" INNER JOIN "pg_namespace" "ns" ON "ns"."oid" = "cnst"."connamespace" LEFT JOIN "pg_attribute" "a" ON "a"."attrelid" = "cnst"."conrelid" AND "a"."attnum" = ANY ("cnst"."conkey") WHERE "t"."relkind" = \'r\' AND (("ns"."nspname" = \'enekeskonyv\' AND "t"."relname" = \'song\'))',
157  parameters: [] }
158npm ERR! code ELIFECYCLE
159npm ERR! errno 1
160npm ERR! enekeskonyv-backend@0.0.1 typeorm:cli: `ts-node ./node_modules/typeorm/cli -f ormconfig.json "migration:run"`
161npm ERR! Exit status 1
162npm ERR!
163npm ERR! Failed at the enekeskonyv-backend@0.0.1 typeorm:cli script.
164npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
165
166npm ERR! A complete log of this run can be found in:
167npm ERR!     C:\Users\Antal Zoltán\AppData\Roaming\npm-cache\_logs\2020-01-28T21_12_19_119Z-debug.log