Hi SkiBunny, After Thomas's comment I thought I'd trawl the code and see if I can learn a bit more.
The "give-away" to me is when you said that 1. The sequences now have "weird" names like SYSTEM_SEQUENCE_6E91F1ED_C242_48BE_887E_4465FA83FAC6 2. That sequences usually have names like SYSTEM_SEQUENCE_1 >From what I can tell from the code, names like SYSTEM_SEQUENCE_1 haven't been used since early March 2007, so (just to repeat what Thomas said really!) I think you're not "usually" using 1.1.118 at all -- it's 1.1.118 that's generating the "weird" names. Also, the fact that you said your system is 3 years old also suggests that you're actually running a pre-March 2007 version of H2. http://code.google.com/p/h2database/source/diff?path=/trunk/h2/src/main/org/h2/table/Column.java&format=side&r=103 (Scroll down to line 226) Cheers Kerry On Wed, Feb 17, 2010 at 9:20 AM, SkiBunny <[email protected]>wrote: > Just wondering if anyone else out there has had some or all of their > metadata suddenly go missing between runs of their front-end program? It's > an intermittent problem, so actually getting real, reliable information > about it is not proving easy, but I have seen one case where: > - three of the tables were missing > - all of the AUTO-INCREMENT sequences had been reset to 1 and had weird > names ilke SYSTEM_SEQUENCE_6E91F1ED_C242_48BE_887E_4465FA83FAC6 (usually > they are SYSTEM_SEQUENCE_1, etc) > > I'm using 1.1.118, by the way. And yes, I know it's an old version now, > and yes, I have considered upgrading to 1.2.x, but at the moment with this > mysterious problem I'm not willing to take on the extra risk of file format > changes. > > This problem is really scary. The overall system (front-end plus h2) has > been in use and further development for 3 years, and we had never seen this > problem up until the past two weeks. It's intermittent, so we never know > when it's going to strike next. I would be very grateful for any words of > wisdom on this one. > > -- > 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]<h2-database%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- 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.
