--- Begin Message ---
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 ---
