MySQL Disk Space Issue Broke 'Devices' Tab

[Zeus Branigan]

Zeus Branigan [http://community.zenoss.org/people/zbranigan] created the discussion

"MySQL Disk Space Issue Broke 'Devices' Tab"

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

--------------------------------------------------------------
Running Zenoss Core 4.2.4 on
CentOS release 5.4 Kernel 2.6.18-164.el5 x86_64
VMware VM

I have been running Zenoss successfully since 4.2.3 until I ran out of disk space on the vg_root-lv_root filesystem.  I solved that issue using Lauren Malhoit's very helpful guide over at TechRepublic, and Zenoss began functioning normally again. 

A few months later I was faced with the same low disk space problem on the vg_root-lv_var_lib_mysql filesystem.  I used a guide found here to expand the volume.
http://www.linuxquestions.org/questions/fedora-35/lvm-partition-resizing-666683/ http://www.linuxquestions.org/questions/fedora-35/lvm-partition-resizing-666683/

After completing the expansion, everything seemed to work well until I went to "Infrastructure" "Devices".  There I am met with the following error:

*Type: <type 'exceptions.TypeError'>*
*Value: <Products.ZenUtils.extdirect.router.DirectResponse object at 0xb874c90> is not JSON serializable*
Traceback (most recent call last):
File "/opt/zenoss/lib/python/ZPublisher/Publish.py", line 126, in publish request, bind=1)
File "/opt/zenoss/lib/python/ZPublisher/mapply.py", line 77, in mapply if debug is not None: return debug(object,args,context)
File "/opt/zenoss/lib/python/ZPublisher/Publish.py", line 46, in call_object result=apply(object,args) # Type s<cr> to step into published object.
File "/opt/zenoss/lib/python/Products/Five/browser/pagetemplatefile.py", line 125, in __call__ return self.im_func(im_self, *args, **kw)
File "/opt/zenoss/Products/ZenWidgets/FileGzipper.py", line 82, in __call__ return original(self, __instance, *args, **keywords)
File "/opt/zenoss/lib/python/Products/Five/browser/pagetemplatefile.py", line 59, in __call__ sourceAnnotations=getattr(debug_flags, 'sourceAnnotations', 0),
File "/opt/zenoss/lib/python/zope/pagetemplate/pagetemplate.py", line 132, in pt_render strictinsert=0, sourceAnnotations=sourceAnnotations
File "/opt/zenoss/lib/python/zope/pagetemplate/pagetemplate.py", line 240, in __call__ interpreter()
File "/opt/zenoss/lib/python/zope/tal/talinterpreter.py", line 266, in __call__ self.interpret(self.program)
File "/opt/zenoss/lib/python/zope/tal/talinterpreter.py", line 338, in interpret handlers[opcode](self, args)
File "/opt/zenoss/lib/python/zope/tal/talinterpreter.py", line 883, in do_useMacro self.interpret(macro)
File "/opt/zenoss/lib/python/zope/tal/talinterpreter.py", line 338, in interpret handlers[opcode](self, args)
File "/opt/zenoss/lib/python/zope/tal/talinterpreter.py", line 941, in do_defineSlot self.interpret(slot)
File "/opt/zenoss/lib/python/zope/tal/talinterpreter.py", line 338, in interpret handlers[opcode](self, args)
File "/opt/zenoss/lib/python/zope/tal/talinterpreter.py", line 528, in do_optTag_tal self.do_optTag(stuff)
File "/opt/zenoss/lib/python/zope/tal/talinterpreter.py", line 513, in do_optTag return self.no_tag(start, program)
File "/opt/zenoss/lib/python/zope/tal/talinterpreter.py", line 508, in no_tag self.interpret(program)
File "/opt/zenoss/lib/python/zope/tal/talinterpreter.py", line 338, in interpret handlers[opcode](self, args)
File "/opt/zenoss/lib/python/zope/tal/talinterpreter.py", line 615, in do_insertText_tal text = self.engine.evaluateText(stuff[0])
File "/opt/zenoss/lib/python/Products/PageTemplates/Expressions.py", line 225, in evaluateText text = self.evaluate(expr)
File "/opt/zenoss/lib/python/zope/tales/tales.py", line 696, in evaluate return expression(self)
File "/opt/zenoss/lib/python/zope/tales/expressions.py", line 217, in __call__ return self._eval(econtext)
File "/opt/zenoss/lib/python/Products/PageTemplates/Expressions.py", line 155, in _eval return render(ob, econtext.vars)
File "/opt/zenoss/lib/python/Products/PageTemplates/Expressions.py", line 117, in render ob = ob()
File "/opt/zenoss/Products/ZenUI3/browser/pages.py", line 39, in getTrees """ % (json.dumps(deviceTree),
File "/opt/zenoss/lib/python2.7/json/__init__.py", line 231, in dumps return _default_encoder.encode(obj)
File "/opt/zenoss/lib/python2.7/json/encoder.py", line 201, in encode chunks = self.iterencode(o, _one_shot=True)
File "/opt/zenoss/lib/python2.7/json/encoder.py", line 264, in iterencode return _iterencode(o, 0)
File "/opt/zenoss/lib/python2.7/json/encoder.py", line 178, in default raise
TypeError(repr(o) + " is not JSON serializable")
TypeError: <Products.ZenUtils.extdirect.router.DirectResponse object at 0xb874c90> is not JSON serializable


All other tabs work well.  Even under the Infrastructure tab, the other tabs show accurate data and events are logged.  Any help with this issue is greatly appreciated.  Happy to provide any additional information that may help with the issue.

Thank You
--------------------------------------------------------------

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

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

[hydruid]

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

"Re: MySQL Disk Space Issue Broke 'Devices' Tab"

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

--------------------------------------------------------------
Are you still using the pre-built vmware image?
--------------------------------------------------------------

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

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

[Zeus Branigan]

Zeus Branigan [http://community.zenoss.org/people/zbranigan] created the discussion

"Re: MySQL Disk Space Issue Broke 'Devices' Tab"

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

--------------------------------------------------------------
Yes.  I used an image from http://sourceforge.net/projects/zenoss/

Thanks.
--------------------------------------------------------------

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

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

[hydruid]

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

"Re: MySQL Disk Space Issue Broke 'Devices' Tab"

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

--------------------------------------------------------------
Those pre-built images are only designed to be used for demo and
evaluation. I highly recommend migrating to a full install!
--------------------------------------------------------------

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

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

[Zeus Branigan]

Zeus Branigan [http://community.zenoss.org/people/zbranigan] created the discussion

"Re: MySQL Disk Space Issue Broke 'Devices' Tab"

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

--------------------------------------------------------------
Well, thats unfortunate.  Hoped there would be a silver bullet.  Never crossed my mind that the VM was for temp install purposes.  Seemed to serve our needs quite well for the last year or so, and even accepted the upgrades without a hitch.

Does the error seem to indicate whether the database is healthy enough for a migration?

Thanks again for your insight.
--------------------------------------------------------------

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

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

[hydruid]

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

"Re: MySQL Disk Space Issue Broke 'Devices' Tab"

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

--------------------------------------------------------------
There is only one way to find out.....it would probably be fine! Take a
look at this link, might lead you in the correct path on getting your
current install fixed: http://community.zenoss.org/thread/16746 http://community.zenoss.org/thread/16746

Also wouldn't hurt to re-index and run zenchkrels!
--------------------------------------------------------------

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

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

[Zeus Branigan]

Zeus Branigan [http://community.zenoss.org/people/zbranigan] created the discussion

"Re: MySQL Disk Space Issue Broke 'Devices' Tab"

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

--------------------------------------------------------------
I will try those steps today if time permits and post the results.

Thanks again.
--------------------------------------------------------------

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

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

[Zeus Branigan]

Zeus Branigan [http://community.zenoss.org/people/zbranigan] created the discussion

"Re: MySQL Disk Space Issue Broke 'Devices' Tab"

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

--------------------------------------------------------------
I tried the following steps:

reindex
commit
zenchkrels
zenoss-repair.py from https://gist.github.com/danielrobbins/3091770 https://gist.github.com/danielrobbins/3091770

No Joy.

I will reinstall.

Thank you for all the assistance
--------------------------------------------------------------

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

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

[hydruid]

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

"Re: MySQL Disk Space Issue Broke 'Devices' Tab"

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

--------------------------------------------------------------
You might just try doing a backup and restoring on another machine!
--------------------------------------------------------------

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

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

[Zeus Branigan]

Zeus Branigan [http://community.zenoss.org/people/zbranigan] created the discussion

"Re: MySQL Disk Space Issue Broke 'Devices' Tab"

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

--------------------------------------------------------------
That sounds like a solid plan.

Thanks again.
--------------------------------------------------------------

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

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