st.cache error

[HongLouyemeng]

AttributeError: 'QueuePool' object has no attribute '_pool'
Traceback:
File "c:\python3.6.5\lib\site-packages\streamlit\script_runner.py", line 332, in _run_script
exec(code, module.dict)
File "D:\pycharm_workspace\weather_test\study_clode.py", line 105, in
df=get_data(farm_id, start_time, end_time, engine)
File "c:\python3.6.5\lib\site-packages\streamlit\caching.py", line 604, in wrapped_func
return get_or_create_cached_value()
File "c:\python3.6.5\lib\site-packages\streamlit\caching.py", line 586, in get_or_create_cached_value
return_value = func(*args, **kwargs)
File "D:\pycharm_workspace\weather_test\study_clode.py", line 29, in get_data
power_data = load_train.get_power_data()
File "D:\pycharm_workspace\weather_test\Data_Process.py", line 55, in get_power_data
mysql_power = pd.read_sql_query(sql_power, self.engine)
File "c:\python3.6.5\lib\site-packages\pandas\io\sql.py", line 332, in read_sql_query
chunksize=chunksize,
File "c:\python3.6.5\lib\site-packages\pandas\io\sql.py", line 1218, in read_query
result = self.execute(*args)
File "c:\python3.6.5\lib\site-packages\pandas\io\sql.py", line 1087, in execute
return self.connectable.execute(*args, **kwargs)
File "c:\python3.6.5\lib\site-packages\sqlalchemy\engine\base.py", line 2236, in execute
connection = self._contextual_connect(close_with_result=True)
File "c:\python3.6.5\lib\site-packages\sqlalchemy\engine\base.py", line 2304, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "c:\python3.6.5\lib\site-packages\sqlalchemy\engine\base.py", line 2338, in _wrap_pool_connect
return fn()
File "c:\python3.6.5\lib\site-packages\sqlalchemy\pool\base.py", line 364, in connect
return _ConnectionFairy._checkout(self)
File "c:\python3.6.5\lib\site-packages\sqlalchemy\pool\base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "c:\python3.6.5\lib\site-packages\sqlalchemy\pool\base.py", line 495, in checkout
rec = pool._do_get()
File "c:\python3.6.5\lib\site-packages\sqlalchemy\pool\impl.py", line 118, in _do_get
return self._pool.get(wait, self._timeout)

[theresa-salud]

I'm experiencing the same issue -- has there been a solution?

[HongLouyemeng]

hello , Maybe you need Chrome. I forgot how I solved the problem.

…

------------------&nbsp;原始邮件&nbsp;------------------ 发件人: "streamlit/streamlit" <notifications@github.com&gt;; 发送时间:&nbsp;2021年2月25日(星期四) 中午11:49 收件人:&nbsp;"streamlit/streamlit"<streamlit@noreply.github.com&gt;; 抄送:&nbsp;"happy_boy"<756745172@qq.com&gt;;"Author"<author@noreply.github.com&gt;; 主题:&nbsp;Re: [streamlit/streamlit] st.cache error (#2409) I'm experiencing the same issue -- has there been a solution? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[So-ham]

Facing the same issue. Please help!

[HongLouyemeng]

我遇到了同样的问题-有解决方案吗？

from cachetools import cached

[HongLouyemeng]

面对同样的问题。请帮忙！

from cachetools import cached