Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Проблема при частичном ресторе только одной БД (использование --db-include) #249

Closed
Labels
@triwada

Description

@triwada

Имеется проблема при частичном ресторе только одной БД

postgres=# select pgpro_version();                                                pgpro_version-------------------------------------------------------------------------------------------------------------- PostgresPro 9.6.16.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit(1 row)postgres=# select pgpro_edition(); pgpro_edition--------------- enterprise(1 row)postgres=# select pgpro_build(); pgpro_build------------- cdeae793ef(1 row)$ pg_probackup -Vpg_probackup 2.3.5 (Postgres Pro 9.6.15.2 enterprise)$ pg_probackup show -B /backupBACKUP INSTANCE 'dummy'=================================================================================================================================================== Instance       Version  ID      Recovery Time           Mode  WAL Mode  TLI     Time   Data     WAL  Zratio  Start LSN      Stop LSN       Status=================================================================================================================================================== dummy          9.6      QF8AG1  2020-08-18 01:06:03+03  PAGE  ARCHIVE   2/2   6m:45s   26GB   496MB    3.62  A9C4/538B7618  A9C4/72007340  OK dumyy          9.6      QF70ZU  2020-08-17 10:16:16+03  FULL  ARCHIVE   2/0   1h:43m  997GB  6928MB    4.19  A9A4/1B337B70  A9A5/CCE05440  OKВыполняется рестор с помощью команды$ pg_probackup restore -B /backup --instance=dummy -D /pgdata/restore/report_data/data --db-include=postgres --recovery-target-time="2020-08-17 14:00" --recovery-target-action=pause --no-validate –-progress -j 20Завершается успешноINFO: Backup files are restored. Transfered bytes: 77GB, time elapsed: 5m:42sINFO: Approximate restore efficiency ratio: 5394% (4178GB/77GB)INFO: Syncing restored files to diskINFO: Restored backup files are synced, time elapsed: 1sLOG: ----------------------------------------LOG: creating recovery.confLOG: Setting restore_command to '/usr/bin/pg_probackup-ent-9.6 archive-get -B /backup --instance dummy --wal-file-path=%p --wal-file-name=%f'INFO: Restore of backup QF70ZU completed.Запускаю инстанс для продолжения восстановления с помощью WAL и в конечном счёте получаю ошибку2020-08-18 06:37:37.395 MSK [97108]: [457-1] db=,tx=0,user=,app=,client= LOG:  restored log file "000000020000A9A5000000DA" from archive2020-08-18 06:37:50.959 MSK [97108]: [458-1] db=,tx=0,user=,app=,client= WARNING:  page 233374 of relation base/3434610/3436498 is uninitialized2020-08-18 06:37:50.959 MSK [97108]: [459-1] db=,tx=0,user=,app=,client= CONTEXT:  xlog redo at A9A5/DAE4FB70 for Btree/DELETE: 8 items2020-08-18 06:37:50.959 MSK [97108]: [460-1] db=,tx=0,user=,app=,client= PANIC:  WAL contains references to invalid pages2020-08-18 06:37:50.959 MSK [97108]: [461-1] db=,tx=0,user=,app=,client= CONTEXT:  xlog redo at A9A5/DAE4FB70 for Btree/DELETE: 8 items2020-08-18 06:37:51.037 MSK [97106]: [5-1] db=,tx=0,user=,app=,client= LOG:  startup process (PID 97108) was terminated by signal 6: Aborted2020-08-18 06:37:51.037 MSK [97106]: [6-1] db=,tx=0,user=,app=,client= LOG:  terminating any other active server processes2020-08-18 06:37:51.038 MSK [97106]: [7-1] db=,tx=0,user=,app=,client= LOG:  worker process: cfs-worker-0 (PID 74582) exited with exit code 12020-08-18 06:37:51.342 MSK [97106]: [8-1] db=,tx=0,user=,app=,client= LOG:  database system is shut downНепонятно, почему здесь появляется relation (base/3434610/3436498 - принадлежит db1) из БД, которая не должна ресторитьсяpostgres=# select oid,datname from pg_database ;   oid    |     datname----------+------------------        1 | template1    13390 | template0 51640550 | db2  3434610 | db1    13391 | postgres(5 rows)

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


      [8]ページ先頭

      ©2009-2025 Movatter.jp