|
From: Colin B. <co...@ba...> - 2006-11-23 21:46:24
|
Redirected back to the list. Davyd, Is this a database with a large number of tables? ----- Forwarded message from Davyd McColl ----- The log file is quite large -- I don't want to put it all up on the mailing list unless I'm sure that I won't bother someone with the size! I'm not a java programmer, so I'm not sure -- but the error seems to keep on cycling, hence why the local machine locks up. The first time this happened, a log file 850mb in size was created. If I just cut a section from where it seems to me to start a cycle and start repeating again, we have: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544726. Error reading data from the connection. null Reason: Error reading data from the connection. null at org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordinator.ensureTransaction(InternalTransactionCoordinator.java:224) at org.firebirdsql.jdbc.InternalTransactionCoordinator.ensureTransaction(InternalTransactionCoordinator.java:74) at org.firebirdsql.jdbc.InternalTransactionCoordinator$MetaDataTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:489) at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:220) at org.firebirdsql.jdbc.AbstractPreparedStatement.executeMetaDataQuery(AbstractPreparedStatement.java:668) at org.firebirdsql.jdbc.FBDatabaseMetaData.doQuery(FBDatabaseMetaData.java:5622) at org.firebirdsql.jdbc.FBDatabaseMetaData.getColumns(FBDatabaseMetaData.java:2557) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1850) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1905) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.accessDbToLoadColumns(SchemaInfo.java:1146) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadColumns(SchemaInfo.java:1124) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTableExt(SchemaInfo.java:637) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTable(SchemaInfo.java:619) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTable(SchemaInfo.java:613) at net.sourceforge.squirrel_sql.client.session.parser.SQLSchemaImpl.getTable(SQLSchemaImpl.java:35) at net.sourceforge.squirrel_sql.client.session.parser.kernel.completions.SQLStatement.getTable(SQLStatement.java:114) at net.sourceforge.squirrel_sql.client.session.parser.kernel.completions.SQLStatement.getTable(SQLStatement.java:114) at net.sourceforge.squirrel_sql.client.session.parser.kernel.completions.SQLSelectStatement.setTable(SQLSelectStatement.java:131) at net.sourceforge.squirrel_sql.client.session.parser.kernel.completions.SQLStatement.setTable(SQLStatement.java:96) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.QualifiedTable(Parser.java:1332) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.FromTableList(Parser.java:1339) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.FromClause(Parser.java:1422) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.SimpleSelect(Parser.java:1603) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.SelectStmt(Parser.java:1792) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.SQLStatement(Parser.java:1808) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.squirrelSQL(Parser.java:1858) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.parse(Parser.java:1876) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.runParser(ParserThread.java:429) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:346) at org.firebirdsql.gds.GDSException: Error reading data from the connection. null at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2070) at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscStartTransaction(AbstractJavaGDSImpl.java:698) at org.firebirdsql.jca.FBManagedConnection.findIscTrHandle(FBManagedConnection.java:1076) at org.firebirdsql.jca.FBManagedConnection.internalStart(FBManagedConnection.java:995) at org.firebirdsql.jca.FBLocalTransaction.internalBegin(FBLocalTransaction.java:140) at org.firebirdsql.jca.FBLocalTransaction.begin(FBLocalTransaction.java:112) at org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordinator.ensureTransaction(InternalTransactionCoordinator.java:222) at org.firebirdsql.jdbc.InternalTransactionCoordinator.ensureTransaction(InternalTransactionCoordinator.java:74) at org.firebirdsql.jdbc.InternalTransactionCoordinator$MetaDataTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:489) at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:220) at org.firebirdsql.jdbc.AbstractPreparedStatement.executeMetaDataQuery(AbstractPreparedStatement.java:668) at org.firebirdsql.jdbc.FBDatabaseMetaData.doQuery(FBDatabaseMetaData.java:5622) at org.firebirdsql.jdbc.FBDatabaseMetaData.getColumns(FBDatabaseMetaData.java:2557) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1850) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1905) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.accessDbToLoadColumns(SchemaInfo.java:1146) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadColumns(SchemaInfo.java:1124) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTableExt(SchemaInfo.java:637) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTable(SchemaInfo.java:619) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTable(SchemaInfo.java:613) at net.sourceforge.squirrel_sql.client.session.parser.SQLSchemaImpl.getTable(SQLSchemaImpl.java:35) at net.sourceforge.squirrel_sql.client.session.parser.kernel.completions.SQLStatement.getTable(SQLStatement.java:114) at net.sourceforge.squirrel_sql.client.session.parser.kernel.completions.SQLStatement.getTable(SQLStatement.java:114) at net.sourceforge.squirrel_sql.client.session.parser.kernel.completions.SQLSelectStatement.setTable(SQLSelectStatement.java:131) at net.sourceforge.squirrel_sql.client.session.parser.kernel.completions.SQLStatement.setTable(SQLStatement.java:96) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.QualifiedTable(Parser.java:1332) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.FromTableList(Parser.java:1339) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.FromClause(Parser.java:1422) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.SimpleSelect(Parser.java:1603) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.SelectStmt(Parser.java:1792) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.SQLStatement(Parser.java:1808) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.squirrelSQL(Parser.java:1858) at net.sourceforge.squirrel_sql.client.session.parser.kernel.Parser.parse(Parser.java:1876) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.runParser(ParserThread.java:429) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:346) 20271109 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - failed to load table names org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544721. Unable to complete network request to host "". Reason: Unable to complete network request to host "". at org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordinator.ensureTransaction(InternalTransactionCoordinator.java:224) at org.firebirdsql.jdbc.InternalTransactionCoordinator.ensureTransaction(InternalTransactionCoordinator.java:74) at org.firebirdsql.jdbc.InternalTransactionCoordinator$MetaDataTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:489) at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:220) at org.firebirdsql.jdbc.AbstractPreparedStatement.executeMetaDataQuery(AbstractPreparedStatement.java:668) at org.firebirdsql.jdbc.FBDatabaseMetaData.doQuery(FBDatabaseMetaData.java:5622) at org.firebirdsql.jdbc.FBDatabaseMetaData.getColumns(FBDatabaseMetaData.java:2557) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1850) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1905) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.accessDbToLoadColumns(SchemaInfo.java:1146) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadColumns(SchemaInfo.java:1124) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTableExt(SchemaInfo.java:637) at net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.matchTable(SQLSyntax.java:963) at net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.findMatchingTokenID(SQLSyntax.java:876) at net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.parseToken(SQLSyntax.java:341) at org.netbeans.editor.Syntax.nextToken(Syntax.java:173) at org.netbeans.editor.DrawEngine.draw(DrawEngine.java:1089) at org.netbeans.editor.DrawEngineLineView.paint(DrawEngineLineView.java:227) at org.netbeans.lib.editor.view.GapBoxViewChildren.paintChildren(GapBoxViewChildren.java:777) at org.netbeans.lib.editor.view.GapBoxView.paint(GapBoxView.java:1457) at org.netbeans.lib.editor.view.GapDocumentView.paint(GapDocumentView.java:225) at org.netbeans.editor.DrawEngineDocView.paint(DrawEngineDocView.java:300) at org.netbeans.editor.view.spi.LockView.paint(LockView.java:357) at javax.swing.plaf.basic.BasicTextUI$RootView.paint(Unknown Source) at javax.swing.plaf.basic.BasicTextUI.paintSafely(Unknown Source) at javax.swing.plaf.basic.BasicTextUI.paint(Unknown Source) at javax.swing.plaf.basic.BasicTextUI.update(Unknown Source) at javax.swing.JComponent.paintComponent(Unknown Source) at javax.swing.JComponent.paint(Unknown Source) at javax.swing.JComponent.paintWithOffscreenBuffer(Unknown Source) at javax.swing.JComponent.paintDoubleBuffered(Unknown Source) at javax.swing.JComponent._paintImmediately(Unknown Source) at javax.swing.JComponent.paintImmediately(Unknown Source) at javax.swing.RepaintManager.paintDirtyRegions(Unknown Source) at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(Unknown Source) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:168) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) at org.firebirdsql.gds.GDSException: Unable to complete network request to host "". at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscStartTransaction(AbstractJavaGDSImpl.java:700) at org.firebirdsql.jca.FBManagedConnection.findIscTrHandle(FBManagedConnection.java:1076) at org.firebirdsql.jca.FBManagedConnection.internalStart(FBManagedConnection.java:995) at org.firebirdsql.jca.FBLocalTransaction.internalBegin(FBLocalTransaction.java:140) at org.firebirdsql.jca.FBLocalTransaction.begin(FBLocalTransaction.java:112) at org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordinator.ensureTransaction(InternalTransactionCoordinator.java:222) at org.firebirdsql.jdbc.InternalTransactionCoordinator.ensureTransaction(InternalTransactionCoordinator.java:74) at org.firebirdsql.jdbc.InternalTransactionCoordinator$MetaDataTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:489) at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:220) at org.firebirdsql.jdbc.AbstractPreparedStatement.executeMetaDataQuery(AbstractPreparedStatement.java:668) at org.firebirdsql.jdbc.FBDatabaseMetaData.doQuery(FBDatabaseMetaData.java:5622) at org.firebirdsql.jdbc.FBDatabaseMetaData.getColumns(FBDatabaseMetaData.java:2557) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1850) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1905) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.accessDbToLoadColumns(SchemaInfo.java:1146) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadColumns(SchemaInfo.java:1124) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTableExt(SchemaInfo.java:637) at net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.matchTable(SQLSyntax.java:963) at net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.findMatchingTokenID(SQLSyntax.java:876) at net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.parseToken(SQLSyntax.java:341) at org.netbeans.editor.Syntax.nextToken(Syntax.java:173) at org.netbeans.editor.DrawEngine.draw(DrawEngine.java:1089) at org.netbeans.editor.DrawEngineLineView.paint(DrawEngineLineView.java:227) at org.netbeans.lib.editor.view.GapBoxViewChildren.paintChildren(GapBoxViewChildren.java:777) at org.netbeans.lib.editor.view.GapBoxView.paint(GapBoxView.java:1457) at org.netbeans.lib.editor.view.GapDocumentView.paint(GapDocumentView.java:225) at org.netbeans.editor.DrawEngineDocView.paint(DrawEngineDocView.java:300) at org.netbeans.editor.view.spi.LockView.paint(LockView.java:357) at javax.swing.plaf.basic.BasicTextUI$RootView.paint(Unknown Source) at javax.swing.plaf.basic.BasicTextUI.paintSafely(Unknown Source) at javax.swing.plaf.basic.BasicTextUI.paint(Unknown Source) at javax.swing.plaf.basic.BasicTextUI.update(Unknown Source) at javax.swing.JComponent.paintComponent(Unknown Source) at javax.swing.JComponent.paint(Unknown Source) at javax.swing.JComponent.paintWithOffscreenBuffer(Unknown Source) at javax.swing.JComponent.paintDoubleBuffered(Unknown Source) at javax.swing.JComponent._paintImmediately(Unknown Source) at javax.swing.JComponent.paintImmediately(Unknown Source) Sorry for the huge output! I understand that the jdbc driver is throwing the initial error, and that's correct -- something catastrophic occurred, and, as far as the driver is concerned, this is a Bad Thing. The problem seems to be that the exception isn't handled, or the failing function is called over and over again, resulting in an endless cycle. Please let me know if there is any other information that I can provide. ----- End forwarded message ----- -- Colin Bell |
