[Qgis-user] QGIS freezes for minutes when updated SpatiaLite SQL Layer

[SIGéal]

I created an issue :
https://github.com/qgis/QGIS/issues/47906

I can reproduce it with a dead simple query : select * from table 
(returning ~ 800 rows).

And no problem with any query/database on QGIS 3.16.16 !

Thanks,

-- 
Christophe

Le 22/03/2022 à 10:41, Alexandre Neto a écrit :
> It probably also has something to do with the query you are using.
>
> Can you please create a ticket? Preferably with some sample data and 
> project and explaining the steps to reproduce the problem.
>
> Thanks
>
> Alexandre Neto
>
> A terça, 22/03/2022, 09:24, SIGéal via Qgis-user 
> <qgis-user at lists.osgeo.org> escreveu:
>
>     Hi list,
>
>     QGIS 3.22/3.24 freezes with hourglass for about 2 minutes when I
>     click
>     on close button of Update SQL Layer dialog, even if I didn't
>     modify the
>     query.
>     If I click on Execute button, I get this error : "an error occurred
>     while opening GPKG dbname=..."
>     This happens with a big database file (600 Mb), only with with query
>     returning hundreds of rows.
>
>     I don't have any problem at all with old behaviour on QGIS 3.16.16
>     : DB
>     Manager opened when I click on Update SQL Layer.
>     So this sounds clearly like a regression linked to the new "Update
>     SQL
>     Layer" dialog/behaviour.
>
>     Thanks for any hint or work around,
>
>     -- 
>     Christophe Damour
>
>     _______________________________________________
>     Qgis-user mailing list
>     Qgis-user at lists.osgeo.org
>     List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220322/c67775d4/attachment.html>