Issue Details (XML | Word | Printable)

Key: CORE-4732
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: Dmitry S. Gostev
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Series of transactions are repeated automatically after system abnormal shutdown

Created: 03/Apr/15 07:11 AM   Updated: 26/May/15 06:56 AM
Component/s: Engine
Affects Version/s: 2.5.3
Fix Version/s: None

File Attachments: 1. File GOODS.fdb (813 kB)

Environment: Windows XP, Windows 7 ( all 32-bit)


 Description  « Hide
This bug existed since version 1.0 and went through the versions to 2.5.3

The situation is as follows:
1. Empty database with some tables, generators created.
2. The user starts to work, opens transaction, inserts a row into table A, the transaction is committed
3. Then he makes a transaction with a query like this:
  UPDATE <TABLE B> SET <INTEGER FIELD>=<INTEGER FIELD>+<some value> WHERE <ID field>=some value
  The transaction is commited after each UPDATE query
4, The he makes a transaction with a query:
  INSERT INTO <TABLE C> ...
  transaction is commited
5. The steps 3,4 are repeated for <n> times with dirrerent data.
6. The user disconnects from the base or permits another query INSERT INTO <TABLE A>.

Then the user works with the database for a week, for a month or a year (the period doesnot matter), he can add new fileds, can make changes to <INTEGER FIELD> in the <TABLE B>. Then occurs an abnormal shutdown of the computer (for example, electricity is cut off).
  When the power is restored and the user connects to the database, the user finds out that the values of the <INTEGER FIELD> of the <TABLE B> are mistakenly increased by the <some value>, like the Firebird 'repeated' all the transactions made in the step 3.
No matter how many times the user made steps 2-5, the Firebird repeats only the first since the database creation sequence of the 'step 3' transactions.
  If needed, the database and the transaction/table detail can be supplied.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.