Re: Problems upgrading from 4.0 to 4.1
Hi! On Apr 11, Christian Hammers wrote: > Hello Sergei > > On Thu, Apr 07, 2005 at 03:14:10PM +0200, Sergei Golubchik wrote: > > > I've just run into deep troubles while upgrading from 4.0.24 to 4.1.10a > > > using precomiled Debian packages on Debian Woody although I read the > > > comments regarding upgrading on dev.mysql.com. > > > > > After starting the new server and running "mysqlcheck -r -v -A", I > > > experienced the following problems on about 15% of my tables (seemed > > > to be quite random, i.e. not only the biggest or most used ones): > > > > Christian, do you have any of that tables ? Can you upload one of them > > (preferably, the smallest one) to our ftp ? > > > > > beta_hardware_verwaltung.hardware_log > > > info : Found wrong packed record at 0 > > > info : Found wrong packed record at 56 > > > info : Found wrong packed record at 112 > > Did you found the files on the incoming/ dir and do you have any news on > this case? If it's not something extremly stupid from my side, can you > open a bug report to make the issue easier to track? Yes, I found the file and repeated this problem, thanks. I opened a bugreport #9824 for it. about "15% of my tables (seemed be quite random" - it happens on the tables that have live checksum enabled (CHECKUM=1 in CREATE TABLE). workarounds - disable checksum (in 4.0, before upgrade) or copy the table with create ... select. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems upgrading from 4.0 to 4.1
Hello Sergei On Thu, Apr 07, 2005 at 03:14:10PM +0200, Sergei Golubchik wrote: > > I've just run into deep troubles while upgrading from 4.0.24 to 4.1.10a > > using precomiled Debian packages on Debian Woody although I read the > > comments regarding upgrading on dev.mysql.com. > > > After starting the new server and running "mysqlcheck -r -v -A", I > > experienced the following problems on about 15% of my tables (seemed > > to be quite random, i.e. not only the biggest or most used ones): > > Christian, do you have any of that tables ? Can you upload one of them > (preferably, the smallest one) to our ftp ? > > > beta_hardware_verwaltung.hardware_log > > info : Found wrong packed record at 0 > > info : Found wrong packed record at 56 > > info : Found wrong packed record at 112 Did you found the files on the incoming/ dir and do you have any news on this case? If it's not something extremly stupid from my side, can you open a bug report to make the issue easier to track? bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller Lütticher Straße 10 Tel 0241/701333-11 ch@westend.comD-52064 Aachen Fax 0241/911879 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems upgrading from 4.0 to 4.1
Hello Sergei On Thu, Apr 07, 2005 at 03:14:10PM +0200, Sergei Golubchik wrote: > > I've just run into deep troubles while upgrading from 4.0.24 to 4.1.10a > > using precomiled Debian packages on Debian Woody although I read the > > comments regarding upgrading on dev.mysql.com. > > > After starting the new server and running "mysqlcheck -r -v -A", I > > experienced the following problems on about 15% of my tables (seemed > > to be quite random, i.e. not only the biggest or most used ones): > > Christian, do you have any of that tables ? Can you upload one of them > (preferably, the smallest one) to our ftp ? I've uploaded the file into your write-only ftp.mysql.com:/pub/mysql/upload/ directory as Christian_Hammers_Tablecorruption_40to41.tar.gz The included table is correct according to a CHECK TABLE with MySQL-4.0.24 but reproducible gets emptied during a REPAIR TABLE on MySQL-4.1.10a. bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller Lütticher Straße 10 Tel 0241/701333-11 ch@westend.comD-52064 Aachen Fax 0241/911879 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]