View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0002628 | SymmetricDS | Bug | public | 2016-06-03 18:52 | 2019-04-23 12:20 |
Reporter | ramyaa_c_k | Assigned To | |||
Priority | high | ||||
Status | new | Resolution | open | ||
Product Version | 3.7.33 | ||||
Summary | 0002628: SymAdmin uninstall command hangs forever, if the engine h2 database just went down | ||||
Description | Invoking symadmin uninstall commands when the engine h2 database just went down, hangs forever Looks like the symadmin hangs when trying to "testConnection". No timeout is supported while using dbcp basicdatasource to test connection Below is the stack trace. "main" prio=5 tid=1 RUNNABLE at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:170) Local Variable: java.io.FileDescriptor#3 at java.net.SocketInputStream.read(SocketInputStream.java:141) Local Variable: java.net.SocketInputStream#1 at java.io.BufferedInputStream.fill(BufferedInputStream.java:246) Local Variable: byte[]#11939 at java.io.BufferedInputStream.read(BufferedInputStream.java:265) Local Variable: java.io.BufferedInputStream#442 at java.io.DataInputStream.readInt(DataInputStream.java:387) Local Variable: java.io.DataInputStream#4 at org.h2.value.Transfer.readInt(Transfer.java:157) at org.h2.engine.SessionRemote.done(SessionRemote.java:599) at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:119) Local Variable: org.h2.value.Transfer#1 Local Variable: java.lang.String#13005 Local Variable: java.net.Socket#1 Local Variable: java.lang.String[]#337 at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:430) Local Variable: java.lang.String#13091 Local Variable: java.lang.String[]#331 Local Variable: java.lang.String#13004 Local Variable: java.lang.String#13006 at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:311) Local Variable: org.h2.engine.SessionRemote#1 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:107) Local Variable: org.h2.engine.ConnectionInfo#1 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:91) Local Variable: org.h2.jdbc.JdbcConnection#1 at org.h2.Driver.connect(Driver.java:74) Local Variable: java.util.Properties#99 Local Variable: org.h2.Driver#1 Local Variable: java.lang.String#18250 at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.jumpmind.db.util.ResettableBasicDataSource.createPoolableConnectionFactory(ResettableBasicDataSource.java:74) Local Variable: org.apache.commons.dbcp.PoolableConnectionFactory#1 at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) Local Variable: org.apache.commons.dbcp.DriverConnectionFactory#1 at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.jumpmind.symmetric.AbstractCommandLauncher.testConnection(AbstractCommandLauncher.java:395) Local Variable: org.jumpmind.db.util.ResettableBasicDataSource#1 at org.jumpmind.symmetric.AbstractCommandLauncher.getSymmetricEngine(AbstractCommandLauncher.java:383) at org.jumpmind.symmetric.AbstractCommandLauncher.getSymmetricEngine(AbstractCommandLauncher.java:377) at org.jumpmind.symmetric.SymmetricAdmin.uninstall(SymmetricAdmin.java:480) at org.jumpmind.symmetric.SymmetricAdmin.executeWithOptions(SymmetricAdmin.java:304) Local Variable: java.lang.String#18061 Local Variable: java.util.LinkedList#4 at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:190) Local Variable: org.apache.commons.cli.CommandLine#1 Local Variable: org.jumpmind.symmetric.SymmetricAdmin#1 Local Variable: org.apache.commons.cli.PosixParser#1 Local Variable: org.apache.commons.cli.Options#1 at org.jumpmind.symmetric.SymmetricAdmin.main(SymmetricAdmin.java:129) Local Variable: java.lang.String[]0000630 | ||||
Tags | dialect: h2, install | ||||
|
This happens even when custom datasource is used by setting property "db.spring.bean.name" |
|
Are you running H2 as a separate process? What is your db.url? Can you provide a couple steps? |
|
Yes. We run h2 as a seperate process on a remote machine. Our sym service and h2 are on different systems. This is the url we use db.url=jdbc:h2:tcp://<database-ip>:<port>/<database-file>;MAX_QUERY_TIMEOUT=60000 |
Date Modified | Username | Field | Change |
---|---|---|---|
2016-06-03 18:52 | ramyaa_c_k | New Issue | |
2016-06-03 18:56 | ramyaa_c_k | Tag Attached: block | |
2016-06-03 18:56 | ramyaa_c_k | Tag Attached: freeze | |
2016-06-03 18:56 | ramyaa_c_k | Tag Attached: freezing | |
2016-06-03 18:56 | ramyaa_c_k | Tag Attached: hang | |
2016-06-03 18:56 | ramyaa_c_k | Tag Detached: block | |
2016-06-03 18:57 | ramyaa_c_k | Tag Attached: block | |
2016-06-03 18:58 | ramyaa_c_k | Note Added: 0000796 | |
2016-06-03 19:02 | elong | Note Added: 0000797 | |
2016-06-06 05:24 | ramyaa_c_k | Note Added: 0000800 | |
2016-06-06 05:25 | ramyaa_c_k | Note Edited: 0000800 | View Revisions |
2016-06-06 05:25 | ramyaa_c_k | Note Edited: 0000800 | View Revisions |
2016-06-06 05:26 | ramyaa_c_k | Note Edited: 0000800 | View Revisions |
2019-04-12 12:44 | admin | Tag Detached: freeze | |
2019-04-12 12:44 | admin | Tag Detached: freezing | |
2019-04-12 12:44 | admin | Tag Detached: hang | |
2019-04-12 12:47 | admin | Tag Detached: block | |
2019-04-23 12:20 | elong | Tag Attached: install | |
2019-04-23 12:20 | elong | Tag Attached: h2 | |
2019-04-23 20:48 | admin | Tag Renamed | h2 => dialect: h2 |