Results 1 to 6 of 6

Thread: Database errors found. now?

  1. #1
    maumar is offline Elite Member
    Join Date
    Mar 2007
    Location
    Small village in the center of Italy
    Posts
    339
    Rep Power
    8

    Default Database errors found. now?

    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=P4F.87begMuVgNOKvoAJzkL6ve6 --auto-repair
    mysql.db
    warning : 2 clients are using or haven't closed the table properly
    mysql.help_category
    error : Table upgrade required. Please do "REPAIR TABLE `help_category`" to fix it!
    mysql.help_keyword
    error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" to fix it!
    mysql.help_topic
    error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to fix it!
    mysql.user
    error : Table upgrade required. Please do "REPAIR TABLE `user`" to fix it!
    zimbra.config
    error : Table upgrade required. Please do "REPAIR TABLE `config`" to fix it!
    zimbra.mailbox_metadata
    error : Table upgrade required. Please do "REPAIR TABLE `mailbox_metadata`" to fix it!
    zimbra.out_of_office
    error : Table upgrade required. Please do "REPAIR TABLE `out_of_office`" to fix it!
    zimbra.service_status
    error : Table upgrade required. Please do "REPAIR TABLE `service_status`" to fix it!
    zimbra.table_maintenance
    error : Table upgrade required. Please do "REPAIR TABLE `table_maintenance`" to fix it!
    zimbra.volume
    error : Table upgrade required. Please do "REPAIR TABLE `volume`" to fix it!

    Checking for installable packages

    Found zimbra-core
    Found zimbra-ldap
    Found zimbra-logger
    Found zimbra-mta
    Found zimbra-snmp
    Found zimbra-store
    Found zimbra-apache
    Found zimbra-spell


    The Zimbra Collaboration Suite appears already to be installed.
    It can be upgraded with no effect on existing accounts,
    or the current installation can be completely removed prior
    to installation for a clean install.

    Do you wish to upgrade? [Y] N

    *** WARNING - you are about to delete all existing users and mail

    Delete users/mail? [N]

    Do you wish to upgrade? [Y]

    Now??
    what shoul i do??
    if i answer Y .what next? system will be upgraded?
    i tried to answer no and i get a terrible:
    *** WARNING - you are about to delete all existing users and mail

    Please any help will be very apreciated
    TIA
    Last edited by maumar; 10-11-2007 at 05:15 AM.

  2. #2
    flavio is offline Member
    Join Date
    Jul 2007
    Location
    San Francisco, CA
    Posts
    13
    Rep Power
    7

    Default I am getting the same trying to upgrade from 4.5.6 to 4.5.7

    Do you want to verify message store database integrity? [Y]
    Verifying integrity of message store databases. This may take a while.
    Starting mysqld daemon with databases from /opt/zimbra/db/data
    mysqld is alive
    Generating report
    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=NBHrySp9ISR_ILPzM38FiSnq --auto-repair
    mysql.help_category
    error : Table upgrade required. Please do "REPAIR TABLE `help_category`" to fix it!
    mysql.help_keyword
    error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" to fix it!
    mysql.help_topic
    error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to fix it!
    mysql.user
    error : Table upgrade required. Please do "REPAIR TABLE `user`" to fix it!
    zimbra.config
    error : Table upgrade required. Please do "REPAIR TABLE `config`" to fix it!
    zimbra.mailbox_metadata
    error : Table upgrade required. Please do "REPAIR TABLE `mailbox_metadata`" to fix it!
    zimbra.out_of_office
    error : Table upgrade required. Please do "REPAIR TABLE `out_of_office`" to fix it!
    zimbra.service_status
    error : Table upgrade required. Please do "REPAIR TABLE `service_status`" to fix it!
    zimbra.table_maintenance
    error : Table upgrade required. Please do "REPAIR TABLE `table_maintenance`" to fix it!
    zimbra.volume
    error : Table upgrade required. Please do "REPAIR TABLE `volume`" to fix it!

    Checking for installable packages

    Found zimbra-core
    Found zimbra-ldap
    Found zimbra-logger
    Found zimbra-mta
    Found zimbra-snmp
    Found zimbra-store
    Found zimbra-apache
    Found zimbra-spell


    The Zimbra Collaboration Suite appears already to be installed.
    It can be upgraded with no effect on existing accounts,
    or the current installation can be completely removed prior
    to installation for a clean install.

    Do you wish to upgrade? [Y]

  3. #3
    KirkIsmay is offline Starter Member
    Join Date
    May 2007
    Posts
    1
    Rep Power
    7

    Default I get the same.

    Anyone know what to do here?

    I tried to run "repair table xxx" from the mysql shell, this is what I got:
    mysql> REPAIR TABLE config;
    +---------------+--------+----------+---------------------------------------------------------+
    | Table | Op | Msg_type | Msg_text |
    +---------------+--------+----------+---------------------------------------------------------+
    | zimbra.config | repair | note | The storage engine for the table doesn't support repair |
    +---------------+--------+----------+---------------------------------------------------------+
    1 row in set (0.00 sec)

  4. #4
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Hi guys-
    Sorry I didn't reply to this sooner.

    The error can be safely ignored. Once you proceed, the upgrade script will call mysql_upgrade with the right parameters. This will fix the problem.

    Hope that helps,
    john

  5. #5
    Mark Daniel's Avatar
    Mark Daniel is offline Senior Member
    Join Date
    May 2007
    Location
    Ferndale, MI
    Posts
    54
    Rep Power
    7

    Default

    I'm getting what they were getting... is this still safe to ignore?

    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=YABG1Sy6x1.20BPnVihAQTvAAATQSfg_
    zimbra.jiveID
    warning : 1 client is using or hasn't closed the table properly
    zimbra.jiveRoster
    warning : 1 client is using or hasn't closed the table properly
    zimbra.jiveRosterGroups
    warning : 1 client is using or hasn't closed the table properly
    zimbra.jiveUserProp
    warning : 1 client is using or hasn't closed the table properly
    Only anomaly is that zimbra seems to be randomly "forgetting" my new HTML signature, and reverting back to the plaintext version I had before updating from 5.0.1 to 5.0.3.

    I'm getting these errors, btw, in database integrity check emails to the administrator. I see they're referring to Jive, which isn't that critical... but still a bit worrisome.
    mark daniel | actc
    zcs 6 ose | mac pro | mac os x server 10.4.11

  6. #6
    carlsanders is offline Active Member
    Join Date
    Mar 2008
    Posts
    40
    Rep Power
    7

    Default

    Greetings...

    If you're nervous and want to do a full backup first, read on...

    Zimbra does its own thing, all out of /opt/zimbra, even on a mac.
    So, if you stop zimbra, and make sure that the database, and http
    are also stopped, then you can back up the /opt/zimbra
    directory structure and that'll cover things well.

    You can use:

    cd /opt; tar czf zimbra.20080401.tar.gz zimbra

    to make a big, compressed backup.

    Or, if you like, you can use rsync (remote synchronize):

    cd /opt; rsync -avz zimbra /tmp

    to make a complete copy in your local /tmp directory,
    or you can use rsync to another system:

    cd /opt; rsync -avz zimbra username@someotherinternalsystem:/var/tmp

    You get the idea. Just make sure all of the services are stopped first.
    The mysql database is great in that if it's stopped, backing up all of the
    files is the equivalent of backing up the database.

    Hope this helps.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 10-05-2007, 03:14 PM
  2. Replies: 2
    Last Post: 10-04-2007, 03:20 PM
  3. Replies: 5
    Last Post: 03-01-2007, 03:20 AM
  4. Replies: 16
    Last Post: 11-29-2006, 10:36 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
  •