Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vSj1i-004MLU-1h for pgsql-general@arkaria.postgresql.org; Mon, 08 Dec 2025 21:44:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vSj1g-001nlu-2m for pgsql-general@arkaria.postgresql.org; Mon, 08 Dec 2025 21:44:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vSj1g-001nlm-1F for pgsql-general@lists.postgresql.org; Mon, 08 Dec 2025 21:44:12 +0000 Received: from mail-westeuropeazon11023142.outbound.protection.outlook.com ([52.101.72.142] helo=AM0PR02CU008.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vSj1e-003vEH-2I for pgsql-general@lists.postgresql.org; Mon, 08 Dec 2025 21:44:12 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=qPWYevQTlfQFVYcwXtHooewYeWsFJlnnZui40VCU1ht2qGBCCjnvxzjAj9jqXf82oaQmaseZI3Pc+JqPIlfZA/L9zFzgJYcGaY+hNtI8RKIVsZaQj8RR0q45UUGu53Ti05pR0AxP0jjsEU4pQ1+m4msGhPM9inpIccNGN8yRDiNbdQm3lrTU8XG1Fny9Tw6dcbFLdyUo0IGPuJxOnP0w60CSy9gIiZw6fJD/wygiff+ETpxKPSwwDiMfGvj/KXpvnzCb6cBVapbAJAepnrc2xSzOVOp7UkAgqfDLRZCmFV4EX7c4PA8CYMIN8cKGj/DPX/i3lR7A8mnLaSdmRSXKWw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=vjFaEtKpkUISfF9xULsAusripAgWSLmUtIUnqhZjPbY=; b=NwkPQwVcZBNcLcYsTjLVU3gHAGKSQJYLGLtQYTGk854LxmmbssR9/1dN0fg4+Dwh4r2VHD7V3jUfba560icfTY1YUHgv4E7dJSTxTGO+8WOXcKpsrl/a2lcBTXyF/KqhngYkOiEF+HBrBqMW8OB9sZHck1G6o3GTKurvp1Ic2KnRzt2fiGFGkV5el/ENMTLvpWO+tPGMkSO9gvRZNH3Nik03XQzO9jXfSuC8bQi9qT2HxAEnrs6Ht+HcP2xsVlvoAY8WY1bFCUCtmpdyhBZlQ6aXTmdvaGk6D+jzfHDnOQhxISWQRHehPNdCfYVlRF3KuXfGkZIxe+CSnlLpztdbbg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=zaharia.ch; dmarc=pass action=none header.from=zaharia.ch; dkim=pass header.d=zaharia.ch; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=swisstchcom.onmicrosoft.com; s=selector1-swisstchcom-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=vjFaEtKpkUISfF9xULsAusripAgWSLmUtIUnqhZjPbY=; b=glRI37fyGVcQLfMG6wkR7tiaQe+FInXd6PxGq4k7IIDmPBvFmZwfX9Ipdp/j4QVMSeknWIUNy5+Fa+69rPmQmEyFbKHwkF8lFO2De7xPVqmxw73Sv3HnembfGQ/gPa3diLLHQ9ZjoGoEShjxrgbbeHYKnrbFB+tqNgXn2MEHM98= Received: from DU2PR09MB5408.eurprd09.prod.outlook.com (2603:10a6:10:27c::21) by AM7PR09MB3575.eurprd09.prod.outlook.com (2603:10a6:20b:103::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9388.14; Mon, 8 Dec 2025 21:44:07 +0000 Received: from DU2PR09MB5408.eurprd09.prod.outlook.com ([fe80::9c5b:f8e7:9209:2df]) by DU2PR09MB5408.eurprd09.prod.outlook.com ([fe80::9c5b:f8e7:9209:2df%5]) with mapi id 15.20.9388.013; Mon, 8 Dec 2025 21:44:07 +0000 From: Tudor Zaharia To: "pgsql-general@lists.postgresql.org" Subject: Help needed debugging a storage issue Thread-Topic: Help needed debugging a storage issue Thread-Index: AQHcaIezXzRFoILYwk2DHHNrUihvkg== Date: Mon, 8 Dec 2025 21:44:07 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=zaharia.ch; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DU2PR09MB5408:EE_|AM7PR09MB3575:EE_ x-ms-office365-filtering-correlation-id: 1bc9f0e0-ec3c-4121-2c56-08de36a2ea1d x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|366016|376014|7055299006|8096899003|38070700021; x-microsoft-antispam-message-info: =?iso-8859-1?Q?l9/boJYUzpC5n93tBknYJ5NvdsYttFhfShDldewoZUll70DCbea6ISxayN?= =?iso-8859-1?Q?jy6i6jnVoXnqVhr0bv8TSHTbCBkAuzTIDxMPiWxpkShHJ5daAV89+btH92?= =?iso-8859-1?Q?vpAAtYlIbl2JLC4r7QQKpYjiRIEUytuiMk8WSxOaNTLlZhf7rVdh4H6CeH?= =?iso-8859-1?Q?03w++TuOJVcO0IogXg1oAwGMYXpQL1wmysfpD4jrWxO9xhS91ReEE7tpXd?= =?iso-8859-1?Q?PuwbO0DGixjNlK5RtUY1CQWMZWKU0kPFYw9PKllyFoYQtoPfgVip2MJV0d?= =?iso-8859-1?Q?+ezlv5tlxhGyeNcbgdFVdwlZlWJ4a9N5tOOhbQsgH7wEp5VSqxDTdRj+78?= =?iso-8859-1?Q?V6UzvF4PSz1evEYay/SpQO1YClG7iY3OrH3MsNKx5tAJw4utvWOuNYWjaV?= =?iso-8859-1?Q?RSbTIZTNHj+uI/xUpDenxcEnwutZWk6fZWiE6jwYeu47B6GRYcc38SQGQf?= =?iso-8859-1?Q?tq22hgC6Za8lIDB6CelzWt/p4VC0Ekawy68NmBCj0fh4OJLEdv6hoJJoz0?= =?iso-8859-1?Q?oXW8gZwIQR22Ps8RUldhMUhI13MQCiEf1cjOwbUoH1gAGfDmekxB9FF1eT?= =?iso-8859-1?Q?eXymsfJdZkNe/5tSB3l+/DE2MlFuuy7rIZ2lgVxk80xQeUNfh0llWzZxvR?= =?iso-8859-1?Q?9zchISuFyKWy2rNk1c4Mg+SJW4UqO/GJ/60ZD81USu5KGJbwH12hVz2uH8?= =?iso-8859-1?Q?CHE4qZBqb8YfqRpnGR0ZjvC9Hg6sx2EgMVvZpRWVJDI0pQNOLBGvgQ4x73?= =?iso-8859-1?Q?6t90aQ86U8jSnwf+TANOHvDmexhQVhCeflNKzVA8e4uxIaKoeIBRrQtKzD?= =?iso-8859-1?Q?k4mao0i2SitHO0+DJJhIEaRSbT9QsvKM11QpHL0K43DciKYVow1omnhKEw?= =?iso-8859-1?Q?U1TuQFLo+JJJWMqphRuj9PZhTcrPDuxJ9Aw4w+Tam84YyfoUK77o7v4pZg?= =?iso-8859-1?Q?Id9wafR97SliynGVXOwXzk406usHZ9JVJcDC31OWNpbHPokjpELZwqxjx7?= =?iso-8859-1?Q?Sa1/UFI4oBHbK3yxF/S243PoE6x+9eufcgCOkY8o4XdngivKh3xiKIkifh?= =?iso-8859-1?Q?Ak8jpQ6uBQjMUDS8UkEomtu9tCtJGpXnHjvR2lTSonXcUnbXKirIx7sAxr?= =?iso-8859-1?Q?dsBViOHVCP8MtrlC29nctZJzkPtxQKcf8ORRrdGjrpQriJLbK6ZxYilEhC?= =?iso-8859-1?Q?4vbxbe9Sz8kVNrhpupmNwAQ1S6dcwethe3awhsPNAlO49zsZhaRR2cpvGS?= =?iso-8859-1?Q?64dvqhtU51ljAaqObWQnzt7h883qty18oW/osBtWGF3ADf/2cC12OEwv+W?= =?iso-8859-1?Q?sYkQc+VsGWp6W7qJB/SOEccLhFZgW4SIRhRKSRrHs8U5zwZncVYpfX977w?= =?iso-8859-1?Q?Nfr4jtNn5RxWanbK/aQzxh+yTwr76PNrFbMX/KDaClQ4GjLAyHSSKTjbqg?= =?iso-8859-1?Q?irlru6c81EkGezTsxDk9r5qRpuG/TIgR20pPG6EEPJKmF5ijgk30bzzRZ1?= =?iso-8859-1?Q?3B98OzP4ek63wSPKatBD5ufVeOBiT4OICoVvUQK6HYL5j2eoHgi0uigHSJ?= =?iso-8859-1?Q?VFCiMijkn6K18NBB+qAwWPhi+KSRWULDZ/flluMfiAP0E4IQ7Q=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DU2PR09MB5408.eurprd09.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(366016)(376014)(7055299006)(8096899003)(38070700021);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?05LOx6TLjBOJ1hQ9wLnToVDzXsfHO701KvhgAjaqlY50IBVe7a5413WFAR?= =?iso-8859-1?Q?GYRmXFRecqp2RISOAJYYlt2B9uTMDERxqvmE4FI236BjRs5duPg4Eh1UAK?= =?iso-8859-1?Q?6QieZvZeqmp/mLp5eadxC4iUf5t+9jPaxvcC0Gawmpw5PpuTq/70CBRp/5?= =?iso-8859-1?Q?F9GWK8nB6vY9vSTJI0yAoEHVofE69vhiftlD9rBcJzb6xBnmQYepOKYlSZ?= =?iso-8859-1?Q?PM9SPhN3nzi7lRUbCWW0wduQNLAaVaucBLXqc7sCMtmYpxC87AVNnzq2Nt?= =?iso-8859-1?Q?i+buXjkQ2wpDIEuql/lSp+LKfJCWnJefWK6lOPbHaSQap8CzM9+NvUZnqQ?= =?iso-8859-1?Q?FSoZ16uJeAYFsW08tVAntttIbCdQt9ijclyXIdgkmCSuPG2TMFW62tjsPv?= =?iso-8859-1?Q?oxESezID53o694ogV+3B2sZtkUoWZMdDR7kfk4KaEKlXotbZem9QqQpGzU?= =?iso-8859-1?Q?12G1QVUmvFPoZW9wIVSushWH4xk5geta3xVv6kiZJmroKgizoJ6mbRfoKa?= =?iso-8859-1?Q?sRdEAnrfukD4AbytFfvuMbQS/j1sc2BYZZ9UmyFZfVue+7HbkqEwBM3FSK?= =?iso-8859-1?Q?wG0HPBexfRH58Gyh6kvK4aUmB4CJ07Iwf10n1NSE4O3TbSB/VKVFqeqLYy?= =?iso-8859-1?Q?dB3i8UZokxPS3g97LOFPWTBeTpLLLRhkpc0dgaRHGqsz4I3oZLtrZXopuI?= =?iso-8859-1?Q?sksGfmVXMoeDt1R5UZITBHbGlp16F2cj0HjvjdoBqjV05iKxmmlh/uMhvX?= =?iso-8859-1?Q?q5A5TrFef7upzQvj2p01tcbsvSDL5gLotvLanzQWdQ7ME+lrrQdEVCYiEt?= =?iso-8859-1?Q?Cb6dts0YdrIj7ebx4zUUt7GgdsmTh7MDQGQx/JIkbddv/NDV0wR6H/s63b?= =?iso-8859-1?Q?ZcRBAOK1tW1rjcHFGR+2cKMHz2t47AKpZIjmjcz84A5fTJJBIFOu7qKJEg?= =?iso-8859-1?Q?nuQ11hYEY4+0vyztS6ryu5OTsnVLJM7yTvVW1MLmOunld2UcXr1X7LGE4N?= =?iso-8859-1?Q?4Vc7iekt3HyNPLW7tNxfIZS2BKJ9ltHWI4oTis30z1dd5argB8JDIGraYz?= =?iso-8859-1?Q?jVQChGlx6412qnhsxVcDgfCrXEfvyVX75Ixe/exc6muoTwD/X3aHhgJDk0?= =?iso-8859-1?Q?TXybDi/3m66XDiOieBnt388PLDkHEClcpw1EooRMEVf4vikqDbAPB1ldBz?= =?iso-8859-1?Q?z0pqkcfHChY93/ZQUwTcx0lKE+gxUWB4Jzmv89By/gKnKLjtAECfZOoY54?= =?iso-8859-1?Q?P3LrCOSJbNpN48lrQDqOAEFBZjXDx7h5HORbemlD762N7Wk84eZtHXcq9l?= =?iso-8859-1?Q?qla1kmQgrwLculKcgsOBA3Lap/tXJot4XmxjaalknErDlWyRZBh/Zr7Pdx?= =?iso-8859-1?Q?5S3ItTDPjiI1nCPTbdMmfjR0HT9VqzMSDuaY0cpojqPLuGTp7zZ5a3WCUB?= =?iso-8859-1?Q?IJBajDftCShVO+8HjbKhxTpg0D/6FGa+JmFqkaxcDjccerC/8oVf+Jgr+N?= =?iso-8859-1?Q?G1U/ntV+CUWBnVOoXRtXpChPfGjuNX1gcmEPahHAQb+YSMSJGTogrJGlcS?= =?iso-8859-1?Q?FqHOz3xdvcPD1p+kkFW2FEfv9e0qqwY/1AJya/c22M1gNUxhEK8daRCfc4?= =?iso-8859-1?Q?Mw6y1D9H1CRbDJk7RWrsOqOVbNSF11VIcZ?= Content-Type: multipart/alternative; boundary="_000_DU2PR09MB54089FABC3436B094AE69B94CFA2ADU2PR09MB5408eurp_" MIME-Version: 1.0 X-OriginatorOrg: zaharia.ch X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DU2PR09MB5408.eurprd09.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 1bc9f0e0-ec3c-4121-2c56-08de36a2ea1d X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Dec 2025 21:44:07.3553 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a84f4386-c7e7-4eb6-b70c-5d8b3b99e079 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: nEbJamdIDVrfXN/qq8haaT9HsszlH6UXyeBxMIMDqNEl46IVAFT45mYdqju7ZhdQ86mFn/AntjouA8tzcFZ2hA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM7PR09MB3575 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DU2PR09MB54089FABC3436B094AE69B94CFA2ADU2PR09MB5408eurp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, my name is Tudor and I am one of the maintainers of PGlite - PostgreSQL= in WASM. I am doing a major refactoring of our codebase and I am a bit stu= ck in the last step of initdb. IIUC, my problem is related to the storage layer. I see this in the logs: 2025-12-08 21:38:42.741 +01 [42] WARNING: invalid page in block 0 of relat= ion base/1/1259_fsm; zeroing out page 2025-12-08 21:38:42.882 +01 [42] WARNING: invalid page in block 2 of relat= ion base/1/1259_fsm; zeroing out page 2025-12-08 21:38:42.903 +01 [42] FATAL: invalid page in block 1 of relatio= n base/1/2600 2025-12-08 21:38:42.903 +01 [42] STATEMENT: CREATE VIEW pg_stats_ext WITH = (security_barrier) AS base/1/1259_fsm is 1MB base/1/2600 is 16KB Looking through the logs ("boot" stage): DEBUG: building index "pg_toast_2600_index" on table "pg_toast_2600" seria= lly DEBUG: index "pg_toast_2600_index" can safely use deduplication ... LOG: checkpoint complete: wrote 227 buffers (1.4%); 0 WAL file(s) added, 0= removed, 0 recycled; write=3D0.003 s, sync=3D0.000 s, total=3D0.004 s; syn= c files=3D0, longest=3D0.000 s, average=3D0.000 s; distance=3D711 kB, estim= ate=3D711 kB; lsn=3D0/1B1D38, redo lsn=3D0/1B1D38 I am using PostgreSQL v17.5 (also did some test on v17.7). I would appreciate some pointers in debugging this further. PS: I have been trying various "-c" flags, which got the initialization pro= cess further, but invariably fails with 'FATAL: invalid page in block ...' = error. These are the flags I am using right now in "boot" stage: '--boot', = '-F', '-c', 'log_checkpoints=3Dtrue', '-X', '1048576', '-d', '4', '-D', '/p= glite/data', '-c', 'checkpoint_flush_after=3D1', '-c', 'fsync=3Don', '-c', = 'synchronous_commit=3Don', '-c', 'effective_io_concurrency=3D1', '-c', 'mai= ntenance_io_concurrency=3D1', '-c','backend_flush_after=3D1', '-c', 'io_com= bine_limit=3D1', '-c', 'ignore_invalid_pages=3Don', '-c', 'ignore_system_in= dexes=3Don', '-c', 'ignore_checksum_failure=3Don', '-c', 'backend_flush_aft= er=3D1' that got me to the "VACUUM FREEZE" step of the "single" stage. --_000_DU2PR09MB54089FABC3436B094AE69B94CFA2ADU2PR09MB5408eurp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi, my name is Tudor and I am one of the maintainers of PGlite - PostgreSQL= in WASM. I am doing a major refactoring of our codebase and I am a bit stu= ck in the last step of initdb. 

IIUC, my problem is related to the storage layer. I see this in the logs:&n= bsp;

2025-12-08 21:38:42.741 +01 [42] WARNING:  invalid page in block 0 of = relation base/1/1259_fsm; zeroing out page
2025-12-08 21:38:42.882 +01 [42] WARNING:  invalid page in block 2 of = relation base/1/1259_fsm; zeroing out page
2025-12-08 21:38:42.903 +01 [42] FATAL:  invalid page in block 1 of re= lation base/1/2600
2025-12-08 21:38:42.903 +01 [42] STATEMENT:  CREATE VIEW pg_stats_ext = WITH (security_barrier) AS <ommited>

base/1/1259_fsm is 1MB
base/1/2600 is 16KB

Looking through the logs ("boot" stage):

DEBUG:  building index "pg_toast_2600_index" on table "= pg_toast_2600" serially
DEBUG:  index "pg_toast_2600_index" can safely use deduplica= tion
...
LOG:  checkpoint complete: wrote 227 buffers (1.4%); 0 WAL file(s) add= ed, 0 removed, 0 recycled; write=3D0.003 s, sync=3D0.000 s, total=3D0.004 s= ; sync files=3D0, longest=3D0.000 s, average=3D0.000 s; distance=3D711 kB, = estimate=3D711 kB; lsn=3D0/1B1D38, redo lsn=3D0/1B1D38

I am using PostgreSQL v17.5 (also did some test on v17.7).

I would appreciate some pointers in debugging this further.

PS: I have been trying various "-c" flags, which got the initiali= zation process further, but invariably fails with 'FATAL: invalid page in b= lock ...' error. These are the flags I am using right now in "boot&quo= t; stage: '--boot', '-F', '-c', 'log_checkpoints=3Dtrue', '-X', '1048576', '-d', '4', '-D', '/pglite/data', '-c', 'checkpoint_flush_= after=3D1', '-c', 'fsync=3Don', '-c', 'synchronous_commit=3Don', '-c', 'eff= ective_io_concurrency=3D1', '-c', 'maintenance_io_concurrency=3D1', '-c','b= ackend_flush_after=3D1', '-c', 'io_combine_limit=3D1', '-c', 'ignore_invalid_pages=3Don', '-c', 'ignore_system_indexes=3Don', '-c= ', 'ignore_checksum_failure=3Don', '-c', 'backend_flush_after=3D1' that got= me to the "VACUUM FREEZE" step of the "single" stage.<= /div>
 
--_000_DU2PR09MB54089FABC3436B094AE69B94CFA2ADU2PR09MB5408eurp_--