Re: Urgent Support Need - Mailing list pgsql-bugs

From Sunil Choudhary
Subject Re: Urgent Support Need
Date
Msg-id CAK2VHVLDwfQC=JEZjYWaWbD2t6YwPa6biVLsthRoTmpe+P2Hpw@mail.gmail.com
Whole thread Raw
In response to Re: Urgent Support Need  (Dave Cramer <davecramer@postgres.rocks>)
List pgsql-bugs

is this issue coming with query only? nothing in the logs apart from this logs.


2021-08-20 11:15:58.446 EAT [119681] db=**,user=**,app=PostgreSQL JDBC Driver,client=***(54498) ERROR:  relation "templates" does not exist at character 149
2021-08-20 11:15:58.446 EAT [119681] db=**,user=**,app=PostgreSQL JDBC Driver,client=***(54498) STATEMENT:  select templateen0_.id as id1_3_, templateen0_.is_active as is_activ2_3_, templateen0_.name as name3_3_, templateen0_.template as template4_3_ from templates templateen0_ where templateen0_.name=$1

On Fri, Aug 20, 2021 at 7:59 PM Dave Cramer <davecramer@postgres.rocks> wrote:


On Fri, 20 Aug 2021 at 09:56, Sunil Choudhary <choudhary.sunil0415@gmail.com> wrote:
Hi Team,

can you please support to identify the rca for below exception.

... 84 common frames omitted Caused by: org.postgresql.util.PSQLException: ERROR: relation "templates" does not exist Position: 149 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:150) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:113) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) 
... 115 common frames omitted  

In order to figure out what went wrong we would need to see the query that caused this problem. 

Dave

pgsql-bugs by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Urgent Support Need
Next
From: Dave Cramer
Date:
Subject: Re: Urgent Support Need