search

calpoly-csai / api

Official API for the NIMBUS Voice Assistant accessible via HTTP REST protocol.
https://nimbus.api.calpolycsai.com/
GNU General Public License v3.0
9 stars 4 forks source link

updated to work with new database #162

Closed cameron-toy closed 4 years ago

cameron-toy commented 4 years ago

f it git push

render[bot] commented 4 years ago

Your Render PR Server URL is https://nimbus-pr-162.onrender.com.

Follow its progress at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

render[bot] commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live!

View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

mfekadu commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live!

View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

Build is good but...

Warnings

FutureWarning: The sklearn.neighbors.classification module is deprecated

expand to see

``` May 27 09:52:49 PM 10.100.3.218 - - [28/May/2020:04:52:49 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 09:52:51 PM /opt/render/project/src/.venv/lib/python3.7/site-packages/sklearn/utils/deprecation.py:144: FutureWarning: The sklearn.neighbors.classification module is deprecated in version 0.22 and will be removed in version 0.24. The corresponding classes / functions should instead be imported from sklearn.neighbors. Anything that cannot be imported from sklearn.neighbors is now part of the private API. May 27 09:52:51 PM warnings.warn(message, FutureWarning) ```

FutureWarning: The sklearn.neighbors.kd_tree module is deprecated

expand to see

``` May 27 09:52:51 PM /opt/render/project/src/.venv/lib/python3.7/site-packages/sklearn/utils/deprecation.py:144: FutureWarning: The sklearn.neighbors.kd_tree module is deprecated in version 0.22 and will be removed in version 0.24. The corresponding classes / functions should instead be imported from sklearn.neighbors. Anything that cannot be imported from sklearn.neighbors is now part of the private API. May 27 09:52:51 PM warnings.warn(message, FutureWarning) ```

FutureWarning: The sklearn.neighbors.dist_metrics module is deprecated

expand to see

``` May 27 09:52:51 PM /opt/render/project/src/.venv/lib/python3.7/site-packages/sklearn/utils/deprecation.py:144: FutureWarning: The sklearn.neighbors.dist_metrics module is deprecated in version 0.22 and will be removed in version 0.24. The corresponding classes / functions should instead be imported from sklearn.neighbors. Anything that cannot be imported from sklearn.neighbors is now part of the private API. May 27 09:52:51 PM warnings.warn(message, FutureWarning) ```

UserWarning: Trying to unpickle estimator KNeighborsClassifier

expand to see

``` May 27 09:52:51 PM /opt/render/project/src/.venv/lib/python3.7/site-packages/sklearn/base.py:318: UserWarning: Trying to unpickle estimator KNeighborsClassifier from version 0.20.2 when using version 0.22.2. This might lead to breaking code or invalid results. Use at your own risk. May 27 09:52:51 PM UserWarning) ```

Error AttributeError: 'KNeighborsClassifier' object has no attribute 'n_samples_fit_'

expand to see

``` May 27 09:52:51 PM [2020-05-28 04:52:51,579] ERROR in app: Exception on /ask [POST] May 27 09:52:51 PM Traceback (most recent call last): File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app response = self.full_dispatch_request() File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request rv = self.handle_user_exception(e) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function return cors_after_request(app.make_response(f(*args, **kwargs))) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception reraise(exc_type, exc_value, tb) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise raise value File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request rv = self.dispatch_request() File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/opt/render/project/src/flask_api.py", line 122, in handle_question response = {"answer": nimbus.answer_question(question)} File "/opt/render/project/src/nimbus.py", line 33, in answer_question ans_dict = self.predict_question(question) File "/opt/render/project/src/nimbus.py", line 69, in predict_question nlp_props["normalized question"] File "/opt/render/project/src/nimbus_nlp/question_classifier.py", line 121, in classify_question min_dist = np.min(self.classifier.kneighbors(test_vector, n_neighbors=1)) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sklearn/neighbors/_base.py", line 613, in kneighbors n_samples_fit = self.n_samples_fit_ AttributeError: 'KNeighborsClassifier' object has no attribute 'n_samples_fit_' May 27 09:52:51 PM initialized database session ```

mfekadu commented 4 years ago

wait

render[bot] commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live!

View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

mfekadu commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live! View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

starting is good

expand to see

``` May 27 10:05:50 PM ==> Starting service with 'sh deploy.sh' May 27 10:05:55 PM [2020-05-28 05:05:55 +0000] [43] [INFO] Starting gunicorn 20.0.4 May 27 10:05:55 PM [2020-05-28 05:05:55 +0000] [43] [INFO] Listening at: http://0.0.0.0:10000 (43) May 27 10:05:55 PM [2020-05-28 05:05:55 +0000] [43] [INFO] Using worker: sync May 27 10:05:55 PM [2020-05-28 05:05:55 +0000] [49] [INFO] Booting worker with pid: 49 May 27 10:05:55 PM [2020-05-28 05:05:55 +0000] [50] [INFO] Booting worker with pid: 50 May 27 10:05:55 PM [2020-05-28 05:05:55 +0000] [51] [INFO] Booting worker with pid: 51 May 27 10:06:10 PM 10.100.3.218 - - [28/May/2020:05:06:10 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:06:15 PM 10.100.3.218 - - [28/May/2020:05:06:15 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:06:20 PM 10.100.3.218 - - [28/May/2020:05:06:20 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:06:25 PM 10.100.3.218 - - [28/May/2020:05:06:25 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:06:30 PM 10.100.3.218 - - [28/May/2020:05:06:30 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:06:31 PM 10.104.76.4 - - [28/May/2020:05:06:31 +0000] "GET / HTTP/1.1" 200 37 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1 Safari/605.1.15" May 27 10:06:35 PM 10.100.3.218 - - [28/May/2020:05:06:35 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:06:40 PM 10.100.3.218 - - [28/May/2020:05:06:40 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:06:40 PM 10.104.78.4 - - [28/May/2020:05:06:40 +0000] "GET / HTTP/1.1" 200 37 "-" "Slackbot-LinkExpanding 1.0 (+https://api.slack.com/robots)" May 27 10:06:41 PM 10.104.78.4 - - [28/May/2020:05:06:41 +0000] "GET /favicon.ico HTTP/1.1" 404 232 "-" "Slackbot 1.0 (+https://api.slack.com/robots)" May 27 10:06:45 PM 10.100.3.218 - - [28/May/2020:05:06:45 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:06:49 PM 10.104.30.5 - - [28/May/2020:05:06:49 +0000] "GET / HTTP/1.1" 200 37 "https://github.com/calpoly-csai/api/pull/162" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.5 Safari/605.1.15" May 27 10:06:49 PM 10.104.78.4 - - [28/May/2020:05:06:49 +0000] "GET /favicon.ico HTTP/1.1" 404 232 "https://nimbus-pr-162.onrender.com/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.5 Safari/605.1.15" May 27 10:06:50 PM 10.100.3.218 - - [28/May/2020:05:06:50 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:06:55 PM 10.100.3.218 - - [28/May/2020:05:06:55 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:06:55 PM 10.104.78.4 - - [28/May/2020:05:06:55 +0000] "POST / HTTP/1.1" 200 53 "-" "PostmanRuntime/7.25.0" May 27 10:07:00 PM 10.100.3.218 - - [28/May/2020:05:07:00 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:07:05 PM 10.100.3.218 - - [28/May/2020:05:07:05 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" ```

