Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Database Integrity check report

  1. #1
    163828045 is offline Member
    Join Date
    Sep 2008
    Posts
    11
    Rep Power
    6

    Default Database Integrity check report

    Hello,
    I have recived the following email,
    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=XXXXXXXXXXX
    mysql.db
    warning : 1 client is using or hasn't closed the table properly
    mysql.user
    warning : 1 client is using or hasn't closed the table properly
    zimbra.jiveID
    warning : 1 client is using or hasn't closed the table properly
    zimbra.jiveUserProp
    warning : 2 clients are using or haven't closed the table properly
    zimbra.jiveVersion
    warning : 1 client is using or hasn't closed the table properly

    Any ideias how i can fix this?

    Thanks
    Last edited by uxbod; 03-16-2009 at 02:26 AM. Reason: removed password

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

    Default

    if you connect with MySQL and those parameters you can then
    Code:
    show tables;
    check table {for each table reported above and if any fail}
    repair table {table name}

  3. #3
    163828045 is offline Member
    Join Date
    Sep 2008
    Posts
    11
    Rep Power
    6

    Default

    Hello,
    Will try that, and post the results.

    Thanks

  4. #4
    163828045 is offline Member
    Join Date
    Sep 2008
    Posts
    11
    Rep Power
    6

    Default

    Hello,
    I have runned the following commands,

    mysql> CHECK TABLE jiveUserProp EXTENDED;
    +---------------------+-------+----------+----------+
    | Table | Op | Msg_type | Msg_text |
    +---------------------+-------+----------+----------+
    | zimbra.jiveUserProp | check | status | OK |
    +---------------------+-------+----------+----------+
    1 row in set (0.00 sec)

    mysql> CHECK TABLE jiveID EXTENDED;
    +---------------+-------+----------+----------+
    | Table | Op | Msg_type | Msg_text |
    +---------------+-------+----------+----------+
    | zimbra.jiveID | check | status | OK |
    +---------------+-------+----------+----------+
    1 row in set (0.00 sec)

    mysql> CHECK TABLE jiveVersion EXTENDED;
    +--------------------+-------+----------+----------+
    | Table | Op | Msg_type | Msg_text |
    +--------------------+-------+----------+----------+
    | zimbra.jiveVersion | check | status | OK |
    +--------------------+-------+----------+----------+
    1 row in set (0.00 sec)

    mysql> CHECK TABLE mysql.db EXTENDED;
    +----------+-------+----------+----------+
    | Table | Op | Msg_type | Msg_text |
    +----------+-------+----------+----------+
    | mysql.db | check | status | OK |
    +----------+-------+----------+----------+
    1 row in set (0.01 sec)

    mysql>

    And it looks like no errors have been found, is this normal?

    Thanks

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

    Default

    If the tables are all okay, and you can afford a short downtime period, then you could shutdown ZCS and run
    Code:
    myisamchk --update-state {ZCS DataPath/*.MYI}

  6. #6
    163828045 is offline Member
    Join Date
    Sep 2008
    Posts
    11
    Rep Power
    6

    Default

    when you say ZCS DataPath you are refering to /opt/zimbra?

    Thanks

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

    Default

    Yes where the MySQL datafiles are stored for ZCS.

  8. #8
    163828045 is offline Member
    Join Date
    Sep 2008
    Posts
    11
    Rep Power
    6

    Default

    So it should be
    /opt/zimbra/db/data
    or do i need to insert the zimbra folder also?
    /opt/zimbra/db/data/zimbra

    Thanks

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

    Default

    You need to specify the full path to where the MYI files are held.

  10. #10
    163828045 is offline Member
    Join Date
    Sep 2008
    Posts
    11
    Rep Power
    6

    Default

    Systems says mysql not installed,i also have tried to rum as zimbra user but no luck.
    Any other way?

    Thanks

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Database Integrity Check Report error in Admin account.
    By nishith in forum Administrators
    Replies: 2
    Last Post: 06-08-2009, 01:37 AM
  2. Replies: 2
    Last Post: 08-18-2008, 02:43 PM
  3. [SOLVED] Mailserver down when send file attach of 50Mb
    By ZMilton in forum Administrators
    Replies: 20
    Last Post: 04-10-2008, 11:44 AM
  4. [SOLVED] Database Integrity check report
    By cedbl in forum Administrators
    Replies: 9
    Last Post: 02-06-2008, 02:11 PM
  5. Database Integrity check report: Errors found
    By mcevoys in forum Administrators
    Replies: 8
    Last Post: 12-07-2007, 08:26 AM

Posting Permissions

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