netdisco-users Digest, Vol 112, Issue 10

Fri, 23 Oct 2015 07:17:14 -0700 

Send netdisco-users mailing list submissions to
        netdisco-users@lists.sourceforge.net

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
        netdisco-users-requ...@lists.sourceforge.net

You can reach the person managing the list at
        netdisco-users-ow...@lists.sourceforge.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."

Today's Topics:

   1. DBIx::Class:Storage messages after DB upgrade (Pavel Skovajsa)
   2. Search failed! Please contact your site administrator.
      (Gary Lloyd)
--- Begin Message --- 
Hello all,

I just upgraded our Ubuntu 14.04 from Postgres 9.1 to Postgres 9.3
using pg_upgrade
tool. Netdisco's web page works great, except I noticed I now have the
netdisco-daemon.log full of errors like this. They were certainly not there
before. Any advices?:


DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
execute failed: ERROR:  invalid byte sequence for encoding "UTF8": 0xe8
0xf6 0x7f [for Statement "UPDATE node_ip SET active = true, dns = ?,
time_last = to_timestamp(1445465451.354297) WHERE ( ( ip = ? AND mac = ? )
)" with ParamValues: 1='èö.}.phone.xyz.com', 2='10.230.43.51',
3='10:8c:cf:e0:f3:a6'] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Arpnip.pm line 134
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
execute failed: ERROR:  invalid byte sequence for encoding "UTF8": 0xe8
0xf6 0x7f [for Statement "UPDATE node_ip SET active = true, dns = ?,
time_last = to_timestamp(1445465450.482445) WHERE ( ( ip = ? AND mac = ? )
)" with ParamValues: 1='èö.}.xyz.com', 2='10.198.217.113',
3='64:d8:14:a4:c7:92'] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Arpnip.pm line 134
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
execute failed: ERROR:  invalid byte sequence for encoding "UTF8": 0xe8
0xf6 0x7f [for Statement "UPDATE node_ip SET active = true, dns = ?,
time_last = to_timestamp(1445465456.819462) WHERE ( ( ip = ? AND mac = ? )
)" with ParamValues: 1='èö.}.phone.xyz.com', 2='10.230.43.51',
3='10:8c:cf:e0:f3:a6'] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Arpnip.pm line 134
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
execute failed: ERROR:  invalid byte sequence for encoding "UTF8": 0xe8
0xf6 0x7f [for Statement "UPDATE node_ip SET active = true, dns = ?,
time_last = to_timestamp(1445465456.931373) WHERE ( ( ip = ? AND mac = ? )
)" with ParamValues: 1='èö.}.phone.xyz.com', 2='10.230.43.51',
3='10:8c:cf:e0:f3:a6'] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Arpnip.pm line 134
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 945 generated 908 errors [for Statement "INSERT INTO device_port
( descr, duplex, duplex_admin, ip, is_master, lastchange, mac, mtu, name,
port, pvid, slave_of, speed, stp, type, up, up_admin, vlan) VALUES ( ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 313
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 24 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 12 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 11 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 27 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 46 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 30 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
execute failed: ERROR:  invalid byte sequence for encoding "UTF8": 0xff
[for Statement "UPDATE node_ip SET active = true, dns = ?, time_last =
to_timestamp(1445465469.351659) WHERE ( ( ip = ? AND mac = ? ) )" with
ParamValues:
1='................................................................
phone.xyz.com', 2='10.198.35.143', 3='00:1f:6c:81:25:c3'] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Arpnip.pm line 134
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 11 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 35 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 27 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
execute failed: ERROR:  invalid input syntax for type macaddr:
"00:00:00:00" [for Statement "SELECT me.ip, me.creation, me.dns,
me.description, me.uptime, me.contact, me.name, me.location, me.layers,
me.ports, me.mac, me.serial, me.model, me.ps1_type, me.ps2_type,
me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os,
me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.vtp_domain,
me.last_discover, me.last_macsuck, me.last_arpnip FROM device me WHERE (
mac = ? )" with ParamValues: 1='00:00:00:00'] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 754
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 41 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 13 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 45 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 23 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 33 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 24 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472
DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::Pg::st
execute_for_fetch failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block [err was 7 now 2000000000]
executing 46 generated 21 errors [for Statement "INSERT INTO device_vlan (
description, ip, last_discover, vlan) VALUES ( ?, ?, now(), ? )"] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 472

-pavel

--- End Message ---
--- Begin Message --- 
Hi

We have been running version 2 of netdisco for some time and all seemed
great until today.
We have hundreds of devices and when I try to bring up a port list it works
for everything except two cisco 6509's (our main core switches) where it
just gets stuck on waiting and then comes up with the message:

Search failed! Please contact your site administrator.

- I've tried an snmpwalk and I can still talk to them and discover,arnip
and macsuck all seem to work.
- There is 17Gb free on the HDD
- deleted devices and readded, but it still does the same.
- generating a postgres.conf using pgtune, but it still happens.

Has anyone got any ideas what else I can try ?

Cheers


*Gary Lloyd*
________________________________________________
I.T. Systems:Keele University
Finance & IT Directorate
________________________________________________

--- End Message ---
------------------------------------------------------------------------------

_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Reply via email to