Document loading indefinitely

Docs API
1

Hi, just want to ask for help on onlyoffice deployed via Kubernetes. Upon opening a document, it just loads indefinitely, and the error in the docservice logs says:

[2022-09-28T09:23:59.925] [WARN] nodeJS - sqlQuery error sqlCommand: INSERT INTO task_result (id, status, status_info, :
error: there is no unique or exclusion constraint matching the ON CONFLICT specification
    at Parser.parseErrorMessage (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:287:98)
    at Parser.handlePacket (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:126:29)
    at Parser.parse (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:39:38)
    at Socket.<anonymous> (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (events.js:400:28)
    at addChunk (internal/streams/readable.js:290:12)
    at readableAddChunk (internal/streams/readable.js:265:9)
    at Socket.Readable.push (internal/streams/readable.js:204:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:188:23)
[2022-09-28T09:23:59.925] [ERROR] nodeJS - error receiving response: docId = undefined type = auth
error: there is no unique or exclusion constraint matching the ON CONFLICT specification
    at Parser.parseErrorMessage (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:287:98)
    at Parser.handlePacket (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:126:29)
    at Parser.parse (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:39:38)
    at Socket.<anonymous> (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (events.js:400:28)
    at addChunk (internal/streams/readable.js:290:12)
    at readableAddChunk (internal/streams/readable.js:265:9)
    at Socket.Readable.push (internal/streams/readable.js:204:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:188:23)

Thanks in advance.

2

Hello @lmanlutac
As far as I understand, you have contacted with my colleagues via Zendesk already. Please do not post the same request in different communication channels.

3

Hi @Alexandre noted on this and thanks!

1 Like
4

Hi!
Have a similar problem with nextcloud integration:

[2022-10-30T06:00:43.714] [WARN] nodeJS - sqlQuery error sqlCommand: INSERT INTO task_result (id, status, status_info, :
error: there is no unique or exclusion constraint matching the ON CONFLICT
    at Parser.parseErrorMessage (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:287:98)
    at Parser.handlePacket (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:126:29)
    at Parser.parse (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:39:38)
    at Socket.<anonymous> (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (events.js:400:28)
    at addChunk (internal/streams/readable.js:290:12)
    at readableAddChunk (internal/streams/readable.js:265:9)
    at Socket.Readable.push (internal/streams/readable.js:204:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:188:23)
[2022-10-30T06:00:43.714] [ERROR] nodeJS - Error convert: docId = conv_check_482239360_docx
error: there is no unique or exclusion constraint matching the ON CONFLICT
    at Parser.parseErrorMessage (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:287:98)
    at Parser.handlePacket (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:126:29)
    at Parser.parse (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/parser.js:39:38)
    at Socket.<anonymous> (/snapshot/server/build/server/DocService/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (events.js:400:28)
    at addChunk (internal/streams/readable.js:290:12)
    at readableAddChunk (internal/streams/readable.js:265:9)
    at Socket.Readable.push (internal/streams/readable.js:204:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:188:23)

Any solution?

5

Hello @Aleksov
I believe we should start with general information about your installation:

  1. Please let us know Document server, Nextcloud, connector app versions.
  2. Please reproduce the issue > check ‘Console’ and ‘Network’ tabs in browser console (F12 in Google Chrome) > make screenshots of any error entries.
  3. Please point us to the guide which you used for Document server installation.
  4. Please provide us with whole Document server logs folder.
  5. When did the issue start? From the first day of installation? Or after some server side actions?
  6. Do you use external Postgre database? If so, please clarify how exactly you connected Postgre to Document server. Also let us know your Postgre version.