Failed OpenWebUI Update

[nightowlPH]

Hi. We're doing a routine upgrade for the apps currently installed in our instance. Of all apps scheduled for update, I noticed OpenWebUI failed. I tried restoring it using one of the backups but it failed.

Below is the snippet of the logs taken from the Log Viewer:

Oct 18 01:49:19 apptask: run: app error for state pending_restore: BoxError: PostgreSQL restore failed. ERROR:  invalid input syntax for type json
DETAIL:  Expected "," or "}", but found "]".
CONTEXT:  JSON data, line 1: ...NEBZeIiIiIiMgI+f8BKrgu3Knzl+cAAAAASUVORK5CYII="}]...
COPY chat, line 212, column chat: "{"id": "", "title": "\ud83d\udd04 Duplicate Schema Guide", "models": ["gpt-4.1"], "params": {}, "his..." Check logs in the Services view.
    at Object.restorePostgreSql [as restore] (file:///home/yellowtent/box/src/services.js:918:22)
    at process.processTicksAndRejections (node:internal/process/task_queues:104:5)
    at async Object.restoreAddons (file:///home/yellowtent/box/src/services.js:2393:9)
    at async installCommand (file:///home/yellowtent/box/src/apptask.js:493:9) {
  [stack]: [Getter/Setter],
  [message]: 'PostgreSQL restore failed. ERROR:  invalid input syntax for type json\n' +
    'DETAIL:  Expected "," or "}", but found "]".\n' +
    'CONTEXT:  JSON data, line 1: ...NEBZeIiIiIiMgI+f8BKrgu3Knzl+cAAAAASUVORK5CYII="}]...\n' +
    'COPY chat, line 212, column chat: "{"id": "", "title": "\\ud83d\\udd04 Duplicate Schema Guide", "models": ["gpt-4.1"], "params": {}, "his..." Check logs in the Services view.',
  name: 'BoxError',
  reason: 'Addons Error',
  extra: {}
}
Oct 18 01:49:19 tasks: setCompleted - 8869: {"result":null,"error":{"message":"PostgreSQL restore failed. ERROR:  invalid input syntax for type json\nDETAIL:  Expected \",\" or \"}\", but found \"]\".\nCONTEXT:  JSON data, line 1: ...NEBZeIiIiIiMgI+f8BKrgu3Knzl+cAAAAASUVORK5CYII=\"}]...\nCOPY chat, line 212, column chat: \"{\"id\": \"\", \"title\": \"\\ud83d\\udd04 Duplicate Schema Guide\", \"models\": [\"gpt-4.1\"], \"params\": {}, \"his...\" Check logs in the Services view.","reason":"Addons Error","stack":"BoxError: PostgreSQL restore failed. ERROR:  invalid input syntax for type json\nDETAIL:  Expected \",\" or \"}\", but found \"]\".\nCONTEXT:  JSON data, line 1: ...NEBZeIiIiIiMgI+f8BKrgu3Knzl+cAAAAASUVORK5CYII=\"}]...\nCOPY chat, line 212, column chat: \"{\"id\": \"\", \"title\": \"\\ud83d\\udd04 Duplicate Schema Guide\", \"models\": [\"gpt-4.1\"], \"params\": {}, \"his...\" Check logs in the Services view.\n    at Object.restorePostgreSql [as restore] (file:///home/yellowtent/box/src/services.js:918:22)\n    at process.processTicksAndRejections (node:internal/process/task_queues:104:5)\n    at async Object.restoreAddons (file:///home/yellowtent/box/src/services.js:2393:9)\n    at async installCommand (file:///home/yellowtent/box/src/apptask.js:493:9)"},"percent":100}
Oct 18 01:49:19 tasks: updating task 8869 with: {"completed":true,"result":null,"error":{"message":"PostgreSQL restore failed. ERROR:  invalid input syntax for type json\nDETAIL:  Expected \",\" or \"}\", but found \"]\".\nCONTEXT:  JSON data, line 1: ...NEBZeIiIiIiMgI+f8BKrgu3Knzl+cAAAAASUVORK5CYII=\"}]...\nCOPY chat, line 212, column chat: \"{\"id\": \"\", \"title\": \"\\ud83d\\udd04 Duplicate Schema Guide\", \"models\": [\"gpt-4.1\"], \"params\": {}, \"his...\" Check logs in the Services view.","reason":"Addons Error","stack":"BoxError: PostgreSQL restore failed. ERROR:  invalid input syntax for type json\nDETAIL:  Expected \",\" or \"}\", but found \"]\".\nCONTEXT:  JSON data, line 1: ...NEBZeIiIiIiMgI+f8BKrgu3Knzl+cAAAAASUVORK5CYII=\"}]...\nCOPY chat, line 212, column chat: \"{\"id\": \"\", \"title\": \"\\ud83d\\udd04 Duplicate Schema Guide\", \"models\": [\"gpt-4.1\"], \"params\": {}, \"his...\" Check logs in the Services view.\n    at Object.restorePostgreSql [as restore] (file:///home/yellowtent/box/src/services.js:918:22)\n    at process.processTicksAndRejections (node:internal/process/task_queues:104:5)\n    at async Object.restoreAddons (file:///home/yellowtent/box/src/services.js:2393:9)\n    at async installCommand (file:///home/yellowtent/box/src/apptask.js:493:9)"},"percent":100}
Oct 18 01:49:19 taskworker: Task took 48.589 seconds
Oct 18 01:49:19 BoxError: PostgreSQL restore failed. ERROR:  invalid input syntax for type json
DETAIL:  Expected "," or "}", but found "]".
CONTEXT:  JSON data, line 1: ...NEBZeIiIiIiMgI+f8BKrgu3Knzl+cAAAAASUVORK5CYII="}]...
COPY chat, line 212, column chat: "{"id": "", "title": "\ud83d\udd04 Duplicate Schema Guide", "models": ["gpt-4.1"], "params": {}, "his..." Check logs in the Services view.
    at Object.restorePostgreSql [as restore] (file:///home/yellowtent/box/src/services.js:918:22)
    at process.processTicksAndRejections (node:internal/process/task_queues:104:5)
    at async Object.restoreAddons (file:///home/yellowtent/box/src/services.js:2393:9)
    at async installCommand (file:///home/yellowtent/box/src/apptask.js:493:9)
Oct 18 01:49:19 Exiting with code 0

[james]

Hello @nightowlph
This looks like something in your OpenWebUI database is causing this restore crash.
Can you find out what that is in the database that is containing this NEBZeIiIiIiMgI+f8BKrgu3Knzl+cAAAAASUVORK5CYII=?
If we can find out what is stored there we might able to understand what is causing the restore crash.

[joseph]

This was confirmed as solved in support. @nightowlph maybe you can explain how.