activity-browser
activity-browser copied to clipboard
Ghost database created out of nowhere
Updating AB
- [X] Yes, I have updated AB and still experience this issue
What happened?
I encountered something that is very weird…
I cannot even properly reconstruct it, but it must have to do with the installation of a database going into a new thread or so.
I did a scenario LCA, for which the AB realized that it had to do some relinking (i.e. in the scenario file I pointed to a superstructure database, which I don’t have right now, so I re-linked it to ecoinvent 3.9.1). It calculated the scenario LCA alright.
But then, it also installed new database (!!). It looks like ecoinvent 3.9.1, but without a name. I do not recall it asking for it. But at some point I noticed that the relinking also opened not only one relinking dialogue, but a set of dialogues in parallel, which seemed to have been in a parallel thread. In the end I have this db now – very strange. @Zoophobus, I know this is a terrible description, but could you try importing the attached file against ecoinvent 3.9.1. and see if you get something similar?
Relevant errors
Loading Scenario file. This may take a while for large files
C:\Users\steub\miniconda3\envs\ab\lib\site-packages\activity_browser\bwutils\superstructure\excel.py:86: FutureWarning: DataFrame.applymap has been deprecated. Use DataFrame.map instead.
data.loc[:, columns] = data[columns].applymap(convert_tuple_str)
Traceback (most recent call last):
File "C:\Users\steub\miniconda3\envs\ab\lib\site-packages\activity_browser\ui\tables\delegates\checkbox.py", line 22, in paint
painter.save()
AttributeError: 'PySide2.QtGui.QResizeEvent' object has no attribute 'save'
Traceback (most recent call last):
File "C:\Users\steub\miniconda3\envs\ab\lib\site-packages\activity_browser\ui\tables\delegates\checkbox.py", line 22, in paint
painter.save()
AttributeError: 'PySide2.QtGui.QResizeEvent' object has no attribute 'save'
Traceback (most recent call last):
File "C:\Users\steub\miniconda3\envs\ab\lib\site-packages\activity_browser\ui\tables\delegates\checkbox.py", line 22, in paint
painter.save()
AttributeError: 'PySide2.QtGui.QResizeEvent' object has no attribute 'save'
Traceback (most recent call last):
File "C:\Users\steub\miniconda3\envs\ab\lib\site-packages\activity_browser\ui\tables\delegates\checkbox.py", line 22, in paint
painter.save()
AttributeError: 'PySide2.QtGui.QResizeEvent' object has no attribute 'save'
Traceback (most recent call last):
File "C:\Users\steub\miniconda3\envs\ab\lib\site-packages\activity_browser\ui\tables\delegates\checkbox.py", line 22, in paint
painter.save()
AttributeError: 'PySide2.QtGui.QResizeEvent' object has no attribute 'save'
Traceback (most recent call last):
File "C:\Users\steub\miniconda3\envs\ab\lib\site-packages\activity_browser\ui\tables\delegates\checkbox.py", line 22, in paint
painter.save()
AttributeError: 'PySide2.QtGui.QResizeEvent' object has no attribute 'save'
C:\Users\steub\miniconda3\envs\ab\lib\site-packages\activity_browser\bwutils\superstructure\dataframe.py:142: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`
ds_.loc[col] = (key['database'][0], key['code'][0]) if j == 0 else key['database'][0]
1.0<function ScenarioImportWidget.scenario_db_check at 0x000002363CEB7EE0> -- 3.3886168003082275
<function SuperstructureManager.fill_empty_process_keys_in_exchanges at 0x00000236383115E0> -- 0.0
<function SuperstructureManager.verify_scenario_process_keys at 0x0000023638311700> -- 0.009251594543457031
<function SuperstructureManager.check_duplicates at 0x0000023638311940> -- 0.0010173320770263672
<function SuperstructureManager.check_scenario_exchange_values at 0x0000023638311820> -- 0.001001119613647461
<function SuperstructureManager.merge_flows_to_self at 0x0000023638311310> -- 0.005011320114135742
<function ScenarioImportWidget.sync_superstructure at 0x000002363CEB7DC0> -- 3.4768824577331543
<function ScenarioImportWidget.load_action at 0x000002363CEB7CA0> -- 9.98945951461792
+showing tab:LCA results
Extracted 21238 datasets in 398.75 seconds
Applying strategy: normalize_units
Applying strategy: update_ecoinvent_locations
Applying strategy: remove_zero_amount_coproducts
Applying strategy: remove_zero_amount_inputs_with_no_activity
Applying strategy: remove_unnamed_parameters
Applying strategy: es2_assign_only_product_with_amount_as_reference_product
Applying strategy: assign_single_product_as_activity
Applying strategy: create_composite_code
Applying strategy: drop_unspecified_subcategories
Applying strategy: fix_ecoinvent_flows_pre35
Applying strategy: drop_temporary_outdated_biosphere_flows
Applying strategy: link_biosphere_by_flow_uuid
Applying strategy: link_internal_technosphere_by_composite_code
Applying strategy: delete_exchanges_missing_activity
Applying strategy: delete_ghost_exchanges
Applying strategy: remove_uncertainty_from_negative_loss_exchanges
Applying strategy: fix_unreasonably_high_lognormal_uncertainties
Applying strategy: convert_activity_parameters_to_list
Applying strategy: add_cpc_classification_from_single_reference_product
Applying strategy: delete_none_synonyms
Applying strategy: set_lognormal_loc_value
Applied 21 strategies in 9.21 seconds
Writing activities to SQLite3 database:
0% [##############################] 100% | ETA: 00:00:00
Total time elapsed: 00:00:56
Title: Writing activities to SQLite3 database:
Started: 10/13/2023 17:29:55
Finished: 10/13/2023 17:30:52
Total time elapsed: 00:00:56
CPU %: 100.20
Memory %: 13.49
Created database:
Reset project settings directory to:C:\Users\steub\OneDrive - Universiteit Leiden\Brightway3\ei391.d59e0d309e8ebcc899228a6029307b93
Operating system
Windows 10
Conda environment
# packages in environment at C:\Users\steub\miniconda3\envs\ab:
#
# Name Version Build Channel
ab-plugin-scenariolink 0.0.4 py_0 romainsacchi
activity-browser 2.9.1 pyhd8ed1ab_0 conda-forge
appdirs 1.4.4 pyh9f0ad1d_0 conda-forge
arrow 1.3.0 pyhd8ed1ab_0 conda-forge
asteval 0.9.31 pyhd8ed1ab_0 conda-forge
astunparse 1.6.3 pyhd8ed1ab_0 conda-forge
attrs 23.1.0 pyh71513ae_1 conda-forge
backports 1.0 pyhd8ed1ab_3 conda-forge
backports.functools_lru_cache 1.6.5 pyhd8ed1ab_0 conda-forge
blinker 1.6.3 pyhd8ed1ab_0 conda-forge
boto3 1.28.62 pyhd8ed1ab_0 conda-forge
botocore 1.31.62 pyhd8ed1ab_0 conda-forge
brightway2 2.4.4 pyhd8ed1ab_0 conda-forge
brotli 1.1.0 hcfcfb64_1 conda-forge
brotli-bin 1.1.0 hcfcfb64_1 conda-forge
brotli-python 1.1.0 py39h99910a6_1 conda-forge
brotlicffi 1.1.0.0 py39h99910a6_1 conda-forge
bw2analyzer 0.10 pyhd8ed1ab_0 conda-forge
bw2calc 1.8.2 py39hcbf5309_0 conda-forge
bw2data 3.6.6 pyhd8ed1ab_0 conda-forge
bw2io 0.8.10 pyhd8ed1ab_0 conda-forge
bw2parameters 1.1.0 pyhd8ed1ab_0 conda-forge
bw_migrations 0.2 pyhd8ed1ab_0 conda-forge
bzip2 1.0.8 h8ffe710_4 conda-forge
ca-certificates 2023.7.22 h56e8100_0 conda-forge
cached-property 1.5.2 hd8ed1ab_1 conda-forge
cached_property 1.5.2 pyha770c72_1 conda-forge
cchardet 2.1.7 py39h99910a6_5 conda-forge
certifi 2023.7.22 pyhd8ed1ab_0 conda-forge
cffi 1.16.0 py39ha55989b_0 conda-forge
chardet 5.2.0 py39hcbf5309_1 conda-forge
charset-normalizer 3.3.0 pyhd8ed1ab_0 conda-forge
click 8.1.7 win_pyh7428d3b_0 conda-forge
colorama 0.4.6 pyhd8ed1ab_0 conda-forge
constructive_geometries 0.8.2 pyhd8ed1ab_0 conda-forge
contourpy 1.1.1 py39h1f6ef14_1 conda-forge
country_converter 1.0.0 pyhd8ed1ab_1 conda-forge
cycler 0.12.1 pyhd8ed1ab_0 conda-forge
datapackage 1.15.2 pyh44b312d_0 conda-forge
dill 0.3.7 pyhd8ed1ab_0 conda-forge
docopt 0.6.2 py_1 conda-forge
eidl 2.0.1 pyhd8ed1ab_0 conda-forge
eight 1.0.1 pyhd8ed1ab_4 conda-forge
et_xmlfile 1.1.0 pyhd8ed1ab_0 conda-forge
fasteners 0.17.3 pyhd8ed1ab_0 conda-forge
flask 3.0.0 pyhd8ed1ab_0 conda-forge
fonttools 4.43.1 py39ha55989b_0 conda-forge
freetype 2.12.1 hdaf720e_2 conda-forge
future 0.18.3 pyhd8ed1ab_0 conda-forge
gettext 0.21.1 h5728263_0 conda-forge
glib 2.78.0 h12be248_0 conda-forge
glib-tools 2.78.0 h12be248_0 conda-forge
greenlet 3.0.0 py39h99910a6_1 conda-forge
gst-plugins-base 1.22.6 h001b923_2 conda-forge
gstreamer 1.22.6 hb4038d2_2 conda-forge
icu 72.1 h63175ca_0 conda-forge
idna 3.4 pyhd8ed1ab_0 conda-forge
ijson 3.2.3 pyhd8ed1ab_0 conda-forge
importlib-metadata 6.8.0 pyha770c72_0 conda-forge
importlib-resources 6.1.0 pyhd8ed1ab_0 conda-forge
importlib_metadata 6.8.0 hd8ed1ab_0 conda-forge
importlib_resources 6.1.0 pyhd8ed1ab_0 conda-forge
inflate64 0.3.1 py39ha55989b_4 conda-forge
intel-openmp 2023.2.0 h57928b3_50496 conda-forge
isodate 0.6.1 pyhd8ed1ab_0 conda-forge
itsdangerous 2.1.2 pyhd8ed1ab_0 conda-forge
jinja2 3.1.2 pyhd8ed1ab_1 conda-forge
jmespath 1.0.1 pyhd8ed1ab_0 conda-forge
jsonlines 4.0.0 pyhd8ed1ab_0 conda-forge
jsonpointer 2.4 py39hcbf5309_3 conda-forge
jsonschema 4.19.1 pyhd8ed1ab_0 conda-forge
jsonschema-specifications 2023.7.1 pyhd8ed1ab_0 conda-forge
kiwisolver 1.4.5 py39h1f6ef14_1 conda-forge
krb5 1.20.1 heb0366b_0 conda-forge
lcms2 2.15 he9d350c_2 conda-forge
lerc 4.0.0 h63175ca_0 conda-forge
libblas 3.9.0 18_win64_mkl conda-forge
libbrotlicommon 1.1.0 hcfcfb64_1 conda-forge
libbrotlidec 1.1.0 hcfcfb64_1 conda-forge
libbrotlienc 1.1.0 hcfcfb64_1 conda-forge
libcblas 3.9.0 18_win64_mkl conda-forge
libclang 16.0.3 default_h8b4101f_1 conda-forge
libclang13 16.0.3 default_h45d3cf4_1 conda-forge
libdeflate 1.19 hcfcfb64_0 conda-forge
libffi 3.4.2 h8ffe710_5 conda-forge
libglib 2.78.0 he8f3873_0 conda-forge
libiconv 1.17 h8ffe710_0 conda-forge
libjpeg-turbo 2.1.5.1 hcfcfb64_1 conda-forge
liblapack 3.9.0 18_win64_mkl conda-forge
libogg 1.3.4 h8ffe710_1 conda-forge
libpng 1.6.39 h19919ed_0 conda-forge
libsqlite 3.43.2 hcfcfb64_0 conda-forge
libtiff 4.6.0 h4554b19_1 conda-forge
libvorbis 1.3.7 h0e60522_0 conda-forge
libwebp 1.3.2 hcfcfb64_1 conda-forge
libwebp-base 1.3.2 hcfcfb64_0 conda-forge
libxcb 1.15 hcd874cb_0 conda-forge
libxml2 2.10.4 hc3477c8_0 conda-forge
libxslt 1.1.37 h0192164_0 conda-forge
libzlib 1.2.13 hcfcfb64_5 conda-forge
linear-tsv 1.1.0 py_1 conda-forge
llvmlite 0.40.1 py39hd28a505_0 conda-forge
lxml 4.9.2 py39h0942119_0 conda-forge
m2w64-gcc-libgfortran 5.3.0 6 conda-forge
m2w64-gcc-libs 5.3.0 7 conda-forge
m2w64-gcc-libs-core 5.3.0 7 conda-forge
m2w64-gmp 6.1.0 2 conda-forge
m2w64-libwinpthread-git 5.0.0.4634.697f757 2 conda-forge
markupsafe 2.1.3 py39ha55989b_1 conda-forge
matplotlib-base 3.8.0 py39hf19769e_2 conda-forge
mkl 2022.1.0 h6a75c08_874 conda-forge
mrio_common_metadata 0.2.1 pyhd8ed1ab_0 conda-forge
msys2-conda-epoch 20160418 1 conda-forge
multiprocess 0.70.15 py39ha55989b_1 conda-forge
multivolumefile 0.2.3 pyhd8ed1ab_0 conda-forge
munkres 1.1.4 pyh9f0ad1d_0 conda-forge
networkx 3.1 pyhd8ed1ab_0 conda-forge
numba 0.57.1 py39hadaa1c4_0 conda-forge
numpy 1.23.5 py39hbccbffa_0 conda-forge
openjpeg 2.5.0 h3d672ee_3 conda-forge
openpyxl 3.1.2 py39ha55989b_1 conda-forge
openssl 3.1.3 hcfcfb64_0 conda-forge
packaging 23.2 pyhd8ed1ab_0 conda-forge
pandas 2.1.1 py39h32e6231_1 conda-forge
pathos 0.3.1 pyhd8ed1ab_0 conda-forge
patsy 0.5.3 pyhd8ed1ab_0 conda-forge
pcre2 10.40 h17e33f8_0 conda-forge
peewee 3.16.3 py39habf9222_1 conda-forge
pillow 10.0.1 py39h6ef006c_1 conda-forge
pint 0.21 pyhd8ed1ab_0 conda-forge
pip 23.2.1 pyhd8ed1ab_0 conda-forge
pkgutil-resolve-name 1.3.10 pyhd8ed1ab_1 conda-forge
pox 0.3.3 pyhd8ed1ab_0 conda-forge
ppft 1.7.6.7 pyhd8ed1ab_0 conda-forge
prettytable 3.9.0 pyhd8ed1ab_0 conda-forge
psutil 5.9.5 py39ha55989b_1 conda-forge
pthread-stubs 0.4 hcd874cb_1001 conda-forge
py7zr 0.20.6 pyhd8ed1ab_0 conda-forge
pybcj 1.0.1 py39ha55989b_3 conda-forge
pycparser 2.21 pyhd8ed1ab_0 conda-forge
pycryptodomex 3.19.0 py39ha55989b_1 conda-forge
pypardiso 0.4.2 pyhd8ed1ab_1 conda-forge
pyparsing 3.1.1 pyhd8ed1ab_0 conda-forge
pyperclip 1.8.2 pyhd8ed1ab_2 conda-forge
pyppmd 1.0.0 py39h99910a6_2 conda-forge
pyprind 2.11.2 py39hcbf5309_1005 conda-forge
pyside2 5.15.8 py39h56cbfbc_2 conda-forge
pysocks 1.7.1 pyh0701188_6 conda-forge
python 3.9.18 h4de0772_0_cpython conda-forge
python-dateutil 2.8.2 pyhd8ed1ab_0 conda-forge
python-json-logger 2.0.7 pyhd8ed1ab_0 conda-forge
python-tzdata 2023.3 pyhd8ed1ab_0 conda-forge
python_abi 3.9 4_cp39 conda-forge
pytz 2023.3.post1 pyhd8ed1ab_0 conda-forge
pyxlsb 1.0.10 pyhd8ed1ab_0 conda-forge
pyyaml 6.0.1 py39ha55989b_1 conda-forge
pyzstd 0.15.9 py39h95af829_1 conda-forge
qt-main 5.15.8 h2c8576c_11 conda-forge
qt-webengine 5.15.8 h5b1ea0b_0 conda-forge
referencing 0.30.2 pyhd8ed1ab_0 conda-forge
requests 2.31.0 pyhd8ed1ab_0 conda-forge
rfc3986 2.0.0 pyhd8ed1ab_0 conda-forge
rpds-py 0.10.6 py39hf21820d_0 conda-forge
s3transfer 0.7.0 pyhd8ed1ab_0 conda-forge
salib 1.4.7 pyhd8ed1ab_0 conda-forge
scipy 1.11.3 py39hddb5d58_1 conda-forge
seaborn 0.13.0 hd8ed1ab_0 conda-forge
seaborn-base 0.13.0 pyhd8ed1ab_0 conda-forge
setuptools 68.2.2 pyhd8ed1ab_0 conda-forge
setuptools-scm 8.0.4 pyhd8ed1ab_0 conda-forge
six 1.16.0 pyh6c4a22f_0 conda-forge
sparse 0.14.0 pyhd8ed1ab_0 conda-forge
sqlalchemy 2.0.21 py39ha55989b_1 conda-forge
stats_arrays 0.6.5 pyhd8ed1ab_0 conda-forge
statsmodels 0.14.0 py39hd88c2e4_2 conda-forge
tableschema 1.19.3 pyh9f0ad1d_0 conda-forge
tabulate 0.9.0 pyhd8ed1ab_1 conda-forge
tabulator 1.53.5 pyhd8ed1ab_0 conda-forge
tbb 2021.7.0 h91493d7_0 conda-forge
texttable 1.7.0 pyhd8ed1ab_0 conda-forge
tk 8.6.13 hcfcfb64_0 conda-forge
tomli 2.0.1 pyhd8ed1ab_0 conda-forge
toolz 0.12.0 pyhd8ed1ab_0 conda-forge
tqdm 4.66.1 pyhd8ed1ab_0 conda-forge
types-python-dateutil 2.8.19.14 pyhd8ed1ab_0 conda-forge
typing-extensions 4.8.0 hd8ed1ab_0 conda-forge
typing_extensions 4.8.0 pyha770c72_0 conda-forge
tzdata 2023c h71feb2d_0 conda-forge
ucrt 10.0.22621.0 h57928b3_0 conda-forge
unfold 2023.10.07 py_0 romainsacchi
unicodecsv 0.14.1 py_1 conda-forge
unicodedata2 15.1.0 py39ha55989b_0 conda-forge
unidecode 1.3.7 pyhd8ed1ab_0 conda-forge
urllib3 1.26.17 pyhd8ed1ab_0 conda-forge
vc 14.3 h64f974e_17 conda-forge
vc14_runtime 14.36.32532 hdcecf7f_17 conda-forge
voluptuous 0.13.1 pyhd8ed1ab_0 conda-forge
vs2015_runtime 14.36.32532 h05e6639_17 conda-forge
wcwidth 0.2.8 pyhd8ed1ab_0 conda-forge
werkzeug 3.0.0 pyhd8ed1ab_0 conda-forge
wheel 0.41.2 pyhd8ed1ab_0 conda-forge
whoosh 2.7.4 py39hcbf5309_8 conda-forge
win_inet_pton 1.1.0 pyhd8ed1ab_6 conda-forge
wrapt 1.15.0 py39ha55989b_1 conda-forge
wurst 0.3.4 pyhd8ed1ab_0 conda-forge
xlrd 2.0.1 pyhd8ed1ab_3 conda-forge
xlsxwriter 3.1.7 pyhd8ed1ab_0 conda-forge
xorg-libxau 1.0.11 hcd874cb_0 conda-forge
xorg-libxdmcp 1.1.3 hcd874cb_0 conda-forge
xz 5.2.6 h8d14728_0 conda-forge
yaml 0.2.5 h8ffe710_2 conda-forge
zipfile-deflate64 0.2.0 py39ha55989b_4 conda-forge
zipp 3.17.0 pyhd8ed1ab_0 conda-forge
zstd 1.5.5 h12be248_0 conda-forge
@bsteubing Sorry I don't see the attached file, could you maybe attach it again?
closing as not replicable