Issue Details (XML | Word | Printable)

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

If you were logged in you would be able to see more operations.
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
Time Spent: 2 hours
Time Spent - 2 hours

File Attachments: 1. Zip Archive database.zip (37 kB)

Environment: Windows XP SP2. A64X2 4200+, 1Gb RAM, 160Gb SATA drive
Issue Links:
Relate
 


 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);



 All   Comments   Work Log   Change History   Version Control   FishEye      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun committed 1 file to 'Firebird' - 22/Dec/06 08:25 AM
Fixed CORE-1063: Server hangs eating CPU and performs huge I/O copying different codepage fields
MODIFY src/jrd/filters.cpp   Rev. 1.52    (+4 -2 lines)
Vlad Khorsun committed 1 file to 'Firebird' - 22/Dec/06 09:53 AM
Correction and more comments for fix for CORE-1063
MODIFY src/jrd/filters.cpp   Rev. 1.53    (+4 -1 lines)
Vlad Khorsun committed 1 file to 'Firebird' on branch 'B2_0_Release' - 25/Dec/06 09:59 AM
Fixed CORE-1063: Server hangs eating CPU and performs huge I/O copying different codepage fields
MODIFY src/jrd/filters.cpp   Rev. 1.49.4.1    (+7 -2 lines)