search

netease-youdao / QAnything

Question and Answer based on Anything.
https://qanything.ai
GNU Affero General Public License v3.0
11.86k stars 1.15k forks source link

关于2.0无法启动的一点解决办法 #529

Open fjzuser opened 1 month ago

fjzuser commented 1 month ago

是否已有关于该错误的issue或讨论？ | Is there an existing issue / discussion for this?

该问题是否在FAQ中有解答？ | Is there an existing answer for this in FAQ?

当前行为 | Current Behavior

2.0在wsl和docker desktop都存在无法启动问题，wsl中是mysql服务挂载的一个文件无法设置权限导致mysql服务无法启动；目前还不知道如何解决；各种无法启动的原因主要是内存不够，建议32G以上；windows下用docker建议wsl配置的内存改为32G，可以正常用2.0 纯linux下32G内存也可以正常使用。 另外希望官方给出用GPU的配置，以及纯python安装的方式，就像老版本那样

期望行为 | Expected Behavior

No response

运行环境 | Environment

- OS:
- NVIDIA Driver:
- CUDA:
- Docker Compose:
- NVIDIA GPU Memory:

QAnything日志 | QAnything logs

No response

复现方法 | Steps To Reproduce

No response

备注 | Anything else?

No response

prettyprettyboy commented 1 month ago

同问，mysql启动不了

