From: | "Mehdi MAACHE (Pyrenet)" <m(dot)maache(at)pyrenet(dot)fr> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org, "Pierre Villaret (Pyrenet)" <p(dot)villaret(at)pyrenet(dot)fr>, Olivier <ohp(at)pyrenet(dot)fr> |
Subject: | Re: Intermittent buildfarm failures in sequence test |
Date: | 2011-01-06 15:18:06 |
Message-ID: | 4D25DD2E.5050300@pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Le 06/01/2011 16:03, Tom Lane a écrit :
> 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
>
For information, I have the same with jaguar and centaur :
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=jaguar&dt=2011-01-03%2004%3A00%3A02
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=centaur&dt=2011-01-04%2007%3A06%3A01
regards, maache mehdi (Pyrenet)
From | Date | Subject | |
---|---|---|---|
Next Message | Sushant Sinha | 2011-01-06 15:44:24 | Re: english parser in text search: support for multiple words in the same position |
Previous Message | Tom Lane | 2011-01-06 15:13:56 | Re: Intermittent buildfarm failures in sequence test |