Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lYao9-0006nR-R8 for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Apr 2021 20:47:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lYao8-0000ff-OU for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Apr 2021 20:47:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lYao8-0000fY-IH for pgsql-hackers@lists.postgresql.org; Mon, 19 Apr 2021 20:47:48 +0000 Received: from relay2-d.mail.gandi.net ([217.70.183.194]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lYao3-0000JL-Ny for pgsql-hackers@lists.postgresql.org; Mon, 19 Apr 2021 20:47:47 +0000 X-Originating-IP: 99.10.92.30 Received: from [192.168.10.146] (99-10-92-30.lightspeed.rlghnc.sbcglobal.net [99.10.92.30]) (Authenticated sender: adsend@dunslane.net) by relay2-d.mail.gandi.net (Postfix) with ESMTPSA id 1664840002; Mon, 19 Apr 2021 20:47:39 +0000 (UTC) Subject: Re: Implementing Incremental View Maintenance To: Yugo NAGATA Cc: Andy Fan , PostgreSQL Hackers , Tatsuo Ishii , Konstantin Knizhnik , Thomas Munro References: <20201001140627.1f8fafe595f545e026d110c6@sraoss.co.jp> <024ba056-6b4f-b26c-af17-297c1bbca65a@postgrespro.ru> <20201112.205355.393498768557598337.t-ishii@sraoss.co.jp> <89729da8-9042-7ea0-95af-e415df6da14d@postgrespro.ru> <20201124182133.2b7d2ee8767f4bb946226ecc@sraoss.co.jp> <5663f5f0-48af-686c-bf3c-62d279567e2a@postgrespro.ru> <20201222215136.39a3736a948161fb490dbc75@sraoss.co.jp> <20201222222422.f3e34e2ac2eb4a9f510676a7@sraoss.co.jp> <20210112190308.ee9e98c24080310a487349f3@sraoss.co.jp> <20210122165954.d6386b0e3a530a76890b8fff@sraoss.co.jp> <20210216103155.762054c9d38727c782f0c11b@sraoss.co.jp> <20210219110126.7152beb4fa4fea5b1133eef3@sraoss.co.jp> <45b2760d-7ee9-0f46-50bf-b15fd440b52f@dunslane.net> <20210309092049.db22add3e2863c2140290a90@sraoss.co.jp> <20210309172750.8fd722a08ed3a2423bb25ccb@sraoss.co.jp> <20210407182537.5fdb444f6d4510a60524baab@sraoss.co.jp> From: Andrew Dunstan Message-ID: Date: Mon, 19 Apr 2021 16:47:38 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.4.0 MIME-Version: 1.0 In-Reply-To: <20210407182537.5fdb444f6d4510a60524baab@sraoss.co.jp> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 4/7/21 5:25 AM, Yugo NAGATA wrote: > Hi, > > I rebased the patch because the cfbot failed. > > Regards, > Yugo Nagata This patch (v22c) just crashed for me with an assertion failure on Fedora 31. Here's the stack trace: [New LWP 333090] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `postgres: andrew regression [local] INSERT                                    '. Program terminated with signal SIGABRT, Aborted. #0  0x00007f8981caa625 in raise () from /lib64/libc.so.6 #0  0x00007f8981caa625 in raise () from /lib64/libc.so.6 #1  0x00007f8981c938d9 in abort () from /lib64/libc.so.6 #2  0x000000000094a54a in ExceptionalCondition (conditionName=conditionName@entry=0xa91dae "queryDesc->sourceText != NULL", errorType=errorType@entry=0x99b468 "FailedAssertion", fileName=fileName@entry=0xa91468 "/home/andrew/pgl/pg_head/src/backend/executor/execMain.c", lineNumber=lineNumber@entry=199) at /home/andrew/pgl/pg_head/src/backend/utils/error/assert.c:69 #3  0x00000000006c0e17 in standard_ExecutorStart (queryDesc=0x226af98, eflags=0) at /home/andrew/pgl/pg_head/src/backend/executor/execMain.c:199 #4  0x00000000006737b2 in refresh_matview_datafill (dest=0x21cf428, query=, queryEnv=0x2245fd0, resultTupleDesc=0x7ffd5e764888, queryString=0x0) at /home/andrew/pgl/pg_head/src/backend/commands/matview.c:719 #5  0x0000000000678042 in calc_delta (queryEnv=0x2245fd0, tupdesc_new=0x7ffd5e764888, tupdesc_old=0x7ffd5e764880, dest_new=0x21cf428, dest_old=0x0, query=0x2246108, rte_path=0x2228a60, table=) at /home/andrew/pgl/pg_head/src/backend/commands/matview.c:2907 #6  IVM_immediate_maintenance (fcinfo=) at /home/andrew/pgl/pg_head/src/backend/commands/matview.c:1683 #7  0x000000000069e483 in ExecCallTriggerFunc (trigdata=0x7ffd5e764bb0, tgindx=2, finfo=0x22345f8, instr=0x0, per_tuple_context=0x2245eb0) at /home/andrew/pgl/pg_head/src/backend/commands/trigger.c:2142 #8  0x000000000069fc4c in AfterTriggerExecute (trigdesc=0x2233db8, trigdesc=0x2233db8, trig_tuple_slot2=0x0, trig_tuple_slot1=0x0, per_tuple_context=0x2245eb0, instr=0x0, finfo=0x2234598, relInfo=0x2233ba0, event=0x222d380, estate=0x2233710) at /home/andrew/pgl/pg_head/src/backend/commands/trigger.c:4041 #9  afterTriggerInvokeEvents (events=0x21cece8, firing_id=1, estate=0x2233710, delete_ok=false) at /home/andrew/pgl/pg_head/src/backend/commands/trigger.c:4255 #10 0x00000000006a4173 in AfterTriggerEndQuery (estate=estate@entry=0x2233710) at /home/andrew/pgl/pg_head/src/backend/commands/trigger.c:4632 #11 0x00000000006c04c8 in standard_ExecutorFinish (queryDesc=0x2237300) at /home/andrew/pgl/pg_head/src/backend/executor/execMain.c:436 #12 0x00000000008415d8 in ProcessQuery (plan=, sourceText=0x21490a0 "INSERT INTO mv_base_b VALUES(5,105);", params=0x0, queryEnv=0x0, dest=0x2221010, qc=0x7ffd5e764f00) at /home/andrew/pgl/pg_head/src/backend/tcop/pquery.c:190 #13 0x00000000008417f2 in PortalRunMulti (portal=portal@entry=0x21ac3c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x2221010, altdest=altdest@entry=0x2221010, qc=qc@entry=0x7ffd5e764f00) at /home/andrew/pgl/pg_head/src/backend/tcop/pquery.c:1267 #14 0x0000000000842415 in PortalRun (portal=portal@entry=0x21ac3c0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x2221010, altdest=altdest@entry=0x2221010, qc=0x7ffd5e764f00) at /home/andrew/pgl/pg_head/src/backend/tcop/pquery.c:779 #15 0x000000000083e3ca in exec_simple_query (query_string=0x21490a0 "INSERT INTO mv_base_b VALUES(5,105);") at /home/andrew/pgl/pg_head/src/backend/tcop/postgres.c:1196 #16 0x0000000000840075 in PostgresMain (argc=argc@entry=1, argv=argv@entry=0x7ffd5e765450, dbname=, username=) at /home/andrew/pgl/pg_head/src/backend/tcop/postgres.c:4458 #17 0x00000000007b8054 in BackendRun (port=, port=) at /home/andrew/pgl/pg_head/src/backend/postmaster/postmaster.c:4488 #18 BackendStartup (port=) at /home/andrew/pgl/pg_head/src/backend/postmaster/postmaster.c:4210 #19 ServerLoop () at /home/andrew/pgl/pg_head/src/backend/postmaster/postmaster.c:1742 #20 0x00000000007b8ebf in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x21435c0) at /home/andrew/pgl/pg_head/src/backend/postmaster/postmaster.c:1414 #21 0x000000000050e030 in main (argc=8, argv=0x21435c0) at /home/andrew/pgl/pg_head/src/backend/main/main.c:209 $1 = {si_signo = 6, si_errno = 0, si_code = -6, _sifields = {_pad = {333090, 500, 0 }, _kill = {si_pid = 333090, si_uid = 500}, _timer = {si_tid = 333090, si_overrun = 500, si_sigval = {sival_int = 0, sival_ptr = 0x0}}, _rt = {si_pid = 333090, si_uid = 500, si_sigval = {sival_int = 0, sival_ptr = 0x0}}, _sigchld = {si_pid = 333090, si_uid = 500, si_status = 0, si_utime = 0, si_stime = 0}, _sigfault = {si_addr = 0x1f400051522, _addr_lsb = 0, _addr_bnd = {_lower = 0x0, _upper = 0x0}}, _sigpoll = {si_band = 2147483981090, si_fd = 0}}} cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com