Обсуждение: core dump on select

On Fri, Sep 24, 2004 at 03:55:43PM -0500, John Liu wrote:
> max memory size (kbytes)    32768
>
> open files                  2000
>
> pipe size (512 bytes)       64
>
> stack size (kbytes)         2097151

My guess is that one of these -- likely the first -- is biting you.
What isn't clear to me is whether you're getting core from the
postmaster or psql itself.  I've seen the latter pretty frequently,
but there is a current segfault problem with AIX 5.1 at least.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what
you told them to.  That actually seems sort of quaint now.
        --J.D. Baldwin

Core dump on select from psql on AIX 5.x

I have the following task at hand -
A huge table, one of the column data has duplicated entries. I want to find
those duplicated records in this column -
select count(*), col-x from table-x group by col-x having count(*) >1;

Of course, the above query will produce a core!! My question is: is there a
smart way in postgresql to solve this problem? Could I avoid this core dump
issue if I use pgplsql?

john
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Andrew Sullivan
Sent: Monday, September 27, 2004 8:38 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] core dump on select

On Fri, Sep 24, 2004 at 03:55:43PM -0500, John Liu wrote:
> max memory size (kbytes)    32768
>
> open files                  2000
>
> pipe size (512 bytes)       64
>
> stack size (kbytes)         2097151

My guess is that one of these -- likely the first -- is biting you.
What isn't clear to me is whether you're getting core from the
postmaster or psql itself.  I've seen the latter pretty frequently,
but there is a current segfault problem with AIX 5.1 at least.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what
you told them to.  That actually seems sort of quaint now.
        --J.D. Baldwin

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

On Mon, Sep 27, 2004 at 04:18:41PM -0500, John Liu wrote:
> Core dump on select from psql on AIX 5.x
>
> I have the following task at hand -
> A huge table, one of the column data has duplicated entries. I want to find
> those duplicated records in this column -
> select count(*), col-x from table-x group by col-x having count(*) >1;
>
> Of course, the above query will produce a core!! My question is: is there a
> smart way in postgresql to solve this problem? Could I avoid this core dump
> issue if I use pgplsql?

Do you really have that many duplicated rows? You're still not saying
if the core dump is in the client or in the server. If it's in the
client, do a SELECT INTO and then browse a limited portion from
there...

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Andrew Sullivan
> Sent: Monday, September 27, 2004 8:38 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] core dump on select
>
> On Fri, Sep 24, 2004 at 03:55:43PM -0500, John Liu wrote:
> > max memory size (kbytes)    32768
> >
> > open files                  2000
> >
> > pipe size (512 bytes)       64
> >
> > stack size (kbytes)         2097151
>
> My guess is that one of these -- likely the first -- is biting you.
> What isn't clear to me is whether you're getting core from the
> postmaster or psql itself.  I've seen the latter pretty frequently,
> but there is a current segfault problem with AIX 5.1 at least.
>
> A
>
> --
> Andrew Sullivan  | ajs@crankycanuck.ca
> I remember when computers were frustrating because they *did* exactly what
> you told them to.  That actually seems sort of quaint now.
>         --J.D. Baldwin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.