|
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
|
-------------------------------------------------------------------------
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_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
| 
