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. (solved) Re: Constant "Error while inserting ArpCache'
messages in syslog (Roberto Greiner)
----------------------------------------------------------------------
Message: 1
Date: Wed, 07 May 2014 08:14:25 -0300
From: Roberto Greiner <[email protected]>
Subject: [Netdot-users] (solved) Re: Constant "Error while inserting
ArpCache' messages in syslog
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
I found out what was happening. Carlos's idea was indeed right. I found
that, in some moment, I removed a comment in the netdot crontab file in
the line '0 1-11,13-16,18-23 * * * root $PREFIX/bin/updatedevices.pl
-DFA', but failed to comment the '-DIFAT' line in at the beginning of
file file. So, I had indeed two 'updatedevice.pl' instances running at
the same time. I corrected that error and the messages are gone.
Sorry for the mistake.
Roberto Greiner
On 28/04/2014 10:17, Roberto Greiner wrote:
> The MySQL restart did not solve the problem. I'm still getting the same
> "Could not insert ArpCache" syslog messages. Does somebody know what
> could be the problem?
>
> Thanks,
>
> Roberto
>
> On 25/04/2014 15:15, Roberto Greiner wrote:
>> No other instance was running. But running the process manually, it took
>> a long time to finish (almost 2 minutes), and ended with the following
>> error:
>> ERROR - DBD::mysql::st execute failed: Lock wait timeout exceeded; try
>> restarting transaction [for Statement "INSERT INTO ipblock
>>
>> (address,prefix,version,status,first_seen,last_seen)
>> VALUES (?, ?, ?, ?, ?, ?)
>> ON DUPLICATE KEY UPDATE
>> last_seen=VALUES(last_seen);" with ParamValues:
>> 0='53174322907827205988022887441789636709', 1=128, 2=6,
>> 3=IpblockStatus=HASH(0x5e280e0), 4='2014/04/25 15:06:33', 5='2014/04/25
>> 15:06:33'] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52.
>>
>> This looks like there is some deadlock in MySQL, so I forced a restart
>> in MySQL, which crashed a query (where none should be running). I ran
>> the same command again, and this time it finished quickly and without
>> errors. The problem seems to have been cleared. Will see for the next
>> hours if new messages are generated.
>>
>> Thanks,
>>
>> Roberto
>>
>> On 25/04/2014 12:20, Carlos Vicente wrote:
>>> Hi Roberto,
>>>
>>> I have never seen this one. Are you sure that there isn?t another
>>> updatedevices process running at the same time?
>>>
>>> cv
>>>
>>> On Apr 25, 2014, at 11:16 AM, Roberto Greiner <[email protected]> wrote:
>>>
>>>> Hi,
>>>>
>>>> I'm running netdot 1.0.6 (upgraded two days ago from 1.0.5RC1, my
>>>> initial version). I'm getting frequent syslog messages like the
>>>> following one:
>>>>
>>>> Apr 25 10:00:13 leonis netdot: WARN - Device 3com8.ipiranga.unesp.br:
>>>> Could not insert ArpCache at 2014/04/25 10:00:03: Error while inserting
>>>> ArpCache: Can't insert new ArpCache: DBD::mysql::st execute failed:
>>>> Duplicate entry '7-2014-04-25 10:00:03' for key 'arpcache1' [for
>>>> Statement "INSERT INTO arpcache (tstamp, device)#012VALUES (?, ?)#012"
>>>> with ParamValues: 0='2014/04/25 10:00:03', 1='7'] at
>>>> /usr/share/perl5/DBIx/ContextualFetch.pm line 52.#012 at
>>>> /usr/local/netdot/bin/updatedevices.pl line 213#012
>>>>
>>>> They occur at full hours, except at midnight, midday and 5:00PM,
>>>> coinciding with the following cronjob:
>>>>
>>>> # Retrieve forwarding tables and ARP caches
>>>> 0 1-11,13-16,18-23 * * * root $PREFIX/bin/updatedevices.pl -DFA
>>>>
>>>> When a device, like 3Com8 in the example above, generates those messages
>>>> and I disable SNMP management in Netdot, I don't get any more messages
>>>> indicating errors for this device. Problem is that I have already
>>>> disabled many of the devices, and new ones appeared. I started getting
>>>> those errors for all my DLink switches, now I'm getting them for my 3Com
>>>> switches. I couldn't find any reference in the web to this error. Could
>>>> someone help me?
>>>>
>>>> Thanks,
>>>>
>>>> Roberto
>>>>
>>>> PS: Netdot running in a Debian 7-64bits VM, with everything, except
>>>> Netdot itself, installed from the APT repositories.
>>>>
>>>> --
>>>> -----------------------------------------------------
>>>> Marcos Roberto Greiner
>>>>
>>>> Os otimistas acham que estamos no melhor dos mundos
>>>> Os pessimistas tem medo de que isto seja verdade
>>>> James Branch Cabell
>>>> -----------------------------------------------------
>>>>
>>>> _______________________________________________
>>>> Netdot-users mailing list
>>>> [email protected]
>>>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
--
-----------------------------------------------------
Marcos Roberto Greiner
Os otimistas acham que estamos no melhor dos mundos
Os pessimistas tem medo de que isto seja verdade
James Branch Cabell
-----------------------------------------------------
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 66, Issue 3
*******************************************
