alex-s9s

-- *****************************************************************
-- SEVERALNINES-CLUSTERCONTROL-MIB
-- Severalnines ClusterControl SNMP MIB
--
-- 2022 01 05 10:29:28 - POC
--
-- Copyright (c) 2022 by Severalnines AB
-- All rights reserved.
-- *****************************************************************

alex-s9s

==
[23:50:35]:Failed to create backup.
[23:50:35]:<em style='color: #f3990b;'>10.0.8.18</em>:<em style='color: #0b33b5;'>/root/backups/BACKUP-0</em>: Preferring the global retention setting: 31 days (be deleted on 2020-12-13).
[23:50:34]:<em style='color: #d35400;'>10.0.8.15:27017</em>: Evaluating command by mongo client on the remote host: sh.setBalancerState(true);
[23:50:34]:<em style='color: #d35400;'>10.0.8.15:27017</em>: Enable the balancer process by issuing sh.setBalancerState(true).
[23:50:34]:Backup finished with failure.
[23:50:34]:Mongo node 10.0.8.18:27018 status: 1 role: shardsvr: Backup command failed.
Starting backup '2020-11-12T14:50:34Z'
StdErr:

alex-s9s

2020-11-12 08:02:16.150 UTC [21740] LOG:  abnormal database system shutdown
2020-11-12 08:02:16.175 UTC [21740] LOG:  database system is shut down
2020-11-12 08:02:20.219 UTC [6151] LOG:  starting PostgreSQL 13.0 (Ubuntu 13.0-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
2020-11-12 08:02:20.220 UTC [6151] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2020-11-12 08:02:20.223 UTC [6151] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-11-12 08:02:20.229 UTC [6152] LOG:  database system was interrupted; last known up at 2020-11-12 06:00:05 UTC
cp: cannot stat '/tmp/pg-restore-933946999/wal/00000005.history': No such file or directory
2020-11-12 08:02:20.424 UTC [6152] LOG:  starting archive recovery
cp: cannot stat '/tmp/pg-restore-933946999/wal/00000004.history': No such file or directory
2020-11-12 08:02:20.450 UTC [6152] LOG:  restored log file "0000000400000000000000C7" from archive

alex-s9s

root@c9:/var/lib/postgresql# tail -100 /var/log/postgresql/postgresql-10-main.log
2020-11-11 08:31:25.836 UTC [27701] postgres@postgres DETAIL:  Key (id)=(13) already exists.
2020-11-11 08:31:25.836 UTC [27701] postgres@postgres STATEMENT:  insert into alex.t4 values (13);
2020-11-11 08:31:41.125 UTC [27701] postgres@postgres ERROR:  duplicate key value violates unique constraint "t4_pkey"
2020-11-11 08:31:41.125 UTC [27701] postgres@postgres DETAIL:  Key (id)=(10) already exists.
2020-11-11 08:31:41.125 UTC [27701] postgres@postgres STATEMENT:  insert into alex.t4 values (10);
2020-11-12 10:10:43.746 UTC [10728] LOG:  received fast shutdown request
2020-11-12 10:10:43.748 UTC [10728] LOG:  aborting any active transactions
2020-11-12 10:10:43.754 UTC [10728] LOG:  worker process: logical replication launcher (PID 10736) exited with exit code 1
2020-11-12 10:10:43.757 UTC [10730] LOG:  shutting down