FileNotFoundError: [Errno 2] No such file or directory: '/opt/render/project/src/nimbus_nlp/models/classification/nlp-model_05_28_2020_05_05_55.pkl'

expand to see

``` May 27 10:07:07 PM [2020-05-28 05:07:07,223] ERROR in app: Exception on /ask [POST] May 27 10:07:07 PM Traceback (most recent call last): File "/opt/render/project/src/nimbus.py", line 25, in __init__ self.classifier.load_latest_classifier() File "/opt/render/project/src/nimbus_nlp/question_classifier.py", line 25, in load_latest_classifier self.classifier = load_latest_model() File "/opt/render/project/src/nimbus_nlp/save_and_load_model.py", line 32, in load_latest_model latest_file = max(list_of_files, key=os.path.getctime) ValueError: max() arg is an empty sequence May 27 10:07:07 PM May 27 10:07:07 PM During handling of the above exception, another exception occurred: May 27 10:07:07 PM May 27 10:07:07 PM Traceback (most recent call last): File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app response = self.full_dispatch_request() File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request rv = self.handle_user_exception(e) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function return cors_after_request(app.make_response(f(*args, **kwargs))) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception reraise(exc_type, exc_value, tb) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise raise value File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request rv = self.dispatch_request() File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/opt/render/project/src/flask_api.py", line 110, in handle_question init_nimbus_db() File "/opt/render/project/src/flask_api.py", line 75, in init_nimbus_db nimbus = Nimbus(db) File "/opt/render/project/src/nimbus.py", line 28, in __init__ self.classifier.train_model() File "/opt/render/project/src/nimbus_nlp/question_classifier.py", line 22, in train_model save_model(self.classifier, "nlp-model") File "/opt/render/project/src/nimbus_nlp/save_and_load_model.py", line 17, in save_model f = open(save_path, "wb") FileNotFoundError: [Errno 2] No such file or directory: '/opt/render/project/src/nimbus_nlp/models/classification/nlp-model_05_28_2020_05_05_55.pkl' ```

AttributeError: 'NoneType' object has no attribute 'answer_question'

expand to see

``` May 27 10:07:07 PM initialized database session May 27 10:07:07 PM initialized NimbusMySQLAlchemy May 27 10:07:07 PM 10.104.78.4 - - [28/May/2020:05:07:07 +0000] "POST /ask HTTP/1.1" 500 290 "-" "PostmanRuntime/7.25.0" May 27 10:07:10 PM 10.100.3.218 - - [28/May/2020:05:07:10 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:07:13 PM [2020-05-28 05:07:13,366] ERROR in app: Exception on /ask [POST] May 27 10:07:13 PM Traceback (most recent call last): File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app response = self.full_dispatch_request() File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request rv = self.handle_user_exception(e) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function return cors_after_request(app.make_response(f(*args, **kwargs))) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception reraise(exc_type, exc_value, tb) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise raise value File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request rv = self.dispatch_request() File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/opt/render/project/src/flask_api.py", line 122, in handle_question response = {"answer": nimbus.answer_question(question)} AttributeError: 'NoneType' object has no attribute 'answer_question' May 27 10:07:13 PM 10.104.78.4 - - [28/May/2020:05:07:13 +0000] "POST /ask HTTP/1.1" 500 290 "-" "PostmanRuntime/7.25.0" May 27 10:07:15 PM 10.100.3.218 - - [28/May/2020:05:07:15 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:07:20 PM 10.100.3.218 - - [28/May/2020:05:07:20 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:07:25 PM 10.100.3.218 - - [28/May/2020:05:07:25 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:07:30 PM 10.100.3.218 - - [28/May/2020:05:07:30 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" ```

mfekadu commented 4 years ago

FileNotFoundError: [Errno 2] No such file or directory: '/opt/render/project/src/nimbus_nlp/models/classification/nlp-model_05_28_2020_05_05_55.pkl'

reason:

$ pwd
/opt/render/project/src
$ 
$ ls classification
ls: cannot access 'classification': No such file or directory
$
render[bot] commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live!

View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

mfekadu commented 4 years ago

starting all good

expand to see

``` May 27 10:16:32 PM ✔ Download and installation successful May 27 10:16:32 PM You can now load the model via spacy.load('en_core_web_lg') May 27 10:16:32 PM ✅ it is good. May 27 10:16:32 PM done May 27 10:16:33 PM ==> Uploading build... May 27 10:17:41 PM ==> Deploying... May 27 10:17:41 PM ==> Build successful 🎉 May 27 10:19:48 PM ==> Starting service with 'sh deploy.sh' May 27 10:19:53 PM [2020-05-28 05:19:53 +0000] [43] [INFO] Starting gunicorn 20.0.4 May 27 10:19:53 PM [2020-05-28 05:19:53 +0000] [43] [INFO] Listening at: http://0.0.0.0:10000 (43) May 27 10:19:53 PM [2020-05-28 05:19:53 +0000] [43] [INFO] Using worker: sync May 27 10:19:54 PM [2020-05-28 05:19:54 +0000] [49] [INFO] Booting worker with pid: 49 May 27 10:19:54 PM [2020-05-28 05:19:54 +0000] [50] [INFO] Booting worker with pid: 50 May 27 10:19:54 PM [2020-05-28 05:19:54 +0000] [51] [INFO] Booting worker with pid: 51 ```

## Hello works
expand to see

``` May 27 10:21:27 PM 10.104.30.4 - - [28/May/2020:05:21:27 +0000] "GET / HTTP/1.1" 200 37 "https://github.com/calpoly-csai/api/pull/162" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:76.0) Gecko/20100101 Firefox/76.0" May 27 10:21:31 PM 10.100.3.218 - - [28/May/2020:05:21:31 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:21:36 PM 10.100.3.218 - - [28/May/2020:05:21:36 +0000] "GET / HTTP/1.1" 200 37 "-" "Ren ```

