ODBC query problem

From: Luis Magaña <joe666(at)gnovus(dot)com>
To: Postgresql General Mail List <pgsql-general(at)postgresql(dot)org>
Subject: ODBC query problem
Date: 2003-07-16 16:32:41
Message-ID: 1058373160.9218.18.camel@kerberus.santarita.intranet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

yesterday I ran vaccumdb on one of our postgresql databases. As of
today, whenever I try to connect to the postmaster from Windows using
the latest ODBC driver the postmaster crashes and restarts itself again,
here the log output:

2003-07-16 11:26:48 [1629] LOG: connection authorized: user=sentinell
database=thot
2003-07-16 11:26:48 [1629] LOG: query: select version()
2003-07-16 11:26:48 [1629] LOG: duration: 0.007115 sec
2003-07-16 11:26:48 [1629] LOG: query: set DateStyle to 'ISO'
2003-07-16 11:26:48 [1629] LOG: duration: 0.001107 sec
2003-07-16 11:26:48 [1629] LOG: query: set geqo to 'OFF'
2003-07-16 11:26:48 [1629] LOG: duration: 0.000814 sec
2003-07-16 11:26:48 [1629] LOG: query: select oid from pg_type where
typname='lo'
2003-07-16 11:26:48 [1629] LOG: duration: 0.018918 sec
2003-07-16 11:26:48 [1629] LOG: query: select pg_client_encoding()
2003-07-16 11:26:48 [1629] LOG: duration: 0.002753 sec
2003-07-16 11:26:48 [1629] LOG: query: select relname, nspname,
relkind from pg_catalog.pg_class, pg_catalog.pg_namespace where relkind
in ('r', 'v') and nspname like 'public' and relname like
'diario_factura_embarque' and relname !~ '^pg_|^dd_' and
pg_namespace.oid = relnamespace order by nspname, relname
2003-07-16 11:26:49 [1623] LOG: server process (pid 1629) was
terminated by signal 11
2003-07-16 11:26:49 [1623] LOG: terminating any other active server
processes
2003-07-16 11:26:49 [1623] LOG: all server processes terminated;
reinitializing shared memory and semaphores
2003-07-16 11:26:49 [1630] LOG: database system was interrupted at
2003-07-16 11:26:27 CDT
2003-07-16 11:26:49 [1630] LOG: checkpoint record is at 0/501001E0
2003-07-16 11:26:49 [1630] LOG: redo record is at 0/501001E0; undo
record is at 0/0; shutdown TRUE
2003-07-16 11:26:49 [1630] LOG: next transaction id: 1973685; next
oid: 1644084
2003-07-16 11:26:49 [1630] LOG: database system was not properly shut
down; automatic recovery in progress
2003-07-16 11:26:49 [1630] LOG: ReadRecord: record with zero length
at 0/50100220
2003-07-16 11:26:49 [1630] LOG: redo is not required
2003-07-16 11:26:51 [1630] LOG: database system is ready

as I can see the long query crashes the post master for some unknown
reason. I've tried this on 7.3.2 and 7.3.3 with the same results.

There is a lot of space in the hard disks so I assume that is not the
problem. Also is to note that I can connect with no problems from PHP,
psql and some other programs running on linux. But, If I run that query
from psql the postmaster also crashes.

Best Regards.

--
Luis Magaña.
Gnovus Networks & Software.
www.gnovus.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Maguire 2003-07-16 16:44:05 Couple Postgres View Questions
Previous Message Annabelle Desbois 2003-07-16 16:31:22 Transactions