Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6290

dblook fails on soft upgraded 10.3 database with ERROR 42X05: Table/View 'SYS.SYSROLES' does not exist.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.10.1.1
    • Fix Version/s: None
    • Component/s: Tools
    • Labels:
      None
    • Issue & fix info:
      Newcomer, Repro attached
    • Bug behavior facts:
      Regression

      Description

      With 10.10 and presumably earlier releases, dblook fails on a soft upgraded 10.3 database with
      ERROR 42X05: Table/View 'SYS.SYSROLES' does not exist.

      To reproduce create a 10.3 database:
      $java org.apache.derby.tools.ij
      ij version 10.3
      ij> connect 'jdbc:derby:tenthreedb;create=true';
      ij> quit;

      Then run dblook with 10.10.
      $java org.apache.derby.tools.dblook -d jdbc:derby:tenthreedb
      – Timestamp: 2013-07-09 07:29:21.195
      – Source database is: tenthreedb
      – Connection URL is: jdbc:derby:tenthreedb
      – appendLogs: false

      – Note: At least one unexpected error/warning message was
      – encountered during DDL generation. See dblook.log
      – to review the message(s).

      The error is in dblook.log
      java.sql.SQLSyntaxErrorException: Table/View 'SYS.SYSROLES' does not exist.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:91)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:327)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:424)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2400)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:85)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:700)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(EmbedStatement.java:156)
      at org.apache.derby.impl.tools.dblook.DB_Roles.doRoles(DB_Roles.java:47)
      at org.apache.derby.tools.dblook.go(dblook.java:549)
      at org.apache.derby.tools.dblook.<init>(dblook.java:142)
      at org.apache.derby.tools.dblook.main(dblook.java:97)
      Caused by: java.sql.SQLException: Table/View 'SYS.SYSROLES' does not exist.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:42)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:125)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:71)
      ... 11 more
      Caused by: ERROR 42X05: Table/View 'SYS.SYSROLES' does not exist.
      at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:278)
      at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(FromBaseTable.java:2652)
      at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(FromBaseTable.java:2264)
      at org.apache.derby.impl.sql.compile.FromList.bindTables(FromList.java:321)
      at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(SelectNode.java:511)
      at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(DMLStatementNode.java:197)
      at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:135)
      at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(CursorNode.java:268)
      at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:400)
      at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:99)
      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:1111)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:691)
      ... 5 more
      – **--> DEBUG: Table/View 'SYS.SYSROLES' does not exist.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              kmarsden Katherine Marsden
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: