From derby-dev-return-80198-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Thu Jul 22 10:01:50 2010 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 12288 invoked from network); 22 Jul 2010 10:01:50 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 22 Jul 2010 10:01:50 -0000 Received: (qmail 68226 invoked by uid 500); 22 Jul 2010 10:01:50 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 67923 invoked by uid 500); 22 Jul 2010 10:01:47 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 67909 invoked by uid 99); 22 Jul 2010 10:01:46 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Jul 2010 10:01:46 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Jul 2010 10:01:43 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o6M9rpkR026059 for ; Thu, 22 Jul 2010 09:53:52 GMT Message-ID: <18099118.514741279792431695.JavaMail.jira@thor> Date: Thu, 22 Jul 2010 05:53:51 -0400 (EDT) From: "Craig Chaney (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Created: (DERBY-4753) "ERROR 42X01: Syntax error: FALSE." during call to java.sql.DatabaseMetaData.getIndexInfo MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org "ERROR 42X01: Syntax error: FALSE." during call to java.sql.DatabaseMetaData.getIndexInfo ----------------------------------------------------------------------------------------- Key: DERBY-4753 URL: https://issues.apache.org/jira/browse/DERBY-4753 Project: Derby Issue Type: Bug Components: JDBC Affects Versions: 10.5.3.0 Environment: Linux Reporter: Craig Chaney We are seeing the failure below occasionally. It does not happen every time ... with the exact same database and call sequence it will happen about 1 out of 3 times. The parameters on the getIndexInfo call are connection.getMetaData().getIndexInfo(null, schemaName, tableName, false, false); schemaName and tableName are valid and definitely not null. Caused by: java.sql.SQLException: Syntax error: FALSE. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.doGetIndexInfo(Unknown Source) at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getIndexInfo(Unknown Source) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.getIndexMetadata(AbstractDbProvider.java:381) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.doesIndexExist(AbstractDbProvider.java:343) ... 61 more Caused by: ERROR 42X01: Syntax error: FALSE. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.checkInternalFeature(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.literal(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.valueSpecification(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.valueExpressionPrimary(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.primary(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.primaryExpressionXX(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.primaryExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.unaryExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.multiplicativeExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.additiveExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.thenElseExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.whenThenExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.valueSpecification(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.valueExpressionPrimary(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.primary(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.primaryExpressionXX(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.primaryExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.unaryExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.multiplicativeExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.additiveExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.valueExpressionPrimary(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.primary(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.primaryExpressionXX(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.primaryExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.unaryExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.multiplicativeExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.additiveExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.derivedColumn(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.selectSublist(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.selectColumnList(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.selectList(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.querySpecification(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.simpleTable(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryPrimary(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryTerm(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.queryExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.preparableSelectStatement(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.preparableSQLDataStatement(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.StatementPart(Unknown Source) at org.apache.derby.impl.sql.compile.SQLParser.Statement(Unknown Source) at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.rePrepare(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 68 more -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.