gspreadに書き込み/読み込みを行うwebサービスのGoogle Assitantアプリ(webhook経由)を作成しようとしております。
ローカルPCからは正常に動作することは確認できているのですが、「git push heroku master」でherokuにデプロイするとImportエラーとなり正常にデプロイが出来ません(gsperad、oauth2client)。
エラーログは以下のとおりです。
2018-07-22T05:12:17.000000+00:00 app[api]: Build succeeded
2018-07-22T05:12:21.105078+00:00 app[web.1]: [2018-07-22 05:12:21 +0000] [4] [INFO] Starting gunicorn 19.6.0
2018-07-22T05:12:21.105112+00:00 app[web.1]: [2018-07-22 05:12:21 +0000] [4] [INFO] Listening at: http://0.0.0.0:7708 (4)
2018-07-22T05:12:21.105114+00:00 app[web.1]: [2018-07-22 05:12:21 +0000] [4] [INFO] Using worker: sync
2018-07-22T05:12:21.111485+00:00 app[web.1]: [2018-07-22 05:12:21 +0000] [8] [INFO] Booting worker with pid: 8
2018-07-22T05:12:21.199145+00:00 app[web.1]: [2018-07-22 05:12:21 +0000] [9] [INFO] Booting worker with pid: 9
2018-07-22T05:12:22.131526+00:00 heroku[web.1]: State changed from starting to up
2018-07-22T05:12:22.188378+00:00 app[web.1]: [2018-07-22 05:12:22 +0000] [8] [ERROR] Exception in worker process
2018-07-22T05:12:22.188407+00:00 app[web.1]: Traceback (most recent call last):
2018-07-22T05:12:22.188409+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/arbiter.py", line 557, in spawn_worker
2018-07-22T05:12:22.188411+00:00 app[web.1]: worker.init_process()
2018-07-22T05:12:22.188413+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/workers/base.py", line 126, in init_process
2018-07-22T05:12:22.188414+00:00 app[web.1]: self.load_wsgi()
2018-07-22T05:12:22.188416+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/workers/base.py", line 136, in load_wsgi
2018-07-22T05:12:22.188417+00:00 app[web.1]: self.wsgi = self.app.wsgi()
2018-07-22T05:12:22.188419+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/app/base.py", line 67, in wsgi
2018-07-22T05:12:22.188421+00:00 app[web.1]: self.callable = self.load()
2018-07-22T05:12:22.188422+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py", line 65, in load
2018-07-22T05:12:22.188424+00:00 app[web.1]: return self.load_wsgiapp()
2018-07-22T05:12:22.188425+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py", line 52, in load_wsgiapp
2018-07-22T05:12:22.188427+00:00 app[web.1]: return util.import_app(self.app_uri)
2018-07-22T05:12:22.188428+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/util.py", line 357, in import_app
2018-07-22T05:12:22.188430+00:00 app[web.1]: import(module)
2018-07-22T05:12:22.188431+00:00 app[web.1]: File "/app/hello.py", line 13, in <module>
2018-07-22T05:12:22.188433+00:00 app[web.1]: import gspread
2018-07-22T05:12:22.188444+00:00 app[web.1]: ModuleNotFoundError: No module named 'gspread'
2018-07-22T05:12:22.189181+00:00 app[web.1]: [2018-07-22 05:12:22 +0000] [8] [INFO] Worker exiting (pid: 8)
2018-07-22T05:12:22.193478+00:00 app[web.1]: [2018-07-22 05:12:22 +0000] [9] [ERROR] Exception in worker process
2018-07-22T05:12:22.193482+00:00 app[web.1]: Traceback (most recent call last):
2018-07-22T05:12:22.193484+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/arbiter.py", line 557, in spawn_worker
2018-07-22T05:12:22.193486+00:00 app[web.1]: worker.init_process()
2018-07-22T05:12:22.193488+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/workers/base.py", line 126, in init_process
2018-07-22T05:12:22.193489+00:00 app[web.1]: self.load_wsgi()
2018-07-22T05:12:22.193491+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/workers/base.py", line 136, in load_wsgi
2018-07-22T05:12:22.193493+00:00 app[web.1]: self.wsgi = self.app.wsgi()
2018-07-22T05:12:22.193495+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/app/base.py", line 67, in wsgi
2018-07-22T05:12:22.193496+00:00 app[web.1]: self.callable = self.load()
2018-07-22T05:12:22.193498+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py", line 65, in load
2018-07-22T05:12:22.193500+00:00 app[web.1]: return self.load_wsgiapp()
2018-07-22T05:12:22.193502+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/app/wsgiapp.py", line 52, in load_wsgiapp
2018-07-22T05:12:22.193503+00:00 app[web.1]: return util.import_app(self.app_uri)
2018-07-22T05:12:22.193505+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.6/site-packages/gunicorn/util.py", line 357, in import_app
2018-07-22T05:12:22.193507+00:00 app[web.1]: import(module)
2018-07-22T05:12:22.193508+00:00 app[web.1]: File "/app/hello.py", line 13, in <module>
2018-07-22T05:12:22.193510+00:00 app[web.1]: import gspread
**2018-07-22T05:12:22.221668+00:00 app[web.1]: ModuleNotFoundError: No module named 'gspread'
**2018-07-22T05:12:22.222931+00:00 app[web.1]: [2018-07-22 05:12:22 +0000] [9] [INFO] Worker exiting (pid: 9)
2018-07-22T05:12:22.610112+00:00 app[web.1]: [2018-07-22 05:12:22 +0000] [4] [INFO] Shutting down: Master
2018-07-22T05:12:22.610257+00:00 app[web.1]: [2018-07-22 05:12:22 +0000] [4] [INFO] Reason: Worker failed to boot.
2018-07-22T05:12:22.827244+00:00 heroku[web.1]: Process exited with status 3
2018-07-22T05:12:22.859699+00:00 heroku[web.1]: State changed from up to crashed
非仮想環境でのモジュールインストール等も試してみましたがやはり駄目です。
何かアドバイスを頂けないでしょうか。
環境:
Windows10
python 3.6.6
requirement.txt:
asn1crypto==0.24.0
certifi==2018.4.16
cffi==1.11.5
chardet==3.0.4
click==6.7
cryptography==2.3
dj-database-url==0.5.0
Django==1.11
django-heroku==0.3.1
Flask==1.0.2
gspread==3.0.1
httplib2==0.11.3
idna==2.7
itsdangerous==0.24
Jinja2==2.10
MarkupSafe==1.0
oauth2client==4.1.2
pipenv==2018.7.1
psycopg2==2.7.5
pyasn1==0.4.3
pyasn1-modules==0.2.2
pycparser==2.18
pyOpenSSL==18.0.0
pytz==2018.5
requests==2.19.1
rsa==3.4.2
six==1.11.0
urllib3==1.23
virtualenv==16.0.0
virtualenv-clone==0.3.0
Werkzeug==0.14.1
whitenoise==3.3.1
ソース(hello.py):
(略)
from future import print_function
from future.standard_library import install_aliases
install_aliases()
from flask import Flask, request,make_response
import os
import gspread
from flask import Flask
from oauth2client.service_account import ServiceAccountCredentials
app = Flask(name)
app.config['JSON_AS_ASCII'] = False
@app.route("/")
def hello():
req = request.get_json(silent=True, force=True)
result = req.get("result")
parameters = result.get("parameters")
datenow = parameters.get("date")
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive'] credentials = ServiceAccountCredentials.from_json_keyfile_name('gspread2xxxxxxxxxxxx.json', scope) gc = gspread.authorize(credentials) wks = gc.open('gspread2').sheet1 wks.update_acell('A1', datenow) print(wks.acell('A1')) return make_response(jsonify({'speech':'This process completed successfully','displayText':'This process completed successfully'})) return make_response(jsonify({'result':'hello world!'}))
if name == "main":
port = int(os.environ.get("PORT", 5000))
app.run(host='0.0.0.0', port=port)
回答1件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。