Provision a benchmarking node with snapshot disk from prod and n2d-highmem-96

added teamReliability ~2030650 workflow-infraTriage labels

changed the description

added Production EngineeringP2 boardautomate teamDatabase Reliability workproject workflow-infraReady labels and removed teamReliability workflow-infraTriage labels

changed milestone to %DB Squad - February 23

changed title from Provision a benchmarking node with snapshot disk from prod and n2-highmem-96 to Provision a benchmarking node with snapshot disk from prod and n2d-highmem-96

Created MRs to deploy new node patroni-main-machine-test-c

changed milestone to %DB Squad - March 23

Finally it seems that I made it work the immediate recovery

2023-03-06 06:02:47.501 GMT,,,87558,,64058206.15606,1,,2023-03-06 06:02:46 GMT,,0,LOG,00000,"ending log output to stderr",,"Future log output will go to log destination ""csvlog"".",,,,,,,""
2023-03-06 06:02:47.502 GMT,,,87558,,64058206.15606,2,,2023-03-06 06:02:46 GMT,,0,LOG,F0000,"hostssl record cannot match because SSL is disabled",,"Set ssl = on in postgresql.conf.",,,"line 9 of configuration file ""/var/opt/gitlab/postgresql/data12/pg_hba.conf""",,,,""
2023-03-06 06:02:47.502 GMT,,,87558,,64058206.15606,3,,2023-03-06 06:02:46 GMT,,0,LOG,F0000,"hostssl record cannot match because SSL is disabled",,"Set ssl = on in postgresql.conf.",,,"line 10 of configuration file ""/var/opt/gitlab/postgresql/data12/pg_hba.conf""",,,,""
2023-03-06 06:02:47.502 GMT,,,87558,,64058206.15606,4,,2023-03-06 06:02:46 GMT,,0,LOG,F0000,"hostssl record cannot match because SSL is disabled",,"Set ssl = on in postgresql.conf.",,,"line 11 of configuration file ""/var/opt/gitlab/postgresql/data12/pg_hba.conf""",,,,""
2023-03-06 06:02:47.502 GMT,,,87558,,64058206.15606,5,,2023-03-06 06:02:46 GMT,,0,LOG,F0000,"hostssl record cannot match because SSL is disabled",,"Set ssl = on in postgresql.conf.",,,"line 14 of configuration file ""/var/opt/gitlab/postgresql/data12/pg_hba.conf""",,,,""
2023-03-06 06:02:47.505 GMT,,,87560,,64058207.15608,1,,2023-03-06 06:02:47 GMT,,0,LOG,00000,"database system was interrupted while in recovery at log time 2023-03-05 23:50:54 GMT",,"If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.",,,,,,,""
2023-03-06 06:02:48.563 GMT,,,87560,,64058207.15608,2,,2023-03-06 06:02:47 GMT,,0,LOG,00000,"starting point-in-time recovery to earliest consistent point",,,,,,,,,""
2023-03-06 06:02:49.148 GMT,,,87560,,64058207.15608,3,,2023-03-06 06:02:47 GMT,1/0,0,LOG,00000,"redo starts at ACFC6/90064A08",,,,,,,,,""
2023-03-06 06:07:21.790 GMT,,,87560,,64058207.15608,4,,2023-03-06 06:02:47 GMT,1/0,0,LOG,00000,"consistent recovery state reached at ACFCA/4DFFFC78",,,,,,,,,""
2023-03-06 06:07:21.791 GMT,,,87558,,64058206.15606,6,,2023-03-06 06:02:46 GMT,,0,LOG,00000,"database system is ready to accept read only connections",,,,,,,,,""
2023-03-06 06:07:21.795 GMT,,,104666,,64058319.198da,1,,2023-03-06 06:07:21 GMT,2/0,0,LOG,00000,"pg_wait_sampling collector started",,,,,,,,,""
2023-03-06 06:07:21.956 GMT,,,87560,,64058207.15608,5,,2023-03-06 06:02:47 GMT,1/0,0,LOG,00000,"recovery stopping after reaching consistency",,,,,,,,,""
2023-03-06 06:07:21.956 GMT,,,87560,,64058207.15608,6,,2023-03-06 06:02:47 GMT,1/0,0,LOG,00000,"redo done at ACFCA/4DFFFC78",,,,,,,,,""
2023-03-06 06:07:21.956 GMT,,,87560,,64058207.15608,7,,2023-03-06 06:02:47 GMT,1/0,0,LOG,00000,"last completed transaction was at log time 2023-03-06 00:00:26.710926+00",,,,,,,,,""
2023-03-06 06:07:22.251 GMT,,,87560,,64058207.15608,8,,2023-03-06 06:02:47 GMT,1/0,0,LOG,00000,"restored log file ""0000000C.history"" from archive",,,,,,,,,""
2023-03-06 06:07:22.435 GMT,,,87560,,64058207.15608,9,,2023-03-06 06:02:47 GMT,1/0,0,LOG,00000,"selected new timeline ID: 13",,,,,,,,,""
2023-03-06 06:07:22.499 GMT,,,87560,,64058207.15608,10,,2023-03-06 06:02:47 GMT,1/0,0,LOG,00000,"archive recovery complete",,,,,,,,,""
2023-03-06 06:07:22.697 GMT,,,87595,,64058208.1562b,1,,2023-03-06 06:02:48 GMT,,0,LOG,00000,"checkpoint starting: end-of-recovery immediate wait",,,,,,,,,""
2023-03-06 06:08:57.877 GMT,,,87595,,64058208.1562b,2,,2023-03-06 06:02:48 GMT,,0,LOG,00000,"checkpoint complete: wrote 2964857 buffers (20.5%); 0 WAL file(s) added, 0 removed, 445 recycled; write=94.245 s, sync=0.262 s, total=95.181 s; sync files=6538, longest=0.006 s, average=0.001 s; distance=15695468 kB, estimate=15695468 kB",,,,,,,,,""
2023-03-06 06:08:58.336 GMT,,,87558,,64058206.15606,7,,2023-03-06 06:02:46 GMT,,0,LOG,00000,"database system is ready to accept connections",,,,,,,,,""

root@patroni-main-machine-test-c-01-db-db-benchmarking.c.gitlab-db-benchmarking.internal:~# gitlab-patronictl list
+-------------------------------------------------------------------------------------+---------------+--------+---------+----+-----------+
| Member                                                                              | Host          | Role   | State   | TL | Lag in MB |
+ Cluster: db-benchmarking-patroni-main-machine-test-c (6959847276950353765) ---------+---------------+--------+---------+----+-----------+
| patroni-main-machine-test-c-01-db-db-benchmarking.c.gitlab-db-benchmarking.internal | 10.255.86.101 | Leader | running | 14 |           |
+-------------------------------------------------------------------------------------+---------------+--------+---------+----+-----------+

@NikolayS and @fomin.list

I have finished provisioning the n2d-highmem-96 node for our benchmarking as discussed at &851 (comment 1286151358)

Is named patroni-main-machine-test-c-01-db-db-benchmarking.c.gitlab-db-benchmarking.internal

added workflow-infraDone label and removed workflow-infraReady label

closed

Provision a benchmarking node with snapshot disk from prod and n2d-highmem-96

Designs

Child items 0

Activity