Details
-
Bug
-
Resolution: Invalid
-
Low
-
None
-
None
-
None
-
None
Description
NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.
postgresql syncronized failed.
there is no bug in "0xdbe-142.2927.6" version.
This is a error message.
`````````````````````````````````````````````````````````````````````````````````````````
ERROR: column reference "oid" is ambiguous
Position: 169
ERROR: column reference "oid" is ambiguous
Position: 169
The SQL statement:
with S as ( select T.oid as type_id, C.oid as class_id
from pg_catalog.pg_type T,
pg_catalog.pg_class C
where T.typnamespace = oid
and T.typnamespace = C.relnamespace
and T.xmin::varchar::bigint > ?
and T.typrelid = C.oid
and T.typtype = 'c'::"char"
and relkind = 'c'::"char" ),
A as ( select attrelid as class_id,
attnum as att_position,
attname as att_name,
pg_catalog.format_type(atttypid,atttypmod) as att_type
from pg_catalog.pg_attribute )
select type_id, att_position, att_name, att_type
from S natural join A
order by type_id::bigint, att_position
at org.jetbrains.jdba.jdbc.BaseExceptionRecognizer.recognizeException(BaseExceptionRecognizer.java:48)
at org.jetbrains.jdba.jdbc.JdbcIntermediateSession.recognizeException(JdbcIntermediateSession.java:347)
at org.jetbrains.jdba.jdbc.JdbcIntermediateSeance.execute(JdbcIntermediateSeance.java:98)
in RemoteSeanceImpl.execute(RemoteSeanceImpl.java:24)
in RemoteUtil.access$100(RemoteUtil.java:36)
in RemoteUtil$RemoteInvocationHandler.invoke(RemoteUtil.java:229)
at com.sun.proxy.$Proxy110.execute(Unknown Source)
at org.jetbrains.jdba.intermediate.AdaptIntermediateSeance.execute(AdaptIntermediateSeance.java:28)
at org.jetbrains.jdba.core.BaseQueryRunner.run(BaseQueryRunner.java:66)
in PostgresIntrospector$SchemaRetriever.f(PostgresIntrospector.java:434)
Caused by: org.jetbrains.jdba.exceptions.StrippedSQLException: org.postgresql.util.PSQLException: ERROR: column reference "oid" is ambiguous
Position: 169
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:413)
at org.jetbrains.jdba.jdbc.JdbcIntermediateSeance.execute(JdbcIntermediateSeance.java:84)
in RemoteSeanceImpl.execute(RemoteSeanceImpl.java:24)
`````````````````````````````````````````````````````````````````````````````````````````
Attachments
Issue Links
- relates to
-
CONFCLOUD-39534 postgresql syncronized failed
- Closed