Report this

What is the reason for this report?

App Platform: API works perfect in prod but doesn't work

Posted on October 16, 2020

Hey all,

I’m writing an API and my API works completely on my machine, but then when I deploy it to DO’s App platform the auth and login functionality works but my schedulecontent/ resource breaks complaining:

phlik-it | 2020-10-15 20:00:12 10.244.0.43 - - [16/Oct/2020 01:00:12] "GET /schedulecontent HTTP/1.1" 308 -
phlik-it | 2020-10-15 20:00:12 [2020-10-16 01:00:12,517] ERROR in app: Exception on /schedulecontent/ [GET]
phlik-it | 2020-10-15 20:00:12 Traceback (most recent call last):
phlik-it | 2020-10-15 20:00:12   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1950, in full_dispatch_request
phlik-it | 2020-10-15 20:00:12     rv = self.dispatch_request()
phlik-it | 2020-10-15 20:00:12   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1936, in dispatch_request
phlik-it | 2020-10-15 20:00:12     return self.view_functions[rule.endpoint](**req.view_args)
phlik-it | 2020-10-15 20:00:12   File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 468, in wrapper
phlik-it | 2020-10-15 20:00:12     resp = resource(*args, **kwargs)
phlik-it | 2020-10-15 20:00:12   File "/usr/local/lib/python3.7/site-packages/flask/views.py", line 89, in view
phlik-it | 2020-10-15 20:00:12     return self.dispatch_request(*args, **kwargs)
phlik-it | 2020-10-15 20:00:12   File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 583, in dispatch_request
phlik-it | 2020-10-15 20:00:12     resp = meth(*args, **kwargs)
phlik-it | 2020-10-15 20:00:12   File "/usr/local/lib/python3.7/site-packages/flask_jwt/__init__.py", line 177, in decorator
phlik-it | 2020-10-15 20:00:12     return fn(*args, **kwargs)
phlik-it | 2020-10-15 20:00:12   File "/app/Resources/ScheduleContent.py", line 54, in get
phlik-it | 2020-10-15 20:00:12     cursor.execute(query)
phlik-it | 2020-10-15 20:00:12 sqlite3.OperationalError: no such column: None

and this makes no sense because everything is working just fine locally so there’s nothing for me to troubleshoot?

Any help or guidance on troubleshooting something like this would be MUCH appreciated.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.