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