--- Begin Message ---
Thanks, looks better now I think? I loaded the new version also you published
few days ago.
[netdisco@]$ ./netdisco-do psql -e '\d netmap_positions'
[21839] 2020-10-19 01:10:11 info App::Netdisco version 2.046005 loaded.
[21839] 2020-10-19 01:10:11 info psql: started at Mon Oct 19 11:40:11 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)
From: Oliver Gorwits <[email protected]>
Date: Monday, 19 October 2020 at 03:52
To: Muris <[email protected]>, "[email protected]"
<[email protected]>
Subject: Re: [Netdisco] netmap_positions database error (was: Re: Netdisco
2.46.2 issues)
Oops I think that should have been:
netdisco-do psql -e 'ALTER TABLE netmap_positions DROP CONSTRAINT
"netmap_positions_device_groups_key"'
On Sun, 18 Oct 2020 at 01:39, Muris <[email protected]> wrote:
thanks, i tried that but didnt seem to like it
[netdisco@]$ ./netdisco-do psql -e 'DROP CONSTRAINT
"netmap_positions_device_groups_key"'
[23531] 2020-10-18 00:31:34 info App::Netdisco version 2.046002 loaded.
[23531] 2020-10-18 00:31:34 info psql: started at Sun Oct 18 11:01:34 2020
ERROR: syntax error at or near "CONSTRAINT"
LINE 1: DROP CONSTRAINT "netmap_positions_device_groups_key"
^
[23531] 2020-10-18 00:31:34 info psql: finished at Sun Oct 18 11:01:34 2020
[23531] 2020-10-18 00:31:34 info psql: status done: psql session closed.
On Sun, Oct 18, 2020 at 12:53 AM Oliver Gorwits <[email protected]> wrote:
Hi, so I’m not sure why your system is in this state.
This should fix it:
bin/netdisco-do psql -e 'DROP CONSTRAINT "netmap_positions_device_groups_key"'
Actually I see what might have gone wrong but you should be fine after this.
Maybe an update i shall do for other users.
Oliver.
On Sat, 17 Oct 2020 at 15:12, Muris <[email protected]> wrote:
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/
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
