[HACKERS] build farm machine using mixed results

2012-09-03 Thread Robert Creager
I change the build-farm.conf file to have the following make line: make => 'make -j 8', # or gmake if required. can include path if necessary. 2 pass, 4 fail. Is this a build configuration you want to pursue? I can either create a new machine, or change one of my existing machines. Makes

Re: [HACKERS] Build failures with Mountain Lion

2012-07-28 Thread Robert Creager
On Jul 27, 2012, at 3:26 PM, Tom Lane wrote: > Hm. We have seen similar symptoms reported by people using broken > openssl installations. I've never tracked down the details but I > suspect header-vs-library mismatches. Is it possible there are some > pre-ML openssl-related files hanging abo

Re: [HACKERS] pg_crypto failures with llvm on OSX

2012-03-10 Thread Robert Creager
On Mar 10, 2012, at 7:54 PM, Andrew Dunstan wrote: > > > On 03/10/2012 09:15 PM, Tom Lane wrote: >> >> (I wonder whether it'd be a good idea for the buildfarm script to >> explicitly clear anything that autoconf pays attention to from its >> startup environment, so that you have to set these

Re: [HACKERS] pg_crypto failures with llvm on OSX

2012-03-10 Thread Robert Creager
On Mar 10, 2012, at 7:15 PM, Tom Lane wrote: > Robert Creager writes: >> On Mar 10, 2012, at 5:01 PM, Tom Lane wrote: >>> What's really odd though is that there is nothing in the configuration >>> script that injects any of those switches. I think y

Re: [HACKERS] pg_crypto failures with llvm on OSX

2012-03-10 Thread Robert Creager
On Mar 10, 2012, at 5:01 PM, Tom Lane wrote: > What's really odd though is that there is nothing in the configuration > script that injects any of those switches. I think you've got some > screwy global configuration on that machine, which you'd be well advised > to try to get rid of --- it's t

Re: [HACKERS] pg_crypto failures with llvm on OSX

2012-03-10 Thread Robert Creager
On Mar 10, 2012, at 4:19 PM, Andrew Dunstan wrote: > > On 03/09/2012 07:50 PM, Tom Lane wrote: >> Andrew Dunstan writes: >>> Buildfarm member mussel (OS X 10.7.3, llvm-gcc 4.2.1, x86_64)seems to be >>> getting consistent warnings when running the pgcrypto regression tests, >>> that look like th

Re: [HACKERS] [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD

2011-06-24 Thread Robert Creager
$msg = shift;\n elog(NOTICE,$msg);\n\n$$;") at postgres.c:1018 #16 0x000100237081 in PostgresMain (argc=2, argv=, username=) at postgres.c:3924 #17 0x0001001e9bbc in ServerLoop () at postmaster.c:3605 #18 0x0001001eab37 in PostmasterMain (argc=3, argv=0x100800680) at postmaster.c

Re: [HACKERS] Why polecat and colugos are failing to build back branches

2011-06-16 Thread Robert Creager
On Jun 15, 2011, at 7:51 PM, Tom Lane wrote: > ... > installation paths. About the only good thing to be said about it is > that these characters are so troublesome that Unix users are unlikely > to use them in directory names anyway. So I'm guessing you don't want this path name? I was going

Re: [HACKERS] Polecat "quit unexpectdly"

2011-06-15 Thread Robert Creager
On Jun 14, 2011, at 2:11 PM, Kevin Grittner wrote: > Robert Creager wrote: > >> Stack trace, nothing else. > >> 3 postgres 0x00010005cafa >> multixact_twophase_postcommit + 74 (multixact.c:1367) >> 4 postgres

Re: [HACKERS] Why polecat and colugos are failing to build back branches

2011-06-14 Thread Robert Creager
On Jun 14, 2011, at 3:45 PM, Tom Lane wrote: > I've committed patches that fix these issues on my own OS X machine, > though it remains to be seen whether polecat and colugos will like > them. It turns out that whatever setup Robert has got with > '/Volumes/High Usage/' is really *not* fully ex

[HACKERS] Polecat "quit unexpectdly"

2011-06-14 Thread Robert Creager
d, 0x05ac  (Apple Inc.), 0x0236, 0x0460USB Device: IR Receiver, 0x05ac  (Apple Inc.), 0x8242, 0x0450 -- Robert Creager, Principal Software EngineerOracle Server Technologies500 Eldorado Blvd, Bldg 5Broomfield, CO, 80021Phone: 303-272-6830 Email: robert.crea...@oracle.comOracle is committed to developing practices and products that help protect the environment

Re: [HACKERS] Why polecat and colugos are failing to build back branches

2011-06-14 Thread Robert Creager
On Jun 13, 2011, at 6:05 PM, Tom Lane wrote: > I looked into $SUBJECT. There appear to be two distinct issues: > > 1. On colugos (OS X with LLVM), the ... > However, because when using gcc that only results in a warning, > we didn't back-patch it. Now it appears that it's an error when using

Re: [HACKERS] [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD

2011-06-09 Thread Robert Creager
On Jun 7, 2011, at 11:32 PM, Tom Lane wrote: > > But I tried "make installcheck" in plperl quite a few times with no > problems. (And yes, I tried some assorted settings of PERL_HASH_SEED, > as well as none at all.) > > At this point I'm thinking that the perl you've got in /opt/local must > b

Re: [HACKERS] [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD

2011-06-09 Thread Robert Creager
On Jun 8, 2011, at 9:13 AM, Robert Creager wrote:I've renamed /opt/local so it's not picked up, and change HEAD to build every 6 hours.  Won't prove it doesn't happen though...  If it appears to work for a bit, I can move /opt/local back and see what happens.Gack.  ccache

Re: [HACKERS] [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD

2011-06-08 Thread Robert Creager
On Jun 7, 2011, at 3:01 PM, Tom Lane wrote: > Robert Creager writes: > > The configure log mentioned upthread says it's finding /usr/bin/perl, > so apparently the buildfarm is running with a different PATH than you're > using here. But that log also shows > &g

Re: [HACKERS] [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD

2011-06-08 Thread Robert Creager
On Jun 7, 2011, at 12:42 PM, Alex Hunsaker wrote: > On Tue, Jun 7, 2011 at 12:22, Tom Lane wrote: >> Alex Hunsaker writes: >>> Im looking at the "raw" perl 5.10.0 source... I wonder if apple is >>> shipping a modified version? >> >> You could find out by digging around at >> http://www.openso

[HACKERS] CREATE FUNCTION hang on test machine polecat on HEAD

2011-06-07 Thread Robert Creager
nnection authorized: user=Robert database=pl_regression[4de65a8f.607a:3] LOG:  statement: CREATE OR REPLACE FUNCTION bar() RETURNS integer AS $$    #die 'BANG!'; # causes server process to exit(2)    # alternative - causes server process to exit(255)    spi_exec_query("invalid sql s

Re: [HACKERS] [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD

2011-06-07 Thread Robert Creager
On Jun 6, 2011, at 7:29 PM, Andrew Dunstan wrote: > > > On 06/06/2011 07:30 PM, Robert Creager wrote: >> [4de65a8f.607a:1] LOG: connection received: host=[local] >> [4de65a8f.607a:2] LOG: connection authorized: user=Robert >> database=pl_regression >>

Re: [HACKERS] Fwd: PGBuildfarm member colugos Branch HEAD Status changed from OK to StartDb-C:3 failure

2010-05-20 Thread Robert Creager
On May 20, 2010, at 11:54 AM, Tom Lane wrote: > Robert Creager writes: >> If anyone is interested, I think this failure was accompanied by the >> following: >> [ apparent PANIC in UpdateControlFile ] > > Hmm, do you have the panic message in the postmaster log?

[HACKERS] Fwd: PGBuildfarm member colugos Branch HEAD Status changed from OK to StartDb-C:3 failure

2010-05-20 Thread Robert Creager
If anyone is interested, I think this failure was accompanied by the following: Process: postgres [35159] Path: /usr/local/src/build-farm-3.2_llvm/builds/HEAD/inst/bin/postgres Identifier: postgres Version: ??? (???) Code Type: X86-64 (Native) Parent Process:

[HACKERS] Fwd: PGBuildfarm member polecat Branch HEAD Status changed from StartDb-C:2 failure to StartDb-C:3 failure

2010-05-20 Thread Robert Creager
And another one (different compiler): Process: postgres [48669] Path:/usr/local/src/build-farm-3.2/builds/HEAD/inst/bin/postgres Identifier: postgres Version: ??? (???) Code Type: X86-64 (Native) Parent Process: postgres [48015] Date/Time: 2010-05-19

Re: [HACKERS] buildfarm logging versus embedded nulls

2010-03-12 Thread Robert Creager
On Mar 11, 2010, at 6:00 PM, Andrew Dunstan wrote: > > > Tom Lane wrote: >> I was looking at this recent nonrepeatable buildfarm failure: >> http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=polecat&dt=2010-03-11%2021:45:10 >> which has several instances of the known "pgstat wait timeout"

Re: [HACKERS] happy birthday Tom Lane ...

2009-09-18 Thread Robert Creager
On Sep 18, 2009, at 5:18 PM, Paul Matthews wrote: happy_birthday++; SELECT count( happy ) FROM birthday WHERE name ~ 'Tom Lane'; WARNING : condition stack overflow: INF Sigh, Rob smime.p7s Description: S/MIME cryptographic signature

Re: [HACKERS] drop tablespace error: invalid argument

2009-09-11 Thread Robert Creager
On Sep 11, 2009, at 2:35 PM, David E. Wheeler wrote: On Sep 11, 2009, at 12:42 PM, Tom Lane wrote: Well, 10.6.1 is out and it's still got the readdir() bug :-(. Has someone filed a bug report about this with Apple? https://bugreport.apple.com/cgi-bin/WebObjects/RadarWeb.woa Look at th

Re: [HACKERS] drop tablespace error: invalid argument

2009-09-11 Thread Robert Creager
On Sep 11, 2009, at 2:35 PM, David E. Wheeler wrote: On Sep 11, 2009, at 12:42 PM, Tom Lane wrote: Well, 10.6.1 is out and it's still got the readdir() bug :-(. Has someone filed a bug report about this with Apple? https://bugreport.apple.com/cgi-bin/WebObjects/RadarWeb.woa If no one

Re: [HACKERS] Any interest in buildfarm a member using Apple's llvm-gcc-4.2 or clang?

2009-09-08 Thread Robert Creager
On Sep 8, 2009, at 4:18 PM, Tom Lane wrote: Robert Creager writes: I'll set up one or two more 'machines' if there is interest (Snow Leopard) LLVM, perhaps, though are you sure that llvm and gcc aren't the same thing under the hood on SL? I thought I'd read

[HACKERS] Any interest in buildfarm a member using Apple's llvm-gcc-4.2 or clang?

2009-09-08 Thread Robert Creager
I'll set up one or two more 'machines' if there is interest (Snow Leopard) % /Developer/usr/bin/llvm-gcc-4.2 --version i686-apple-darwin10-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build 5646) (LLVM build 2118) llvm-gcc-4.2 currently fails during check for the known directory probl

Re: [HACKERS] [Pgbuildfarm-members] Snow Leopard bison/flex build problem

2009-09-07 Thread Robert Creager
On Sep 7, 2009, at 4:08 PM, Tom Lane wrote: Any feelings about that? Should I just hit everything back to 7.4 to be safe? I've noticed on 7.4, Mac gets a spinlock compile error (see polecat logs on buildfarm). Should I give up on the mac for 7.4? Cheers, Rob Sent from my iPhone -- S

Re: [HACKERS] [Pgbuildfarm-members] Snow Leopard bison/flex build problem

2009-09-07 Thread Robert Creager
On Sep 7, 2009, at 2:41 PM, Dave Page wrote: On 9/7/09, Robert Creager wrote: On Sep 7, 2009, at 2:17 PM, Dave Page wrote: FYI, I've been building from source on Snow Leopard without any problems. If your building from the official tarball, bison/flex are not used. I'm bui

Re: [HACKERS] [Pgbuildfarm-members] Snow Leopard bison/flex build problem

2009-09-07 Thread Robert Creager
On Sep 7, 2009, at 2:17 PM, Dave Page wrote: FYI, I've been building from source on Snow Leopard without any problems. If your building from the official tarball, bison/flex are not used. I'm building from CVS, where bison/flex are used. Cheers, rob -- Sent via pgsql-hackers mailing

Re: [HACKERS] [Pgbuildfarm-members] Snow Leopard bison/flex build problem

2009-09-07 Thread Robert Creager
On Sep 7, 2009, at 1:18 PM, Tom Lane wrote: Robert Creager writes: On Sep 7, 2009, at 11:29 AM, Andrew Dunstan wrote: Please try building by hand and examine the files to find out what the conflict is between these declarations. pgc.c - 161: extern yy_size_t yyleng; Bizarre --- my

Re: [HACKERS] [Pgbuildfarm-members] Snow Leopard bison/flex build problem

2009-09-07 Thread Robert Creager
On Sep 7, 2009, at 1:18 PM, Tom Lane wrote: Robert Creager writes: On Sep 7, 2009, at 11:29 AM, Andrew Dunstan wrote: Please try building by hand and examine the files to find out what the conflict is between these declarations. pgc.c - 161: extern yy_size_t yyleng; Bizarre --- my

Re: [HACKERS] [Pgbuildfarm-members] Snow Leopard bison/flex build problem

2009-09-07 Thread Robert Creager
On Sep 7, 2009, at 11:29 AM, Andrew Dunstan wrote: Robert Creager wrote: Upgraded to Snow Leopard Saturday, and am having problems building now. The build logs are here http://buildfarm.postgresql.org/cgi-bin/show_status.pl?member=polecat And the failing part is here: make -C preproc

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-10 Thread Robert Creager
I've also modified the Makefile. I removed the special .sql.in : .sql implicit rule and re-organized the Makefile. I didn't commit as it was after 12:00pm when I finished... I'll send you what I did when I return home. If you just replaced the $libdir with $$libdir, then a merge will be easy.

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-09 Thread Robert Creager
On Wed, 09 Nov 2005 10:42:00 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > > If pg_sphere is supplying a setup procedure that gets this wrong, > yell at them. I'll just go fix it, now that I know what the right way is ;-) Thanks, Rob ---(end of broadcast)-

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-09 Thread Robert Creager
On Wed, 09 Nov 2005 09:56:51 -0500 Andrew Dunstan <[EMAIL PROTECTED]> wrote: > > Why use an absolute path? Why not just give the name of the .so and let > postgres find it in $libdir (i.e. sed -e 's,/usr/local/pgsql.*/lib/,,' > on your dump) ? 'cause I didn't know I could? I'll go and fix the

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-09 Thread Robert Creager
When grilled further on (Wed, 09 Nov 2005 10:54:12 +0300), Teodor Sigaev <[EMAIL PROTECTED]> confessed: > > So, I'm as sure as I can be right now. How can I check the .so files > > installed > > by the build? Do they reference an absolute path for their dependent .so > > files > > (postgres),

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-08 Thread Robert Creager
When grilled further on (Tue, 08 Nov 2005 11:12:04 -0500), Tom Lane <[EMAIL PROTECTED]> confessed: > Teodor Sigaev <[EMAIL PROTECTED]> writes: > > Layout of GIST_SPLITVEC struct has been changed from 8.0, I'm afraid that > > old > > .so is used. spl_(right|left)valid fields was added to GIST_SPL

Re: [HACKERS] Assert failure found in 8.1RC1

2005-11-08 Thread Robert Creager
On Tue, 08 Nov 2005 15:36:18 -0600 "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > > Just to clarify, did it show the assert failure, the context switch > storm, or both? I didn't try for the assert after the patch. I was developing the test when I ran across the assert problem. It should trigger t

Re: [HACKERS] Assert failure found in 8.1RC1

2005-11-08 Thread Robert Creager
On Tue, 08 Nov 2005 14:09:58 -0600 "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > On Fri, Nov 04, 2005 at 08:46:27PM -0400, Marc G. Fournier wrote: > > On Fri, 4 Nov 2005, Jim C. Nasby wrote: > > For all the talk about "couldn't it be part of regression", I haven't seen > > anyone submit a patch tha

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-08 Thread Robert Creager
On Tue, 08 Nov 2005 11:12:04 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Teodor Sigaev <[EMAIL PROTECTED]> writes: > > Layout of GIST_SPLITVEC struct has been changed from 8.0, I'm afraid that > > old .so is used. spl_(right|left)valid fields was added to GIST_SPLITVEC. > > Does look a bit suspi

Re: [Pgsphere-dev] Re: [HACKERS] SIGSEGV taken on 8.1 during

2005-11-08 Thread Robert Creager
When grilled further on (Tue, 08 Nov 2005 10:06:38 -0500), Tom Lane <[EMAIL PROTECTED]> confessed: > Does PGSphere itself have any regression tests? > > (Actually, running the contrib regression tests might be more relevant > than the main PG tests, since several contrib modules with GIST > opcla

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-08 Thread Robert Creager
When grilled further on (Tue, 08 Nov 2005 09:20:13 -0500), Tom Lane <[EMAIL PROTECTED]> confessed: > Robert Creager <[EMAIL PROTECTED]> writes: > > v->spl_right is address 0xbp - uninitialized? > > The whole struct looks pretty uninitialized, which immediately mak

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-08 Thread Robert Creager
When grilled further on (Tue, 08 Nov 2005 15:13:32 +0300), Teodor Sigaev <[EMAIL PROTECTED]> confessed: > Hmm, did you recompile pg_sphere module for 8.1? Yes I did. Just did it again to make sure. Is there any way I can do a without a reconfigure/make/install of postgresql? The db is runnin

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-07 Thread Robert Creager
When grilled further on (Mon, 7 Nov 2005 22:25:17 -0700), Robert Creager <[EMAIL PROTECTED]> confessed: Sorry, I'll just trickle out the information. tassiv=# \d catalog_ra_decl_index Index "public.catalog_ra_decl_index" Column | Type +--- loc

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-07 Thread Robert Creager
When grilled further on (Mon, 7 Nov 2005 08:07:14 -0700), Robert Creager <[EMAIL PROTECTED]> confessed: I'm currently attached to the dead (dying) process. spl_nright seems pretty large... (gdb) print v->spl_nright $3 = 138311580 Program received signal SIGSEGV, Segmentation fau

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-07 Thread Robert Creager
When grilled further on (Sun, 6 Nov 2005 20:00:38 -0700), Robert Creager <[EMAIL PROTECTED]> confessed: Didn't set the core big enough (1Mb). It's now at 50Mb. I am using PGSphere, which should be the only gist indexes in use. gdb /usr/local/pgsql810/bin/postgres core.28

Re: [HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-06 Thread Robert Creager
When grilled further on (Sun, 06 Nov 2005 18:52:40 -0500), Andrew Dunstan <[EMAIL PROTECTED]> confessed: > > Which version is first in your path, 8.0 or 8.1? If 8.0, do you get a > different result from the 8.1 binaries? > 8.0 was first. I've specified the correct full path now for the execut

[HACKERS] SIGSEGV taken on 8.1 during dump/reload

2005-11-06 Thread Robert Creager
Hey all, I was doing a test run of a live dump from 8.0.2 to 8.1.0, and 8.1.0 took a segmentation violation 1 hour into the operation. My plan is to re-do the dump/restore, and if it fails again, to re-compile with debug and cassert, and try to get a core. The command line was (8.1.0 is on port

Re: [HACKERS] Seeing context switch storm with 10/13 snapshot of

2005-11-04 Thread Robert Creager
On Thu, 20 Oct 2005 17:35:31 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > Robert Creager <[EMAIL PROTECTED]> writes: > > Interesting. 7.4.1 is worse for this test, as two jump up to 130k. But, my > > app runs fine against 7.4.1... > > > Would it still be hel

Re: [HACKERS] Assert failure found in 8.1RC1

2005-11-02 Thread Robert Creager
On Wed, 02 Nov 2005 15:19:44 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Robert Creager <[EMAIL PROTECTED]> writes: > > TRAP: FailedAssertion("!(shared->page_number[slotno] == pageno && > > shared->page_status[slotno] == SLRU_PAGE_READ_IN_PROGRE

Re: [HACKERS] Assert failure found in 8.1RC1

2005-11-02 Thread Robert Creager
On Wed, 02 Nov 2005 15:37:05 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Robert Creager <[EMAIL PROTECTED]> writes: > > I can reproduce very quickly. Looks like I should try the patch in 248 > > first to see if it fixes 8.1RC1? > > Excellent. Yes, the sec

[HACKERS] Assert failure found in 8.1RC1

2005-11-02 Thread Robert Creager
FLAGS_SL = -fpic LDFLAGS = -Wl,-rpath,/usr/local/pgsql810/lib LDFLAGS_SL = LIBS = -lpgport -lz -lreadline -lncurses -lcrypt -lresolv -lnsl -ldl -lm -lbsd VERSION = PostgreSQL 8.1RC1 Thanks, Rob -- Robert Creager Advisory Software Engineer Data Management Group Sun Microsystems [EMAIL PROTECT

Re: [HACKERS] Seeing context switch storm with 10/13 snapshot of

2005-10-20 Thread Robert Creager
On Thu, 20 Oct 2005 23:28:21 +0100 Simon Riggs <[EMAIL PROTECTED]> wrote: > On Thu, 2005-10-20 at 14:59 -0600, Robert Creager wrote: > > On Thu, 20 Oct 2005 21:19:18 +0100 > > Simon Riggs <[EMAIL PROTECTED]> wrote: > > > > > Try this to recreate the pro

Re: [HACKERS] Seeing context switch storm with 10/13 snapshot of

2005-10-20 Thread Robert Creager
On Thu, 20 Oct 2005 21:19:18 +0100 Simon Riggs <[EMAIL PROTECTED]> wrote: > Try this to recreate the problem: > http://archives.postgresql.org/pgsql-performance/2004-04/msg00280.php > Yup, that does it. Three hits the level I see with my application ~100k. Two hits about 50k, one does nothing

Re: [HACKERS] Seeing context switch storm with 10/13 snapshot of

2005-10-18 Thread Robert Creager
On Tue, 18 Oct 2005 12:24:03 -0600 Robert Creager <[EMAIL PROTECTED]> wrote: > On Tue, 18 Oct 2005 10:29:43 -0600 > Robert Creager <[EMAIL PROTECTED]> wrote: > > > On Tue, 18 Oct 2005 00:25:25 +0100 > > Simon Riggs <[EMAIL PROTECTED]> wrote: > >

Re: [HACKERS] Seeing context switch storm with 10/13 snapshot of

2005-10-18 Thread Robert Creager
On Tue, 18 Oct 2005 10:29:43 -0600 Robert Creager <[EMAIL PROTECTED]> wrote: > On Tue, 18 Oct 2005 00:25:25 +0100 > Simon Riggs <[EMAIL PROTECTED]> wrote: > > > > Please try this patch and see if it reduces the CS storm: > > Sorry, didn't work. Took

Re: [HACKERS] Seeing context switch storm with 10/13 snapshot of

2005-10-18 Thread Robert Creager
On Tue, 18 Oct 2005 00:25:25 +0100 Simon Riggs <[EMAIL PROTECTED]> wrote: > > Please try this patch and see if it reduces the CS storm: > > http://archives.postgresql.org/pgsql-patches/2005-10/msg00091.php Yes, I will. I'd been trying to figure out what triggered it, as I was unable to reproduc

Re: [HACKERS] Seeing context switch storm with 10/13 snapshot of

2005-10-13 Thread Robert Creager
When grilled further on (Thu, 13 Oct 2005 22:44:54 -0400), Tom Lane <[EMAIL PROTECTED]> confessed: > Robert Creager <[EMAIL PROTECTED]> writes: > > I've been having this problem since trying to upgrade from 7.4.1 to 8.03, and > > now 8.1. > > Can you put

[HACKERS] Seeing context switch storm with 10/13 snapshot of 8.1beta3

2005-10-13 Thread Robert Creager
7 0 1032 63832 48 160899600 056 225 113536 40 60 0 0 Help? Thanks, Rob -- Robert Creager Advisory Software Engineer Data Management Group Sun Microsystems [EMAIL PROTECTED] 303.673.2365 Office 888.912.4458 Pager ---(end of broadcast)--

Re: [HACKERS] auto vacuum lock on 8.1beta1

2005-10-13 Thread Robert Creager
On Thu, 13 Oct 2005 14:20:46 -0500 Kevin Grittner <[EMAIL PROTECTED]> wrote: > I can confirm that the patch was in the snapshot I picked up this > morning at about 10:30 CDT. We've been using it since then and > have not seen the problem in spite of attempting to provoke it with > database vacuum

Re: [HACKERS] auto vacuum lock on 8.1beta1

2005-10-13 Thread Robert Creager
On Thu, 13 Oct 2005 15:09:58 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > Robert Creager <[EMAIL PROTECTED]> writes: > > Might this be the same problem as the recent thread "database vacuum from > > cron hanging" where Tom is: "I'm busy volatile-i

[HACKERS] auto vacuum lock on 8.1beta1

2005-10-13 Thread Robert Creager
cuum: processing database "int_test_new" creagrs=# select version(); version --- ------------ PostgreSQL 8.1beta2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1 (Mandrake Linux 9.2 3.3.1-2mdk) --

Re: [HACKERS] date_trunc problem in HEAD

2005-03-13 Thread Robert Creager
OK. I believe the following function provides the correct functionality. Agree/disagree? If it's good, I'll figure out how to convert this little monster to C... CREATE OR REPLACE FUNCTION date_trunc_week(timestamp without time zone) RETURNS timestamp without time zone AS ' DECLARE rea

Re: [HACKERS] date_trunc problem in HEAD

2005-03-13 Thread Robert Creager
When grilled further on (Sun, 13 Mar 2005 19:40:02 +0100), Kurt Roeckx <[EMAIL PROTECTED]> confessed: > > Attached is a patch against HEAD for your review. > > It has this comment in it: >/* the new year cannot be greater than the >

[HACKERS] date_trunc problem in HEAD

2005-03-13 Thread Robert Creager
Hey All, I goofed with the patch I submitted last year for adding 'week' capability to the date_trunc function. Attached is a patch against HEAD for your review. Cheers, Rob -- 11:00:49 up 47 days, 16:17, 4 users, load average: 3.01, 2.37, 2.37 Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT

Re: [HACKERS] Comments on patch for date_trunc( 'week', ... );

2004-06-10 Thread Robert Creager
When grilled further on (Wed, 3 Mar 2004 22:40:50 -0500 (EST)), Bruce Momjian <[EMAIL PROTECTED]> confessed: > > Well, it must have hit the lists if I have put it in the patch queue, no? > > --- > > Hey Bruce, > > I never

[HACKERS] Comments on patch for date_trunc( 'week', ... );

2004-06-09 Thread Robert Creager
Per a brief conversation with Tom, I've created a patch for adding support for 'week' within the date_trunc function. Within the patch I added a couple of test cases and associated target output, and changed the documentation to add 'week' appropriately. Comments? Should I of bypassed this list

Re: [HACKERS] pgAdmin

2004-06-09 Thread Robert Creager
When grilled further on (29 Feb 2004 08:46:36 -0800), [EMAIL PROTECTED] (Hammer) confessed: > Quick one: > Anyone know how to use Putty to open a connection up under SSH which > will allow pgAdmin III to connect to a postgresql database ie. Only > access to server postgresql is on is via ssh. >

Re: [HACKERS] Comments on patch for date_trunc( 'week', ... );

2004-03-03 Thread Robert Creager
lied patches list at: > > http://momjian.postgresql.org/cgi-bin/pgpatches > > I will try to apply it within the next 48 hours. > > ----------- > > > Robert Creager wrote: > -- Start of PGP signed

Re: [HACKERS] pgAdmin

2004-03-01 Thread Robert Creager
When grilled further on (29 Feb 2004 08:46:36 -0800), [EMAIL PROTECTED] (Hammer) confessed: > Quick one: > Anyone know how to use Putty to open a connection up under SSH which > will allow pgAdmin III to connect to a postgresql database ie. Only > access to server postgresql is on is via ssh. >

Re: [HACKERS] pg_dump bug in 7.4

2003-10-04 Thread Robert Creager
When grilled further on (Sat, 4 Oct 2003 12:50:27 -0500), Bruno Wolff III <[EMAIL PROTECTED]> confessed: > The following is still a problem in current cvs (as of 2 hours ago). > Normally I wouldn't bug people about this again this soon, but with talk of > a release candidate next week I wanted to

Re: [HACKERS] Header files installed for contrib modules?

2003-08-23 Thread Robert Creager
On Sat, 23 Aug 2003 21:16:38 +0200 (CEST) Peter Eisentraut <[EMAIL PROTECTED]> said something like: > Robert Creager writes: > > > Just wondering if there is currently any mechanism in the contrib makefile > > hierarchy for installing header files into an appropriate dir

[HACKERS] Header files installed for contrib modules?

2003-08-22 Thread Robert Creager
Hey, Just wondering if there is currently any mechanism in the contrib makefile hierarchy for installing header files into an appropriate directory. I didn't find anything. I'm using PGSphere (spherical types/operators), and trying to help them out a little here and there. When I converted my

Re: [HACKERS] 7.4Beta1 hang?

2003-08-14 Thread Robert Creager
On Sat, 09 Aug 2003 20:12:36 -0400 Tom Lane <[EMAIL PROTECTED]> said something like: > Robert Creager <[EMAIL PROTECTED]> writes: > > Anything to look at before I kick it? > > pg_locks and pg_stat_activity, if you can select from them in a > non-stuck backend. t

Re: [HACKERS] 7.4Beta1 hang?

2003-08-14 Thread Robert Creager
On Sat, 09 Aug 2003 21:17:05 -0400 Tom Lane <[EMAIL PROTECTED]> said something like: > Robert Creager <[EMAIL PROTECTED]> writes: > > [much data] > > Could you supply the relation names corresponding to the relation OIDs > appearing in pg_locks, so we can be sure w

[HACKERS] 7.4Beta1 hang?

2003-08-14 Thread Robert Creager
I appear to have a hang on my system (40 minutes so far, it's now 17:40). The code is from CVS updated 8/6 if I remember correctly. The machine is idle, with a vacuum waiting and an INSERT doing nothing. The vacuum is being generated via pg_autovacuum. The output from the perl script leading u

[HACKERS] 7.4 Beta1: variable not found in subplan target lists

2003-08-14 Thread Robert Creager
Hey again, Received this error: Aug 6 16:24:55 thunder postgres[7835]: [11-1] ERROR: variable not found in subplan target lists during this query: $dbh->do( qq/ DELETE FROM temp_obs_v WHERE file_id IN (SELECT file_id FROM temp_obs_v NATURAL JOIN files WHERE group_id = $group_

Re: [HACKERS] 7.4Beta1 hang?

2003-08-10 Thread Robert Creager
On Sat, 09 Aug 2003 21:17:05 -0400 Tom Lane <[EMAIL PROTECTED]> said something like: > > Could you supply the relation names corresponding to the relation OIDs > appearing in pg_locks, so we can be sure who's processing what? > Sure, if you tell me how ;-) I looked at the view definition and t

[HACKERS] 7.4 Beta1 "elog" problem

2003-08-10 Thread Robert Creager
I grabbed REL7_4_BETA1 from cvs this morning, and am having a problem. A trigger I wrote uses 'elog', which is apparently not defined any more in my build. The documentation doesn't build (my problem), but doc/src/sgml/spi.sgml indicates that elog should be valid. The error I receive when insta

Re: [HACKERS] 7.4Beta1 hang?

2003-08-10 Thread Robert Creager
On Sat, 9 Aug 2003 17:48:38 -0600 Robert Creager <[EMAIL PROTECTED]> said something like: I received another hang, this time without a vacuum occurring. It occurred during a copy operation. While there is a checkpoint process running, I don't believe it was there at the start of th

Re: [HACKERS] 7.4 Beta1 "elog" problem

2003-08-10 Thread Robert Creager
On Wed, 06 Aug 2003 15:41:47 -0700 Joe Conway <[EMAIL PROTECTED]> said something like: > Robert Creager wrote: > > psql:dbTriggers.sql:30: ERROR: could not load library > > "/usr/local/pgsql/triggers/tassiv_triggers.so": > > /usr/local/pgsql/triggers/tassi

Re: [HACKERS] Regression test failure date.

2003-07-28 Thread Robert Creager
I will stand by the fact that I cannot generate failures from 2003-02-15 (200+ runs), and I can from 2003-02-16. Just to make sure I didn't screw up the cvs usage, I'll try again tonight if I get the chance and re-download re-test these two days. I can set up a script that will step through week

Re: [HACKERS] FAQ programming entry?

2003-07-27 Thread Robert Creager
Sorry, wrong list... On Sun, 27 Jul 2003 14:37:59 -0600 Robert Creager <[EMAIL PROTECTED]> said something like: > > Hey Guys, > > I'm working on translating my system to use pg_sphere. The question I > have, which I think would make a good FAQ entry (or section is

[HACKERS] FAQ programming entry?

2003-07-27 Thread Robert Creager
Hey Guys, I'm working on translating my system to use pg_sphere. The question I have, which I think would make a good FAQ entry (or section is usage example?), is that I have a C language trigger function. How do I use spoint (and other types) internal to that set of functions? Note that I am

Re: [HACKERS] Regression test failure date.

2003-07-26 Thread Robert Creager
On Sat, 26 Jul 2003 21:08:46 -0400 (EDT) Bruce Momjian <[EMAIL PROTECTED]> said something like: > > I am seeing repeatable success from a CVS of 2003-05-01, and > repeatable failure from current CVS. > > I have only been running nightly paralell regression runs since June > 27, so it is possible

Re: [HACKERS] Regression test failure date.

2003-07-26 Thread Robert Creager
On Sat, 26 Jul 2003 20:24:56 -0400 Tom Lane <[EMAIL PROTECTED]> said something like: > > What time of day did your successive pulls correspond to, anyway? > (I believe my cvs2cl printout above is showing me EST.) > > regards, tom lane > > I'm MST, and I did not specify a

[HACKERS] Regression test failure date.

2003-07-26 Thread Robert Creager
I found it (I think)... Looks like something was done after the 15'th... 2003-02-15 passes 50/50 and 33/33 on second pass (so far) 2003-02-16 fails 6/50 vacuum failed 1 times misc failed 3 times sanity_check failed 3 times inherit failed 1 times triggers failed 4 times 2003-02-18

Re: [HACKERS] I might be getting closer?

2003-07-26 Thread Robert Creager
On Sat, 26 Jul 2003 16:49:27 -0400 (EDT) Bruce Momjian <[EMAIL PROTECTED]> said something like: > [ cc to hackers] > > It certainly looks closer, particularly because the failure is s > simple domain constraint failure and not a more internal error. > > Have you tried moving ahead a few days to

Re: [HACKERS] parallel regression test failure

2003-07-26 Thread Robert Creager
On Sat, 26 Jul 2003 16:40:27 -0400 (EDT) Bruce Momjian <[EMAIL PROTECTED]> said something like: > > That is a very good guess. All the errors seem related to the parser. > Everyone gets lucky now and then ;-) I'm now using bison 1.5 2003-01-22 did not fail in 50 tests. 2003-01-26 has not fail

Re: [HACKERS] parallel regression test failure

2003-07-26 Thread Robert Creager
On Sat, 26 Jul 2003 11:22:21 -0400 Tom Lane <[EMAIL PROTECTED]> said something like: > Robert Creager <[EMAIL PROTECTED]> writes: > > Just to make sure I've got this right: > > > cvs update -D -mm-dd > > make maintainer-clean > > ./co

Re: [HACKERS] parallel regression test failure

2003-07-26 Thread Robert Creager
./configure --with-pgport=5433 --prefix=/usr/local/pgsql_cvs The failure moves around (out of 25 tests): constraints failed 1 times cluster failed 1 times foreign_key failed 1 times misc failed 6 times sanity_check failed 3 times inherit failed 2 times triggers failed 4 times Have not tried ins

Re: [HACKERS] parallel regression test failure

2003-07-26 Thread Robert Creager
On Sat, 26 Jul 2003 10:47:12 -0400 (EDT) Bruce Momjian <[EMAIL PROTECTED]> said something like: > > If you would like to do the cvs -d testing yourself instead of me, let > me know. It will take me a few hours to get to it anyway. > Just to make sure I've got this right: cvs update -D -mm

Re: [HACKERS] parallel regression test failure

2003-07-26 Thread Robert Creager
On Sat, 26 Jul 2003 10:47:12 -0400 (EDT) Bruce Momjian <[EMAIL PROTECTED]> said something like: > > If you would like to do the cvs -d testing yourself instead of me, let > me know. It will take me a few hours to get to it anyway. > I will start doing pulling down old versions (once I figure o

Re: [HACKERS] parallel regression test failure

2003-07-26 Thread Robert Creager
On Sat, 26 Jul 2003 01:00:46 -0400 Tom Lane <[EMAIL PROTECTED]> said something like: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I run it every night and it fails 25% of the time. > > When did you start seeing the problem? > > I just wasted an hour running eighty-some iterations of "make ch

Re: [HACKERS] parallel regression test failure

2003-07-25 Thread Robert Creager
On Fri, 25 Jul 2003 19:57:04 -0400 Tom Lane <[EMAIL PROTECTED]> said something like: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I am seeing the following parallel regression test failures. Any > > idea on the cause? > > I don't see it here, on either of two different architectures. Maybe >

Re: [HACKERS] parallel regression test failure

2003-07-25 Thread Robert Creager
On Fri, 25 Jul 2003 19:57:04 -0400 Tom Lane <[EMAIL PROTECTED]> said something like: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I am seeing the following parallel regression test failures. Any > > idea on the cause? > > I don't see it here, on either of two different architectures. Maybe >

Re: [HACKERS] parallel regression test failure

2003-07-25 Thread Robert Creager
On Fri, 25 Jul 2003 19:57:04 -0400 Tom Lane <[EMAIL PROTECTED]> said something like: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I am seeing the following parallel regression test failures. Any > > idea on the cause? > > I don't see it here, on either of two different architectures. Maybe >