From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Intermittent buildfarm failures in sequence test |
Date: | 2011-01-06 15:03:00 |
Message-ID: | 6401.1294326180@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Have a look at
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=raven&dt=2011-01-05%2001%3A30%3A12
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=currawong&dt=2011-01-06%2002%3A30%3A01
I recall seeing a couple of similar failures in the past few weeks but
can't dredge them up at the moment.
The test case is pretty simple:
CREATE SEQUENCE foo_seq;
ALTER TABLE foo_seq RENAME TO foo_seq_new;
SELECT * FROM foo_seq_new;
SELECT nextval('foo_seq_new');
SELECT nextval('foo_seq_new');
SELECT * FROM foo_seq_new;
DROP SEQUENCE foo_seq_new;
In the failure reports, all the SELECTs give the expected values except
that "log_cnt" in the last one is 31 instead of expected 32.
Anybody have any idea what's causing that? I can't avoid the suspicion
that this is a consequence of some replication-related hack or other,
but I haven't been keeping close enough tabs to guess just what.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-01-06 15:13:56 | Re: Intermittent buildfarm failures in sequence test |
Previous Message | Robert Haas | 2011-01-06 14:31:17 | Re: sepgsql contrib module |