Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Collaboration Suite > Administrators

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-27-2011, 07:30 AM
Junior Member
 
Posts: 7
Default [SOLVED] ZCS 7.1.1 - Database Integrity - ERROR

Hello, I received an email this morning from ZCS with this 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=MYPASSWORD
mboxgroup1.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup1.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup1.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup1.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup1.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup10.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup10.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup10.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup10.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup10.pop3_message


(those lines are repeating for every user I´ve)

My ZCS version are: Release 7.1.1_GA_3196.RHEL5_64_20110527011124 CentOS5_64 FOSS edition.

My ZCS are working fine since last upgrade to 7.1.1, spite of this email, and I´ve no other problem and warnings since today.

Centos Version: CentOS release 5.6 (Final)


I´ve a ZCS server for contingency, I ran on this server:
/opt/zimbra/libexec/zmdbintegrityreport -m (the report was the same) THEN,

/opt/zimbra/libexec/zmdbintegrityreport -r

AND I receive this for every user:

note : The storage engine for the table doesn't support repair
zimbra.volume
note : The storage engine for the table doesn't support repair

Any suggestions? What I suppose to do?

Thank you
Reply With Quote
  #2 (permalink)  
Old 06-27-2011, 08:11 AM
Zimbra Consultant & Moderator
 
Posts: 20,315
Default

You should make sure you read the Release Notes in detail before and after an upgrade.

[SOLVED] Database errors found after migration to 7.0.0
__________________
Regards


Bill
Reply With Quote
  #3 (permalink)  
Old 07-04-2011, 05:42 AM
Junior Member
 
Posts: 7
Default

Hi Bill.

Last week I ran the upgrade tables scripts, everything is fine.

I received today this email (I know is a harmless notification but I´m telling you this bug is still going on):

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=St_miMm2CzfRXkQRmhA44wLhXpa
mysql.general_log
Error : You can't use locks with log tables.
mysql.slow_log
Error : You can't use locks with log tables.


FYI:

Also, I ran this script: /opt/zimbra/libexec/zmfixperms --verbose --extended after that my MTA didn´t start.

I made some correction manually with this orders:

chown root:root /opt/zimbra/postfix-2.7.4.2z/conf/ -R
chown postfixostfix /opt/zimbra/data/postfix/data/. -R

Everything is going well right now.

Regards
Reply With Quote
  #4 (permalink)  
Old 07-04-2011, 07:47 AM
Zimbra Consultant & Moderator
 
Posts: 20,315
Default

Quote:
Originally Posted by agrobio View Post
I received today this email (I know is a harmless notification but I´m telling you this bug is still going on):

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=St_miMm2CzfRXkQRmhA44wLhXpa
mysql.general_log
Error : You can't use locks with log tables.
mysql.slow_log
Error : You can't use locks with log tables.


FYI:
That's not a bug in Zimbra, it's a MySQL bug.

Quote:
Originally Posted by agrobio View Post
Also, I ran this script: /opt/zimbra/libexec/zmfixperms --verbose --extended after that my MTA didn´t start.
I guess you've filed a bug report for that problem?

Quote:
Originally Posted by agrobio View Post
I made some correction manually with this orders:

chown root:root /opt/zimbra/postfix-2.7.4.2z/conf/ -R
Those are the wrong owner:group for those files, they should be:

Code:
ls -l /opt/zimbra/postfix-2.7.4.2z/conf/ 
total 188
-rw-r--r-- 1 root   postfix 20695 May  9 23:53 access
-rw-r--r-- 1 root   postfix  8829 May  9 23:53 aliases
-rw-r--r-- 1 root   postfix  3548 May  9 23:53 bounce.cf.default
-rw-r--r-- 1 root   postfix 11681 May  9 23:53 canonical
-rw-r--r-- 1 root   postfix  9904 May  9 23:53 generic
-rw-r--r-- 1 root   postfix 19310 May  9 23:53 header_checks
-rw-r--r-- 1 root   postfix 11942 May  9 23:53 LICENSE
-rw-r--r-- 1 zimbra zimbra   2477 Jun 28 07:08 main.cf
-rw-r--r-- 1 root   postfix 24035 May  9 23:53 main.cf.default
-rw-r--r-- 1 root   postfix  3187 May  9 23:53 makedefs.out
-r--r----- 1 zimbra zimbra   5049 Jun 28 07:08 master.cf
-rw-r--r-- 1 zimbra zimbra   5195 May 27 09:38 master.cf.in
-rw-r--r-- 1 root   postfix  6816 May  9 23:53 relocated
-rw-r--r-- 1 root   postfix  1629 May  9 23:53 TLS_LICENSE
-rw-r--r-- 1 root   postfix 12549 May  9 23:53 transport
-rw-r--r-- 1 root   postfix 12494 May  9 23:53 virtual
__________________
Regards


