--- Begin Message ---
Hi Oliver, thankyou. I really had to get to one device today and netdisco just
wouldn’t give me the data under ports kept saying no matching records.
Here is the output on the front end when going to that device. How is the back
end logs looking though, is that normal what its reporting?
Webfront end examples of the things I mentioned, looks like the DBIx class is
crashing, that’s why im seeing the blanks and having to refresh:
[2444] 2020-09-23 03:56:26 error request to POST
/ajax/data/device/netmappositions crashed:
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute
failed: ERROR: duplicate key value violates unique co$
DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement "INSERT
INTO netmap_positions ( device, host_groups, locations, positions, vlan) VALUES
( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues: 1='10.2.9.2$
[11839] 2020-09-23 04:00:15 error request to POST
/ajax/data/device/netmappositions crashed:
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute
failed: ERROR: duplicate key value violates unique c$
DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement "INSERT
INTO netmap_positions ( device, host_groups, locations, positions, vlan) VALUES
( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues: 1='10.2.9.2$
Use of uninitialized value $args{"mac"} in pattern match (m//) at
/home/netdisco/perl5/lib/perl5/NetAddr/MAC.pm line 128.
Use of uninitialized value $args{"mac"} in pattern match (m//) at
/home/netdisco/perl5/lib/perl5/NetAddr/MAC.pm line 128.
Use of uninitialized value $args{"mac"} in pattern match (m//) at
/home/netdisco/perl5/lib/perl5/NetAddr/MAC.pm line 128.
) me" with ParamValues: 1='10.2.2,0', 2='1970-01-01 00:00:00', 3='2020-09-21
23:59:59', 4='1970-01-01 00:00:00', 5='10.23.223,0', 6='1970-01-01 00:00:00',
7='1970-01-01 00:00:00'] at /home/netdisco/perl5/lib/perl5/App/Net$
[1610] 2020-09-21 06:11:12 error request to GET /ajax/content/report/subnets
crashed: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
execute failed: ERROR: invalid input syntax for type cidr: "10.2.2$
power(2, (32 - masklen(net))) as subnet_size,
count(DISTINCT ip) as active,
round(100 * count(DISTINCT ip) / (power(2, (32 - masklen(net))))) as
percent
FROM (
SELECT DISTINCT net, ni.ip
[2863] 2020-09-10 05:33:08 error request to POST
/ajax/data/device/netmappositions crashed:
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute
failed: ERROR: duplicate key value violates unique co$
DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement "INSERT
INTO netmap_positions ( device, host_groups, locations, positions, vlan) VALUES
( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues: 1='10.1.1.1$
[2863] 2020-09-11 04:31:04 error request to POST
/ajax/data/device/netmappositions crashed:
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute
failed: ERROR: duplicate key value violates unique co$
DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement "INSERT
INTO netmap_positions ( device, host_groups, locations, positions, vlan) VALUES
( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues: 1='10.1.2.2'$
[2863] 2020-09-14 03:10:34 error request to POST
/ajax/data/device/netmappositions crashed:
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute
failed: ERROR: duplicate key value violates unique co$
DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement "INSERT
INTO netmap_positions ( device, host_groups, locations, positions, vlan) VALUES
( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues: 1='10.6.5.0$
Use of uninitialized value $args{"mac"} in pattern match (m//) at
/home/netdisco/perl5/lib/perl5/NetAddr/MAC.pm line 128.
[8823] 2020-09-15 01:15:09 warn App::Netdisco 2.046002 web
From: Oliver Gorwits <[email protected]>
Date: Wednesday, 23 September 2020 at 18:12
To: Muris <[email protected]>
Cc: "[email protected]"
<[email protected]>
Subject: Re: [Netdisco] Netdisco 2.46.2 issues
Hi Muris
Just to note that for issues in the web frontend it would be the web-frontend
log, not the backend (which is the log of the pollers).
regards
Oliver
On Wed, 23 Sep 2020 at 05:16, Muris <[email protected]> wrote:
Im looking also at the backend log and a few things coming up, when im doing
the searching, and queries, see below
Use of uninitialized value $res{"418"} in pattern match (m//) at
/home/netdisco/perl5/lib/perl5/SNMP/Info/CiscoStpExtensions.pm line 255.
Use of uninitialized value $res{"418"} in string eq at
/home/netdisco/perl5/lib/perl5/SNMP/Info/CiscoStpExtensions.pm line 256.
Use of uninitialized value $res{"174"} in string eq at
/home/netdisco/perl5/lib/perl5/SNMP/Info/CiscoStpExtensions.pm line 253.
Use of uninitialized value $res{"174"} in string eq at
/home/netdisco/perl5/lib/perl5/SNMP/Info/CiscoStpExtensions.pm line 254.
Use of uninitialized value $res{"174"} in pattern match (m//) at
/home/netdisco/perl5/lib/perl5/SNMP/Info/CiscoStpExtensions.pm line 255.
Use of uninitialized value $res{"174"} in string eq at
/home/netdisco/perl5/lib/perl5/SNMP/Info/CiscoStpExtensions.pm line 256.
Use of uninitialized value in unpack at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Discover/Properties.pm
line 56.
Use of uninitialized value in sprintf at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Discover/Entities.pm
line 108.
Use of uninitialized value in unpack at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Discover/Properties.pm
line 56.
Use of uninitialized value in unpack at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Discover/Properties.pm
line 56.
Use of uninitialized value in sprintf at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Discover/Entities.pm
line 108.
Use of uninitialized value in sprintf at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Discover/Entities.pm
line 108.
DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.
SQL that returns multiple rows is DEPRECATED for ->find and ->single at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/Node.pm line 182
DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.
SQL that returns multiple rows is DEPRECATED for ->find and ->single at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Arpnip/Subnets.pm
line 65
DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.
SQL that returns multiple rows is DEPRECATED for ->find and ->single at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/Node.pm line 182
From: Muris <[email protected]>
Date: Wednesday, 23 September 2020 at 13:31
To: "[email protected]"
<[email protected]>
Subject: Netdisco 2.46.2 issues
Hi List,
Upgraded to 2.46.2 Netdisco, with Postgresql 12
Ive noticed a few issues with this version
searching or looking things up, it doesn’t find anything, then you have to
refresh the page multiple times to pull up the data
Going into some devices and clicking on ports comes up with “ no matching
records” no matter how many times you delete or bring in the devices, even
addresses, vlans tabs do the same
Previously I was a few versions behind running on similar postgresql 12 was
running fine.
Anyone finding similar ? or a fix possible?
Thanks
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
