Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-14 Thread ohp
: Re: [HACKERS] cvs head initdb hangs on unixware o...@pyrenet.fr writes: On Wed, 10 Dec 2008, Heikki Linnakangas wrote: BTW, why does this work on warthog buildfarm member? Different compiler version? it's configured with --enable-debug. Maybe run_build.pl should run twice, onece

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread ohp
] cvs head initdb hangs on unixware [EMAIL PROTECTED] writes: FWIW, I have attached the 2 generated .s. Someone with knowledge of asm may want to have a look.. Hmm. It looks to me like the compiler is getting confused by the interaction between nodeno, leftnodeno, and rightnodeno. Try this patch

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Heikki Linnakangas
[EMAIL PROTECTED] wrote: On Tue, 9 Dec 2008, Tom Lane wrote: Hmm. It looks to me like the compiler is getting confused by the interaction between nodeno, leftnodeno, and rightnodeno. Try this patch to see if it gets around it. (This is a tad better anyway since it avoids examining the right

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Peter Eisentraut
Heikki Linnakangas wrote: I find it pretty scary to work around compiler bugs like this. Who knows what other code it miscompiles. Can you reduce fsm_search_avail into a small stand-alone test program, and file a bug report with the compiler vendor? BTW, why does this work on warthog

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Bruce Momjian
Peter Eisentraut wrote: Heikki Linnakangas wrote: I find it pretty scary to work around compiler bugs like this. Who knows what other code it miscompiles. Can you reduce fsm_search_avail into a small stand-alone test program, and file a bug report with the compiler vendor? BTW,

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Bruce Momjian
Heikki Linnakangas wrote: [EMAIL PROTECTED] wrote: On Tue, 9 Dec 2008, Tom Lane wrote: Hmm. It looks to me like the compiler is getting confused by the interaction between nodeno, leftnodeno, and rightnodeno. Try this patch to see if it gets around it. (This is a tad better anyway

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread ohp
head initdb hangs on unixware [EMAIL PROTECTED] wrote: On Tue, 9 Dec 2008, Tom Lane wrote: Hmm. It looks to me like the compiler is getting confused by the interaction between nodeno, leftnodeno, and rightnodeno. Try this patch to see if it gets around it. (This is a tad better anyway since

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Heikki Linnakangas
[EMAIL PROTECTED] wrote: On Wed, 10 Dec 2008, Heikki Linnakangas wrote: I find it pretty scary to work around compiler bugs like this. Who knows what other code it miscompiles. Can you reduce fsm_search_avail into a small stand-alone test program, and file a bug report with the compiler

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Tom Lane
[EMAIL PROTECTED] writes: On Wed, 10 Dec 2008, Heikki Linnakangas wrote: BTW, why does this work on warthog buildfarm member? Different compiler version? it's configured with --enable-debug. Maybe run_build.pl should run twice, onece with --enable-debug once without. No, the standard

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Zdenek Kotala
Tom Lane napsal(a): [EMAIL PROTECTED] writes: On Wed, 10 Dec 2008, Heikki Linnakangas wrote: BTW, why does this work on warthog buildfarm member? Different compiler version? it's configured with --enable-debug. Maybe run_build.pl should run twice, onece with --enable-debug once without.

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Tom Lane
Heikki Linnakangas [EMAIL PROTECTED] writes: [EMAIL PROTECTED] wrote: Never saw a problem with gcc, hp-ux, darwin or M$? Sure, that's not what I was saying. My point is, when there's a bug in one version of a compiler, we shouldn't try to adapt PostgreSQL to that bug. Instead, we should

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Tom Lane
Zdenek Kotala [EMAIL PROTECTED] writes: Tom Lane napsal(a): No, the standard way to deal with such issues is to set up two buildfarm members. I think current infrastructures is not good for it. For example I would like to compile postgres on one machine with three different compiler and

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Martijn van Oosterhout
On Wed, Dec 10, 2008 at 06:27:05PM +0100, Zdenek Kotala wrote: I think current infrastructures is not good for it. For example I would like to compile postgres on one machine with three different compiler and in 32 or 64 mode. Should I have 6 animals? I think better idea is to have one

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Peter Eisentraut
On Wednesday 10 December 2008 19:36:38 Tom Lane wrote: Zdenek Kotala [EMAIL PROTECTED] writes: Tom Lane napsal(a): No, the standard way to deal with such issues is to set up two buildfarm members. I think current infrastructures is not good for it. For example I would like to compile

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Andrew Dunstan
Zdenek Kotala wrote: Tom Lane napsal(a): [EMAIL PROTECTED] writes: On Wed, 10 Dec 2008, Heikki Linnakangas wrote: BTW, why does this work on warthog buildfarm member? Different compiler version? it's configured with --enable-debug. Maybe run_build.pl should run twice, onece with

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Aidan Van Dyk
* Zdenek Kotala [EMAIL PROTECTED] [081210 12:29]: No, the standard way to deal with such issues is to set up two buildfarm members. This would be a 100% waste of cycles for gcc-based members anyway, since gcc generates the same code with or without -g. However, for compilers where it makes

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-09 Thread ohp
head initdb hangs on unixware [EMAIL PROTECTED] writes: the infinite loop occurs in fsm_search_avail when called for the 32nd time. ... which is the first time that the initial test doesn't make it fall out immediately. Would you add a couple more printouts, along the line of nodeno

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-09 Thread Zdenek Kotala
[EMAIL PROTECTED] napsal(a): I first misread your mail, and added only the first fprintf , while I was uploading a 400M initdb.log, I went back to add the second one. Guess what! with the fprintf .. descending node... in place, everything goes well. The optimizer definitly does something

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-09 Thread Tom Lane
[EMAIL PROTECTED] writes: Guess what! with the fprintf .. descending node... in place, everything goes well. The optimizer definitly does something weird along the definition/assignement of leftok/rightok.. Hmm, so the problem is in that second loop. The trick is to pick some reasonably

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-09 Thread ohp
On Tue, 9 Dec 2008, Tom Lane wrote: Date: Tue, 09 Dec 2008 09:23:06 -0500 From: Tom Lane [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Heikki Linnakangas [EMAIL PROTECTED], Zdenek Kotala [EMAIL PROTECTED], pgsql-hackers list pgsql-hackers@postgresql.org Subject: Re: [HACKERS] cvs head

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-09 Thread Kenneth Marshall
[EMAIL PROTECTED], Zdenek Kotala [EMAIL PROTECTED], pgsql-hackers list pgsql-hackers@postgresql.org Subject: Re: [HACKERS] cvs head initdb hangs on unixware [EMAIL PROTECTED] writes: Guess what! with the fprintf .. descending node... in place, everything goes well. The optimizer definitly

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-09 Thread Tom Lane
[EMAIL PROTECTED] writes: On Tue, 9 Dec 2008, Tom Lane wrote: Hmm, so the problem is in that second loop. The trick is to pick some reasonably non-ugly code change that makes the problem go away. I tried that and moving leftok,rightok declaration outside the loop, and refactor the

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-09 Thread Tom Lane
[EMAIL PROTECTED] writes: FWIW, I have attached the 2 generated .s. Someone with knowledge of asm may want to have a look.. Hmm. It looks to me like the compiler is getting confused by the interaction between nodeno, leftnodeno, and rightnodeno. Try this patch to see if it gets around it.

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-08 Thread ohp
: [HACKERS] cvs head initdb hangs on unixware Tom Lane wrote: [EMAIL PROTECTED] writes: As you can see in attached initdb.log, it seems fsm_search_avail is called repeatedly and args are sort of looping... That's expected, since the system is inserting a lot of tuples successively. Right. I suspect

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-08 Thread Tom Lane
[EMAIL PROTECTED] writes: the infinite loop occurs in fsm_search_avail when called for the 32nd time. ... which is the first time that the initial test doesn't make it fall out immediately. Would you add a couple more printouts, along the line of nodeno = target; while

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-07 Thread Tom Lane
[EMAIL PROTECTED] writes: As you can see in attached initdb.log, it seems fsm_search_avail is called repeatedly and args are sort of looping... That's expected, since the system is inserting a lot of tuples successively. What it looks like to me is that the failing call is the first one where

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-07 Thread Heikki Linnakangas
Tom Lane wrote: [EMAIL PROTECTED] writes: As you can see in attached initdb.log, it seems fsm_search_avail is called repeatedly and args are sort of looping... That's expected, since the system is inserting a lot of tuples successively. Right. I suspect it was in the infinite loop yet. Try

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-04 Thread ohp
On Wed, 3 Dec 2008, Heikki Linnakangas wrote: Date: Wed, 03 Dec 2008 20:29:01 +0200 From: Heikki Linnakangas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Zdenek Kotala [EMAIL PROTECTED], pgsql-hackers list pgsql-hackers@postgresql.org Subject: Re: [HACKERS] cvs head initdb hangs on unixware

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-04 Thread Heikki Linnakangas
[EMAIL PROTECTED] wrote: On Wed, 3 Dec 2008, Heikki Linnakangas wrote: Could you zip up the FSM file of that relation (a file called e.g 789_fsm), and send it over? Or the whole data directory, it shouldn't be that big. you get both. Thanks. Hmm, the FSM pages are full of zeros, as I

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-04 Thread ohp
On Thu, 4 Dec 2008, Heikki Linnakangas wrote: Date: Thu, 04 Dec 2008 13:19:15 +0200 From: Heikki Linnakangas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Zdenek Kotala [EMAIL PROTECTED], pgsql-hackers list pgsql-hackers@postgresql.org Subject: Re: [HACKERS] cvs head initdb hangs on unixware

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-03 Thread ohp
On Tue, 2 Dec 2008, Heikki Linnakangas wrote: Date: Tue, 02 Dec 2008 20:47:19 +0200 From: Heikki Linnakangas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Zdenek Kotala [EMAIL PROTECTED], pgsql-hackers list pgsql-hackers@postgresql.org Subject: Re: [HACKERS] cvs head initdb hangs on unixware

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-03 Thread Andrew Dunstan
[EMAIL PROTECTED] wrote: Looking at fsm_rebuild_page, I wonder if the compiler is treating int as an unsigned integer? That would cause an infinite loop. No, a simple printf of nodeno shows it starting at 4096 all the way down to 0, starting back at 4096... I wonder if

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-03 Thread Heikki Linnakangas
[EMAIL PROTECTED] wrote: On Tue, 2 Dec 2008, Heikki Linnakangas wrote: Date: Tue, 02 Dec 2008 20:47:19 +0200 From: Heikki Linnakangas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Zdenek Kotala [EMAIL PROTECTED], pgsql-hackers list pgsql-hackers@postgresql.org Subject: Re: [HACKERS] cvs head

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-02 Thread Zdenek Kotala
Could you generate a core and send a stacktrace? kill SIGABRT pid should do that. Zdenek [EMAIL PROTECTED] napsal(a): Hi all, cvs head configured without --enable-debug hang in initdb while making check. warthog doesn't exhibit it because it's configured with debug. when it

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-02 Thread ohp
On Tue, 2 Dec 2008, Zdenek Kotala wrote: Date: Tue, 02 Dec 2008 17:22:25 +0100 From: Zdenek Kotala [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: pgsql-hackers list pgsql-hackers@postgresql.org Subject: Re: [HACKERS] cvs head initdb hangs on unixware Could you generate a core and send

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-02 Thread ohp
On Tue, 2 Dec 2008, Zdenek Kotala wrote: Date: Tue, 02 Dec 2008 17:22:25 +0100 From: Zdenek Kotala [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: pgsql-hackers list pgsql-hackers@postgresql.org Subject: Re: [HACKERS] cvs head initdb hangs on unixware Could you generate a core and send

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-02 Thread Heikki Linnakangas
[EMAIL PROTECTED] wrote: Suivi de pile correspondant à p1, Programme postmaster *[0] fsm_rebuild_page( présumé: 0xbd9731a0, 0, 0xbd9731a0) [0x81e6a97] [1] fsm_search_avail( présumé: 0x2, 0x6, 0x1) [0x81e68d9] [2] fsm_set_and_search(0x84b2250, 0, 0, 0x2e, 0x5, 0x6, 0x2e, 0x8047416, 0xb4)