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: Database error message when discover (Christian Ramseyer)
2. Re: Database error message when discover (Oliver B?hrig)
--- Begin Message ---
I got curious and tried to find the source. In our case it's always
invalid if- or entity indexes. I've created an issue:
https://github.com/netdisco/netdisco/issues/729
Cheers
Christian
On 25.06.20 12:44, Oliver Bührig wrote:
> Hi all,
>
> I am running Netdisco Version
>
> App::Netdisco 2.42.10
> SNMP::Info 3.68
> DB Schema 58
> PostgreSQL 11.00.8
> Perl 5.16.3
>
> I have found the this message in the Postgres log file.
>
> 2020-06-25 10:01:55.644 CEST [31889] ERROR: current transaction is
> aborted, commands ignored until end of transaction block
> 2020-06-25 10:01:55.644 CEST [31889] STATEMENT: INSERT INTO
> device_port_properties ( ifindex, ip, port, raw_speed) VALUES ( $1, $2,
> $3, $4 )
> 2020-06-25 10:01:55.644 CEST [31889] ERROR: current transaction is
> aborted, commands ignored until end of transaction block
> 2020-06-25 10:01:55.644 CEST [31889] STATEMENT: INSERT INTO
> device_port_properties ( ifindex, ip, port, raw_speed) VALUES ( $1, $2,
> $3, $4 )
> 2020-06-25 10:01:55.644 CEST [31889] ERROR: current transaction is
> aborted, commands ignored until end of transaction block
> 2020-06-25 10:01:55.644 CEST [31889] STATEMENT: INSERT INTO
> device_port_properties ( ifindex, ip, port, raw_speed) VALUES ( $1, $2,
> $3, $4 )
>
> rund about 1500 times each discovery run
>
> I can not find which devices produce this behaviour. Is there a way to
> debug is a little bit deeper ?
>
> Regards,
>
> Oliver Buehrig
>
>
>
>
>
--- End Message ---
--- Begin Message ---
Hi CChristian,
I switched on logging in postgres config and got some further
information from logs.
2020-06-26 06:02:06.605 CEST [7336] ERROR: current transaction is
aborted, commands ignored until end of transaction block
2020-06-26 06:02:06.605 CEST [7336] ERROR: current transaction is
aborted, commands ignored until end of transaction block
for this case is no additional log information available ...
but later in the logfile are may lines with an error
2020-06-26 06:02:34.367 CEST [15108] DETAIL: parameters: $1 =
'duplicate of 16632570', $2 = 'error', $3 = 'X.Y.8.52', $4 = 'discover',
$5 = '16632570', $6 = 'X.Y.8.52', $7 = 'discover', $8 = '00:50:00', $9 =
'queued-%', $10 = '16632570', $11 = 'queued'
2020-06-26 06:02:34.459 CEST [15108] DETAIL: parameters: $1 =
'duplicate of 16632179', $2 = 'error', $3 = 'X.Y.14.66', $4 =
'discover', $5 = '16632179', $6 = 'X.Y.14.66', $7 = 'discover', $8 =
'00:50:00', $9 = 'queued-%', $10 = '16632179', $11 = 'queued'
X and Y in the IP address was changed, due to securtiy reason, in the
log is it correct !
The count of the ip address ist the number of devices in the database.
In the database are devices from Cisco, Arista, Juniper, HP, Allied and
Brocade.
Maybe it helps a little bit
Many thanks for your help and for creating an issue.
Best regards,
Oliver
On 25.06.20 17:38, Christian Ramseyer wrote:
> I got curious and tried to find the source. In our case it's always
> invalid if- or entity indexes. I've created an issue:
>
> https://github.com/netdisco/netdisco/issues/729
>
> Cheers
> Christian
>
> On 25.06.20 12:44, Oliver Bührig wrote:
>> Hi all,
>>
>> I am running Netdisco Version
>>
>> App::Netdisco 2.42.10
>> SNMP::Info 3.68
>> DB Schema 58
>> PostgreSQL 11.00.8
>> Perl 5.16.3
>>
>> I have found the this message in the Postgres log file.
>>
>> 2020-06-25 10:01:55.644 CEST [31889] ERROR: current transaction is
>> aborted, commands ignored until end of transaction block
>> 2020-06-25 10:01:55.644 CEST [31889] STATEMENT: INSERT INTO
>> device_port_properties ( ifindex, ip, port, raw_speed) VALUES ( $1, $2,
>> $3, $4 )
>> 2020-06-25 10:01:55.644 CEST [31889] ERROR: current transaction is
>> aborted, commands ignored until end of transaction block
>> 2020-06-25 10:01:55.644 CEST [31889] STATEMENT: INSERT INTO
>> device_port_properties ( ifindex, ip, port, raw_speed) VALUES ( $1, $2,
>> $3, $4 )
>> 2020-06-25 10:01:55.644 CEST [31889] ERROR: current transaction is
>> aborted, commands ignored until end of transaction block
>> 2020-06-25 10:01:55.644 CEST [31889] STATEMENT: INSERT INTO
>> device_port_properties ( ifindex, ip, port, raw_speed) VALUES ( $1, $2,
>> $3, $4 )
>>
>> rund about 1500 times each discovery run
>>
>> I can not find which devices produce this behaviour. Is there a way to
>> debug is a little bit deeper ?
>>
>> Regards,
>>
>> Oliver Buehrig
>>
>>
>>
>>
>>
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
