Re: ODBC query problem

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: Postgresql General Mail List <pgsql-general(at)postgresql(dot)org>
Subject: Re: ODBC query problem
Date: 2003-07-16 16:47:58
Message-ID: 20030716164758.GL30373@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 16, 2003 at 11:32:41AM -0500, Luis Maga?a wrote:
> 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

You don't say what platform you're running on, but I think for more
UNIXes sig 11 is SIGSEGV. SInce you always get it with the same
query, I'd suspect (1) a bad library, which is causing buffer
overflows (2) bad disk, which has put a bad block on your disk for
one of the requested tables (which then causes the crash) or (3), and
much less likely, bad RAM. Check your hardware, and let us know
whether you have a core file somewhere whence you can get a backtrace
(actually, since it's reproducible, you ought to be able to get a
backtrace while running the query).

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-07-16 16:50:10 Re: Postgresql "FIFO" Tables, How-To ?
Previous Message Brian Maguire 2003-07-16 16:44:05 Couple Postgres View Questions