Issue Details (XML | Word | Printable)

Key: CORE-1468
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

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

Database corruption possible when database file extension and read\write activity is performed simultaneously

Created: 18/Sep/07 03:55 AM   Updated: 26/Dec/07 12:36 PM
Component/s: Engine
Affects Version/s: 2.1 Beta 1
Fix Version/s: 2.1 Beta 2

Time Tracking:
Not Specified

Environment: I can reproduce it only on Windows 2003 64-bit edition. The same binaries worked fine on WinXP 32-bit on the same machine. Also FW must be ON


 Description  « Hide
SQL> CREATE DATABASE 'test.fdb';
SQL> CONNECT 'test.fdb';
Commit current transaction (y/n)?y
Committing.
Database: 'test.fdb'
SQL> CREATE TABLE TEST_TABLE (S CHAR(256));
SQL> SET TERM ^ ;
SQL> EXECUTE BLOCK AS
CON> DECLARE N INT = 1000000;
CON> DECLARE I INT = 0;
CON> DECLARE S CHAR(256);
CON> BEGIN
CON> S ='0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345';
CON> WHILE (I < N) DO
CON> BEGIN
CON> INSERT INTO TEST_TABLE VALUES (:S);
CON> I = I + 1;
CON> END
CON> END ^
SQL> SELECT COUNT(*) from TEST_TABLE ^

       COUNT
============
Statement failed, SQLCODE = -902
database file appears corrupt ()
-bad checksum
-checksum error on database page 447


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.