Bugs item #2825243, was opened at 2009-07-22 17:01
Message generated for change (Settings changed) made by heangu
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2825243&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: Core
Group: None
Status: Open
Resolution: None
>Priority: 9
Private: No
Submitted By: heangu (heangu)
Assigned to: Nobody/Anonymous (nobody)
Summary: Data lost when restart
Initial Comment:
I opened two sessions at the same time, use session one to insert data,
session two execute START TRANSACTION but without COMMIT. When restart, I found
the data just inserted was lost!! MY test case is as follows:
1. Start the server.
2. Open one session. mclient -lsql -dtest. (Denote it as S1)
3. Open the second session as step 2. (Denote it as S2)
4. IN S1:
CREATE TABLE t(a int);
CREATE TABLE x(a int);
INSERT INTO t VALUES(1);
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
INSERT INTO t SELECT * FROM t;
5. IN S2:
START TRANSACTION;
6. IN S1:
INSERT INTO x VALUES(1);
INSERT INTO x VALUES(2);
7. IN S2:
COMMIT;
UPDATE t SET a = 8;
8. WAIT a few minutes.
9. KILL server and start it.
10. Open session S1. (mclient -lsql -dtest)
11. IN S1:
SELECT * FROM x;
Here is the problem. I should have got two lines (1 and 2) in STEP 11, but in
fact I only got an empty set.
Where has my data gone?
It can't be other person who deleted it. And I can have it occur many times.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2825243&group_id=56967
------------------------------------------------------------------------------
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
