Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Processing: confusion when listing inputs from "virtual layers" #47159

Closed
2 tasks
mcingotti opened this issue Feb 2, 2022 · 11 comments · Fixed by #49016
Closed
2 tasks

Processing: confusion when listing inputs from "virtual layers" #47159

mcingotti opened this issue Feb 2, 2022 · 11 comments · Fixed by #49016
Assignees
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Processing Relating to QGIS Processing framework or individual Processing algorithms

Comments

@mcingotti
Copy link

What is the bug or the crash?

Running some processing algorithms within a project with numerous layers contained in a geopackage, I noticed that the same layers appeared many times in the form input layer.
After going through some steps I remembered having looked at the preview of the layers inside the db manager. From there I did some tests and I saw that once the preview of the table was created, a virtual layer was automatically created within the project layers, inside db manager.
By saving the project these layers are saved, generating a redundancy of layers that makes it difficult to manage during processing operations.
Furthemore is not possible to delete these virtual layers.

Steps to reproduce the issue

I gave it a try by creating a new project from scratch, so i loaded the layers connected the geopackage in the db manager and checked the virtual layers in the project layers

Screenshot (11)

I tried to launch a geoprocessing tool and only the layers present in the panel appeared

Screenshot (10)

I activated a preview of the table in the db manager and the virtual layer appeared
Screenshot (12)
Screenshot (13)

relaunching
Screenshot (14)
the geoprocessing tool the layer appears duplicated

Versions

QGIS version
3.16.8-Hannover
QGIS code revision
8c50902
Compiled against Qt
5.11.2
Running against Qt
5.11.2
Compiled against GDAL/OGR
3.1.4
Running against GDAL/OGR
3.1.4
Compiled against GEOS
3.8.1-CAPI-1.13.3
Running against GEOS
3.8.1-CAPI-1.13.3
Compiled against SQLite
3.29.0
Running against SQLite
3.29.0
PostgreSQL Client Version
11.5
SpatiaLite Version
4.3.0
QWT Version
6.1.3
QScintilla2 Version
2.10.8
Compiled against PROJ
6.3.2
Running against PROJ
Rel. 6.3.2, May 1st, 2020
OS Version
Windows 10 (10.0)
Active python plugins
DataPlotly;
DEMto3D;
GroupStats;
mmqgis;
Multi_Ring_Buffer;
pointsamplingtool;
qfieldsync;
quick_map_services;
shapetools;
SwapVectorDirection;
TerrainShading;
db_manager;
MetaSearch;
processing

Supported QGIS version

  • I'm running a supported QGIS version according to the roadmap.

New profile

  • I tried with a new QGIS profile

Additional context

No response

@mcingotti mcingotti added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Feb 2, 2022
@nicogodet
Copy link
Member

3.16.8 is a bit old and 3.16 is EOL.
Can you upgrade to 3.22.3 ?

@gioman gioman added the Feedback Waiting on the submitter for answers label Feb 3, 2022
@gioman
Copy link
Contributor

gioman commented Feb 3, 2022

Can you upgrade to 3.22.3 ?

@mcingotti and also try on a new QGIS profile.

@mcingotti
Copy link
Author

Can you upgrade to 3.22.3 ?

@mcingotti and also try on a new QGIS profile.

This bug has been solved in the 3.22.3?

With a new QGIS profile, same result

Screenshot (17)

@gioman
Copy link
Contributor

gioman commented Feb 3, 2022

This bug has been solved in the 3.22.3?

@mcingotti we need you to test on 3.22.3, there is no point at the moment to report anything about 3.16 as it won't get any new release (and no new bug fix).

@gioman
Copy link
Contributor

gioman commented Feb 3, 2022

@mcingotti never mind, I tested and confirm the issue.

@gioman
Copy link
Contributor

gioman commented Feb 3, 2022

Not sure anyway if this a DB manager or Processing issue. Seems more the latter to me.

@gioman gioman changed the title db manager preview creates virtual duplicated layers Processing: confusion when listing inputs from "virtual layers" Feb 3, 2022
@gioman gioman added Processing Relating to QGIS Processing framework or individual Processing algorithms and removed Feedback Waiting on the submitter for answers labels Feb 3, 2022
@mcingotti
Copy link
Author

Not sure anyway if this a DB manager or Processing issue. Seems more the latter to me.

Yes but the layer duplication appears after using db manager preview

@gioman
Copy link
Contributor

gioman commented Feb 3, 2022

Yes but the layer duplication appears after using db manager preview

@mcingotti but db manager does the right thing, give the duplicated virtual layer a different name

@DelazJ
Copy link
Contributor

DelazJ commented Feb 3, 2022

@gioman we can also question why db manager duplicates that layer

@gioman
Copy link
Contributor

gioman commented Feb 3, 2022

@gioman we can also question why db manager duplicates that layer

@DelazJ yes, but as it does and it appends an identifier as suffix, I guess that is by design.

@mcingotti
Copy link
Author

@nyalldawson in which version will be applied this fix?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Processing Relating to QGIS Processing framework or individual Processing algorithms
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants