Re: [h2] What would be the best update-candidate

2015-01-09 Thread Noel Grandin
what does your database URL look like? -- 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+unsubscr...@googlegroups.com. To post to this group, send email

[h2] What would be the best update-candidate

2015-01-09 Thread Rinse Lemstra
Hello, We are currently using version h2-1.3.176 In AUTO_SERVER mode we experiece corruption of various kinds: index not found 202 File corrupted while reading record: \[1280] stream data key:1344 pos:11 remaining:0\. rowCount expected 11462 got 11466 What would be the best / most

Re: [h2] What would be the best update-candidate

2015-01-09 Thread Noel Grandin
OK, that's good, there is nothing problematic in your settings. Probably the best update-candidate is 1.4.184, but add MV_STORE=false to your URL to keep using the old(stable) storage engine. On 2015-01-09 10:23 AM, Rinse Lemstra wrote: Connecting to H2 database:

Re: [h2] 1.4.182 corruption

2015-01-09 Thread Dieter Cailliau
he means 1.4.183 Op donderdag 8 januari 2015 23:52:40 UTC+1 schreef marcolopes: 1.3.183 ?? On Thursday, December 18, 2014 at 9:07:16 PM UTC, Thomas Mueller wrote: Hi, Yes, this looks like the bug that was fixed in version 1.3.183. I'm afraid this database is not recoverable. Regards,

Re: [h2] What would be the best update-candidate

2015-01-09 Thread Rinse Lemstra
Connecting to H2 database: jdbc:h2:file:c:\TimeWriter5Std\lib\..\data\xso_standard\default\Data.std.h2.db H2 properties: {AUTO_SERVER=TRUE, MODE=REGULAR, CACHE_SIZE=16384, DB_CLOSE_DELAY=0, IGNORECASE=TRUE, DATABASE_TO_UPPER=TRUE} Does this make sense ? regards, Rinse -- You received

Re: [h2] What would be the best update-candidate

2015-01-09 Thread Rinse Lemstra
Thanks for your advice. One final question: 1.3.176 is the last version with the 'Beta' addition. Am I right that this 'Beta' addition applies particulary on the MVstore code ? regards, Rinse Op vrijdag 9 januari 2015 09:36:20 UTC+1 schreef Noel Grandin: OK, that's good, there is nothing

[h2] Should SHUTDOWN DEFRAG reduce the DB File size when all tables are empty?

2015-01-09 Thread Kenton Garner
URL: jdbc:h2:../data/audit;COMPRESS=TRUE;AUTOCOMMIT=FALSE;TRACE_LEVEL_FILE=4;lock_timeout=6;MVCC=FALSE;DB_CLOSE_ON_EXIT=TRUE;MV_STORE=TRUE;AUTO_SERVER=TRUE;AUTO_SERVER_PORT=7899 Version 1.4.184 - svn revision 6003 I know you must be tired of questions regarding db file size. I am just