Zenoss 4.2 - Unable to acknowledge events

[pperreault]

pperreault [http://community.zenoss.org/people/pperreault] created the discussion

"Zenoss 4.2 - Unable to acknowledge events"

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

--------------------------------------------------------------
I'm testing Zenoss with a 4.2 build on a Centos VM.  I receive the error shown below when attempting to acknowledge events.  I haven't found anything in the forums pertaining to this issue.  Any help pointing me in the right direction to resolve this is appreciated.

------
2012-09-30T17:39:18 INFO extdirect Direct request failed: org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed by the driver.: EventsRouter.acknowledge [{'evids': ['000c2959-ce8b-b059-11e1-f1142efc1d9f'], 'params': {'eventState': [0, 1], 'severity': [5, 4, 3, 2]}, 'limit': 100, 'excludeIds': {}}]
------
2012-09-30T17:39:18 INFO extdirect DirectRouter suppressed the following exception (Response 44d5a41c-f616-4a8d-bcd0-16e7d681af39):
Traceback (most recent call last):
  File "/opt/zenoss/Products/ZenUtils/extdirect/router.py", line 180, in _processDirectRequest
    response.result = _targetfn(**data)
  File "<string>", line 2, in acknowledge
  File "/opt/zenoss/Products/Zuul/decorators.py", line 69, in wrapped_fn
    return f(self, *args, **kwargs)
  File "/opt/zenoss/Products/Zuul/routers/zep.py", line 537, in acknowledge
    limit=limit,
  File "/opt/zenoss/Products/Zuul/facades/zepfacade.py", line 410, in acknowledgeEventSummaries
    limit)
  File "/opt/zenoss/lib/python/zenoss/protocols/services/zep.py", line 162, in acknowledgeEventSummaries
    limit=limit)
  File "/opt/zenoss/lib/python/zenoss/protocols/services/zep.py", line 102, in updateEventSummaries
    search_uuid = self.createSavedSearch(event_filter=event_filter, exclusion_filter=exclusion_filter, timeout=timeout)
  File "/opt/zenoss/lib/python/zenoss/protocols/services/zep.py", line 191, in createSavedSearch
    status, response = self.client.post(url, query)
  File "/opt/zenoss/lib/python/zenoss/protocols/services/__init__.py", line 175, in post
    return self._request_with_body(path, method='POST', body=body, params=params, headers=headers)
  File "/opt/zenoss/lib/python/zenoss/protocols/services/__init__.py", line 170, in _request_with_body
    response, content = self._executeRequest(request)
  File "/opt/zenoss/lib/python/zenoss/protocols/services/__init__.py", line 154, in _executeRequest
    raise ServiceResponseError(response.reason, response.status, request, response, content)
ServiceResponseError: org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed by the driver.



******
Version info
******

| Zenoss (http://www.zenoss.com/) | Zenoss 4.2.0 |
| OS (http://www.tldp.org/) | Linux (x86_64) 2.6.32 (Linux **** 2.6.32-279.el6.x86_64 #1 SMP Fri Jun 22 12:19:21 UTC 2012 x86_64) |
| Zope (http://www.zope.org/) | Zope 2.13.13 |
| Python (http://www.python.org/) | Python 2.7.2 |
| Database (http://www.mysql.com/) | MySQL 5.5.27 (Ver 5.5.27) |
| RRD (http://oss.oetiker.ch/rrdtool) | RRDtool 1.4.7 |
| Twisted (http://twistedmatrix.com/trac) | Twisted 11.0.0 |
| RabbitMQ (http://www.rabbitmq.com/) | RabbitMQ 2.8.4 |
| Erlang (http://www.erlang.org/) | Erlang 5.8.5 |
| NetSnmp (http://net-snmp.sourceforge.net/) | NetSnmp 5.5.0 |
| PyNetSnmp (http://www.zenoss.com/) | PyNetSnmp 0.30.3 |
| WMI (http://www.zenoss.com/) | Wmi 1.3.15 |
--------------------------------------------------------------

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

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]

[jshardlow]

jshardlow [http://community.zenoss.org/people/jshardlow] created the discussion

"Re: Zenoss 4.2 - Unable to acknowledge events"

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

--------------------------------------------------------------
I *think* this may be caused by zeneventserver losing contact with MySQL. If I'm on the right track, then according to this thread http://community.zenoss.org/thread/18427 http://community.zenoss.org/thread/18427 you may need to make a tweak:

In the $ZENHOME/etc/zeneventserver.conf uncomment the line zep.jdbc.pool.test_on_borrow=false and set zep.jdbc.pool.test_on_borrow=false to true.
Stop zenoss then stop mysqld. Delete the ib_logfile0 and ib_logfile1 in the mysql data directory. Start mysql and verify you can connect. If all is well, start zenoss.
--------------------------------------------------------------

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

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]