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