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

[Alexandre Neto]

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-developer/attachments/20220322/ac052a1e/attachment.html>