pghoard
pghoard copied to clipboard
Problem with postgres restart: FileNotFoundError
There is FileNotFoundError in the pghoard log. When I restart postgres: pg_ctlcluster 9.5 main restart, then the immediate event has no problem, but the next one (I think it is at the archive_timeout end) will fail with FileNotFoundError.
DEBUG event: /var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog_incoming/0000000100000000000000C7.partial IN_CLOSE_WRITE, None DEBUG event: /var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog_incoming/0000000100000000000000C7.partial IN_MOVED_FROM, None DEBUG event: /var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog_incoming/0000000100000000000000C7 IN_MOVED_TO, os.stat_result(st_mode=33152, st_ino=1048790, st_dev=2049, st_nlink=1, st_uid=121, st_gid=126, st_size=16777216, st_atime=1498809135, st_mtime=1498809168, st_ctime=1498809168) DEBUG compressed_file_path for '/var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog_incoming/0000000100000000000000C7' is '/var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog/0000000100000000000000C7' DEBUG b'pg_receivexlog: finished segment at 0/C8000000 (timeline 1)\n' DEBUG event: /var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog_incoming/0000000100000000000000C7.partial IN_CLOSE_WRITE, None DEBUG event: /var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog_incoming/0000000100000000000000C7 IN_DELETE, None INFO Compressed 16777216 byte open file '/var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog_incoming/0000000100000000000000C7' to 797294 bytes (5%), took: 0.078s ERROR Problem handling: {'type': 'MOVE', 'src_path': '/var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog_incoming/0000000100000000000000C7.partial', 'full_path': '/var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog_incoming/0000000100000000000000C7'}: FileNotFoundError: [Errno 2] No such file or directory: '/var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog_incoming/0000000100000000000000C7' Traceback (most recent call last): File "/usr/lib/python3/dist-packages/pghoard/compressor.py", line 75, in run self.handle_event(event, filetype) File "/usr/lib/python3/dist-packages/pghoard/compressor.py", line 155, in handle_event os.unlink(event["full_path"]) FileNotFoundError: [Errno 2] No such file or directory: '/var/lib/pghoard/metadata/pc_ef_zvolsky2/xlog_incoming/0000000100000000000000C7'
{ "log_level": "DEBUG", "backup_location": "/var/lib/pghoard/metadata", "backup_sites": { "pc_ef_zvolsky2": { "nodes": [ { "host": "127.0.0.1", "password": "xxxxxxxxxxxxxx", "port": 5432, "user": "pghoard" } ], "object_storage": { "storage_type": "local", "directory": "/var/lib/pghoard/backup" }, "basebackup_mode": "pipe", "pg_xlog_directory": "/var/lib/postgresql/9.5/main/pg_xlog", "pg_bin_directory": "/usr/bin" } } }