[From nobody Sat Jun 6 19:31:10 2026 Received: (at 1139157-done) by bugs.debian.org; 6 Jun 2026 18:28:42 +0000 X-Spam-Checker-Version: SpamAssassin 4.0.1-bugs.debian.org_2005_01_02 (2024-03-25) on buxtehude.debian.org X-Spam-Level: X-Spam-Status: No, score=-21.9 required=4.0 tests=BAYES_00, BODY_INCLUDES_CONTROL,BODY_INCLUDES_CONTROL_TAGS,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,FOURLA,HAS_BUG_NUMBER, RCVD_IN_DNSWL_LOW,SPF_HELO_PASS,SPF_PASS autolearn=ham autolearn_force=no version=4.0.1-bugs.debian.org_2005_01_02 X-Spam-Bayes: score:0.0000 Tokens: new, 32; hammy, 150; neutral, 105; spammy, 0. spammytokens: hammytokens:0.000-+--trixie, 0.000-+--H*F:U*sebastic, 0.000-+--Trixie, 0.000-+--H*rp:U*sebastic, 0.000-+--H*Ad:U*sebastic Return-path: <sebastic@xs4all.nl> Received: from ewsoutbound.kpnmail.nl ([195.121.94.186]:15580) by buxtehude.debian.org with esmtps (TLS1.3:ECDHE_X25519__RSA_PSS_RSAE_SHA256__AES_256_GCM:256) (Exim 4.96) (envelope-from <sebastic@xs4all.nl>) id 1wVvlC-004CxB-09 for 1139157-done@bugs.debian.org; Sat, 06 Jun 2026 18:28:42 +0000 X-KPN-MessageId: 88c2aa57-61d5-11f1-89f2-00505699b430 Received: from smtp.kpnmail.nl (unknown [10.31.155.8]) by ewsoutbound.so.kpn.org (Halon) with ESMTPS id 88c2aa57-61d5-11f1-89f2-00505699b430; Sat, 06 Jun 2026 20:28:37 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=xs4all.nl; s=xs4all01; h=content-type:from:to:subject:mime-version:date:message-id; bh=cFaR3tU5Hu1pp1eOVpPxbf9A9JpE1qzdFYYCDHbDyqA=; b=sj6nR/fsYQPYoXF+AmDhRQuBcCIxG3AhHl/LryYh1hGzX0CMu80JDjzTm29Ac3+lXtqpcMBi9ynnu z8jA08TMhd0/hJb/biu2h02RgqT9vfaaihLEY6eTnqomMSBt4Siz0KOFonnjpn8/V7/Hzce9Jpf3+N SqZCqzxxFCXLyFYIyBzDsQY3pe7ZQPdjyP2faN8gYoPMR5GGqRe/n8DwILYfYgjNZXzgFBm1RoU/TW PhNnlq07Xtnqb4IevUZg4R1ly6V4dx7P2jxTM4g9oMgas5JUg3KU/aQoeuMQMPoNBSHH4t23PXcezo Va3kCqMUtvvMXbN0QjFfKSW9tK1CImg== X-KPN-MID: 33|gytqC0D17fU6p0ybSX90JtutgBpmOoxmnurbBvMEqd2NFPUAycCOGB8NwWCBKDQ N3GZkyk4LmE78kB2fa1d0qA== X-KPN-VerifiedSender: Yes X-CMASSUN: 33|ELCnGFSDErIE84YXqGRqpxaBKijNlDtXMmkmLPFOUTMr0WV5L5bGkAAwhDsbtpK Nxegl/HRFbDyQ/8V4YPwS1A== X-Originating-IP: 77.172.224.45 Received: from [10.0.0.150] (77-172-224-45.fixed.kpn.net [77.172.224.45]) by smtp.xs4all.nl (Halon) with ESMTPSA id 889a2543-61d5-11f1-9c0c-00505699d6e5; Sat, 06 Jun 2026 20:28:37 +0200 (CEST) Message-ID: <661226da-87e8-4557-b1e2-6ad47217a578@xs4all.nl> Date: Sat, 6 Jun 2026 20:28:37 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Bug#1139157: Bug: postgis: Null-byte (\x00) in postgis--3.5.2.sql causes CREATE EXTENSION to fail To: Roland Wagner <w@gner.org>, 1139157-done@bugs.debian.org References: <01a301dcf5dd$4c0ead00$e42c0700$@gner.org> Content-Language: en-US From: Sebastiaan Couwenberg <sebastic@xs4all.nl> Autocrypt: addr=sebastic@xs4all.nl; keydata= xsFNBFCIBxoBEADb2bBkp1eEV8wKQJJ8/j7Fd2LdFz9kmhPVsZG9Igtoow7sDIvu9PBsr4u0 rKV4LjId562nXIbzXX2+YZ3Dbj0Cg4z9PLoYbENuRvcEWwyfhWyz9vNpusarUc7H+Xvym5LP iDzKgNyXVjCrhrHTd0w09S6/zrLOXtcQs91QTvT0+pdFPaUdpNPZpInMJmZeAsh4Sh6OuPEy Mtc5PhcAt/HcJ/jVBY7F7ENtfpH1c4rEMeV3VoU0W/i6rXUY3mtWCFW8hP+ULiBt2Ct2dvwF XF2I+g+jCiQ8Y8BD2u6jiCy0y/gseC2fIyafIpBs0Grv0Qs/Rir80ieVL5A8VnY5e1ZhYsv6 4+dNZ7QZtYHnoZlXofNQ75qcTZvI7Sv4lL/vpwWfaDTUzGPfU6Zn1R7fyOJTMaV+GvBN+SMB 3ZUUloiPhmg6NkOTdOPleajCQNaL5Z8KFaMUH7zCi8ZLT7TNJ26ky7rWUsJpdAGVGXae+tt2 vEsTDYTkaDQ7sYKVvGU21FagVMoVuYDsjhbZE+QbOXjsJSlQ/1oKESfy0kolrgYXHJMFIFFf MMO3toVLNSMwYVXGD9UZPFIEHXpOFP5Qcjh/ICu4szbGtXRlnS47Dc0jCxVVQyTWtTzo3oHV lwz9vAcnCI/OAODU0AwVPV0mWWpTUoFVc9uxMErBVj4PFqtKcQARAQABzSpTZWJhc3RpYWFu IENvdXdlbmJlcmcgPHNlYmFzdGljQHhzNGFsbC5ubD7CwZcEEwEKAEECGwMFCwkIBwMFFQoJ CAsFFgIDAQACHgECF4ACGQEWIQSBgt5BcFZAjWFGUNFnUPEK6I1K8QUCYEWozQUJIomkswAK CRBnUPEK6I1K8QReEAC+HcQuEe/e0GRw3NFDrLMP1ZOV596ef0b4Z9718Q595HKU1tInmTdd 4tmnJ0hiE20g4HNW/8gXMnr7yf/1RSzIicDasgni+MeVlI4o6ts5zrf3gWGhzWIcCKgim/nA ReuYnNWkeCIk4yH5QIpCt8McaPG3hLsFMU3X4y3ct6E/ZXnML6ALUrearOtss7mmzJot+jja XsGmL4T90ni2SvWoeQG5BgZ/+rfmq/l3C6bbLBLX34+yMKUFOpck3HAVMWUlY91b2DSGGWw5 6iAoAsG6w4UFjnaOfWdrtBg8VKQY5hVpRmS4SoSOWoMnf+et+h0fgXTSVWCA6eiU3MKR0heP A4kfXn/Md5a+pNJVI1I71DgIjds16srTGs6Hd7+WunA4r8gKwOkJjBJ7OCF3nc9qJrfSrQsa wgSvnT6w+VK3j8+KMpOBIoRQKsbioYY1fEvNfzUrnJLc6gfJHiLbKbT3gfIJh6BSaxWgI4I8 3aU1LsXi/XIfeAUtOOoNqc80QSESmsi5qtHh+yJOWvrW+SNnrWP+dUkuuqSw4jD1plIWJZ/n Yi+z+bXEpcHCeasFbC+M1nj7+r8zdHQXo4Rot5D9hhhqVQAkRJ71HnW+/vhCLPBWEE2+jDEP kiA92AoYPlCYpIbcPIYD8yO2t1rZdde+6Ume4VUGh2Mbvcnb3nkiEM7BTQRQiAcaARAA1nKS E2Za3UDDiXwVvkwIrb5G5aHoHhw5IVXrw8JVvjQ7bUQkwatgarua16QgCMOvsoFWXwdwE5Ix HzBiHnZZq8j6/W1h2PG4nFms092fLB0C1VeGPScgaDqZGBtWThzY9tTsuQgyHfYagkbxX2kA cocGVxzUYuL3Z1GNDMTUBqDKg5RRKr2Lml0GF4F7zbJBjkEFstehIcDutBm5mQ4BABdMTOLi BfIDIUTj+PN94gfgkCoORJrjgUChYqnt+oUXqOSU5Xz2N5SyY1Gst6o02lZT871pDVuXGBWo jHQKke+W+LqVVaNAbXVX3PqW+0D4EOABFgxiUTNqeBqR73fWNmn2c8gQr19CHuCaLrE55ZGn gR78aGK/JyCEKQQoqLKIP3f2ctcSiP6rQvs97q8uq9DIDfMGY3FXwNAwrMGt0NdXPnv6d1Qo amfz90W7BrBhHUnPq/Eh/vQa9lGTJpAmcVSHhbcPYwi3kq1/MdIMHxJayx5BYOzgWWrHKdDG 70LNhT9RAl9O79Es9PX9WXYDeUXP6JKA4sB9FrtcZ8TrfxGsSwo+9M2NN2raPlv+9wHholdd zheYXZDpEzm6EHKyZj+4UzUtA9b8mtwUDgUt/UT6SNe9zFlPhZYsaPU5ZqcVH27nbFYPqQtf SkT4ixsQreAZQqhI7nix51Z6bUAq0F0AEQEAAcLBfAQYAQoAJgIbDBYhBIGC3kFwVkCNYUZQ 0WdQ8QrojUrxBQJgRar4BQkiiabeAAoJEGdQ8QrojUrxskMP/2Xk8YIEt8JjZffk0HMAWjGd 4FBSsfUv/E5EUBOFu7F2CmcGsgHk9m7RPTf51UacHnct0jhd5o6qSGF6nHS+aFjuxBHp0fWY kqrrCgIMJzB0UkQfy4xAMU/Yr5BnNqale363pigZMqOr1p/xw2gMPe89VieBgC/h5gZ4gP8y 32nUxqX3zaeQg4qQrfTD8nkOzC4kNncRNU5i8paOxrKww9pyvg0uEaZlDZXD34iAVeXY7l+D PlW+u8fXaLhuPAVEiLLLi4lNM07tQKRjxVQlhIx5UKJZhI++snVXnrtvjEk8BNUYATTlVVFy 96ZLqiH3bsMpbvBQcN4/KlolF3IoRxgQ8m4/O30HFLLFTOkdP/yaUGirP7gYxz6LuNcXJNIN cjGG4agSwjJ/4OUtYDUNHBXReQN6IJfWzhKWtMZ2mE2Xix1i41xhUE+sDu6yJ6X8V+NW1j+0 MpUCUbOoC+aB9b4cdGZLr5sAQJEFpW+Gn0X0Aq4zbQQXxT99iNmfR9e8y8Fm0e81v+qUM3f2 +eDWbll9NZJBHJW5PjRBS5rY5UsVWCwxrGkWUtrGuUW20XznQXcWI4NEUzoxj+URRD6qCrHM BeaTDMa+9IAvk3/HPlmz/Or03KIPreUCV3XVdelk9BcdDLAEJu8db0vyQDr7EGn+6rjFfnq0 /KnfM3VBUDvL In-Reply-To: <01a301dcf5dd$4c0ead00$e42c0700$@gner.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Control: tags -1 unreproducible On 6/6/26 7:52 PM, Roland Wagner wrote: > When trying to enable the PostGIS extension on a fresh PostgreSQL 17 > installation running on Debian Trixie (arm64 / Raspberry Pi 5), the database > throws the following error: > > ERROR: invalid byte sequence for encoding "UTF8": 0x00 > > We tracked this down to a physical null-byte (\x00) inside the SQL extension > script provided by the package. > > File: /usr/share/postgresql/17/extension/postgis--3.5.2.sql > > Location: Inside the definition string for EPSG 8796 (around the string > "AUTHORITY["EPSG","42") This file is provided by postgresql-17-postgis-3-scripts which works as expected on amd64, and because it's an arch:all package it's the same on all other architectures. > Running the following command confirms the physical presence of the > null-byte in the file: > > grep -Pa '\x00' /usr/share/postgresql/17/extension/postgis--3.5.2.sql Unreproducible with the package from the archive as retrieved by debsnap: $ grep -nPa '\x00' binary-postgresql-17-postgis-3-scripts/postgresql-17-postgis-3-scripts_3.5.2+dfsg-1_all/usr/share/postgresql/17/extension/postgis--3.5.2.sql $ > Workaround: > > Removing the null-byte with 'tr -d "\000"' and manually fixing the resulting > unterminated string/syntax errors at the end of the file allowed the > extension to load successfully. > > It seems there was a compilation or packaging error when building this > specific version for arm64. > > Best regards, > > Roland Wagner > > Gemini helped me, its really a great tool. Many thanks also to you, because > you maintain also a great tool! Since you have a solution to your problem, there is nothing for the package maintainer to do. Kind Regards, Bas -- PGP Key ID: 4096R/6750F10AE88D4AF1 Fingerprint: 8182 DE41 7056 408D 6146 50D1 6750 F10A E88D 4AF1]