Bugs item #1504657, was opened at 2006-06-12 11:47
Message generated for change (Comment added) made by mr-meltdown
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1504657&group_id=56967Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
>Category: SQL/Core
Group: None
Status: Open
Resolution: None
>Priority: 8
Submitted By: monica_manzano (monica_manzano)
>Assigned to: Niels Nes (nielsnes)
>Summary: SQL: wrong data while inserting tuples in concurrent clients
Initial Comment:
I created the tables and inserted the data, and
something went really wrong. I found out it was because
of having another JdbcClient running concurrently.
Because I found it a very interesting bug, I did a
study case (dont know if it will be useful for you).
I checked the behaviour on the clients and took some
steps (I attached a .png with the case study). When
having more than one client running, if you create the
database in one of them, the rest see the tables
created, but there are problems with seeing the data
inserted. In the case study, I insert users tuples in
the users table. In the attached figure, in every step,
I say in which client I do the insertion and the
outcome obtained (when the results are correct, I only
print them sometimes).
After this case study, I went into another one where I
started inserting in the second client run, but the
behaviour was exactly the same; that is, it doesnt
matter if it is the first client run or the second one
the one which does the first create/inserts statements.
Finally, I ran a third client. At the first moment,
this client3 didnt see any of the data inserted. After
inserting another user in any of the three clients,
the other two see the correct data, while the client
who ran it sees wrong data.
I didnt try with MonetDB5
----------------------------------------------------------------------
>Comment By: Fabian (mr-meltdown)
Date: 2006-06-12 12:33
Message:
Logged In: YES
user_id=963970
this is release critical
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1504657&group_id=56967_______________________________________________
Monetdb-bugs mailing list
Monetdb-bugs@...
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
