Re: [h2] Asc order problem in a Date Data type Column using Pluggable / User-Defined Table

2016-12-21 Thread Noel Grandin
I just pushed an updated unit test to GitHub. Sorry, I can see anything obviously wrong with your code. -- 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-databa

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Anatolii K
Test attached On Wednesday, December 21, 2016 at 8:41:44 PM UTC+5, Thomas Mueller Graf wrote: > > Hi, > > I guess that bug would be on my plate... I recently made changes there > (trying to improve concurrency). I'm sorry about that. Having a test case > would be great! > > Regards, > Thomas >

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Anatolii K
org.h2.jdbc.JdbcSQLException: General error: "java.nio.BufferUnderflowException"; SQL statement: UPDATE account set balance = ? where id = ? [5-193] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Anatolii K
The bug is reproduced only in multi-thread application On Wednesday, December 21, 2016 at 8:41:44 PM UTC+5, Thomas Mueller Graf wrote: > > Hi, > > I guess that bug would be on my plate... I recently made changes there > (trying to improve concurrency). I'm sorry about that. Having a test case >

Re: [h2] Asc order problem in a Date Data type Column using Pluggable / User-Defined Table

2016-12-21 Thread Pedro Almeida
Here it is a very minimal project where the issue can be verified. https://github.com/UlTriX/h2problem I appreciate any help. Thank you Pedro On Wednesday, 21 December 2016 14:49:02 UTC, Noel Grandin wrote: > > I updated our unit tests to test this case, and it seems to be working > fine. >

Re: [h2] Asc order problem in a Date Data type Column using Pluggable / User-Defined Table

2016-12-21 Thread Pedro Almeida
Hi Noel, thank you very much for the quick response I am working in isolating the code and the problem. >From what I gather so far I strongly believe the problem lies in H2 when working with the TableFilter The Cursor I implemented (that is returned by public Cursor find(Session session, Sear

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Thomas Mueller Graf
Hi, I guess that bug would be on my plate... I recently made changes there (trying to improve concurrency). I'm sorry about that. Having a test case would be great! Regards, Thomas On Wed, Dec 21, 2016 at 3:56 PM, Noel Grandin wrote: > Can we get a full stack trace for that failure.​ > > --

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Noel Grandin
Can we get a full stack trace for that failure.​ -- 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,

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Anatolii K
Without split it also failed (url jdbc:h2:nioMemLZF:db): Caused by: java.nio.BufferUnderflowException at java.nio.Buffer.nextGetIndex(Buffer.java:500) On Wednesday, December 21, 2016 at 7:50:31 PM UTC+5, Noel Grandin wrote: > > then let's fix that problem, but I'm not really keen on trying to fi

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Noel Grandin
then let's fix that problem, but I'm not really keen on trying to fix a combination crash like that. -- 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+

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Anatolii K
I have very big in-memory database ~ 1TB. Without split H2 crashes On Wednesday, December 21, 2016 at 7:43:13 PM UTC+5, Noel Grandin wrote: > > I'm sorry, but that's just a silly combination to be using. > > You should only using be "split:" for FAT filesystems, and you should > certainly not

Re: [h2] Asc order problem in a Date Data type Column using Pluggable / User-Defined Table

2016-12-21 Thread Noel Grandin
I updated our unit tests to test this case, and it seems to be working fine. If you are convinced the problem lies in H2, try creating a small standalone test case, and then we could help you debug it. -- You received this message because you are subscribed to the Google Groups "H2 Database" g

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Noel Grandin
I'm sorry, but that's just a silly combination to be using. You should only using be "split:" for FAT filesystems, and you should certainly not be using it in combination with "nioMemLZF:" -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To uns

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Anatolii K
After applying this patch I'm getting following error with nioMemLZF (url= jdbc:h2:split:30:nioMemLZF:db): org.h2.jdbc.JdbcSQLException: General error: "java.nio.BufferUnderflowException"; SQL statement: UPDATE account set balance = ? where id = ? [5-193] at org.h2.message.DbException.getJdb

[h2] Asc order problem in a Date Data type Column using Pluggable / User-Defined Table

2016-12-21 Thread Pedro Almeida
Hello, I am using H2 Version 1.4.193 and I am creating a Pluggable / User-Defined Table with ENGINE "..." Just to sum up it is a Table that gathers data from a REST Endpoint. I have implemented the Table, Index and Cursor everything is working in order and simple queries like SELECT * FROM Ta

Re: [h2] Missing lob entry on concurrent update read of a row

2016-12-21 Thread Noel Grandin
yes, because you are not holding the transaction open while reading the LOB, so the LOB is disappearing while you are reading it. i.e. connection.setAutoCommit(false); read the LOB completely here.. connection.commit(); -- You received this message because you are subscribed to th

Re: [h2] Missing lob entry on concurrent update read of a row

2016-12-21 Thread Mayank Tankhiwale
Hi Noel, The update thread and the read thread each have separate transactions/connections(ThreadLocal) to the database. So while the read thread is open, the update thread comes and updates/writes to the row. (currently the table has single row) and one of the column in CLOB. Our observation

Re: [h2] autoCommitDelay and SET WRITE_DELAY

2016-12-21 Thread pichulines
Hi all, sorry for reopen such an old thread... but this is also happening to me working with last release 1.4.193. The MVStore background thread seems to eat a lot of cpu with no operation being performed. Setting the WRITE_DELAY as a connection parameter does the trick. Thanks for your help.

Re: [h2] autoCommitDelay and SET WRITE_DELAY

2016-12-21 Thread pichulines
Hi all, sorry for reopen such an old thread... but this is also happening to me working with last release 1.4.193. The MVStore background thread seems to eat a lot of cpu with no operation being performed. Setting the WRITE_DELAY as a connection parameter does the trick. Thanks for your help.

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Anatolii K
Thank you for quick help! On Wednesday, December 21, 2016 at 3:55:32 PM UTC+5, Noel Grandin wrote: > > It appears I was wrong about this, we already implement reading/writing > without synchronisation for all of our other > file implementations, I just missed that you are using the "split:" stuf

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

2016-12-21 Thread Noel Grandin
It appears I was wrong about this, we already implement reading/writing without synchronisation for all of our other file implementations, I just missed that you are using the "split:" stuff. I have pushed a fix for this. -- You received this message because you are subscribed to the Google Gro

[h2] Re: The last stable release Version 1.3.176 was published at 2014-04-05, when will 1.4.x stable version release?

2016-12-21 Thread Steve McLeod
Leon, Although not marked stable, 1.4 with the page store (MV_STORE=false in JDBC URL) works better than 1.3.176 in many ways, and as good as 1.3.176 in all other ways. I'm willing to state this because my product (Poker Copilot) has been using H2 since 2009 with thousands of users. As of Janu

Re: [h2] MVStore -- can I ignore it?

2016-12-21 Thread Noel Grandin
On 2016/12/21 10:26 AM, SkiAddict wrote: How do we migrate to the MV_STORE format? Dump and restore. -- 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-dat

Re: [h2] MVStore -- can I ignore it?

2016-12-21 Thread SkiAddict
On Wednesday, 21 December 2016 20:15:40 UTC+13, Noel Grandin wrote: > > MV_STORE is a completely separate storage engine from the old PageStore. > > The old PageStore engine generates files with a .h2.db extension, the new > MV_STORE engine generates files with a .mv.db extension. > > So it's not