Deploy/Kubernetes/Enc

[dikshauat]

Hi @keshavprasad,

Please help us resolving the below error we are getting on kubernetes cluster for the Deploy' ENC job of Sunbird

dikshauat@cloudshell:~ (diksha-poc)$ kubectl logs -f enc-6964fbbff9-kx8v9 -n dev
Unhandled rejection SequelizeDatabaseError: relation "Keys" does not exist
at Query.formatError (/home/enc/node_modules/sequelize/lib/dialects/postgres/query.js:366:16)
at query.catch.err (/home/enc/node_modules/sequelize/lib/dialects/postgres/query.js:72:18)
at tryCatcher (/home/enc/node_modules/bluebird/js/release/util.js:16:23)
at Promise._settlePromiseFromHandler (/home/enc/node_modules/bluebird/js/release/promise.js:547:31)
at Promise._settlePromise (/home/enc/node_modules/bluebird/js/release/promise.js:604:18)
at Promise._settlePromise0 (/home/enc/node_modules/bluebird/js/release/promise.js:649:10)
at Promise._settlePromises (/home/enc/node_modules/bluebird/js/release/promise.js:725:18)
at _drainQueueStep (/home/enc/node_modules/bluebird/js/release/async.js:93:12)
at _drainQueue (/home/enc/node_modules/bluebird/js/release/async.js:86:9)
at Async._drainQueues (/home/enc/node_modules/bluebird/js/release/async.js:102:5)
at Immediate.Async.drainQueues (/home/enc/node_modules/bluebird/js/release/async.js:15:14)
at runCallback (timers.js:672:20)
at tryOnImmediate (timers.js:645:5)
at processImmediate [as _immediateCallback] (timers.js:617:5)
Error starting service { SequelizeDatabaseError: relation "Keys" does not exist
at Query.formatError (/home/enc/node_modules/sequelize/lib/dialects/postgres/query.js:366:16)
at query.catch.err (/home/enc/node_modules/sequelize/lib/dialects/postgres/query.js:72:18)
at tryCatcher (/home/enc/node_modules/bluebird/js/release/util.js:16:23)
at Promise._settlePromiseFromHandler (/home/enc/node_modules/bluebird/js/release/promise.js:547:31)
at Promise._settlePromise (/home/enc/node_modules/bluebird/js/release/promise.js:604:18)
at Promise._settlePromise0 (/home/enc/node_modules/bluebird/js/release/promise.js:649:10)
at Promise._settlePromises (/home/enc/node_modules/bluebird/js/release/promise.js:725:18)
at _drainQueueStep (/home/enc/node_modules/bluebird/js/release/async.js:93:12)
at _drainQueue (/home/enc/node_modules/bluebird/js/release/async.js:86:9)
at Async._drainQueues (/home/enc/node_modules/bluebird/js/release/async.js:102:5)
at Immediate.Async.drainQueues (/home/enc/node_modules/bluebird/js/release/async.js:15:14)
at runCallback (timers.js:672:20)
at tryOnImmediate (timers.js:645:5)
at processImmediate [as _immediateCallback] (timers.js:617:5)
name: 'SequelizeDatabaseError',
parent:
{ error: relation "Keys" does not exist
at Connection.parseE (/home/enc/node_modules/pg/lib/connection.js:567:11)
at Connection.parseMessage (/home/enc/node_modules/pg/lib/connection.js:391:17)
at Socket. (/home/enc/node_modules/pg/lib/connection.js:129:22)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at readableAddChunk (_stream_readable.js:176:18)
at Socket.Readable.push (_stream_readable.js:134:10)
at TCP.onread (net.js:559:20)
name: 'error',
length: 103,
severity: 'ERROR',
code: '42P01',
detail: undefined,
hint: undefined,
position: '95',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_relation.c',
line: '1180',
routine: 'parserOpenTable',
sql: 'SELECT "id", "public", "private", "type", "active", "reserved", "createdAt", "updatedAt" FROM "Keys" AS "Keys";',
parameters: undefined },
original:
{ error: relation "Keys" does not exist
at Connection.parseE (/home/enc/node_modules/pg/lib/connection.js:567:11)
at Connection.parseMessage (/home/enc/node_modules/pg/lib/connection.js:391:17)
at Socket. (/home/enc/node_modules/pg/lib/connection.js:129:22)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at readableAddChunk (_stream_readable.js:176:18)
at Socket.Readable.push (_stream_readable.js:134:10)
at TCP.onread (net.js:559:20)
name: 'error',
length: 103,
severity: 'ERROR',
code: '42P01',
detail: undefined,
hint: undefined,
position: '95',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_relation.c',
line: '1180',
routine: 'parserOpenTable',
sql: 'SELECT "id", "public", "private", "type", "active", "reserved", "createdAt", "updatedAt" FROM "Keys" AS "Keys";',
parameters: undefined },
sql: 'SELECT "id", "public", "private", "type", "active", "reserved", "createdAt", "updatedAt" FROM "Keys" AS "Keys";',
parameters: undefined }

[beepdot]

Please refer to the answer posted here - https://github.com/orgs/Sunbird-Ed/discussions/78

[beepdot]

Please use the image which I have shared in the above thread for deployment and let me know if it works or not.

[jaingaurav126]

Thanks for resolving the issue. Marking it as answered.