Re: [Netdisco] Login

[Christian R. <ram...@ne...>]

On 09.04.21 20:06, Tim Polimeni wrote:
> Thanks it looks like I have some challenges as well after I updated to
> the lasted version I get the following as well 
> 
> 
> 
> Before we continue, the following prerequisites must be in place:
>  * Database added to PostgreSQL for Netdisco
>  * User added to PostgreSQL with rights to the Netdisco Database
>  * "~/environments/deployment.yml" file configured with Database
> dsn/user/pass
>  * A full backup of any existing Netdisco database data
>  * Internet access (for OUIs and MIBs)
> 
> If you are upgrading Netdisco 2 read the release notes:
> https://github.com/netdisco/netdisco/wiki/Release-Notes
> <https://github.com/netdisco/netdisco/wiki/Release-Notes>
> There you will find required and incompatible changes
> which are not covered by this script.
> 
> You will be asked to confirm all changes to your system.
> 
> So, is all of the above in place? [y/N]: y
> 
> Would you like to deploy the database schema? [y/N]: y
> DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently
> unversioned. Please call upgrade on your schema to sync the DB. at
> /home/netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 121
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed:
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
> connect('dbname=netdisco','netdisco',...) failed: FATAL:  remaining
> connection slots are reserved for non-replication superuser connections
> at /home/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1639.
> at /home/netdisco/perl5/bin/netdisco-db-deploy line 110 at
> /home/netdisco/perl5/bin/netdisco-db-deploy line 110
> DB schema update complete.
> DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently
> unversioned. Please call upgrade on your schema to sync the DB. at
> /home/netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 121
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
> connect('dbname=netdisco','netdisco',...) failed: FATAL:  remaining
> connection slots are reserved for non-replication superuser connections
> at /home/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1639.
> at /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/Statistics.pm line 37
> Updating statistics... [netdisco@netengsrv01 ~]$ 
> 
> 
> [netdisco@netengsrv01 ~]$ netdisco-do psql
> [3955495] 2021-04-09 18:06:06  info App::Netdisco version 2.047005 loaded.
> [3955495] 2021-04-09 18:06:06  info psql:  started at Fri Apr  9
> 14:06:06 2021
> psql: FATAL:  remaining connection slots are reserved for
> non-replication superuser connections
> [3955495] 2021-04-09 18:06:06  info psql: finished at Fri Apr  9
> 14:06:06 2021
> [3955495] 2021-04-09 18:06:06  info psql: status done: psql session closed.
> [netdisco@netengsrv01 ~]$ 
> 

Yes looks like your database is in some trouble. If this is a local
database just for Netdisco I'd just stop the netdisco-backend, this will
likely solve the issue and it does not need to run for netdisco-deploy.

If it does not solve the issue, try to also restart postgres or the
whole server as a low-effort fix attempt.

If you want to dig into the details try to connect to the database
directly with psql as user postgres, and look at pg_stat_activity to see
what's going on.

Cheers
Christian