Bill
Reply With Quote
  #5 (permalink)  
Old 07-05-2011, 06:03 AM
Moderator
 
Posts: 1,209
Default

Quote:
Originally Posted by agrobio View Post
Hi Bill.

Last week I ran the upgrade tables scripts, everything is fine.

I received today this email (I know is a harmless notification but I´m telling you this bug is still going on):

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=St_miMm2CzfRXkQRmhA44wLhXpa
mysql.general_log
Error : You can't use locks with log tables.
mysql.slow_log
Error : You can't use locks with log tables.


FYI:

Also, I ran this script: /opt/zimbra/libexec/zmfixperms --verbose --extended after that my MTA didn´t start.

I made some correction manually with this orders:

chown root:root /opt/zimbra/postfix-2.7.4.2z/conf/ -R
chown postfixostfix /opt/zimbra/data/postfix/data/. -R

Everything is going well right now.

Regards
The latest Patch for 7.1.1 has an updated zmfixperms which ostensibly was intended to fix that specific problem.
__________________
___________________________________
L. Mark Stone, CIO


"Uptime. All the time."

477 Congress Street | Portland, ME 04101-3431 | (207) 772-5678

proactive maintenance and monitoring | technology consulting
Zimbra groupware | EMR implementations | private cloud hosting
Reply With Quote
  #6 (permalink)  
Old 07-08-2011, 12:37 AM
Trained Alumni
 
Posts: 336
Default

Quote:
Originally Posted by phoenix View Post
That's not a bug in Zimbra, it's a MySQL bug.
I get that mysql error on every mysql check on every 7 installation (not upgrade!), and even if it's not a zimbra bug, it's annyong, and scares customers.

Any way to avoid it?
__________________
YetOpen S.r.l. ~ Your open source partner
Lecco (LC) - ITALY
http://www.yetopen.it
Reply With Quote
  #7 (permalink)  
Old 07-08-2011, 03:13 AM
Zimbra Consultant & Moderator
 
Posts: 20,315
Default

Quote:
Originally Posted by maxxer View Post
I get that mysql error on every mysql check on every 7 installation (not upgrade!), and even if it's not a zimbra bug, it's annyong, and scares customers.
Why? It doesn't cause you any problems.

Quote:
Originally Posted by maxxer View Post
Any way to avoid it?
Get MySQL to fix the bug?
__________________
Regards


Bill
Reply With Quote
  #8 (permalink)  
Old 07-08-2011, 05:28 AM
Junior Member
 
Posts: 7
Default

Quote:
Originally Posted by LMStone View Post
The latest Patch for 7.1.1 has an updated zmfixperms which ostensibly was intended to fix that specific problem.
Let me tell you the patch is not solve all the problems and it creates new ones.

OS: CentOS release 5.6 (Final)
Zimbra: Release 7.1.1_GA_3196.RHEL5_64_20110527011124 CentOS5_64 FOSS edition.


antispam Running
antivirus Stopped
zmclamdctl is not running

ldap Stopped
logger Stopped
zmlogswatchctl is not running

mailbox Stopped
zmmailboxdctl is not running.

mta Running
snmp Running
spell Running
stats Running
zmconfigd Stopped
zmconfigd is not running.


I´ll try to figure it out all now.
Reply With Quote
  #9 (permalink)  
Old 07-08-2011, 12:57 PM
Trained Alumni
 
Posts: 336
Default

Quote:
Originally Posted by phoenix View Post
Why? It doesn't cause you any problems.
When customers call me saying their zimbra has problems because of these warnings, yes.

Quote:
Originally Posted by phoenix View Post
Get MySQL to fix the bug?
Get zimbra ignore check for that tables?

And btw if mysqlcheck fails, upon upgrade ./install.sh will (should) fail, thus preventing the installation.
__________________
YetOpen S.r.l. ~ Your open source partner
Lecco (LC) - ITALY
http://www.yetopen.it
Reply With Quote
  #10 (permalink)  
Old 07-18-2011, 12:03 PM
Moderator
 
Posts: 1,432
Default

For reference, the (harmless) "You can't use locks with log tables" issue is documented at Bug 50272 - harmless errors reported by zmdbintegrityreport

That references one mysql bug; another may be MySQL Bugs: #43829: mysql_upgrade and log tables

See [SOLVED] Database Integrity Check Report
__________________
Elliot Wilen
Berkeley, CA

Don't forget to enter your Zimbra version in your forum profile.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com




 

SEO by vBSEO ©2011, Crawlability, Inc.