netdisco-users Digest, Vol 114, Issue 6

Wed, 30 Dec 2015 05:46:52 -0800 

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. Re: discovery of Cisco 6500 : duplicate key value (Steven Xu)
   2. Re: Search failed! Please contact your site       administrator
      (netdisco2) (Steven Xu)
   3. Re: discovery of Cisco 6500 : duplicate key value
      (De Bruyne Karel)
   4. Customize the Netdisco Web Gui (Tran, John)
--- Begin Message --- Hi,

There was a previous mailing thread about the 6500 series on a similar symptom. See https://sourceforge.net/p/netdisco/mailman/message/33128110/

The solution was to upgrade to SNMP::Info 3.23. What version of SNMP::Info are you running?

Steven

-----De Bruyne Karel <karel.debru...@uantwerpen.be> wrote: -----
To: "netdisco-users@lists.sourceforge.net" <netdisco-users@lists.sourceforge.net>
From: De Bruyne Karel <karel.debru...@uantwerpen.be>
Date: 12/10/2015 05:57AM
Subject: [Netdisco] discovery of Cisco 6500 : duplicate key value

I’ve got a rather big network (>500 Cisco switches).

 

A few weeks ago I discovered Netdisco, and I really like it.

A lot of the tools we wrote ourselves can be replaced by it.

 

I’ve got a small problem : the discovery of my network isn’t complete…

 

I always get errors when discovering two of our main routers (Cisco 6500 series):

 

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"

DETAIL:  Key (ip, port, vlan, native)=(143.129.xxx.yyy, GigabitEthernet2/16, 1, t) already exists.' at populate slice:

{

  ip => "143.129.xxx.yyy",

  last_discover => \"now()",

  native => "t",

  port => "GigabitEthernet2/16",

  vlan => 1,

  vlantype => "static"

} at /home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 487

 

Even when I delete these devices and re-discover it, I still get these error.

 

How could I solve this?

 

Kind Regards,

 

Karel De Bruyne

University of Antwerp

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

--- End Message ---
--- Begin Message --- Hi Christian,

I've made these exact observations and fixed the code for our organization for a few months now, but haven't gotten around to cleaning it up so I could provide patches to the community.

I'll try and get around to doing this during the holidays.

As per Oliver's observations, the real solution is to get "slices" or "pages" of results at a time.

Steven

-----Christian Ramseyer <r...@networkz.ch> wrote: -----
To: netdisco-users@lists.sourceforge.net
From: Christian Ramseyer <r...@networkz.ch>
Date: 12/14/2015 11:21AM
Subject: Re: [Netdisco] Search failed! Please contact your site administrator (netdisco2)

On 14/12/15 10:49, Oliver Gorwits wrote:
>
> ... I should add that there is no reason we could not improve the
> performance, but for a lack of time. I agree that it can and should be
> better!
>
> So if anyone would like to take a look at the DB queries, or submit
> patches for the web frontend, I would be very welcome indeed.
>
> To enable debugging to see the DB queries, run this in your terminal
> and visit Netdisco on port 5001:
>
> DBIC_TRACE=1 ~/bin/localenv plackup -p 5001 bin/netdisco-web-fg
>


Hi

I did in fact have a look at the issue a few days ago and tried the view
on some of our big boxes. What I have observed when viewing a 6500 with
some 300 ports and a bunch of columns like connected nodes enabled:

1. the actual SQL is not too bad, it finishes after maybe 10 seconds

2. the real problem seems to be the huge nested hash that gets assembled
by DBIx::Class when we call $set->all, it takes around 40 seconds to
build and makes the starman process grow to 1.3GB for my device. However
I was not able to get the search failed message in any case, maybe it's
just a question of having enough RAM/swap or liberal ulimits for the
netdisco user.

Unfortunately I have no practical experience with DBIx::Class. The
manual mentions HashRefInflator
( http://search.cpan.org/~ribasushi/DBIx-Class-0.082820/lib/DBIx/Class/ResultClass/HashRefInflator.pm )
as a lightweight way to access large results, maybe just switching to
this would be good enough.

Another harder to implement, but probably more promisiong solution would
be to only fetch the port names first, sort it, and then only retrieve
the full DBIx object trees for the interfaces on the current page.

Let's see, maybe I can have a look over these annoyingly long holidays
that are coming up :) Otherwise I hope this information might be helpful
to someone.

