最新消息:VPS服务器又从fzhost.net换回Linode了,主题仍用朋友推荐的大前端D8

【已解决】pymongo的count()出错:pymongo.errors.ServerSelectionTimeoutError timed out

MongoDB crifan 207浏览 0评论

折腾:

【已解决】gunicorn运行Flask的app但访问出错:org.apache.http.conn.HttpHostConnectException Connect to failed Operation timed out

期间,

虽然timeout了,但是的确是可以运行的:

(robotDemo-dwdcgdaG) [root@naturling-general-01 robotDemo]# python app.py

[2018-04-24 09:13:52,620 INFO app.py:59 <module>] api=<flask_restful.Api object at 0x7f40da1a1da0>

[2018-04-24 09:13:52,622 INFO app.py:80 <module>] purePymongo=MongoClient(host=[‘x.x.x.x:port’], document_class=dict, tz_aware=False, connect=True, authsource=’gridfs’)

[2018-04-24 09:13:52,987 INFO app.py:59 <module>] api=<flask_restful.Api object at 0x7fa0544f9e10>

[2018-04-24 09:13:52,989 INFO app.py:80 <module>] purePymongo=MongoClient(host=[‘x.x.x.x:port’], document_class=dict, tz_aware=False, connect=True, authsource=’gridfs’)

WARNING:werkzeug: * Debugger is active!

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:104]:

parser=<flask_restful.reqparse.RequestParser object at 0x7fa050036860>

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:14:06,064 INFO app.py:104 get] parser=<flask_restful.reqparse.RequestParser object at 0x7fa050036860>

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:107]:

parsedArgs={‘q’: ‘play a happy song’}

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:14:06,066 INFO app.py:107 get] parsedArgs={‘q’: ‘play a happy song’}

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:113]:

q=play a happy song

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:14:06,067 INFO app.py:113 get] q=play a happy song

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:122]:

foundSongName=<_sre.SRE_Match object; span=(0, 17), match=’play a happy song’>

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:14:06,067 INFO app.py:122 get] foundSongName=<_sre.SRE_Match object; span=(0, 17), match=’play a happy song’>

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:128]:

songName=happy

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:14:06,068 INFO app.py:128 get] songName=happy

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:150]:

filenameRegex=re.compile(‘happy’, re.IGNORECASE)

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:14:06,068 INFO app.py:150 get] filenameRegex=re.compile(‘happy’, re.IGNORECASE)

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:156]:

findFileCursor=<gridfs.grid_file.GridOutCursor object at 0x7fa050036a58>

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:14:06,068 INFO app.py:156 get] findFileCursor=<gridfs.grid_file.GridOutCursor object at 0x7fa050036a58>

Traceback (most recent call last):

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask/app.py", line 1997, in __call__

    return self.wsgi_app(environ, start_response)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask/app.py", line 1985, in wsgi_app

    response = self.handle_exception(e)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask_restful/__init__.py", line 273, in error_router

    return original_handler(e)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask/app.py", line 1540, in handle_exception

    reraise(exc_type, exc_value, tb)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask/_compat.py", line 32, in reraise

    raise value.with_traceback(tb)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask/app.py", line 1982, in wsgi_app

    response = self.full_dispatch_request()

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask/app.py", line 1614, in full_dispatch_request

    rv = self.handle_user_exception(e)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask_restful/__init__.py", line 273, in error_router

    return original_handler(e)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask/app.py", line 1517, in handle_user_exception

    reraise(exc_type, exc_value, tb)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask/_compat.py", line 32, in reraise

    raise value.with_traceback(tb)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask/app.py", line 1612, in full_dispatch_request

    rv = self.dispatch_request()

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask/app.py", line 1598, in dispatch_request

    return self.view_functions[rule.endpoint](**req.view_args)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask_restful/__init__.py", line 480, in wrapper

    resp = resource(*args, **kwargs)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask/views.py", line 84, in view

    return self.dispatch_request(*args, **kwargs)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/flask_restful/__init__.py", line 595, in dispatch_request

    resp = meth(*args, **kwargs)

  File "/root/naturling_20180101/web/server/robotDemo/app.py", line 157, in get

    findFileCount = findFileCursor.count()

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/pymongo/cursor.py", line 755, in count

    cmd, self.__collation, session=self.__session)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/pymongo/collection.py", line 1504, in _count

    with self._socket_for_reads() as (sock_info, slave_ok):

  File "/usr/lib64/python3.4/contextlib.py", line 59, in __enter__

    return next(self.gen)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/pymongo/mongo_client.py", line 982, in _socket_for_reads

    server = topology.select_server(read_preference)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/pymongo/topology.py", line 224, in select_server

    address))

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/pymongo/topology.py", line 183, in select_servers

    selector, server_timeout, address)

  File "/root/.local/share/virtualenvs/robotDemo-dwdcgdaG/lib/python3.4/site-packages/pymongo/topology.py", line 199, in _select_servers_loop

    self._error_message(selector))

