Roestlab / massdash

MassDash: A web-based dashboard for streamlined DIA-MS visualization, analysis, prototyping, and optimization
https://massdash.streamlit.app/
BSD 3-Clause "New" or "Revised" License
16 stars 3 forks source link

sqlite error when using streamlit caching #64

Closed singjc closed 6 months ago

singjc commented 6 months ago

The following error occurs when using an OSW file and streamlit caching

File "/media/justincsing/ExtraDrive1/Documents2/Roest_Lab/Github/MassSeer/massseer/loaders/access/OSWDataAccess.py", line 118, in _getFeaturesFromPrecursorIdAndRunDf
    if check_sqlite_table(self.conn, "SCORE_MS2"):
  File "/media/justincsing/ExtraDrive1/Documents2/Roest_Lab/Github/MassSeer/massseer/util.py", line 205, in check_sqlite_table
    c = con.cursor()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 140391240152640 and this is thread id 140391248545344.
singjc commented 6 months ago

Addressed with #65