Date: Mon, 2 Sep 2024 18:17:40 +0200 From: Moin Rahman <bofh@freebsd.org> To: Wolfgang Zenker <wolfgang@lyxys.ka.sub.org> Cc: freebsd-ports@freebsd.org Subject: Re: lang/php8X whith databases/php8X-sqlite3 and databases/sqlite3 segfaults in Quarterly Message-ID: <75DF9F9F-0804-4521-9B65-6120F2D482EA@freebsd.org> In-Reply-To: <ZtXhQ7pyGCY-LQ1n@punkt.de> References: <ZtXVgn6VXvzWkM34@punkt.de> <0AB6AC67-CF26-4C5E-9D04-36DE43C489C2@freebsd.org> <ZtXhQ7pyGCY-LQ1n@punkt.de>
next in thread | previous in thread | raw e-mail | index | archive | help
--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 =
<wolfgang@lyxys.ka.sub.org> 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 =
<wolfgang@lyxys.ka.sub.org> 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
> <?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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?75DF9F9F-0804-4521-9B65-6120F2D482EA>