Hi Thomas, 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, but reading it from gmail with my smartphone the relevant portion is missing.
I re-paste it here without pre tags /CREATE ALIAS IF NOT EXISTS READ_BLOB FOR "org.h2.tools.Recover.readBlob"; CREATE ALIAS IF NOT EXISTS READ_CLOB FOR "org.h2.tools.Recover.readClob"; CREATE ALIAS IF NOT EXISTS READ_BLOB_DB FOR "org.h2.tools.Recover.readBlobDb"; CREATE ALIAS IF NOT EXISTS READ_CLOB_DB FOR "org.h2.tools.Recover.readClobDb"; -- pageSize: 2048 writeVersion: 3 readVersion: 3 -- head 1: writeCounter: 1211977 log 2413:0/0 crc 662344123 (ok) -- head 2: writeCounter: 1211977 log 2413:0/0 crc 662344123 (ok) -- log 2413:0/0 -- page 3: free list -- 3 1111111 1111111111 - 1111111111 1111111111 - 1111111111 1111111111 - 1111111111 1111111111 - 1111111111 1111111111 ... ... contents omitted ... ---- Transaction log ---- ---- Statistics ---- -- page count: 319162, free: 88377 -- page data bytes: head 13245977, empty 102539677, rows 154789962 (63% full) -- free 20%, 64423 page(s) -- data leaf 41%, 132117 page(s) -- data node 0%, 941 page(s) -- data overflow 0%, 314 page(s) -- btree leaf 0%, 1673 page(s) -- btree node 0%, 21 page(s) -- free list 0%, 20 page(s) -- stream trunk 0%, 438 page(s) -- stream data 37%, 119212 page(s) / Please giv eme a hint on what I should search for (the entire .sql file weights some hundreds of MB and moreover could contain privacy-sensitive data). Thomas Mueller-6 wrote > Hi, > >> Running the Recover tool with the "-transactionLog" option gave me no > evidences. > > Well, what did you look at? Could you upload the .sql file, or at least > the > interesting part (the summary and the transaction log)? Obviously of a > case > where the database has grown very large. > > Regards, > Thomas > > > > On Tue, Aug 20, 2013 at 1:03 PM, davide.cavestro > < > davide.cavestro@ > >wrote: > >> I agree with you. >> >> Running the Recover tool with the "-transactionLog" option gave me no >> evidences. Is there some particular section of the sql file I should >> examine? >> >> Follows an excerpt from the recover output when ran on a database that >> had >> no problems on the 2nd import (no errors on the trace file and db size >> almost unchanged) but had problems on the 3rd one (namely errors on the >> trace file and db size increased). >> >> >> >> So, if the errors on the trace file and the db size increase/uncommitted >> transactions are related, is there something I could do to detect the >> cause >> (even debugging)? >> >> >> Thomas Mueller-6 wrote >> > Hi, >> > >> > Please note it's not the *size* of an uncommitted transaction that is a >> > problem. The problem is, once you have an uncommitted transaction >> (which >> > could mean there is only one row changed in the uncommitted >> transaction), >> > then the transaction log is not truncated starting from that point on. >> So >> > the *starting* time of the uncommitted transaction is the problem. >> > >> > To get more details about transactions, you could run the Recover tool >> > with >> > the "-transactionLog" option. This option is not yet documented, >> because >> I >> > thought it is not useful in general. But I will document it now. >> >> >> >> >> >> -- >> View this message in context: >> http://h2-database.66688.n3.nabble.com/h2-Continuous-Increase-in-H2-db-size-after-dropping-and-loading-same-data-repeatedly-tp4026836p4027193.html >> Sent from the H2 Database mailing list archive at Nabble.com. >> >> -- >> 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 > h2-database+unsubscribe@ > . >> To post to this group, send email to > h2-database@ > . >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- > 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 > h2-database+unsubscribe@ > . > To post to this group, send email to > h2-database@ > . > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. -- View this message in context: http://h2-database.66688.n3.nabble.com/h2-Continuous-Increase-in-H2-db-size-after-dropping-and-loading-same-data-repeatedly-tp4026836p4027200.html Sent from the H2 Database mailing list archive at Nabble.com. -- 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.
