Sorry for the delay, here are the complete logs for both versions:
Build 125.2 (here it work, workbench offers me a list of table)
2020-11-02 08:35:08 INFO =================== Log started ===================
2020-11-02 08:35:08 INFO Settings.initialize() Using configdir: /home/username/.sqlworkbench
2020-11-02 08:35:08 DEBUG Settings.initialize() Using default xstlDir: /opt/sqlworkbench-2019-10-04-build125.2/xslt
2020-11-02 08:35:08 DEBUG Settings.initialize() Last modification time of loaded config file: 1604302431555
2020-11-02 08:35:08 INFO ResourceMgr.getResources() Setting default locale to: en
2020-11-02 08:35:08 INFO WbManager.readParameters() Starting SQL Workbench/J, Build 125.2 (2019-10-03 14:02)
2020-11-02 08:35:08 INFO WbManager.readParameters() Java version=11.0.6, java.home=/usr/local/sdkman/candidates/java/11.0.6-open, vendor=Oracle Corporation, name=OpenJDK 64-Bit Server VM
2020-11-02 08:35:08 INFO WbManager.readParameters() Operating System=Linux, version=3.10.0-514.10.2.el7.x86_64, platform=amd64
2020-11-02 08:35:08 INFO WbManager.readParameters() Available memory: 1934MB
2020-11-02 08:35:08 INFO WbManager.readParameters() Classpath: /opt/sqlworkbench-2019-10-04-build125.2/sqlworkbench.jar:/opt/sqlworkbench-2019-10-04-build125.2/ext/*
2020-11-02 08:35:08 INFO CommandRegistry.scanForExtensions() Found 0 commands in 2ms
2020-11-02 08:35:09 DEBUG MacroManager.init<> Loading default macros took 63ms
2020-11-02 08:35:09 INFO IconMgr.<init> Using sizes: toolbar: 16, menu: 16
2020-11-02 08:35:09 DEBUG Settings.restoreWindowPosition() Restoring window position for 'workbench.gui.MainWindow', current screen size: [x: 0, y: 0, w:2560,h:1440], requested position: [x: 756, y: 107, w:1675,h:1175]
2020-11-02 08:35:09 DEBUG DbUnitHelper.isDbUnitAvailable() DbUnit not available
2020-11-02 08:35:09 DEBUG PoiHelper.isPoiAvailable() Error loading POI classes org.apache.poi.ss.usermodel.Workbook
java.lang.ClassNotFoundException: org.apache.poi.ss.usermodel.Workbook
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
at java.base/java.lang.Class.forName0(Native Method)
at java.base/java.lang.Class.forName(Class.java:315)
at workbench.db.exporter.PoiHelper.isPoiAvailable(PoiHelper.java:56)
at workbench.sql.wbcommands.WbImport.getSupportedSpreadSheetTypes(WbImport.java:196)
at workbench.sql.wbcommands.WbImport.<init>(WbImport.java:139)
at workbench.sql.CommandMapper.<init>(CommandMapper.java:167)
at workbench.sql.StatementRunner.<init>(StatementRunner.java:122)
at workbench.gui.sql.SqlPanel.<init>(SqlPanel.java:465)
at workbench.gui.MainWindow.addTabAtIndex(MainWindow.java:3607)
at workbench.gui.MainWindow.addTab(MainWindow.java:3577)
at workbench.gui.MainWindow.addTab(MainWindow.java:3541)
at workbench.gui.MainWindow.display(MainWindow.java:378)
at workbench.WbManager.openNewWindow(WbManager.java:629)
at workbench.WbManager.runGui(WbManager.java:1014)
at java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:313)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:770)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:740)
at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
2020-11-02 08:35:09 DEBUG BookmarkManager.updateInBackground() Panel 'Statement' was updated in PT0.003823S (0 bookmarks)
2020-11-02 08:35:09 DEBUG ClasspathUtil.checkLibsToMove() Checking directory: /opt/sqlworkbench-2019-10-04-build125.2 for additional libraries
2020-11-02 08:35:09 INFO ClasspathUtil.checkLibsToMove() Checking for ext libs took: 2ms
2020-11-02 08:35:10 INFO XmlProfileStorage.readProfiles() Loading connection profiles from /home/username/.sqlworkbench/WbProfiles.xml
2020-11-02 08:35:10 DEBUG ProfileManager.readFile() 30 profiles loaded from /home/username/.sqlworkbench/WbProfiles.xml in 25ms
2020-11-02 08:35:10 DEBUG ProfileManager.readProfiles() 30 profiles loaded in 27ms from 1 files
2020-11-02 08:35:10 DEBUG WbDesCipher.getInstance() WbDesCipher created
2020-11-02 08:35:13 DEBUG MacroManager.loadMacros() Loaded 21 macros from file /home/username/.sqlworkbench/WbMacros.xml for clientId: 1
2020-11-02 08:35:13 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1
2020-11-02 08:35:14 DEBUG SqlPanel.readFromWorkspace() Restoring panel 1 from workspace /home/username/.sqlworkbench/Yucatan.wksp took 36ms
2020-11-02 08:35:14 DEBUG SqlPanel.readFromWorkspace() Restoring panel 2 from workspace /home/username/.sqlworkbench/Yucatan.wksp took 11ms
2020-11-02 08:35:14 DEBUG SqlPanel.readFromWorkspace() Restoring panel 3 from workspace /home/username/.sqlworkbench/Yucatan.wksp took 2ms
2020-11-02 08:35:14 DEBUG SqlPanel.readFromWorkspace() Restoring panel 4 from workspace /home/username/.sqlworkbench/Yucatan.wksp took 2ms
2020-11-02 08:35:14 DEBUG MainWindow.loadWorkspace() Loading workspace /home/username/.sqlworkbench/Yucatan.wksp took 244ms
2020-11-02 08:35:14 DEBUG BookmarkManager.updateInBackground() Panel 'use_conturex.sql' was updated in PT0.069519S (0 bookmarks)
2020-11-02 08:35:14 DEBUG BookmarkManager.updateBookmarks() Parsing bookmarks for 4 tabs took: 59ms
2020-11-02 08:35:14 DEBUG TreeLoader.setSelectedTypes() Selected object types: [SEQUENCE, SYNONYM, SYSTEM TABLE, TABLE, VIEW]
2020-11-02 08:35:14 INFO ConnectionMgr.getConnection() Creating new connection for [{Yucatan}/yucatan_v06@onlcelsiustcp] for driver=com.informix.jdbc.IfxDriver and URL=[jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp]
2020-11-02 08:35:14 INFO DbDriver.loadDriverClass() Adding ClassLoader URL=file:/global/common/java/versionen/ixjdbc-4.10.12/lib/ifxjdbc.jar
2020-11-02 08:35:14 DEBUG DbMetadata.<init> WbWin-1 TAB-4: Schema term: user
2020-11-02 08:35:14 DEBUG DbMetadata.<init> WbWin-1 TAB-4: Catalog term: database
2020-11-02 08:35:14 DEBUG DbMetadata.<init> WbWin-1 TAB-4: Identifier quote character obtained from driver:
2020-11-02 08:35:14 INFO DbMetadata.<init> WbWin-1 TAB-4: Using DBID=informix_dynamic_server
2020-11-02 08:35:14 INFO DbMetadata.<init> WbWin-1 TAB-4: Using identifier quote character: "
2020-11-02 08:35:14 INFO DbMetadata.<init> WbWin-1 TAB-4: Using search string escape character: \
2020-11-02 08:35:14 INFO DbMetadata.retrieveObjectTypes() WbWin-1 TAB-4: Table types returned by the JDBC driver: [SYSTEM TABLE, TABLE, VIEW]
2020-11-02 08:35:14 INFO DbMetadata.<init> WbWin-1 TAB-4: Using catalog separator: :
2020-11-02 08:35:14 DEBUG GenericSchemaInfoReader.logSettings() WbWin-1 TAB-4: Re-Use statement: false, cache current schema: false, SQL: null
2020-11-02 08:35:14 DEBUG GenericCatalogInformationReader.<init> WbWin-1 TAB-4: Cache current schema: false
2020-11-02 08:35:14 INFO WbConnection.runConnectScript() Executing connect script for connection [informix_dynamic_server]: User=username, Database=yucatan_v06, URL=jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp ...
2020-11-02 08:35:14 INFO StatementRunner.logStatement() Executed: (username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp)
EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('t')
(5ms)
2020-11-02 08:35:14 DEBUG WbConnection.runConnectScript() (WbWin-1 TAB-4) Executed statement: EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('t')
2020-11-02 08:35:14 INFO StatementRunner.logStatement() Executed: (username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp)
WbVarDef -variable=dbname -query="SELECT trim(dbinfo('dbname')) from sysmaster:sysdual"
(5ms)
2020-11-02 08:35:14 DEBUG WbConnection.runConnectScript() (WbWin-1 TAB-4) Executed statement: WbVarDef -variable=dbname -query="SELECT trim(dbinfo('dbname')) from sysmaster:sysdual"
2020-11-02 08:35:14 INFO StatementRunner.logStatement() Executed: (username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp)
WbVarDef -variable=connecttime -query="SELECT TO_CHAR(current, '%Y-%m-%d-%H-%M-%S') from sysmaster:sysdual"
(5ms)
2020-11-02 08:35:14 DEBUG WbConnection.runConnectScript() (WbWin-1 TAB-4) Executed statement: WbVarDef -variable=connecttime -query="SELECT TO_CHAR(current, '%Y-%m-%d-%H-%M-%S') from sysmaster:sysdual"
2020-11-02 08:35:14 INFO ConnectionMgr.getConnection() Connected to: [Informix Dynamic Server], Database version info: [12.10.FC11WE], Database version number: [12.10], Driver version: [4.10.JC12], JDBC version: [4.0], ID: [WbWin-1 TAB-4]
2020-11-02 08:35:14 DEBUG DbTreePanel.setConnectionToUse() Using connection WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp for DbTree
2020-11-02 08:35:14 DEBUG TreeLoader.setConnection() Using object types: [SEQUENCE, SYNONYM, SYSTEM TABLE, TABLE, VIEW]
2020-11-02 08:35:14 DEBUG DbTreePanel.loadTypes() Using the following object types for the type filter: [SEQUENCE, SYNONYM, SYSTEM TABLE, TABLE, VIEW]
2020-11-02 08:35:14 DEBUG DbMetadata.getCatalogInformation() WbWin-1 TAB-4: Retrieving 38 catalogs using getCatalogs() took: 3ms
2020-11-02 08:35:14 DEBUG TreeLoader.loadSchemas() Loading schemas for catalog: yucatan_v06
2020-11-02 08:35:14 WARN DbMetadata.getSchemas() WbWin-1 TAB-4: getSchemas() called with catalog parameter, but current connection is not configured to support that Backtrace
java.lang.Exception: Backtrace
at workbench.db.DbMetadata.getSchemas(DbMetadata.java:2789)
at workbench.gui.dbobjects.objecttree.TreeLoader.loadSchemas(TreeLoader.java:412)
at workbench.gui.dbobjects.objecttree.TreeLoader.loadChildren(TreeLoader.java:1127)
at workbench.gui.dbobjects.objecttree.DbObjectsTree.doLoad(DbObjectsTree.java:600)
at workbench.gui.dbobjects.objecttree.DbObjectsTree.access$000(DbObjectsTree.java:63)
at workbench.gui.dbobjects.objecttree.DbObjectsTree$7.run(DbObjectsTree.java:586)
2020-11-02 08:35:14 DEBUG DbMetadata.getSchemas() WbWin-1 TAB-4: Retrieving 3 schemas using getSchemas() took 5ms
2020-11-02 08:35:14 DEBUG TreeLoader.loadSchemas() Loaded 3 schemas. Currently selected types: [SEQUENCE, SYNONYM, SYSTEM TABLE, TABLE, VIEW]
2020-11-02 08:35:19 DEBUG CompletionHandler.updateSelectionList() Completion invoked for statement:
SELECT *
FROM kund^|^
WHERE 1=1
--group by 1
--order by 1
2020-11-02 08:35:19 DEBUG DbObjectCacheFactory.getCache() Creating new cache for: username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp
2020-11-02 08:35:19 ERROR ObjectCachePersistence.loadFromCache() Could not read local storage entry
java.lang.NullPointerException: entry
at java.base/java.util.Objects.requireNonNull(Objects.java:246)
at java.base/java.util.zip.ZipFile.getInputStream(ZipFile.java:372)
at workbench.db.objectcache.ObjectCachePersistence.loadFromLocalFile(ObjectCachePersistence.java:107)
at workbench.db.objectcache.DbObjectCacheFactory.loadCache(DbObjectCacheFactory.java:84)
at workbench.db.objectcache.DbObjectCacheFactory.getCache(DbObjectCacheFactory.java:154)
at workbench.db.WbConnection.getObjectCache(WbConnection.java:442)
at workbench.gui.completion.BaseAnalyzer.retrieveTables(BaseAnalyzer.java:583)
at workbench.gui.completion.BaseAnalyzer.buildResult(BaseAnalyzer.java:438)
at workbench.gui.completion.BaseAnalyzer.retrieveObjects(BaseAnalyzer.java:352)
at workbench.gui.completion.StatementContext.<init>(StatementContext.java:84)
at workbench.gui.completion.StatementContext.<init>(StatementContext.java:58)
at workbench.gui.completion.CompletionHandler.updateSelectionList(CompletionHandler.java:174)
at workbench.gui.completion.CompletionHandler.showPopup(CompletionHandler.java:101)
at workbench.gui.completion.CompletionHandler$1.run(CompletionHandler.java:132)
2020-11-02 08:35:19 DEBUG ObjectCache.getTables() Getting tables using schema: null, filter: null, search path: [null]
2020-11-02 08:35:19 DEBUG DbMetadata.getObjects() WbWin-1 TAB-4: Retrieving table list took: 44ms
2020-11-02 08:35:19 DEBUG DbMetadata.getObjects() WbWin-1 TAB-4: Processing 434 tables took: 7ms
2020-11-02 08:35:19 DEBUG ObjectCache.getTables() Namespace "null" not found in cache. Retrieved 434 objects
2020-11-02 08:35:19 DEBUG CompletionHandler.updateSelectionList() Auto-completion invoked for SELECT, analyzer: SelectAnalyzer, context: CONTEXT_TABLE_LIST, currentSchema: null, element count: 434 (104ms)
2020-11-02 08:37:54 DEBUG FileVersioner.createBackup() Created backup file: /home/username/.sqlworkbench/Yucatan.wksp.5
2020-11-02 08:37:54 DEBUG MainWindow.saveWorkspace() Workspace /home/username/.sqlworkbench/Yucatan.wksp saved
2020-11-02 08:37:54 DEBUG FileVersioner.createBackup() Created backup file: /home/username/.sqlworkbench/WbMacros.xml.5
2020-11-02 08:37:54 DEBUG MacroStorage.saveMacros() Saved 20 macros to /home/username/.sqlworkbench/WbMacros.xml
2020-11-02 08:37:54 DEBUG DbObjectCacheFactory.saveCache() Saving cache for key: username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp
2020-11-02 08:37:54 DEBUG ObjectCachePersistence.saveCache() Current object cache written to: /home/username/.sqlworkbench/.cache/username@informix_sqli_celsius_1526_yucatan_v06_informixserver_onlcelsiustcp.wbcache
2020-11-02 08:37:54 DEBUG ConnectionMgr.disconnect() Trying to physically close the connection with id=WbWin-1 TAB-4
2020-11-02 08:37:54 INFO ConnectionMgr.disconnect() Disconnecting: [yucatan_v06@onlcelsiustcp], ID=WbWin-1 TAB-4
2020-11-02 08:37:54 DEBUG WbConnection.shutdown() Connection WbWin-1 TAB-4 closed.
2020-11-02 08:37:54 DEBUG DbObjectCacheFactory.propertyChange() Connection with key=username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp was closed. Reference count for this cache is: 0
2020-11-02 08:37:54 DEBUG ObjectCachePersistence.saveCache() Current object cache written to: /home/username/.sqlworkbench/.cache/username@informix_sqli_celsius_1526_yucatan_v06_informixserver_onlcelsiustcp.wbcache
2020-11-02 08:37:54 DEBUG ObjectCache.clear() Removed all entries from the cache
2020-11-02 08:37:54 DEBUG DbObjectCacheFactory.propertyChange() Removed cache for key=username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp
2020-11-02 08:37:54 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1
2020-11-02 08:37:54 DEBUG BookmarkManager.updateInBackground() Panel 'Statement' was updated in PT0.000049S (0 bookmarks)
2020-11-02 08:37:54 DEBUG BookmarkManager.updateInBackground() Panel 'Statement' was updated in PT0.000076S (0 bookmarks)
2020-11-02 08:37:55 DEBUG WbManager.closeAllWindows() Closing all open windows
2020-11-02 08:37:55 DEBUG Settings.saveSettings() Saving global settings to: /home/username/.sqlworkbench/workbench.settings
2020-11-02 08:37:55 INFO WbManager.doShutdown() Stopping SQL Workbench/J, Build 125.2
2020-11-02 08:37:55 INFO =================== Log stopped ===================
Build 127 (here it does not work, workbench offers me a list of schema names)
2020-11-02 08:32:22 INFO =================== Log started ===================
2020-11-02 08:32:22 INFO Settings.initialize() Using configdir: /home/username/.sqlworkbench
2020-11-02 08:32:22 DEBUG Settings.initialize() Using default xstlDir: /opt/sqlworkbench-2020-09-22-build127/xslt
2020-11-02 08:32:22 DEBUG Settings.initialize() Last modification time of loaded config file: 1604302318753
2020-11-02 08:32:22 INFO ResourceMgr.getResources() Setting default locale to: en
2020-11-02 08:32:22 INFO WbManager.readParameters() Starting SQL Workbench/J, Build 127 (2020-08-22 22:34)
2020-11-02 08:32:22 INFO WbManager.readParameters() Java version=11.0.6, java.home=/usr/local/sdkman/candidates/java/11.0.6-open, vendor=Oracle Corporation, name=OpenJDK 64-Bit Server VM
2020-11-02 08:32:22 INFO WbManager.readParameters() Operating System=Linux, version=3.10.0-514.10.2.el7.x86_64, platform=amd64
2020-11-02 08:32:22 INFO WbManager.readParameters() Available memory: 1934MB
2020-11-02 08:32:22 INFO WbManager.readParameters() Classpath: /opt/sqlworkbench-2020-09-22-build127/sqlworkbench.jar:/opt/sqlworkbench-2020-09-22-build127/ext/flatlaf.jar
2020-11-02 08:32:22 INFO CommandRegistry.scanForExtensions() Found 0 commands in 6ms
2020-11-02 08:32:22 DEBUG LnFManager.getLnFList() Added FlatLaf Light, class: com.formdev.flatlaf.FlatLightLaf, type: ext
2020-11-02 08:32:22 DEBUG LnFManager.getLnFList() Added FlatLaf Dark, class: com.formdev.flatlaf.FlatDarkLaf, type: ext
2020-11-02 08:32:22 DEBUG LnFManager.getLnFList() Checking look & feels took: 48ms
2020-11-02 08:32:22 DEBUG MacroManager.<init> Loading default macros took 53ms
2020-11-02 08:32:22 INFO IconMgr.<init> Using sizes: toolbar: 16, menu: 16
2020-11-02 08:32:22 DEBUG Settings.restoreWindowPosition() Restoring window position for 'workbench.gui.MainWindow', current screen size: [x: 0, y: 0, w:2560,h:1440], requested position: [x: 756, y: 107, w:1675,h:1175]
2020-11-02 08:32:22 INFO PoiHelper.isPoiAvailable() Apache POI not available
2020-11-02 08:32:23 DEBUG DbUnitHelper.isDbUnitAvailable() DbUnit not available
2020-11-02 08:32:23 DEBUG BookmarkManager.lambda$updateInBackground$4() Panel 'Statement' was updated in 1ms (0 bookmarks)
2020-11-02 08:32:23 DEBUG ClasspathUtil.checkLibsToMove() Checking directory: /opt/sqlworkbench-2020-09-22-build127 for additional libraries
2020-11-02 08:32:23 INFO ClasspathUtil.checkLibsToMove() Checking for ext libs took: 1ms
2020-11-02 08:32:23 INFO ConnectionMgr.fixOracleSampleURL() Changed invalid sample URL in driver "Oracle" from: jdbc:oracle:thin://@hostname:port/service_name to: jdbc:oracle:thin:@//hostname:port/service_name
2020-11-02 08:32:23 INFO ConnectionMgr.fixOracleSampleURL() Changed invalid sample URL in driver "Oracle/XML" from: jdbc:oracle:thin://@hostname:port/service_name to: jdbc:oracle:thin:@//hostname:port/service_name
2020-11-02 08:32:23 DEBUG XmlProfileStorage.readProfiles() Loading connection profiles from /home/username/.sqlworkbench/WbProfiles.xml
2020-11-02 08:32:23 DEBUG WbDesCipher.getInstance() WbDesCipher created
2020-11-02 08:32:23 INFO XmlProfileStorage.readProfiles() Loaded 30 connection profiles from /home/username/.sqlworkbench/WbProfiles.xml
2020-11-02 08:32:23 DEBUG ProfileManager.readFile() 30 profiles loaded from /home/username/.sqlworkbench/WbProfiles.xml in 57ms
2020-11-02 08:32:23 INFO ProfileManager.readProfiles() 30 profiles loaded in 58ms from 1 files
2020-11-02 08:32:25 DEBUG MacroManager.loadMacros() Loaded 21 macros from file /home/username/.sqlworkbench/WbMacros.xml for clientId: 1
2020-11-02 08:32:25 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1
2020-11-02 08:32:26 DEBUG SqlPanel.readFromWorkspace() Restoring panel 1 from workspace /home/username/.sqlworkbench/Yucatan.wksp took 20ms
2020-11-02 08:32:26 DEBUG SqlPanel.readFromWorkspace() Restoring panel 2 from workspace /home/username/.sqlworkbench/Yucatan.wksp took 8ms
2020-11-02 08:32:26 DEBUG SqlPanel.readFromWorkspace() Restoring panel 3 from workspace /home/username/.sqlworkbench/Yucatan.wksp took 3ms
2020-11-02 08:32:26 DEBUG SqlPanel.readFromWorkspace() Restoring panel 4 from workspace /home/username/.sqlworkbench/Yucatan.wksp took 1ms
2020-11-02 08:32:26 DEBUG BookmarkManager.lambda$updateInBackground$4() Panel 'use_conturex.sql' was updated in 12ms (0 bookmarks)
2020-11-02 08:32:26 DEBUG MainWindow.loadWorkspace() Loading workspace /home/username/.sqlworkbench/Yucatan.wksp took 264ms
2020-11-02 08:32:26 DEBUG BookmarkManager.updateBookmarks() Parsing bookmarks for 4 tabs took: 2ms
2020-11-02 08:32:26 DEBUG TreeLoader.setSelectedTypes() Selected object types: [SEQUENCE, SYNONYM, SYSTEM TABLE, TABLE, VIEW]
2020-11-02 08:32:26 INFO ConnectionMgr.getConnection() Creating new connection for "{Yucatan}/yucatan_v06@onlcelsiustcp": [user=username, url=jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp, driverClass=com.informix.jdbc.IfxDriver, driverName=Informix]
2020-11-02 08:32:26 INFO DbDriver.loadDriverClass() Adding ClassLoader URL=file:/global/common/java/versionen/ixjdbc-4.10.12/lib/ifxjdbc.jar
2020-11-02 08:32:26 DEBUG DbMetadata.<init> WbWin-1 TAB-4: Schema term: user
2020-11-02 08:32:26 DEBUG DbMetadata.<init> WbWin-1 TAB-4: Catalog term: database
2020-11-02 08:32:26 DEBUG DbMetadata.<init> WbWin-1 TAB-4: Identifier quote character obtained from driver:
2020-11-02 08:32:26 INFO DbMetadata.<init> WbWin-1 TAB-4: Using DBID=informix_dynamic_server
2020-11-02 08:32:26 INFO DbMetadata.<init> WbWin-1 TAB-4: Using identifier quote character: "
2020-11-02 08:32:26 INFO DbMetadata.<init> WbWin-1 TAB-4: Using search string escape character: \
2020-11-02 08:32:26 INFO DbMetadata.retrieveObjectTypes() WbWin-1 TAB-4: Table types returned by the JDBC driver: [SYSTEM TABLE, TABLE, VIEW]
2020-11-02 08:32:26 INFO DbMetadata.<init> WbWin-1 TAB-4: Using catalog separator: :
2020-11-02 08:32:26 DEBUG GenericSchemaInfoReader.logSettings() WbWin-1 TAB-4: Re-Use statement: false, cache current schema: false, SQL: null
2020-11-02 08:32:26 DEBUG GenericCatalogInformationReader.<init> WbWin-1 TAB-4: Cache current schema: false
2020-11-02 08:32:26 INFO WbConnection.runConnectScript() Executing connect script for connection [informix_dynamic_server]: User=username, Database=yucatan_v06, URL=jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp ...
2020-11-02 08:32:26 INFO StatementRunner.logStatement() Executed: (WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp)
EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('t')
(4ms)
2020-11-02 08:32:26 DEBUG WbConnection.runConnectScript() (WbWin-1 TAB-4) Executed statement: EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('t')
2020-11-02 08:32:26 INFO StatementRunner.logStatement() Executed: (WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp)
WbVarDef -variable=dbname -query="SELECT trim(dbinfo('dbname')) from sysmaster:sysdual"
(4ms)
2020-11-02 08:32:26 DEBUG WbConnection.runConnectScript() (WbWin-1 TAB-4) Executed statement: WbVarDef -variable=dbname -query="SELECT trim(dbinfo('dbname')) from sysmaster:sysdual"
2020-11-02 08:32:26 INFO StatementRunner.logStatement() Executed: (WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp)
WbVarDef -variable=connecttime -query="SELECT TO_CHAR(current, '%Y-%m-%d-%H-%M-%S') from sysmaster:sysdual"
(3ms)
2020-11-02 08:32:26 DEBUG WbConnection.runConnectScript() (WbWin-1 TAB-4) Executed statement: WbVarDef -variable=connecttime -query="SELECT TO_CHAR(current, '%Y-%m-%d-%H-%M-%S') from sysmaster:sysdual"
2020-11-02 08:32:26 INFO ConnectionMgr.getConnection() Connected to: [Informix Dynamic Server], Database version info: [12.10.FC11WE], Database version number: [12.10], Driver version: [4.10.JC12], JDBC version: [4.0], ID: [WbWin-1 TAB-4]
2020-11-02 08:32:26 DEBUG ConnectionInfo.updateDBSwitcher() Removing DB switcher for: WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp
2020-11-02 08:32:26 DEBUG DbTreePanel.setConnectionToUse() Using connection WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp for DbTree
2020-11-02 08:32:26 DEBUG TreeLoader.setConnection() Using object types: [SEQUENCE, SYNONYM, SYSTEM TABLE, TABLE, VIEW]
2020-11-02 08:32:26 DEBUG DbTreePanel.loadTypes() Using the following object types for the type filter: [SEQUENCE, SYNONYM, SYSTEM TABLE, TABLE, VIEW]
2020-11-02 08:32:26 DEBUG DbMetadata.getCatalogInformation() WbWin-1 TAB-4: Retrieving 38 catalogs using getCatalogs() took: 3ms
2020-11-02 08:32:26 DEBUG TreeLoader.loadSchemas() Loading schemas for catalog: yucatan_v06
2020-11-02 08:32:26 WARN DbMetadata.getSchemas() WbWin-1 TAB-4: getSchemas() called with catalog parameter, but current connection is not configured to support that Backtrace
java.lang.Exception: Backtrace
at workbench.db.DbMetadata.getSchemas(DbMetadata.java:2624)
at workbench.gui.dbobjects.objecttree.TreeLoader.loadSchemas(TreeLoader.java:433)
at workbench.gui.dbobjects.objecttree.TreeLoader.loadChildren(TreeLoader.java:1227)
at workbench.gui.dbobjects.objecttree.DbObjectsTree.doLoad(DbObjectsTree.java:612)
at workbench.gui.dbobjects.objecttree.DbObjectsTree.access$000(DbObjectsTree.java:64)
at workbench.gui.dbobjects.objecttree.DbObjectsTree$9.run(DbObjectsTree.java:598)
2020-11-02 08:32:26 DEBUG DbMetadata.getSchemas() WbWin-1 TAB-4: Retrieving 3 schemas using getSchemas() took 13ms
2020-11-02 08:32:26 DEBUG TreeLoader.loadSchemas() Loaded 3 schemas. Currently selected types: [SEQUENCE, SYNONYM, SYSTEM TABLE, TABLE, VIEW]
2020-11-02 08:32:29 DEBUG CompletionHandler.updateSelectionList() Completion invoked for statement:
SELECT *
FROM kund^|^
WHERE 1=1
--group by 1
--order by 1
2020-11-02 08:32:29 DEBUG DbMetadata.getCatalogInformation() WbWin-1 TAB-4: Retrieving 38 catalogs using getCatalogs() took: 2ms
2020-11-02 08:32:29 DEBUG DbMetadata.getSchemas() WbWin-1 TAB-4: Retrieving 3 schemas using getSchemas() took 5ms
2020-11-02 08:32:29 DEBUG CompletionHandler.updateSelectionList() Auto-completion invoked for SELECT, analyzer: SelectAnalyzer, context: 11, currentSchema: yucatan_v06, element count: 3 (32ms)
2020-11-02 08:32:37 DEBUG DbObjectCacheFactory.getCache() Creating new cache for: WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp
2020-11-02 08:32:37 ERROR ObjectCachePersistence.loadFromLocalFile() Could not read local storage entry
java.lang.NullPointerException: entry
at java.base/java.util.Objects.requireNonNull(Objects.java:246)
at java.base/java.util.zip.ZipFile.getInputStream(ZipFile.java:372)
at workbench.db.objectcache.ObjectCachePersistence.loadFromLocalFile(ObjectCachePersistence.java:109)
at workbench.db.objectcache.DbObjectCacheFactory.loadCache(DbObjectCacheFactory.java:85)
at workbench.db.objectcache.DbObjectCacheFactory.getCache(DbObjectCacheFactory.java:157)
at workbench.db.WbConnection.getObjectCache(WbConnection.java:459)
at workbench.gui.completion.CompletionPopup.doPaste(CompletionPopup.java:615)
at workbench.gui.completion.CompletionPopup.closePopup(CompletionPopup.java:412)
at workbench.gui.completion.CompletionPopup.quickSearchValueSelected(CompletionPopup.java:294)
at workbench.gui.completion.CompletionSearchField.keyPressed(CompletionSearchField.java:66)
at java.desktop/java.awt.Component.processKeyEvent(Component.java:6590)
at java.desktop/javax.swing.JComponent.processKeyEvent(JComponent.java:2849)
at java.desktop/java.awt.Component.processEvent(Component.java:6409)
at java.desktop/java.awt.Container.processEvent(Container.java:2263)
at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5008)
at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2321)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4840)
at java.desktop/java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1950)
at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:870)
at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1139)
at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1009)
at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:835)
at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2321)
at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2772)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4840)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
2020-11-02 08:32:41 DEBUG CompletionHandler.updateSelectionList() Completion invoked for statement:
SELECT *
FROM informix.kund^|^
WHERE 1=1
--group by 1
--order by 1
2020-11-02 08:32:41 DEBUG DbMetadata.getCatalogInformation() WbWin-1 TAB-4: Retrieving 38 catalogs using getCatalogs() took: 3ms
2020-11-02 08:32:41 DEBUG DbMetadata.getSchemas() WbWin-1 TAB-4: Retrieving 3 schemas using getSchemas() took 6ms
2020-11-02 08:32:41 DEBUG CompletionHandler.updateSelectionList() Auto-completion invoked for SELECT, analyzer: SelectAnalyzer, context: 11, currentSchema: yucatan_v06, element count: 3 (18ms)
2020-11-02 08:33:51 DEBUG MainWindow.windowClosing() Main window closing
2020-11-02 08:33:51 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "/home/username/.sqlworkbench/Yucatan.wksp" took 4ms
2020-11-02 08:33:51 DEBUG FileVersioner.createBackup() Created file "/home/username/.sqlworkbench/Yucatan.wksp.5" as a backup of "/home/username/.sqlworkbench/Yucatan.wksp" in 13ms
2020-11-02 08:33:51 DEBUG MainWindow._doSaveWorkspace() Workspace /home/username/.sqlworkbench/Yucatan.wksp saved in 35ms
2020-11-02 08:33:51 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "/home/username/.sqlworkbench/WbMacros.xml" took 10ms
2020-11-02 08:33:51 DEBUG FileVersioner.createBackup() Created file "/home/username/.sqlworkbench/WbMacros.xml.5" as a backup of "/home/username/.sqlworkbench/WbMacros.xml" in 17ms
2020-11-02 08:33:51 DEBUG MacroStorage.saveMacros() Saved 20 macros to /home/username/.sqlworkbench/WbMacros.xml in 67ms
2020-11-02 08:33:51 DEBUG ObjectCachePersistence.saveToLocalFile() Current object cache written to: /home/username/.sqlworkbench/.cache/username@informix_sqli_celsius_1526_yucatan_v06_informixserver_onlcelsiustcp.wbcache
2020-11-02 08:33:51 DEBUG DbObjectCacheFactory.saveCache() Saving cache for WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp took 13ms
2020-11-02 08:33:51 DEBUG ConnectionMgr.disconnect() Trying to physically close the connection with id=WbWin-1 TAB-4
2020-11-02 08:33:51 INFO ConnectionMgr.closeConnection() Disconnecting: [yucatan_v06@onlcelsiustcp], ID=WbWin-1 TAB-4
2020-11-02 08:33:51 DEBUG WbConnection.shutdown() Connection WbWin-1 TAB-4 closed.
2020-11-02 08:33:51 DEBUG ConnectionMgr.closeConnection() Disconnecting connection with ID=WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp took 3ms
2020-11-02 08:33:51 DEBUG DbObjectCacheFactory.propertyChange() Connection WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp was closed. Reference count for this cache is: 0
2020-11-02 08:33:51 DEBUG ObjectCachePersistence.saveToLocalFile() Current object cache written to: /home/username/.sqlworkbench/.cache/username@informix_sqli_celsius_1526_yucatan_v06_informixserver_onlcelsiustcp.wbcache
2020-11-02 08:33:51 DEBUG DbObjectCacheFactory.saveCache() Saving cache for WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp took 6ms
2020-11-02 08:33:51 DEBUG ObjectCache.clear() Removed all entries from the cache
2020-11-02 08:33:51 DEBUG DbObjectCacheFactory.propertyChange() Removed cache for WbWin-1 TAB-4, username@jdbc:informix-sqli://celsius:1526/yucatan_v06:INFORMIXSERVER=onlcelsiustcp
2020-11-02 08:33:51 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1
2020-11-02 08:33:51 DEBUG BookmarkManager.lambda$updateInBackground$4() Panel 'Statement' was updated in 0ms (0 bookmarks)
2020-11-02 08:33:51 DEBUG BookmarkManager.lambda$updateInBackground$4() Panel 'Statement' was updated in 0ms (0 bookmarks)
2020-11-02 08:33:51 DEBUG WbManager.closeAllWindows() Closing all open windows
2020-11-02 08:33:51 DEBUG Settings.saveSettings() Saving global settings to: /home/username/.sqlworkbench/workbench.settings
2020-11-02 08:33:51 INFO WbManager.doShutdown() Stopping SQL Workbench/J, Build 127
2020-11-02 08:33:51 INFO =================== Log stopped ===================