Content-Type: text/plain; charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2102\))
Subject: Re: segfault when creating index on huge table
From: Yiqing Jin <yiqing.jin@gmail.com>
In-Reply-To: <4948.1437070492@sss.pgh.pa.us>
Date: Thu, 16 Jul 2015 13:34:47 -0700
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <2B30837D-16A9-40F1-A150-2F3511F54FB4@gmail.com>
References: 
 <CAL8HZuNR2FR1owZHWG-p64GJtNfbbmPx1Y2OXmJ_XuQ3P8YtVA@mail.gmail.com>
 <4948.1437070492@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi Tom,=20

Thanks for your reply!

I=E2=80=99m having trouble getting the full stack trace since it=E2=80=99s =
a controlled environment and I need to figure out a way to install all the =
debug info packages.

but for now i have checked all core dumps which all seems crashed at same p=
oint.

warning: no loadable sections found in added symbol-file system-supplied DS=
O at 0x7fffe2b31000
Core was generated by `postgres: osm osm_planet [local] ALTER TABLE        =
  '.
Program terminated with signal 11, Segmentation fault.
#0  0x0000000000785180 in med3_tuple (a=3D0x7f31613f1028, b=3D0x7f31613f104=
0, c=3D0xffffffff3ffffffd, cmp_tuple=3D0x7f43613f1010, state=3D0x1) at qsor=
t_tuple.c:66
66	{
Missing separate debuginfos, use: debuginfo-install glibc-2.12-1.149.el6_6.=
5.x86_64


I=E2=80=99ll try get help to get a full stack trace and post here as soon a=
s possible.

Thanks
Yiqing

> On Jul 16, 2015, at 11:14 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> Yiqing Jin <yiqing.jin@gmail.com> writes:
>> I'm trapped with a problem when trying to create an index on a table with
>> about 2.8 billion records in it.
>> ALTER TABLE ONLY nodes ADD CONSTRAINT pk_nodes PRIMARY KEY (id);
>> or
>> create index pknode on nodes(id);
>=20
>> Postgres terminated with segfault during the proocess.
>=20
> That shouldn't happen.  Can you get a stack trace from the core dump?
>=20
> https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL=
_backend
>=20
> 			regards, tom lane


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin