Ask a Question

OpenLCA crashes when hovering "Description"

+1 vote
1.5k views
Hello.
I've come across an issue, and I was wondering if someone else has experienced it.

I do as follows:

Open any process from a database > Go to the Inputs/Outputs tab > In the Inputs table, hover the mouse over the description column/field of any input > [software freezes]

In previous versions of OpenLCA I've used, when I hovered over the description field (without left-clicking), the program would show a small textbox with the contents of the description field. Now, it crashes.

What could be the issue?

Thank you in advance.

EDIT:

Software: OpenLCA version 2.5.0
Operating System: Windows 11
in openLCA by (130 points)
edited by

3 Answers

0 votes
by (147k points)
edited by
Thank you for reporting - which version are you using, and on which operation system?

(@all, be aware that such a report is much more useful for us if these "details" are provided as well. It is for you probably clear which version you are using but not for us, and since openLCA is developed further, the behaviour is not the same across different versions. Thank you!)

Also edit: thank you for the details! However here, this did not help too much, I was using 2.5 (until switching to 2.6 two days ago or so) since release, on Windows, on different computers, and did not have this behaviour. Does the log file indicate anything? Do you have a very weak graphic card or processor on the computer? Can you try if you have the same behaviour in 2.6 (in downloads, other, development releases)? Thank you again.
Show 8 previous comments
by (147k points)
thank you but I cannot read it - 261, windows? - edit: the text helps, I was referring to the image below. Please indeed report if you run into the issue again.
0 votes
by (180 points)

Same here. Freeze when hovering over the description of the output "biowaste"

0 votes
ago by (310 points)
I’m having the same problem. It started with version 2.6.1, but it’s still happening after upgrading to 2.6.2.
If I select the flow in the Input/Output table first, I can open the description of that flow – but trying the second flow at the latest, openLCA freezes.
My PC meets all the requirements, has plenty of RAM and a good graphics card. Until now, openLCA has always worked without any problems.

I expected some issues with older versions or older databases in the openlca data folder. However, emptying the folder and re-importing the databases did not solve the problem.
Show 1 previous comment
ago by (310 points)
Second half of log file:
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - After adding stats (total=3/10, idle=2/10, active=1, waiting=0)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Attempting to create/setup new connection (fb6f2b37-ecc6-4588-8845-4c862867f462)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Established new connection (fb6f2b37-ecc6-4588-8845-4c862867f462)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - Added connection org.apache.derby.impl.jdbc.EmbedConnection@107157333 (XID = 11609982), (SESSIONID = 7), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - After adding stats (total=4/10, idle=3/10, active=1, waiting=0)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Attempting to create/setup new connection (da0984c0-a549-403a-8e44-e8c45ca4be4d)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Established new connection (da0984c0-a549-403a-8e44-e8c45ca4be4d)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - Added connection org.apache.derby.impl.jdbc.EmbedConnection@1462877786 (XID = 11609985), (SESSIONID = 9), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null)
09:01:16    DEBUG    com.zaxxer.hikari.pool.ProxyConnection    HikariPool-1 - Executed rollback on connection org.apache.derby.impl.jdbc.EmbedConnection@1585347198 (XID = 11609975), (SESSIONID = 1), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null) due to dirty commit state on close().
09:01:16    TRACE    org.openlca.app.AppContext    clear app cache
09:01:16    TRACE    org.openlca.app.AppContext    evict all from cache
09:01:16    TRACE    org.openlca.app.AppContext    create app cache for Derby: •
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - After adding stats (total=5/10, idle=5/10, active=0, waiting=0)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Attempting to create/setup new connection (ae634e1d-f7fc-4efc-83ac-c285003bd654)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Established new connection (ae634e1d-f7fc-4efc-83ac-c285003bd654)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - Added connection org.apache.derby.impl.jdbc.EmbedConnection@152815240 (XID = 11609987), (SESSIONID = 11), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - After adding stats (total=6/10, idle=6/10, active=0, waiting=0)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Attempting to create/setup new connection (d6626144-dd17-4720-8c7c-212ce5165fa0)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Established new connection (d6626144-dd17-4720-8c7c-212ce5165fa0)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - Added connection org.apache.derby.impl.jdbc.EmbedConnection@1400833482 (XID = 11609989), (SESSIONID = 13), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null)
09:01:16    TRACE    org.openlca.core.database.Derby    create connection: jdbc:derby:C:/Users/•/openLCA-data-1.4/databases/•
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - After adding stats (total=7/10, idle=6/10, active=1, waiting=0)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Attempting to create/setup new connection (5f5e6c0b-a155-4c50-b605-66e372336c5c)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Established new connection (5f5e6c0b-a155-4c50-b605-66e372336c5c)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - Added connection org.apache.derby.impl.jdbc.EmbedConnection@1983746272 (XID = 11609993), (SESSIONID = 15), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null)
09:01:16    DEBUG    com.zaxxer.hikari.pool.ProxyConnection    HikariPool-1 - Executed rollback on connection org.apache.derby.impl.jdbc.EmbedConnection@1585347198 (XID = 11609975), (SESSIONID = 1), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null) due to dirty commit state on close().
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - After adding stats (total=8/10, idle=8/10, active=0, waiting=0)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Attempting to create/setup new connection (5fec1bc2-db74-4bec-b7d8-73d8cf89f014)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Established new connection (5fec1bc2-db74-4bec-b7d8-73d8cf89f014)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - Added connection org.apache.derby.impl.jdbc.EmbedConnection@1632862870 (XID = 11609995), (SESSIONID = 17), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - After adding stats (total=9/10, idle=9/10, active=0, waiting=0)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Attempting to create/setup new connection (0b1c249c-762e-4647-8251-1827e8b85083)
09:01:16    DEBUG    com.zaxxer.hikari.pool.PoolBase    HikariPool-1 - Established new connection (0b1c249c-762e-4647-8251-1827e8b85083)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - Added connection org.apache.derby.impl.jdbc.EmbedConnection@1943015353 (XID = 11609997), (SESSIONID = 19), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - After adding stats (total=10/10, idle=10/10, active=0, waiting=0)
09:01:16    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - Connection not added, stats (total=10/10, idle=10/10, active=0, waiting=0)
09:01:16    TRACE    org.openlca.core.database.NativeSql    execute query select file_name from tbl_mapping_files
09:01:16    TRACE    org.openlca.core.database.Derby    create connection: jdbc:derby:C:/Users/•/openLCA-data-1.4/databases/•
09:01:16    DEBUG    com.zaxxer.hikari.pool.ProxyConnection    HikariPool-1 - Executed rollback on connection org.apache.derby.impl.jdbc.EmbedConnection@1585347198 (XID = 11609975), (SESSIONID = 1), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null) due to dirty commit state on close().
09:01:20    TRACE    org.openlca.core.database.NativeSql    execute query select d.id, d.ref_id, d.name, d.version, d.last_change, d.f_category, d.library, d.tags from tbl_results d where d.f_category is null
09:01:20    TRACE    org.openlca.core.database.Derby    create connection: jdbc:derby:C:/Users/•/openLCA-data-1.4/databases/•
09:01:20    DEBUG    com.zaxxer.hikari.pool.ProxyConnection    HikariPool-1 - Executed rollback on connection org.apache.derby.impl.jdbc.EmbedConnection@1585347198 (XID = 11609975), (SESSIONID = 1), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null) due to dirty commit state on close().
09:01:20    TRACE    org.openlca.core.database.NativeSql    execute query select d.id, d.ref_id, d.name, d.version, d.last_change, d.f_category, d.library, d.tags from tbl_epds d where d.f_category is null
09:01:20    TRACE    org.openlca.core.database.Derby    create connection: jdbc:derby:C:/Users/•/openLCA-data-1.4/databases/•
09:01:20    DEBUG    com.zaxxer.hikari.pool.ProxyConnection    HikariPool-1 - Executed rollback on connection org.apache.derby.impl.jdbc.EmbedConnection@1585347198 (XID = 11609975), (SESSIONID = 1), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null) due to dirty commit state on close().
09:01:20    TRACE    org.openlca.core.database.NativeSql    execute query select d.id, d.ref_id, d.name, d.version, d.last_change, d.f_category, d.library, d.tags, d.flow_type, d.f_location, d.f_reference_flow_property from tbl_flows d where d.f_category is null
09:01:20    TRACE    org.openlca.core.database.Derby    create connection: jdbc:derby:C:/Users/•/openLCA-data-1.4/databases/•
09:01:20    DEBUG    com.zaxxer.hikari.pool.ProxyConnection    HikariPool-1 - Executed rollback on connection org.apache.derby.impl.jdbc.EmbedConnection@1585347198 (XID = 11609975), (SESSIONID = 1), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null) due to dirty commit state on close().
09:01:20    TRACE    org.openlca.core.database.NativeSql    execute query select d.id, d.ref_id, d.name, d.version, d.last_change, d.f_category, d.library, d.tags, d.process_type, d.f_location, f.flow_type from tbl_processes d left join tbl_exchanges e on e.id = d.f_quantitative_reference left join tbl_flows f on e.f_flow = f.id where d.f_category is null
09:01:20    TRACE    org.openlca.core.database.Derby    create connection: jdbc:derby:C:/Users/•/openLCA-data-1.4/databases/•
09:01:20    DEBUG    com.zaxxer.hikari.pool.ProxyConnection    HikariPool-1 - Executed rollback on connection org.apache.derby.impl.jdbc.EmbedConnection@1585347198 (XID = 11609975), (SESSIONID = 1), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null) due to dirty commit state on close().
09:01:21    TRACE    org.openlca.core.database.NativeSql    execute query select d.id, d.ref_id, d.name, d.version, d.last_change, d.f_category, d.library, d.tags from tbl_product_systems d where d.f_category is null
09:01:21    TRACE    org.openlca.core.database.Derby    create connection: jdbc:derby:C:/Users/•/openLCA-data-1.4/databases/•
09:01:21    DEBUG    com.zaxxer.hikari.pool.ProxyConnection    HikariPool-1 - Executed rollback on connection org.apache.derby.impl.jdbc.EmbedConnection@1585347198 (XID = 11609975), (SESSIONID = 1), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null) due to dirty commit state on close().
09:01:21    TRACE    org.openlca.core.database.NativeSql    execute query select d.id, d.ref_id, d.name, d.version, d.last_change, d.f_category, d.library, d.tags from tbl_projects d where d.f_category is null
09:01:21    TRACE    org.openlca.core.database.Derby    create connection: jdbc:derby:C:/Users/•/openLCA-data-1.4/databases/•
09:01:21    DEBUG    com.zaxxer.hikari.pool.ProxyConnection    HikariPool-1 - Executed rollback on connection org.apache.derby.impl.jdbc.EmbedConnection@1585347198 (XID = 11609975), (SESSIONID = 1), (DATABASE = C:/Users/•/openLCA-data-1.4/databases/•), (DRDAID = null) due to dirty commit state on close().
09:01:21    TRACE    org.openlca.app.App    execute UI job Update title(16)
09:01:46    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - Pool stats (total=10/10, idle=10/10, active=0, waiting=0)
09:01:46    DEBUG    com.zaxxer.hikari.pool.HikariPool    HikariPool-1 - Fill pool skipped, pool has sufficient level or currently being filled.
Based on Snow Theme - Modified by GreenDelta
Powered by Question2Answer
...