mfekadu commented 4 years ago

when can i take csc 202

request

curl --location --request POST 'https://nimbus-pr-162.onrender.com/ask' --header 'Content-Type: application/json' --data-raw '{
    "question": "when can i take csc 202??"
}'

python3.7/

raise EOFError

expand to see

``` May 27 10:21:37 PM [2020-05-28 05:21:37,512] ERROR in app: Exception on /ask [POST] May 27 10:21:37 PM Traceback (most recent call last): File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app response = self.full_dispatch_request() File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request rv = self.handle_user_exception(e) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function return cors_after_request(app.make_response(f(*args, **kwargs))) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception reraise(exc_type, exc_value, tb) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise raise value File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request rv = self.dispatch_request() File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/opt/render/project/src/flask_api.py", line 110, in handle_question init_nimbus_db() File "/opt/render/project/src/flask_api.py", line 75, in init_nimbus_db nimbus = Nimbus(db) File "/opt/render/project/src/nimbus.py", line 25, in __init__ self.classifier.load_latest_classifier() File "/opt/render/project/src/nimbus_nlp/question_classifier.py", line 25, in load_latest_classifier self.classifier = load_latest_model() File "/opt/render/project/src/nimbus_nlp/save_and_load_model.py", line 33, in load_latest_model return joblib.load(latest_file) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/joblib/numpy_pickle.py", line 585, in load obj = _unpickle(fobj, filename, mmap_mode) File "/opt/render/project/src/.venv/lib/python3.7/site-packages/joblib/numpy_pickle.py", line 504, in _unpickle obj = unpickler.load() File "/usr/local/lib/python3.7/pickle.py", line 1086, in load raise EOFError May 27 10:21:37 PM initialized database session May 27 10:21:37 PM initialized NimbusMySQLAlchemy May 27 10:21:37 PM 10.104.78.4 - - [28/May/2020:05:21:37 +0000] "POST /ask HTTP/1.1" 500 290 "-" "PostmanRuntime/7.25.0" May 27 10:21:41 PM 10.100.3.218 - - [28/May/2020:05:21:41 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 10:21:37 PM EOFError ```

pip freeze

joblib==0.15.1

expand to see

``` $ pip freeze ansicolors==1.1.8 attrs==19.3.0 blis==0.4.1 cachetools==4.0.0 catalogue==1.0.0 certifi==2019.11.28 chardet==3.0.4 Click==7.0 colorama==0.4.3 colorful==0.5.4 cymem==2.0.3 en-core-web-lg==2.2.5 en-core-web-sm==2.2.5 Flask==1.1.1 Flask-Cors==3.0.8 fuzzywuzzy==0.18.0 google-api-core==1.16.0 google-api-python-client==1.7.11 google-auth==1.11.2 google-auth-httplib2==0.0.3 google-cloud==0.34.0 google-cloud-automl==0.10.0 googleapis-common-protos==1.51.0 grpcio==1.27.2 gunicorn==20.0.4 httplib2==0.17.0 idna==2.6 importlib-metadata==1.5.0 itsdangerous==1.1.0 Jinja2==2.11.1 joblib==0.15.1 MarkupSafe==1.1.1 marshmallow==3.5.0 mock==4.0.1 more-itertools==8.3.0 murmurhash==1.0.2 mysql-connector-python==8.0.18 nltk==3.4.5 numpy==1.18.3 oauth2client==4.1.3 packaging==20.4 pandas==1.0.1 plac==1.1.3 pluggy==0.13.1 preshed==3.0.2 protobuf==3.11.3 py==1.8.1 pyasn1==0.4.8 pyasn1-modules==0.2.8 PyDrive==1.3.1 pyparsing==2.4.7 pytest==5.3.5 python-dateutil==2.8.1 python-Levenshtein==0.12.0 pytz==2019.3 PyYAML==5.3 requests==2.23.0 rsa==4.0 scikit-learn==0.22.2 scipy==1.4.1 six==1.11.0 spacy==2.2.4 SQLAlchemy==1.3.13 srsly==1.0.2 termcolor==1.1.0 thinc==7.4.0 tqdm==4.43.0 uritemplate==3.0.1 urllib3==1.25.9 wasabi==0.6.0 wcwidth==0.1.9 Werkzeug==1.0.0 zipp==3.0.0 $ ```

mfekadu commented 4 years ago

Request

curl --location --request POST 'https://nimbus-pr-162.onrender.com/ask' --header 'Content-Type: application/json' --data-raw '{
    "question": "What is Foaad'\''s email?"
}'

Logs

May 27 10:24:56 PM  10.100.3.218 - - [28/May/2020:05:24:56 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0"
May 27 10:24:59 PM  [2020-05-28 05:24:59,152] ERROR in app: Exception on /ask [POST]
May 27 10:24:59 PM  Traceback (most recent call last):
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app
    response = self.full_dispatch_request()
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function
    return cors_after_request(app.make_response(f(*args, **kwargs)))
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request
    rv = self.dispatch_request()
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/opt/render/project/src/flask_api.py", line 122, in handle_question
    response = {"answer": nimbus.answer_question(question)}
AttributeError: 'NoneType' object has no attribute 'answer_question'
May 27 10:24:59 PM  10.104.78.5 - - [28/May/2020:05:24:59 +0000] "POST /ask HTTP/1.1" 500 290 "-" "PostmanRuntime/7.25.0"
May 27 10:25:01 PM  10.100.3.218 - - [28/May/2020:05:25:01 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0"
render[bot] commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live!

View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

render[bot] commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live!

View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

mfekadu commented 4 years ago

joblib 0.14.0

$ pip list | grep joblib
joblib                   0.14.0    
May 27 10:46:59 PM  10.104.78.5 - - [28/May/2020:05:46:59 +0000] "POST / HTTP/1.1" 200 54 "-" "PostmanRuntime/7.25.0"
May 27 10:47:00 PM  10.100.3.218 - - [28/May/2020:05:47:00 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0"
May 27 10:47:05 PM  10.100.3.218 - - [28/May/2020:05:47:05 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0"
May 27 10:47:06 PM  [2020-05-28 05:47:06,030] ERROR in app: Exception on /ask [POST]
May 27 10:47:06 PM  Traceback (most recent call last):
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app
    response = self.full_dispatch_request()
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function
    return cors_after_request(app.make_response(f(*args, **kwargs)))
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request
    rv = self.dispatch_request()
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/opt/render/project/src/flask_api.py", line 110, in handle_question
    init_nimbus_db()
  File "/opt/render/project/src/flask_api.py", line 75, in init_nimbus_db
    nimbus = Nimbus(db)
  File "/opt/render/project/src/nimbus.py", line 25, in __init__
    self.classifier.load_latest_classifier()
  File "/opt/render/project/src/nimbus_nlp/question_classifier.py", line 25, in load_latest_classifier
    self.classifier = load_latest_model()
  File "/opt/render/project/src/nimbus_nlp/save_and_load_model.py", line 33, in load_latest_model
    return joblib.load(latest_file)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/joblib/numpy_pickle.py", line 605, in load
    obj = _unpickle(fobj, filename, mmap_mode)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/joblib/numpy_pickle.py", line 529, in _unpickle
    obj = unpickler.load()
  File "/usr/local/lib/python3.7/pickle.py", line 1086, in load
    raise EOFError
May 27 10:47:06 PM  initialized database session
May 27 10:47:06 PM  initialized NimbusMySQLAlchemy
May 27 10:47:06 PM  10.104.78.5 - - [28/May/2020:05:47:06 +0000] "POST /ask HTTP/1.1" 500 290 "-" "PostmanRuntime/7.25.0"
May 27 10:47:10 PM  10.100.3.218 - - [28/May/2020:05:47:10 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0"
May 27 10:47:06 PM  EOFError

no pickles ?? 🥒

$ ls *.pkl
ls: cannot access '*.pkl': No such file or directory

ls

$ ls
Dockerfile         __init__.py           credentials.json     heroku_deploy.sh              requirements.txt                 sql
Dockerfile_heroku  __pycache__           database_wrapper.py  id_rsa                        run.sh                           sqlalchemy_demo.py
Entity             auth.json             deploy.sh            letsencrypt-backup-tar.cron   run_tests.sh                     tasks.py
LICENSE            build.py              flask_api.py         lint.sh                       scripts                          test.py
Makefile           cert-update.sh        folder_id.txt        modules                       settings.yaml                    tests
Pipfile            config.json           format.sh            nimbus.py                     settings.yaml_SAMPLE             type_check.sh
Pipfile.lock       config_SAMPLE.json    gce_deploy.sh        nimbus_nlp                    settings.yml                     utilities
QA.py              coverage.sh           gunicorn_config.py   office_hours_post_request.py  setup_letsencrypt.sh
README.md          create_all_tables.py  happy.wav            qa_pair.csv                   setup_special_files_from_env.py

ls nimbus_nlp/models/classification/

$ ls nimbus_nlp/models/classification/
keep
render[bot] commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live!

View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

sonarcloud[bot] commented 4 years ago

Kudos, SonarCloud Quality Gate passed!

Bug A 0 Bugs
Vulnerability A 0 Vulnerabilities (and Security Hotspot 0 Security Hotspots to review)
Code Smell A 5 Code Smells

No Coverage information No Coverage information
0.0% 0.0% Duplication

render[bot] commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live!

View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

render[bot] commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live!

View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

mfekadu commented 4 years ago

Unknown column 'Profs.first_name' in 'field list'

May 27 11:20:26 PM  [2020-05-28 06:20:26,666] ERROR in app: Exception on /ask [POST]
May 27 11:20:26 PM  Traceback (most recent call last):
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/mysql/connector/connection_cext.py", line 472, in cmd_query
    raw_as_string=raw_as_string)
_mysql_connector.MySQLInterfaceError: Unknown column 'Profs.first_name' in 'field list'
May 27 11:20:26 PM  
May 27 11:20:26 PM  During handling of the above exception, another exception occurred:
May 27 11:20:26 PM  
May 27 11:20:26 PM  Traceback (most recent call last):
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
    cursor, statement, parameters, context
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
    cursor.execute(statement, parameters)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/mysql/connector/cursor_cext.py", line 266, in execute
    raw_as_string=self._raw_as_string)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/mysql/connector/connection_cext.py", line 475, in cmd_query
    sqlstate=exc.sqlstate)
mysql.connector.errors.ProgrammingError: 1054 (42S22): Unknown column 'Profs.first_name' in 'field list'
May 27 11:20:26 PM  
May 27 11:20:26 PM  The above exception was the direct cause of the following exception:
May 27 11:20:26 PM  
May 27 11:20:26 PM  Traceback (most recent call last):
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app
    response = self.full_dispatch_request()
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function
    return cors_after_request(app.make_response(f(*args, **kwargs)))
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request
    rv = self.dispatch_request()
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/opt/render/project/src/flask_api.py", line 122, in handle_question
    response = {"answer": nimbus.answer_question(question)}
  File "/opt/render/project/src/nimbus.py", line 42, in answer_question
    answer = qa.answer(ans_dict)
  File "/opt/render/project/src/QA.py", line 52, in answer
    db_data = self.db_query(extracted_vars, self.db)
  File "/opt/render/project/src/QA.py", line 231, in _chain_db_access
    for key, val in fn(extracted_vars, db).items():
  File "/opt/render/project/src/QA.py", line 96, in _get_property
    prop=prop, entity=ent, identifier=ent_string
  File "/opt/render/project/src/database_wrapper.py", line 583, in get_property_from_entity
    props = self._get_property_from_entity(prop, entity, identifier, tag_column_map)
  File "/opt/render/project/src/database_wrapper.py", line 558, in _get_property_from_entity
    for row in query_obj.all():
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3233, in all
    return list(self)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3389, in __iter__
    return self._execute_and_instances(context)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3414, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 982, in execute
    return meth(self, multiparams, params)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 293, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1101, in _execute_clauseelement
    distilled_params,
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1250, in _execute_context
    e, statement, parameters, cursor, context
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1476, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
    raise value.with_traceback(tb)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
    cursor, statement, parameters, context
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
    cursor.execute(statement, parameters)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/mysql/connector/cursor_cext.py", line 266, in execute
    raw_as_string=self._raw_as_string)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/mysql/connector/connection_cext.py", line 475, in cmd_query
    sqlstate=exc.sqlstate)
