On 31.05.2011 05:16, Tom Lane wrote:
Tomasz Chmielewskiman...@wpkg.org writes:
bookstor=# SELECT 1 FROM core_wot_seq FOR UPDATE;
Um ... why are you doing that on a sequence?
ERROR: could not access status of transaction 1573786613
DETAIL: Could not open file pg_clog/05DC: No such file or
On 07.05.2011 23:19, Tomasz Chmielewski wrote:
On 06.05.2011 10:42, Tomasz Chmielewski wrote:
bookstor=# SELECT 1 FROM core_wot_seq FOR UPDATE;
ERROR: could not access status of transaction 1573786613
DETAIL: Could not open file pg_clog/05DC: No such file or directory.
How do I best recover
Tomasz Chmielewski man...@wpkg.org writes:
bookstor=# SELECT 1 FROM core_wot_seq FOR UPDATE;
Um ... why are you doing that on a sequence?
ERROR: could not access status of transaction 1573786613
DETAIL: Could not open file pg_clog/05DC: No such file or directory.
This doesn't surprise me too
On 06.05.2011 10:42, Tomasz Chmielewski wrote:
On 04.05.2011 22:27, Tomasz Chmielewski wrote:
Then another pg_clog file disappeared.
OK, I have:
bookstor=# SELECT * FROM core_wot_seq;
sequence_name | last_value | increment_by | max_value | min_value |
cache_value | log_cnt | is_cycled |
On 04.05.2011 22:27, Tomasz Chmielewski wrote:
Then another pg_clog file disappeared.
OK, I have:
bookstor=# SELECT * FROM core_wot_seq;
sequence_name | last_value | increment_by | max_value |
min_value | cache_value | log_cnt | is_cycled | is_called
On 1st May, I saw this message in my postgres log:
May 2 06:52:02 db10 postgres[3590]: [29829-1] 2011-05-02 06:52:02 SGT
ERROR: could not access status of transaction 1573786613
May 2 06:52:02 db10 postgres[3590]: [29829-2] 2011-05-02 06:52:02 SGT
DETAIL: Could not open file pg_clog/05DC:
Tomasz Chmielewski man...@wpkg.org wrote:
On 1st May, I saw this message in my postgres log:
May 2 06:52:02 db10 postgres[3590]: [29829-1] 2011-05-02 06:52:02
SGT ERROR: could not access status of transaction 1573786613
May 2 06:52:02 db10 postgres[3590]: [29829-2] 2011-05-02 06:52:02
On 04.05.2011 20:14, Kevin Grittner wrote:
Tomasz Chmielewskiman...@wpkg.org wrote:
On 1st May, I saw this message in my postgres log:
May 2 06:52:02 db10 postgres[3590]: [29829-1] 2011-05-02 06:52:02
SGT ERROR: could not access status of transaction 1573786613
May 2 06:52:02 db10
Tomasz Chmielewski man...@wpkg.org wrote:
This repeated many times:
/var/log/postgresql/postgresql_log.1:May 3 18:24:49 db10
postgres[21363]: [26999-1] 2011-05-03 18:24:49 SGT ERROR: could
not access status of transaction 1573786613
/var/log/postgresql/postgresql_log.1-May 3 18:24:49
On Wed, May 4, 2011 at 12:37 PM, Tomasz Chmielewski man...@wpkg.org wrote:
/var/log/postgresql/postgresql_log.1:May 3 18:24:49 db10 postgres[21363]:
[26999-1] 2011-05-03 18:24:49 SGT ERROR: could not access status of
transaction 1573786613
/var/log/postgresql/postgresql_log.1-May 3
On 04.05.2011 21:50, Scott Marlowe wrote:
Then another pg_clog file disappeared.
Is it possible there's some rogue process deleting files in pg_clog
somehow?
I don't think.
Have you run an fsck on this drive to make sure it's not got
any file system errors?
Also, don't think there is
On 04.05.2011 22:13, Tomasz Chmielewski wrote:
On 04.05.2011 21:50, Scott Marlowe wrote:
Then another pg_clog file disappeared.
OK, I have:
bookstor=# SELECT * FROM core_wot_seq;
sequence_name | last_value | increment_by | max_value | min_value
| cache_value | log_cnt |
12 matches
Mail list logo