From nobody Mon Sep 02 16:01:08 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 4WyD5L1CKrz5Tf7q for ; Mon, 02 Sep 2024 16:01:26 +0000 (UTC) (envelope-from wolfgang@lyxys.ka.sub.org) Received: from mail.punkt.de (mail.punkt.de [217.29.41.227]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4WyD5K5Mngz4rX4; Mon, 2 Sep 2024 16:01:25 +0000 (UTC) (envelope-from wolfgang@lyxys.ka.sub.org) Authentication-Results: mx1.freebsd.org; none Received: from punkt.de (unknown [IPv6:2a00:b580:a000:b000::1000]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mail.punkt.de (Postfix) with ESMTPSA id 94F333E207; Mon, 2 Sep 2024 18:01:17 +0200 (CEST) Date: Mon, 2 Sep 2024 18:01:08 +0200 From: Wolfgang Zenker To: freebsd-ports@freebsd.org Cc: Moin Rahman Subject: Re: lang/php8X whith databases/php8X-sqlite3 and databases/sqlite3 segfaults in Quarterly Message-ID: References: <0AB6AC67-CF26-4C5E-9D04-36DE43C489C2@freebsd.org> 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 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <0AB6AC67-CF26-4C5E-9D04-36DE43C489C2@freebsd.org> Organization: private site User-Agent: Mutt/2.2.13 (2024-03-09) X-Spamd-Bar: ---- X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:16188, ipnet:217.29.32.0/20, country:DE] X-Rspamd-Queue-Id: 4WyD5K5Mngz4rX4 Am Mon, Sep 02, 2024 at 05:19:01PM +0200 schrieb Moin Rahman: >> On Sep 2, 2024, at 5:10 PM, Wolfgang Zenker wrote: >> I have a problem with using the PHP sqlite3 module in the 2024Q3 branch. >> Scripts segfault on calling >> $dbObj = new SQLite3('example.db'); >> Tested with php 8.2 and 8.3, strongly suspect the other versions have >> the problem as well. >> 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. >> The problem did not exist in the 2024Q2 branch and does not exist in >> HEAD. >> 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? >> >> Looking forward to your suggestions. > Please share the details of the exact versions of the ports. > Kind regards, > Moin Failing setup on php 8.2: - php82-8.2.20 - php82-sqlite3-8.2.20 - sqlite3-3.46.0,1 Failing setup on php 8.3: - php83-8.3.8 - php83-sqlite3-8.3.8 - sqlite3-3.46.0,1 php 8.1 and php 8.4 setups not tested yet. 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 How to reproduce: 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 2) Use a small php script sqlitetest.php query("SELECT * FROM people WHERE role = 'your uncle'"); while ($row = $results->fetchArray()) { printf("%s's %s\n", $row['name'], $row['role']); } ?> 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 = 'your uncle'; sqlite> .quit should return "Bob". 4) test php script $ php sqlitetest.php returns Segmentation fault