QGIS Crashing When Opening File Linked to Non-Existent host for PostgreSQL Tables

[toniesomja]

What is the bug or the crash?

I am experiencing an issue where QGIS crashes upon attempting to open a specific project file. This project contains references to tables from a host in PostgreSQL database that no longer exist. Unfortunately, this file includes all of my original templates, and I am unable to access them due to the crash.

Could you please assist me in resolving this issue? I would greatly appreciate any guidance on how to recover or open the project despite the missing database tables.

Thank you for your help!

Steps to reproduce the issue

1. Open QGIS.
2. Attempt to open a project.
3. Ignore for Session (there is no other option)
4. QGIS crashes immediately
   
5. Report details:
   Python Stack Trace
   Windows fatal exception: access violation

Current thread 0x000056b8 (most recent call first):

Stack Trace

providerMetadataFactory :
QgsVectorLayerFeatureSource::QgsVectorLayerFeatureSource :
QgsFeature::setValid :
QgsFeaturePickerModel::createValuesGatherer :
QgsFeaturePickerModelBase::scheduledReload :
QObject::qt_static_metacall :
QTimer::timerEvent :
QObject::event :
QApplicationPrivate::notify_helper :
QApplication::notify :
QgsApplication::notify :
QCoreApplication::notifyInternal2 :
QEventDispatcherWin32Private::sendTimerEvent :
QEventDispatcherWin32::processEvents :
UserCallWinProcCheckWow :
DispatchMessageWorker :
QEventDispatcherWin32::processEvents :
qt_plugin_query_metadata :
QEventLoop::exec :
multipleProviderMetadataFactory :
QgsVectorLayer::setDataProvider :
QgsVectorLayer::readXml :
QgsMapLayer::readLayerXml :
QgsProject::addLayer :
QgsProject::_getMapLayers :
QgsProject::readProjectFile :
QgsProject::unzip :
QgsProject::read :
QgisApp::addProject :
QgisApp::openProject :
main :
BaseThreadInitThunk :
RtlUserThreadStart :

QGIS Info
QGIS Version: 3.40.0-Bratislava
QGIS code revision: b56115d
Compiled against Qt: 5.15.13
Running against Qt: 5.15.13
Compiled against GDAL: 3.9.3
Running against GDAL: 3.9.3

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

Versions

QGIS Version: 3.40.0-Bratislava an older one.

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

[nirvn]

@toniesomja , we'll need a sample project to replicate this crash, can you attach one here?