{"action":"created","issue":{"url":"https://api.github.com/repos/wal-g/wal-g/issues/121","repository_url":"https://api.github.com/repos/wal-g/wal-g","labels_url":"https://api.github.com/repos/wal-g/wal-g/issues/121/labels{/name}","comments_url":"https://api.github.com/repos/wal-g/wal-g/issues/121/comments","events_url":"https://api.github.com/repos/wal-g/wal-g/issues/121/events","html_url":"https://github.com/wal-g/wal-g/issues/121","id":363628946,"node_id":"MDU6SXNzdWUzNjM2Mjg5NDY=","number":121,"title":"Can't restore due to missing archive, but archive never existed in first place","user":{"login":"WillPlatnick","id":1935688,"node_id":"MDQ6VXNlcjE5MzU2ODg=","avatar_url":"https://avatars2.githubusercontent.com/u/1935688?v=4","gravatar_id":"","url":"https://api.github.com/users/WillPlatnick","html_url":"https://github.com/WillPlatnick","followers_url":"https://api.github.com/users/WillPlatnick/followers","following_url":"https://api.github.com/users/WillPlatnick/following{/other_user}","gists_url":"https://api.github.com/users/WillPlatnick/gists{/gist_id}","starred_url":"https://api.github.com/users/WillPlatnick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WillPlatnick/subscriptions","organizations_url":"https://api.github.com/users/WillPlatnick/orgs","repos_url":"https://api.github.com/users/WillPlatnick/repos","events_url":"https://api.github.com/users/WillPlatnick/events{/privacy}","received_events_url":"https://api.github.com/users/WillPlatnick/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-09-25T15:11:09Z","updated_at":"2018-09-25T17:46:21Z","closed_at":null,"author_association":"NONE","body":"We are using WAL-G on 4 different database clusters. We're having issues restoring the database from this one cluster after an upgrade to PG10.  This archive that it's looking for doesn't exist in S3.\r\n\r\nThe WAL log it's looking for is ```000000010000D6E5000000C1``` and it's true, it doesn't exist.\r\n\r\nIn fact, that whole series doesn't exist. I have no files that start with ```000000010000D6``` but I do have a ton with ```000000010000D7```\r\n\r\nI'm wondering if something with the timeline is getting messed up during backups or during restore somehow, but I'm not sure where to look first.\r\n\r\n\r\n```2018-09-22 13:57:51.549 GMT [2278] LOG:  creating missing WAL directory \"pg_wal/archive_status\"\r\n2018-09-22 13:57:51.587 GMT [2278] LOG:  starting point-in-time recovery to 2018-09-22 07:00:00+00\r\nBUCKET: bucketname\r\nSERVER: \r\n2018/09/22 08:57:52 Archive '%s' does not exist 000000010000D6E5000000C1\r\ngithub.com/wal-g/wal-g.DownloadAndDecompressWALFile\r\n\t/home/travis/gopath/src/github.com/wal-g/wal-g/commands.go:590\r\ngithub.com/wal-g/wal-g.HandleWALFetch\r\n\t/home/travis/gopath/src/github.com/wal-g/wal-g/commands.go:515\r\nmain.main\r\n\t/home/travis/gopath/src/github.com/wal-g/wal-g/cmd/wal-g/main.go:131\r\nruntime.main\r\n\t/home/travis/.gimme/versions/go1.10.4.linux.amd64/src/runtime/proc.go:198\r\nruntime.goexit\r\n\t/home/travis/.gimme/versions/go1.10.4.linux.amd64/src/runtime/asm_amd64.s:2361\r\n2018-09-22 13:57:52.014 GMT [2278] LOG:  invalid checkpoint record\r\n2018-09-22 13:57:52.014 GMT [2278] FATAL:  could not locate required checkpoint record\r\n2018-09-22 13:57:52.014 GMT [2278] HINT:  If you are not restoring from a backup, try removing the file \"/var/lib/postgresql/10/main/backup_label\".```"},"comment":{"url":"https://api.github.com/repos/wal-g/wal-g/issues/comments/424437523","html_url":"https://github.com/wal-g/wal-g/issues/121#issuecomment-424437523","issue_url":"https://api.github.com/repos/wal-g/wal-g/issues/121","id":424437523,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNDQzNzUyMw==","user":{"login":"x4m","id":6000069,"node_id":"MDQ6VXNlcjYwMDAwNjk=","avatar_url":"https://avatars0.githubusercontent.com/u/6000069?v=4","gravatar_id":"","url":"https://api.github.com/users/x4m","html_url":"https://github.com/x4m","followers_url":"https://api.github.com/users/x4m/followers","following_url":"https://api.github.com/users/x4m/following{/other_user}","gists_url":"https://api.github.com/users/x4m/gists{/gist_id}","starred_url":"https://api.github.com/users/x4m/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/x4m/subscriptions","organizations_url":"https://api.github.com/users/x4m/orgs","repos_url":"https://api.github.com/users/x4m/repos","events_url":"https://api.github.com/users/x4m/events{/privacy}","received_events_url":"https://api.github.com/users/x4m/received_events","type":"User","site_admin":false},"created_at":"2018-09-25T17:46:21Z","updated_at":"2018-09-25T17:46:21Z","author_association":"COLLABORATOR","body":"Well, if backup is named ```D74500000059``` you need all WAL files since ```D74500000059``` for PITR and at least some of them for plain restoration.\r\nI know the only legitimate case when WALs can be not archived by WAL-G --  pg_upgrade. In this case backup that you are restoring is from version before 10. You can check file PG_VERSION in PGDATA to test this version.\r\n\r\nif it's not a case - we need to figure out how come that WALs are in in archive."}}
{"actor":{"display_login":"x4m"}}