Hi,
I have the following problem:
Whenever I make a connection to Sequoia, it is automatically closed
after about 10 seconds. I get
WARN virtualdatabase.VirtualDatabaseWorkerThread.vDB Client
(login:xyz,host:abc.de closed connection with server)
I tried the access with SQuirrel and others, always getting the same
error. Until the time of the error I can connect and look at tables.
It is not a real timeout as it also occurs if I constantly work on
the connection.
I am using
sequoia-2.10.9
postgresql-8.2.5 with appropiate jdbc-driver
The important part of my configuration:
<DatabaseBackend name="xyzNode1" driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/xyz_beta_1_db1" con
nectionTestStatement="select now()">
<DatabaseSchema dynamicPrecision="table"/>
<!-- which virtual user uses which real user -->
<ConnectionManager vLogin="xyz" rLogin="xyz" rPassword="xyz">
<!--<SimpleConnectionManager/>-->
<VariablePoolConnectionManager initPoolSize="10"
minPoolSize="5" maxPoolSize="50" idleTimeout="0" waitTimeout="0"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="xyzNode2" driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/xyz_beta_1_db2" con
nectionTestStatement="select now()">
<DatabaseSchema dynamicPrecision="table"/>
<ConnectionManager vLogin="xyz" rLogin="xyz" rPassword="xyz">
<!--<SimpleConnectionManager/>-->
<VariablePoolConnectionManager initPoolSize="10"
minPoolSize="5" maxPoolSize="50" idleTimeout="0" waitTimeout="0"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache granularity="table" />
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/xyz_beta_1" login="xyz" passw
ord="xyz">
<RecoveryLogTable tableName="recovery" logIdColumnType="BIGINT
NOT NULL"
vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR
NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="checkpoint"
checkpointNameColumnType="VARCHAR NOT NULL"/>
<BackendTable tableName="backend"
databaseNameColumnType="VARCHAR NOT NULL"
backendNameColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL"/>
<DumpTable tableName="dump" dumpNameColumnType="VARCHAR NOT
NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="VARCHAR NOT NULL"
dumpFormatColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL"
backendNameColumnType="VARCHAR NOT NULL"
tablesColumnType="VARCHAR NOT NULL"/>
</RecoveryLog>
This is what the application log says:
Can't open Table window
Connection lost while executing getTables and automatic reconnect
failed
jdbcnav.util.NavigatorException
at
jdbcnav.JDBCDatabase$JDBCTable.updateDetails(JDBCDatabase.java:1499)
at jdbcnav.JDBCDatabase$JDBCTable.<init>(JDBCDatabase.java:1402)
at jdbcnav.JDBCDatabase.newJDBCTable(JDBCDatabase.java:1013)
at jdbcnav.JDBCDatabase.loadTable(JDBCDatabase.java:635)
at jdbcnav.BasicDatabase$MyNode.getTable(BasicDatabase.java:912)
at jdbcnav.BasicDatabase.edit(BasicDatabase.java:114)
at jdbcnav.BasicDatabase.executeCommand(BasicDatabase.java:74)
at jdbcnav.BrowserFrame$4.mousePressed(BrowserFrame.java:135)
at
java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:222)
at java.awt.Component.processMouseEvent(Component.java:5498)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5266)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3968)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3889)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1778)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Connection lost while executing getTables and automatic reconnect
failed
at
org.continuent.sequoia.driver.Connection.getTables(Connection.java:4300)
at
org.continuent.sequoia.driver.DatabaseMetaData.getTables(DatabaseMetaData.java:690)
at
jdbcnav.JDBCDatabase$JDBCTable.updateDetails(JDBCDatabase.java:1485)
at jdbcnav.JDBCDatabase$JDBCTable.<init>(JDBCDatabase.java:1402)
at jdbcnav.JDBCDatabase.newJDBCTable(JDBCDatabase.java:1013)
at jdbcnav.JDBCDatabase.loadTable(JDBCDatabase.java:635)
at jdbcnav.BasicDatabase$MyNode.getTable(BasicDatabase.java:912)
at jdbcnav.BasicDatabase.edit(BasicDatabase.java:114)
at jdbcnav.BasicDatabase.executeCommand(BasicDatabase.java:74)
at jdbcnav.BrowserFrame$4.mousePressed(BrowserFrame.java:135)
at
java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:222)
at java.awt.Component.processMouseEvent(Component.java:5498)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5266)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3968)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3889)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1778)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Caused by:
org.continuent.sequoia.common.exceptions.driver.VirtualDatabaseUnavailableException:
Virtual database vDBviif not found on any of the controllers
at
org.continuent.sequoia.driver.Driver.getConnectionToNewController(Driver.java:422)
at
org.continuent.sequoia.driver.Connection.reconnect(Connection.java:2599)
at
org.continuent.sequoia.driver.Connection.getTables(Connection.java:4295)
... 29 more
Regards
Joachim
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
