Hi, all. Tonight I've encountered two (independent) production systems going into failure on an issue that has remarkable resemblance with a resolved H2 database issue from the past:
References: Group: http://groups.google.com/group/h2-database/browse_frm/thread/41c475eb55a299d1 Change log for 1.1.111: "Queries that are ordered by an indexed column returned no rows in certain cases (if all rows were deleted from the table previously, and there is a low number of rows in the table, and when not using other conditions, and when using the default b tree index)." We've indeed also seen this problem in the past with 1.1.108. That's the exact reason for upgrading to 1.1.111. We've not seen the problem anymore for a while until mysteriously seeing it twice in one night, now. Because of Java 1.4 we're currently still at 1.1.111. I also don't see anything in the change log of later versions that is clearly related to this problem. I've verified to be absolutely sure that these machines are running the exact 1.1.111 version. Problem that we're seeing is a table that's reduced to a small number of rows (2 in the example below) on which a certain SELECT query unexpectedly gains no records in result: SELECT count(*) FROM embedded_events; --> count = 2 SELECT * FROM embedded_events ORDER BY ID; --> 'no rows' Workarounds: SELECT * FROM embedded_events ORDER BY ID DESC; --> '2 rows' SELECT * FROM embedded_events ORDER BY ID+0; --> '2 rows' Given these were production systems I had at some point to cut corners and restart stuff. I did make a copy of one of the databases, while it was still running and giving us the faulty results. Not sure if that's of any use (I've placed it on another machine and am not seeing the problem anymore). Can I provide any more information to allow the gurus here to analyze this problem? Regards, Sander. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
