Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-1791

Database Errors (failed queries)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • None
    • Professional Edition
    • Poller
    • CentOS distribution

    Description

      We had a rather strange issue today; our SSD SAN was getting over 40k IO from a single VM. Turned out our observium poller was taking up around 30k io and a reset was required.

      Once it was available again; the only thing we see is that the database error file is around 2gb filled with:

      [2016/04/06 22:42:18 +0200] poller.php(27113): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:18 +0200] poller.php(27113): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:18 +0200] poller.php(27113): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:18 +0200] poller.php(27113): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:18 +0200] poller.php(27113): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:18 +0200] poller.php(27113): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:18 +0200] poller.php(27113): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''
      [2016/04/06 22:42:25 +0200] poller.php(27823): Failed dbQuery (#1054 - Unknown column 'svcgrpmember_id' in 'where clause'), Query: DELETE FROM `netscaler_servicegroupmembers` WHERE `svcgrpmember_id` = ''

      Attachments

        Activity

          People

            landy Mike Stupalov
            rendest Stef Renders
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: