Postgres 8.1.4 sanity_check failed on SuSE 8.2
Hello,
while the regression tests, there is one that fails:
*** ./expected/sanity_check.out Thu Sep 8 20:07:42 2005
--- ./results/sanity_check.out Tue Sep 5 10:27:53 2006
***************
*** 17,22 ****
--- 17,24 ----
circle_tbl | t
fast_emp4000 | t
func_index_heap | t
+ gcircle_tbl | t
+ gpolygon_tbl | t
hash_f8_heap | t
hash_i4_heap | t
hash_name_heap | tI have found out, that someone else had this problem, but I have found no solution: http://archives.postgresql.org/pgsql-general/2006-05/msg01003.php
On the compiling machine, I have (a clean) SuSE 8.2 running, the filesystem is a xfs file system. The last version, Postgres 8.1.3, compiled nicely some time ago.
Any ideas how I can fix this?
Best regards,
Johannes Weberhofer
--
|---------------------------------
| weberhofer GmbH | Johannes Weberhofer
| information technologies, Austria
|
| phone : +43 (0)1 5454421 0 | email: office@weberhofer.at
| fax : +43 (0)1 5454421 19 | web : http://weberhofer.at
| mobile: +43 (0)699 11998315
|----------------------------------------------------------->>
"Johannes Weberhofer, Weberhofer GmbH" <office@weberhofer.at> writes:
while the regression tests, there is one that fails:
Repeatably, or did you only see this once? There's a known timing issue
that explains this, but it's only been seen once or twice that I know of.
2006-08-06 00:35 tgl
* src/test/regress/: expected/sanity_check.out,
sql/sanity_check.sql: Tweak sanity_check regression test to display
more tables (viz, those without indexes) but not to display temp
tables. It's a bit hard to credit that sanity_check could get
through a database-wide VACUUM while the preceding create_index
test is still trying to clean up its temp tables ... but I see no
other explanation for the current failure report from buildfarm
member sponge.
The report alluded to is
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=sponge&dt=2006-08-05%2021:30:02
regards, tom lane
Tom,
thank you! from cvs I copied the latest "strategy" to make the sanity checks and removed those values which were added after version 8.1.4. Using that patch, I can compile postgres without any problems. This version runs nicely on several servers.
Best regards,
Johannes
Johannes Weberhofer, Weberhofer GmbH schrieb:
I have tried it several times, but no success. I didn't have this issue
with older postgres versions on the same machine/system.Best regards,
Johannes WeberhoferTom Lane schrieb:
"Johannes Weberhofer, Weberhofer GmbH" <office@weberhofer.at> writes:
while the regression tests, there is one that fails:
Repeatably, or did you only see this once? There's a known timing issue
that explains this, but it's only been seen once or twice that I know of.2006-08-06 00:35 tgl
* src/test/regress/: expected/sanity_check.out,
sql/sanity_check.sql: Tweak sanity_check regression test to display
more tables (viz, those without indexes) but not to display temp
tables. It's a bit hard to credit that sanity_check could get
through a database-wide VACUUM while the preceding create_index
test is still trying to clean up its temp tables ... but I see no
other explanation for the current failure report from buildfarm
member sponge.The report alluded to is
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=sponge&dt=2006-08-05%2021:30:02regards, tom lane
--
|---------------------------------
| weberhofer GmbH | Johannes Weberhofer
| information technologies, Austria
|
| phone : +43 (0)1 5454421 0 | email: office@weberhofer.at
| fax : +43 (0)1 5454421 19 | web : http://weberhofer.at
| mobile: +43 (0)699 11998315
|----------------------------------------------------------->>
Attachments:
postgresql-8.1.4-sanitycheck.patchtext/plain; name=postgresql-8.1.4-sanitycheck.patchDownload+138-64
Import Notes
Reply to msg id not found: 44FED231.4080005@weberhofer.at