Fwd: Re: SQuirrel locks up local host if connection to database is dropped (FB, using JayBird)

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

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV