Database error during start peertube

Hi everyone!
I manually install peertube instance. Nginx show me 502 Bad gateway.
In peertube’s …/storage/logs/peertube.log I found strings:

{
“level”: “error”,
“message”: “Cannot execute migration 0005.”,
“label”: “pt.bsuir.by:443”,
“err”: {
“stack”: “SequelizeDatabaseError: relation “public.Pods” does not exist
at Query.formatError (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/sequelize/lib/dialects/postgres/query.js:366:16)
at /var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/sequelize/lib/dialects/postgres/query.js:72:18
at tryCatcher (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/bluebird/js/release/util.js:16:23)
at Promise._settlePromiseFromHandler (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/bluebird/js/release/promise.js:547:31)
at Promise._settlePromise (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/bluebird/js/release/promise.js:604:18)
at Promise._settlePromise0 (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/bluebird/js/release/promise.js:649:10)
at Promise._settlePromises (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/bluebird/js/release/promise.js:725:18)
at _drainQueueStep (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/bluebird/js/release/async.js:93:12)
at _drainQueue (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/bluebird/js/release/async.js:86:9)
at Async._drainQueues (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/bluebird/js/release/async.js:102:5)
at Immediate.Async.drainQueues [as _onImmediate] (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/bluebird/js/release/async.js:15:14)
at processImmediate (internal/timers.js:456:21)”,
“message”: “relation “public.Pods” does not exist”,
“name”: “SequelizeDatabaseError”,
“parent”: {
“stack”: “error: relation “public.Pods” does not exist\n at Connection.parseE (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/pg/lib/connection.js:604:11)\n at Connection.parseMessage (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/pg/lib/connection.js:401:19)\n at Socket. (/var/pt.bsuir.by/versions/peertube-v2.0.0/node_modules/pg/lib/connection.js:121:22)\n at Socket.emit (events.js:321:20)\n at addChunk (_stream_readable.js:297:12)\n at readableAddChunk (_stream_readable.js:273:9)\n at Socket.Readable.push (_stream_readable.js:214:10)\n at TCP.onStreamRead (internal/stream_base_commons.js:186:23)”,
“message”: “relation “public.Pods” does not exist”,
“name”: “error”,
“length”: 109,
“severity”: “ERROR”,
“code”: “42P01”,
“file”: “namespace.c”,
“line”: “402”,
“routine”: “RangeVarGetRelidExtended”,
“sql”: “ALTER TABLE “public”.“Pods” ADD COLUMN “email” VARCHAR(400) NOT NULL DEFAULT ‘’;”
},
“sql”: “ALTER TABLE “public”.“Pods” ADD COLUMN “email” VARCHAR(400) NOT NULL DEFAULT ‘’;”
},
“timestamp”: “2020-02-03T14:40:29.646Z”
}

What is it? How can I solve this problem?
Thanks.

Please delete and re create your database and paste the output. I think there is an issue when peertube tries to initialize the database.

1 « J'aime »

Thank you. Its solved.

I’m sorry.
I have some problems with admin authentication.

But I have label “Invalid client: client is invalid”.
Tell me where the error may be.
Thanks.

Restart httpd and start/enable peertube and view peertube log.