Christian






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

--- End Message ---
--- Begin Message --- 
I am running version 3.30

cpan[3]> i /SNMP::Info/
Module  = SNMP::Info             (OLIVER/SNMP-Info-3.30.tar.gz)
cpan[4]> install SNMP::Info
SNMP::Info is up to date (3.30).

Kind regards,
Karel

________________________________
Van: Steven Xu [stev...@yorku.ca]
Verzonden: dinsdag 22 december 2015 15:29
Aan: De Bruyne Karel
CC: netdisco-users@lists.sourceforge.net
Onderwerp: Re: [Netdisco] discovery of Cisco 6500 : duplicate key value

Hi,

There was a previous mailing thread about the 6500 series on a similar symptom. 
See https://sourceforge.net/p/netdisco/mailman/message/33128110/

The solution was to upgrade to SNMP::Info 3.23. What version of SNMP::Info are 
you running?

Steven

-----De Bruyne Karel <karel.debru...@uantwerpen.be> wrote: -----
To: "netdisco-users@lists.sourceforge.net" 
<netdisco-users@lists.sourceforge.net>
From: De Bruyne Karel <karel.debru...@uantwerpen.be>
Date: 12/10/2015 05:57AM
Subject: [Netdisco] discovery of Cisco 6500 : duplicate key value

I’ve got a rather big network (>500 Cisco switches).

A few weeks ago I discovered Netdisco, and I really like it.
A lot of the tools we wrote ourselves can be replaced by it.

I’ve got a small problem : the discovery of my network isn’t complete…

I always get errors when discovering two of our main routers (Cisco 6500 
series):

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"
DETAIL:  Key (ip, port, vlan, native)=(143.129.xxx.yyy, GigabitEthernet2/16, 1, 
t) already exists.' at populate slice:
{
  ip => "143.129.xxx.yyy",
  last_discover => \"now()",
  native => "t",
  port => "GigabitEthernet2/16",
  vlan => 1,
  vlantype => "static"
} at /home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 487

Even when I delete these devices and re-discover it, I still get these error.

How could I solve this?

Kind Regards,

Karel De Bruyne
University of Antwerp
------------------------------------------------------------------------------
_______________________________________________
Netdisco mailing list
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users

--- End Message ---
--- Begin Message --- 
I am a newbie to NetDisco and was able to install Netdisco successfully.  Now 
that I have cisco devices showing up, is there a way for me to change the 
homepage layout to have something else than By Platform?  I have over 300 cisco 
devices in 4 different sites.  I would to group the cisco devices by sites or 
location so it would be easier to see where the Cisco devices are located.  Any 
help would be appreciated.

John Tran
Senior Systems Network Engineer

[cid:image80d140.PNG@d274cd99.40b8cd58]

T +1 215 660 8500 Ext:7183
E john.t...@almacgroup.com<mailto:john.t...@almacgroup.com>
25 Fretz Road | Souderton PA 18964 | United States of America

www.almacgroup.com<http://www.almacgroup.com>

[cid:imagef07b7f.PNG@9615d5ca.4ba7d913]


The contents of this message and any attachments to it are confidential and may 
be legally privileged. If you have received this message in error, you should 
delete it from your system immediately and advise the sender.

Almac Group (UK) Limited, registered no. NI061368.  Almac Sciences Limited, 
registered no. NI041550.  Almac Discovery Limited, registered no. NI046249.  
Almac Pharma Services Limited, registered no. NI045055.  Almac Clinical 
Services Limited, registered no. NI041905.  Almac Clinical Technologies 
Limited, registered no. NI061202.  Almac Diagnostics Limited, registered no. 
NI043067.  All preceding companies are registered in Northern Ireland with a 
registered office address of Almac House, 20 Seagoe Industrial Estate, 
Craigavon, BT63 5QD, UK.

Almac Sciences (Scotland) Limited, registered in Scotland no. SC154034.

Almac Clinical Services LLC, Almac Clinical Technologies LLC and Almac 
Diagnostics LLC are Delaware limited liability companies and Almac Group 
Incorporated is a Delaware Corporation.  More information on the Almac Group 
can be found on the Almac website: www.almacgroup.com

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

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

Reply via email to