MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Wed, 07 Dec 2016 17:19:54 +0100
From: Erik Rijkers <er@xs4all.nl>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Robert Haas <robertmhaas@gmail.com>, Amit Langote
 <amitlangote09@gmail.com>, Rajkumar Raghuwanshi
 <rajkumar.raghuwanshi@enterprisedb.com>, Ashutosh Bapat
 <ashutosh.bapat@enterprisedb.com>, Pg Hackers
 <pgsql-hackers@postgresql.org>, pgsql-hackers-owner@postgresql.org
Subject: Re: Declarative partitioning - another take
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>
Message-ID: <ce3c665ba06aed715386e79ef2abc616@xs4all.nl>
User-Agent: XS4ALL Webmail
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

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