Hi,

yesterday we encounter following error on one of our servers running H2 in 
server mode (h2-1.2.140). H2 is running in cluster mode.

Error was thrown for all queries. There is only one table with ~300 000 
records.

H2 trace:

/*SQL */COMMIT;
01-10 12:18:14 pageStore: Cannot remove records, cache size too small? 
records:149797 memory:181626439
01-10 12:18:14 pageStore: Cannot remove records, cache size too small? 
records:149797 memory:181626419
01-10 12:18:14 pageStore: Cannot remove records, cache size too small? 
records:149797 memory:181626390
01-10 12:18:14 pageStore: Cannot remove records, cache size too small? 
records:149798 memory:181628704
01-10 12:18:14 pageStore: Cannot remove records, cache size too small? 
records:149799 memory:181631018
01-10 12:18:14 pageStore: Cannot remove records, cache size too small? 
records:149800 memory:181633332
01-10 12:18:14 jdbc[3]:
/*SQL #:1 t:111*/INSERT INTO MESSAGEIDROUTINGTABLE (MESSAGEID, SOURCEESME, 
SOURCEPROTOCOL, TIMECREATED) VALUES ('465f398da', 'VIVO_TMMRJO', 'SMPP', 
1357827499701);
01-10 12:18:14 command: slow query: 111
01-10 12:18:14 pageStore: Cannot remove records, cache size too small? 
records:149797 memory:181626468

Exception logged by our application:
Exception:"
java.io.EOFException"_org.h2.jdbc.JdbcSQLException:IOException:"java.io.EOFException"[90028--40]
 
at org.h2.message.DbException getJdbc SQLException(DbException java:327)
at org.h2 message.DbException get(DbException java:156)
at org.h2.message.DbException.convert(DbException java:271)
at org.h2.server.TcpServer.Thread.sendError(TcpServer.Thread java:183)
at org.h2.server.TcpServer.Thread.run(TcpServerThread java:136) 
at java.lang.Thread run(Thread java:662)
Causedby: java.io.EOFException
at java.io.DataInputStream.readInt(DataInputStream java:375)
at org.h2.value.Transfer.readInt(Transfer java:145)
at org.h2.server.TcpServer.Thread.process(TcpServerThread java:216)
at org.h2.server.TcpServer.Thread.run(TcpServerThread java:134)

We tried to raise the CACHE_SIZE parameter using H2shell but it did not 
help. We had to restart H2 after that the problem was fixed.

Thanks for you answer
Matous

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/UePyO3J1QfcJ.
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.

Reply via email to