Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-39534

postgresql syncronized failed

    XMLWordPrintable

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

          Activity

            People

              Unassigned Unassigned
              11a989c282e5 baek kyu baek kyu
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: