View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0002628SymmetricDSBugpublic2016-06-03 18:522019-04-23 12:20
Reporterramyaa_c_k Assigned To 
Priorityhigh 
Status newResolutionopen 
Product Version3.7.33 
Summary0002628: SymAdmin uninstall command hangs forever, if the engine h2 database just went down
DescriptionInvoking 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
Tagsdialect: h2, install

Activities

ramyaa_c_k

2016-06-03 18:58

reporter   ~0000796

This happens even when custom datasource is used by setting property "db.spring.bean.name"

elong

2016-06-03 19:02

developer   ~0000797

Are you running H2 as a separate process? What is your db.url? Can you provide a couple steps?

ramyaa_c_k

2016-06-06 05:24

reporter   ~0000800

Last edited: 2016-06-06 05:26

View 4 revisions

 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

Issue History

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