search

LCA-ActivityBrowser / activity-browser

GUI for brightway2
GNU Lesser General Public License v3.0
140 stars 54 forks source link

Ghost database created out of nowhere #1072

Closed bsteubing closed 2 months ago

bsteubing commented 10 months ago

Updating AB

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?

image

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
Zoophobus commented 10 months ago

@bsteubing Sorry I don't see the attached file, could you maybe attach it again?

marc-vdm commented 2 months ago

closing as not replicable