6.5 problems: Buffer Leak? - Mailing list pgsql-general

From ty
Subject 6.5 problems: Buffer Leak?
Date
Msg-id 377DD841.352D8955@cpsc.ucalgary.ca
Whole thread Raw
List pgsql-general
Hello,

I installed PostgreSQL 6.4.2 and had it running without any problem for
several months, it even passed the regression tests almost perfectly
(!!! a first time for me)... After 6.5 came out, I completely removed
the 6.4.2 installation with a `rm -r /usr/local/pgsql/` soon followed by
a `shutdown -r now`... I compiled 6.5 (gcc couldn't compile two certain
.c files, so I removed the -O2 flag and it compiled properly)..
installed it, ran initdb, still no other problems to speak of...

Then: login as user postgres, and you can see the following transcript
of my session:


koi:~$ psql template1
Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL
NOTICE:  Buffer Leak: [065] (freeNext=0, freePrev=0, relname=,
blockNum=0, flags
=0x0, refcount=0 265)
NOTICE:  Buffer Leak: [131] (freeNext=0, freePrev=0, relname=,
blockNum=0, flags
=0x0, refcount=0 338)
NOTICE:  Buffer Leak: [149] (freeNext=0, freePrev=0, relname=,
blockNum=0, flags
=0x0, refcount=0 265)
NOTICE:  Buffer Leak: [197] (freeNext=0, freePrev=512, relname=r,
blockNum=20994
56, flags=0x6174, refcount=1667855475 338)
NOTICE:  Buffer Leak: [215] (freeNext=917582, freePrev=2099456,
relname=, blockN
um=0, flags=0x0, refcount=0 282)
NOTICE:  Buffer Leak: [219] (freeNext=0, freePrev=-196604, relname=,
blockNum=68
81281, flags=0x4049, refcount=0 17)
NOTICE:  Buffer Leak: [220] (freeNext=-1, freePrev=-1, relname=,
blockNum=0, fla
gs=0x200, refcount=0 136550544)
NOTICE:  Buffer Leak: [221] (freeNext=0, freePrev=16455, relname=,
blockNum=0, f
lags=0x47, refcount=2099456 136550544)
NOTICE:  Buffer Leak: [223] (freeNext=0, freePrev=917573, relname=,
blockNum=664
7137, flags=0x0, refcount=0 873)
NOTICE:  Buffer Leak: [224] (freeNext=1260, freePrev=2019650915,
relname=, block
Num=0, flags=0x0, refcount=0 5)
NOTICE:  Buffer Leak: [226] (freeNext=0, freePrev=0, relname=,
blockNum=-262140,
 flags=0xffff, refcount=-1 5)
NOTICE:  Buffer Leak: [228] (freeNext=0, freePrev=-1, relname=,
blockNum=16447,
flags=0x0, refcount=512 136549705)
NOTICE:  Buffer Leak: [229] (freeNext=6881280, freePrev=0, relname=,
blockNum=51
2, flags=0x0, refcount=917566 135009884)
NOTICE:  Buffer Leak: [230] (freeNext=0, freePrev=0, relname=,
blockNum=917565,
flags=0x4ec, refcount=1936941424 136549672)
NOTICE:  Buffer Leak: [231] (freeNext=0, freePrev=0, relname=c,
blockNum=1667593
077, flags=0x64, refcount=0 82)
NOTICE:  Buffer Leak: [232] (freeNext=2099456, freePrev=1260, relname=,
blockNum
=0, flags=0x0, refcount=0 1886217472)
NOTICE:  Buffer Leak: [233] (freeNext=1701011826, freePrev=0, relname=,
blockNum
=0, flags=0x10, refcount=0 1702125932)
NOTICE:  Buffer Leak: [234] (freeNext=0, freePrev=0, relname= ,
blockNum=0, flag
s=0x0, refcount=-1 49)
NOTICE:  Buffer Leak: [248] (freeNext=0, freePrev=917545, relname=,
blockNum=203
7675109, flags=0x0, refcount=0 1953722224)
NOTICE:  Buffer Leak: [249] (freeNext=1255, freePrev=1919906416,
relname=, block
Num=0, flags=0x0, refcount=0 1936028263)
NOTICE:  AbortTransaction and not in in-progress state

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: template1

EOFplate1=>


This happens when postmaster is run with both the simple
postmaster -i
and as well as
export PGDATESTYLE=ISO
/usr/bin/su - postgres -c "nohup /usr/local/pgsql/bin/postmaster -i -S
-D/usr/local/pgsql/data -o '-F -B 256 -S 1024' 2>&1 >/tmp/postgres.log
&"

The installation is Stampede 0.89 (missing software added into the
requirements of 6.5 above and beyond those of 6.4.2?) on a Dual Celeron
system running at their native 300MHz (inable to function properly in a
dual processing environment?), if that gives any clue...

Thanks in advance,

Ty
tyATarrowsmithDOTnet



pgsql-general by date:

Previous
From: "Stephen Boyle"
Date:
Subject: Subject: Postgres Upsizing Tool for MSAccess 97 - New Version 0.15 Available !!
Next
From: Astro Monk
Date:
Subject: docs where?