DevOps - k8s "error: select count(*) as 'count'"
{"graphQLErrors":[{"name":"Server Error","message":"Something went wrong! Please contact your administrator"}],"networkError":null,"message":"Something went wrong! Please contact your administrator"}
Kotahi server pod logs
info: Missing auth token
info: ::ffff:10.0.2.187 - - [13/Apr/2021:12:44:57 +0000] "GET / HTTP/1.1" 200 216 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36"
info: ::ffff:10.0.2.187 - - [13/Apr/2021:12:44:58 +0000] "GET /js/app.af29a5f9.js HTTP/1.1" 200 - "https://k8s.kotahi.cloud/" "Mozilla/5.0 (Windows NT 10.0;
Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36"
error: select count(*) as "count" from (select "manuscripts".* from "manuscripts" where published IS NOT NULL) as "temp" - current transaction is aborted, commands ignored until end of transaction block length=144, name=error, severity=ERROR, code=25P02, detail=undefined, hint=undefined, position=undefined, internalPosition=undefined, internalQuery=undefined, where=undefined, schema=undefined, table=undefined, column=undefined, dataType=undefined, constraint=undefined, file=postgres.c, line=1105, routine=exec_simple_query, originalStack=error: select count(*) as "count" from (select "manuscripts".* from "manuscripts" where published IS NOT NULL) as "temp" - current transaction is aborted, commands ignored until end of transaction block
at Parser.parseErrorMessage (/home/node/app/node_modules/pg-protocol/dist/parser.js:278:15)
at Parser.handlePacket (/home/node/app/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/home/node/app/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket.<anonymous> (/home/node/app/node_modules/pg-protocol/dist/index.js:10:42)
at Socket.emit (events.js:314:20)
at addChunk (_stream_readable.js:297:12)
at readableAddChunk (_stream_readable.js:272:9)
at Socket.Readable.push (_stream_readable.js:213:10)
at TCP.onStreamRead (internal/stream_base_commons.js:188:23)