Re: [BUGS] Server hangs on multiple connections

2002-09-20 Thread David Christian
On Thursday, Sep 19, 2002, at 18:33 US/Eastern, Tom Lane wrote: > David Christian <[EMAIL PROTECTED]> writes: >> Happy to. Interestingly, when I build with --enable-debug and >> --enable-cassert, the server doesn't lock up during 'make check', it >> just (very quickly) fails all of the tests an

Re: [BUGS] Server hangs on multiple connections

2002-09-20 Thread Tom Lane
David Christian <[EMAIL PROTECTED]> writes: > On Thursday, Sep 19, 2002, at 18:33 US/Eastern, Tom Lane wrote: >> There should be a core file left in the database subdirectory after >> the assert failure --- would you gdb it and get a stack trace from it? > Unfortunately, I see no core file under

Re: [BUGS] Server hangs on multiple connections

2002-09-20 Thread David Christian
On Friday, Sep 20, 2002, at 11:30 US/Eastern, Tom Lane wrote: > If you are using "make check" then look for > src/test/regress/tmp_check/data/base/*/core Thanks. Here it is: $ gdb src/test/regress/tmp_check/install/usr/local/pgsql/bin/postmaster src/test/regress/tmp_check/data/base/16556/core

Re: [BUGS] Server hangs on multiple connections

2002-09-20 Thread David Christian
On Friday, Sep 20, 2002, at 11:30 US/Eastern, Tom Lane wrote: > Another interesting line of attack would be to try compiling > src/backend/storage/lmgr/lwlock.c at different optimization levels, > to see if the problem goes away with less optimization. We saw a > problem on AIX (if memory serves

Re: [BUGS] Server hangs on multiple connections

2002-09-20 Thread Tom Lane
David Christian <[EMAIL PROTECTED]> writes: > On Friday, Sep 20, 2002, at 11:30 US/Eastern, Tom Lane wrote: >> Another interesting line of attack would be to try compiling >> src/backend/storage/lmgr/lwlock.c at different optimization levels, [ and indeed the problem goes away at -O0 ] > So, is

[BUGS] Bug #777: postgresql desconectado (not connect)

2002-09-20 Thread pgsql-bugs
José Alberto Torres ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description postgresql desconectado (not connect) Long Description I'm not English. I'm Spanish, please... Tenemos un servidor postgresql con la version 7.1 y cuando se p

[BUGS] Bug #778: pg_dump crashes when dumping a view

2002-09-20 Thread pgsql-bugs
Michael Bravo ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description pg_dump crashes when dumping a view Long Description pg_dump crashes when trying to dump a certain database structure. plaform: Linux, Debian 3.0 (stable) PostgreSQL

Re: [BUGS] Bug #778: pg_dump crashes when dumping a view

2002-09-20 Thread Tom Lane
[EMAIL PROTECTED] writes: > pg_dump crashes when trying to dump a certain database structure. Looks like this was broken by a late change in the 7.2 querytree structure. There is no comparable bug in 7.3devel (because that whole piece of code got rewritten), but if you need a patch here it is.

Re: [BUGS] Fix for PSQL 7.2.2 doesn't compile on OS X 10.2

2002-09-20 Thread Deron Brookins
I was able to successfully compile 7.2.2 on 10.2, but I had to change a line in the config.cache file. I only used the with-perl option. The config.cache file that was created had the following line pgac_cv_union_semun=${pgac_cv_union_semun=yes} When i compared the config.cache with the 7.2

Re: [BUGS] Server hangs on multiple connections

2002-09-20 Thread Tom Lane
Well, the long and the short of it seems to be that no one before you ever tried to run Postgres on a multi-CPU PowerPC machine :-( Some digging around on the net made it clear that we were missing synchronization instructions that are critical for access to shared memory in a multi-CPU system.