Discussion:
A Zenoss error has occurred
Rodrigo Mohr
2012-11-29 14:48:24 UTC
Permalink
Rodrigo Mohr [http://community.zenoss.org/people/rodmohr] created the discussion

"A Zenoss error has occurred"

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

--------------------------------------------------------------
Hello,

I am using Zenoss version 4.2.0, running in a Ubuntu 12.04 server.

It was working fine since yesterday, but now I am getting the following error:

Type: <class 'zenoss.protocols.services.ServiceResponseError'>
Value: 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.

Traceback (most recent call last):
  File "/usr/local/zenoss/lib/python/ZPublisher/Publish.py", line 126, in publish
    request, bind=1)
  File "/usr/local/zenoss/lib/python/ZPublisher/mapply.py", line 77, in mapply
    if debug is not None: return debug(object,args,context)
  File "/usr/local/zenoss/lib/python/ZPublisher/Publish.py", line 46, in call_object
    result=apply(object,args) # Type s<cr> to step into published object.
  File "/usr/local/zenoss/lib/python/Products/Five/browser/metaconfigure.py", line 476, in __call__
    return self.index(*args, **kw)
  File "/usr/local/zenoss/lib/python/Products/Five/browser/pagetemplatefile.py", line 125, in __call__
    return self.im_func(im_self, *args, **kw)
  File "/usr/local/zenoss/Products/ZenWidgets/FileGzipper.py", line 82, in __call__
    return original(self, __instance, *args, **keywords)
  File "/usr/local/zenoss/lib/python/Products/Five/browser/pagetemplatefile.py", line 59, in __call__
    sourceAnnotations=getattr(debug_flags, 'sourceAnnotations', 0),
  File "/usr/local/zenoss/lib/python/zope/pagetemplate/pagetemplate.py", line 132, in pt_render
    strictinsert=0, sourceAnnotations=sourceAnnotations
  File "/usr/local/zenoss/lib/python/zope/pagetemplate/pagetemplate.py", line 240, in __call__
    interpreter()
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 266, in __call__
    self.interpret(self.program)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 338, in interpret
    handlers[opcode](self, args)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 883, in do_useMacro
    self.interpret(macro)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 338, in interpret
    handlers[opcode](self, args)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 528, in do_optTag_tal
    self.do_optTag(stuff)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 513, in do_optTag
    return self.no_tag(start, program)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 508, in no_tag
    self.interpret(program)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 338, in interpret
    handlers[opcode](self, args)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 883, in do_useMacro
    self.interpret(macro)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 338, in interpret
    handlers[opcode](self, args)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 528, in do_optTag_tal
    self.do_optTag(stuff)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 513, in do_optTag
    return self.no_tag(start, program)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 508, in no_tag
    self.interpret(program)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 338, in interpret
    handlers[opcode](self, args)
  File "/usr/local/zenoss/lib/python/zope/tal/talinterpreter.py", line 737, in do_insertStructure_tal
    structure = self.engine.evaluateStructure(expr)
  File "/usr/local/zenoss/lib/python/Products/PageTemplates/Expressions.py", line 218, in evaluateStructure
    text = super(ZopeContext, self).evaluateStructure(expr)
  File "/usr/local/zenoss/lib/python/zope/tales/tales.py", line 696, in evaluate
    return expression(self)
  File "/usr/local/zenoss/lib/python/zope/contentprovider/tales.py", line 80, in __call__
    return provider.render()
  File "/usr/local/zenoss/Products/ZenUI3/utils/javascript.py", line 28, in render
    raw_js = '\n'.join(v.render() for v in self.viewlets)
  File "/usr/local/zenoss/Products/ZenUI3/utils/javascript.py", line 28, in <genexpr>
    raw_js = '\n'.join(v.render() for v in self.viewlets)
  File "/usr/local/zenoss/Products/ZenUI3/utils/javascript.py", line 40, in render
    return self.snippet()
  File "/usr/local/zenoss/Products/ZenUI3/browser/eventconsole/grid.py", line 159, in snippet
    defs = column_config(self.request, archive=archive)
  File "/usr/local/zenoss/Products/ZenUI3/browser/eventconsole/grid.py", line 115, in column_config
    columns = _find_column_definitions(archive)
  File "/usr/local/zenoss/Products/ZenUI3/browser/eventconsole/grid.py", line 71, in _find_column_definitions
    details = getFacade('zep').getUnmappedDetails()
  File "/usr/local/zenoss/Products/Zuul/facades/zepfacade.py", line 656, in getUnmappedDetails
    return getDetailsInfo().getUnmappedDetails()
  File "/usr/local/zenoss/Products/Zuul/facades/zepfacade.py", line 811, in getUnmappedDetails
    self._initDetails()
  File "/usr/local/zenoss/Products/Zuul/facades/zepfacade.py", line 769, in _initDetails
    response, content = self._configClient.getDetails()
  File "/usr/local/zenoss/lib/python/zenoss/protocols/services/zep.py", line 257, in getDetails
    return self.client.get('index_details')
  File "/usr/local/zenoss/lib/python/zenoss/protocols/services/__init__.py", line 181, in get
    return self._request(path, method='GET', params=params, headers=headers)
  File "/usr/local/zenoss/lib/python/zenoss/protocols/services/__init__.py", line 160, in _request
    response, content = self._executeRequest(request)
  File "/usr/local/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.

