Re: [QGIS-Developer] DB-manager and large query results (for time manager)
On 25-08-2020 10:27, Giovanni Manghi wrote: Hi Raymond, There's a question on a Dutch geo forum about a join query in DB-Manager that does not return data, but an error without message instead. PG Admin runs the query with he expected results, so it seems ok. I have seen this type of problem in the past, but now I can't recall the exact details of my use case, can you post somewhere the data and the query?. More recently there was a similar issue, DB Manager running a query and returning 0 results, while actually the query returned more than that, but I think this is fixed. Recently seems also that DB Manager is very slow running queries that on other programs (i.e. pgadmin or dbeaver) take much less time. cheers! -- G -- ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer Hi Giovanni, Thanks for your reply. The queries and data can be found in the tread and I added the link. But as this is all in Dutch it might be hard for you to figure it out. The data sources are these: https://geodata.rivm.nl/covid-19/COVID-19_aantallen_gemeente_cumulatief.csv3 https://geodata.nationaalgeoregister.nl/wijkenbuurten2019/wfs?service=WFS2 (layer: gemeenten2019) and the query: select c.*, g.geom, g.inwoners from covid19 as c join gemeenten_bewerkt as g on c.municipality_code=g.code; I'm not used to the DB-manager as I prefer writing queries in DBeaver for creating new tables or views. When they seem right I open them in QGIS. DB-manager always feels a bit like a black box in between the DB and QGIS. Raymond ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] DB-manager and large query results (for time manager)
Hi Raymond, > There's a question on a Dutch geo forum about a join query in DB-Manager > that does not return data, but an error without message instead. PG > Admin runs the query with he expected results, so it seems ok. I have seen this type of problem in the past, but now I can't recall the exact details of my use case, can you post somewhere the data and the query?. More recently there was a similar issue, DB Manager running a query and returning 0 results, while actually the query returned more than that, but I think this is fixed. Recently seems also that DB Manager is very slow running queries that on other programs (i.e. pgadmin or dbeaver) take much less time. cheers! -- G -- ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] Travis failing in QGIS-Documentation
Hi Denis, thanks for the update and for the fix. Will restart the checks during the afternoon when the fix is pushed Cheers Matteo ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] Travis failing in QGIS-Documentation
Denis, Thanks for all the work improving and fixing this. Math On Tue, Aug 25, 2020 at 3:12 PM Denis Rouzaud wrote: > Hi, > > Sorry, I am somehow responsible for the failure of the recent Docker > images on master (release branches were apparently not affected). > > The images were apparently not updated for a bit (which I didn't notice). > I moved the Docker images creation from Travis to Github actions, and due > to a missing check in the job, the image was pushed without QGIS built in > it. > There was apparently a new way of defining where the Qt 3D extras headers > are located: > > https://github.com/qgis/QGIS/commit/46acc34e6a8263218c5c494096f3182a05c704e7#diff-6987645362d6f81263fd0a8623dacbb9R52 > > This is now fixed, the image is currently building > https://github.com/qgis/QGIS/runs/1025298753?check_suite_focus=true > If no stupid error is present further in the job, it should be pushed > still this morning. > > Sorry for the mess. > > Denis > > > Le mar. 25 août 2020 à 09:53, matteo a écrit : > >> Hi all, >> >> sorry for cross posting and sorry if I missed some existing discussion >> on this topic. >> >> I don't think anybody introduced some strange commit but it seems that >> the Travis check is always failing even with PR that don't code snippet >> at all. >> >> The error seems related directly with the environment: >> >> https://travis-ci.org/github/qgis/QGIS-Documentation/builds/720902932#L694 >> >> >> Exception raised: >> >> Traceback (most recent call last): >> >> File "/usr/lib/python3.8/doctest.py", line 1329, in __run >> >> exec(compile(example.source, filename, "single", >> >> File "", line 22, in >> >> from qgis.testing import start_app >> >> ModuleNotFoundError: No module named 'qgis' >> >> >> >> >> Any Travis guru out here? :) >> >> Cheers and thanks >> >> Matteo >> ___ >> QGIS-Developer mailing list >> QGIS-Developer@lists.osgeo.org >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer > > ___ > QGIS-Developer mailing list > QGIS-Developer@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] Travis failing in QGIS-Documentation
Hi, Sorry, I am somehow responsible for the failure of the recent Docker images on master (release branches were apparently not affected). The images were apparently not updated for a bit (which I didn't notice). I moved the Docker images creation from Travis to Github actions, and due to a missing check in the job, the image was pushed without QGIS built in it. There was apparently a new way of defining where the Qt 3D extras headers are located: https://github.com/qgis/QGIS/commit/46acc34e6a8263218c5c494096f3182a05c704e7#diff-6987645362d6f81263fd0a8623dacbb9R52 This is now fixed, the image is currently building https://github.com/qgis/QGIS/runs/1025298753?check_suite_focus=true If no stupid error is present further in the job, it should be pushed still this morning. Sorry for the mess. Denis Le mar. 25 août 2020 à 09:53, matteo a écrit : > Hi all, > > sorry for cross posting and sorry if I missed some existing discussion > on this topic. > > I don't think anybody introduced some strange commit but it seems that > the Travis check is always failing even with PR that don't code snippet > at all. > > The error seems related directly with the environment: > > https://travis-ci.org/github/qgis/QGIS-Documentation/builds/720902932#L694 > > > Exception raised: > > Traceback (most recent call last): > > File "/usr/lib/python3.8/doctest.py", line 1329, in __run > > exec(compile(example.source, filename, "single", > > File "", line 22, in > > from qgis.testing import start_app > > ModuleNotFoundError: No module named 'qgis' > > > > > Any Travis guru out here? :) > > Cheers and thanks > > Matteo > ___ > QGIS-Developer mailing list > QGIS-Developer@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
[QGIS-Developer] Travis failing in QGIS-Documentation
Hi all, sorry for cross posting and sorry if I missed some existing discussion on this topic. I don't think anybody introduced some strange commit but it seems that the Travis check is always failing even with PR that don't code snippet at all. The error seems related directly with the environment: https://travis-ci.org/github/qgis/QGIS-Documentation/builds/720902932#L694 Exception raised: Traceback (most recent call last): File "/usr/lib/python3.8/doctest.py", line 1329, in __run exec(compile(example.source, filename, "single", File "", line 22, in from qgis.testing import start_app ModuleNotFoundError: No module named 'qgis' Any Travis guru out here? :) Cheers and thanks Matteo ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer