{"action":"created","issue":{"url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/633","repository_url":"https://api.github.com/repos/pgbackrest/pgbackrest","labels_url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/633/labels{/name}","comments_url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/633/comments","events_url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/633/events","html_url":"https://github.com/pgbackrest/pgbackrest/issues/633","id":387913357,"node_id":"MDU6SXNzdWUzODc5MTMzNTc=","number":633,"title":"PGBACKREST Missing Archiving Some WAL Files","user":{"login":"fpa-postgres","id":45638452,"node_id":"MDQ6VXNlcjQ1NjM4NDUy","avatar_url":"https://avatars2.githubusercontent.com/u/45638452?v=4","gravatar_id":"","url":"https://api.github.com/users/fpa-postgres","html_url":"https://github.com/fpa-postgres","followers_url":"https://api.github.com/users/fpa-postgres/followers","following_url":"https://api.github.com/users/fpa-postgres/following{/other_user}","gists_url":"https://api.github.com/users/fpa-postgres/gists{/gist_id}","starred_url":"https://api.github.com/users/fpa-postgres/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fpa-postgres/subscriptions","organizations_url":"https://api.github.com/users/fpa-postgres/orgs","repos_url":"https://api.github.com/users/fpa-postgres/repos","events_url":"https://api.github.com/users/fpa-postgres/events{/privacy}","received_events_url":"https://api.github.com/users/fpa-postgres/received_events","type":"User","site_admin":false},"labels":[{"id":65354970,"node_id":"MDU6TGFiZWw2NTM1NDk3MA==","url":"https://api.github.com/repos/pgbackrest/pgbackrest/labels/question","name":"question","color":"cc317c","default":true}],"state":"open","locked":false,"assignee":{"login":"dwsteele","id":5814217,"node_id":"MDQ6VXNlcjU4MTQyMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/5814217?v=4","gravatar_id":"","url":"https://api.github.com/users/dwsteele","html_url":"https://github.com/dwsteele","followers_url":"https://api.github.com/users/dwsteele/followers","following_url":"https://api.github.com/users/dwsteele/following{/other_user}","gists_url":"https://api.github.com/users/dwsteele/gists{/gist_id}","starred_url":"https://api.github.com/users/dwsteele/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwsteele/subscriptions","organizations_url":"https://api.github.com/users/dwsteele/orgs","repos_url":"https://api.github.com/users/dwsteele/repos","events_url":"https://api.github.com/users/dwsteele/events{/privacy}","received_events_url":"https://api.github.com/users/dwsteele/received_events","type":"User","site_admin":false},"assignees":[{"login":"dwsteele","id":5814217,"node_id":"MDQ6VXNlcjU4MTQyMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/5814217?v=4","gravatar_id":"","url":"https://api.github.com/users/dwsteele","html_url":"https://github.com/dwsteele","followers_url":"https://api.github.com/users/dwsteele/followers","following_url":"https://api.github.com/users/dwsteele/following{/other_user}","gists_url":"https://api.github.com/users/dwsteele/gists{/gist_id}","starred_url":"https://api.github.com/users/dwsteele/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwsteele/subscriptions","organizations_url":"https://api.github.com/users/dwsteele/orgs","repos_url":"https://api.github.com/users/dwsteele/repos","events_url":"https://api.github.com/users/dwsteele/events{/privacy}","received_events_url":"https://api.github.com/users/dwsteele/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/pgbackrest/pgbackrest/milestones/48","html_url":"https://github.com/pgbackrest/pgbackrest/milestone/48","labels_url":"https://api.github.com/repos/pgbackrest/pgbackrest/milestones/48/labels","id":3827424,"node_id":"MDk6TWlsZXN0b25lMzgyNzQyNA==","number":48,"title":"2.08","description":"","creator":{"login":"dwsteele","id":5814217,"node_id":"MDQ6VXNlcjU4MTQyMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/5814217?v=4","gravatar_id":"","url":"https://api.github.com/users/dwsteele","html_url":"https://github.com/dwsteele","followers_url":"https://api.github.com/users/dwsteele/followers","following_url":"https://api.github.com/users/dwsteele/following{/other_user}","gists_url":"https://api.github.com/users/dwsteele/gists{/gist_id}","starred_url":"https://api.github.com/users/dwsteele/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwsteele/subscriptions","organizations_url":"https://api.github.com/users/dwsteele/orgs","repos_url":"https://api.github.com/users/dwsteele/repos","events_url":"https://api.github.com/users/dwsteele/events{/privacy}","received_events_url":"https://api.github.com/users/dwsteele/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":15,"state":"open","created_at":"2018-11-16T18:17:23Z","updated_at":"2018-12-15T01:49:07Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2018-12-05T19:38:28Z","updated_at":"2018-12-15T06:17:21Z","closed_at":null,"author_association":"NONE","body":"1. pgBackRest version: 2.07\r\n\r\n2. PostgreSQL version: 10.4\r\n\r\n3. Operating system/version - if you have more than one server (for example, a database server, a repository host server, one or more standbys), please specify each: RHEL 7\r\n\r\n4. Did you install pgBackRest from source or from a package? package\r\n\r\n5. Please attach the following as applicable:\r\n    - `pgbackrest.conf` file(s) -\r\n\r\n------ pgbackrest.conf-------------\r\n[pg-node-1]\r\n#xpg1-host=\r\npg1-path=/apps/postgres/data\r\npg1-socket-path=/tmp\r\npg1-port=5432\r\npg1-host-user=postgres\r\npg1-host-cmd=/usr/bin/pgbackrest\r\narchive-async=y\r\narchive-push-queue-max=107374182400\r\nprocess-max=10\r\n#repo1-host-user=postgres\r\n\r\n\r\n[global]\r\nrepo1-host=findp-alln-prd-01\r\nrepo1-host-cmd=/usr/bin/pgbackrest\r\nrepo1-host-user=postgres\r\nrepo1-path=/apps/postgres/backup\r\n#repo-cipher-type=aes-256-cbc\r\n#repo1-cipher-\r\npass=\r\nprocess-max=10\r\nrepo1-retention-full=2\r\n---------------------\r\n----------------------------- postgrtesql.conf------\r\narchive_command = '/usr/bin/pgbackrest --stanza=pg-node-1 --config=/apps/postgres/pgbackrest.conf archive-push %p'\r\nwal_level = logical                     # minimal, replica, or logical\r\n#wal_compression = off                  # enable compression of full-page writes\r\n#wal_log_hints = off                    # also do full page writes of non-critical updates\r\nwal_buffers = 16MB                      # min 32kB, -1 sets based on shared_buffers\r\nmax_wal_size = 8GB\r\nmin_wal_size = 4GB\r\ncheckpoint_completion_target = 0.9      # checkpoint target duration, 0.0 - 1.0\r\ncheckpoint_timeout = 10min              # range 30s-1d\r\narchive_mode = on               # enables archiving; off, on, or always\r\n                                # (change requires restart)\r\nmax_wal_senders = 20            # max number of walsender processes\r\nmax_replication_slots = 20      # max number of replication slots\r\nseq_page_cost = 1.0                     # measured on an arbitrary scale\r\nrandom_page_cost = 2.0                  # same scale as above\r\nmin_parallel_table_scan_size = 1GB\r\nmin_parallel_index_scan_size = 100MB\r\neffective_cache_size = 1100GB\r\n----------\r\n\r\n7. Describe the issue:\r\n  PGBACKREST Missed Archiving Some WAL Files. Pls refer to attached file for detailed info. Any suggestion on this will help.\r\n\r\n\r\nThanks\r\n[PGBACKREST WAL FILE ISSUE.txt](https://github.com/pgbackrest/pgbackrest/files/2650316/PGBACKREST.WAL.FILE.ISSUE.txt)\r\n"},"comment":{"url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/comments/447541081","html_url":"https://github.com/pgbackrest/pgbackrest/issues/633#issuecomment-447541081","issue_url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/633","id":447541081,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NzU0MTA4MQ==","user":{"login":"fpa-postgres","id":45638452,"node_id":"MDQ6VXNlcjQ1NjM4NDUy","avatar_url":"https://avatars2.githubusercontent.com/u/45638452?v=4","gravatar_id":"","url":"https://api.github.com/users/fpa-postgres","html_url":"https://github.com/fpa-postgres","followers_url":"https://api.github.com/users/fpa-postgres/followers","following_url":"https://api.github.com/users/fpa-postgres/following{/other_user}","gists_url":"https://api.github.com/users/fpa-postgres/gists{/gist_id}","starred_url":"https://api.github.com/users/fpa-postgres/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fpa-postgres/subscriptions","organizations_url":"https://api.github.com/users/fpa-postgres/orgs","repos_url":"https://api.github.com/users/fpa-postgres/repos","events_url":"https://api.github.com/users/fpa-postgres/events{/privacy}","received_events_url":"https://api.github.com/users/fpa-postgres/received_events","type":"User","site_admin":false},"created_at":"2018-12-15T06:17:21Z","updated_at":"2018-12-15T06:17:21Z","author_association":"NONE","body":"\r\nBelow are conf files of pg-node-5 and findp-alln-prd-01.\r\n---pgbackrest.conf - pg-node-5---------\r\n[pg-node-5]\r\npg1-path=/apps/postgres/data\r\npg1-socket-path=/tmp\r\npg1-port=5432\r\npg1-host-user=postgres\r\npg1-host-cmd=/usr/bin/pgbackrest\r\narchive-async=y\r\narchive-push-queue-max=107374182400\r\nprocess-max=10\r\n\r\n[global]\r\nrepo1-host=findp-alln-prd-01\r\nrepo1-host-cmd=/usr/bin/pgbackrest\r\nrepo1-host-user=postgres\r\nrepo1-path=/apps/postgres/backup\r\npass=\r\nprocess-max=10\r\nrepo1-retention-full=2\r\n--------------------\r\n\r\n------ findp-alln-prd-01 -pgbackrest.conf-----------\r\n[global]\r\nrepo1-host-cmd=/usr/bin/pgbackrest\r\nrepo1-host-user=postgres\r\nrepo1-path=/apps/postgres/backup\r\npass=\r\nprocess-max=10\r\nrepo1-retention-full=2\r\n\r\n[pg-node-1]\r\npg1-host=finpg-rcdn-prd-01\r\npg1-path=/apps/postgres/data\r\npg1-socket-path=/tmp\r\npg1-port=5432\r\npg1-host-user=postgres\r\npg1-host-cmd=/usr/bin/pgbackrest\r\narchive-async=y\r\narchive-push-queue-max=107374182400\r\nprocess-max=10\r\n\r\n[pg-node-5]\r\npg1-host=finpg-rcdn-prd-05\r\npg1-path=/apps/postgres/data\r\npg1-socket-path=/tmp\r\npg1-port=5432\r\npg1-host-user=postgres\r\npg1-host-cmd=/usr/bin/pgbackrest\r\narchive-async=y\r\narchive-push-queue-max=107374182400\r\nprocess-max=10\r\n----------------------------------\r\n\r\nAlso, we  are noticing that every time disk is full on host, pgbackrest gets messed up. Could you please suggest some pointers. \r\n\r\nASSERT: [025]: multiple status files found in '/var/spool/pgbackrest/archive/pg-node-2/out' for WAL segment '00000001000009DA00000097'\r\n        STACK TRACE:\r\n        command/archive/common:archiveAsyncStatus:47:(debug log level required for parameters)\r\n        command/archive/push/push:cmdArchivePush:(debug log level required for parameters)\r\n        main:main:(debug log level required for parameters)\r\n\r\n\r\nThanks\r\n \r\n"}}
{"actor":{"display_login":"fpa-postgres"}}