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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.10.1.1
• Component/s: Tools
• Issue & fix info: Newcomer, Repro attached
• Bug behavior facts: Regression
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 09/Jul/13 14:35
• Updated: 09/Jul/13 14:35

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.