Re: lang/php8X whith databases/php8X-sqlite3 and databases/sqlite3 segfaults in Quarterly

> On Sep 2, 2024, at 6:01 PM, Wolfgang Zenker <wolfgang@lyxys.ka.sub.org> wrote:
> 
> 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:
> 
>>> 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
> <?php
> 
> $dbObj = new SQLite3('example.db');
> $results = $dbObj->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
> 
> 

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