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

Crash on opening ODBC connection #59372

Open
2 tasks done
the3rdParty opened this issue Nov 7, 2024 · 1 comment
Open
2 tasks done

Crash on opening ODBC connection #59372

the3rdParty opened this issue Nov 7, 2024 · 1 comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Crash/Data Corruption Data Source Manager ODBC

Comments

@the3rdParty
Copy link

What is the bug or the crash?

QGis crashes when user tries to add a new vector layer from database (ODBC) source. This occurs both testing the connection as well as adding the layer (without testing). The same ODBC connection tests ok in the ODBC Data Source Manager and returns data to other applications such as MS Excel

Steps to reproduce the issue

  1. Set up an ODBC connection using the system's ODBC data source manager. In this case the data source is on a remote server. Test the connection and ensure its working.
  2. In QGIS select Menu: Layer / Add Layer / Add Vector Layer
  3. In the "Data Source Manager / Vector" window select Source Type: Database
  4. Select Database: ODBC
  5. Click Connections: New
  6. In the "Create a New OGR Database Connection" window select Type: ODBC,
  7. Name: Input any name,
  8. Host: [blank],
  9. Database : The name of the ODBC connection created in step 1.
  10. Port: 2399
  11. Under Authentication, click Basic tab, and complete the username and password for the ODBC connection
  12. Click "Test Connection"
  13. QGIS crashes after a few seconds

Versions

QGIS version
3.34.9-Prizren
QGIS code revision
cbbc7bd
Qt version
5.15.13
Python version
3.12.4
GDAL/OGR version
3.9.1
PROJ version
9.4.0
EPSG Registry database version
v11.004 (2024-02-24)
GEOS version
3.12.2-CAPI-1.18.2
SQLite version
3.45.1
PDAL version
2.6.3
PostgreSQL client version
16.2
SpatiaLite version
5.1.0
QWT version
6.2.0
QScintilla2 version
2.14.1
OS version
Windows 11 Version 2009

Active Python plugins
pointsamplingtool
0.5.4
qchainage
3.0.1
quick_map_services
0.19.34
db_manager
0.1.20
grassprovider
2.12.99
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

Python Stack Trace
Windows fatal exception: access violation

Current thread 0x00000130 (most recent call first):

Stack Trace

ConfigDSNW :
SQLTablesW :
SQLTablesCover :
SQLTables :
CPLODBCDriverInstaller::RemoveDriver :
CPLODBCDriverInstaller::RemoveDriver :
CPLODBCDriverInstaller::RemoveDriver :
CPLODBCDriverInstaller::RemoveDriver :
CPLODBCDriverInstaller::RemoveDriver :
QgsOgrProviderUtils::GDALOpenWrapper :
QgsOgrProviderUtils::IsLocalFile :
QgsOgrProviderUtils::getLayer :
QgsTiledSceneRenderer::flags :
QgsAppLayerHandling::addOgrVectorLayers :
QgisApp::identifyMapTool :
QObject::qt_static_metacall :
QgsDataSourceManagerDialog::addVectorLayers :
QObject::qt_static_metacall :
QgsAbstractDataSourceWidget::addVectorLayers :
QgsProjectStorageGuiProvider::QgsProjectStorageGuiProvider :
QObject::qt_static_metacall :
QAbstractButton::clicked :
QAbstractButton::click :
QAbstractButton::mouseReleaseEvent :
QWidget::event :
QApplicationPrivate::notify_helper :
QApplication::notify :
QgsApplication::notify :
QCoreApplication::notifyInternal2 :
QApplicationPrivate::sendMouseEvent :
QSizePolicy::QSizePolicy :
QSizePolicy::QSizePolicy :
QApplicationPrivate::notify_helper :
QApplication::notify :
QgsApplication::notify :
QCoreApplication::notifyInternal2 :
QGuiApplicationPrivate::processMouseEvent :
QWindowSystemInterface::sendWindowSystemEvents :
QEventDispatcherWin32::processEvents :
qt_plugin_query_metadata :
QEventLoop::exec :
QCoreApplication::exec :
main :
BaseThreadInitThunk :
RtlUserThreadStart :

QGIS Info
QGIS Version: 3.34.9-Prizren
QGIS code revision: cbbc7bd
Compiled against Qt: 5.15.13
Running against Qt: 5.15.13
Compiled against GDAL: 3.9.1
Running against GDAL: 3.9.1

System Info
CPU Type: x86_64
Kernel Type: winnt
Kernel Version: 10.0.22621

@the3rdParty the3rdParty added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Nov 7, 2024
@agiudiceandrea
Copy link
Contributor

Probably the same underlying issue of #48403.

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! Crash/Data Corruption Data Source Manager ODBC
Projects
None yet
Development

No branches or pull requests

2 participants