Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E23F62E00D7 for ; Tue, 5 Feb 2008 09:25:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 03426-02-3 for ; Tue, 5 Feb 2008 09:25:00 -0400 (AST) Received: from brendan.brad.office.comodo.net (brad.comodogroup.com [82.109.38.202]) by postgresql.org (Postfix) with ESMTP id C61BF2E32EB for ; Tue, 5 Feb 2008 09:24:19 -0400 (AST) Received: (qmail 7034 invoked by uid 1000); 5 Feb 2008 13:24:17 -0000 Received: from mahdell.brad.office.comodo.net (HELO mahdell.brad.office.comodo.net) (192.168.0.228) by brendan.brad.office.comodo.net (qpsmtpd/0.31.1) with ESMTP; Tue, 05 Feb 2008 13:24:17 +0000 From: Mike Williams Organization: Comodo To: pgsql-admin@postgresql.org Subject: Re: "create implicit sequence" crashes postgres Date: Tue, 5 Feb 2008 13:24:12 +0000 User-Agent: KMail/1.9.7 References: <200802041726.01060.mike.williams@comodo.com> <200802051104.07958.mike.williams@comodo.com> <20080205113759.GC32363@alvh.no-ip.org> In-Reply-To: <20080205113759.GC32363@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200802051324.12712.mike.williams@comodo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/27 X-Sequence-Number: 28101 On Tuesday 05 February 2008 11:37:59 Alvaro Herrera wrote: > I guess it would still be good to know why it crashes. =A0I think the > reason you're not getting a good backtrace is that you're attempting to > get it from the client process, which is not the guilty one here. =A0Same > for the ulimit setting: you have to apply it to the session running > postmaster, not psql. =A0The core file should be located in your "data" > directory. Ahh, so there is a core dump! postgres@mcsql1 ~ $ !ul ulimit -c unlimited postgres@mcsql1 ~ $ !po postgres -D /var/lib/postgresql/data/ postgres@mcsql1 ~ $ psql Welcome to psql 8.2.6, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit postgres=3D# CREATE TABLE billing_transaction_items ( id serial NOT NULL, billing_transaction_id integer NOT NULL, pricing_term_id integer, product_id integer NOT NULL, is_free boolean NOT NULL, is_visible boolean NOT NULL, created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL, cost numeric(15,4) DEFAULT 0.0 NOT NULL, tax numeric(15,4) DEFAULT 0.0 NOT NULL, quoted_cost numeric(15,4) DEFAULT 0.0 NOT NULL, quoted_tax numeric(15,4) DEFAULT 0.0 NOT NULL ); server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. !> \q postgres@mcsql1 ~ $ gdb /usr/bin/postgres /var/lib/postgresql/data/core GNU gdb 6.6 Copyright (C) 2006 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain condition= s. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "x86_64-pc-linux-gnu"... Using host libthread_db library "/lib/libthread_db.so.1". Reading symbols from /lib64/libpam.so.0...done. Loaded symbols for /lib/libpam.so.0 Reading symbols from /usr/lib64/libssl.so.0.9.8...done. Loaded symbols for /usr/lib64/libssl.so.0.9.8 Reading symbols from /usr/lib64/libcrypto.so.0.9.8...done. Loaded symbols for /usr/lib64/libcrypto.so.0.9.8 Reading symbols from /lib64/libcrypt.so.1...done. Loaded symbols for /lib/libcrypt.so.1 Reading symbols from /lib64/libdl.so.2...done. Loaded symbols for /lib/libdl.so.2 Reading symbols from /lib64/libm.so.6...done. Loaded symbols for /lib/libm.so.6 Reading symbols from /lib64/libc.so.6...done. Loaded symbols for /lib/libc.so.6 Reading symbols from /lib64/ld-linux-x86-64.so.2...done. Loaded symbols for /lib64/ld-linux-x86-64.so.2 Reading symbols from /lib64/libnss_compat.so.2...done. Loaded symbols for /lib/libnss_compat.so.2 Reading symbols from /lib64/libnsl.so.1...done. Loaded symbols for /lib/libnsl.so.1 Reading symbols from /lib64/libnss_nis.so.2...done. Loaded symbols for /lib/libnss_nis.so.2 Reading symbols from /lib64/libnss_files.so.2...done. Loaded symbols for /lib/libnss_files.so.2 Core was generated by `postgres: postgres postgres [local] CR'. Program terminated with signal 11, Segmentation fault. #0 0x00000000006292bf in pfree (pointer=3D0x9bba00) at mcxt.c:585 585 mcxt.c: No such file or directory. in mcxt.c (gdb) (gdb) (gdb) bt #0 0x00000000006292bf in pfree (pointer=3D0x9bba00) at mcxt.c:585 #1 0x00000000006115b4 in EmitErrorReport () at elog.c:1746 #2 0x0000000000610b3e in errfinish (dummy=3D0) at elog.c:390 #3 0x00000000004a4ddc in transformColumnDefinition (pstate=3D0xa75978, cxt= =3D0x7fff06ee5b50, column=3D0xa4d190) at analyze.c:1098 #4 0x00000000004a6180 in transformStmt (pstate=3D0xa757d8, parseTree=3D0xa= 75738, extras_before=3D0x7fff06ee5c00, extras_after=3D0x7fff06ee5c08) at an= alyze.c:970 #5 0x00000000004a7a7a in do_parse_analyze (parseTree=3D0x0, pstate=3D0xa75= 7d8) at analyze.c:251 #6 0x00000000004a8544 in parse_analyze (parseTree=3D0xa75738, sourceText=3D0xa4c6d0 "CREATE TABLE billing_transaction_items (\n id= serial NOT NULL,\n billing_transaction_id integer NOT NULL,\n pricin= g_term_id integer,\n product_id integer NOT NULL,\n is_free boolean N= OT NULL"..., paramTypes=3D0x0, numParams=3D0) at analyze.c:173 #7 0x0000000000592f2b in pg_analyze_and_rewrite (parsetree=3D0xa75738, query_string=3D0xa4c6d0 "CREATE TABLE billing_transaction_items (\n = id serial NOT NULL,\n billing_transaction_id integer NOT NULL,\n pric= ing_term_id integer,\n product_id integer NOT NULL,\n is_free boolean= NOT NULL"..., paramTypes=3D0x0, numParams=3D0) at postgres.c:567 #8 0x000000000059322d in exec_simple_query ( query_string=3D0xa4c6d0 "CREATE TABLE billing_transaction_items (\n = id serial NOT NULL,\n billing_transaction_id integer NOT NULL,\n pric= ing_term_id integer,\n product_id integer NOT NULL,\n is_free boolean= NOT NULL"...) at postgres.c:875 #9 0x0000000000594bec in PostgresMain (argc=3D4, argv=3D0x9bb0c0, username= =3D0x9bb080 "postgres") at postgres.c:3424 #10 0x000000000056c058 in ServerLoop () at postmaster.c:2932 #11 0x000000000056dc26 in PostmasterMain (argc=3D3, argv=3D0x9b69e0) at pos= tmaster.c:966 #12 0x0000000000529133 in main (argc=3D3, argv=3D0x9b69e0) at main.c:188 (gdb) Means nothing to me... =2D-=20 Mike Williams System Administration Manager - Comodo Office Tel Europe: +44 (0) 161 8747070 =46ax Europe: +44 (0) 161 8771767