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 1mOIbv-0001gg-HU for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Sep 2021 11:52:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mOIbt-0006F9-GB for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Sep 2021 11:52:53 +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 1mOIbt-0006F1-6H for pgsql-hackers@lists.postgresql.org; Thu, 09 Sep 2021 11:52:53 +0000 Received: from mail.credativ.com ([2a02:158:380:2a0::5d5e:825a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mOIbq-00015K-L6 for pgsql-hackers@postgresql.org; Thu, 09 Sep 2021 11:52:52 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.credativ.com (Postfix) with ESMTP id 8A19420139; Thu, 9 Sep 2021 11:52:47 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=credativ.de; s=email; t=1631188367; bh=9ku0su0EFSf10bN7eVp8NFlN7Qf7yuTqBjpPkgr/Jwg=; h=Date:From:To:Subject:From; b=sO89Sy3rifFHp3ah6FUj3uruXyxbhotg4HCUcno8wkJyvvD85OSVU0hnDOo4U6FdC A/7eXR2ZiplmJdsYQsN9k57gPbf1lHGeaXEUGoDr+KSB1P5LREFdBoU2yDXwDbrhir a28pUharGZHfY7M+HEf2WIVinLfQgJA0UZQRMflubjct2hftSU4SbdT2p0jZtyKkSU zEGZnkCMTSKvV3pkB8OVwNhUGjTu4Ligp8Ht7EEbgpzNKKW8K6BnzB2worQVjZHOoj 61ByQyHh3MSBwoxXtHtbbDIoX+U6IsfRKHGYqoyYiKlzu45DyKiNwNe+F2LQH3b8Je ShidnmYwGTtgw== Received: from mail.credativ.com ([127.0.0.1]) by localhost (mail.credativ.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id UH3DRw1Lg6M2; Thu, 9 Sep 2021 11:52:41 +0000 (UTC) Received: from msg.credativ.de (unknown [IPv6:2003:5b:203b:100:7627:eaff:fe52:8e03]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: cbe) by mail.credativ.com (Postfix) with ESMTPSA id AA9E12001B for ; Thu, 9 Sep 2021 11:52:41 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=credativ.de; s=email; t=1631188361; bh=9ku0su0EFSf10bN7eVp8NFlN7Qf7yuTqBjpPkgr/Jwg=; h=Date:From:To:Subject:From; b=EFjtINJ5gY6Q0goQTHPBrOZUJpiM97uVjcVKz4Ae9qiLw+x+g6/z6otD6oBqVtgZJ yQIJlC92ITGID13ML/8kscugN44/ggE5Y5Fl981i8IqImmmIOhwQtsVowBHhyqb9z3 oAp0nqJOP0HLuHfMJtyptzhuvCeBCUvFQX79+6KyDDwyScfc4BJWCooxNctFIYj7D+ L5bk9rPnbnQrGViuKLWRxwUlrVaqizARAIUyi8+sHnR8iHCh2LaKUn4p32OGZZ49i/ qIQ0zaMXSKaRwSat7atKm4aeS8XSgcPkqMkJ0V4VRnigvWjUKx/QdHwv/XKyQZZvR+ LqNJ/77ypVDJA== Date: Thu, 9 Sep 2021 13:52:41 +0200 From: Christoph Berg To: PostgreSQL Hackers Subject: trap instead of error on 32 TiB table Message-ID: Mail-Followup-To: Christoph Berg , PostgreSQL Hackers MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I was wondering what happens when the 32 TiB per table limit is reached, so I faked 32767 1 GiB sparse files using dd and then tried inserting more rows. On a cassert-enabled build I got: TRAP: FailedAssertion("tagPtr->blockNum != P_NEW", File: "./build/../src/backend/storage/buffer/buf_table.c", Line: 125) On a normal build, I got: ERROR: cannot extend file "base/18635/53332" beyond 4294967295 blocks ORT: mdextend, md.c:443 Shouldn't the cassert build raise the ERROR instead as well? PostgreSQL 13.4. Christoph -- Senior Consultant, Tel.: +49 2166 9901 187 credativ GmbH, HRB Mönchengladbach 12080, USt-ID-Nummer: DE204566209 Trompeterallee 108, 41189 Mönchengladbach Geschäftsführung: Dr. Michael Meskes, Sascha Heuer, Geoff Richardson, Peter Lilley; Unser Umgang mit personenbezogenen Daten unterliegt folgenden Bestimmungen: https://www.credativ.de/datenschutz