To reproduce:
- Use H2 version 1.3.155:
- Create two separate databases (db1 & db2) on same box with the same
query: "create cached table if not exists DISCOUNT_PLANNED (KEY
varchar(20), NE varchar(20), SO integer, DISCOUNT integer,
HOUR_OF_WEEK integer, LAST_UPDATE timestamp DEFAULT CURRENT_TIMESTAMP,
primary key (KEY, NE, SO, HOUR_OF_WEEK))"
- In db2 create a linked table to db1: "create linked table if not
exists REMOTE_DISCOUNT_PLANNED('org.h2.Driver', 'jdbc:h2:tcp://
localhost:10093/db1', 'sa', '', 'DISCOUNT_PLANNED');
- Kill the Java process (not shutting down cleanly)
- Restart the java process.
- Connection to db1 is OK
- The moment you connect to db2 the H2 TCP server stops responding.
Now cannot connect to db1, db2 or any other database. The H2 shell is
dead, the H2 console is dead.
- The only way to recover is to restart the process that runs the H2
TCP server.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
