Receiving ParserError from Livestatus

[jodiecunningham]

It helps when I post in the right project. In /adagios/status:

 ParserError: "Error '400' from livestatus: invalid filter: table 'services' has no column 'columns'" 

Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/adagios/views.py", line 20, in wrapper
    result = fn(*args, **kwargs)
  File "/usr/lib/python2.6/site-packages/adagios/status/views.py", line 604, in status_index
    c = adagios.status.utils.get_statistics(request)
  File "/usr/lib/python2.6/site-packages/adagios/status/utils.py", line 243, in get_statistics
    'Stats: state = 1', 'Stats: state = 2', 'Stats: state = 3', *arguments, columns=False)
  File "/usr/lib/python2.6/site-packages/pynag/Parsers/__init__.py", line 1612, in query
    raise ParserError("Error '%s' from livestatus: %s" % (return_code, error_message))
ParserError: "Error '400' from livestatus: invalid filter: table 'services' has no column 'columns'"

Fresh install yesterday RHEL Server 6.5 okconfig-1.2.3-1.git.8.0eeca51.el6.noarch mk-livestatus-1.2.2-3.git.1177.22baef4.el6.x86_64 adagios-1.3.1-1.git.190.9322b6d.el6.noarch

[hakong]

Same error here :( nagios-3.5.1-1.el6.x86_64 adagios-1.3.1-1.git.190.9322b6d.el6.noarch okconfig-1.2.3-1.git.8.0eeca51.el6.noarch mk-livestatus-1.2.2-3.git.1177.22baef4.el6.x86_64 pnp4nagios-0.6.20-1.el6.x86_64

[hakong]

Fixed it (temporarily) by downgrading pynag.

[root@adagios ~]# yum downgrade pynag [root@adagios ~]# service nagios restart; service httpd restart; service npcd restart

[palli]

The issue is fixed if you update either adagios or pynag to latest git version.

yum clean all --enablerepo=ok-testing 
yum update adagios pynag --enablerepo=ok-testing

[palli]

Dont hesitate to reopen the issue if you still have problems. Closing for now.

[hakong]

I'm having a lot of green problems :D

[hakong]

And this:

Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/adagios/views.py", line 20, in wrapper
    result = fn(*args, **kwargs)
  File "/usr/lib/python2.6/site-packages/adagios/status/views.py", line 604, in status_index
    c = adagios.status.utils.get_statistics(request)
  File "/usr/lib/python2.6/site-packages/adagios/status/utils.py", line 243, in get_statistics
    'Stats: state = 1', 'Stats: state = 2', 'Stats: state = 3', *arguments, columns=False)
TypeError: query() got multiple values for keyword argument 'columns'

[palli]

woh that looks slightly off. Please update pynag to at least git commit 9a716b74847d0b26298337d5b48f794aff9fd58c.

Also i can tell from the traceback your version of adagios is not latest which might be causing some of your problems.

[hakong]

Updated pynag to 0.8.1-1.git.72.9a716b7.el6, works well now.

[jodiecunningham]

Initially had the same issue as hakong, but I pulled 9a716b7 from ok-testing and it looks like it works great now.

Thanks for the quick response!