Bugs item #1504657, was opened at 2006-06-12 11:47 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1504657&group_id=56967
Please 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: Closed Resolution: Fixed Priority: 5 Private: No 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: Stefan Manegold (stmane) Date: 2007-01-29 19:26 Message: Logged In: YES user_id=572415 Originator: NO Closed on behalf of Romulo. ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2007-01-29 18:52 Message: Logged In: YES user_id=1498628 Originator: NO This bug is fixed and it is covered by: sql/src/jdbc/tests/Tests/BugConcurrent_clients_1504657.SQL However, the location of the Java file is in: clients/src/java/tests/BugConcurrent_clients_1504657.java Regards, Romulo Note: Why I cannot close it? ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2007-01-25 18:07 Message: Logged In: YES user_id=1498628 Originator: NO A test was created to cover this bug: sql/src/jdbc/tests/Tests/BugConcurrent_clients_1504657.SQL However, the location of the Java file is in: clients/src/java/tests/BugConcurrent_clients_1504657.java Regards, Romulo ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2007-01-18 00:16 Message: Logged In: YES user_id=572415 Originator: NO lowered priority as it is supposedly fixed, only the test (or a reason why there is none) is missing. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2006-12-02 18:39 Message: Logged In: YES user_id=572415 Originator: NO Re-opened, as no test has been provided, yet. User (submitter) and/or developer (assignee), please supply a respective test, or explain why a test is not required/possible. ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2006-06-13 11:21 Message: Logged In: YES user_id=43556 fixed the problem, ie keep delta's also in new transactions. Could you repeat you test? ---------------------------------------------------------------------- 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 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
