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.