Oct 31 03:27:50 soviet.tankie.tube systemd[1]: Stopping peertube.service - PeerTube daemon...
Oct 31 03:27:50 soviet.tankie.tube systemd[1]: peertube.service: Deactivated successfully.
Oct 31 03:27:50 soviet.tankie.tube systemd[1]: Stopped peertube.service - PeerTube daemon.
Oct 31 03:27:50 soviet.tankie.tube systemd[1]: peertube.service: Consumed 2d 5h 47min 34.411s CPU time.
Oct 31 03:27:50 soviet.tankie.tube systemd[1]: Started peertube.service - PeerTube daemon.
Oct 31 03:27:51 soviet.tankie.tube peertube[457121]: [tankie.tube:443 uploadx] 2024-10-31 03:27:51.820 debug: DiskStorage config: {
Oct 31 03:27:51 soviet.tankie.tube peertube[457121]: directory: '/var/www/peertube/storage/tmp/resumable-uploads',
Oct 31 03:27:51 soviet.tankie.tube peertube[457121]: expiration: { maxAge: undefined, rolling: true },
Oct 31 03:27:51 soviet.tankie.tube peertube[457121]: maxMetadataSize: '10MB',
Oct 31 03:27:51 soviet.tankie.tube peertube[457121]: logger: [Function: Object],
Oct 31 03:27:51 soviet.tankie.tube peertube[457121]: userIdentifier: [Function: userIdentifier],
Oct 31 03:27:51 soviet.tankie.tube peertube[457121]: filename: [Function: filename]
Oct 31 03:27:51 soviet.tankie.tube peertube[457121]: }
Oct 31 03:27:51 soviet.tankie.tube peertube[457121]: [tankie.tube:443 uploadx] 2024-10-31 03:27:51.823 debug: Registered handlers: DELETE, GET, OPTIONS, PATCH, POST, PUT
Oct 31 03:27:52 soviet.tankie.tube peertube[457121]: [tankie.tube:443] 2024-10-31 03:27:52.132 debug: Checking NodeJS version v18.20.4.
Oct 31 03:27:52 soviet.tankie.tube peertube[457121]: [tankie.tube:443] 2024-10-31 03:27:52.132 info: Using following configuration file hierarchy: /var/www/peertube/config/default.yaml -> /var/www/peertube/config/production.yaml -> /var/www/peertube/config/local-production.json.
Oct 31 03:27:52 soviet.tankie.tube peertube[457121]: [tankie.tube:443] 2024-10-31 03:27:52.192 error: Unable to connect to PostgreSQL database. {
Oct 31 03:27:52 soviet.tankie.tube peertube[457121]: "err": {
Oct 31 03:27:52 soviet.tankie.tube peertube[457121]: "stack": "Error: Parse error: Unexpected \": SELECT 1\" at line 1 column 20.\nThis likely happens because you're using the default \"sql\" dialect.\nIf possible, please select a more specific dialect (like sqlite, postgresql, etc).\n at TokenizerEngine.createParseError (file:///var/www/peertube/versions/peertube-v6.3.2/node_modules/sql-formatter/dist/index.js:15859:12)\n at TokenizerEngine.tokenize (file:///var/www/peertube/versions/peertube-v6.3.2/node_modules/sql-formatter/dist/index.js:15849:22)\n at Tokenizer.tokenize (file:///var/www/peertube/versions/peertube-v6.3.2/node_modules/sql-formatter/dist/index.js:15969:65)\n at LexerAdapter.tokenize (file:///var/www/peertube/versions/peertube-v6.3.2/node_modules/sql-formatter/dist/index.js:16806:37)\n at LexerAdapter.reset (file:///var/www/peertube/versions/peertube-v6.3.2/node_modules/sql-formatter/dist/index.js:16341:24)\n at Parser.feed (/var/www/peertube/versions/peertube-v6.3.2/node_modules/nearley/lib/nearley.js:281:15)\n at Object.parse (file:///var/www/peertube/versions/peertube-v6.3.2/node_modules/sql-formatter/dist/index.js:16813:34)\n at Formatter.parse (file:///var/www/peertube/versions/peertube-v6.3.2/node_modules/sql-formatter/dist/index.js:17522:49)\n at Formatter.format (file:///var/www/peertube/versions/peertube-v6.3.2/node_modules/sql-formatter/dist/index.js:17517:22)\n at formatDialect (file:///var/www/peertube/versions/peertube-v6.3.2/node_modules/sql-formatter/dist/index.js:17640:57)\n at format (file:///var/www/peertube/versions/peertube-v6.3.2/node_modules/sql-formatter/dist/index.js:17630:10)\n at Printf.template (file:///var/www/peertube/versions/peertube-v6.3.2/dist/core/helpers/logger.js:18:39)\n at Printf.transform (/var/www/peertube/versions/peertube-v6.3.2/node_modules/logform/printf.js:11:26)\n at Format.transform (/var/www/peertube/versions/peertube-v6.3.2/node_modules/logform/combine.js:20:24)\n at Console._write (/var/www/peertube/versions/peertube-v6.3.2/node_modules/winston-transport/modern.js:91:33)\n at doWrite (/var/www/peertube/versions/peertube-v6.3.2/node_modules/readable-stream/lib/_stream_writable.js:390:139)",
Oct 31 03:27:52 soviet.tankie.tube peertube[457121]: "message": "Parse error: Unexpected \": SELECT 1\" at line 1 column 20.\nThis likely happens because you're using the default \"sql\" dialect.\nIf possible, please select a more specific dialect (like sqlite, postgresql, etc)."
Oct 31 03:27:52 soviet.tankie.tube peertube[457121]: }
Oct 31 03:27:52 soviet.tankie.tube peertube[457121]: }
Oct 31 03:27:52 soviet.tankie.tube systemd[1]: peertube.service: Main process exited, code=exited, status=255/EXCEPTION
Oct 31 03:27:52 soviet.tankie.tube systemd[1]: peertube.service: Failed with result 'exit-code'.
Oct 31 03:27:52 soviet.tankie.tube systemd[1]: peertube.service: Consumed 1.688s CPU time.
Oct 31 03:27:52 soviet.tankie.tube systemd[1]: peertube.service: Scheduled restart job, restart counter is at 1.
Thanks, it should be fixed by Fix sql formatter crash · Chocobozzz/PeerTube@29cdeb0 · GitHub
As a workaround, you can disable prettify_sql config
1 « J'aime »