I have configured a network just to try using Zenoss, I have only 2 devices configured.

This looks to be a problem in my sql file but I don't have a clue on what problem that would be..

Thank you for the help.
--------------------------------------------------------------

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

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]
jmp242
2012-11-29 15:32:49 UTC
Permalink
jmp242 [http://community.zenoss.org/people/jmp242] created the discussion

"Re: A Zenoss error has occurred"

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

--------------------------------------------------------------
How did you get Zenoss 4.2 on Ubuntu? I'm only aware of it being available for RHEL ...Maybe try on that OS?

Also, make sure you install SP1.

--
James Pulver
ZCA Member
LEPP Computer Group
Cornell University
--------------------------------------------------------------

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

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]
Rodrigo Mohr
2012-11-29 15:38:34 UTC
Permalink
Rodrigo Mohr [http://community.zenoss.org/people/rodmohr] created the discussion

"Re: A Zenoss error has occurred"

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

--------------------------------------------------------------
I managed to make the install work using the link below:
http://community.zenoss.org/message/69806#69806 http://community.zenoss.org/message/69806

Unfortunatelly, changing the OS is not an option for me.

It was working fine prior to yesterday, with the network monitoring working fine but I guess there might me a problem between mysql/ubuntu/zenoss.
Trying to figure out where..

This error is happening everytime after login, so I am not able to do anything.

I will install SP1 to see if it is fixed.
--------------------------------------------------------------

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

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]
jmp242
2012-11-29 15:40:35 UTC
Permalink
jmp242 [http://community.zenoss.org/people/jmp242] created the discussion

"Re: A Zenoss error has occurred"

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

--------------------------------------------------------------
Hmm, well that poster is probably the only one using Ubuntu, so ask him?

--
James Pulver
ZCA Member
LEPP Computer Group
Cornell University
--------------------------------------------------------------

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

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]
Rodrigo Mohr
2012-11-29 15:50:17 UTC
Permalink
Rodrigo Mohr [http://community.zenoss.org/people/rodmohr] created the discussion

"Re: A Zenoss error has occurred"

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

--------------------------------------------------------------
Installing SP1 resolved my problem! :D

Thank you for the help.
--------------------------------------------------------------

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

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]
Philip Warren
2012-11-29 16:09:23 UTC
Permalink
Philip Warren [http://community.zenoss.org/people/pwarren] created the discussion

"Re: A Zenoss error has occurred"

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

--------------------------------------------------------------
From your original problem description, you are likely running into this problem (which is not resolved in SP1 unfortunately). Follow the steps in this post to enable validation on the database connection pool which should avoid this issue:

http://community.zenoss.org/message/68940#68940#68940 http://community.zenoss.org/message/68940#68940

-- Philip
--------------------------------------------------------------

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

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]
Rodrigo Mohr
2012-12-01 13:21:15 UTC
Permalink
Rodrigo Mohr [http://community.zenoss.org/people/rodmohr] created the discussion

"Re: A Zenoss error has occurred"

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

--------------------------------------------------------------
Thank you all!

I have implemented all this changes and the problem stopped happening.
--------------------------------------------------------------

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

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]
hydruid
2013-04-30 14:34:28 UTC
Permalink
hydruid [http://community.zenoss.org/people/hydruid] created the discussion

"Re: A Zenoss error has occurred"

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

--------------------------------------------------------------
I am definitely not the only one using Ubuntu :)
--------------------------------------------------------------

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

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