From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: table modification [ALTER TABLE DROP COLUMN name];
on large table (1.7gb) crashed mysqldnt
Description: - attempt to extract a longblob column from a large table
with ca. 200.000 records
into a separate table (successful)
- dropping the blob_column from the large table (success)
consecutive access to the database by an odbc-client
caused the server to crash.
stack_trace (dump.txt) attached
How-To-Repeat: bug has been reproduced a 2nd time by dropping another
column from the same table.
Actually, the original table is not available anymore,
because the crash corrupted the indexfile.
Further attempts to reproduce the failure on backup-tables in
progress.
Fix: none so far
Synopsis: mysqldnt crashed after ALTER TABLE DROP COLUMN
Submitter-Id: ASC
Originator: Armin Schöffmann
Organization: Aegaeon technologies GmbH
MySQL support: licence
Severity: critical
Priority:
Category: mysqld
Class: sw-bug
Release: mysql-3.23.36
Exectutable: mysqld
Environment: Dell Optiplex, Intel PIII, 256mb, nt5sp1(us)ws
System: Win2000
Compiler: VC++ 6.0
Architecture: i686
------------------------
Aegaeon technolgies GmbH
Stadtamhof 15
93059 Regensburg
Germany
fon: +49.941.8107344
fax: +49.941.8107356
www.aegaeon.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
