Skip site navigation (1) Skip section navigation (2)

From: "Kasia Tuszynska" <ktuszynska(at)esri(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject:
Date: 2008-09-25 00:43:03
Message-ID: D7BFFE348C53EF4E8AA0698B1E395FA91069BC09@flybywire.esri.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Everybody,

I am sorry if this is an inappropriate way of finding out the
information, but I suspect that there is a bug in postgres on windows, I
tried searching for a similar bug on the net but only found
pgsql-bugs(at)postgresql(dot)org(dot) to report bugs, before I send it as a
potential bug I would like to make sure that it has not been identified
already. If there is some search tool of reported bugs for postgres
please let me know. 

 

Particulars of the suspected bug:

I suspect that there is a memory leak somewhere related to handling
blobs

Tested on windows 2003 server sp2 and Red Hat 4 - only happens on
windows

While inserting binary data into a  blob filed postgres.exe crashes

 

Last statement in pg_log:

2008-09-19 22:15:16 PDT LOG: INSERT INTO db.user.table (objectid, area,
perimeter, tbd90_, tbd90_id, code_90, cnty_nm, local_nm, nmcenmq,
nmhanzi, a5,...shape) VALUES ( $1, $2, $3, $4, $5,...  $204 )

2008-09-19 22:15:16 PDT DETAIL:  parameters: $1 = '402', $2 =
'3642082536.41162', $3 = '340956.4869', $4 = '403', $5 = '403', ...,
$204 =
'390F0000430100000800100023000000A13C010001000000BAB2A791FB9B8316BAD

 

Looking in Event Viewer at the crashed process:

Faulting application postgres.exe, version 8.3.0.831, faulting module
msvcr80.dll, version 8.0.50727.1433, fault address 0x0001e44a

 

Often when postgres crashes it is very good at recovering, in this case
the left over postgres processes have to be killed manually. 

 

We work primarily with spatial data, so the blob field is used to store
either geometric shapes or raster pixels, both types of data has been
tested and in both cases the failure occurs on the insert of the blob.

 

 

 

pgsql-admin by date

Next:From: Claus GuttesenDate: 2008-09-25 07:59:31
Subject: iso-8859-1 and utf-8
Previous:From: ryota_nakazawaDate: 2008-09-25 00:05:30
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group