Postgres Pro
Downloads
Home   >   mailing lists

Thread: [Fwd: [BUGS] pg_autovacuum segv]

[Fwd: [BUGS] pg_autovacuum segv]

From
Markus Bertheau
Date:
Forwarding to -hackers as per README

-----Пересланное сообщение-----

From: Markus Bertheau <twanger@bluetwanger.de>
To: pgsql-bugs@postgresql.org
Subject: [BUGS] pg_autovacuum segv
Date: 09 Oct 2003 17:30:48 +0200

(gdb) run
Starting program: /root/src/postgresql-7.4beta4/contrib/pg_autovacuum/pg_autovacuum 
[2003-10-09 05:28:13 PM] Failed connection to database template1 with error: FATAL:  user "root" does not exist
.

Program received signal SIGSEGV, Segmentation fault.
0x0804a132 in check_stats_enabled (dbi=0x804e2f0) at pg_autovacuum.c:739
739                     strcmp("on", PQgetvalue(res, 0, PQfnumber(res, "stats_row_level")));
(gdb) bt
#0  0x0804a132 in check_stats_enabled (dbi=0x804e2f0) at pg_autovacuum.c:739
#1  0x0804a9b3 in main (argc=1, argv=0xbfffdf64) at pg_autovacuum.c:1004
#2  0x40103657 in __libc_start_main (main=0x804a8e4 <main>, argc=1, ubp_av=0xbfffdf64, init=0x8048b30 <_init>,
fini=0x804afd0<_fini>, rtld_fini=0x4000dcd4 <_dl_fini>, stack_end=0xbfffdf5c) at ../sysdeps/generic/libc-start.c:129
 
(gdb) 

This is on a i386 Redhat 7.2 with pg7.3.4 installed.

-- 
Markus Bertheau <twanger@bluetwanger.de>


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command   (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)

Re: [Fwd: [BUGS] pg_autovacuum segv]

From
Christopher Browne
Date:
In the last exciting episode, twanger@bluetwanger.de (Markus Bertheau) wrote:
> Forwarding to -hackers as per README
>
> -----Пересланное сообщение-----
>
> From: Markus Bertheau <twanger@bluetwanger.de>
> To: pgsql-bugs@postgresql.org
> Subject: [BUGS] pg_autovacuum segv
> Date: 09 Oct 2003 17:30:48 +0200
>
> (gdb) run
> Starting program: /root/src/postgresql-7.4beta4/contrib/pg_autovacuum/pg_autovacuum 
> [2003-10-09 05:28:13 PM] Failed connection to database template1 with error: FATAL:  user "root" does not exist

It should probably have died more gracefully, but what happened here
should be clear enough.

You ran the program as root, and so it assumed that it should connect
as PostgreSQL user "root."  That user does not exist, so the
connection failed.

You'll need to specify a user, or establish "root" as a superuser.
-- 
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
http://www3.sympatico.ca/cbbrowne/spreadsheets.html
"Bother," said Pooh as he struggled with sendmail.cf.
"It never does quite what I want."
"I wish Christopher Robin were here.".

Re: [Fwd: [BUGS] pg_autovacuum segv]

From
Bruce Momjian
Date:
OK, I committed a fix so it will not segfault on root starting it.

---------------------------------------------------------------------------

Christopher Browne wrote:
> In the last exciting episode, twanger@bluetwanger.de (Markus Bertheau) wrote:
> > Forwarding to -hackers as per README
> >
> > -----?????????????????????? ??????????????????-----
> >
> > From: Markus Bertheau <twanger@bluetwanger.de>
> > To: pgsql-bugs@postgresql.org
> > Subject: [BUGS] pg_autovacuum segv
> > Date: 09 Oct 2003 17:30:48 +0200
> >
> > (gdb) run
> > Starting program: /root/src/postgresql-7.4beta4/contrib/pg_autovacuum/pg_autovacuum 
> > [2003-10-09 05:28:13 PM] Failed connection to database template1 with error: FATAL:  user "root" does not exist
> 
> It should probably have died more gracefully, but what happened here
> should be clear enough.
> 
> You ran the program as root, and so it assumed that it should connect
> as PostgreSQL user "root."  That user does not exist, so the
> connection failed.
> 
> You'll need to specify a user, or establish "root" as a superuser.
> -- 
> wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
> http://www3.sympatico.ca/cbbrowne/spreadsheets.html
> "Bother," said Pooh as he struggled with sendmail.cf.
> "It never does quite what I want."
> "I wish Christopher Robin were here.". 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073