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

Postgis metadata error #56842

Open
2 tasks done
eleagula opened this issue Mar 13, 2024 · 2 comments
Open
2 tasks done

Postgis metadata error #56842

eleagula opened this issue Mar 13, 2024 · 2 comments
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Metadata Related to handling of layer or project metadata

Comments

@eleagula
Copy link

eleagula commented Mar 13, 2024

What is the bug or the crash?

In either QGIS 3.34.4 or QGIS 3.36.0, when I attempt to save metadata to my Postgis database for a newly uploaded vector layer, I receive this error:

forward transform of
(inf, inf)
Error: Fallback transform failed

This seems to happen for layers I've uploaded to Postgis using the GDAL "Export to PostgreSQL", as well as for some layers I've uploaded using the DB Manager. Previous versions of QGIS worked fine.

Steps to reproduce the issue

In either QGIS 3.34.4 or QGIS 3.36.0, upload a vector layer to Postgis using the GDAL "Export to PostgreSQL" function. After uploading, place layer in Layers panel and attempt to write and save metadata using the "Save to Default Location" option. The following error pops up and no metadata is saved in the database:

forward transform of
(inf, inf)
Error: Fallback transform failed

A similar error occurs with layers uploaded via DB Manager, although not as consistently.

Versions

<style type="text/css"> p, li { white-space: pre-wrap; } </style>
QGIS version 3.34.4-Prizren QGIS code revision decd43d
Qt version 5.15.3
Python version 3.9.18
GDAL/OGR version 3.8.4
PROJ version 9.3.1
EPSG Registry database version v10.098 (2023-11-24)
GEOS version 3.12.1-CAPI-1.18.1
SQLite version 3.41.1
PDAL version 2.6.0
PostgreSQL client version 16.1
SpatiaLite version 5.1.0
QWT version 6.1.6
QScintilla2 version 2.13.4
OS version Windows 10 Version 2009
       
Active Python plugins
project_report 1.2
qgis_stac 1.1.1
QuickOSM 2.2.3
quick_map_services 0.19.34
SentinelHub 2.0.2
db_manager 0.1.20
MetaSearch 0.3.6
processing 2.12.99
QGIS version 3.34.4-Prizren QGIS code revision [decd43d](https://github.com/qgis/QGIS/commit/decd43dc) Qt version 5.15.3 Python version 3.9.18 GDAL/OGR version 3.8.4 PROJ version 9.3.1 EPSG Registry database version v10.098 (2023-11-24) GEOS version 3.12.1-CAPI-1.18.1 SQLite version 3.41.1 PDAL version 2.6.0 PostgreSQL client version 16.1 SpatiaLite version 5.1.0 QWT version 6.1.6 QScintilla2 version 2.13.4 OS version Windows 10 Version 2009

Active Python plugins
project_report
1.2
qgis_stac
1.1.1
QuickOSM
2.2.3
quick_map_services
0.19.34
SentinelHub
2.0.2
db_manager
0.1.20
MetaSearch
0.3.6
processing
2.12.99


Supported QGIS version

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

New profile

Additional context

No response

@eleagula eleagula added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Mar 13, 2024
@eleagula
Copy link
Author

eleagula commented Mar 13, 2024

Adjusting the Extent in the Metadata menu seemed to have allowed me to save the metadata to the database. In the Extent tab, I chose my layer in question from the "Calculate from: Layer" option and it changed the extent values. After that, I was able to save the metadata. However, this may still represent an issue - In previous versions of QGIS, I did not have to bother with manually adjusting the extent after uploading a new layer in order to save metadata to Postgis.

@agiudiceandrea agiudiceandrea added the Metadata Related to handling of layer or project metadata label Mar 17, 2024
@kjetpett
Copy link

Adjusting the Extent in the Metadata menu seemed to have allowed me to save the metadata to the database. In the Extent tab, I chose my layer in question from the "Calculate from: Layer" option and it changed the extent values. After that, I was able to save the metadata. However, this may still represent an issue - In previous versions of QGIS, I did not have to bother with manually adjusting the extent after uploading a new layer in order to save metadata to Postgis.

I can confirm that I have experienced the same issue that you describe both on QGIS 3.38 (MacOS) and 3.36 (Windows). I was able to save metadata to qgis_layer_metadata by manually recalculating the extent as you describe.

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! Metadata Related to handling of layer or project metadata
Projects
None yet
Development

No branches or pull requests

3 participants