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

Mysql error (Unknown column 'D.hostname' in 'order clause' )

Details

    • Bug
    • Resolution: Fixed
    • Major
    • None
    • None
    • Default
    • None

    Description

      I see the error below in the Mysql logs
      Can this be fixed?

      Error during query on (40,tools-db-master,3306,8566287) , user "tools_observium_rw@10.106.36.186" , schema "observium" , 1054, Unknown column 'D.hostname' in 'order clause' . digest_text = "SELECT * FROM `bgpPeers` LEFT JOIN `devices` USING(`device_id`) WHERE `status` = ? AND `bgpPeerAdminStatus` IN (?,?) AND `bgpPeerState` != ? AND ((`device_id` IS NOT ?)) ORDER BY D.`hostname` ASC"

      Attachments

        Activity

          [OBS-4958] Mysql error (Unknown column 'D.hostname' in 'order clause' )
          Shama Tarek added a comment -

          Thanks
          When is the release date for this version?
          I dont see year 2025 in this page https://changelog.observium.org/ 

          Shama Tarek added a comment - Thanks When is the release date for this version? I dont see year 2025 in this page https://changelog.observium.org/  
          landy Mike Stupalov made changes -
          Issue Type Original: Help [ 10200 ] New: Bug [ 1 ]
          Resolution New: Fixed [ 1 ]
          Status Original: In Progress [ 3 ] New: Resolved [ 5 ]
          landy Mike Stupalov added a comment -

          Fixed in r13815.

          landy Mike Stupalov added a comment - Fixed in r13815.
          landy Mike Stupalov made changes -
          Status Original: In Review [ 10101 ] New: In Progress [ 3 ]
          Shama Tarek added a comment -

          I am running the below enviorment

          Shama Tarek added a comment - I am running the below enviorment
          landy Mike Stupalov made changes -
          Status Original: Pending Response [ 10000 ] New: In Review [ 10101 ]
          Shama Tarek made changes -
          Attachment New: image-2025-01-08-12-45-58-353.png [ 21557 ]
          bot Observium Bot made changes -
          Status Original: Open [ 1 ] New: Pending Response [ 10000 ]
          Shama Tarek created issue -
          bot Observium Bot added a comment -

          General questions and device support can be discussed in our Discord channel, click here to join.

          Please make and attach additional information about the device:

          • full snmp dump from device: 

            snmpwalk -v2c -c <community> -t 3 -Cc --hexOutputLength=0 -Ih -ObentxU <hostname> .1 > myagent.snmpwalk
            		 
            snmpwalk -v2c -c <community> -t 3 -Cc --hexOutputLength=0 -Ih -ObentxU <hostname> .1.3.6.1.4.1 >> myagent.snmpwalk

            If device not support SNMP version 2c, replace -v2c with -v1.

          • If you have problems with discovery or poller processes, please do and attach these debugs: 

            ./discovery.php -d -h <device>
            		 
            ./poller.php -d -h <device>

          • additionally attach device and/or vendor specific MIB files

          This comment is added automatically.

          bot Observium Bot added a comment - General questions and device support can be discussed in our Discord channel, click here to join . Please make and attach additional information about the device: full snmp dump from device: snmpwalk -v2c -c <community> -t 3 -Cc --hexOutputLength=0 -Ih -ObentxU <hostname> .1 > myagent.snmpwalk snmpwalk -v2c -c <community> -t 3 -Cc --hexOutputLength=0 -Ih -ObentxU <hostname> .1.3.6.1.4.1 >> myagent.snmpwalk If device not support SNMP version 2c, replace -v2c with -v1. If you have problems with discovery or poller processes, please do and attach these debugs: ./discovery.php -d -h <device> ./poller.php -d -h <device> additionally attach device and/or vendor specific MIB files This comment is added automatically.

          People

            landy Mike Stupalov
            Shama Tarek
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: