Re: WAL recycling, Linux 2.4.18

With the recompiled non-stripped postgres binary, connecting to one of the
blocked threads during a checkpoint:

pexicast_lg=# select * from pg_stat_activity where datname='pexicast_lg';
datid | datname | procpid | usesysid | usename
|
current_query

---------+-------------+---------+----------+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3926366 | pexicast_lg | 5130 | 100 | tomcat | UPDATE
list_entries SET last_mail=now() WHERE list_entry_id IN
(623793,623813,623833,623853,623873,623893,623913,623933,623953,623973,623993,624013,624033,624053,624073,624093,624113,624133,624153,624173,624193,624213,624233,624253,624273,624293,624313,62

(gdb) where
#0 0x4028299d in fdatasync () from /lib/libc.so.6
#1 0x081049ae in pg_fdatasync (fd=53) at fd.c:233
#2 0x08088276 in issue_xlog_fsync () at xlog.c:3367
#3 0x08085206 in XLogWrite (WriteRqst=
{Write = {xlogid = 14, xrecoff = 1170656964}, Flush = {xlogid =
14, xrecoff = 1170656964}}) at xlog.c:1167
#4 0x080854fd in XLogFlush (record={xlogid = 14, xrecoff = 1170656964})
at xlog.c:1277
#5 0x0808335b in RecordTransactionCommit () at xact.c:610
#6 0x0808365e in CommitTransaction () at xact.c:973
#7 0x08083929 in CommitTransactionCommand () at xact.c:1256
#8 0x0810eedf in finish_xact_command () at postgres.c:931
#9 0x0810edee in pg_exec_query_string (
query_string=0x837b1b8 "UPDATE list_entries SET last_mail=now() WHERE
list_entry_id IN
(623793,623813,623833,623853,623873,623893,623913,623933,623953,623973,623993,624013,624033,624053,624073,624093,624113,624133,624153,624"...,
dest=Remote,
parse_context=0x834e508) at postgres.c:871
#10 0x0810fd5e in PostgresMain (argc=4, argv=0xbfffe140,
username=0x83297e9 "tomcat") at postgres.c:1926
#11 0x080f6d4e in DoBackend (port=0x83296b8) at postmaster.c:2243
#12 0x080f669f in BackendStartup (port=0x83296b8) at postmaster.c:1874
#13 0x080f5882 in ServerLoop () at postmaster.c:995
#14 0x080f5391 in PostmasterMain (argc=1, argv=0x8312448) at postmaster.c:771
#15 0x080d4e18 in main (argc=1, argv=0xbfffeac4) at main.c:206

Oddly enough, I can no longer control-C out after doing a "c"ontinue
command. Hm.

Cheers,

Doug

At 02:17 PM 7/8/2002, Tom Lane wrote:
>Doug Fields <dfields-pg-general(at)pexicom(dot)com> writes:
> > I was able to set a breakpoint at CreateCheckPoint - gdb never found a
> > MoveOfflineLogs for me to set a breakpoint.
>
>Grumble. It's a static routine, and I imagine its name has been totally
>stripped from the executable.
>
> > Also, I can't seem to recompile PostgreSQL because Debian can't find a
> > tclConfig.sh.
>
>Oliver, what's an appropriate way to rebuild PG with debug symbols from
>the Debian package?
>
> regards, tom lane