Send netdisco-users mailing list submissions to
[email protected]
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
[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 netdisco-users digest..."
Today's Topics:
1. netmap_positions database error (was: Re: Netdisco 2.46.2
issues) (Oliver Gorwits)
2. Re: netmap_positions database error (was: Re: Netdisco 2.46.2
issues) (Muris)
--- Begin Message ---
Hi Muris
I think there is a problem with your local database schema. This constraint
on (host_groups, vlan) should not be there! It looks like database schema
version 51 was not properly applied.
Please would you send the output of:
bin/netdisco-do psql -e '\d netmap_positions'
thanks,
oliver.
On Tue, 13 Oct 2020 at 04:00, Muris <[email protected]> wrote:
> Is there a way to revert back to the previous version of netdisco ?
>
>
>
> Doesn’t seem there is a fix for this, and its getting really annoying,
> like searching devices doesn’t show up anything and then having to refresh
> it multiple time for items to show… seems to be a lot of crashing going on
> with the DBIx
>
>
>
> Netdisco-web log:
>
>
>
> [2631] 2020-10-12 00:18:08 warn App::Netdisco 2.046002 web
>
> [2632] 2020-10-12 01:30:36 error request to POST
> /ajax/data/device/netmappositions crashed:
> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
> execute failed: ERROR: duplicate key value violates unique co$
>
> DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement
> "INSERT INTO netmap_positions ( device, host_groups, locations, positions,
> vlan) VALUES ( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues:
> 1='10.16.50.12$
>
> [2630] 2020-10-12 01:40:43 error request to POST
> /ajax/data/device/netmappositions crashed:
> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
> execute failed: ERROR: duplicate key value violates unique co$
>
> DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement
> "INSERT INTO netmap_positions ( device, host_groups, locations, positions,
> vlan) VALUES ( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues:
> 1='10.20.93.1'$
>
> [2631] 2020-10-12 01:41:06 error request to POST
> /ajax/data/device/netmappositions crashed:
> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
> execute failed: ERROR: duplicate key value violates unique co$
>
> DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement
> "INSERT INTO netmap_positions ( device, host_groups, locations, positions,
> vlan) VALUES ( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues:
> 1='10.20.93.1'$
>
> 2020/10/12-12:26:18 Starman::Server (type Net::Server::PreFork) starting!
> pid(18362)
>
>
>
> [2632] 2020-10-12 02:11:27 error request to POST
> /ajax/data/device/netmappositions crashed:
> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
> execute failed: ERROR: duplicate key value violates unique co$
>
> DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement
> "INSERT INTO netmap_positions ( device, host_groups, locations, positions,
> vlan) VALUES ( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues:
> 1='10.16.50.13$
>
> [2630] 2020-10-12 02:11:48 error request to POST
> /ajax/data/device/netmappositions crashed:
> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
> execute failed: ERROR: duplicate key value violates unique co$
>
> DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement
> "INSERT INTO netmap_positions ( device, host_groups, locations, positions,
> vlan) VALUES ( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues:
> 1='10.16.50.13$
>
> Use of uninitialized value $args{"mac"} in pattern match (m//) at
> /home/netdisco/perl5/lib/perl5/NetAddr/MAC.pm line 128.
>
> 2020/10/13-00:00:10 Starman::Server (type Net::Server::PreFork) starting!
> pid(12917)
>
> Resolved [*]:5000 to [::]:5000, IPv6
>
>
>
> *From: *Muris <[email protected]>
> *Date: *Wednesday, 7 October 2020 at 11:59
> *To: *Pavel Skovajsa <[email protected]>, Joseph Bernard <
> [email protected]>, "[email protected]" <
> [email protected]>
> *Subject: *Re: [Netdisco] Netdisco 2.46.2 issues
>
>
>
> Im still experiencing this issue, only way to fix it is to keep restarting
> netdisco-web on a continual basis
>
>
>
> *From: *Muris <[email protected]>
> *Date: *Monday, 28 September 2020 at 13:35
> *To: *Pavel Skovajsa <[email protected]>, Joseph Bernard <
> [email protected]>
> *Cc: *"[email protected]" <
> [email protected]>
> *Subject: *Re: [Netdisco] Netdisco 2.46.2 issues
>
>
>
> I haven’t done any OS upgrades myself, am running Red Hat Enterprise Linux
> and purely netdisco on there.
>
>
>
> Just ran a straight update from cpan and followed the prompts.
>
>
>
>
>
> *From: *Pavel Skovajsa <[email protected]>
> *Date: *Monday, 28 September 2020 at 03:13
> *To: *Joseph Bernard <[email protected]>
> *Cc: *"[email protected]" <
> [email protected]>
> *Subject: *Re: [Netdisco] Netdisco 2.46.2 issues
>
>
>
> Just checking, you did not update the perl libraries in the process did
> you? For example apt upgrade on debian? If you did, follow the CPAN upgrade
> entry text:
>
> ---------------------------------------
> Furthermore, whenever you upgrade your Operating System, you must delete
> the ~/perl5 directory and re-run the following command, to update
> Netdisco's C library bindings:
> curl -L https://cpanmin.us/ | perl - --notest --local-lib ~/perl5
> App::Netdisco
>
> ----------------------------------------
>
> -pavel
>
>
>
>
>
> On Thu, Sep 24, 2020 at 5:15 PM Joseph Bernard <[email protected]> wrote:
>
> Your problem sounds like mine, but I haven’t figured it out. My
> workaround is a cronjob that restarts netdisco-web every hour.
>
>
> Thanks,
> Joseph B.
>
> Sent from my iPhone
>
> > On Sep 24, 2020, at 9:32 AM, Muris <[email protected]> wrote:
> >
> > Hi Christian, yes I notice it is better when restarting the process or
> even rebooting machine , but after some time the same errors/things are
> seen and continue to occur.
> >
> > I think it’s a bug in DBIx as it does crash from looking at the webfront
> end logs.
> >
> > On 24/9/20, 2:48 am, "Christian Ramseyer" <[email protected]> wrote:
> >
> > Hi Muris
> >
> >
> >> On 23.09.20 07:12, Muris wrote:
> >> Yep i sure did update the schema
> >
> > I have also already seen weird behaviors after upgrading which went
> away
> > by restarting both Netdisco processes, did you by chance already try
> > that? The upgrade process does not do that on its own.
> >
> > Cheers
> > Christian
> >
> >
> >
> >
> >
> >
> > _______________________________________________
> > Netdisco mailing list
> > [email protected]
> > https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>
> _______________________________________________
> Netdisco mailing list
> [email protected]
> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>
> _______________________________________________
> Netdisco mailing list
> [email protected]
> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
Hi Oliver, thankyou for looking into this, I really appreciate it and
others.
Here is the output:
[20104] 2020-10-17 14:09:51 info App::Netdisco version 2.046002 loaded.
[20104] 2020-10-17 14:09:51 info psql: started at Sun Oct 18 00:39:51 2020
Table "public.netmap_positions"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+----------------------------------------------
id | integer | | not null |
nextval('netmap_positions_id_seq'::regclass)
host_groups | text[] | | not null | '{}'::text[]
vlan | integer | | not null | 0
positions | text | | not null |
device | inet | | |
locations | text[] | | not null | '{}'::text[]
Indexes:
"netmap_positions_pkey" PRIMARY KEY, btree (id)
"netmap_positions_device_groups_key" UNIQUE CONSTRAINT, btree
(host_groups, vlan)
[20104] 2020-10-17 14:09:51 info psql: finished at Sun Oct 18 00:39:51 2020
[20104] 2020-10-17 14:09:51 info psql: status done: psql session closed.
On Sat, Oct 17, 2020 at 11:53 PM Oliver Gorwits <[email protected]> wrote:
> Hi Muris
>
> I think there is a problem with your local database schema. This
> constraint on (host_groups, vlan) should not be there! It looks like
> database schema version 51 was not properly applied.
>
> Please would you send the output of:
>
> bin/netdisco-do psql -e '\d netmap_positions'
>
> thanks,
> oliver.
>
> On Tue, 13 Oct 2020 at 04:00, Muris <[email protected]> wrote:
>
>> Is there a way to revert back to the previous version of netdisco ?
>>
>>
>>
>> Doesn’t seem there is a fix for this, and its getting really annoying,
>> like searching devices doesn’t show up anything and then having to refresh
>> it multiple time for items to show… seems to be a lot of crashing going on
>> with the DBIx
>>
>>
>>
>> Netdisco-web log:
>>
>>
>>
>> [2631] 2020-10-12 00:18:08 warn App::Netdisco 2.046002 web
>>
>> [2632] 2020-10-12 01:30:36 error request to POST
>> /ajax/data/device/netmappositions crashed:
>> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
>> execute failed: ERROR: duplicate key value violates unique co$
>>
>> DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement
>> "INSERT INTO netmap_positions ( device, host_groups, locations, positions,
>> vlan) VALUES ( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues:
>> 1='10.16.50.12$
>>
>> [2630] 2020-10-12 01:40:43 error request to POST
>> /ajax/data/device/netmappositions crashed:
>> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
>> execute failed: ERROR: duplicate key value violates unique co$
>>
>> DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement
>> "INSERT INTO netmap_positions ( device, host_groups, locations, positions,
>> vlan) VALUES ( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues:
>> 1='10.20.93.1'$
>>
>> [2631] 2020-10-12 01:41:06 error request to POST
>> /ajax/data/device/netmappositions crashed:
>> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
>> execute failed: ERROR: duplicate key value violates unique co$
>>
>> DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement
>> "INSERT INTO netmap_positions ( device, host_groups, locations, positions,
>> vlan) VALUES ( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues:
>> 1='10.20.93.1'$
>>
>> 2020/10/12-12:26:18 Starman::Server (type Net::Server::PreFork) starting!
>> pid(18362)
>>
>>
>>
>> [2632] 2020-10-12 02:11:27 error request to POST
>> /ajax/data/device/netmappositions crashed:
>> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
>> execute failed: ERROR: duplicate key value violates unique co$
>>
>> DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement
>> "INSERT INTO netmap_positions ( device, host_groups, locations, positions,
>> vlan) VALUES ( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues:
>> 1='10.16.50.13$
>>
>> [2630] 2020-10-12 02:11:48 error request to POST
>> /ajax/data/device/netmappositions crashed:
>> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
>> execute failed: ERROR: duplicate key value violates unique co$
>>
>> DETAIL: Key (host_groups, vlan)=({}, 0) already exists. [for Statement
>> "INSERT INTO netmap_positions ( device, host_groups, locations, positions,
>> vlan) VALUES ( ?, ?, ?, ?, ? ) RETURNING id" with ParamValues:
>> 1='10.16.50.13$
>>
>> Use of uninitialized value $args{"mac"} in pattern match (m//) at
>> /home/netdisco/perl5/lib/perl5/NetAddr/MAC.pm line 128.
>>
>> 2020/10/13-00:00:10 Starman::Server (type Net::Server::PreFork) starting!
>> pid(12917)
>>
>> Resolved [*]:5000 to [::]:5000, IPv6
>>
>>
>>
>> *From: *Muris <[email protected]>
>> *Date: *Wednesday, 7 October 2020 at 11:59
>> *To: *Pavel Skovajsa <[email protected]>, Joseph Bernard <
>> [email protected]>, "[email protected]" <
>> [email protected]>
>> *Subject: *Re: [Netdisco] Netdisco 2.46.2 issues
>>
>>
>>
>> Im still experiencing this issue, only way to fix it is to keep
>> restarting netdisco-web on a continual basis
>>
>>
>>
>> *From: *Muris <[email protected]>
>> *Date: *Monday, 28 September 2020 at 13:35
>> *To: *Pavel Skovajsa <[email protected]>, Joseph Bernard <
>> [email protected]>
>> *Cc: *"[email protected]" <
>> [email protected]>
>> *Subject: *Re: [Netdisco] Netdisco 2.46.2 issues
>>
>>
>>
>> I haven’t done any OS upgrades myself, am running Red Hat Enterprise
>> Linux and purely netdisco on there.
>>
>>
>>
>> Just ran a straight update from cpan and followed the prompts.
>>
>>
>>
>>
>>
>> *From: *Pavel Skovajsa <[email protected]>
>> *Date: *Monday, 28 September 2020 at 03:13
>> *To: *Joseph Bernard <[email protected]>
>> *Cc: *"[email protected]" <
>> [email protected]>
>> *Subject: *Re: [Netdisco] Netdisco 2.46.2 issues
>>
>>
>>
>> Just checking, you did not update the perl libraries in the process did
>> you? For example apt upgrade on debian? If you did, follow the CPAN upgrade
>> entry text:
>>
>> ---------------------------------------
>> Furthermore, whenever you upgrade your Operating System, you must delete
>> the ~/perl5 directory and re-run the following command, to update
>> Netdisco's C library bindings:
>> curl -L https://cpanmin.us/ | perl - --notest --local-lib ~/perl5
>> App::Netdisco
>>
>> ----------------------------------------
>>
>> -pavel
>>
>>
>>
>>
>>
>> On Thu, Sep 24, 2020 at 5:15 PM Joseph Bernard <[email protected]> wrote:
>>
>> Your problem sounds like mine, but I haven’t figured it out. My
>> workaround is a cronjob that restarts netdisco-web every hour.
>>
>>
>> Thanks,
>> Joseph B.
>>
>> Sent from my iPhone
>>
>> > On Sep 24, 2020, at 9:32 AM, Muris <[email protected]> wrote:
>> >
>> > Hi Christian, yes I notice it is better when restarting the process or
>> even rebooting machine , but after some time the same errors/things are
>> seen and continue to occur.
>> >
>> > I think it’s a bug in DBIx as it does crash from looking at the
>> webfront end logs.
>> >
>> > On 24/9/20, 2:48 am, "Christian Ramseyer" <[email protected]> wrote:
>> >
>> > Hi Muris
>> >
>> >
>> >> On 23.09.20 07:12, Muris wrote:
>> >> Yep i sure did update the schema
>> >
>> > I have also already seen weird behaviors after upgrading which went
>> away
>> > by restarting both Netdisco processes, did you by chance already try
>> > that? The upgrade process does not do that on its own.
>> >
>> > Cheers
>> > Christian
>> >
>> >
>> >
>> >
>> >
>> >
>> > _______________________________________________
>> > Netdisco mailing list
>> > [email protected]
>> > https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>>
>> _______________________________________________
>> Netdisco mailing list
>> [email protected]
>> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>>
>> _______________________________________________
>> Netdisco mailing list
>> [email protected]
>> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>
>
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
