【python新人求助】flask+pymssql 通过wsgi发布到Apache，访问接口服务器卡死?

Question

前端发起http请求 '/getData' ,项目就卡死 index.py 代码如下： from flask import Flask,render_template,request import json import pymssql import urllib.parse import sys app = Flask(__name__) @app.route('/') def index(): return render_template('index.html') @app.route('/hello') def hello(): return 'hello world' @app.route('/getData',methods=['GET']) def getddlData(): # return json.dumps([]) sql='SELECT DISTINCT ChatRoomName FROM dbo.Issue' conn=pymssql.connect(host="localhost", user="sa", password="123456", database="IssueCollect") cursor=conn.cursor(as_dict=True) cursor.execute(sql) rooms=cursor.fetchall() cursor.close() conn.close() return json.dumps(rooms) if __name__ == '__main__': app.run() test.wsgi： import sys #app's path sys.path.insert(0,"C:/Users/Stephen/Desktop/IssueCollect") from index import app #Initialize WSGI app object application = app Apache conf LoadFile "c:/program files (x86)/python37-32/python37.dll" LoadModule wsgi_module "c:/program files (x86)/python37-32/lib/site-packages/mod_wsgi/server/mod_wsgi.cp37-win32.pyd" WSGIPythonHome "c:/program files (x86)/python37-32" <VirtualHost *:5001> WSGIScriptAlias / C:/Users/Stephen/Desktop/IssueCollect/test.wsgi <Directory C:/Users/Stephen/Desktop/IssueCollect> Require all granted </Directory> </VirtualHost> 卡死后关闭httpd，查看Apache error log： on Jul 23 14:05:52.534352 2018] [mpm_winnt:notice] [pid 3856:tid 600] AH00455: Apache/2.4.34 (Win32) mod_wsgi/4.6.4 Python/3.7 configured -- resuming normal operations [Mon Jul 23 14:05:52.534853 2018] [mpm_winnt:notice] [pid 3856:tid 600] AH00456: Server built: Jul 10 2018 09:24:15 [Mon Jul 23 14:05:52.534853 2018] [core:notice] [pid 3856:tid 600] AH00094: Command line: 'C:\\Apache24\\bin\\httpd.exe -d C:/Apache24' [Mon Jul 23 14:05:52.536599 2018] [mpm_winnt:notice] [pid 3856:tid 600] AH00418: Parent: Created child process 18044 Apache server shutdown initiated... pm_winnt:notice] [pid 18044:tid 712] AH00354: Child: Starting 512 worker threads. [Mon Jul 23 14:06:58.522281 2018] [mpm_winnt:notice] [pid 3856:tid 600] AH00422: Parent: Received shutdown signal -- Shutting down the server. [Mon Jul 23 14:07:30.572310 2018] [mpm_winnt:notice] [pid 18044:tid 712] AH00362: Child: Waiting 30 more seconds for 2 worker threads to finish. [Mon Jul 23 14:08:00.692059 2018] [mpm_winnt:notice] [pid 18044:tid 712] AH00362: Child: Waiting 0 more seconds for 2 worker threads to finish. [Mon Jul 23 14:08:00.792357 2018] [mpm_winnt:notice] [pid 18044:tid 712] AH00363: Child: Terminating 2 threads that failed to exit. [Mon Jul 23 14:08:00.792357 2018] [mpm_winnt:notice] [pid 18044:tid 712] AH00364: Child: All worker threads have exited. 在本地python中执行index.py访问正常，发布到Apache服务器上，不连接数据库直接返回空正常。连接数据库就有问题。是我Apache配置问题吗？

Answer 1

放弃Apache，转nginx+uwsgi解决问题

Answer 2

检查 SQL SELECT DISTINCT ChatRoomName FROM dbo.Issue 的结果集是否太大。