Hi Noel, I've always used http://h2-database.66688.n3.nabble.com/ to post to the newsgroup before: from that interface my messages appeared to be ok. I simply was not aware that there were this kind of issues. From now on I'm going to write directly from google groups.
About the *CONTAINS_UNCOMMITTED* column, it's value is always false. About the *MAX_LOG_SIZE* parameter, removing it from the JDBC URL, hence using the default value of 16MB I obtain in the trace file the message *pageStore: Transaction log could not be truncated; size: 16 MB* . The strange thing is that - even debugging - I'm sure I commit every 10 records, and with the real world data this issue always arises at row 332991 of the 65th table, when the db file size is ~68MB. The error message appears only one time, only at the 1st import. About the standalone test case I posted, it is so long cause I had to introduce a proxy for the connection in order to reproduce the issue. I can try to simplify it, but I can assure you this issue costs too much time even to me. Davide On Wednesday, August 21, 2013 9:36:14 AM UTC+2, Noel Grandin wrote: > > > On 2013-08-21 07:56, Thomas Mueller wrote: > > Hi, > > I suspect if you read mailing list messages from a mobile device you miss >> preformatted contents... I posted the head and tail of the .sql file in my >> previous post > > > Well, I think you didn't post the content of the transaction log (not > before, and not now). > > Davide seems to be using some other interface (other then google > groups or straight email) to post to this newsgroup, so quite often his > posts are incomplete. > > Also, I have modified the SESSIONS metadata table - I replaced the > UNDO_LOG_SIZE column with a "CONTAINS_UNCOMMITTED" column, which should be > more reliable as an indicator of uncommitted transactions. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
