Restart Retool Postgresql Database

💬 Queries and Resources
, ,
1

Hi guys. My AWS lamba is using retool postgresql as a database. A query from it produces an error:

Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "XX000", message: "cache lookup failed for type 34472072", severity: "ERROR", detail: None, column: None, hint: None }), transient: false })

From what i understand. A column is still using a non-existing enum. I've checked my tables but i cannot find any columns that are using this non-existing enums. So my question is:

  1. Is the query is cached?
  2. If so, is restarting the postgresql will solve the problem?
  3. If so, how do i do it?
3

Hi @Arie_Pranasakti,

Are you self-hosting Retool?

Is this postgres DB the Retool DB or is it the postgres instance that is set up to manage deployment?

What data is the AWS lambda fetching?

4

Hi @Arie_Pranasakti,

Are you able to share any more details or screenshots with me to help to better troubleshoot this issue?