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. Database error message when discover (Oliver B?hrig)
2. Re: Database error message when discover (Christian Ramseyer)
--- Begin Message ---
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
--
Oliver Bührig
IT-Kommunikationsnetzwerke
Deutsches Elektronen-Synchrotron
Ein Forschungszentrum der Helmholtz-Gemeinschaft
Notkestr. 85
22607 Hamburg
Germany
Tel. : +49 40 8998 2622
Fax : +49 40 8994 2622
E-Mail: oliver.bueh...@desy.de
--- End Message ---
--- Begin Message ---
Hi Oliver
The errors you posted are follow-up errors in a transaction that failed.
You can find the actual error by going up in the log until the
complaining starts.
Coincidentally I have the same errors here, the reason in our case is this:
2020-06-25 03:12:47.156 CEST [25581] ERROR: invalid input syntax for
type bigint: "10.0.97.110.97.103.101.109.101.110.116"
2020-06-25 03:12:47.156 CEST [25581] STATEMENT: INSERT INTO
device_port_properties ( ifindex, ip, port, raw_speed) VALUES ( $1, $2,
$3, $4 )
Then for every additional interface in the transaction there is a
follow-up error:
2020-06-25 03:12:47.156 CEST [25581] ERROR: current transaction is
aborted, commands ignored until end of transaction block
2020-06-25 03:12:47.156 CEST [25581] STATEMENT: INSERT INTO
device_port_properties ( ifindex, ip, port, raw_speed) VALUES ( $1, $2,
$3, $4 )
2020-06-25 03:12:47.156 CEST [25581] ERROR: current transaction is
aborted, commands ignored until end of transaction block
2020-06-25 03:12:47.156 CEST [25581] STATEMENT: INSERT INTO
device_port_properties ( ifindex, ip, port, raw_speed) VALUES ( $1, $2,
$3, $4 )
etc...
Unfortunately the log does not contain the parameter values for $2 etc.
To see which device it is, you'd need to enable log_statements = all in
Postgres (only temporarily, it will write a lot of logs).
In our case, I guess the bigint column mentioned is raw_speed, and the
10.109... is a garbage reply from some Cisco or Nokia device.
Do you also get this string or is it something else that fails for you?
Why don't you open a github issue and then we can try to track down
which devices are causing these discovery failures.
Cheers
Christian
--
Christian Ramseyer, netnea ag
Network Management. Security. OpenSource.
https://www.netnea.com
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