Discussion:
zeneventserver losing connecting with mysql
OneLoveAmaru
2012-10-08 15:28:42 UTC
Permalink
OneLoveAmaru [http://community.zenoss.org/people/OneLoveAmaru] created the discussion

"zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68890#68890

--------------------------------------------------------------
Hi Guys, I'm having a problem with Zenoss 4.2.0 SP1. It seems zeneventserver keeps blowing up and losing connection to mysql.

Here is a snitip of the logs. Any help would really be appreciated.


2012-09-27T02:36:53.620 [ZEP_EVENT_TIME_PURGER] INFO  org.zenoss.utils.dao.impl.MySqlRangePartitioner - Pruning table event_time partition p20120926_060000: prune timestamp 2012-09-26 02:36:53.62
2012-09-27T02:36:53.863 [ZEP_EVENT_TIME_PURGER] INFO  org.zenoss.utils.dao.impl.MySqlRangePartitioner - Adding partition p20120927_080000 to table event_time

2012-09-27T02:44:27.572 [ZEP2] ERROR org.springframework.transaction.interceptor.TransactionInterceptor - Application exception overridden by rollback exception
org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [SELECT uuid FROM event_summary WHERE last_seen <= ? AND clear_fingerprint_hash IN (?) AND status_id NOT IN (?, ?, ?) FOR UPDATE]; The last packet successfully received from the server was 37,601,700 milliseconds ago.  The last packet sent successfully to the server was 37,601,701 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 37,601,700 milliseconds ago.  The last packet sent successfully to the server was 37,601,701 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
        at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:98) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:701) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:165) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:171) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:178) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.zenoss.zep.dao.impl.EventSummaryDaoImpl.clearEvents(EventSummaryDaoImpl.java:341) ~[zep-core-1.2-SNAPSHOT.jar:na]
        at org.zenoss.zep.dao.impl.EventSummaryDaoImpl.create(EventSummaryDaoImpl.java:165) ~[zep-core-1.2-SNAPSHOT.jar:na]
        at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source) ~[na:na]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_31]
        at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_31]
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) ~[spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) ~[spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
        at $Proxy24.create(Unknown Source) [na:na]
        at org.zenoss.zep.impl.EventProcessorImpl.processEvent(EventProcessorImpl.java:113) [zep-core-1.2-SNAPSHOT.jar:na]
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68890#68890]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
Shane Scott
2012-10-08 15:30:34 UTC
Permalink
Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68895#68895

--------------------------------------------------------------
OneLoveAmaru:

What version of rabbitmq are you running? Is rabbit running and how full is your root disk? Can you post your mysql.cnf?

Best,
--Shane Scott (Hackman238)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68895#68895]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
OneLoveAmaru
2012-10-08 15:33:10 UTC
Permalink
OneLoveAmaru [http://community.zenoss.org/people/OneLoveAmaru] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68906#68906

--------------------------------------------------------------
[***@tmglxzen1 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root
                       12G  2.1G  8.8G  20% /
tmpfs                 1.9G   56K  1.9G   1% /dev/shm
/dev/sda1             485M   98M  362M  22% /boot
/dev/mapper/opt-zenoss
                       40G  1.4G   36G   4% /opt/zenoss
/dev/mapper/data-mysql
                       40G  498M   37G   2% /var/lib/mysql

[***@tmglxzen1 ~]# yum info rabbitmq
Installed Packages
Name        : rabbitmq-server
Arch        : noarch
Version     : 2.8.4
Release     : 1
Size        : 3.2 M
Repo        : installed
From repo   : /rabbitmq-server-2.8.4-1.noarch
Summary     : The RabbitMQ server
URL         : http://www.rabbitmq.com/ http://www.rabbitmq.com/
License     : MPLv1.1
Description : RabbitMQ is an implementation of AMQP, the emerging standard for high
            : performance enterprise messaging. The RabbitMQ server is a robust and
            : scalable implementation of an AMQP broker.


[***@tmglxzen1 ~]# cat /etc/my.cnf
[mysqld]
max_connections = 2000
max_allowed_packet=32M
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68906#68906]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
Shane Scott
2012-10-08 15:35:49 UTC
Permalink
Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68897#68897

--------------------------------------------------------------
OneLove:

Let's do a few things. First, upgrade to rabbitmq-server 2.8.6-1, at a minimum. What version of mysqld are you running? I'd like to give you a better cnf that leverages the mysql thread_pool plugin.

Best,
--Shane Scott (Hackman238)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68897#68897]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
OneLoveAmaru
2012-10-08 15:37:37 UTC
Permalink
OneLoveAmaru [http://community.zenoss.org/people/OneLoveAmaru] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68907#68907

--------------------------------------------------------------
Server version: 5.5.27 MySQL Community Server (GPL)

I'll install rabbitmq 2.8.7 now, since that's the latest version from their website.

Thanks so much for the quick responses BTW!
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68907#68907]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
OneLoveAmaru
2012-10-08 15:41:01 UTC
Permalink
OneLoveAmaru [http://community.zenoss.org/people/OneLoveAmaru] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68908#68908

--------------------------------------------------------------
While I'm at it, I'm going to upgrade MySQL to 5.5.28.
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68908#68908]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
Shane Scott
2012-10-08 15:47:12 UTC
Permalink
Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68899#68899

--------------------------------------------------------------
OneLove:

Alrighty. Once done verify that thread_pool.so is in the plugins directory of your mysql server.

Backup your old mysql.cnf and create a new one with the following:

[mysqld]
socket = Value from your old conf
basedir =Value from your old conf
datadir =Value from your old conf
port = 3306
user = zenoss

innodb_file_per_table # <-- If your old conf does not have this, comment it out.
skip_external_locking

#
# Per the current Zenoss Resource Manager Install Guide,
# please size innodb_buffer_pool_size according to the following
# guidelines:
#
# Deployment Size       Value of innodb_buffer_pool_size
# --------------------  --------------------------------
#    1 to  250 devices   512M
#  250 to  500 devices   768M
#  500 to 1000 devices  1024M
# 1000 to 2000 devices  2048M
#
# If mysqld is installed on a dedicated system, this can (and should) be set
# to as much as 75% of available memory on the system.
#
innodb_buffer_pool_size = 2048M

# log file size should be 25% of of buffer pool size
innodb_log_file_size = 2000M
innodb_additional_mem_pool_size = 32M
innodb_log_buffer_size = 8M
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 2

# In previous releases of MySQL, this was recommended to be set to 2 times the
# number of CPUs, however the default and recommended option in 5.5 is to not
# set a bound on the thread pool size.
innodb_thread_concurrency = 0

# Setting this setting to 0 is recommended in virtualized environments. If
# running virtualized, it is recommended to uncomment the setting below when
# seeing database performance issues.
#innodb_spin_wait_delay = 0

# In large installs, there were a significant number of mutex waits on the
# adaptive hash index, and this needed to be disabled.
#innodb_adaptive_hash_index = OFF

# Use the Barracuda file format which enables support for dynamic and
# compressed row formats.
innodb_file_format = Barracuda

# Enable the thread pool plug-in - recommended on 5.5.16 and later.
plugin-load = thread_pool.so
thread_pool_size = 48

# Disable the query cache - it provides negligible performance improvements
# and leads to significant thread contention under load.
query_cache_size = 0
query_cache_type = OFF

max_allowed_packet = 64M
wait_timeout = 86400
interactive_timeout = 86400
max_connections = 1500
max_user_connections = 1500

# Enable dedicated purge thread. (default is 0)
innodb_purge_threads = 1

# Introduce operation lag to allow purge operations. (default is 0)
innodb_max_purge_lag = 100000

[client]
user = zenoss

[mysql]
max_allowed_packet = 64M

[mysqldump]
max_allowed_packet = 64M


Then stop mysql and start it. If there are errors, check the hostname.err file in the data directory and post the error.

Best,
--Shane Scott (Hackman238)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68899#68899]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
OneLoveAmaru
2012-10-08 18:41:41 UTC
Permalink
OneLoveAmaru [http://community.zenoss.org/people/OneLoveAmaru] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68911#68911

--------------------------------------------------------------
I made all of your reccomended changes but there is no thread_pool.so anywhere on the server. Where can I obtain that?
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68911#68911]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
Shane Scott
2012-10-08 18:53:00 UTC
Permalink
Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68929#68929

--------------------------------------------------------------
OneLove:

Oh dang, I forgot it's a commercial plugin. Use this cnf instead.

[mysqld]
innodb_file_per_table # <-- If your old conf does not have this, comment it out.
skip_external_locking

#
# Per the current Zenoss Resource Manager Install Guide,
# please size innodb_buffer_pool_size according to the following
# guidelines:
#
# Deployment Size Value of innodb_buffer_pool_size
# -------------------- --------------------------------
# 1 to 250 devices 512M
# 250 to 500 devices 768M
# 500 to 1000 devices 1024M
# 1000 to 2000 devices 2048M
#
# If mysqld is installed on a dedicated system, this can (and should) be set
# to as much as 75% of available memory on the system.
#
innodb_buffer_pool_size = 2048M

# log file size should be 25% of of buffer pool size
innodb_log_file_size = 2000M

innodb_additional_mem_pool_size = 32M
innodb_log_buffer_size = 8M
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 2

# Set to 2 times the number of CPUs which can be dedicated to mysql
innodb_thread_concurrency = 4

# Setting this setting to 0 is recommended in virtualized environments. If
# running virtualized, it is recommended to uncomment the setting below when
# seeing database performance issues.
#innodb_spin_wait_delay = 0

# In large installs, there were a significant number of mutex waits on the
# adaptive hash index, and this needed to be disabled.
#innodb_adaptive_hash_index = OFF

# Use the Barracuda file format which enables support for dynamic and
# compressed row formats.

innodb_file_format = Barracuda

# Disable the query cache - it provides negligible performance improvements
# and leads to significant thread contention under load.
query_cache_size = 0
query_cache_type = OFF

max_allowed_packet = 64M
wait_timeout = 86400
interactive_timeout = 86400
max_connections = 1500
max_user_connections = 1500

# Enable dedicated purge thread. (default is 0)
innodb_purge_threads = 1
innodb_max_purge_lag = 100000

[client]
user = zenoss

[mysql]
max_allowed_packet = 64M

[mysqldump]
max_allowed_packet = 64M
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68929#68929]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
OneLoveAmaru
2012-10-08 19:21:22 UTC
Permalink
OneLoveAmaru [http://community.zenoss.org/people/OneLoveAmaru] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68912#68912

--------------------------------------------------------------
OK, using your my.cnf settings and upgraded mysql and rabbitmq. I'll let you know in a couple days if that did it. It usually bugs out every 24 to 48hrs.
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68912#68912]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
Shane Scott
2012-10-08 19:22:25 UTC
Permalink
Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68930#68930

--------------------------------------------------------------
OneLoveL

Excellent. Can you also su zenoss then zenhub debug? This will ensure we get the most useful data from zenhub.

Keep me posted!

Best,
--Shane Scott (Hackman238)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68930#68930]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
OneLoveAmaru
2012-10-08 21:43:22 UTC
Permalink
OneLoveAmaru [http://community.zenoss.org/people/OneLoveAmaru] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68913#68913

--------------------------------------------------------------
I turned on zenhub debug as you suggested.

I'll let you know shortly how it turns out.

Thanks for all of the tips and super fast responses!
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68913#68913]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
pwarren
2012-10-09 12:48:47 UTC
Permalink
pwarren [http://community.zenoss.org/people/pwarren] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68939#68939

--------------------------------------------------------------
You are probably encountering this issue, which will be fixed in the next maintenance release:

http://jira.zenoss.com/jira/browse/ZEN-2937 http://jira.zenoss.com/jira/browse/ZEN-2937

Follow the workaround steps in Comment #1 to enable the test_on_borrow property for zeneventserver to enable database connection validation and recovery in zeneventserver.

--
Philip Warren
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68939#68939]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
Shane Scott
2012-10-09 14:05:29 UTC
Permalink
Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/68940#68940

--------------------------------------------------------------
Phil:

Wow, that'll definitely worsen it.  I haven't seen this occur in v4.2...yet, but I imagine it's only a matter of time. :)

Thanks Phil!

Best,
--Shane Scott (Hackman238)

OneLove:

As Phil suggests you may want to edit the $ZENHOME/etc/zeneventserver.conf and uncommong the line zep.jdbc.pool.test_on_borrow=false and set zep.jdbc.pool.test_on_borrow=false to true. Once done, su zenoss then zeneventserver stop then zeneventserver start.

Best,
--Shane Scott (Hackman238)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68940#68940]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
OneLoveAmaru
2012-10-11 17:22:01 UTC
Permalink
OneLoveAmaru [http://community.zenoss.org/people/OneLoveAmaru] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/69032#69032

--------------------------------------------------------------
I'm going to wait and see if our changes fix my problem first. If it continues then I'll impliment the fix from that ticket.
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/69032#69032]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
Shane Scott
2012-10-12 02:46:34 UTC
Permalink
Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/69060#69060

--------------------------------------------------------------
OneLove:

Alrighty.

--Shane Scott (Hackman238)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/69060#69060]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
OneLoveAmaru
2012-10-12 15:12:36 UTC
Permalink
OneLoveAmaru [http://community.zenoss.org/people/OneLoveAmaru] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/69069#69069

--------------------------------------------------------------
And it blew up again, so I implimented the fix from ZEN-2937.

Thanks for everyones help!
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/69069#69069]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
Shane Scott
2012-10-12 15:21:38 UTC
Permalink
Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: zeneventserver losing connecting with mysql"

To view the discussion, visit: http://community.zenoss.org/message/69113#69113

--------------------------------------------------------------
OneLove:

Can you post the zenhub, mysql and zeneventserver logs for the period when it blew up? Just incase this is a new bug  we'll wna tot look there.

Best,
--Shane Scott (Hackman238)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/69113#69113]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
Loading...