Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-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 Netdot-users digest..."
Today's Topics:
1. Re: High CPU on Brocade Ethernet router when polled
(Newton, Terry M)
2. Re: Error When deleting a host (Carlos Vicente)
3. Re: Error When deleting a host (Michael T. Voity)
4. Re: Error When deleting a host (Carlos Vicente)
5. Re: Error When deleting a host (Michael T. Voity)
6. Re: Error When deleting a host (Carlos Vicente)
7. Re: Error When deleting a host (Michael T. Voity)
8. Re: Error When deleting a host (Carlos Vicente)
----------------------------------------------------------------------
Message: 1
Date: Wed, 2 Oct 2013 19:00:57 +0000
From: "Newton, Terry M" <[email protected]>
Subject: Re: [Netdot-users] High CPU on Brocade Ethernet router when
polled
To: "'Carlos Vicente'" <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID:
<[email protected]>
Content-Type: text/plain; charset="us-ascii"
I guess it depends on what you consider big. Current ARP table for that router
is 2,051 and mac table is 2,300.
Terry Newton
Network Engineering
(501) 686-5218
-----Original Message-----
From: Carlos Vicente [mailto:[email protected]]
Sent: Wednesday, October 02, 2013 12:59 PM
To: Newton, Terry M
Cc: [email protected]
Subject: Re: [Netdot-users] High CPU on Brocade Ethernet router when polled
Hi Terry,
How big are your ARP tables?
If your tables are huge, that may be the reason. You have two options:
a) Reduce your ARP tables by segmenting your network with more routers (easy to
say, I know)
b) Write a CLI subclass (like the ones under
lib/Netdot/Model/Device/CLI/*) to get those via SSH instead of SNMP.
cv
On 10/2/13 1:41 PM, Newton, Terry M wrote:
>
> I am using Brocade Ethernet routers and whenever netdot polls the
> device, it runs up the cpu and causes adverse effects. I have turned
> off the bulk snmp, but that did not make a differenct. Any
> suggestions? I really would like to use netdot to poll and collect
> information from these devices so any suggestions are appreciated.
> Thanks.
>
>
>
> ----------------------------------------------------------------------
> -- Confidentiality Notice: This e-mail message, including any
> attachments, is for the sole use of the intended recipient(s) and may
> contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not
> the intended recipient, please contact the sender by reply e-mail and
> destroy all copies of the original message.
>
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
----------------------------------------------------------------------
Confidentiality Notice: This e-mail message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.
------------------------------
Message: 2
Date: Wed, 02 Oct 2013 15:09:38 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Error When deleting a host
To: "Michael T. Voity" <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi Michael,
I seem to remember this issue from long ago.
Try this: Go to mysql and delete any backup tables with names like
fwtable_<number> and arpcache_<number>
Let me know if that doesn't help.
cv
On 10/1/13 3:55 PM, Michael T. Voity wrote:
> Hello,
>
> I am trying to delete a device that has been off my network for quite
> a while. I get this error message when i go to manually delete it:
>
> Ideas?
>
>
> Transaction aborted: Can't delete 296: DBD::mysql::st execute failed:
> Cannot delete or update a parent row: a foreign key constraint fails
> (`netdot`.`fwtable_1353833103`, CONSTRAINT `fk_device_5` FOREIGN KEY
> (`device`) REFERENCES `device` (`id`)) [for Statement "DELETE FROM
> device WHERE id=? " with ParamValues: 0='296'] at
> /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52, line 4.
>
> Stack: [/usr/local/share/perl5/DBIx/ContextualFetch.pm:52]
> [/usr/local/share/perl5/DBIx/ContextualFetch.pm:32]
> [/usr/local/share/perl5/Class/DBI.pm:737]
> [/usr/local/netdot/lib/Netdot/Model.pm:876]
> [/usr/local/netdot/lib/Netdot/Model/Device.pm:2377]
> [/usr/local/netdot/htdocs/generic/delete.html:161]
> [/usr/local/netdot/htdocs/generic/delete.html:163]
> [/usr/local/netdot/htdocs/autohandler:110]
> [/usr/local/netdot/htdocs/management/dhandler:1]
> [/usr/local/netdot/htdocs/management/autohandler:83]
> [/usr/local/share/perl5/HTML/Mason/Request.pm:951]
>
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]
>
>
[/usr/local/netdot/htdocs/autohandler:76]
> at /usr/local/netdot/htdocs/generic/delete.html line 161.
>
> Stack: [/usr/local/share/perl5/Carp.pm:100]
> [/usr/local/share/perl5/Class/DBI.pm:169]
> [/usr/local/share/perl5/Class/DBI.pm:175]
> [/usr/local/share/perl5/Class/DBI.pm:739]
> [/usr/local/netdot/lib/Netdot/Model.pm:876]
> [/usr/local/netdot/lib/Netdot/Model/Device.pm:2377]
> [/usr/local/netdot/htdocs/generic/delete.html:161]
> [/usr/local/netdot/htdocs/generic/delete.html:163]
> [/usr/local/netdot/htdocs/autohandler:110]
> [/usr/local/netdot/htdocs/management/dhandler:1]
> [/usr/local/netdot/htdocs/management/autohandler:83]
> [/usr/local/share/perl5/HTML/Mason/Request.pm:951]
>
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]
>
>
[/usr/local/netdot/htdocs/autohandler:76]
>
>
>
>
> -- Michael T. Voity Network Engineer University of Vermont
>
>
> _______________________________________________ Netdot-users mailing
> list [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 3
Date: Thu, 03 Oct 2013 10:56:59 -0400
From: "Michael T. Voity" <[email protected]>
Subject: Re: [Netdot-users] Error When deleting a host
To: Carlos Vicente <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Carlos,
That did the trick. I had some unrelated mysql errors that popped up
that guided me to fix the db.
When will the next version of NetDot be released?
Thanks,
-Mike
Michael T. Voity
Network Engineer
University of Vermont
On 10/2/2013 3:09 PM, Carlos Vicente wrote:
> Hi Michael,
>
> I seem to remember this issue from long ago.
>
> Try this: Go to mysql and delete any backup tables with names like
> fwtable_<number> and arpcache_<number>
>
> Let me know if that doesn't help.
>
> cv
>
> On 10/1/13 3:55 PM, Michael T. Voity wrote:
>> Hello,
>>
>> I am trying to delete a device that has been off my network for quite
>> a while. I get this error message when i go to manually delete it:
>>
>> Ideas?
>>
>>
>> Transaction aborted: Can't delete 296: DBD::mysql::st execute failed:
>> Cannot delete or update a parent row: a foreign key constraint fails
>> (`netdot`.`fwtable_1353833103`, CONSTRAINT `fk_device_5` FOREIGN KEY
>> (`device`) REFERENCES `device` (`id`)) [for Statement "DELETE FROM
>> device WHERE id=? " with ParamValues: 0='296'] at
>> /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52, line 4.
>>
>> Stack: [/usr/local/share/perl5/DBIx/ContextualFetch.pm:52]
>> [/usr/local/share/perl5/DBIx/ContextualFetch.pm:32]
>> [/usr/local/share/perl5/Class/DBI.pm:737]
>> [/usr/local/netdot/lib/Netdot/Model.pm:876]
>> [/usr/local/netdot/lib/Netdot/Model/Device.pm:2377]
>> [/usr/local/netdot/htdocs/generic/delete.html:161]
>> [/usr/local/netdot/htdocs/generic/delete.html:163]
>> [/usr/local/netdot/htdocs/autohandler:110]
>> [/usr/local/netdot/htdocs/management/dhandler:1]
>> [/usr/local/netdot/htdocs/management/autohandler:83]
>> [/usr/local/share/perl5/HTML/Mason/Request.pm:951]
>>
> [/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]
>>
> [/usr/local/netdot/htdocs/autohandler:76]
>> at /usr/local/netdot/htdocs/generic/delete.html line 161.
>>
>> Stack: [/usr/local/share/perl5/Carp.pm:100]
>> [/usr/local/share/perl5/Class/DBI.pm:169]
>> [/usr/local/share/perl5/Class/DBI.pm:175]
>> [/usr/local/share/perl5/Class/DBI.pm:739]
>> [/usr/local/netdot/lib/Netdot/Model.pm:876]
>> [/usr/local/netdot/lib/Netdot/Model/Device.pm:2377]
>> [/usr/local/netdot/htdocs/generic/delete.html:161]
>> [/usr/local/netdot/htdocs/generic/delete.html:163]
>> [/usr/local/netdot/htdocs/autohandler:110]
>> [/usr/local/netdot/htdocs/management/dhandler:1]
>> [/usr/local/netdot/htdocs/management/autohandler:83]
>> [/usr/local/share/perl5/HTML/Mason/Request.pm:951]
>>
> [/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]
>>
> [/usr/local/netdot/htdocs/autohandler:76]
>>
>>
>>
>> -- Michael T. Voity Network Engineer University of Vermont
>>
>>
>> _______________________________________________ Netdot-users mailing
>> list [email protected]
>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 4
Date: Thu, 03 Oct 2013 11:11:11 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Error When deleting a host
To: "Michael T. Voity" <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
On 10/3/13 10:56 AM, Michael T. Voity wrote:
> Carlos,
>
>
> That did the trick. I had some unrelated mysql errors that popped
> up that guided me to fix the db.
>
Glad to know.
> When will the next version of NetDot be released?
>
Working on it. It's taking longer than usual this time.
Regards,
cv
------------------------------
Message: 5
Date: Thu, 03 Oct 2013 11:18:30 -0400
From: "Michael T. Voity" <[email protected]>
Subject: Re: [Netdot-users] Error When deleting a host
To: Carlos Vicente <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Carlos,
Good to hear that there is a new version coming soon.
I did find some tables named - "fwtableentry_<number>" and
"arpcacheentry_<number>" in my db. Should these tables be dropped too?
-Mike
Michael T. Voity
Network Engineer
University of Vermont
On 10/3/2013 11:11 AM, Carlos Vicente wrote:
> On 10/3/13 10:56 AM, Michael T. Voity wrote:
>> Carlos,
>>
>>
>> That did the trick. I had some unrelated mysql errors that popped
>> up that guided me to fix the db.
>>
> Glad to know.
>
>> When will the next version of NetDot be released?
>>
> Working on it. It's taking longer than usual this time.
>
> Regards,
>
> cv
------------------------------
Message: 6
Date: Thu, 03 Oct 2013 11:22:49 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Error When deleting a host
To: "Michael T. Voity" <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
On 10/3/13 11:18 AM, Michael T. Voity wrote:
> Carlos,
>
> Good to hear that there is a new version coming soon.
>
> I did find some tables named - "fwtableentry_<number>" and
> "arpcacheentry_<number>" in my db. Should these tables be dropped
> too?
Yes, you should remove those. Otherwise you may get more foreign key
errors when deleting stuff.
Best,
cv
------------------------------
Message: 7
Date: Thu, 03 Oct 2013 11:36:15 -0400
From: "Michael T. Voity" <[email protected]>
Subject: Re: [Netdot-users] Error When deleting a host
To: Carlos Vicente <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
I did get those errors -
The fix was -
use netdot;
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE ....;
SET FOREIGN_KEY_CHECKS=1;
Thanks,
-Mike
Michael T. Voity
Network Engineer
University of Vermont
On 10/3/2013 11:22 AM, Carlos Vicente wrote:
>
> On 10/3/13 11:18 AM, Michael T. Voity wrote:
>> Carlos,
>>
>> Good to hear that there is a new version coming soon.
>>
>> I did find some tables named - "fwtableentry_<number>" and
>> "arpcacheentry_<number>" in my db. Should these tables be dropped
>> too?
> Yes, you should remove those. Otherwise you may get more foreign key
> errors when deleting stuff.
>
> Best,
>
> cv
------------------------------
Message: 8
Date: Thu, 03 Oct 2013 11:54:20 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Error When deleting a host
To: "Michael T. Voity" <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
OK, but what I meant is that those tables could cause errors in the
Netdot UI when deleting devices, like what happened to you at the
beginning of this thread.
cv
On 10/3/13 11:36 AM, Michael T. Voity wrote:
> I did get those errors -
>
> The fix was -
> use netdot;
> SET FOREIGN_KEY_CHECKS=0;
> DROP TABLE ....;
> SET FOREIGN_KEY_CHECKS=1;
>
>
> Thanks,
>
> -Mike
>
>
> Michael T. Voity
> Network Engineer
> University of Vermont
>
> On 10/3/2013 11:22 AM, Carlos Vicente wrote:
>>
>> On 10/3/13 11:18 AM, Michael T. Voity wrote:
>>> Carlos,
>>>
>>> Good to hear that there is a new version coming soon.
>>>
>>> I did find some tables named - "fwtableentry_<number>" and
>>> "arpcacheentry_<number>" in my db. Should these tables be dropped
>>> too?
>> Yes, you should remove those. Otherwise you may get more foreign key
>> errors when deleting stuff.
>>
>> Best,
>>
>> cv
>
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 59, Issue 3
*******************************************
