X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3E03FD1E2E2 for ; Tue, 16 Mar 2004 07:12:43 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 45614-04 for ; Tue, 16 Mar 2004 03:12:37 -0400 (AST) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by svr1.postgresql.org (Postfix) with ESMTP id A47DFD1E2AA for ; Tue, 16 Mar 2004 03:12:35 -0400 (AST) Received: from [206.19.64.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 1087007; Mon, 15 Mar 2004 23:08:01 -0800 Message-ID: <4056A8A7.4060208@joeconway.com> Date: Mon, 15 Mar 2004 23:11:35 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Matthew T. O'Connor" Cc: Tom Lane , pgsql-hackers , Josh Berkus Subject: Re: [PERFORM] rapid degradation after postmaster restart References: <4052661D.5060505@joeconway.com> <14884.1079150555@sss.pgh.pa.us> <4055F343.6070600@joeconway.com> <405614CA.5030101@zeut.net> <405689A4.4080406@joeconway.com> <4056916B.5090204@zeut.net> In-Reply-To: <4056916B.5090204@zeut.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/709 X-Sequence-Number: 51301 [moving to hackers] Matthew T. O'Connor wrote: > Good luck, I hope you can get permission. Would e nice to fix this > little crash. I went ahead and recompiled with --enable-debug, and get this trace: #0 0xfefb3218 in strlen () from /usr/lib/libc.so.1 #1 0xff006520 in _doprnt () from /usr/lib/libc.so.1 #2 0xff0082e8 in sprintf () from /usr/lib/libc.so.1 #3 0x1213c in print_db_info (dbi=0x28980, print_tbl_list=0) at pg_autovacuum.c:681 #4 0x120fc in print_db_list (db_list=0x25f80, print_table_lists=0) at pg_autovacuum.c:673 #5 0x11b44 in init_db_list () at pg_autovacuum.c:416 #6 0x12c58 in main (argc=154384, argv=0xff043a54) at pg_autovacuum.c:1007 Line 681 is this: sprintf(logbuffer, "dbname: %s Username %s Passwd %s", dbi->dbname, dbi->username, dbi->password); It appears that dbi->password is a null pointer: (gdb) print dbi->dbname $1 = 0x25f68 "template1" (gdb) print dbi->username $2 = 0x25b20 "dba" (gdb) print dbi->password $3 = 0x0 Problem is, since this is a development machine, they have everything set to "trust" in pg_hba.conf. I added a "-P foo" to the command line, and it starts up fine now. HTH, Joe