2024-09-24 22:37:25 2024-09-24 14:37:25+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
2024-09-24 22:37:27 2024-09-24 14:37:27+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-09-24 22:37:27 2024-09-24 14:37:27+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
2024-09-24 22:37:27 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-09-24 22:37:27 2024-09-24T14:37:27.770851Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-09-24 22:37:27 2024-09-24T14:37:27.955732Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.2) starting as process 1
2024-09-24 22:37:27 2024-09-24T14:37:27.960758Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2024-09-24 22:37:27 2024-09-24T14:37:27.970430Z 0 [Warning] [MY-000054] [Server] World-writable config file '/var/lib/mysql/auto.cnf' is ignored.
2024-09-24 22:37:27 2024-09-24T14:37:27.971639Z 0 [Warning] [MY-010107] [Server] World-writable config file '/var/lib/mysql/auto.cnf' has been removed.
2024-09-24 22:37:27 2024-09-24T14:37:27.972576Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 85bad2f0-7a82-11ef-890c-0242ac120003.
2024-09-24 22:37:27 2024-09-24T14:37:27.984956Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-09-24 22:37:28 2024-09-24T14:37:28.574635Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 5.7.18, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.4/en/upgrading.html
2024-09-24 22:37:28 2024-09-24T14:37:28.574665Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-09-24 22:37:28 2024-09-24T14:37:28.819077Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-09-24 22:37:28 2024-09-24T14:37:28.819197Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-09-24 22:37:28 2024-09-24T14:37:28.819216Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-09-24 22:37:28 2024-09-24T14:37:28.820315Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.2)  MySQL Community Server - GPL.
2024-09-24 22:37:28 2024-09-24T14:37:28.820350Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-09-24 22:37:40 2024-09-24 14:37:40+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
2024-09-24 22:37:42 2024-09-24 14:37:42+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-09-24 22:37:42 2024-09-24 14:37:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
2024-09-24 22:37:42 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-09-24 22:50:37 2024-09-24 14:50:37+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
2024-09-24 22:50:38 2024-09-24 14:50:38+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-09-24 22:50:38 2024-09-24 14:50:38+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
2024-09-24 22:50:38 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-09-24 22:57:59 2024-09-24 14:57:59+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
2024-09-24 22:58:00 2024-09-24 14:58:00+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-09-24 22:58:00 2024-09-24 14:58:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
2024-09-24 22:58:01 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-09-24 22:37:42 2024-09-24T14:37:42.589211Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-09-24 22:37:42 2024-09-24T14:37:42.789161Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.2) starting as process 1
2024-09-24 22:37:42 2024-09-24T14:37:42.795055Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2024-09-24 22:37:42 2024-09-24T14:37:42.804858Z 0 [Warning] [MY-000054] [Server] World-writable config file '/var/lib/mysql/auto.cnf' is ignored.
2024-09-24 22:37:42 2024-09-24T14:37:42.806533Z 0 [Warning] [MY-010107] [Server] World-writable config file '/var/lib/mysql/auto.cnf' has been removed.
2024-09-24 22:37:42 2024-09-24T14:37:42.807439Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8e9271ce-7a82-11ef-88a2-0242ac120003.
2024-09-24 22:37:42 2024-09-24T14:37:42.822909Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-09-24 22:37:43 2024-09-24T14:37:43.485539Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 5.7.18, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.4/en/upgrading.html
2024-09-24 22:37:43 2024-09-24T14:37:43.485582Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-09-24 22:37:43 2024-09-24T14:37:43.687707Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-09-24 22:37:43 2024-09-24T14:37:43.687832Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-09-24 22:37:43 2024-09-24T14:37:43.687854Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-09-24 22:37:43 2024-09-24T14:37:43.689359Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.2)  MySQL Community Server - GPL.
2024-09-24 22:37:43 2024-09-24T14:37:43.689379Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-09-24 22:50:39 2024-09-24T14:50:38.771171Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-09-24 22:50:39 2024-09-24T14:50:39.021932Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.2) starting as process 1
2024-09-24 22:50:39 2024-09-24T14:50:39.025431Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2024-09-24 22:50:39 2024-09-24T14:50:39.037569Z 0 [Warning] [MY-000054] [Server] World-writable config file '/var/lib/mysql/auto.cnf' is ignored.
2024-09-24 22:50:39 2024-09-24T14:50:39.038079Z 0 [Warning] [MY-010107] [Server] World-writable config file '/var/lib/mysql/auto.cnf' has been removed.
2024-09-24 22:50:39 2024-09-24T14:50:39.039040Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 5d3dfcb6-7a84-11ef-88b7-0242ac120002.
2024-09-24 22:50:39 2024-09-24T14:50:39.050570Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-09-24 22:50:39 2024-09-24T14:50:39.462586Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 5.7.18, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.4/en/upgrading.html
2024-09-24 22:50:39 2024-09-24T14:50:39.462614Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-09-24 22:50:39 2024-09-24T14:50:39.760803Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-09-24 22:50:39 2024-09-24T14:50:39.761128Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-09-24 22:50:39 2024-09-24T14:50:39.761214Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-09-24 22:50:39 2024-09-24T14:50:39.769483Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.2)  MySQL Community Server - GPL.
2024-09-24 22:50:39 2024-09-24T14:50:39.769514Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-09-24 22:58:01 2024-09-24T14:58:01.057031Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-09-24 22:58:01 2024-09-24T14:58:01.232410Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.2) starting as process 1
2024-09-24 22:58:01 2024-09-24T14:58:01.236326Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2024-09-24 22:58:01 2024-09-24T14:58:01.245728Z 0 [Warning] [MY-000054] [Server] World-writable config file '/var/lib/mysql/auto.cnf' is ignored.
2024-09-24 22:58:01 2024-09-24T14:58:01.246390Z 0 [Warning] [MY-010107] [Server] World-writable config file '/var/lib/mysql/auto.cnf' has been removed.
2024-09-24 22:58:01 2024-09-24T14:58:01.246888Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 64d18d23-7a85-11ef-88d0-0242ac120004.
2024-09-24 22:58:01 2024-09-24T14:58:01.262125Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-09-24 22:58:02 2024-09-24T14:58:02.586047Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-09-24 22:58:02 mysqld: Table 'mysql.plugin' doesn't exist
2024-09-24 22:58:02 2024-09-24T14:58:02.729172Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2024-09-24 22:58:02 2024-09-24T14:58:02.729307Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:02 2024-09-24T14:58:02.729391Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:02 2024-09-24T14:58:02.729467Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:02 2024-09-24T14:58:02.729581Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:02 2024-09-24T14:58:02.729660Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:02 2024-09-24T14:58:02.729728Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:02 2024-09-24T14:58:02.729793Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:02 2024-09-24T14:58:02.826900Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-09-24 22:58:02 2024-09-24T14:58:02.932528Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-09-24 22:58:02 2024-09-24T14:58:02.960519Z 0 [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_main. See below for the description of exact issue.
2024-09-24 22:58:02 2024-09-24T14:58:02.960551Z 0 [Warning] [MY-010069] [Server] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2024-09-24 22:58:03 mysqld: Cannot change permissions of the file 'private_key.pem.temp' (OS errno 1 - Operation not permitted)
2024-09-24 22:58:03 2024-09-24T14:58:03.091708Z 0 [ERROR] [MY-010295] [Server] Could not set file permission for private_key.pem
2024-09-24 22:58:03 2024-09-24T14:58:03.091730Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-09-24 22:58:04 2024-09-24T14:58:04.548341Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.2)  MySQL Community Server - GPL.
2024-09-24 22:58:04 2024-09-24T14:58:04.548367Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-09-24 22:58:20 2024-09-24T14:58:20.384015Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-09-24 22:58:20 2024-09-24T14:58:20.575574Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.2) starting as process 1
2024-09-24 22:58:20 2024-09-24T14:58:20.582251Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2024-09-24 22:58:20 2024-09-24T14:58:20.591663Z 0 [Warning] [MY-000054] [Server] World-writable config file '/var/lib/mysql/auto.cnf' is ignored.
2024-09-24 22:58:20 2024-09-24T14:58:20.593209Z 0 [Warning] [MY-010107] [Server] World-writable config file '/var/lib/mysql/auto.cnf' has been removed.
2024-09-24 22:58:20 2024-09-24T14:58:20.593873Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 7059a9af-7a85-11ef-8777-0242ac120004.
2024-09-24 22:58:20 2024-09-24T14:58:20.604108Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-09-24 22:58:22 2024-09-24T14:58:22.219694Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-09-24 22:58:22 mysqld: Table 'mysql.plugin' doesn't exist
2024-09-24 22:58:22 2024-09-24T14:58:22.454741Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2024-09-24 22:58:22 2024-09-24T14:58:22.454888Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:22 2024-09-24T14:58:22.454983Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:22 2024-09-24T14:58:22.455068Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:22 2024-09-24T14:58:22.455188Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:22 2024-09-24T14:58:22.455255Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:22 2024-09-24T14:58:22.455322Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:22 2024-09-24T14:58:22.455387Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-09-24 22:58:22 2024-09-24T14:58:22.527980Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-09-24 22:58:22 2024-09-24T14:58:22.665065Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-09-24 22:58:22 2024-09-24T14:58:22.693616Z 0 [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_main. See below for the description of exact issue.
2024-09-24 22:58:22 2024-09-24T14:58:22.693652Z 0 [Warning] [MY-010069] [Server] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2024-09-24 22:58:22 mysqld: Cannot change permissions of the file 'private_key.pem.temp' (OS errno 1 - Operation not permitted)
2024-09-24 22:58:22 2024-09-24T14:58:22.739381Z 0 [ERROR] [MY-010295] [Server] Could not set file permission for private_key.pem
2024-09-24 22:58:22 2024-09-24T14:58:22.739404Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-09-24 22:58:24 2024-09-24T14:58:24.307029Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.2)  MySQL Community Server - GPL.
2024-09-24 22:58:24 2024-09-24T14:58:24.307060Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-09-24 22:58:18 2024-09-24 14:58:18+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
2024-09-24 22:58:20 2024-09-24 14:58:20+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-09-24 22:58:20 2024-09-24 14:58:20+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
2024-09-24 22:58:20 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
foxworld306 commented 1 month ago

感谢，看来还是要在服务器上部署，个人电脑16G焊死了

prettyprettyboy commented 1 month ago

我发现wsl中是mysql服务挂载的一个文件无法设置权限导致mysql服务无法启动的问题可以修改挂载路径解决

xixihahaliu commented 1 month ago

@prettyprettyboy 请问你指的修改挂载路径的方式可以提PR吗？我们内部无法复现，另外下一个版本更新将会提供纯python的安装方式（without es），gpu版本也将尽快提供

prettyprettyboy commented 1 month ago

修改后貌似还是有问题