Are there any debug messages for CHECKPOINT SYNC that indicate the
command was properly obeyed and executed? Or does it merely appear as
a sql command?
h2 version: 1.2.131
truncated connection
string: ;WRITE_DELAY=0;ACCESS_MODE_DATA=rws;TRACE_LEVEL_FILE=3
>From java I executed a sql command with:
Statement stmnt = conn.createStatement();
stmnt.execute("checkpoint sync;");
stmnt.close();
In the trace log I get:
/**/Statement stat2743 = conn20.createStatement();
03-25 09:33:54 jdbc[2]:
/**/stat2743.execute("checkpoint sync;");
03-25 09:33:54 jdbc[2]:
/*SQL */checkpoint sync;
03-25 09:33:54 jdbc[2]:
/**/stat2743.close();
Is that all that will ever appear? It's fine if it is, I'm merely
trying to make sure if the command is being received and executed
properly.
However, when a checkpoint next appears it isn't until much later (33
seconds) and the output is far more verbose:
03-25 09:34:27 pageStore: checkpoint
03-25 09:34:27 pageStore: writeBack page [3] freeList
03-25 09:34:27 pageStore: writeBack page[5] b-tree leaf table:557
entries:1
03-25 09:34:27 pageStore: writeBack page[6] b-tree leaf table:553
entries:3
Executing the command after an update via the web console looks much
the same as when called from java.
Thanks for any thoughts,
--
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.