pymongo.errors.ServerSelectionTimeoutError: x.x.x.x:32018: timed out

去用postman测试,也是一样现象:

对于Flask中代码:

log.info("findFileCursor=%s", findFileCursor)

findFileCount = findFileCursor.count()

log.info("findFileCount=%s", findFileCount)

卡死在findFileCursor.count()了:

flask pymongo.errors.ServerSelectionTimeoutError timed out

python – Why is PyMongo 3 giving ServerSelectionTimeoutError? – Stack Overflow

ServerSelectionTimeoutError: No servers found yet with pymongo 3.1 · Issue #66 · dcrosta/flask-pymongo

python – Pymongo error Server Timeout – Stack Overflow

pymongo.errors.ServerSelectionTimeoutError · Issue #1734 · MongoEngine/mongoengine

errors – Exceptions raised by the pymongo package — PyMongo 3.6.1 documentation

pymongo.errors.ServerSelectionTimeoutError Python Example

[PYTHON-1054] Database connection timeout error – MongoDB

[PYTHON-1100] pymongo.errors.ServerSelectionTimeoutError: localhost:27017: [Errno 8] nodename nor servname provided, or not known – MongoDB

pymongo count() pymongo.errors.ServerSelectionTimeoutError

python – Error while counting number of entries in a Mongo database using pymongo – Stack Overflow

python – How do you check if the client for a MongoDB instance is valid? – Stack Overflow

pymongo.MongoClient Python Example

好像此处不是count()出错,而是本身数据库连接有问题

突然想到,难道是:

此处阿里云的端口限制,不允许其他IP包括自己的服务器本身去访问自己的mongo的端口?

此处确认服务器上的mongod是正在正常运行的:

(robotDemo-dwdcgdaG) [root@naturling-general-01 robotDemo]# systemctl status mongod

● mongod.service – SYSV: Mongo is a scalable, document-oriented database.

   Loaded: loaded (/etc/rc.d/init.d/mongod; bad; vendor preset: disabled)

   Active: active (running) since Tue 2018-04-10 15:37:29 CST; 1 weeks 6 days ago

     Docs: man:systemd-sysv-generator(8)

   CGroup: /system.slice/mongod.service

           └─1096 /usr/bin/mongod -f /etc/mongod.conf

Apr 10 15:37:28 naturling-general-01 systemd[1]: Starting SYSV: Mongo is a scalable, document-oriented database….

Apr 10 15:37:28 naturling-general-01 runuser[1077]: pam_unix(runuser:session): session opened for user mongod by (uid=0)

Apr 10 15:37:29 naturling-general-01 runuser[1077]: pam_unix(runuser:session): session closed for user mongod

Apr 10 15:37:29 naturling-general-01 mongod[1058]: Starting mongod: [  OK  ]

Apr 10 15:37:29 naturling-general-01 systemd[1]: Started SYSV: Mongo is a scalable, document-oriented database..

把:

