search

lbehnke / h2database

Automatically exported from code.google.com/p/h2database
0 stars 0 forks source link

DB Corruption #123

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)
1. Run two ScheduledThreadExecutors (one selects, one inserts)
2. connect to DB in multithreaded mode (MULTI_THREADED=1)
3. Everytime the results of the select query are compared to the size of
expected results. Everytime an insert is done, the size of expectedResults
are updated.

What is the expected output? What do you see instead?
Expected output is - the test runs normally and sees a consistent result.

What version of the product are you using? On what operating system, file
system, and virtual machine?
H2 v 1.1.117
Windows XP
NTFS (I believe)

Do you know a workaround?
No

How important/urgent is the problem for you?
We are evaluating H2 to replace our current DB in one of our webapps.
Hence, pretty urgent.

In your view, is this a defect or a feature request?
defect.

Please provide any additional information below.
Attaching sample test code for reference.

a basic test db with 3 tables
Department (primary key Id) - 10000 rows
Employee (foreign key - DeptId) - ~million rows
Project (foreign key) ~40K rows

Original issue reported on code.google.com by asmalp...@gmail.com on 25 Sep 2009 at 5:31

Attachments:

GoogleCodeExporter commented 9 years ago 
Hi,

Thanks for the test case! Could you add the CREATE TABLE statements please?

Regards,
Thomas

Original comment by thomas.t...@gmail.com on 25 Sep 2009 at 5:48

GoogleCodeExporter commented 9 years ago 
Attaching create statement

Original comment by asmalp...@gmail.com on 25 Sep 2009 at 6:45

Attachments:

GoogleCodeExporter commented 9 years ago 
Hi,

I have added insert statements, and disabled the referential integrity 
constraints (I
believe those are not related to the problem). So far I couldn't reproduce the
problem. Could you have a look at my modified test case please?

http://h2database.com/p.html#04c9e8f5948b90ae328f4cc6bf5b7f4b

Original comment by thomas.t...@gmail.com on 26 Sep 2009 at 8:19

GoogleCodeExporter commented 9 years ago

Original comment by thomas.t...@gmail.com on 4 Oct 2009 at 9:15