Results 1 to 9 of 9

Thread: MySQL keep corrupting

  1. #1
    ekkas is offline Special Member
    Join Date
    Feb 2010
    Location
    South Africa
    Posts
    107
    Rep Power
    5

    Default MySQL keep corrupting

    I have a problem where my SQL keep getting corrupt, then I have to rebuild the SQL tables via : Mysql Crash Recovery - Zimbra :: Wiki after which it works again for anything from a day to a few hours.

    It is running
    Release 6.0.9_GA_2686.RHEL5_64_20101115233514 CentOS5_64 FOSS edition.
    Linux version 2.6.18-194.26.1.el5xen

    On a XenServer 5.6, connected to a CentOS 5.5-64bit dedicated 'SAN' box as it's storage (for the whole VM) over 1000Mbps LAN using NFS.

    I had it on local storage, but have when the problems started, I converted it from Ubuntu 8.04 32 bit to CentOS 64 bit, primarily because with the Xen kernel I can load XenServer's XenTools for better monitoring and since 32 bit is phased out, and then transferred it to SAN storage.

    BUT, my problem is the SQL tables getting corrupted, the only logs I find any indication that something went wrong is in mysql_errors.log, apart from other errors that is there because the SQL tables is corrupt. Neither the XenServer nor the SAN storage have anything (that I can find) in their logs to indicate any other problems, although I'm not a Linux guru either.

    I don't know if the SAN storage could be an issue, but I have a (quite loaded/busy) Windows 7 64-bit databasee 'server' VM running of the same XenServer and the same SAN/NFS without any problems.

    Anyone can please help me ty to figure this animal out? I 'd really appreciate it.

    Thanks

    Ekkas

  2. #2
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,485
    Rep Power
    56

    Default

    Quote Originally Posted by ekkas View Post
    On a XenServer 5.6, connected to a CentOS 5.5-64bit dedicated 'SAN' box as it's storage (for the whole VM) over 1000Mbps LAN using NFS.
    I'm not saying this is specifically your problem but it's not recommended that you use NFS for Zimbra - take a look at this wiki article: Performance Tuning Guidelines for Large Deployments - Zimbra :: Wiki
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    ekkas is offline Special Member
    Join Date
    Feb 2010
    Location
    South Africa
    Posts
    107
    Rep Power
    5

    Post

    Thanks for the reply.
    I had a look at that. I don't believe I have THAT big ZCS implementation. About 600 mailboxes, a lot of them unused. Ave. of about 45 GB mail a day. The Windows 7 database server I run on the same VM has a lot more IO than Zimbra. Disk read/writes and Network usage barely shows on performance graph (on XenServer) for Zimbra. So I doubt if I am stressing the system at all. I get better IO speeds on the SAN than what I get on local drive, and local drive isn't RAID'ed, so it makes me nervous to run Zimbra on a single drive.

    Is there maybe something specific I can search for to find root cause of this bastardly corruption?
    Do you think it might be a ghost in Zimbra somewhere (that I caused during my migration from 32 to 64 bit) or hardware related? I'd just like to find some log to narrow the options down a bit, although when I have fresh eyes, I'll look again as well.

    Ekkas

  4. #4
    ekkas is offline Special Member
    Join Date
    Feb 2010
    Location
    South Africa
    Posts
    107
    Rep Power
    5

    Default Spoke to soon

    This morning, my Windows VM also went bonkers, so it seems my problem is not related to Zimbra.

    or , I don't know.

  5. #5
    baloan is offline New Member
    Join Date
    Aug 2013
    Posts
    3
    Rep Power
    1

    Default

    Hello Ekkas,

    I have the same issue with xenserver 6.20, ubuntu 12.04, mysql 5.5. How have you solved your problem?

    Regards, Andreas

  6. #6
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,485
    Rep Power
    56

    Default

    Quote Originally Posted by baloan View Post
    I have the same issue with xenserver 6.20, ubuntu 12.04, mysql 5.5. How have you solved your problem?
    Did you read the post above yours? It would appear that this is not related to Zimbra (and I would be surprised if it was). Do you happen to be using a SAN storage device? How many users on this server? How much RAM? How long has this been happening? What errors are you actually getting? Have you tried rebuilding the MySQL tables (as mentioned in the first paost)? There isn't actaly a ZCS version 6.20, you should update your forum profile with the output of the following command (and also post it here):

    Code:
    zmcontrol -v
    . You should also get yourself onto a more recent version of Zimbra.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  7. #7
    ekkas is offline Special Member
    Join Date
    Feb 2010
    Location
    South Africa
    Posts
    107
    Rep Power
    5

    Default

    Quote Originally Posted by baloan View Post
    Hello Ekkas,

    I have the same issue with xenserver 6.20, ubuntu 12.04, mysql 5.5. How have you solved your problem?

    Regards, Andreas
    I'd check hardware/storage issues if I were you. All SQL corruption we've had over the years was due to either untimely power outage, hardware failure, or full disks.
    SQL should not just corrupt by itself.

    Regards

  8. #8
    baloan is offline New Member
    Join Date
    Aug 2013
    Posts
    3
    Rep Power
    1

    Default

    Hello ekka,

    I have found that my platform stack

    Asrock B75M, i3-2120, 8GB RAM
    xenserver 6.2.0
    +- Windows XP SP3
    +- ubuntu 12.04

    both guests suffer from file corruption for large files (>500MB). The host itsself seems to be fine.

    I am running Zarafa groupware for one year now and the ibdata file has reached the 500MB size mark...

    Regards, Andreas


    Code:
    root@zeus:~/tmp# cp testsrc testdest
    root@zeus:~/tmp# l
    total 1389140
    drwxr-xr-x 2 root root      4096 Aug  9 20:03 .
    drwx------ 8 root root      4096 Aug  9 19:54 ..
    -rwxr-xr-x 1 root root        64 Aug  9 19:46 t
    -rw-r--r-- 1 root root 711229440 Aug  9 20:03 testdest
    -rw-r--r-- 1 root root 711229440 Aug  9 19:45 testsrc
    root@zeus:~/tmp# md5sum testsrc testdest
    c9a0d6ec2548210f50b46ca2d2ed7287  testsrc
    02a485852bab7464bdd446408022166e  testdest
    root@zeus:~/tmp# md5sum testsrc testdest
    c9a0d6ec2548210f50b46ca2d2ed7287  testsrc
    53aec428ebb0c2c558065a0857712b68  testdest
    root@zeus:~/tmp# md5sum testsrc testdest
    c9a0d6ec2548210f50b46ca2d2ed7287  testsrc
    7bd8583cca29b5696a0d365166d71f99  testdest
    root@zeus:~/tmp# md5sum testsrc testdest
    c9a0d6ec2548210f50b46ca2d2ed7287  testsrc
    08995fda40fd1871f830e209c1fc93e8  testdest

  9. #9
    baloan is offline New Member
    Join Date
    Aug 2013
    Posts
    3
    Rep Power
    1

    Default

    Root cause was a faulty memory stick (DDR3 DIMM).

    Thanks for you feedback,
    Andreas

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  3. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 03:27 PM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •