[#CORE-1063] Server hangs eating CPU and performs huge I/O copying different codepage fields

Firebird Core

Server hangs eating CPU and performs huge I/O copying different codepage fields

Created: 21/Dec/06 08:00 AM Updated: 29/May/08 05:04 PM

Return to search

Component/s:

Engine

Affects Version/s:

2.0.0

Fix Version/s:

2.0.1, 2.1 Alpha 1

Time Tracking:

Original Estimate:

Not Specified

Remaining Estimate:

0 minutes

Time Spent:

2 hours

File Attachments:

database.zip (37 kB)

Environment:

Windows XP SP2. A64X2 4200+, 1Gb RAM, 160Gb SATA drive

Issue Links:

Relate

This issue is related to:

~~QA-35~~ Test for CORE-1063

Description

« Hide

Restore the small database from attached backup and run the following script on it:

alter table cms_wiki
add u_name varchar(100) character set UTF8,
add u_title varchar(100) character set UTF8,
add u_description blob sub_type 1 character set UTF8,
add u_text blob sub_type 1 character set UTF8;

commit;

update cms_wiki set
u_name = name, u_title = title, u_text = text, u_description = description;

commit;

drop index uq_cms_wiki;

alter table cms_wiki drop name, drop description, drop text, drop title;

commit;

alter table cms_wiki
alter u_name to name,
alter u_title to title,
alter u_description to description,
alter u_text to text;

commit;

CREATE UNIQUE INDEX UQ_CMS_WIKI ON CMS_WIKI (NAME, SITE_ID);