Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

连接池启动后自动退出 #35

Closed
no-serve-people opened this issue Jan 12, 2019 · 5 comments
Closed

连接池启动后自动退出 #35

no-serve-people opened this issue Jan 12, 2019 · 5 comments
Assignees

Comments

@no-serve-people
Copy link
Contributor

Describe Your Environment (描述你的环境)

  • System:
  • PHP version: 7.1.24
  • Swoole version: 4.2.11
  • SMProxy version: v1.2.6

How to Reproduce the Problem? (如何重现问题)

  1. 执行 start后查看status正常,但是运行后几秒时间报错

Expected Behavior (预期行为)

1.mysql.log
2019-01-12 11:20:13 [warning] oo many connections (/Volumes/Ext/MacOsx/Codes/PhpstormProjects/SMProxy/src/SMProxyServer.php:257)
2019-01-12 11:20:19 [warning] SMProxy@Connection 127.0.0.1:3306 waiting timeout, timeout=0.5 (/Volumes/Ext/MacOsx/Codes/PhpstormProjects/SMProxy/src/MysqlPool/MySQLPool.php:222)
2019-01-12 11:20:19 [warning] SMProxy@Connection 127.0.0.1:3306 waiting timeout, timeout=0.5 (/Volumes/Ext/MacOsx/Codes/PhpstormProjects/SMProxy/src/MysqlPool/MySQLPool.php:222)
2019-01-12 11:20:19 [warning] SMProxy@Connection 127.0.0.1:3306 waiting timeout, timeout=0.5 (/Volumes/Ext/MacOsx/Codes/PhpstormProjects/SMProxy/src/MysqlPool/MySQLPool.php:222)
2019-01-12 11:20:19 [warning] SMProxy@Connection 127.0.0.1:3306 waiting timeout, timeout=0.5 (/Volumes/Ext/MacOsx/Codes/PhpstormProjects/SMProxy/src/MysqlPool/MySQLPool.php:222)
2019-01-12 11:20:19 [warning] SMProxy@Connection 127.0.0.1:3306 waiting timeout, timeout=0.5 (/Volumes/Ext/MacOsx/Codes/PhpstormProjects/SMProxy/src/MysqlPool/MySQLPool.php:222)
2019-01-12 11:20:19 [warning] SMProxy@Connection 127.0.0.1:3306 waiting timeout, timeout=0.5 (/Volumes/Ext/MacOsx/Codes/PhpstormProjects/SMProxy/src/MysqlPool/MySQLPool.php:222)
2019-01-12 11:20:19 [warning] SMProxy@Connection 127.0.0.1:3306 waiting timeout, timeout=0.5 (/Volumes/Ext/MacOsx/Codes/PhpstormProjects/SMProxy/src/MysqlPool/MySQLPool.php:222)
2019-01-12 11:20:19 [warning] SMProxy@Connection 127.0.0.1:3306 waiting timeout, timeout=0.5 (/Volumes/Ext/MacOsx/Codes/PhpstormProjects/SMProxy/src/MysqlPool/MySQLPool.php:222)
2019-01-12 11:20:19 [warning] SMProxy@Connection 127.0.0.1:3306 waiting timeout, timeout=0.5 (/Volumes/Ext/MacOsx/Codes/PhpstormProjects/SMProxy/src/MysqlPool/MySQLPool.php:222)
2019-01-12 11:20:19 [warning] SMProxy@Connection 127.0.0.1:3306 waiting timeout, timeout=0.5 (/Volumes/Ext/MacOsx/Codes/PhpstormProjects/SMProxy/src/MysqlPool/MySQLPool.php:222)
2.swoole.log
[2019-01-12 18:20:13 #97133.8] NOTICE Server is shutdown now.
[2019-01-12 18:20:43 *97145.1] WARNING swWorker_onTimeout (ERROR 9011): worker exit timeout, forced to terminate.
[2019-01-12 18:20:43 *97149.5] WARNING swWorker_onTimeout (ERROR 9011): worker exit timeout, forced to terminate.
[2019-01-12 18:20:43 *97151.7] WARNING swWorker_onTimeout (ERROR 9011): worker exit timeout, forced to terminate.
[2019-01-12 18:20:43 *97146.2] WARNING swWorker_onTimeout (ERROR 9011): worker exit timeout, forced to terminate.
[2019-01-12 18:20:44 *97148.4] WARNING swWorker_onTimeout (ERROR 9011): worker exit timeout, forced to terminate.
[2019-01-12 18:20:44 *97150.6] WARNING swWorker_onTimeout (ERROR 9011): worker exit timeout, forced to terminate.
[2019-01-12 18:20:44 *97144.0] WARNING swWorker_onTimeout (ERROR 9011): worker exit timeout, forced to terminate.
[2019-01-12 18:20:44 *97147.3] WARNING swWorker_onTimeout (ERROR 9011): worker exit timeout, forced to terminate.

More Information (更多信息)

...

@louislivi
Copy link
Owner

@tracenull telnet 127.0.0.1 3306数据库是否能够正常链接,如果能则降低 配置的startConn

@louislivi
Copy link
Owner

常见问题

@louislivi louislivi self-assigned this Jan 13, 2019
@no-serve-people
Copy link
Contributor Author

@louislivi 把startConn调低了,服务在运行了,但是我执行stop命令,停止不了

@louislivi
Copy link
Owner

检查pid文件权限

@no-serve-people
Copy link
Contributor Author

嗯嗯,可以停止,不过需要等挺长时间。谢谢,已经用于生产环境

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants