Error on stopping server

[GlooM]

Hello! I use zimbra ose v 6.0.1 for Ubuntu server 64bit.

When I stopping server, I receive the following error:

zimbra@mail:~$ zmcontrol stop
Host mail.xxxxxxxx.xx
Stopping stats...Done.
Stopping mta...Done.
Stopping spell...Done.
Stopping snmp...Done.
Stopping archiving...Done.
Stopping antivirus...Done.
Stopping antispam...Done.
Stopping imapproxy...Done.
Stopping memcached...Done.
Stopping mailbox...Failed.
Stopping zmmtaconfig...zmmtaconfig is not running.
Stopping mailboxd...done.
Unknown suffix 'Y' used for variable 'port' (value 'YZ6uS9TsdjRtd0n7Sr7naj8t')
/opt/zimbra/mysql/bin/mysql: Error while setting value 'YZ6uS9TsdjRtd0n7Sr7naj8t ' to 'port'
Unknown suffix 'Y' used for variable 'port' (value 'YZ6uS9TsdjRtd0n7Sr7naj8t')
/opt/zimbra/mysql/bin/mysql: Error while setting value 'YZ6uS9TsdjRtd0n7Sr7naj8t ' to 'port'
Stopping mysqld...failed.


Stopping logger...Done.
Stopping ldap...Done.

Next server startup passes normally. What does this error mean?

[veronica]

Unknown suffix 'Y' used for variable 'port' (value 'YZ6uS9TsdjRtd0n7Sr7naj8t')

Seems some Junk value set here. What is error in mailbox.log ?

[GlooM]

Originally Posted by veronica

What is error in mailbox.log ?

I'm sorry. You mean mail.log or what? I didn't see mailbox.log in /var/log

[phoenix]

Originally Posted by GlooM

I'm sorry. You mean mail.log or what? I didn't see mailbox.log in /var/log

Log Files - Zimbra :: Wiki

[GlooM]

Originally Posted by phoenix

Log Files - Zimbra :: Wiki

Thanks for link! I found this file.

This is moment in log, when I shutting down server.

2009-11-15 02:08:55,184 INFO [Shutdown] [] log - Shutdown hook executing
2009-11-15 02:09:10,345 INFO [Shutdown] [] StatsImageServlet - Servlet StatsImageServlet shutting down
2009-11-15 02:09:10,376 INFO [Shutdown] [] FileUploadServlet - Servlet FileUploadServlet shutting down
2009-11-15 02:09:10,419 INFO [Shutdown] [] PublicICalServlet - Servlet PublicICalServlet shutting down
2009-11-15 02:09:10,433 INFO [Shutdown] [] account - Servlet PreAuthServlet shutting down
2009-11-15 02:09:10,493 INFO [Shutdown] [] mailbox - Servlet UserServlet shutting down
2009-11-15 02:09:10,525 INFO [Shutdown] [] ContentServlet - Servlet ContentServlet shutting down
2009-11-15 02:09:10,526 INFO [Shutdown] [] soap - Servlet AdminServlet shutting down
2009-11-15 02:09:10,539 INFO [Shutdown] [] TcpServer/7025 - LmtpServer initiating shutdown
2009-11-15 02:09:10,539 INFO [MailboxPurge] [] purge - Shutting down purge thread.
2009-11-15 02:09:10,724 INFO [LmtpServer] [] TcpServer/7025 - finished accept loop
2009-11-15 02:09:11,719 INFO [Shutdown] [] TcpServer/7025 - LmtpServer shutting down idle thread pool
2009-11-15 02:09:11,727 INFO [Shutdown] [] TcpServer/110 - Pop3Server initiating shutdown
2009-11-15 02:09:11,735 INFO [Shutdown] [] TcpServer/110 - Pop3Server shutting down idle thread pool
2009-11-15 02:09:11,742 INFO [Shutdown] [] TcpServer/995 - Pop3SSLServer initiating shutdown
2009-11-15 02:09:12,154 INFO [Pop3Server] [] TcpServer/110 - finished accept loop
2009-11-15 02:09:12,195 INFO [Shutdown] [] TcpServer/995 - Pop3SSLServer shutting down idle thread pool
2009-11-15 02:09:12,226 INFO [Shutdown] [] TcpServer/143 - ImapServer initiating shutdown
2009-11-15 02:09:12,235 INFO [Pop3SSLServer] [] TcpServer/995 - finished accept loop
2009-11-15 02:09:13,106 INFO [Shutdown] [] TcpServer/143 - ImapServer shutting down idle thread pool
2009-11-15 02:09:13,123 INFO [Shutdown] [] TcpServer/993 - ImapSSLServer initiating shutdown
2009-11-15 02:09:13,106 INFO [ImapServer] [] TcpServer/143 - finished accept loop
2009-11-15 02:09:13,164 INFO [ImapSSLServer] [] TcpServer/993 - finished accept loop
2009-11-15 02:09:13,171 INFO [Shutdown] [] TcpServer/993 - ImapSSLServer shutting down idle thread pool
2009-11-15 02:09:16,203 INFO [Shutdown] [] im - Wildfire stopped
2009-11-15 02:09:16,243 INFO [IndexReadersCache-Sweeper] [] IndexReadersCache - IndexReadersCache-Sweeper thread exiting
2009-11-15 02:09:21,204 INFO [mailboxd.csv] [] sqltrace - Slow execution (3619ms): SHOW INNODB STATUS
2009-11-15 02:09:27,291 INFO [Shutdown] [] redolog - Redo log rollover took 10724ms
2009-11-15 02:09:27,303 INFO [Shutdown] [] redolog - Logged: 20798 items, 10.712ms/item
2009-11-15 02:09:27,310 INFO [Shutdown] [] extensions - Destroying extensions
2009-11-15 02:09:27,872 INFO [Shutdown] [] extensions - Destroyed extension nginx-lookup: com.zimbra.cs.nginx.NginxLookupExten...mbr a.cs.extension.Z
2009-11-15 02:09:27,882 INFO [Shutdown] [] extensions - Destroyed extension com_zimbra_cert_manager: com.zimbra.cert.ZimbraCertMgrExt@com.zimbra.cs.ext ensio
2009-11-15 02:09:27,882 INFO [Shutdown] [] extensions - Destroyed extension com_zimbra_bulkprovision: com.zimbra.bp.ZimbraBulkProvisionExt...imbra.cs .ext
2009-11-15 02:09:27,883 INFO [Shutdown] [] extensions - Destroyed extension zimbrasamba: com.zimbra.ldaputils.ZimbraLDAPUtils...zimbra.cs.extensi
2009-11-15 02:09:27,900 INFO [Shutdown] [] extensions - Destroyed extension clamscanner: com.zimbra.clam.ClamScanner@com.zimb...tensio n.ZimbraExtension
2009-11-15 02:09:27,925 INFO [Shutdown] [] index - Shutting down IndexHelper thread pools....
2009-11-15 02:09:27,925 INFO [Shutdown] [] index - ...ReIndexing threadpool shutdown completed.
2009-11-15 02:09:27,956 INFO [Shutdown] [] index - ...IndexingCompleted threadpool shutdown completed.
2009-11-15 02:09:27,980 INFO [IncomingDirectorySweeper] [] store - IncomingDirectorySweeper thread exiting
2009-11-15 02:09:27,984 WARN [Shutdown] [] ZimbraHttpConnectionManager - shutting down http client idle connection reaper thread
2009-11-15 02:09:27,989 INFO [Shutdown] [] soap - Servlet SoapServlet shutting down
2009-11-15 02:09:28,239 INFO [Shutdown] [] log - Shutdown hook complete

[stardust]

Hello, we have encountered the similar issue:
Here is the quote of mailbox.log file:
========================

2009-11-20 19:10:36,370 INFO [btpool0-2103] [name=username@domain.ru;mid=42;ip=10.1.16.71;ua=Zi mbraWebClient - IE7

(Win)/6.0.1_GA_1816.UBUNTU8_64;] SoapEngine - handler exception
com.zimbra.common.service.ServiceException: system failure: MessagingExecption
ExceptionId:btpool0-2103:1258733436370:6f60e5df4e156715
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:251)
at com.zimbra.cs.service.mail.ParseMimeMessage.parseM imeMsgSoap(ParseMimeMessage.java:402)
at com.zimbra.cs.service.mail.ParseMimeMessage.parseM imeMsgSoap(ParseMimeMessage.java:171)
at com.zimbra.cs.service.mail.SendMsg.handle(SendMsg. java:146)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:417)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:272)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:156)
at com.zimbra.soap.SoapServlet.doWork(SoapServlet.jav a:291)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:212)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:502)
at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1148)
at org.mortbay.servlet.UserAgentFilter.doFilter(UserA gentFilter.java:81)
at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter .java:129)
at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1139)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:378)
at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebA ppContext.java:417)
at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:230)
at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:152)
at org.mortbay.jetty.handler.rewrite.RewriteHandler.h andle(RewriteHandler.java:230)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:517)
at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:868)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:747)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:218)
at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:386)
at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:409)
at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:451)
Caused by: javax.mail.MessagingException: No SMTP hosts available
at com.zimbra.cs.util.JMSession.getSession(JMSession. java:83)
at com.zimbra.cs.util.JMSession.getSession(JMSession. java:58)
at com.zimbra.cs.service.mail.ParseMimeMessage.parseM imeMsgSoap(ParseMimeMessage.java:267)
... 33 more
2009-11-20 19:10:36,530 INFO [Shutdown] [] log - Shutdown hook executing
2009-11-20 19:10:37,437 INFO [Shutdown] [] StatsImageServlet - Servlet StatsImageServlet shutting down
2009-11-20 19:10:37,437 INFO [Shutdown] [] FileUploadServlet - Servlet FileUploadServlet shutting down
2009-11-20 19:10:37,437 INFO [Shutdown] [] PublicICalServlet - Servlet PublicICalServlet shutting down
2009-11-20 19:10:37,437 INFO [Shutdown] [] account - Servlet PreAuthServlet shutting down
2009-11-20 19:10:37,437 INFO [Shutdown] [] mailbox - Servlet UserServlet shutting down
2009-11-20 19:10:37,437 INFO [Shutdown] [] ContentServlet - Servlet ContentServlet shutting down
2009-11-20 19:10:37,437 INFO [Shutdown] [] soap - Servlet AdminServlet shutting down
2009-11-20 19:10:37,448 INFO [Shutdown] [] TcpServer/7025 - LmtpServer initiating shutdown
2009-11-20 19:10:37,448 INFO [MailboxPurge] [] purge - Shutting down purge thread.
2009-11-20 19:10:37,448 INFO [LmtpServer] [] TcpServer/7025 - finished accept loop
2009-11-20 19:10:37,486 INFO [Shutdown] [] TcpServer/7025 - LmtpServer shutting down idle thread pool
2009-11-20 19:10:37,486 INFO [Shutdown] [] TcpServer/995 - Pop3SSLServer initiating shutdown
2009-11-20 19:10:37,487 INFO [Shutdown] [] TcpServer/995 - Pop3SSLServer shutting down idle thread pool
2009-11-20 19:10:37,487 INFO [Shutdown] [] TcpServer/143 - ImapServer initiating shutdown
2009-11-20 19:10:37,487 INFO [Shutdown] [] ProtocolHandler - graceful shutdown requested
2009-11-20 19:10:37,499 INFO [ImapServer] [] TcpServer/143 - finished accept loop
2009-11-20 19:10:37,522 INFO [Pop3SSLServer] [] TcpServer/995 - finished accept loop
2009-11-20 19:10:37,523 INFO [Shutdown] [] ProtocolHandler - graceful shutdown requested
2009-11-20 19:10:37,525 INFO [Shutdown] [] TcpServer/143 - ImapServer waiting 10 seconds for thread pool shutdown
2009-11-20 19:10:37,525 INFO [ImapServer-4410] [] ProtocolHandler - Handler exiting normally
2009-11-20 19:10:37,539 INFO [ImapServer-4493] [] ProtocolHandler - Handler exiting normally
2009-11-20 19:10:47,647 INFO [Shutdown] [] TcpServer/143 - ImapServer thread pool terminated
2009-11-20 19:10:47,647 INFO [Shutdown] [] TcpServer/993 - ImapSSLServer initiating shutdown
2009-11-20 19:10:47,647 INFO [Shutdown] [] ProtocolHandler - graceful shutdown requested
2009-11-20 19:10:47,660 INFO [ImapSSLServer] [] TcpServer/993 - finished accept loop
2009-11-20 19:10:47,673 INFO [Shutdown] [] ProtocolHandler - graceful shutdown requested
2009-11-20 19:10:47,765 INFO [Shutdown] [] ProtocolHandler - graceful shutdown requested
2009-11-20 19:10:47,772 INFO [Shutdown] [] ProtocolHandler - graceful shutdown requested
2009-11-20 19:10:47,836 INFO [ImapSSLServer-97] [] ProtocolHandler - Handler exiting normally
2009-11-20 19:10:47,892 INFO [ImapSSLServer-93] [] ProtocolHandler - Handler exiting normally
2009-11-20 19:10:47,892 INFO [ImapSSLServer-92] [] ProtocolHandler - Handler exiting normally
2009-11-20 19:10:47,836 INFO [Shutdown] [] TcpServer/993 - ImapSSLServer waiting 10 seconds for thread pool shutdown
2009-11-20 19:10:47,898 INFO [ImapSSLServer-103] [] ProtocolHandler - Handler exiting normally
2009-11-20 19:10:47,898 INFO [Shutdown] [] TcpServer/993 - ImapSSLServer thread pool terminated
2009-11-20 19:10:56,665 INFO [Shutdown] [] im - Wildfire stopped
2009-11-20 19:10:56,709 INFO [IndexReadersCache-Sweeper] [] IndexReadersCache - IndexReadersCache-Sweeper thread exiting
2009-11-20 19:11:05,096 INFO [Shutdown] [] redolog - Redo log rollover took 7046ms
2009-11-20 19:11:05,106 INFO [Shutdown] [] redolog - Logged: 498181 items, 32.454ms/item
2009-11-20 19:11:05,106 INFO [Shutdown] [] extensions - Destroying extensions
2009-11-20 19:11:05,198 INFO [Shutdown] [] extensions - Destroyed extension com_zimbra_bulkprovision:

