Send netdisco-users mailing list submissions to
netdisco-users@lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
netdisco-users-requ...@lists.sourceforge.net
You can reach the person managing the list at
netdisco-users-ow...@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. FATAL: the database system is in recovery mode (Ricardo Stella)
--- Begin Message ---
I have a netdisco instance under docker. System has been running for a
couple of months now, but needed to run a discover command to add a new
switch that wasn't being detected.
Here's what I get when running netdisco-do:
root@nettools:/home# docker-compose -p "netdisco" run netdisco-do discover
-d 10.10.90.250
Creating netdisco_netdisco-do_run ... done
Attempting to create directory /home/netdisco/perl5
[1] 2024-02-28 15:30:13 info App::Netdisco version 2.072003 loaded.
[1] 2024-02-28 15:30:13 info discover: [10.10.90.250] started at Wed Feb
28 15:30:13 2024
[1] 2024-02-28 15:38:56 error bless( {'msg' =>
'DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
connect(\'dbname=netdisco;host=netdisco-postgresql\',\'netdisco\',...)
failed: connection to server at "netdisco-postgresql" (172.21.0.4), port
5432 failed: FATAL: the database system is in recovery mode at
/home/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1639. at
/home/netdisco/perl5/lib/perl5/App/Netdisco/JobQueue/PostgreSQL.pm line 392
'}, 'DBIx::Class::Exception' )
[1] 2024-02-28 15:38:56 info discover: finished at Wed Feb 28 15:38:56 2024
[1] 2024-02-28 15:38:56 info discover: status error:
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
connect('dbname=netdisco;host=netdisco-postgresql','netdisco',...) failed:
connection to server at "netdisco-postgresql" (172.21.0.4), port 5432
failed: FATAL: the database system is in recovery mode at
/home/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1639. at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Discover/Snapshot.pm
line 22
ERROR: 1
Then, netdisco-backend.log goes crazy with output with the following errors:
[5114] 2024-02-28 15:52:28 error bless( {'msg' =>
'DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
execute failed: ERROR: could not read block 0 in file "base/16385/49720":
read only 0 of 8192 bytes [for Statement "UPDATE admin SET finished = ?,
log = ?, started = ?, status = ? WHERE ( job = ? )" with ParamValues:
1=\'Wed Feb 28 15:52:28 2024\', 2=\'Primed device action skip list\',
3=\'Wed Feb 28 15:52:28 2024\', 4=\'done\', 5=\'0\'] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/JobQueue/PostgreSQL.pm line 255
'}, 'DBIx::Class::Exception' )
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
execute failed: ERROR: could not read block 0 in file "base/16385/49720":
read only 0 of 8192 bytes [for Statement "SELECT me.job, me.entered,
me.started, me.finished, me.device, me.port, me.action, me.subaction,
me.status, me.username, me.userip, me.log, me.debug, me.device_key,
me.backend FROM admin me WHERE ( ( backend = ? AND started >
(LOCALTIMESTAMP - ?::interval) AND status = ? ) )" with ParamValues: 1='
0e6e95e95671.pds.org', 2='3000', 3='queued'] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/JobQueue/PostgreSQL.pm line 149
Looks like the whole DB got corrupted. Any ideas? If not, I guess I could
just wipe the netdisco/pgdata directory and start over?
TIA.
--
°(((=((===°°°(((================================================
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
