I believe I needed to upgrade at least to version 3.23.42. There was a bug fix where certain record lengths killed the REPAIR (See D.2.9). So I tried an upgrade & problem is gone... whether or not my diagnosis was correct.
I want to thank all that replied for your dead-on help. Also I have to say that not only was the help accurate & succinct but the turnaround time was also stellar. rafe Michael Widenius wrote: > > Hi! > > >>>>> "rafe" == rafe <[EMAIL PROTECTED]> writes: > > >> Description: > rafe> I am not subscribe to this list so please cc me in your reply. > > rafe> I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a >fresh build and there has been no activity except for the following: > rafe> 1) Record inserts from flat file parsing. > rafe> 2) OPTIMIZE TABLE wich died in batch & caused me to try and run the REPAIR. > > rafe> I've also tried complete rebuilds with the same data and I get the same crashi >but builds with less data (~4GB) have worked. > > rafe> The REPAIR TABLE dies repeatedly with: > mysql> repair table dna; > rafe> ERROR 2013: Lost connection to MySQL server during query > > rafe> I've tried '-O max_allowed_packet=33554432' as per section A.2.2. But with the >same results. > > REPAIR should be independent of max_allowed_packet. > > We have many users of MySQL with tables bigger than 4G, so this is not > a general problem. > > Please take a backup of your table and try a repair with the > 'myisamchk' utility. > > As Sinisa said, please try REPAIR with our latest binary. If you get > the same problem with MySQL 3.23.49, can you give us access to a copy > of that table so that we can fix this problem ASAP ? > > Regards, > Monty > > -- > For technical support contracts, goto https://order.mysql.com/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO > /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland > <___/ www.mysql.com --------------------------------------------------------------------- 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