com.zimbra.bp.ZimbraBulkProvisionExt...extension.ZimbraExtensionClassLoader@6699176f
2009-11-20 19:11:05,205 INFO [Shutdown] [] extensions - Destroyed extension nginx-lookup:

com.zimbra.cs.nginx.NginxLookupExten...extension.ZimbraExtensionClassLoader@7aba175f
2009-11-20 19:11:05,205 INFO [Shutdown] [] extensions - Destroyed extension zimbrasamba:

com.zimbra.ldaputils.ZimbraLDAPUtils...extension.ZimbraExtensionClassLoader@20823c6d
2009-11-20 19:11:05,206 INFO [Shutdown] [] extensions - Destroyed extension clamscanner:

com.zimbra.clam.ClamScanner@com.zimb...tensio n.ZimbraExtensionClassLoader@78871e65
2009-11-20 19:11:05,206 INFO [Shutdown] [] extensions - Destroyed extension com_zimbra_cert_manager:

com.zimbra.cert.ZimbraCertMgrExt@com...t ension.ZimbraExtensionClassLoader@4e0a39de
2009-11-20 19:11:05,206 INFO [Shutdown] [] index - Shutting down IndexHelper thread pools....
2009-11-20 19:11:05,206 INFO [Shutdown] [] index - ...ReIndexing threadpool shutdown completed.
2009-11-20 19:11:05,216 INFO [Shutdown] [] index - ...IndexingCompleted threadpool shutdown completed.
2009-11-20 19:11:05,216 INFO [IncomingDirectorySweeper] [] store - IncomingDirectorySweeper thread exiting
2009-11-20 19:11:05,228 WARN [Shutdown] [] ZimbraHttpConnectionManager - shutting down http client idle connection reaper thread
2009-11-20 19:11:05,242 INFO [Shutdown] [] soap - Servlet SoapServlet shutting down
2009-11-20 19:11:05,361 INFO [Shutdown] [] log - Shutdown hook complete
2009-11-20 19:22:56,426 INFO [main] [] soap - Servlet SoapServlet starting up

[Burn]

and I'm getting the same on 6.0.4 OSE edition. Google search on this error suggests there's something wrong with mysql_install_db. Any pointers?

[greenrenault]

Same error, still looking for a solution. Ubuntu 8.10 LTS, Zimbra 6.06 FOSS.

Unknown suffix 'P' used for variable 'port' (value '6PuWfUZsU9gWx1NxFvWbBkzuuKGQNp')
/opt/zimbra/mysql/bin/mysql: Error while setting value '6PuWfUZsU9gWx1NxFvWbBkzuuKGQNp' to 'port'
Unknown suffix 'P' used for variable 'port' (value 
/opt/zimbra/mysql/bin/mysql: Error while setting value '6PuWfUZsU9gWx1NxFvWbBkzuuKGQNp' to 'port'
Stopping mysqld...failed.

[veronica]

Hope you have port value in my.cnf file as:-
port = 7306

If this value is missing then value specified in MYSQL_TCP_PORT environmental variable is recognized the TCP port for connecting servers which is 13306.

[cvidal]

This looks like a bug in zmstorectl. At the beginning of the script it defines:

MYSQL="${zimbra_home}/bin/mysql -u zimbra -P ${zimbra_mysql_password}"

This is wrong, '-P' is used to indicate the port, not the password. Also, the script ${zimbra_home}/bin/mysql already sets the correct user, password and socket.

The problem with this is that "flushDirtyPages()" fails when MySQL is stopped.

The solution is to define MYSQL as:

MYSQL="${zimbra_home}/bin/mysql"

I have just posted this as bug 48702.

This happens only on the Open Source edition, NE is OK (at least the OS for RHEL5).