#Can't add new queries

1 messages · Page 1 of 1 (latest)

hoary fossil
#

I have a large app with 59 queries. When I try to add another query to this app it sends the request (visible in console) but never returns a response. Appsmith frontend just gives a general error: 'There was an unexpected error'.

:authority:
appsmith.sevi.io
:method:
POST
:path:
/api/v1/actions

actionConfiguration
:
{pluginSpecifiedTemplates: [{value: true}], body: "SELECT * FROM anon."address" LIMIT 10;"}
datasource
:
{id: "63e42a80164069489c5e78ad"}
eventData
:
{actionType: "Query", from: "ENTITY_EXPLORER", dataSource: "postgres",…}
name
:
"Query2"
pageId
:
"63f338113a458715dc9d251b"
pluginId
:
"63e4281b164069489c5e7870"
source
:
"SELF"

Other apps do not fail this action, I tried everything I could without admin privileges. It runs self-hosted Appsmith Community v1.17

#

While this action is awaiting I can only see the names of other queries (and the newly created one). Clicking on the new one does nothing. Clicking on an already existing one start loading until the action is completed (or timed-out in my case)

#

And clicking around opens the 'Oops Something went wrong' page.

I found some additional information, here is what I think is the error, or part of it. I can't really find an error.

{type: 'CREATE_ACTION_ERROR', payload: {…}, @@redux-saga/SAGA_ACTION: true}
payload
:
actionConfiguration
:
body
:
"SELECT * FROM anon."address" LIMIT 10;"
formData
:
undefined
pluginSpecifiedTemplates
:
[{…}]
[[Prototype]]
:
Object
datasource
:
{id: '63e42a80164069489c5e78ad'}
eventData
:
{actionType: 'Query', from: 'ENTITY_EXPLORER', dataSource: 'postgres', datasourceId: '63e42a80164069489c5e78ad', pluginName: 'PostgreSQL', …}
name
:
"Query1"
pageId
:
"63f338113a458715dc9d251b"
pluginId
:
"63e4281b164069489c5e7870"
source
:
"SELF"
[[Prototype]]
:
Object
type
:
"CREATE_ACTION_ERROR"
@@redux-saga/SAGA_ACTION
:
true
[[Prototype]]
:
Object

And here is the error code before it sends me to the error page:
index.tsx:1101 TypeError: Cannot read properties of undefined (reading 'url')
at navigationSelectors.ts:187:41
at index.js:70:25
at index.js:30:25
at index.js:84:33
at index.js:30:25
at EvaluatedValuePopup.tsx:483:5
at useSelector.js:29:30
at useSelector.js:125:25
at Oe (EvaluatedValuePopup.tsx:482:30)
at io (react-dom.production.min.js:157:137)

hoary fossil
#

This error is connected to the query breaking, I can't copy and paste the query itself since it will break the site if I try clicking the textbox

SyntaxError: Unexpected token (1:7) (at acorn.mjs:3554:13)
at j.<anonymous> (acorn.mjs:3554:13)
at j.unexpected (acorn.mjs:762:8)
at j.semicolon (acorn.mjs:739:66)
at j.parseExpressionStatement (acorn.mjs:1228:8)
at j.parseStatement (acorn.mjs:955:24)
at j.parseTopLevel (acorn.mjs:819:21)
at j.parse (acorn.mjs:591:15)
at Function.parse (acorn.mjs:641:35)
at Ye (acorn.mjs:5943:17)
at e.value (index.ts:26:27)

hoary fossil
#

If you need additional info let me know so I can ask our sysadmin. But currently we are not able to add new queries to this app

hoary fossil
#

I looked at the backend logs. They stop at going to create recource. But no error logs. There are also in other apps errors that certain js objects already exist while they do not.

I would appreciate it if someone could look with me, or offer a solution as the current situation is stopping us from developing

hoary fossil
#

Fix for me was exporting and importing the app.