dari icon indicating copy to clipboard operation
dari copied to clipboard

h2 database: Statement was canceled or the session timed

Open Typografikon opened this issue 7 years ago • 2 comments

Hi to all, on place where I usually see Revisions while editing some record I found today following exception:

Statement was canceled or the session timed out; SQL statement: SELECT r.id, r.typeId, r.data, i1.value FROM Record r LEFT OUTER JOIN RecordString4 i0 ON i0.id = r.id AND i0.typeId = r.typeId AND i0.symbolId IN (-1) INNER JOIN RecordString4 i1 ON i1.id = r.id AND i1.typeId = r.typeId AND i1.symbolId IN (11) WHERE 1 = 1 AND r.typeId IN ('0000015b-de47-d385-a7fb-fee7eef40001') AND ((i0.value IS NULL) AND (i1.symbolId = 11 AND i1.value IS NOT NULL AND i1.value LIKE X'30303030303135622d646163382d643235362d613335622d66626639326131393030303025')) ORDER BY i1.value DESC LIMIT 11 OFFSET 0 [57014-193] (org.h2.jdbc.JdbcSQLException)

Stacktrace

org.h2.engine.SessionRemote.done(SessionRemote.java:624) org.h2.command.CommandRemote.executeQuery(CommandRemote.java:158) org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:79) org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:210) ...

When I try to run this command in database it tooks about 3 sec and returns no result (empty result set). I see that default Dari timetout is 3.0. How can I changes this setting? I try to set in

CMS Settings > Debug > Dari Settings > Key: readTimeout and Value: 30

but still got timeout about 3 sec. Any suggestions? I just want to get rid of this timeout error in CMS ui.

With best regards, O.

Typografikon avatar May 19 '17 19:05 Typografikon