sqlalchemy.exc.ProgrammingError: (mysql.connector.errors.ProgrammingError) 1054 (42S22): Unknown column 'Profs.first_name' in 'field list'
May 27 11:20:26 PM  [SQL: SELECT `Profs`.first_name AS `Profs_first_name`, `Profs`.last_name AS `Profs_last_name`, `Profs`.phone_number AS `Profs_phone_number`, `Profs`.research_interests AS `Profs_research_interests`, `Profs`.email AS `Profs_email`, `Profs`.office_hours AS `Profs_office_hours`, `Profs`.platform AS `Profs_platform`, `Profs`.latest_quarter AS `Profs_latest_quarter`, `Profs`.office AS `Profs_office`, `Profs`.department AS `Profs_department`, `Profs`.title AS `Profs_title`
May 27 11:20:26 PM  FROM `Profs`]
May 27 11:20:26 PM  (Background on this error at: http://sqlalche.me/e/f405)
May 27 11:20:26 PM  {'entity': 'Dr. Kurfess', 'tag': 'PROF', 'normalized entity': 'Kurfess', 'input question': "What is Dr. Kurfess' email", 'normalized question': "What is [PROF]' email", 'question class': "What is [PROF]'s email?"}
May 27 11:20:26 PM  10.104.78.4 - - [28/May/2020:06:20:26 +0000] "POST /ask HTTP/1.1" 500 290 "-" "PostmanRuntime/7.25.0"
May 27 11:20:27 PM  10.100.3.218 - - [28/May/2020:06:20:27 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0"
May 27 11:20:32 PM  10.104.78.4 - - [28/May/2020:06:20:32 +0000] "GET /ask HTTP/1.1" 405 178 "-" "PostmanRuntime/7.25.0"
May 27 11:20:32 PM  10.100.3.218 - - [28/May/2020:06:20:32 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0"
May 27 11:20:37 PM  10.100.3.218 - - [28/May/2020:06:20:37 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0"
May 27 11:20:39 PM  [2020-05-28 06:20:39 +0000] [70] [INFO] Booting worker with pid: 70
May 27 11:20:41 PM  [2020-05-28 06:20:41,232] ERROR in app: Exception on /ask [POST]
May 27 11:20:41 PM  Traceback (most recent call last):
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/mysql/connector/connection_cext.py", line 472, in cmd_query
    raw_as_string=raw_as_string)
_mysql_connector.MySQLInterfaceError: Unknown column 'Profs.first_name' in 'field list'
May 27 11:20:41 PM  
May 27 11:20:41 PM  During handling of the above exception, another exception occurred:
May 27 11:20:41 PM  
May 27 11:20:41 PM  Traceback (most recent call last):
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
    cursor, statement, parameters, context
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
    cursor.execute(statement, parameters)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/mysql/connector/cursor_cext.py", line 266, in execute
    raw_as_string=self._raw_as_string)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/mysql/connector/connection_cext.py", line 475, in cmd_query
    sqlstate=exc.sqlstate)
mysql.connector.errors.ProgrammingError: 1054 (42S22): Unknown column 'Profs.first_name' in 'field list'
May 27 11:20:41 PM  
May 27 11:20:41 PM  The above exception was the direct cause of the following exception:
May 27 11:20:41 PM  
May 27 11:20:41 PM  initialized database session
May 27 11:20:41 PM  initialized NimbusMySQLAlchemy
May 27 11:20:41 PM  {'entity': 'Dr. Kurfess', 'tag': 'PROF', 'normalized entity': 'Kurfess', 'input question': "What is Dr. Kurfess' email", 'normalized question': "What is [PROF]' email", 'question class': "What is [PROF]'s email?"}
May 27 11:20:41 PM  10.104.78.4 - - [28/May/2020:06:20:41 +0000] "POST /ask HTTP/1.1" 500 290 "-" "PostmanRuntime/7.25.0"
May 27 11:20:41 PM  Traceback (most recent call last):
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app
    response = self.full_dispatch_request()
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function
    return cors_after_request(app.make_response(f(*args, **kwargs)))
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request
    rv = self.dispatch_request()
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/opt/render/project/src/flask_api.py", line 122, in handle_question
    response = {"answer": nimbus.answer_question(question)}
  File "/opt/render/project/src/nimbus.py", line 42, in answer_question
    answer = qa.answer(ans_dict)
  File "/opt/render/project/src/QA.py", line 52, in answer
    db_data = self.db_query(extracted_vars, self.db)
  File "/opt/render/project/src/QA.py", line 231, in _chain_db_access
    for key, val in fn(extracted_vars, db).items():
  File "/opt/render/project/src/QA.py", line 96, in _get_property
    prop=prop, entity=ent, identifier=ent_string
  File "/opt/render/project/src/database_wrapper.py", line 583, in get_property_from_entity
    props = self._get_property_from_entity(prop, entity, identifier, tag_column_map)
  File "/opt/render/project/src/database_wrapper.py", line 558, in _get_property_from_entity
    for row in query_obj.all():
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3233, in all
    return list(self)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3389, in __iter__
    return self._execute_and_instances(context)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3414, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 982, in execute
    return meth(self, multiparams, params)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 293, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1101, in _execute_clauseelement
    distilled_params,
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1250, in _execute_context
    e, statement, parameters, cursor, context
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1476, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
    raise value.with_traceback(tb)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
    cursor, statement, parameters, context
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
    cursor.execute(statement, parameters)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/mysql/connector/cursor_cext.py", line 266, in execute
    raw_as_string=self._raw_as_string)
  File "/opt/render/project/src/.venv/lib/python3.7/site-packages/mysql/connector/connection_cext.py", line 475, in cmd_query
    sqlstate=exc.sqlstate)
