FW: cannot stat `/usr/local/pgsql/data/pg_xlog/00000001000000430000009C': No such file or directory
От | Sailer, Denis (YBUSA-CDR) |
---|---|
Тема | FW: cannot stat `/usr/local/pgsql/data/pg_xlog/00000001000000430000009C': No such file or directory |
Дата | |
Msg-id | 3FB3AAE149F4AD4D8499E15EE8CF41A38F4577@YBCDREX01.corp.ybusa.net обсуждение исходный текст |
Список | pgsql-general |
Here is the message.
2005-10-24 08:36:44 CDTLOG: database system was shut down at 2005-10-24 08:35:25 CDT
2005-10-24 08:36:44 CDTLOG: checkpoint record is at 43/B100001C
2005-10-24 08:36:44 CDTLOG: redo record is at 43/B100001C; undo record is at 43/B100001C; shutdown TRUE
2005-10-24 08:36:44 CDTLOG: next transaction ID: 6891749; next OID: 14756831
2005-10-24 08:36:44 CDTLOG: database system is ready
cp: cannot stat `/usr/local/pgsql/data/pg_xlog/00000001000000430000009C': No such file or directory
could not copy /usr/local/pgsql/data/pg_xlog/00000001000000430000009C to archive
2005-10-24 08:36:44 CDTLOG: archive command "yblogger /usr/local/pgsql/data/pg_xlog/00000001000000430000009C </dev/null" failed: return code 25088
Postgresql version is: PostgreSQL 8.0.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1 (SuSE Linux)
From: Sailer, Denis (YBUSA-CDR)
Sent: Monday, October 24, 2005 10:23 AM
To: 'pgsql-general@postgresql.org'
Subject: FW: cannot stat `/usr/local/pgsql/data/pg_xlog/00000001000000430000009C': No such file or directory
I forgot to include the specific error message related to the archival process not finding the file.
From: Sailer, Denis (YBUSA-CDR) [mailto:Denis.Sailer@yellowbook.com]
Sent: Monday, October 24, 2005 8:52 AM
To: pgsql-general@postgresql.org
Subject: cannot stat `/usr/local/pgsql/data/pg_xlog/00000001000000430000009C': No such file or directory
In my development system the file system where $PGDATA resides filled up.
cp: writing `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000076': No space left on device
could not copy /usr/local/pgsql/data/pg_xlog/000000010000004300000076 to archive
2005-10-23 08:46:29 CDTLOG: archive command "yblogger /usr/local/pgsql/data/pg_xlog/000000010000004300000076 </dev/null" failed: return code 25088
cp: overwrite `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000076'? 2005-10-23 08:46:30 CDTLOG: archived transaction log file "000000010
000004300000076"
2005-10-23 08:46:31 CDTLOG: could not close temporary statistics file "/usr/local/pgsql/data/global/pgstat.tmp.27235": No space left on device
cp: writing `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000077': No space left on device
could not copy /usr/local/pgsql/data/pg_xlog/000000010000004300000077 to archive
2005-10-23 08:47:46 CDTLOG: archive command "yblogger /usr/local/pgsql/data/pg_xlog/000000010000004300000077 </dev/null" failed: return code 25088
cp: overwrite `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000077'? 2005-10-23 08:47:47 CDTLOG: archived transaction log file "000000010
000004300000077"
2005-10-23 08:47:48 CDTLOG: could not close temporary statistics file "/usr/local/pgsql/data/global/pgstat.tmp.27235": No space left on device
cp: writing `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000078': No space left on device
could not copy /usr/local/pgsql/data/pg_xlog/000000010000004300000078 to archive
2005-10-23 08:49:49 CDTLOG: archive command "yblogger /usr/local/pgsql/data/pg_xlog/000000010000004300000078 </dev/null" failed: return code 25088
cp: overwrite `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000078'? 2005-10-23 08:49:51 CDTLOG: archived transaction log file "000000010
000004300000078"
2005-10-23 08:49:52 CDTLOG: could not close temporary statistics file "/usr/local/pgsql/data/global/pgstat.tmp.27235": No space left on device
cp: writ
At this point in time postgres had gone away. I tried to restart Postgres, but received these messages. Postgres would not start.
2005-10-24 08:28:04 CDTLOG: database system was interrupted at 2005-10-23 10:01:14 CDT
2005-10-24 08:28:04 CDTLOG: could not open file "/usr/local/pgsql/data/pg_xlog/000000010000004300000043" (log file 67, segment 67): No such file or dir
ectory
2005-10-24 08:28:04 CDTLOG: invalid checkpoint record
2005-10-24 08:28:04 CDTPANIC: could not locate required checkpoint record
2005-10-24 08:28:04 CDTHINT: If you are not restoring from a backup, try removing the file "/usr/local/pgsql/data/backup_label".
2005-10-24 08:28:04 CDTLOG: startup process (PID 13345) was terminated by signal 6
2005-10-24 08:28:04 CDTLOG: aborting startup due to startup process failure
2005-10-24 08:28:04 CDTLOG: logger shutting down
Since this is development I used “pg_resetxlog -f /usr/local/pgsql/data”. I then tried to start Postgres, but received the same messages as above. I removed the backup in progress file as stated in the message. Postgres was able to start after that, but now it keeps trying to archive log files that don’t exist.
How can I tell postgres to move to the point in time where log file truncation occurred where the log files now start?
В списке pgsql-general по дате отправления:
Предыдущее
От: "Sailer, Denis (YBUSA-CDR)"Дата:
Сообщение: FW: cannot stat `/usr/local/pgsql/data/pg_xlog/00000001000000430000009C': No such file or directory