Issue Details (XML | Word | Printable)

Key: CORE-3550
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: Vlad Khorsun
Reporter: alainsegura
Votes: 0
Watchers: 7
Operations

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

Error writing data to the connection (2.5.1) / transactions reliability / database corruption

Created: 10/Jul/11 06:20 AM   Updated: 16/Jul/11 06:14 PM
Component/s: Engine
Affects Version/s: 2.5.1
Fix Version/s: None

Environment: Windows 32bits superserver


 Description  « Hide
 the connection to the database is lost with error "error writing data to the connection" while running this piece of code (B):
(Error message returned may vary from time to time)

If you re run the code (B), then, after the 2nd error, when you try to reconnect the database is corrupted (wrong page type)

A: Run the code
recreate global temporary table test (x varchar(20) not null, y varchar(20) not null) on commit preserve rows

B: Run the code
execute block as
declare variable i integer;
declare variable j integer;

begin
 i=0;
 while (i<500) do begin
  execute statement 'recreate global temporary table test (x varchar(20) not null, y varchar(20) not null) on commit preserve rows';
  execute statement 'create unique index xtest on test (x,y)';
  execute statement 'grant all on test to FMUSER';

  j=0;
  while (j<10000) do begin
    in autonomous transaction do execute statement 'insert into test (x,y) values ( ' || cast(i as varchar(20)) || ', ' || cast( j as varchar(20)) || ')';
   j=j+1;
  end

  i=i+1;
 end
end

 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.