<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
I created an issue :<br>
<a class="moz-txt-link-freetext" href="https://github.com/qgis/QGIS/issues/47906">https://github.com/qgis/QGIS/issues/47906</a><br>
<br>
I can reproduce it with a dead simple query : select * from table
(returning ~ 800 rows).<br>
<br>
And no problem with any query/database on QGIS 3.16.16 !<br>
<br>
Thanks,<br>
<pre class="moz-signature" cols="72">--
Christophe
</pre>
<div class="moz-cite-prefix">Le 22/03/2022 à 10:41, Alexandre Neto a
écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CA+H0G_GLgVQuWp7UMAxiivOcbjB7Gh7YL1cdixgzbdSGzUHhsA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="auto">It probably also has something to do with the
query you are using.
<div dir="auto"><br>
</div>
<div dir="auto">Can you please create a ticket? Preferably with
some sample data and project and explaining the steps to
reproduce the problem.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Thanks</div>
<div dir="auto"><br>
</div>
<div dir="auto">Alexandre Neto</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">A terça, 22/03/2022, 09:24,
SIGéal via Qgis-user <<a
href="mailto:qgis-user@lists.osgeo.org"
moz-do-not-send="true" class="moz-txt-link-freetext">qgis-user@lists.osgeo.org</a>>
escreveu:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hi list,<br>
<br>
QGIS 3.22/3.24 freezes with hourglass for about 2 minutes when
I click <br>
on close button of Update SQL Layer dialog, even if I didn't
modify the <br>
query.<br>
If I click on Execute button, I get this error : "an error
occurred <br>
while opening GPKG dbname=..."<br>
This happens with a big database file (600 Mb), only with with
query <br>
returning hundreds of rows.<br>
<br>
I don't have any problem at all with old behaviour on QGIS
3.16.16 : DB <br>
Manager opened when I click on Update SQL Layer.<br>
So this sounds clearly like a regression linked to the new
"Update SQL <br>
Layer" dialog/behaviour.<br>
<br>
Thanks for any hint or work around,<br>
<br>
-- <br>
Christophe Damour<br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank"
rel="noreferrer" moz-do-not-send="true"
class="moz-txt-link-freetext">Qgis-user@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote>
</div>
</blockquote>
<br>
</body>
</html>