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 1poQEh-0000Pj-8Q for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Apr 2023 14:53:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1poQEf-0001pS-N3 for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Apr 2023 14:53:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1poQEf-0001oq-9B for pgsql-hackers@lists.postgresql.org; Mon, 17 Apr 2023 14:53:41 +0000 Received: from mail-io1-xd33.google.com ([2607:f8b0:4864:20::d33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1poQEX-000Kg8-Uy for pgsql-hackers@postgresql.org; Mon, 17 Apr 2023 14:53:39 +0000 Received: by mail-io1-xd33.google.com with SMTP id z132so552103iof.3 for ; Mon, 17 Apr 2023 07:53:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20221208.gappssmtp.com; s=20221208; t=1681743213; x=1684335213; h=content-disposition:mime-version:message-id:subject:to:from:date :from:to:cc:subject:date:message-id:reply-to; bh=87O3byE1jsiTjLvAW2zCeZMcGpQjC97IVQBdqIOYG7E=; b=DKVX7uKvzVLL3p5scAnfl2INMEWrufYOnTUrsRK0wrUcZE+SnZ3IDLZVU4WN1zruNZ 1dzfbXB/YW7qoruuTB7XpKs0QuM6t5J4Ad2mkKN4VGCrJHjgtnfMDXsmAL2iPgYw9A0+ WxquUzz4lObgIHYTOEQXoxUtjo88mLc1CjRhHpdqsXKpiIS0O73xEKgk4y+v+JbrK1Lf n3OQItP3+bAzi3HaJDjpRmy6wXbwP/Den6Bo/W16R0jJVuCkV85HX+NoKBO0P2yYGo3Q lUW8yaVU20VGkJPMPX44kV030EPHqHtn46wVfUg7jj1X116StY/Bae7lJhpcPpnOh5qM E3Og== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1681743213; x=1684335213; h=content-disposition:mime-version:message-id:subject:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=87O3byE1jsiTjLvAW2zCeZMcGpQjC97IVQBdqIOYG7E=; b=ClHmPB30Zc+VuUYXoFbzHauOposOHMLZITqfzLD0cD1r/Frn+yYkSljFiGZzCwgxnx xsfXSeAvftMVKgTHESCv8Z7hoNqHvAbF425mFDeI7yQD3zMyrWvTAZJPykWSrxJKHOsX fN8oaRFLGP1U8lpd++cwBYgTf9r1eOCgme/03bJC62CWbYbev9hPGpt67GBLVnYQwHRm dpNlyFNB0v4eX432Xk58OBxRM1tOzBv829oV3mGKx+gYGC2rGfPZmv2JZkgpgiKjpmuW 9/wGQ01argWSQSZbQwNlPSimuEmpCztcWPbIxHzuZsiwU1u4GcgKwESKvXks2df2sNi+ 4F6Q== X-Gm-Message-State: AAQBX9cyuRkCNjsO6UTfezVzTCCVmB/xutnEIkRZoS5NrgxGuQhiP7Ux 1Wnn+5l1muGAbeLPf81aBpU25h/LNjUBsjy7MK0= X-Google-Smtp-Source: AKy350Ylts8TsdKq1K2p18yrKyl08Nmck4o0pgbDgflcB/lojZCMOpiuK1wfkYQqg9E7iML2ac4I0g== X-Received: by 2002:a6b:6d1a:0:b0:760:ee5e:848c with SMTP id a26-20020a6b6d1a000000b00760ee5e848cmr4381312iod.13.1681743212918; Mon, 17 Apr 2023 07:53:32 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id d134-20020a02628c000000b00408b3bc8061sm3492238jac.43.2023.04.17.07.53.32 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 17 Apr 2023 07:53:32 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 4F8FF8005DC; Mon, 17 Apr 2023 09:53:30 -0500 (CDT) Date: Mon, 17 Apr 2023 09:53:30 -0500 From: Justin Pryzby To: pgsql-hackers@postgresql.org Subject: v16dev: TRAP: failed Assert("size > SizeOfXLogRecord"), File: "xlog.c", Line: 1055, PID: 13564 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I hit this assertion while pg_restoring data into a v16 instance. postgresql16-server-16-alpha_20230417_PGDG.rhel7.x86_64 wal_level=minimal and pg_dump --single-transaction both seem to be required to hit the issue. $ /usr/pgsql-16/bin/postgres -D ./pg16test -c maintenance_work_mem=1GB -c max_wal_size=16GB -c wal_level=minimal -c max_wal_senders=0 -c port=5678 -c logging_collector=no & $ time sudo -u postgres /usr/pgsql-16/bin/pg_restore -d postgres -p 5678 --single-transaction --no-tablespace ./curtables TRAP: failed Assert("size > SizeOfXLogRecord"), File: "xlog.c", Line: 1055, PID: 13564 Core was generated by `postgres: postgres postgres [local] COMMIT '. Program terminated with signal 6, Aborted. #0 0x00007f28b8bd5387 in raise () from /lib64/libc.so.6 Missing separate debuginfos, use: debuginfo-install postgresql16-server-16-alpha_20230417_PGDG.rhel7.x86_64 (gdb) bt #0 0x00007f28b8bd5387 in raise () from /lib64/libc.so.6 #1 0x00007f28b8bd6a78 in abort () from /lib64/libc.so.6 #2 0x00000000009bc8c9 in ExceptionalCondition (conditionName=conditionName@entry=0xa373e1 "size > SizeOfXLogRecord", fileName=fileName@entry=0xa31b13 "xlog.c", lineNumber=lineNumber@entry=1055) at assert.c:66 #3 0x000000000057b049 in ReserveXLogInsertLocation (PrevPtr=0x2e3d750, EndPos=, StartPos=, size=24) at xlog.c:1055 #4 XLogInsertRecord (rdata=rdata@entry=0xf187a0 , fpw_lsn=fpw_lsn@entry=0, flags=, num_fpi=num_fpi@entry=0, topxid_included=topxid_included@entry=false) at xlog.c:844 #5 0x000000000058210c in XLogInsert (rmid=rmid@entry=0 '\000', info=info@entry=176 '\260') at xloginsert.c:510 #6 0x0000000000582b09 in log_newpage_range (rel=rel@entry=0x2e1f628, forknum=forknum@entry=FSM_FORKNUM, startblk=startblk@entry=0, endblk=endblk@entry=3, page_std=page_std@entry=false) at xloginsert.c:1317 #7 0x00000000005d02f9 in smgrDoPendingSyncs (isCommit=isCommit@entry=true, isParallelWorker=isParallelWorker@entry=false) at storage.c:837 #8 0x0000000000571637 in CommitTransaction () at xact.c:2225 #9 0x0000000000572b25 in CommitTransactionCommand () at xact.c:3201 #10 0x000000000086afc7 in finish_xact_command () at postgres.c:2782 #11 0x000000000086d7e1 in exec_simple_query (query_string=0x2dec4f8 "COMMIT") at postgres.c:1307