M

daemon

N77生态保护和环境治理业

Traceback (most recent call last):

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context

self.dialect.do_execute(

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute

cursor.execute(statement, parameters)

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/cursors.py", line 159, in execute

result = self._query(query)

^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/cursors.py", line 330, in _query

conn.query(q)

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 582, in query

self._affected_rows = self._read_query_result(unbuffered=unbuffered)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 847, in _read_query_result

result.read()

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 1245, in read

first_packet = self.connection._read_packet()

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 803, in _read_packet

packet.raise_for_error()

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/protocol.py", line 219, in raise_for_error

err.raise_mysql_exception(self._data)

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/err.py", line 154, in raise_mysql_exception

raise errorclass(errno, errval, sqlstate=sqlstate)

pymysql.err.OperationalError: (1017, 'Can\'t find file: \'./hy/n77@751f@6001@4fdd@62a4@548c@73af@5883@6cbb@7406@4e1a.MYI\' (errno: 2 "No such file or directory")')

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

File "/Volumes/TIME/M/getindustry.py", line 331, in

drawcandle(selected.columns[0])

File "/Volumes/TIME/M/getindustry.py", line 24, in drawcandle

stock = pd.read_sql("select * from `"+data+"`", conn)#read_csv(data+".csv",header=0)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pandas/io/sql.py", line 736, in read_sql

return pandas_sql.read_query(

^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pandas/io/sql.py", line 1848, in read_query

result = self.execute(sql, params)

^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pandas/io/sql.py", line 1671, in execute

return self.con.exec_driver_sql(sql, *args)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1781, in exec_driver_sql

ret = self._execute_context(

^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1848, in _execute_context

return self._exec_single_context(

^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1988, in _exec_single_context

self._handle_dbapi_exception(

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2365, in _handle_dbapi_exception

raise sqlalchemy_exception.with_traceback(exc_info[2]) from e