Send netdisco-users mailing list submissions to
[email protected]
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
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Netdisco 2: error running job (Huber, Peter)
2. Netdisco 2: discover error (Huber, Peter)
--- Begin Message ---
Hi,
I have attached the debug file. I hope this helps to find the problem.
Regards
Peter
>-----Ursprüngliche Nachricht-----
>Von: Eric Miller [mailto:[email protected]]
>Gesendet: Freitag, 1. November 2013 03:15
>An: Huber, Peter
>Cc: [email protected]
>Betreff: Re: [Netdisco] Netdisco 2: error running job
>
>Can you run with "DBIC_TRACE=1 netdisco-do discover -D -d 10.10.10.10"
>so we can get a better idea of what's happening before the error?
>
>Thanks,
>Eric
>
>On 2013-10-31 09:22, Huber, Peter wrote:
>> Hi,
>>
>> after running netdisco-do discover -d 10.10.10.10 I get the following
>> error message:
>>
>> [26644] info @0.000020> discover: started at Thu Oct 31 14:10:21 2013
>> [26644] info @13.101797> discover: finished at Thu Oct 31 14:10:34
>> 2013
>> [26644] info @13.101963> discover: status error: error running job:
>> DBIx::Class::Storage::DBI::_dbh_execute_for_fetch():
>> execute_for_fetch() aborted with 'ERROR: duplicate key value violates
>> unique constraint "device_port_vlan_pkey"' at populate slice:
>> {
>> ip => "10.10.10.10",
>> last_discover => \"now()",
>> native => "t",
>> port => "1:23",
>> vlan => 11,
>> vlantype => undef
>> } at /opt/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line
>> 453
>>
>> How can I fix this? I am using version 2.019003
>>
>> Regards
>>
>> Peter
>>
>> Private Universität Witten/Herdecke gGmbH Alfred-Herrhausen-Straße 50
>> D - 58448 Witten
>>
>> Homepage: http://www.uni-wh.de
>> Twitter: http://twitter.com/UniWH
>> Facebook: http://www.facebook.com/UniWH
>>
>> Geschäftsführung: Prof. Dr. Martin Butzlaff (Präsident), Dipl. oec.
>> Jan Peter Nonnenkamp (Kanzler)
>>
>> Sitz der Gesellschaft: Witten
>> Handelsregister des Amtsgerichts Bochum Nr. HRB 8671
>> ----------------------------------------------------------------------
>> -------- Android is increasing in popularity, but the open development
>> platform that developers love is also attractive to malware creators.
>> Download this white paper to learn more about secure code signing
>> practices that can help keep Android apps secure.
>> http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.c
>> lktrk _______________________________________________
>> Netdisco mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/netdisco-users
Private Universität Witten/Herdecke gGmbH
Alfred-Herrhausen-Straße 50
D - 58448 Witten
Homepage: http://www.uni-wh.de
Twitter: http://twitter.com/UniWH
Facebook: http://www.facebook.com/UniWH
Geschäftsführung: Prof. Dr. Martin Butzlaff (Präsident), Dipl. oec. Jan Peter
Nonnenkamp (Kanzler)
Sitz der Gesellschaft: Witten
Handelsregister des Amtsgerichts Bochum Nr. HRB 8671
CREATE TABLE admin (
job INTEGER PRIMARY KEY NOT NULL,
role text NOT NULL,
wid integer NOT NULL DEFAULT 0,
entered timestamp,
started timestamp,
finished timestamp,
device inet,
port text,
action text,
subaction text,
status text,
username text,
userip inet,
log text,
debug boolean
):
[13197] info @0.000019> discover: started at Mon Nov 4 10:58:06 2013
SELECT me.version, me.installed FROM dbix_class_schema_versions me WHERE ( 1=0
):
SELECT me.version FROM dbix_class_schema_versions me ORDER BY installed DESC
LIMIT ?: '1'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation FROM device_ip
me WHERE ( alias = ? ): '10.129.252.120'
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,
to_char(last_arpnip, 'YYYY-MM-DD HH24:MI'), to_char(last_discover,
'YYYY-MM-DD HH24:MI'), to_char(last_macsuck, 'YYYY-MM-DD HH24:MI'),
extract(epoch from (age(now(), last_arpnip))), extract(epoch from (age(now(),
last_discover))), extract(epoch from (age(now(), last_macsuck))),
replace(age(timestamp 'epoch' + uptime / 100 * interval '1 second', timestamp
'1970-01-01 00:00:00-00')::text, 'mon', 'month') FROM device me WHERE ( me.ip =
? ): '10.129.252.120'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation FROM device_ip
me WHERE ( alias = ? ): '10.129.252.120'
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,
to_char(last_arpnip, 'YYYY-MM-DD HH24:MI'), to_char(last_discover,
'YYYY-MM-DD HH24:MI'), to_char(last_macsuck, 'YYYY-MM-DD HH24:MI'),
extract(epoch from (age(now(), last_arpnip))), extract(epoch from (age(now(),
last_discover))), extract(epoch from (age(now(), last_macsuck))),
replace(age(timestamp 'epoch' + uptime / 100 * interval '1 second', timestamp
'1970-01-01 00:00:00-00')::text, 'mon', 'month') FROM device me WHERE ( me.ip =
? ): '10.129.252.120'
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag FROM community me WHERE ( me.ip
= ? ): '10.129.252.120'
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag FROM community me WHERE ( me.ip
= ? ): '10.129.252.120'
[13197] debug @0.312502> [10.129.252.120] try_connect with ver: 2, class:
SNMP::Info::Layer3::Extreme, comm: public
BEGIN WORK
COMMIT
[13197] debug @2.208199> [10.129.252.120] device - aliased as 10.129.252.120
[13197] debug @2.208471> resolving 1 aliases with max 250 outstanding requests
BEGIN WORK
DELETE FROM device_ip WHERE ( ip = ? ): '10.129.252.120'
[13197] debug @7.360899> [10.129.252.120] device - removed 1 aliases
SAVEPOINT savepoint_0
UPDATE device SET last_discover = now(), uptime = ? WHERE ( ip = ? ):
'3283086600', '10.129.252.120'
RELEASE SAVEPOINT savepoint_0
SAVEPOINT savepoint_0
INSERT INTO device_ip ( alias, dns, ip, port, subnet) VALUES ( ?, ?, ?, ?, ? ):
'__BULK_INSERT__'
RELEASE SAVEPOINT savepoint_0
[13197] debug @7.366247> [10.129.252.120] device - added 1 new aliases
COMMIT
[13197] debug @13.283882> [10.129.252.120] interfaces - ignoring 1000005
(Mgmt) (propVirtual)
[13197] debug @13.285472> [10.129.252.120] interfaces - ignoring 1000004
(Default) (propVirtual)
[13197] debug @13.285824> [10.129.252.120] interfaces - ignoring 1000001
(VirtualRouter0) (propVirtual)
[13197] debug @13.287148> [10.129.252.120] interfaces - ignoring 1000002
(VirtualRouter2) (propVirtual)
[13197] debug @13.287515> [10.129.252.120] interfaces - ignoring 1000003
(VirtualRouter1) (propVirtual)
[13197] debug @13.288980> [10.129.252.120] interfaces - ignoring 1000006
(priv) (propVirtual)
[13197] debug @13.289907> [10.129.252.120] interfaces - ignoring 1000008
(switchmgmt) (propVirtual)
BEGIN WORK
DELETE FROM device_port_power WHERE ( ip IN ( SELECT me.ip FROM device_port me
WHERE ( me.ip = ? ) ) ): '10.129.252.120'
DELETE FROM device_port_vlan WHERE ( ip IN ( SELECT me.ip FROM device_port me
WHERE ( me.ip = ? ) ) ): '10.129.252.120'
DELETE FROM device_port_wireless WHERE ( ip IN ( SELECT me.ip FROM device_port
me WHERE ( me.ip = ? ) ) ): '10.129.252.120'
DELETE FROM device_port_ssid WHERE ( ip IN ( SELECT me.ip FROM device_port me
WHERE ( me.ip = ? ) ) ): '10.129.252.120'
DELETE FROM device_port_log WHERE ( ip IN ( SELECT me.ip FROM device_port me
WHERE ( me.ip = ? ) ) ): '10.129.252.120'
DELETE FROM device_port WHERE ( ip = ? ): '10.129.252.120'
[13197] debug @13.312823> [10.129.252.120] interfaces - removed 28 interfaces
SAVEPOINT savepoint_0
RELEASE SAVEPOINT savepoint_0
SAVEPOINT savepoint_0
INSERT INTO device_port ( descr, duplex, duplex_admin, ip, lastchange, mac,
mtu, name, port, pvid, speed, stp, type, up, up_admin, vlan) VALUES ( ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ): '__BULK_INSERT__'
RELEASE SAVEPOINT savepoint_0
[13197] debug @13.325913> [10.129.252.120] interfaces - added 28 new interfaces
COMMIT
BEGIN WORK
DELETE FROM device_vlan WHERE ( ip = ? ): '10.129.252.120'
[13197] debug @14.010168> [10.129.252.120] vlans - removed 4 device VLANs
SAVEPOINT savepoint_0
INSERT INTO device_vlan ( description, ip, last_discover, vlan) VALUES ( ?, ?,
now(), ? ): '__BULK_INSERT__'
RELEASE SAVEPOINT savepoint_0
[13197] debug @14.013223> [10.129.252.120] vlans - added 4 new device VLANs
COMMIT
BEGIN WORK
DELETE FROM device_port_vlan WHERE ( ip = ? ): '10.129.252.120'
[13197] debug @14.016798> [10.129.252.120] vlans - removed 0E0 port VLANs
SAVEPOINT savepoint_0
INSERT INTO device_port_vlan ( ip, last_discover, native, port, vlan, vlantype)
VALUES ( ?, now(), ?, ?, ?, ? ): '__BULK_INSERT__'
ROLLBACK TO SAVEPOINT savepoint_0
RELEASE SAVEPOINT savepoint_0
ROLLBACK
[13197] info @14.036693> discover: finished at Mon Nov 4 10:58:20 2013
[13197] info @14.036864> discover: status error: error running job:
execute_for_fetch() aborted with 'ERROR: duplicate key value violates unique
constraint "device_port_vlan_pkey"' at populate slice:
{
ip => "10.129.252.120",
last_discover => \"now()",
native => "t",
port => "1:23",
vlan => 11,
vlantype => undef
} at /opt/netdisco/perl5/lib/perl5/DBIx/Class/Schema.pm line 1080.
DBIx::Class::Schema::throw_exception(App::Netdisco::DB=HASH(0x36eaf78),
"execute_for_fetch() aborted with 'ERROR: duplicate key value"...) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage.pm line 112
DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::Pg=HASH(0x42bdc48),
"execute_for_fetch() aborted with 'ERROR: duplicate key value"...) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 2259
DBIx::Class::Storage::DBI::_dbh_execute_for_fetch(DBIx::Class::Storage::DBI::Pg=HASH(0x42bdc48),
DBIx::Class::ResultSource::Table=HASH(0x51d2860), DBI::st=HASH(0x5928670),
ARRAY(0x592e980), ARRAY(0x5923180), ARRAY(0x593ece8)) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 2158
DBIx::Class::Storage::DBI::insert_bulk(DBIx::Class::Storage::DBI::Pg=HASH(0x42bdc48),
DBIx::Class::ResultSource::Table=HASH(0x51d2860), ARRAY(0x5923180),
ARRAY(0x593ece8)) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/ResultSet.pm line 2294
DBIx::Class::ResultSet::populate(DBIx::Class::ResultSet=HASH(0x5942478),
ARRAY(0x4cc47a0)) called at
/opt/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 453
App::Netdisco::Core::Discover::__ANON__() called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/BlockRunner.pm line 139
DBIx::Class::Storage::BlockRunner::try {...} () called at
/opt/netdisco/perl5/lib/perl5/Try/Tiny.pm line 83
eval {...} called at /opt/netdisco/perl5/lib/perl5/Try/Tiny.pm line 74
Try::Tiny::try(CODE(0x5942c40), Try::Tiny::Catch=REF(0x5928a60)) called
at /opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/BlockRunner.pm line 143
DBIx::Class::Storage::BlockRunner::__ANON__() called at
/opt/netdisco/perl5/lib/perl5/Context/Preserve.pm line 22
Context::Preserve::preserve_context(CODE(0x593a060), "replace",
CODE(0x5939bc8)) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/BlockRunner.pm line 221
DBIx::Class::Storage::BlockRunner::_run(DBIx::Class::Storage::BlockRunner=HASH(0x593c920))
called at /opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/BlockRunner.pm line
112
DBIx::Class::Storage::BlockRunner::run(DBIx::Class::Storage::BlockRunner=HASH(0x593c920))
called at /opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage.pm line 189
DBIx::Class::Storage::txn_do(DBIx::Class::Storage::DBI::Pg=HASH(0x42bdc48),
CODE(0x512ba08)) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 816
DBIx::Class::Storage::DBI::txn_do(DBIx::Class::Storage::DBI::Pg=HASH(0x42bdc48),
CODE(0x512ba08)) called at /opt/netdisco/perl5/lib/perl5/DBIx/Class/Schema.pm
line 656
DBIx::Class::Schema::txn_do(App::Netdisco::DB=HASH(0x36eaf78),
CODE(0x512ba08)) called at
/opt/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 456
App::Netdisco::Core::Discover::store_vlans(App::Netdisco::DB::Result::Device=HASH(0x7f3e9574e1b8),
SNMP::Info::Layer3::Extreme=HASH(0x7f3e957635a8)) called at
/opt/netdisco/perl5/lib/perl5/App/Netdisco/Daemon/Worker/Poller/Device.pm line
75
App::Netdisco::Daemon::Worker::Poller::Device::discover(MyWorker=HASH(0x4de0f00),
App::Netdisco::Daemon::DB::Result::Admin=HASH(0x36f7ce0)) called at
/opt/netdisco/bin/netdisco-do line 102
main::try {...} () called at /opt/netdisco/perl5/lib/perl5/Try/Tiny.pm
line 83
eval {...} called at /opt/netdisco/perl5/lib/perl5/Try/Tiny.pm line 74
Try::Tiny::try(CODE(0x4dd45e8), Try::Tiny::Catch=REF(0x42c3d38)) called
at /opt/netdisco/bin/netdisco-do line 107
--- End Message ---
--- Begin Message ---
I have removed the netdisco database and then deployed a fresh one. So there is
no switch in the database which could cause any problem.
I try to discover an extreme switch and get the following errors. Discovering a
cisco switch is working fine. This extreme switch is discovered well with
netdisco 1.3.1
Here what I have done and the output. Can you help me?
Regards
Peter
$ DBIC_TRACE=1 netdisco-do discover -D -d zbz-core.network.uni-wh.de
I get the following output:
CREATE TABLE admin (
job INTEGER PRIMARY KEY NOT NULL,
role text NOT NULL,
wid integer NOT NULL DEFAULT 0,
entered timestamp,
started timestamp,
finished timestamp,
device inet,
port text,
action text,
subaction text,
status text,
username text,
userip inet,
log text,
debug boolean
):
[22995] info @0.000019> discover: started at Wed Nov 6 09:10:48 2013
SELECT me.version, me.installed FROM dbix_class_schema_versions me WHERE ( 1=0
):
SELECT me.version FROM dbix_class_schema_versions me ORDER BY installed DESC
LIMIT ?: '1'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation FROM device_ip
me WHERE ( alias = ? ): '10.129.252.120'
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,
to_char(last_arpnip, 'YYYY-MM-DD HH24:MI'), to_char(last_discover,
'YYYY-MM-DD HH24:MI'), to_char(last_macsuck, 'YYYY-MM-DD HH24:MI'),
extract(epoch from (age(now(), last_arpnip))), extract(epoch from (age(now(),
last_discover))), extract(epoch from (age(now(), last_macsuck))),
replace(age(timestamp 'epoch' + uptime / 100 * interval '1 second', timestamp
'1970-01-01 00:00:00-00')::text, 'mon', 'month') FROM device me WHERE ( me.ip =
? ): '10.129.252.120'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation FROM device_ip
me WHERE ( alias = ? ): '10.129.252.120'
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,
to_char(last_arpnip, 'YYYY-MM-DD HH24:MI'), to_char(last_discover,
'YYYY-MM-DD HH24:MI'), to_char(last_macsuck, 'YYYY-MM-DD HH24:MI'),
extract(epoch from (age(now(), last_arpnip))), extract(epoch from (age(now(),
last_discover))), extract(epoch from (age(now(), last_macsuck))),
replace(age(timestamp 'epoch' + uptime / 100 * interval '1 second', timestamp
'1970-01-01 00:00:00-00')::text, 'mon', 'month') FROM device me WHERE ( me.ip =
? ): '10.129.252.120'
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag FROM community me WHERE ( me.ip
= ? ): '10.129.252.120'
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag FROM community me WHERE ( me.ip
= ? ): '10.129.252.120'
[22995] debug @0.326488> [10.129.252.120] try_connect with ver: 2, class:
SNMP::Info, comm: public
[22995] debug @0.824854> [10.129.252.120] try_connect with ver: 2, new class:
SNMP::Info::Layer3::Extreme, comm: public
[22995] debug @2.303318> [10.129.252.120] device - aliased as 10.129.252.120
[22995] debug @2.303509> resolving 1 aliases with max 250 outstanding requests
BEGIN WORK
DELETE FROM device_ip WHERE ( ip = ? ): '10.129.252.120'
[22995] debug @7.617843> [10.129.252.120] device - removed 0E0 aliases
INSERT INTO device ( contact, description, dns, fan, ip, last_discover, layers,
location, mac, model, name, os, os_ver, ps1_status, ps2_status, serial,
snmp_class, snmp_comm, snmp_ver, uptime, vendor) VALUES ( ?, ?, ?, ?, ?, now(),
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ): '[email protected], +1
888 257 3000', 'ExtremeXOS version 12.2.1.1 v1221b1 by release-manager on Thu
Dec 18 21:56:00 PST 2008', 'zbz-core.network.uni-wh.de', '101: OK, 102: OK,
103: OK, 104: OK, 105: OK, 106: OK, 107: OK, 108: OK', '10.129.252.120',
'01001111', '', '00:04:96:35:60:0c', 'summitX450a-24x', 'zbz-core', 'xos',
'12.2.1.1', 'OK', 'OK', '0835G-81555', 'SNMP::Info::Layer3::Extreme', 'public',
'2', '3299722700', 'extreme'
SAVEPOINT savepoint_0
INSERT INTO device_ip ( alias, dns, ip, port, subnet) VALUES ( ?, ?, ?, ?, ? ):
'__BULK_INSERT__'
RELEASE SAVEPOINT savepoint_0
[22995] debug @7.624398> [10.129.252.120] device - added 1 new aliases
COMMIT
[22995] debug @12.447533> [10.129.252.120] interfaces - ignoring 1000005
(Mgmt) (propVirtual)
[22995] debug @12.449086> [10.129.252.120] interfaces - ignoring 1000004
(Default) (propVirtual)
[22995] debug @12.449381> [10.129.252.120] interfaces - ignoring 1000001
(VirtualRouter0) (propVirtual)
[22995] debug @12.450738> [10.129.252.120] interfaces - ignoring 1000002
(VirtualRouter2) (propVirtual)
[22995] debug @12.451034> [10.129.252.120] interfaces - ignoring 1000003
(VirtualRouter1) (propVirtual)
[22995] debug @12.452551> [10.129.252.120] interfaces - ignoring 1000006
(priv) (propVirtual)
[22995] debug @12.453501> [10.129.252.120] interfaces - ignoring 1000008
(switchmgmt) (propVirtual)
BEGIN WORK
DELETE FROM device_port_power WHERE ( ip IN ( SELECT me.ip FROM device_port me
WHERE ( me.ip = ? ) ) ): '10.129.252.120'
DELETE FROM device_port_vlan WHERE ( ip IN ( SELECT me.ip FROM device_port me
WHERE ( me.ip = ? ) ) ): '10.129.252.120'
DELETE FROM device_port_wireless WHERE ( ip IN ( SELECT me.ip FROM device_port
me WHERE ( me.ip = ? ) ) ): '10.129.252.120'
DELETE FROM device_port_ssid WHERE ( ip IN ( SELECT me.ip FROM device_port me
WHERE ( me.ip = ? ) ) ): '10.129.252.120'
DELETE FROM device_port_log WHERE ( ip IN ( SELECT me.ip FROM device_port me
WHERE ( me.ip = ? ) ) ): '10.129.252.120'
DELETE FROM device_port WHERE ( ip = ? ): '10.129.252.120'
[22995] debug @12.476130> [10.129.252.120] interfaces - removed 0E0 interfaces
SAVEPOINT savepoint_0
RELEASE SAVEPOINT savepoint_0
SAVEPOINT savepoint_0
INSERT INTO device_port ( descr, duplex, duplex_admin, ip, lastchange, mac,
mtu, name, port, pvid, speed, stp, type, up, up_admin, vlan) VALUES ( ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ): '__BULK_INSERT__'
RELEASE SAVEPOINT savepoint_0
[22995] debug @12.488622> [10.129.252.120] interfaces - added 28 new interfaces
COMMIT
BEGIN WORK
DELETE FROM device_vlan WHERE ( ip = ? ): '10.129.252.120'
[22995] debug @13.149950> [10.129.252.120] vlans - removed 0E0 device VLANs
SAVEPOINT savepoint_0
INSERT INTO device_vlan ( description, ip, last_discover, vlan) VALUES ( ?, ?,
now(), ? ): '__BULK_INSERT__'
RELEASE SAVEPOINT savepoint_0
[22995] debug @13.152999> [10.129.252.120] vlans - added 4 new device VLANs
COMMIT
BEGIN WORK
DELETE FROM device_port_vlan WHERE ( ip = ? ): '10.129.252.120'
[22995] debug @13.156287> [10.129.252.120] vlans - removed 0E0 port VLANs
SAVEPOINT savepoint_0
INSERT INTO device_port_vlan ( ip, last_discover, native, port, vlan, vlantype)
VALUES ( ?, now(), ?, ?, ?, ? ): '__BULK_INSERT__'
ROLLBACK TO SAVEPOINT savepoint_0
RELEASE SAVEPOINT savepoint_0
ROLLBACK
[22995] info @13.176139> discover: finished at Wed Nov 6 09:11:01 2013
[22995] info @13.176299> discover: status error: error running job:
execute_for_fetch() aborted with 'ERROR: duplicate key value violates unique
constraint "device_port_vlan_pkey"' at populate slice:
{
ip => "10.129.252.120",
last_discover => \"now()",
native => "t",
port => "1:23",
vlan => 11,
vlantype => undef
} at /opt/netdisco/perl5/lib/perl5/DBIx/Class/Schema.pm line 1080.
DBIx::Class::Schema::throw_exception(App::Netdisco::DB=HASH(0x2ebbf28),
"execute_for_fetch() aborted with 'ERROR: duplicate key value"...) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage.pm line 112
DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::Pg=HASH(0x3a850f0),
"execute_for_fetch() aborted with 'ERROR: duplicate key value"...) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 2259
DBIx::Class::Storage::DBI::_dbh_execute_for_fetch(DBIx::Class::Storage::DBI::Pg=HASH(0x3a850f0),
DBIx::Class::ResultSource::Table=HASH(0x49a37c0), DBI::st=HASH(0x50fa1f0),
ARRAY(0x50ef418), ARRAY(0x50f3dd0), ARRAY(0x51143b0)) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 2158
DBIx::Class::Storage::DBI::insert_bulk(DBIx::Class::Storage::DBI::Pg=HASH(0x3a850f0),
DBIx::Class::ResultSource::Table=HASH(0x49a37c0), ARRAY(0x50f3dd0),
ARRAY(0x51143b0)) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/ResultSet.pm line 2294
DBIx::Class::ResultSet::populate(DBIx::Class::ResultSet=HASH(0x51086e8),
ARRAY(0x44957a0)) called at
/opt/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 453
App::Netdisco::Core::Discover::__ANON__() called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/BlockRunner.pm line 139
DBIx::Class::Storage::BlockRunner::try {...} () called at
/opt/netdisco/perl5/lib/perl5/Try/Tiny.pm line 83
eval {...} called at /opt/netdisco/perl5/lib/perl5/Try/Tiny.pm line 74
Try::Tiny::try(CODE(0x510b820), Try::Tiny::Catch=REF(0x50fa5e0)) called
at /opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/BlockRunner.pm line 143
DBIx::Class::Storage::BlockRunner::__ANON__() called at
/opt/netdisco/perl5/lib/perl5/Context/Preserve.pm line 22
Context::Preserve::preserve_context(CODE(0x510c060), "replace",
CODE(0x5115398)) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/BlockRunner.pm line 221
DBIx::Class::Storage::BlockRunner::_run(DBIx::Class::Storage::BlockRunner=HASH(0x510bd90))
called at /opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/BlockRunner.pm line
112
DBIx::Class::Storage::BlockRunner::run(DBIx::Class::Storage::BlockRunner=HASH(0x510bd90))
called at /opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage.pm line 189
DBIx::Class::Storage::txn_do(DBIx::Class::Storage::DBI::Pg=HASH(0x3a850f0),
CODE(0x48fc978)) called at
/opt/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 816
DBIx::Class::Storage::DBI::txn_do(DBIx::Class::Storage::DBI::Pg=HASH(0x3a850f0),
CODE(0x48fc978)) called at /opt/netdisco/perl5/lib/perl5/DBIx/Class/Schema.pm
line 656
DBIx::Class::Schema::txn_do(App::Netdisco::DB=HASH(0x2ebbf28),
CODE(0x48fc978)) called at
/opt/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 456
App::Netdisco::Core::Discover::store_vlans(App::Netdisco::DB::Result::Device=HASH(0x4c862f0),
SNMP::Info::Layer3::Extreme=HASH(0x7f3598e05aa8)) called at
/opt/netdisco/perl5/lib/perl5/App/Netdisco/Daemon/Worker/Poller/Device.pm line
75
App::Netdisco::Daemon::Worker::Poller::Device::discover(MyWorker=HASH(0x45b1f30),
App::Netdisco::Daemon::DB::Result::Admin=HASH(0x2ec8c90)) called at
/opt/netdisco/bin/netdisco-do line 102
main::try {...} () called at /opt/netdisco/perl5/lib/perl5/Try/Tiny.pm
line 83
eval {...} called at /opt/netdisco/perl5/lib/perl5/Try/Tiny.pm line 74
Try::Tiny::try(CODE(0x45a55a0), Try::Tiny::Catch=REF(0x3aa35a0)) called
at /opt/netdisco/bin/netdisco-do line 107
$
>-----Ursprüngliche Nachricht-----
>Von: Huber, Peter
>Gesendet: Montag, 4. November 2013 11:02
>An: [email protected]
>Betreff: AW: [Netdisco] Netdisco 2: error running job
>
>Hi,
>
>I have attached the debug file. I hope this helps to find the problem.
>
>Regards
>
>Peter
>
>>-----Ursprüngliche Nachricht-----
>>Von: Eric Miller [mailto:[email protected]]
>>Gesendet: Freitag, 1. November 2013 03:15
>>An: Huber, Peter
>>Cc: [email protected]
>>Betreff: Re: [Netdisco] Netdisco 2: error running job
>>
>>Can you run with "DBIC_TRACE=1 netdisco-do discover -D -d 10.10.10.10"
>>so we can get a better idea of what's happening before the error?
>>
>>Thanks,
>>Eric
>>
>>On 2013-10-31 09:22, Huber, Peter wrote:
>>> Hi,
>>>
>>> after running netdisco-do discover -d 10.10.10.10 I get the following
>>> error message:
>>>
>>> [26644] info @0.000020> discover: started at Thu Oct 31 14:10:21
>>> 2013 [26644] info @13.101797> discover: finished at Thu Oct 31
>>> 14:10:34
>>> 2013
>>> [26644] info @13.101963> discover: status error: error running job:
>>> DBIx::Class::Storage::DBI::_dbh_execute_for_fetch():
>>> execute_for_fetch() aborted with 'ERROR: duplicate key value
>>> violates unique constraint "device_port_vlan_pkey"' at populate slice:
>>> {
>>> ip => "10.10.10.10",
>>> last_discover => \"now()",
>>> native => "t",
>>> port => "1:23",
>>> vlan => 11,
>>> vlantype => undef
>>> } at /opt/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line
>>> 453
>>>
>>> How can I fix this? I am using version 2.019003
>>>
>>> Regards
>>>
>>> Peter
>>>
>>> Private Universität Witten/Herdecke gGmbH Alfred-Herrhausen-Straße 50
>>> D - 58448 Witten
>>>
>>> Homepage: http://www.uni-wh.de
>>> Twitter: http://twitter.com/UniWH
>>> Facebook: http://www.facebook.com/UniWH
>>>
>>> Geschäftsführung: Prof. Dr. Martin Butzlaff (Präsident), Dipl. oec.
>>> Jan Peter Nonnenkamp (Kanzler)
>>>
>>> Sitz der Gesellschaft: Witten
>>> Handelsregister des Amtsgerichts Bochum Nr. HRB 8671
>>> ---------------------------------------------------------------------
>>> -
>>> -------- Android is increasing in popularity, but the open
>>> development platform that developers love is also attractive to malware
>creators.
>>> Download this white paper to learn more about secure code signing
>>> practices that can help keep Android apps secure.
>>> http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.
>>> c lktrk _______________________________________________
>>> Netdisco mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/netdisco-users
Private Universität Witten/Herdecke gGmbH
Alfred-Herrhausen-Straße 50
D - 58448 Witten
Homepage: http://www.uni-wh.de
Twitter: http://twitter.com/UniWH
Facebook: http://www.facebook.com/UniWH
Geschäftsführung: Prof. Dr. Martin Butzlaff (Präsident), Dipl. oec. Jan Peter
Nonnenkamp (Kanzler)
Sitz der Gesellschaft: Witten
Handelsregister des Amtsgerichts Bochum Nr. HRB 8671
--- End Message ---
------------------------------------------------------------------------------
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most
from the latest Intel processors and coprocessors. See abstracts and register
http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