purePymongo = MongoClient(

    host="x.x.x.x",

改为

purePymongo = MongoClient(

    host=“localhost”,

同时加上:

mongoServerInfo = purePymongo.server_info()

log.info("mongoServerInfo=%s", mongoServerInfo)

看看效果

是可以打印出mongo的信息的:

(robotDemo-dwdcgdaG) [root@naturling-general-01 robotDemo]# python app.py          

[2018-04-24 09:42:51,418 INFO app.py:59 <module>] api=<flask_restful.Api object at 0x7fb77c948da0>

[2018-04-24 09:42:51,420 INFO app.py:81 <module>] purePymongo=MongoClient(host=[‘localhost:32018′], document_class=dict, tz_aware=False, connect=True, authsource=’gridfs’)

[2018-04-24 09:42:51,630 INFO app.py:83 <module>] mongoServerInfo={‘maxBsonObjectSize’: 16777216, ‘modules’: [], ‘sysInfo’: ‘deprecated’, ‘buildEnvironment’: {‘cxx’: ‘/opt/mongodbtoolchain/bin/g++: g++ (GCC) 4.8.2’, ‘linkflags’: ‘-fPIC -pthread -Wl,-z,now -rdynamic -fuse-ld=gold -Wl,-z,noexecstack -Wl,–warn-execstack’, ‘distarch’: ‘x86_64’, ‘ccflags’: ‘-fno-omit-frame-pointer -fPIC -fno-strict-aliasing -ggdb -pthread -Wall -Wsign-compare -Wno-unknown-pragmas -Winvalid-pch -Werror -O2 -Wno-unused-local-typedefs -Wno-unused-function -Wno-deprecated-declarations -Wno-unused-but-set-variable -Wno-missing-braces -fno-builtin-memcmp’, ‘target_arch’: ‘x86_64’, ‘target_os’: ‘linux’, ‘distmod’: ‘rhel70’, ‘cc’: ‘/opt/mongodbtoolchain/bin/gcc: gcc (GCC) 4.8.2’, ‘cxxflags’: ‘-Wnon-virtual-dtor -Woverloaded-virtual -Wno-maybe-uninitialized -std=c++11’}, ‘allocator’: ‘tcmalloc’, ‘ok’: 1.0, ‘bits’: 64, ‘gitVersion’: ‘a9f574de6a566a58b24d126b44a56718d181e989’, ‘versionArray’: [3, 2, 19, 0], ‘openssl’: {‘running’: ‘OpenSSL 1.0.1e-fips 11 Feb 2013’, ‘compiled’: ‘OpenSSL 1.0.1e-fips 11 Feb 2013’}, ‘debug’: False, ‘storageEngines’: [‘devnull’, ‘ephemeralForTest’, ‘mmapv1’, ‘wiredTiger’], ‘version’: ‘3.2.19’, ‘javascriptEngine’: ‘mozjs’}

[2018-04-24 09:42:51,992 INFO app.py:59 <module>] api=<flask_restful.Api object at 0x7fe841096e10>

[2018-04-24 09:42:51,995 INFO app.py:81 <module>] purePymongo=MongoClient(host=[‘localhost:32018′], document_class=dict, tz_aware=False, connect=True, authsource=’gridfs’)

[2018-04-24 09:42:52,005 INFO app.py:83 <module>] mongoServerInfo={‘buildEnvironment’: {‘cxx’: ‘/opt/mongodbtoolchain/bin/g++: g++ (GCC) 4.8.2’, ‘distarch’: ‘x86_64’, ‘linkflags’: ‘-fPIC -pthread -Wl,-z,now -rdynamic -fuse-ld=gold -Wl,-z,noexecstack -Wl,–warn-execstack’, ‘target_os’: ‘linux’, ‘distmod’: ‘rhel70’, ‘cc’: ‘/opt/mongodbtoolchain/bin/gcc: gcc (GCC) 4.8.2’, ‘cxxflags’: ‘-Wnon-virtual-dtor -Woverloaded-virtual -Wno-maybe-uninitialized -std=c++11’, ‘ccflags’: ‘-fno-omit-frame-pointer -fPIC -fno-strict-aliasing -ggdb -pthread -Wall -Wsign-compare -Wno-unknown-pragmas -Winvalid-pch -Werror -O2 -Wno-unused-local-typedefs -Wno-unused-function -Wno-deprecated-declarations -Wno-unused-but-set-variable -Wno-missing-braces -fno-builtin-memcmp’, ‘target_arch’: ‘x86_64’}, ‘maxBsonObjectSize’: 16777216, ‘gitVersion’: ‘a9f574de6a566a58b24d126b44a56718d181e989’, ‘sysInfo’: ‘deprecated’, ‘javascriptEngine’: ‘mozjs’, ‘versionArray’: [3, 2, 19, 0], ‘openssl’: {‘running’: ‘OpenSSL 1.0.1e-fips 11 Feb 2013’, ‘compiled’: ‘OpenSSL 1.0.1e-fips 11 Feb 2013’}, ‘storageEngines’: [‘devnull’, ‘ephemeralForTest’, ‘mmapv1’, ‘wiredTiger’], ‘allocator’: ‘tcmalloc’, ‘ok’: 1.0, ‘modules’: [], ‘debug’: False, ‘bits’: 64, ‘version’: ‘3.2.19’}

WARNING:werkzeug: * Debugger is active!

然后就可以了:

findFileCursor=<gridfs.grid_file.GridOutCursor object at 0x7fe83c9c8f28>

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:43:55,291 INFO app.py:159 get] findFileCursor=<gridfs.grid_file.GridOutCursor object at 0x7fe83c9c8f28>

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:161]:

findFileCount=5

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:43:55,295 INFO app.py:161 get] findFileCount=5

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:169]:

[ 1] _id=5ad44098a4bc71fa65bb2c2e, contentType=audio/mpeg, filename=Happy Birthday,Danny and the Dinosaur!.mp3

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:43:55,299 INFO app.py:169 get] [ 1] _id=5ad44098a4bc71fa65bb2c2e, contentType=audio/mpeg, filename=Happy Birthday,Danny and the Dinosaur!.mp3

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:169]:

[ 2] _id=5ad44095a4bc71fa65bb2bff, contentType=application/pdf, filename=Happy Birthday,Danny and the Dinosaur!.pdf

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:43:55,299 INFO app.py:169 get] [ 2] _id=5ad44095a4bc71fa65bb2bff, contentType=application/pdf, filename=Happy Birthday,Danny and the Dinosaur!.pdf

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:169]:

[ 3] _id=5ad43ad2a4bc71fa65bae49f, contentType=application/pdf, filename=Happy Easter, Little Critter.pdf

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:43:55,300 INFO app.py:169 get] [ 3] _id=5ad43ad2a4bc71fa65bae49f, contentType=application/pdf, filename=Happy Easter, Little Critter.pdf

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:169]:

[ 4] _id=5ad43cc2a4bc71fa65bafda5, contentType=audio/mpeg, filename=Happy Pig Day.mp3

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:43:55,300 INFO app.py:169 get] [ 4] _id=5ad43cc2a4bc71fa65bafda5, contentType=audio/mpeg, filename=Happy Pig Day.mp3

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

INFO in app [app.py:169]:

[ 5] _id=5ad43a2da4bc71fa65badc0a, contentType=application/pdf, filename=Happy father’s day.pdf

<span style="font-family: Monaco; font-size: 12px; color: rgb(51, 51, 51);"–<——————————————————————————

[2018-04-24 09:43:55,300 INFO app.py:169 get] [ 5] _id=5ad43a2da4bc71fa65badc0a, contentType=application/pdf, filename=Happy father’s day.pdf

【总结】

所以现在现象就是:

Mac本地测试连接远程Mongod时,服务器的host设置的IP地址:

from pymongo import MongoClient

purePymongo = MongoClient(

    host="x.x.x.x",

而放到服务器上运行时,地址就要改为localhost:

from pymongo import MongoClient

purePymongo = MongoClient(

    host="localhost",

才可以正常访问,否则就会出现:

pymongo.errors.ServerSelectionTimeoutError

的问题。

根本原因,以后再深究。

转载请注明:在路上 » 【已解决】pymongo的count()出错:pymongo.errors.ServerSelectionTimeoutError timed out

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址
60 queries in 0.265 seconds, using 12.24MB memory