Flask Deprecation warnings on install

[dugjason]

I'm receiving the following warnings when pip installing Caravel 0.10.0 on Ubuntu (Python 2.7.11)

/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.script is deprecated, use flask_script instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy is deprecated, use flask_sqlalchemy instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy._compat is deprecated, use flask_sqlalchemy._compat instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask_cache/__init__.py:152: UserWarning: Flask-Cache: CACHE_TYPE is set to null, caching is effectively disabled.
  warnings.warn("Flask-Cache: CACHE_TYPE is set to null, "
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.cache is deprecated, use flask_cache instead.
  .format(x=modname), ExtDeprecationWarning

I've run upgrades to various Flask packages, but continue to see this error. Does anyone have any suggestions?

[xrmx]

The suggestion is to understand that warnings are not errors and so there's no need to open issues here :) Also it has already been taken care of them in master.

[dugjason]

Thanks. Perhaps my issue was a little vague; I'm seeing these warnings loop after I start caravel. I see a cycle of workers starting, these warnings, workers dying, then the cycle repeating indefinitely.

Upgrading to the version of Caravel currently in Master (latest commit is 30ef8eb), I still see this cycle of errors, and am unable to load caravel via a browser;

2016-08-19 13:53:56,890:INFO:flask_appbuilder.base:Registering class PermissionModelView on menu Base Permissions
2016-08-19 13:53:57,212:INFO:flask_appbuilder.base:Registering class PermissionModelView on menu Base Permissions
2016-08-19 13:53:57,250:INFO:flask_appbuilder.base:Registering class PermissionViewModelView on menu Permission on Views/Menus
2016-08-19 13:53:57,454:INFO:flask_appbuilder.base:Registering class UserStatsChartView on menu User's Statistics
2016-08-19 13:53:57,547:INFO:flask_appbuilder.base:Registering class ViewMenuModelView on menu Views/Menus
2016-08-19 13:53:57,563:INFO:flask_appbuilder.base:Registering class PermissionViewModelView on menu Permission on Views/Menus
2016-08-19 13:53:57,843:INFO:flask_appbuilder.base:Registering class PermissionViewModelView on menu Permission on Views/Menus
2016-08-19 13:53:57,880:INFO:flask_appbuilder.base:Registering class RoleModelView on menu List Roles
2016-08-19 13:53:58,098:INFO:flask_appbuilder.base:Registering class PermissionModelView on menu Base Permissions
2016-08-19 13:53:58,345:INFO:flask_appbuilder.base:Registering class ViewMenuModelView on menu Views/Menus
2016-08-19 13:53:58,383:INFO:flask_appbuilder.base:Registering class UserStatsChartView on menu User's Statistics
2016-08-19 13:53:59,116:INFO:flask_appbuilder.base:Registering class ViewMenuModelView on menu Views/Menus
2016-08-19 13:53:59,269:INFO:flask_appbuilder.base:Registering class RoleModelView on menu List Roles
2016-08-19 13:53:59,369:INFO:flask_appbuilder.base:Registering class PermissionModelView on menu Base Permissions
[2016-08-19 13:53:59 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12460)
[2016-08-19 13:53:59 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12468)
[2016-08-19 13:53:59 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12471)
[2016-08-19 13:53:59 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12473)
2016-08-19 13:53:59,766:INFO:flask_appbuilder.base:Registering class PermissionViewModelView on menu Permission on Views/Menus
[2016-08-19 13:53:59 +0000] [12468] [INFO] Worker exiting (pid: 12468)
2016-08-19 13:53:59,856:INFO:flask_appbuilder.base:Registering class PermissionViewModelView on menu Permission on Views/Menus
2016-08-19 13:53:59,951:INFO:flask_appbuilder.base:Registering class UserStatsChartView on menu User's Statistics
[2016-08-19 13:54:00 +0000] [12460] [INFO] Worker exiting (pid: 12460)
[2016-08-19 13:53:59 +0000] [12471] [INFO] Worker exiting (pid: 12471)
[2016-08-19 13:54:00 +0000] [12473] [INFO] Worker exiting (pid: 12473)
[2016-08-19 13:54:00 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12483)
[2016-08-19 13:54:00 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12489)
[2016-08-19 13:54:00 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12492)
[2016-08-19 13:54:00 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12497)
[2016-08-19 13:54:00 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12501)
[2016-08-19 13:54:00 +0000] [12492] [INFO] Worker exiting (pid: 12492)
[2016-08-19 13:54:00 +0000] [12483] [INFO] Worker exiting (pid: 12483)
[2016-08-19 13:54:00 +0000] [12489] [INFO] Worker exiting (pid: 12489)
[2016-08-19 13:54:00 +0000] [12704] [INFO] Booting worker with pid: 12704
2016-08-19 13:54:01,002:INFO:flask_appbuilder.base:Registering class PermissionModelView on menu Base Permissions
[2016-08-19 13:54:01 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12516)
[2016-08-19 13:54:01 +0000] [12516] [INFO] Worker exiting (pid: 12516)
2016-08-19 13:54:01,283:INFO:flask_appbuilder.base:Registering class UserStatsChartView on menu User's Statistics
2016-08-19 13:54:01,384:INFO:flask_appbuilder.base:Registering class ViewMenuModelView on menu Views/Menus
2016-08-19 13:54:01,574:INFO:flask_appbuilder.base:Registering class PermissionModelView on menu Base Permissions
[2016-08-19 13:54:01 +0000] [12707] [INFO] Booting worker with pid: 12707
[2016-08-19 13:54:01 +0000] [12708] [INFO] Booting worker with pid: 12708
[2016-08-19 13:54:01 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12553)
[2016-08-19 13:54:01 +0000] [12553] [INFO] Worker exiting (pid: 12553)
[2016-08-19 13:54:01 +0000] [12709] [INFO] Booting worker with pid: 12709
[2016-08-19 13:54:02 +0000] [12714] [INFO] Booting worker with pid: 12714
[2016-08-19 13:54:02 +0000] [12725] [INFO] Booting worker with pid: 12725
[2016-08-19 13:54:02 +0000] [12726] [INFO] Booting worker with pid: 12726
[2016-08-19 13:54:03 +0000] [12732] [INFO] Booting worker with pid: 12732
2016-08-19 13:54:03,343:INFO:flask_appbuilder.base:Registering class ViewMenuModelView on menu Views/Menus
[2016-08-19 13:54:03 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12554)
[2016-08-19 13:54:03 +0000] [12736] [INFO] Booting worker with pid: 12736
[2016-08-19 13:54:03 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12566)
[2016-08-19 13:54:03 +0000] [12554] [INFO] Worker exiting (pid: 12554)
[2016-08-19 13:54:03 +0000] [12737] [INFO] Booting worker with pid: 12737
[2016-08-19 13:54:03 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12568)
[2016-08-19 13:54:03 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12584)
[2016-08-19 13:54:03 +0000] [12738] [INFO] Booting worker with pid: 12738
[2016-08-19 13:54:04 +0000] [12584] [INFO] Worker exiting (pid: 12584)
[2016-08-19 13:54:04 +0000] [12741] [INFO] Booting worker with pid: 12741
[2016-08-19 13:54:04 +0000] [12321] [CRITICAL] WORKER TIMEOUT (pid:12611)
[2016-08-19 13:54:04 +0000] [12611] [INFO] Worker exiting (pid: 12611)
[2016-08-19 13:54:04 +0000] [12745] [INFO] Booting worker with pid: 12745
[2016-08-19 13:54:04 +0000] [12744] [INFO] Booting worker with pid: 12744
[2016-08-19 13:54:05 +0000] [12746] [INFO] Booting worker with pid: 12746
[2016-08-19 13:54:05 +0000] [12747] [INFO] Booting worker with pid: 12747
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy is deprecated, use flask_sqlalchemy instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy._compat is deprecated, use flask_sqlalchemy._compat instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy is deprecated, use flask_sqlalchemy instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy._compat is deprecated, use flask_sqlalchemy._compat instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy is deprecated, use flask_sqlalchemy instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy._compat is deprecated, use flask_sqlalchemy._compat instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy is deprecated, use flask_sqlalchemy instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy._compat is deprecated, use flask_sqlalchemy._compat instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy is deprecated, use flask_sqlalchemy instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy._compat is deprecated, use flask_sqlalchemy._compat instead.
  .format(x=modname), ExtDeprecationWarning
/home/caravel/.pyenv/versions/2.7.11/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.script is deprecated, use flask_script instead.
  .format(x=modname), ExtDeprecationWarning

[xrmx]

@dugjason vague is an understatement, it's more unrelated :) It looks like there's something wrong with your gunicorn conf as the master can't talk with workers. Is it the default one?

[dugjason]

Yes; default gunicorn config. gunicorn is not a tool I'm familiar with; is there anything in particular I should be looking at?

[mistercrunch]

My guess is you might have system restrictions of some kind. What kind of environment are you in? You probably want to run your own gunicorn command at this point to debug. Make it a single worker, and use --log-level=DEBUG.

[dugjason]

I'm running on a pretty standard Ubuntu 14.04.5 install on EC2.

Looks like it starts to load caravel, then gunicorn fails on importing the app;

caravel@ip-10-73-xxx-xxx:~$ gunicorn -w1 --log-level=DEBUG caravel
[2016-08-22 13:20:37 +0000] [6869] [DEBUG] Current configuration:
  secure_scheme_headers: {'X-FORWARDED-PROTOCOL': 'ssl', 'X-FORWARDED-PROTO': 'https', 'X-FORWARDED-SSL': 'on'}
  proxy_protocol: False
  worker_connections: 1000
  statsd_host: None
  max_requests_jitter: 0
  post_fork: <function post_fork at 0x7f8631377758>
  pythonpath: None
  enable_stdio_inheritance: False
  worker_class: sync
  ssl_version: 3
  suppress_ragged_eofs: True
  syslog: False
  syslog_facility: user
  when_ready: <function when_ready at 0x7f8631377488>
  pre_fork: <function pre_fork at 0x7f86313775f0>
  cert_reqs: 0
  preload_app: False
  keepalive: 2
  accesslog: None
  group: 1011
  graceful_timeout: 30
  do_handshake_on_connect: False
  spew: False
  workers: 1
  proc_name: None
  sendfile: None
  pidfile: None
  umask: 0
  on_reload: <function on_reload at 0x7f8631377320>
  pre_exec: <function pre_exec at 0x7f8631377cf8>
  worker_tmp_dir: None
  post_worker_init: <function post_worker_init at 0x7f86313778c0>
  limit_request_fields: 100
  on_exit: <function on_exit at 0x7f863137e410>
  config: None
  logconfig: None
  check_config: False
  statsd_prefix:
  proxy_allow_ips: ['127.0.0.1']
  pre_request: <function pre_request at 0x7f8631377e60>
  post_request: <function post_request at 0x7f8631377f50>
  user: 1012
  forwarded_allow_ips: ['127.0.0.1']
  worker_int: <function worker_int at 0x7f8631377a28>
  threads: 1
  max_requests: 0
  limit_request_line: 4094
  access_log_format: %(h)s %(l)s %(u)s %(t)s "%(r)s" %(s)s %(b)s "%(f)s" "%(a)s"
  certfile: None
  worker_exit: <function worker_exit at 0x7f863137e140>
  chdir: /home/caravel
  paste: None
  default_proc_name: caravel
  errorlog: -
  loglevel: DEBUG
  capture_output: False
  syslog_addr: udp://localhost:514
  syslog_prefix: None
  daemon: False
  ciphers: TLSv1
  on_starting: <function on_starting at 0x7f86313771b8>
  worker_abort: <function worker_abort at 0x7f8631377b90>
  bind: ['127.0.0.1:8000']
  raw_env: []
  reload: False
  limit_request_field_size: 8190
  nworkers_changed: <function nworkers_changed at 0x7f863137e2a8>
  timeout: 30
  ca_certs: None
  django_settings: None
  tmp_upload_dir: None
  keyfile: None
  backlog: 2048
  logger_class: gunicorn.glogging.Logger
[2016-08-22 13:20:37 +0000] [6869] [INFO] Starting gunicorn 19.6.0
[2016-08-22 13:20:37 +0000] [6869] [DEBUG] Arbiter booted
[2016-08-22 13:20:37 +0000] [6869] [INFO] Listening at: http://127.0.0.1:8000 (6869)
[2016-08-22 13:20:37 +0000] [6869] [INFO] Using worker: sync
[2016-08-22 13:20:37 +0000] [6874] [INFO] Booting worker with pid: 6874
[2016-08-22 13:20:37 +0000] [6869] [DEBUG] 1 workers
/usr/local/lib/python2.7/dist-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy is deprecated, use flask_sqlalchemy instead.
  .format(x=modname), ExtDeprecationWarning
/usr/local/lib/python2.7/dist-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy._compat is deprecated, use flask_sqlalchemy._compat instead.
  .format(x=modname), ExtDeprecationWarning
/usr/local/lib/python2.7/dist-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.script is deprecated, use flask_script instead.
  .format(x=modname), ExtDeprecationWarning
/usr/local/lib/python2.7/dist-packages/flask_cache/__init__.py:152: UserWarning: Flask-Cache: CACHE_TYPE is set to null, caching is effectively disabled.
  warnings.warn("Flask-Cache: CACHE_TYPE is set to null, "
/usr/local/lib/python2.7/dist-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.cache is deprecated, use flask_cache instead.
  .format(x=modname), ExtDeprecationWarning
2016-08-22 13:20:39,355:INFO:flask_appbuilder.base:Registering class MyIndexView on menu
2016-08-22 13:20:39,389:INFO:flask_appbuilder.base:Registering class UtilView on menu
2016-08-22 13:20:39,393:INFO:flask_appbuilder.base:Registering class LocaleView on menu
2016-08-22 13:20:39,398:INFO:flask_appbuilder.base:Registering class ResetPasswordView on menu
2016-08-22 13:20:39,441:INFO:flask_appbuilder.base:Registering class ResetMyPasswordView on menu
2016-08-22 13:20:39,454:INFO:flask_appbuilder.base:Registering class UserInfoEditView on menu
2016-08-22 13:20:39,490:INFO:flask_appbuilder.base:Registering class AuthDBView on menu
2016-08-22 13:20:39,500:INFO:flask_appbuilder.base:Registering class UserDBModelView on menu List Users
2016-08-22 13:20:39,594:INFO:flask_appbuilder.base:Registering class RoleModelView on menu List Roles
2016-08-22 13:20:39,681:INFO:flask_appbuilder.base:Registering class UserStatsChartView on menu User's Statistics
2016-08-22 13:20:39,733:INFO:flask_appbuilder.base:Registering class PermissionModelView on menu Base Permissions
2016-08-22 13:20:39,789:INFO:flask_appbuilder.base:Registering class ViewMenuModelView on menu Views/Menus
2016-08-22 13:20:39,882:INFO:flask_appbuilder.base:Registering class PermissionViewModelView on menu Permission on Views/Menus
2016-08-22 13:20:41,670:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-22 13:20:41,671:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-22 13:20:41,674:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-22 13:20:41,674:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-22 13:20:41,675:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-22 13:20:41,675:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-22 13:20:41,677:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-22 13:20:41,677:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-22 13:20:41,677:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-22 13:20:41,678:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-22 13:20:41,678:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-22 13:20:41,678:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-22 13:20:41,681:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-22 13:20:41,681:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-22 13:20:41,682:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-22 13:20:41,682:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-22 13:20:41,682:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-22 13:20:41,682:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-22 13:20:41,690:INFO:flask_appbuilder.base:Registering class TableColumnInlineView on menu
2016-08-22 13:20:41,768:INFO:flask_appbuilder.base:Registering class DruidColumnInlineView on menu
2016-08-22 13:20:41,847:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-22 13:20:41,847:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-22 13:20:41,848:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-22 13:20:41,848:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-22 13:20:41,848:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-22 13:20:41,849:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-22 13:20:41,853:INFO:flask_appbuilder.base:Registering class SqlMetricInlineView on menu
2016-08-22 13:20:41,957:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-22 13:20:41,957:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-22 13:20:41,957:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-22 13:20:41,958:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-22 13:20:41,958:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-22 13:20:41,958:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-22 13:20:41,964:INFO:flask_appbuilder.base:Registering class DruidMetricInlineView on menu
2016-08-22 13:20:42,013:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-22 13:20:42,013:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-22 13:20:42,014:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-22 13:20:42,014:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-22 13:20:42,014:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-22 13:20:42,015:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-22 13:20:42,017:WARNING:flask_appbuilder.models.filters:Filter type not supported for column: password
2016-08-22 13:20:42,019:INFO:flask_appbuilder.base:Registering class DatabaseView on menu Databases
2016-08-22 13:20:42,099:INFO:flask_appbuilder.base:Registering class TableModelView on menu Tables
2016-08-22 13:20:42,204:INFO:flask_appbuilder.base:Registering class DruidClusterModelView on menu Druid Clusters
2016-08-22 13:20:42,272:INFO:flask_appbuilder.base:Registering class SliceModelView on menu Slices
2016-08-22 13:20:42,362:INFO:flask_appbuilder.base:Registering class SliceAsync on menu
2016-08-22 13:20:42,413:INFO:flask_appbuilder.base:Registering class DashboardModelView on menu Dashboards
2016-08-22 13:20:42,510:INFO:flask_appbuilder.base:Registering class DashboardModelViewAsync on menu
2016-08-22 13:20:42,562:INFO:flask_appbuilder.base:Registering class LogModelView on menu Action Log
2016-08-22 13:20:42,654:INFO:flask_appbuilder.base:Registering class DruidDatasourceModelView on menu Druid Datasources
2016-08-22 13:20:42,743:INFO:flask_appbuilder.base:Registering class R on menu
2016-08-22 13:20:42,748:INFO:flask_appbuilder.base:Registering class Caravel on menu
2016-08-22 13:20:42,845:INFO:flask_appbuilder.base:Registering class CssTemplateModelView on menu CSS Templates
[2016-08-22 13:20:42 +0000] [6874] [DEBUG] Exception while loading the application
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/gunicorn/arbiter.py", line 557, in spawn_worker
    worker.init_process()
  File "/usr/local/lib/python2.7/dist-packages/gunicorn/workers/base.py", line 126, in init_process
    self.load_wsgi()
  File "/usr/local/lib/python2.7/dist-packages/gunicorn/workers/base.py", line 136, in load_wsgi
    self.wsgi = self.app.wsgi()
  File "/usr/local/lib/python2.7/dist-packages/gunicorn/app/base.py", line 67, in wsgi
    self.callable = self.load()
  File "/usr/local/lib/python2.7/dist-packages/gunicorn/app/wsgiapp.py", line 65, in load
    return self.load_wsgiapp()
  File "/usr/local/lib/python2.7/dist-packages/gunicorn/app/wsgiapp.py", line 52, in load_wsgiapp
    return util.import_app(self.app_uri)
  File "/usr/local/lib/python2.7/dist-packages/gunicorn/util.py", line 370, in import_app
    raise AppImportError("Failed to find application: %r" % module)
AppImportError: Failed to find application: 'caravel'
Failed to find application: 'caravel'
[2016-08-22 13:20:42 +0000] [6874] [INFO] Worker exiting (pid: 6874)
[2016-08-22 13:20:43 +0000] [6869] [INFO] Shutting down: Master
[2016-08-22 13:20:43 +0000] [6869] [INFO] Reason: App failed to load.
caravel@ip-10-73-xxx-xxx:~$

Apologies if the $ gunicorn -w1 --log-level=DEBUG caravel command was incorrect; I've not used gunicorn before

[xrmx]

@dugjason gunicorn -w1 --log-level=DEBUG caravel:app

[dugjason]

Thanks!

Running that seems to successfully start the app, but it does not seem to be accessible from the browser (I've double checked the correct ports are open, etc).
Trying to access the app, I see no updates in these logs. This log was pulled after running the service for ~1hr

caravel@ip-10-73-xxx-xxx:~$ gunicorn -w1 --log-level=DEBUG caravel:app
[2016-08-23 09:26:58 +0000] [2752] [DEBUG] Current configuration:
  secure_scheme_headers: {'X-FORWARDED-PROTOCOL': 'ssl', 'X-FORWARDED-PROTO': 'https', 'X-FORWARDED-SSL': 'on'}
  proxy_protocol: False
  worker_connections: 1000
  statsd_host: None
  max_requests_jitter: 0
  post_fork: <function post_fork at 0x7f6d00520758>
  pythonpath: None
  enable_stdio_inheritance: False
  worker_class: sync
  ssl_version: 3
  suppress_ragged_eofs: True
  syslog: False
  syslog_facility: user
  when_ready: <function when_ready at 0x7f6d00520488>
  pre_fork: <function pre_fork at 0x7f6d005205f0>
  cert_reqs: 0
  preload_app: False
  keepalive: 2
  accesslog: None
  group: 1011
  graceful_timeout: 30
  do_handshake_on_connect: False
  spew: False
  workers: 1
  proc_name: None
  sendfile: None
  pidfile: None
  umask: 0
  on_reload: <function on_reload at 0x7f6d00520320>
  pre_exec: <function pre_exec at 0x7f6d00520cf8>
  worker_tmp_dir: None
  post_worker_init: <function post_worker_init at 0x7f6d005208c0>
  limit_request_fields: 100
  on_exit: <function on_exit at 0x7f6d00527410>
  config: None
  logconfig: None
  check_config: False
  statsd_prefix:
  proxy_allow_ips: ['127.0.0.1']
  pre_request: <function pre_request at 0x7f6d00520e60>
  post_request: <function post_request at 0x7f6d00520f50>
  user: 1012
  forwarded_allow_ips: ['127.0.0.1']
  worker_int: <function worker_int at 0x7f6d00520a28>
  threads: 1
  max_requests: 0
  limit_request_line: 4094
  access_log_format: %(h)s %(l)s %(u)s %(t)s "%(r)s" %(s)s %(b)s "%(f)s" "%(a)s"
  certfile: None
  worker_exit: <function worker_exit at 0x7f6d00527140>
  chdir: /home/caravel
  paste: None
  default_proc_name: caravel:app
  errorlog: -
  loglevel: DEBUG
  capture_output: False
  syslog_addr: udp://localhost:514
  syslog_prefix: None
  daemon: False
  ciphers: TLSv1
  on_starting: <function on_starting at 0x7f6d005201b8>
  worker_abort: <function worker_abort at 0x7f6d00520b90>
  bind: ['127.0.0.1:8000']
  raw_env: []
  reload: False
  limit_request_field_size: 8190
  nworkers_changed: <function nworkers_changed at 0x7f6d005272a8>
  timeout: 30
  ca_certs: None
  django_settings: None
  tmp_upload_dir: None
  keyfile: None
  backlog: 2048
  logger_class: gunicorn.glogging.Logger
[2016-08-23 09:26:58 +0000] [2752] [INFO] Starting gunicorn 19.6.0
[2016-08-23 09:26:58 +0000] [2752] [DEBUG] Arbiter booted
[2016-08-23 09:26:58 +0000] [2752] [INFO] Listening at: http://127.0.0.1:8000 (2752)
[2016-08-23 09:26:58 +0000] [2752] [INFO] Using worker: sync
[2016-08-23 09:26:58 +0000] [2757] [INFO] Booting worker with pid: 2757
[2016-08-23 09:26:58 +0000] [2752] [DEBUG] 1 workers
/usr/local/lib/python2.7/dist-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy is deprecated, use flask_sqlalchemy instead.
  .format(x=modname), ExtDeprecationWarning
/usr/local/lib/python2.7/dist-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.sqlalchemy._compat is deprecated, use flask_sqlalchemy._compat instead.
  .format(x=modname), ExtDeprecationWarning
/usr/local/lib/python2.7/dist-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.script is deprecated, use flask_script instead.
  .format(x=modname), ExtDeprecationWarning
/usr/local/lib/python2.7/dist-packages/flask_cache/__init__.py:152: UserWarning: Flask-Cache: CACHE_TYPE is set to null, caching is effectively disabled.
  warnings.warn("Flask-Cache: CACHE_TYPE is set to null, "
/usr/local/lib/python2.7/dist-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.cache is deprecated, use flask_cache instead.
  .format(x=modname), ExtDeprecationWarning
2016-08-23 09:26:59,861:INFO:flask_appbuilder.base:Registering class MyIndexView on menu
2016-08-23 09:26:59,940:INFO:flask_appbuilder.base:Registering class UtilView on menu
2016-08-23 09:26:59,944:INFO:flask_appbuilder.base:Registering class LocaleView on menu
2016-08-23 09:26:59,948:INFO:flask_appbuilder.base:Registering class ResetPasswordView on menu
2016-08-23 09:27:00,038:INFO:flask_appbuilder.base:Registering class ResetMyPasswordView on menu
2016-08-23 09:27:00,052:INFO:flask_appbuilder.base:Registering class UserInfoEditView on menu
2016-08-23 09:27:00,138:INFO:flask_appbuilder.base:Registering class AuthDBView on menu
2016-08-23 09:27:00,148:INFO:flask_appbuilder.base:Registering class UserDBModelView on menu List Users
2016-08-23 09:27:00,387:INFO:flask_appbuilder.base:Registering class RoleModelView on menu List Roles
2016-08-23 09:27:00,574:INFO:flask_appbuilder.base:Registering class UserStatsChartView on menu User's Statistics
2016-08-23 09:27:00,676:INFO:flask_appbuilder.base:Registering class PermissionModelView on menu Base Permissions
2016-08-23 09:27:00,856:INFO:flask_appbuilder.base:Registering class ViewMenuModelView on menu Views/Menus
2016-08-23 09:27:01,010:INFO:flask_appbuilder.base:Registering class PermissionViewModelView on menu Permission on Views/Menus
2016-08-23 09:27:06,101:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-23 09:27:06,101:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-23 09:27:06,105:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-23 09:27:06,108:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-23 09:27:06,108:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-23 09:27:06,108:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-23 09:27:06,110:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-23 09:27:06,116:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-23 09:27:06,116:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-23 09:27:06,116:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-23 09:27:06,116:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-23 09:27:06,117:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-23 09:27:06,119:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-23 09:27:06,120:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-23 09:27:06,120:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-23 09:27:06,120:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-23 09:27:06,148:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-23 09:27:06,148:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-23 09:27:06,156:INFO:flask_appbuilder.base:Registering class TableColumnInlineView on menu
2016-08-23 09:27:06,259:INFO:flask_appbuilder.base:Registering class DruidColumnInlineView on menu
2016-08-23 09:27:06,357:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-23 09:27:06,357:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-23 09:27:06,358:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-23 09:27:06,358:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-23 09:27:06,358:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-23 09:27:06,359:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-23 09:27:06,363:INFO:flask_appbuilder.base:Registering class SqlMetricInlineView on menu
2016-08-23 09:27:06,544:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-23 09:27:06,544:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-23 09:27:06,545:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-23 09:27:06,545:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-23 09:27:06,545:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-23 09:27:06,546:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-23 09:27:06,551:INFO:flask_appbuilder.base:Registering class DruidMetricInlineView on menu
2016-08-23 09:27:06,720:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.tables".
2016-08-23 09:27:06,721:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.tables.TableExtension".
2016-08-23 09:27:06,721:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.fenced_code".
2016-08-23 09:27:06,722:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.fenced_code.FencedCodeExtension".
2016-08-23 09:27:06,722:DEBUG:MARKDOWN:Successfuly imported extension module "markdown.extensions.codehilite".
2016-08-23 09:27:06,724:DEBUG:MARKDOWN:Successfully loaded extension "markdown.extensions.codehilite.CodeHiliteExtension".
2016-08-23 09:27:06,750:WARNING:flask_appbuilder.models.filters:Filter type not supported for column: password
2016-08-23 09:27:06,757:INFO:flask_appbuilder.base:Registering class DatabaseView on menu Databases
2016-08-23 09:27:06,999:INFO:flask_appbuilder.base:Registering class TableModelView on menu Tables
2016-08-23 09:27:07,212:INFO:flask_appbuilder.base:Registering class DruidClusterModelView on menu Druid Clusters
2016-08-23 09:27:07,296:INFO:flask_appbuilder.base:Registering class SliceModelView on menu Slices
2016-08-23 09:27:07,520:INFO:flask_appbuilder.base:Registering class SliceAsync on menu
2016-08-23 09:27:07,620:INFO:flask_appbuilder.base:Registering class DashboardModelView on menu Dashboards
2016-08-23 09:27:07,726:INFO:flask_appbuilder.base:Registering class DashboardModelViewAsync on menu
2016-08-23 09:27:07,828:INFO:flask_appbuilder.base:Registering class LogModelView on menu Action Log
2016-08-23 09:27:08,014:INFO:flask_appbuilder.base:Registering class DruidDatasourceModelView on menu Druid Datasources
2016-08-23 09:27:08,198:INFO:flask_appbuilder.base:Registering class R on menu
2016-08-23 09:27:08,204:INFO:flask_appbuilder.base:Registering class Caravel on menu
2016-08-23 09:27:08,398:INFO:flask_appbuilder.base:Registering class CssTemplateModelView on menu CSS Templates

[xrmx]

@dugjason you are binding to 127.0.0.1 so unless you are on your machine or have a tunnel you need a proxy or need to bind to another interface. Anyway try to replicate your issue with the debug flag so we can see if there's something wrong in caravel.

[dugjason]

Thanks @xrmx, @mistercrunch ; that seems to have done it. Running gunicorn -w4 -b :8088 caravel:app works, and allows me to access Caravel from the Internet.

I'm happy to continue helping debug what was causing the problem with running Caravel using the caravel runserver -p 8088 command if someone can give me some guidance

[chethankt]

I am getting below error. can any one help

: UserWarning: Flask-Cache: CACHE_TYPE is set to null, caching is effectively disabled.
warnings.warn("Flask-Cache: CACHE_TYPE is set to null, "
/root/anaconda2/lib/python2.7/site-packages/flask/exthook.py:71: ExtDeprecationWarning: Importing flask.ext.cache is deprecated, use flask_cache instead.
.format(x=modname), ExtDeprecationWarning
100:ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (sqlite3.OperationalError) unable to open database file

[xrmx]

@chethankt completely unrelated, please don't hijack issues. Looks like a permission issue.