sqlalchemy.exc.ProgrammingError: (mysql.connector.errors.ProgrammingError) 1054 (42S22): Unknown column 'Profs.first_name' in 'field list'
May 27 11:20:41 PM  [SQL: SELECT `Profs`.first_name AS `Profs_first_name`, `Profs`.last_name AS `Profs_last_name`, `Profs`.phone_number AS `Profs_phone_number`, `Profs`.research_interests AS `Profs_research_interests`, `Profs`.email AS `Profs_email`, `Profs`.office_hours AS `Profs_office_hours`, `Profs`.platform AS `Profs_platform`, `Profs`.latest_quarter AS `Profs_latest_quarter`, `Profs`.office AS `Profs_office`, `Profs`.department AS `Profs_department`, `Profs`.title AS `Profs_title`
May 27 11:20:41 PM  FROM `Profs`]
May 27 11:20:41 PM  (Background on this error at: http://sqlalche.me/e/f405)
May 27 11:20:41 PM  10.104.78.4 - - [28/May/2020:06:20:41 +0000] "GET /ask HTTP/1.1" 405 178 "-" "PostmanRuntime/7.25.0"
render[bot] commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live!

View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

render[bot] commented 4 years ago

A deploy for your Render PR Server at https://nimbus-pr-162.onrender.com just failed.

View details on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

render[bot] commented 4 years ago

Your Render PR Server at https://nimbus-pr-162.onrender.com is now live!

View it on your dashboard at https://dashboard.render.com/web/srv-br7k3qg60jaqq47hqvb0.

mfekadu commented 4 years ago

YAY! good logs

expand to see

``` May 27 11:47:17 PM initialized NimbusMySQLAlchemy May 27 11:47:17 PM Saved model : /opt/render/project/src/nimbus_nlp/models/classification/nlp-model_05_28_2020_06_46_32.pkl May 27 11:47:17 PM {'entity': 'Dr. Kurfess', 'tag': 'PROF', 'normalized entity': 'Kurfess', 'input question': "What is Dr. Kurfess' email", 'normalized question': "What is [PROF]' email", 'question class': 'What is the email of [PROF]?'} May 27 11:47:17 PM [(84, ['Kurt', 'Voelker'], 'kvoelker@calpoly.edu')] May 27 11:47:17 PM 10.104.78.4 - - [28/May/2020:06:47:17 +0000] "POST /ask HTTP/1.1" 200 78 "-" "PostmanRuntime/7.25.0" ``` ``` May 27 11:47:18 PM 10.100.3.218 - - [28/May/2020:06:47:18 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:47:23 PM 10.100.3.218 - - [28/May/2020:06:47:23 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:47:28 PM 10.100.3.218 - - [28/May/2020:06:47:28 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:47:33 PM 10.100.3.218 - - [28/May/2020:06:47:33 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:47:38 PM 10.100.3.218 - - [28/May/2020:06:47:38 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:47:42 PM initialized database session May 27 11:47:42 PM initialized NimbusMySQLAlchemy May 27 11:47:42 PM {'entity': 'Dr. Kurfess', 'tag': 'PROF', 'normalized entity': 'Kurfess', 'input question': "What is Dr. Kurfess' email?", 'normalized question': "What is [PROF]' email?", 'question class': 'What is the email of [PROF]?'} May 27 11:47:42 PM [(84, ['Kurt', 'Voelker'], 'kvoelker@calpoly.edu')] May 27 11:47:42 PM 10.104.78.4 - - [28/May/2020:06:47:42 +0000] "POST /ask HTTP/1.1" 200 78 "-" "PostmanRuntime/7.25.0" May 27 11:47:43 PM 10.100.3.218 - - [28/May/2020:06:47:43 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:47:48 PM 10.100.3.218 - - [28/May/2020:06:47:48 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:47:53 PM 10.100.3.218 - - [28/May/2020:06:47:53 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" ``` ``` May 27 11:47:54 PM {'entity': 'Dr. Foaad', 'tag': 'PROF', 'normalized entity': 'Foaad', 'input question': "What is Dr. Foaad's email?", 'normalized question': "What is [PROF]'s email?", 'question class': 'What is the email of [PROF]?'} May 27 11:47:54 PM [(111, ['Sara', 'Ford'], 'ssford@calpoly.edu'), (131, ['Foaad', 'Khosmood'], 'foaad@calpoly.edu')] May 27 11:47:54 PM 10.104.78.4 - - [28/May/2020:06:47:54 +0000] "POST /ask HTTP/1.1" 200 73 "-" "PostmanRuntime/7.25.0" May 27 11:47:58 PM 10.100.3.218 - - [28/May/2020:06:47:58 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:48:03 PM 10.100.3.218 - - [28/May/2020:06:48:03 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:48:08 PM 10.100.3.218 - - [28/May/2020:06:48:08 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:48:13 PM 10.100.3.218 - - [28/May/2020:06:48:13 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:48:18 PM 10.100.3.218 - - [28/May/2020:06:48:18 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:48:22 PM [2020-05-28 06:48:22 +0000] [103] [INFO] Booting worker with pid: 103 May 27 11:48:23 PM 10.100.3.218 - - [28/May/2020:06:48:23 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" ``` ``` May 27 11:48:25 PM initialized database session May 27 11:48:25 PM initialized NimbusMySQLAlchemy May 27 11:48:25 PM {'entity': 'mammen', 'tag': 'PROF', 'normalized entity': 'mammen', 'input question': 'What sections does mammen teach?', 'normalized question': 'What sections does [PROF] teach?', 'question class': 'How many sections does [PROF] teach?'} May 27 11:48:25 PM [(91, ['James', 'Mealy'], 'CPE 233_03'), (91, ['James', 'Mealy'], 'CPE 233_04'), (91, ['James', 'Mealy'], 'EE 462_06'), (91, ['James', 'Mealy'], 'CPE 233_01'), (91, ['James', 'Mealy'], 'CPE 233_02'), (100, ['Kurt', 'Mammen'], 'CPE 357_07'), (100, ['Kurt', 'Mammen'], 'CPE 357_06'), (100, ['Kurt', 'Mammen'], 'CPE 357_08'), (100, ['Kurt', 'Mammen'], 'CPE 357_05'), (100, ['Kurt', 'Mammen'], 'CPE 357_09'), (100, ['Kurt', 'Mammen'], 'CPE 357_10')] May 27 11:48:25 PM 10.104.78.4 - - [28/May/2020:06:48:25 +0000] "POST /ask HTTP/1.1" 200 134 "-" "PostmanRuntime/7.25.0" May 27 11:48:28 PM 10.100.3.218 - - [28/May/2020:06:48:28 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" ``` ``` May 27 11:48:33 PM 10.100.3.218 - - [28/May/2020:06:48:33 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:48:38 PM 10.100.3.218 - - [28/May/2020:06:48:38 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:48:43 PM 10.100.3.218 - - [28/May/2020:06:48:43 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" May 27 11:48:45 PM {'entity': 'Foaad', 'tag': 'PROF', 'normalized entity': 'Foaad', 'input question': "When are Foaad's office hours?", 'normalized question': "When are [PROF]'s office hours?", 'question class': "When are [PROF]'s office hours?"} May 27 11:48:45 PM [(111, ['Sara', 'Ford'], 'Monday 10:30 - 11:30 am, Tuesday 3:30 - 4:30 pm, Wednesday 10:30 - 11:30 am, Thursday 3:30 - 4:30 pm, Friday 10:30 - 11:30 am or by appt., '), (131, ['Foaad', 'Khosmood'], 'TR 4:10-6:00 PM, Wed. 12:10-1:00 PM')] May 27 11:48:45 PM 10.104.78.4 - - [28/May/2020:06:48:45 +0000] "POST /ask HTTP/1.1" 200 99 "-" "PostmanRuntime/7.25.0" May 27 11:48:48 PM 10.100.3.218 - - [28/May/2020:06:48:48 +0000] "GET / HTTP/1.1" 200 37 "-" "Render/1.0" ``` ``` May 27 11:49:52 PM {'entity': 'CSC 357', 'tag': 'COURSE', 'normalized entity': 'CSC 357', 'input question': 'What are the prerequisites for CSC 357?', 'normalized question': 'What are the prerequisites for [COURSE]?', 'question class': 'What are the prerequisites for [COURSE]?'} May 27 11:49:52 PM [(84, ['CSC', '492', 'Senior Project II.'], 'CSC 491 and consent of instructor.'), (84, ['CSC', '498', 'Research Senior Project II.'], 'CSC 497 and consent of instructor.'), (85, ['CSC', '231', 'Programming for Engineering Students.'], 'MATH 142; PHYS 121 or PHYS 131 or PHYS 141.'), (85, ['CSC', '400', 'Special Problems.'], 'Consent of instructor.'), (85, ['CSC', '454', 'Implementation of Operating Systems.'], 'CSC/CPE 453.'), (85, ['CSC', '491', 'Senior Project I.'], 'CSC 307 or CSC 309; and consent of instructor.'), (86, ['CSC', '290', 'Selected Topics.'], 'Open to undergraduate students and consent of instructor.'), (87, ['CSC', '430', 'Programming Languages.'], 'CSC 349 and CSC/CPE 357.'), (88, ['CSC', '366', 'Database Modeling, Design and Implementation.'], 'CSC 365.'), (88, ['CSC', '550', 'Operating Systems.'], 'CSC/CPE 453 and graduate standing, or consent of instructor.'), (90, ['CSC', '349', 'Design and Analysis of Algorithms.'], 'CSC 141 and MATH 142; or CSC 348 and MATH 142; or CPE/CSC 102 and CPE/ CSC 103 and MATH 248; or CPE/CSC 202 and CPE/ CSC 203 and MATH 248.'), (90, ['CSC', '453', 'Introduction to Operating Systems.'], 'CSC/CPE 357, and CSC/CPE 225 or CPE/EE 229 or CPE/EE 233.'), (90, ['CSC', '487', 'Deep Learning.'], 'CSC 349, and MATH 206 or MATH 244.'), (91, ['CSC', '236', 'Fundamentals of Computer Science for Scientists and Engineers II.'], 'CSC 235 with a grade of C- or better, or consent of instructor.'), (91, ['CSC', '300', 'Professional Responsibilities.'], 'CSC/CPE 357 and junior standing.'), (91, ['CSC', '436', 'Mobile Application Development.'], 'CSC/CPE 357.'), (91, ['CSC', '473', 'Advanced Rendering Techniques.'], 'CSC/CPE 471.'), (92, ['CSC', '105', 'Fundamentals of Computer Science I Supplemental Instruction.'], 'NA'), (92, ['CSC', '123', 'Introduction to Computing.'], 'Basic computer literacy.'), (92, ['CSC', '171', 'Introduction to Interactive Entertainment.'], 'NA'), (92, ['CSC', '301', 'Personal Software Process.'], 'CSC/CPE 102 and CSC/CPE 103, or CSC/CPE 202 and CSC/CPE 203.'), (92, ['CSC', '323', 'Cryptography Engineering.'], 'CPE/CSC 357.'), (92, ['CSC', '477', 'Scientific and Information Visualization.'], 'CSC 349.'), (92, ['CSC', '530', 'Languages and Translators.'], 'CSC 430 and graduate standing, or consent of instructor.'), (92, ['CSC', '540', 'Theory of Computation II.'], 'CSC 445 and graduate standing, or consent of instructor.'), (92, ['CSC', '581', 'Computer Support for Knowledge Management.'], 'CSC 480 or CSC 484 or consent of instructor.'), (93, ['CSC', '203', 'Project-Based Object-Oriented Programming and Design.'], 'CPE/CSC 202 with a grade of C- or better or consent of instructor.'), (93, ['CSC', '225', 'Introduction to Computer Organization.'], 'CSC/CPE 202.'), (93, ['CSC', '308', 'Software Engineering I.'], 'CSC 141 or CSC 348.'), (93, ['CSC', '309', 'Software Engineering II.'], 'CSC 308 and CSC/CPE 357.'), (93, ['CSC', '369', 'Introduction to Distributed Computing.'], 'CSC/CPE 102 and CSC/CPE 103, or CSC/CPE 202 and CSC/CPE 203; and one of the STAT 301, STAT 312, STAT 321 or STAT 350.'), (93, ['CSC', '445', 'Theory of Computation I.'], 'CSC 141 or CSC 348.'), (93, ['CSC', '476', 'Real-Time 3D Computer Graphics Software.'], 'CSC/CPE 471.'), (93, ['CSC', '508', 'Software Engineering I.'], 'CSC 307 or CSC 308 and graduate standing, or consent of instructor.'), (93, ['CSC', '509', 'Software Engineering II.'], 'CSC 508 and graduate standing, or consent of instructor.'), (93, ['CSC', '549', 'Advanced Algorithm Design and Analysis.'], 'CSC 349.'), (93, ['CSC', '580', 'Artificial Intelligence.'], 'CSC 480 and graduate standing, or consent of instructor.'), (93, ['CPE', '350', 'Capstone I.'], 'NA'), (94, ['CSC', '232', 'Computer Programming for Scientists and Engineers.'], 'MATH 118 or equivalent.'), (94, ['CSC', '515', 'Computer Architecture.'], 'CPE 315 or CPE 333, and graduate standing; or consent of instructor.'), (94, ['CSC', '569', 'Distributed Computing.'], 'CSC 141 or CSC 348; and CPE/CSC 357; or graduate standing and consent of instructor.'), (94, ['CSC', '599', 'Thesis.'], 'CSC 590; CSC 498 or CSC 597; selection of thesis committee; graduate standing; and consent of instructor.'), (95, ['CSC', '313', 'Teaching Computing.'], 'CPE/CSC 202.'), (95, ['CSC', '321', 'Introduction to Computer Security.'], 'CPE/CSC 357.'), (95, ['CSC', '471', 'Introduction to Computer Graphics.'], 'CPE/CSC 357.'), (95, ['CSC', '474', 'Computer Animation.'], 'CSC/CPE 471.'), (95, ['CSC', '483', 'Current Topics in Human-Computer Interaction.'], 'CSC 484.'), (95, ['CSC', '493', 'Cooperative Education Experience.'], 'Sophomore standing and consent of instructor.'), (95, ['CSC', '495', 'Cooperative Education Experience.'], 'Sophomore standing and consent of instructor.'), (95, ['CSC', '593', 'Cooperative Education Experience.'], 'Graduate standing and consent of instructor.'), (95, ['CSC', '594', 'Cooperative Education Experience.'], 'Graduate standing and consent of instructor.'), (95, ['CSC', '595', 'Cooperative Education Experience.'], 'Graduate standing and consent of instructor.'), (95, ['CPE', '357', 'Systems Programming.'], 'CSC/CPE 102 and CSC/CPE 103 with a grade of C- or better or consent of instructor, or CSC/CPE 202 and CSC/CPE 203 with a grade of C- or better or consent of instructor; and CSC 225 or CPE/EE 229 or CPE/EE 233.'), (96, ['CSC', '311', 'Computational Art.'], 'Junior standing; completion of GE Area A with grades of C- or better; and completion of GE Areas B1 through B4, with a grade of C- or better in one course in GE Area B4 (GE Area B1 for students on the 2019-20 or earlier catalogs).'), (96, ['CSC', '450', 'Computing for Interactive Arts Capstone II.'], 'ART/CSC 350.'), (97, ['CSC', '320', 'Practical Computer Security for Everyone.'], 'Junior standing; completion of GE Area A with grades of C- or better; and completion of GE Areas B1 through B4, with a grade of C- or better in one course in GE Area B4 (GE Area B1 for students on the 2019-20 or earlier catalogs).'), (97, ['CSC', '560', 'Database Systems.'], 'CSC 365 and graduate standing, or consent of instructor.'), (98, ['CSC', '303', 'Teaching Computer Science.'], 'CSC/CPE 102 and CSC/CPE 103, with a grade of C- or better or consent of instructor, or CSC/CPE 202 and CSC/CPE 203, with a grade of C- or better or consent of instructor.'), (98, ['CSC', '500', 'Directed Study.'], 'Fully classified graduate standing and consent of instructor.'), (98, ['CSC', '582', 'Computational Linguistics.'], 'CSC 482 and graduate standing.'), (98, ['CSC', '590', 'Thesis Seminar.'], 'Graduate standing or consent of instructor.'), (99, ['CSC', '458', 'Current Topics in Computer Systems.'], 'CSC/CPE 357.'), (99, ['CSC', '478', 'Current Topics in Computer Graphics.'], 'CSC/CPE 471.'), (99, ['CSC', '564', 'Computer Networks: Research Topics.'], 'CSC/CPE 464 and graduate standing, or consent of instructor.'), (101, ['CSC', '302', 'Computers and Society.'], 'Junior standing; completion of GE Area A with grades of C- or better; and completion of GE Areas B1 through B4, with a grade of C- or better in one course in GE Area B4 (GE Area B1 for students on the 2019-20 or earlier catalogs).'), (101, ['CSC', '405', 'Software Construction.'], 'CSC 305 and CSC 402.'), (101, ['CSC', '431', 'Compiler Construction.'], 'CSC 430.'), (101, ['CSC', '566', 'Topics in Advanced Data Mining.'], 'CSC 466 or CSC 480 or CSC 582.'), (101, ['CSC', '596', 'Research in Computer Science I.'], 'Consent of instructor.'), (102, ['CSC', '234', 'C and Unix.'], 'MATH 142.'), (102, ['CSC', '310', 'Computers for Poets.'], 'Junior standing; completion of GE Area A with grades of C- or better; and completion of GE Areas B1 through B4, with a grade of C- or better in one course in GE Area B4 (GE Area B1 for students on the 2019-20 or earlier catalogs).'), (102, ['CSC', '348', 'Discrete Structures.'], 'CSC/CPE 102 and CSC/CPE 103, with a grade of C- or better or consent of instructor, or CSC/CPE 202 and CSC/CPE 203, with a grade of C- or better or consent of instructor.'), (104, ['CSC', '344', 'Music Programming.'], 'CSC 141 or CSC 348; and CPE/CSC 357.'), (104, ['CSC', '497', 'Research Senior Project I.'], 'CSC 307 or CSC 309; and consent of instructor.'), (104, ['CSC', '521', 'Computer Security.'], 'CPE/CSC 321 and graduate standing.'), (108, ['CSC', '305', 'Individual Software Design and Development.'], 'CSC/CPE 357.'), (109, ['CSC', '378', 'Interactive Entertainment Engineering.'], 'CPE/CSC 102 and CPE/CSC 103, or CPE/CSC 202 and junior standing.'), (110, ['CSC', '435', 'Introduction to Object Oriented Design Using Graphical User Interfaces.'], 'CSC 305.'), (111, ['CSC', '235', 'Fundamentals of Computer Science for Scientists and Engineers I.'], 'MATH 141 or MATH 161 with a grade of C- or better, or consent of instructor.'), (111, ['CSC', '325', 'Introduction to Privacy: Policy and Technology.'], 'CSC 300.'), (111, ['CSC', '371', 'Game Design.'], 'CSC/CPE 102 and CSC/CPE 103; or CSC/CPE 202 and junior standing.'), (111, ['CSC', '377', 'Introduction to Mixed Reality.'], 'CPE/CSC 202.'), (113, ['CSC', '437', 'Dynamic Web Development.'], 'CPE/CSC 357 with a grade of C- or better and CSC 365 with a grade of C- or better; or consent of instructor.'), (114, ['CSC', '307', 'Introduction to Software Engineering.'], 'CSC 141 or CSC 348; and CPE/CSC 357.'), (115, ['CSC', '365', 'Introduction to Database Systems.'], 'CSC 141; or CSC 348; or CPE/CSC 102 and CPE/CSC 103 and MATH 248; or CPE/CSC 202 and CPE/CSC 203 and MATH 248.'), (116, ['CSC', '350', 'Computing for Interactive Arts Capstone I.'], 'ART 384; CSC/CPE 103 or CSC/CPE 202; and junior standing.'), (116, ['CSC', '572', 'Computer Graphics.'], 'Successful completion of CSC/CPE 471 and graduate standing, or consent of instructor.'), (119, ['CSC', '570', 'Current Topics in Computer Science.'], 'Graduate standing and evidence of satisfactory preparation in computer science.'), (121, ['CSC', '597', 'Research in Computer Science II.'], 'CSC 596 and consent of instructor.'), (135, ['CSC', '357', 'Systems Programming.'], 'CSC/CPE 102 and CSC/CPE 103 with a grade of C- or better or consent of instructor, or CSC/CPE 202 and CSC/CPE 203 with a grade of C- or better or consent of instructor; and CSC 225 or CPE/EE 229 or CPE/EE 233.')] May 27 11:49:52 PM 10.104.78.4 - - [28/May/2020:06:49:52 +0000] "POST /ask HTTP/1.1" 200 285 "-" "PostmanRuntime/7.25.0" ```