openchatai / copilot

🤖 🔥 Language-to-actions engine
https://open.cx
MIT License
5.08k stars 399 forks source link

1049, "Unknown database 'opencopilot'" #721

Open mikeyang01 opened 7 months ago

mikeyang01 commented 7 months ago

i deploy the project to the vps server, one day later, the database was deleted. Is there any way to prevent the database from delete by someone?

File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__ raise exc_value.with_traceback(exc_tb) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 898, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 637, in connect return dialect.connect(*cargs, **cparams) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 616, in connect return self.loaded_dbapi.connect(*cargs, **cparams) File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 358, in __init__ self.connect() File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 664, in connect self._request_authentication() File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 976, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "/usr/local/lib/python3.9/site-packages/pymysql/_auth.py", line 240, in caching_sha2_password_auth pkt = conn._read_packet() File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 772, in _read_packet packet.raise_for_error() File "/usr/local/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/local/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1049, "Unknown database 'opencopilot'") (Background on this error at: https://sqlalche.me/e/20/e3q8) CleanShot 2024-03-25 at 16 39 54@2x

mikeyang01 commented 7 months ago

@gharbat I hope this message finds you well. I'm reaching out to you regarding this issue. We've encountered a challenge that I believe your expertise could greatly assist in resolving.

AhmedElyos commented 6 months ago

same problem here

ashu3103 commented 4 months ago

Same problem! I think the problem is with redis in worker node.

Here are the logs: Screenshot from 2024-07-14 22-15-55