Hi, FYI this problem is fixed since version 1.4.188. The problem was that if writes were re-ordered, and a power failure occurred, truncate was sometimes done before a previous write.
Regards, Thomas On Tuesday, May 5, 2015, Osvaldas Ziukas <[email protected]> wrote: > > > 2015 m. gegužė 5 d., antradienis 08:45:59 UTC+3, Thomas Mueller rašė: >> >> Hi, >> >> That's strange. The last part of the file is missing. >> >> Looking at the H2 source code, the file truncate code is very simple and >> conservative (MVStore.shrinkFileIfPossible, which is calling >> getFileLengthInUse). It looks unlikely that there is a bug in this area. >> >> Could you describe what you did to get into this state? One possible way >> to get into this situation is to copy the database file while it is in use, >> without using the online backup command. Or truncate the file in some other >> way. Other than that, I wouldn't know a way. Do you have a reproducible >> test case? >> >> Regards >> Thomas >> >> On Thursday, April 30, 2015, Osvaldas Ziukas <[email protected]> >> wrote: >> >>> Hello here is db file >>>> >>>> -- >>> 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/d/optout. >>> >> > Sadly no, we use H2 database in our aplications and this issue happens > sometimes, first appearance noticed after half an year of work. As far as i > know no one copy modify of effect db and it happens during h2 use. Only > effects who can reduce size of db are old records delete by id, nothing > else. > > -- > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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/d/optout.
