From nobody Mon Sep 02 16:17:40 2024 X-Original-To: freebsd-ports@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4WyDSK1bBJz5Tg75 for ; Mon, 02 Sep 2024 16:17:53 +0000 (UTC) (envelope-from bofh@freebsd.org) Received: from smtp.freebsd.org (smtp.freebsd.org [IPv6:2610:1c1:1:606c::24b:4]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "smtp.freebsd.org", Issuer "R10" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4WyDSJ6yFgz4sp5; Mon, 2 Sep 2024 16:17:52 +0000 (UTC) (envelope-from bofh@freebsd.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1725293873; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=v3hZtaE8C8c3NPgR4n/kvveQT1SQJ48zWd4yc+sAVsE=; b=Sx+3siUokPmyXMcHQ4AtArIyojPKvSYTgHCRLVxOgPi2QX0Z4GERvBR9Lz2XlR2J+Sxl81 bwK6iN9kpRsv5VeOqm2eVE5PUAJtGPDKBpykb3qK5Juz6AUbDP5a5+n5ieggtfSA/6wJ+P fj1Dzb0DSrNbvQfvpp6p2vXdC+hfFjRNBLOgAh6nWICih7VQ2HVP75uSL5St1JVfYQnFXN mxl6hidJFIeQIddKhaZGZnVpd/VUh3tSI0KFu/MLZcXJ9/HPVZZawnSv3Km8yor0dyXPuN nB9wuP0oqGnhZAdo7wQT3xNWmTcE4h3FgdfX/esITfrLJTOnVtF5it9jwAZbTg== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1725293873; a=rsa-sha256; cv=none; b=YMe3qpspk5JCVNhsNGefIbzQovzYkPbuI2r7xY1jFj9PCr03vFMIwjVzwWVHCkbuYLNRH1 R6ygVQssxfl6eiI1Su/M779DZ1iqJsdmIYhKwKpkAGxVgGmd7mdskprUS7+iJ0iW1JnMT+ VmiclNBj3PUl4vpa7Yg6RWK5/zYtnsnmUnxpgdlHqS/xfsmEq4ZkX1eW9k+e42EuJtELhP QGisyeiaqKnUTaa/eKZteJHae1y39AdbAkkHLeWb0Umd3xlMDy3wSePplOOTqEA9Z2n7nC R9Kjn1dNKANJNhXFq4A8KCRQXbV0qHidz2tbbSEML8TvfJA3/3b/V0kP21DDtw== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1725293873; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=v3hZtaE8C8c3NPgR4n/kvveQT1SQJ48zWd4yc+sAVsE=; b=O/ALRTwy+EZTAzaWvI8WK5pnjZX0D6fYkpWN0bcHmPpwSacHtqbNaWfHAHm4sbZ9oGvSCA dXrNPrg3xmRvZsWn6MpOd55AySCAaCH9YUe8XcTLJPSQCOLtjBstKFZ744O/1PY9khRFin LWQgH+/q0VXiAIRTX9yfiwSUXiMrIBnboxjjkOTyE+6oFAiRPTHJfWoQgx/ail0ZXBbimz izWOtPKxLS+DerIJui0a05qqkQiM+vi0xZngfUgmZIjoqkAax1XcT/dgro17lMBwc2iYE7 UYsQd29VqzODqUxFvDoyZqYKOg0gdT5/56oiXGAtXKNbB9SsN/uum1seYwM70A== Received: from mx.bofh.network (mx.bofh.network [5.9.249.227]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) (Authenticated sender: bofh/mail) by smtp.freebsd.org (Postfix) with ESMTPSA id 4WyDSJ41BtzRdM; Mon, 2 Sep 2024 16:17:52 +0000 (UTC) (envelope-from bofh@freebsd.org) Received: from smtpclient.apple ( [217.117.226.147]) by mx.bofh.network (OpenSMTPD) with ESMTPSA id 2ffae9c8 (TLSv1.2:ECDHE-ECDSA-AES256-GCM-SHA384:256:NO); Mon, 2 Sep 2024 16:17:51 +0000 (UTC) Content-Type: multipart/signed; boundary="Apple-Mail=_694FF603-5F0F-4E2E-9FFD-1C63F6156BF0"; protocol="application/pgp-signature"; micalg=pgp-sha512 List-Id: Porting software to FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-ports List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-ports@freebsd.org Sender: owner-freebsd-ports@FreeBSD.org Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.700.6.1.2\)) Subject: Re: lang/php8X whith databases/php8X-sqlite3 and databases/sqlite3 segfaults in Quarterly From: Moin Rahman In-Reply-To: Date: Mon, 2 Sep 2024 18:17:40 +0200 Cc: freebsd-ports@freebsd.org Message-Id: <75DF9F9F-0804-4521-9B65-6120F2D482EA@freebsd.org> References: <0AB6AC67-CF26-4C5E-9D04-36DE43C489C2@freebsd.org> To: Wolfgang Zenker X-Mailer: Apple Mail (2.3731.700.6.1.2) --Apple-Mail=_694FF603-5F0F-4E2E-9FFD-1C63F6156BF0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii > On Sep 2, 2024, at 6:01 PM, Wolfgang Zenker = wrote: >=20 > Am Mon, Sep 02, 2024 at 05:19:01PM +0200 schrieb Moin Rahman: >>> On Sep 2, 2024, at 5:10 PM, Wolfgang Zenker = wrote: >=20 >>> I have a problem with using the PHP sqlite3 module in the 2024Q3 = branch. >>> Scripts segfault on calling >>> $dbObj =3D new SQLite3('example.db'); >>> Tested with php 8.2 and 8.3, strongly suspect the other versions = have >>> the problem as well. >=20 >>> For which port(s) should I open a problem report here? The culprit = could >>> be either the php-port, the php-sqlite3 subport or the sqlite3 port. >>> I built a small test environment and the sqlite3 cli tool works ok, >>> and I don't see much changes in the php-sqlite3 subports, so I = suspect >>> the problematic part is in the php ports. >=20 >>> The problem did not exist in the 2024Q2 branch and does not exist in >>> HEAD. >=20 >>> Does it make sense to open problem reports on the quarterly branch = at >>> all or should I ask the maintainers to MFH the php and sqlite3 = ports? >>>=20 >>> Looking forward to your suggestions. >=20 >> Please share the details of the exact versions of the ports. >=20 >> Kind regards, >> Moin >=20 > Failing setup on php 8.2: > - php82-8.2.20 > - php82-sqlite3-8.2.20 > - sqlite3-3.46.0,1 >=20 > Failing setup on php 8.3: > - php83-8.3.8 > - php83-sqlite3-8.3.8 > - sqlite3-3.46.0,1 >=20 > php 8.1 and php 8.4 setups not tested yet. >=20 > Working versions from 2024Q2 branch: > - php82.8.2.18 / php83-8.3.6 > - php82-sqlite3-8.2.18 / php83-sqlite3-8.3.6 > - sqlite3-3.45.1,1 >=20 > How to reproduce: >=20 > 1) Build a small test-database > $ sqlite3 example.db > SQLite version 3.46.0 2024-05-23 13:25:27 > Enter ".help" for usage hints. > sqlite> create table people(name text, role text); > sqlite> insert into people values('Alice', 'restaurant'); > sqlite> insert into people VALUES ('Bob', 'your uncle'); > sqlite> .quit >=20 > 2) Use a small php script sqlitetest.php > =20 > $dbObj =3D new SQLite3('example.db'); > $results =3D $dbObj->query("SELECT * FROM people WHERE role =3D 'your = uncle'"); >=20 > while ($row =3D $results->fetchArray()) { > printf("%s's %s\n", $row['name'], $row['role']); > } > ?> >=20 > 3) verify database works with sqlite3 cli > $ sqlite3 example.db > SQLite version 3.46.0 2024-05-23 13:25:27 > Enter ".help" for usage hints. > sqlite> select name from people where role =3D 'your uncle'; > sqlite> .quit >=20 > should return "Bob". >=20 > 4) test php script > $ php sqlitetest.php >=20 > returns Segmentation fault >=20 >=20 Hi, You said that it works on HEAD. I can merge the latest PHP into the quarterly branch. But unfortunately I cannot merge sqlite3. Current sqlite3 version in HEAD is 3.46.1. I will merge the latest php into quarterly sometimes tomorrow. Kind regards, Moin --Apple-Mail=_694FF603-5F0F-4E2E-9FFD-1C63F6156BF0 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP -----BEGIN PGP SIGNATURE----- iQKTBAEBCgB9FiEETfdREoUGjQZKBS+fvbm1phfAvJEFAmbV5SRfFIAAAAAALgAo aXNzdWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldDRE Rjc1MTEyODUwNjhEMDY0QTA1MkY5RkJEQjlCNUE2MTdDMEJDOTEACgkQvbm1phfA vJF8oQ//fsskVnyTqqoycUDFgGb5oKmE8QYk8ZXWPpEW/Ml3itScsqYFPULr4Qwb aA0o2kRCwCYbB4IEDqIuqxFqu0vLuaLsP84EMiG6s8xo+7Azk9wc9QjFWh1958CY 1U8rcK6499ZjmBtqKDzey80ARUBLUyUhZ+CgZlYY240OzCrU2WohmjqULdkSp7is DaCM8Apa7Ay7cMDcIbpB8/S0S2bL7Ee9ouD4qXk1G5HjcTqYhVyTeD3+xOyWZRcf EmnzQacYCgWLFdD2VSXdOmoO62UNoV98toSMfh2g3oTXOLhbL0Vcjk3LF9yQg5HZ stwNftBPRVcAKjzxNV7rglPpPBhrKUy4AFiJXdM7+kpgClWHsIldCy5iNOUZdEUp l7j/gByl16zsz8SoFt5i+qhZP33qWtqPmuWYuDkNApGjGJIMxiJDygtxjiBwkOvY B4KDIwCVlagZ+XlUwOPwwRWIsfk8cq97E38Q2OAM7qiVMiedUtq54xXCRYNmKplo 1n8V99RKUIo25MWQw22ZyQSX2M7v3nfL/AZ3E1nSRW7VUJXz7RO6MNPNC7mKSSNC xOVqkEl6JkORy3kaVlWu0B8cQpj2t6GmAtXWB3+FlCnEWFBLTBxVGMtbGCzvfOYL 4Cc5LsXohZmd24Z2nxcl446MMoVvOjmVMAD7+XVTUhbN4OCKUtk= =rYGi -----END PGP SIGNATURE----- --Apple-Mail=_694FF603-5F0F-4E2E-9FFD-1C63F6156BF0--