[6.18.1 / Linux] Board Selector freezes the GUI forever: unindexed SQLite query runs synchr
Hello,
"AWT-EventQueue-0" #46 [10722] prio=6 os_prio=0 cpu=72188.54ms elapsed=81.89s runnable
java.lang.Thread.State: RUNNABLE
at org.sqlite.core.NativeDB.step(Native Method)
at org.sqlite.core.DB.execute(DB.java:1012)
at org.sqlite.core.DB.execute(DB.java:974)
at org.sqlite.jdbc3.JDBC3PreparedStatement.executeQuery(JDBC3PreparedStatement.java:87)
at com.st.microxplorer.mcufinder.db.DbMcusSqlite.getSqliteMissingFields(DbMcusSqlite.java:748)
at com.st.microxplorer.mcufinder.db.DbMcus.getMissingFields(DbMcus.java:1043)
at com.st.microxplorer.mcufinder.gui.WebUtils.downloadDocs(WebUtils.java:918)
at com.st.microxplorer.mcufinder.gui.selector.MultiScanPanel.performAutoRefresh(MultiScanPanel.java:814)
at com.st.microxplorer.mcufinder.gui.boardselector.BoardMultiScanPanel.<init>(BoardMultiScanPanel.java:133)
at com.st.microxplorer.mcufinder.gui.selector.MultiSelectorPanel.createBoardSelectorPanel(MultiSelectorPanel.java:265)
at com.st.microxplorer.mcufinder.gui.selector.MultiSelectorPanel.setSelectedTabIndex(MultiSelectorPanel.java:491)
at com.st.microxplorer.mcufinder.gui.selector.MultiSelectorDialog.<init>(MultiSelectorDialog.java:63)
at com.st.microxplorer.plugins.filemanager.engine.MainFileManager.userNewConfig(MainFileManager.java:161)
at com.st.microxplorer.maingui.HomeNewTaskLinePanel.jButtonNewConfigurationBoardActionPerformed(HomeNewTaskLinePanel.java:139)
... AWT event dispatch ...WORKAROUND I AM CURRENTLY USING
Help > Connection and Updates > "No Auto-Refresh at Application start"
The Board Selector then opens normally. Equivalent to setting DataRefresh=0
in ~/.stm32cubemx/plugins/updater/updater.ini.
The cost is that MCU/board data no longer refreshes on its own, and
Help > Refresh Data triggers the same hang.
For anyone hitting this: deleting the ~/.stmcufinder cache to force a clean
re-download does NOT help. I checked - the downloaded cube-finder-db.zip
matches ST's published md5 exactly, and PRAGMA integrity_check on the
database returns ok. The file is not damaged.
Thanks in advance for your time.
Manu
