Description
Noticed some more errors during discovery
[2021/09/12 14:55:42 +0200] discovery.php(3583610): Failed dbQuery (#1136 - Column count doesn't match value count at row 1), Query: INSERT INTO `ports` (``) VALUES () ON DUPLICATE KEY UPDATE `if |
Vrf`=VALUES(`ifVrf`)[2021/09/12 15:44:47 +0200] discovery.php(531954): Failed dbQuery (#1267 - Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='), Query: SELECT |
`neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12319601' AND `protocol` = 'lldp' AND `remote_hostname` = 'Dôme SD1' AND `remote_port` |
= '00 07 5F AE 9B 55 '[2021/09/12 15:38:46 +0200] discovery.php(371725): Failed dbQuery (#1048 - Column 'remote_port' cannot be null), Query: INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`, |
`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`) VALUES ('12292667','797','isdp',NULL,'ebr-swi-ligantes',NULL,NULL,NULL,NULL,NULL,' |
1') |
For the first error I am not sure which device caused it
Second error see attached swidebug1
Third error see attached swidebug2
Attachments
Activity
Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
Resolution | New: Fixed [ 1 ] | |
Status | Original: In Progress [ 3 ] | New: Resolved [ 5 ] |
Attachment | New: neighdebug.txt [ 19093 ] |
Status | Original: Reopened [ 4 ] | New: In Progress [ 3 ] |
Resolution | Original: Fixed [ 1 ] | |
Status | Original: Resolved [ 5 ] | New: Reopened [ 4 ] |
Resolution | New: Fixed [ 1 ] | |
Status | Original: In Progress [ 3 ] | New: Resolved [ 5 ] |
Status | Original: Pending Response [ 10000 ] | New: In Progress [ 3 ] |
Comment |
[ Please make and attach additional information about the device: * full snmp dump from device: {noformat} snmpwalk -v2c -c <community> -t 3 -Cc --hexOutputLength=0 -ObentxU <hostname> .1 > myagent.snmpwalk snmpwalk -v2c -c <community> -t 3 -Cc --hexOutputLength=0 -ObentxU <hostname> .1.3.6.1.4.1 >> myagent.snmpwalk {noformat} _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: {noformat} ./discovery.php -d -h <device> ./poller.php -d -h <device> {noformat} * additionally attach device and/or vendor specific MIB files {color:#505F79}_Note, this comment is added automatically._{color} ] |
Status | Original: Open [ 1 ] | New: Pending Response [ 10000 ] |