Re: ODBC query problem

From: Luis Magaña <joe666(at)santarita(dot)com(dot)mx>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: Postgresql General Mail List <pgsql-general(at)postgresql(dot)org>
Subject: Re: ODBC query problem
Date: 2003-07-16 17:04:25
Message-ID: 1058375064.9220.23.camel@kerberus.santarita.intranet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks,

yes, it's running solaris 8 on a SPARC with SCSI disk.

It will be really hard for me to turn the system off in order to check
the disk for surface errors since is a system in production.

Howver, I have a core file dumped whenever this happens. Let me find out
how to do the backtrace and I'll show it to you gladly.

Thanks for the help.

On Wed, 2003-07-16 at 11:47, Andrew Sullivan wrote:
> 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
--
Luis Magaña.
Invernadero Santa Rita.
www.santarita.com.mx

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kirill Ponazdyr 2003-07-16 17:09:01 Re: Postgresql "FIFO" Tables, How-To ?
Previous Message Bruno Wolff III 2003-07-16 16:50:51 Re: Postgresql "FIFO" Tables, How-To ?