|
From: Davyd M. <da...@cl...> - 2006-11-24 08:19:50
|
Sorry about the misdirected mail (: Yes, this database does have a rather large number of tables in it (251 to be as close as I know). How would that affect the situation? Is the object browser trying, and failing, to do something with the table listing? -d Colin Bell wrote: > 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 ----- > > -- Davyd McColl Senior Developer Club Technology Logo |
