Results 1 to 6 of 6

Thread: Database errors found.

  1. #1
    rolandCA is offline Trained Alumni
    Join Date
    Mar 2008
    Location
    Vancouver, Canada
    Posts
    3
    Rep Power
    7

    Default Database errors found.

    I have received the following error in my mail.

    Database errors found.
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=****************
    zimbra.jiveUserProp
    warning : 1 client is using or hasn't closed the table properly

    3 days ago we had a power outage and the server lost its power. Is there anything I should do ?

    #######################
    zimbra@mail:~$ zmcontrol -v


    Release 5.0.11_GA_2695.UBUNTU6 UBUNTU6 NETWORK edition

    zimbra@mail:~$ uname -a
    Linux mail.domain.com 2.6.15-51-server #1 SMP Tue Feb 12 17:12:18 UTC 2008 i686 GNU/Linux

  2. #2
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Welcome to the forums

    Have a look in /opt/zimbra/db/data/hostname.err for any error messages. You then may need to follow Wiki :: MySQL Crash Recovery if you cannot just repair the databases.

  3. #3
    rolandCA is offline Trained Alumni
    Join Date
    Mar 2008
    Location
    Vancouver, Canada
    Posts
    3
    Rep Power
    7

    Default

    hi, thanks for reply. I dont have the /opt/zimbra/db/data/hostname.err

    zimbra@mail:~$ ls /opt/zimbra/db/data/
    backup mboxgroup2 mboxgroup34 mboxgroup49 mboxgroup63 mboxgroup78 mboxgroup92
    ib_logfile0 mboxgroup20 mboxgroup35 mboxgroup5 mboxgroup64 mboxgroup79 mboxgroup93
    ib_logfile1 mboxgroup21 mboxgroup36 mboxgroup50 mboxgroup65 mboxgroup8 mboxgroup94
    ibdata1 mboxgroup22 mboxgroup37 mboxgroup51 mboxgroup66 mboxgroup80 mboxgroup95
    mboxgroup1 mboxgroup23 mboxgroup38 mboxgroup52 mboxgroup67 mboxgroup81 mboxgroup96
    mboxgroup10 mboxgroup24 mboxgroup39 mboxgroup53 mboxgroup68 mboxgroup82 mboxgroup97
    mboxgroup100 mboxgroup25 mboxgroup4 mboxgroup54 mboxgroup69 mboxgroup83 mboxgroup98
    mboxgroup11 mboxgroup26 mboxgroup40 mboxgroup55 mboxgroup7 mboxgroup84 mboxgroup99
    mboxgroup12 mboxgroup27 mboxgroup41 mboxgroup56 mboxgroup70 mboxgroup85 mysql
    mboxgroup13 mboxgroup28 mboxgroup42 mboxgroup57 mboxgroup71 mboxgroup86 test
    mboxgroup14 mboxgroup29 mboxgroup43 mboxgroup58 mboxgroup72 mboxgroup87 zimbra
    mboxgroup15 mboxgroup3 mboxgroup44 mboxgroup59 mboxgroup73 mboxgroup88
    mboxgroup16 mboxgroup30 mboxgroup45 mboxgroup6 mboxgroup74 mboxgroup89
    mboxgroup17 mboxgroup31 mboxgroup46 mboxgroup60 mboxgroup75 mboxgroup9
    mboxgroup18 mboxgroup32 mboxgroup47 mboxgroup61 mboxgroup76 mboxgroup90
    mboxgroup19 mboxgroup33 mboxgroup48 mboxgroup62 mboxgroup77 mboxgroup91

  4. #4
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Are you in a position where you can completely shutdown ZCS and restart it ? Once that has been done check your logfiles for any error messages.

  5. #5
    rolandCA is offline Trained Alumni
    Join Date
    Mar 2008
    Location
    Vancouver, Canada
    Posts
    3
    Rep Power
    7

    Default

    thanks for the help but I would prefer not to reboot it if not absolutely necessary. Additionally I do have an error message as in my original post.

    quote**
    Database errors found.
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=****************
    zimbra.jiveUserProp
    warning : 1 client is using or hasn't closed the table properly
    **quote

    Is this message so cryptic and obscure that noone is able to decipher? I would think that someone else has come across it.

    For now the queue is empty and email is being delivered but I would appreciate any insight into the problem.

  6. #6
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Okay, if you want to check that table you can do
    Code:
    su - zimbra
    /opt/zimbra/mysql/bin/mysql --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=*****
    > use zimbra;
    > check table jiveUserProp;
    > repair table jiveUserProp;
    I would recommend you take a backup first though! and you can get the password using
    Code:
    su - zimbra
    zmlocalconfig -s | grep -i mysql

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Fresh Zimbra installation does not work
    By Datax in forum Installation
    Replies: 4
    Last Post: 08-18-2008, 01:18 PM
  2. Database errors found. now?
    By maumar in forum Installation
    Replies: 5
    Last Post: 04-02-2008, 05:13 AM
  3. Replies: 20
    Last Post: 03-18-2008, 05:37 AM
  4. Replies: 2
    Last Post: 10-04-2007, 03:20 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
  •