agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Erik Rijkers <er@xs4all.nl>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Amit Langote <amitlangote09@gmail.com>
Cc: Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
Cc: Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Cc: pgsql-hackers-owner@postgresql.org
Subject: Re: Declarative partitioning - another take
Date: Wed, 07 Dec 2016 17:19:54 +0100
Message-ID: <ce3c665ba06aed715386e79ef2abc616@xs4all.nl> (raw)
In-Reply-To: <78ae9888-7372-245d-cf6b-f655e6fe6c12@lab.ntt.co.jp>
References: <ad16e2f5-fc7c-cc2d-333a-88d4aa446f96@lab.ntt.co.jp>
<8d7c35e3-1c85-33d0-4440-0a75bf9d31cd@lab.ntt.co.jp>
<56ec5504-c4d7-534c-8832-696dddfd58d1@lab.ntt.co.jp>
<CA+Tgmoarz2hkxoNddx9Ng_HMeoq4G8Q-R-teQtwmE8nCxkAJow@mail.gmail.com>
<aa874eaf-cd3b-0f75-c647-6c0ea823781e@lab.ntt.co.jp>
<CA+TgmobF2r=f-crrE-k7WM8iFpBKLz3dtBtEc=KmkudYViYcyQ@mail.gmail.com>
<2587c47e-7ff7-80db-953f-fb532c215219@lab.ntt.co.jp>
<CA+Tgmobksy=erJSrY55AvZJtaEFJmASmmM3Pmn6nOKP=95ZnLQ@mail.gmail.com>
<357638a4-f4e8-317a-6450-6e03f30caa62@lab.ntt.co.jp>
<CA+TgmoZ-feQsxc7U_JerM_AFChp3Qf6btK708SAe7M8Vdv5=jA@mail.gmail.com>
<f2f36bbd-0851-2256-5ca1-86322c1f82e3@lab.ntt.co.jp>
<CA+TgmoZN_Zf7MBb48O66FAJgFe0S9_NkLVeQNBz6hsxb6Og93w@mail.gmail.com>
<890ce68d-2cff-ccf3-67f7-6f5d3264dbfc@lab.ntt.co.jp>
<CA+TgmobjAVgiXWqa3WmPO09Ma+o8c=3+JVYP+1fE_TFvNYJ5PQ@mail.gmail.com>
<CA+HiwqE1-1w9GiPE3+oje00=y5mzTu8c8XCn=9jzKW4ik+3y9w@mail.gmail.com>
<CA+Tgmob9o3+xgYHtGbfzUWm9bknRryx53Q5pEVFkzVHSDO=QXQ@mail.gmail.com>
<78ae9888-7372-245d-cf6b-f655e6fe6c12@lab.ntt.co.jp>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
On 2016-12-07 12:42, Amit Langote wrote:
> 0001-Catalog-and-DDL-for-partitioned-tables-20.patch
> 0002-psql-and-pg_dump-support-for-partitioned-tables-20.patch
> 0003-Catalog-and-DDL-for-partitions-20.patch
> 0004-psql-and-pg_dump-support-for-partitions-20.patch
> 0005-Teach-a-few-places-to-use-partition-check-quals-20.patch
> 0006-Tuple-routing-for-partitioned-tables-20.patch
> 0007-Update-DDL-Partitioning-chapter-to-reflect-new-devel-20.patch
Patches apply, compile, check OK.
But this yields a segfault:
begin;
create schema if not exists s;
create table s.t (c text, d text, id serial) partition by list
((ascii(substring(coalesce(c, d, ''), 1, 1))));
create table s.t_part_ascii_065 partition of s.t for values in ( 65 );
it logs as follows:
2016-12-07 17:03:45.787 CET 6125 LOG: server process (PID 11503) was
terminated by signal 11: Segmentation fault
2016-12-07 17:03:45.787 CET 6125 DETAIL: Failed process was running:
create table s.t_part_ascii_065 partition of s.t for values in ( 65 );
2016-12-07 17:03:45.787 CET 6125 LOG: terminating any other active
server processes
2016-12-07 17:03:45.791 CET 6125 LOG: all server processes terminated;
reinitializing
2016-12-07 17:03:45.999 CET 11655 LOG: database system was interrupted;
last known up at 2016-12-07 17:00:38 CET
2016-12-07 17:03:48.040 CET 11655 LOG: database system was not properly
shut down; automatic recovery in progress
2016-12-07 17:03:48.156 CET 11655 LOG: redo starts at 0/2897988
2016-12-07 17:03:48.172 CET 11655 LOG: invalid magic number 0000 in log
segment 000000010000000000000002, offset 9207808
2016-12-07 17:03:48.172 CET 11655 LOG: redo done at 0/28C72C0
2016-12-07 17:03:48.172 CET 11655 LOG: last completed transaction was
at log time 2016-12-07 17:01:29.580562+01
2016-12-07 17:03:49.534 CET 11655 LOG: MultiXact member wraparound
protections are now enabled
2016-12-07 17:03:49.622 CET 6125 LOG: database system is ready to
accept connections
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
view thread (329+ messages) latest in thread
Message-ID: <ce3c665ba06aed715386e79ef2abc616@xs4all.nl>
Permalink: ../ce3c665ba06aed715386e79ef2abc616@xs4all.nl/
Also on: postgresql.org/message-id/ce3c665ba06aed715386e79ef2abc616@xs4all.nl
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: er@xs4all.nl, Langote_Amit_f8@lab.ntt.co.jp, robertmhaas@gmail.com, amitlangote09@gmail.com, rajkumar.raghuwanshi@enterprisedb.com, ashutosh.bapat@enterprisedb.com, pgsql-hackers-owner@postgresql.org
Subject: Re: Declarative partitioning - another take
In-Reply-To: <ce3c665ba06aed715386e79ef2abc616@xs4all.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox