N77生态保护和环境治理业
Traceback (most recent call last):
File "/usr/local/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 1958, in _exec_single_context
self.dialect.do_execute(
~~~~~~~~~~~~~~~~~~~~~~~^
cursor, str_statement, effective_parameters, context
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "/usr/local/lib/python3.14/site-packages/sqlalchemy/engine/default.py", line 1192, in do_execute
cursor.execute(statement, parameters)
~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.14/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/usr/local/lib/python3.14/site-packages/pymysql/cursors.py", line 335, in _query
conn.query(q)
~~~~~~~~~~^^^
File "/usr/local/lib/python3.14/site-packages/pymysql/connections.py", line 581, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.14/site-packages/pymysql/connections.py", line 857, in _read_query_result
result.read()
~~~~~~~~~~~^^
File "/usr/local/lib/python3.14/site-packages/pymysql/connections.py", line 1290, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.14/site-packages/pymysql/connections.py", line 810, in _read_packet
packet.raise_for_error()
~~~~~~~~~~~~~~~~~~~~~~^^
File "/usr/local/lib/python3.14/site-packages/pymysql/protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
File "/usr/local/lib/python3.14/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 "/usr/local/lib/python3.14/site-packages/pandas/io/sql.py", line 1733, in execute
return execute_function(sql, *args)
File "/usr/local/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 1770, in exec_driver_sql
ret = self._execute_context(
dialect,
...<5 lines>...
distilled_parameters,
)
File "/usr/local/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 1837, in _execute_context
return self._exec_single_context(
~~~~~~~~~~~~~~~~~~~~~~~~~^
dialect, context, statement, parameters
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "/usr/local/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 1977, in _exec_single_context
self._handle_dbapi_exception(
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
e, str_statement, effective_parameters, cursor, context
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "/usr/local/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 2347, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.14/site-packages/sqlalchemy/engine/base.py", line 1958, in _exec_single_context
self.dialect.do_execute(
~~~~~~~~~~~~~~~~~~~~~~~^
cursor, str_statement, effective_parameters, context
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "/usr/local/lib/python3.14/site-packages/sqlalchemy/engine/default.py", line 1192, in do_execute
cursor.execute(statement, parameters)
~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.14/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/usr/local/lib/python3.14/site-packages/pymysql/cursors.py", line 335, in _query
conn.query(q)
~~~~~~~~~~^^^
File "/usr/local/lib/python3.14/site-packages/pymysql/connections.py", line 581, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.14/site-packages/pymysql/connections.py", line 857, in _read_query_result
result.read()
~~~~~~~~~~~^^
File "/usr/local/lib/python3.14/site-packages/pymysql/connections.py", line 1290, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.14/site-packages/pymysql/connections.py", line 810, in _read_packet
packet.raise_for_error()
~~~~~~~~~~~~~~~~~~~~~~^^
File "/usr/local/lib/python3.14/site-packages/pymysql/protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
File "/usr/local/lib/python3.14/site-packages/pymysql/err.py", line 154, in raise_mysql_exception
raise errorclass(errno, errval, sqlstate=sqlstate)
sqlalchemy.exc.OperationalError: (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")')
[SQL: select * from `N77生态保护和环境治理业`]
(Background on this error at: https://sqlalche.me/e/21/e3q8)
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 "/usr/local/lib/python3.14/site-packages/pandas/io/sql.py", line 780, in read_sql
return pandas_sql.read_query(
~~~~~~~~~~~~~~~~~~~~~^
sql,
^^^^
...<6 lines>...
dtype=dtype,
^^^^^^^^^^^^
)
^
File "/usr/local/lib/python3.14/site-packages/pandas/io/sql.py", line 1910, in read_query
result = self.execute(sql, params)
File "/usr/local/lib/python3.14/site-packages/pandas/io/sql.py", line 1735, in execute
raise DatabaseError(f"Execution failed on sql '{sql}': {exc}") from exc
pandas.errors.DatabaseError: Execution failed on sql 'select * from `N77生态保护和环境治理业`': (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")')
[SQL: select * from `N77生态保护和环境治理业`]
(Background on this error at: https://sqlalche.me/e/21/e3q8)