Aiven-Open / Aiven-Open/pghoard
Problem with postgres restart: FileNotFoundError
- Langage dominant
- Python
- Étoiles
- 1.4k
- Forks
- 111
- Merge moyen
- 1 j 5 h
- PR mergées (30 j)
- 2
Description
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"
}
}
}
Guide de contribution
Aucun guide de contribution indexé pour ce dépôt
Évaluation
Cette issue n'a pas encore été évaluée.