search

zatosource / zato

ESB, SOA, REST, APIs and Cloud Integrations in Python
https://zato.io
GNU Affero General Public License v3.0
1.12k stars 240 forks source link

(DataError) invalid input syntax for integer: "None" #137

Closed mentis-pl closed 10 years ago

mentis-pl commented 10 years ago

DataError at /zato/scheduler/

(DataError) invalid input syntax for integer: "None" LINE 3: WHERE cluster.id = 'None' ^ 'SELECT cluster.id AS cluster_id, cluster.name AS cluster_name, cluster.description AS cluster_description, cluster.odb_type AS cluster_odb_type, cluster.odb_host AS cluster_odb_host, cluster.odb_port AS cluster_odb_port, cluster.odb_user AS cluster_odb_user, cluster.odb_db_name AS cluster_odb_db_name, cluster.odb_schema AS cluster_odb_schema, cluster.broker_host AS cluster_broker_host, cluster.broker_port AS cluster_broker_port, cluster.lb_host AS cluster_lb_host, cluster.lb_port AS cluster_lb_port, cluster.lb_agent_port AS cluster_lb_agent_port, cluster.cw_srv_id AS cluster_cw_srv_id, cluster.cw_srv_keep_alive_dt AS cluster_cw_srv_keep_alive_dt \nFROM cluster \nWHERE cluster.id = %(id_1)s' {'id_1': u'None'}

Request Method: GET Request URL: http://localhost:8183/zato/scheduler/?cluster=None Django Version: 1.3.1 Exception Type: DataError Exception Value:

(DataError) invalid input syntax for integer: "None" LINE 3: WHERE cluster.id = 'None' ^ 'SELECT cluster.id AS cluster_id, cluster.name AS cluster_name, cluster.description AS cluster_description, cluster.odb_type AS cluster_odb_type, cluster.odb_host AS cluster_odb_host, cluster.odb_port AS cluster_odb_port, cluster.odb_user AS cluster_odb_user, cluster.odb_db_name AS cluster_odb_db_name, cluster.odb_schema AS cluster_odb_schema, cluster.broker_host AS cluster_broker_host, cluster.broker_port AS cluster_broker_port, cluster.lb_host AS cluster_lb_host, cluster.lb_port AS cluster_lb_port, cluster.lb_agent_port AS cluster_lb_agent_port, cluster.cw_srv_id AS cluster_cw_srv_id, cluster.cw_srv_keep_alive_dt AS cluster_cw_srv_keep_alive_dt \nFROM cluster \nWHERE cluster.id = %(id_1)s' {'id_1': u'None'}

Exception Location: /home/krystianm/stuff/python/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py in do_execute, line 331 Python Executable: /home/krystianm/stuff/python/zato-1.1/bin/python Python Version: 2.7.5 Python Path:

['/home/krystianm/stuff/python/zato-1.1/eggs/amqp-1.0.11-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/anyjson-0.3.3-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/APScheduler-2.0.3-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/argh-0.23.2-py2.7.egg', '/usr/lib/python2.7', '/home/krystianm/stuff/python/zato-1.1/eggs/boto-2.6.0-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/bunch-1.0.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/bzr-2.5.0-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/circuits-1.5-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/codegen-1.0-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/collective.recipe.patch-0.2.2-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/configobj-4.7.2-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/coverage-3.5.3-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/distribute-0.6.30-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/Distutils2-1.0a4-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/Django-1.3.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/django_debug_toolbar_django13-0.8.4-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/django_settings-1.3_beta-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/fs-0.4.0-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/gevent-0.13.8-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/gevent_inotifyx-0.1.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/greenlet-0.4.0-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/gunicorn-0.16.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/hexagonit.recipe.download-1.6-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/hiredis-0.1.1-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/Importing-1.10-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/setuptools-0.6c12dev_r89000-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/inotifyx-0.2.0-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/iw.recipe.cmd-0.3-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/jsonlib2-1.5.2-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/kombu-2.5.10-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/lxml-3.0.1-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/mock-0.8.0-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/nose-1.2.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/nosexcover-1.0.7-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/ordereddict-1.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/paodate-1.2-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/parse-1.4.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/Paste-1.7.5.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/pathtools-0.1.2-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/pesto-25-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/pika-0.9.12-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/pip-1.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/psutil-0.6.1-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/psycopg2-2.4.5-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/Pygments-1.5-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/pyparsing-1.5.6-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/python_dateutil-2.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/pytz-2012h-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/pyzmq-2.2.0.1-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/pyzmq_static-2.2-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/quicli-1.1.0-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/redis-2.4.13-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/repoze.lru-0.6-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/requests-0.14.2-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/retools-0.3-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/sec_wall-1.2-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/setproctitle-1.1.6-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/six-1.2.0-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/springpython-1.3.0.RC1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/texttable-0.8.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/threadpool-1.2.7-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/tornado-2.4-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/urllib3-1.5-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/watchdog-0.6.0-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/zato-agent/src', '/home/krystianm/stuff/python/zato-1.1/zato-broker/src', '/home/krystianm/stuff/python/zato-1.1/zato-cli/src', '/home/krystianm/stuff/python/zato-1.1/zato-client/src', '/home/krystianm/stuff/python/zato-1.1/zato-common/src', '/home/krystianm/stuff/python/zato-1.1/zato-server/src', '/home/krystianm/stuff/python/zato-1.1/zato-web-admin/src', '/home/krystianm/stuff/python/zato-1.1/eggs/zc.buildout-1.6.3-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/zc.recipe.egg-1.3.2-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/ZConfig-2.9.3-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/zdaemon-2.0.4-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/eggs/zerokspot.recipe.git-0.6.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/lib/python2.7/site-packages', '/home/krystianm/stuff/python/zato-1.1/zato_extra_paths', '/home/krystianm/stuff/python/zato-1.1/bin', '/home/krystianm/stuff/python/zato-1.1/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/local/lib/python2.7/site-packages/pip-1.3.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/lib/python2.7/site-packages/pip-1.3.1-py2.7.egg', '/home/krystianm/stuff/python/zato-1.1/lib/python2.7', '/home/krystianm/stuff/python/zato-1.1/lib/python2.7/plat-x86_64-linux-gnu', '/home/krystianm/stuff/python/zato-1.1/lib/python2.7/lib-tk', '/home/krystianm/stuff/python/zato-1.1/lib/python2.7/lib-old', '/home/krystianm/stuff/python/zato-1.1/lib/python2.7/lib-dynload', '/usr/lib/python2.7/plat-x86_64-linux-gnu', '/usr/lib/python2.7/lib-tk']

Server time: Wed, 8 Jan 2014 13:39:35 -0500 Traceback Switch to copy-and-paste view

/home/krystianm/stuff/python/zato-1.1/eggs/Django-1.3.1-py2.7.egg/django/core/handlers/base.py in get_response

                        response = middleware_method(request)

    ...
▶ Local vars
/home/krystianm/stuff/python/zato-1.1/zato-web-admin/src/zato/admin/middleware.py in process_request

                req.zato.cluster = req.zato.odb.query(Cluster).filter_by(id=req.zato.cluster_id).one()

    ...
▶ Local vars
/home/krystianm/stuff/python/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py in one

            ret = list(self)

    ...
▶ Local vars
/home/krystianm/stuff/python/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py in __iter__

            return self._execute_and_instances(context)

    ...
▶ Local vars
/home/krystianm/stuff/python/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py in _execute_and_instances

            result = conn.execute(querycontext.statement, self._params)

    ...
▶ Local vars
/home/krystianm/stuff/python/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py in execute

                                                    params)

    ...
▶ Local vars
/home/krystianm/stuff/python/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py in _execute_clauseelement

                compiled_sql, distilled_params

    ...
▶ Local vars
/home/krystianm/stuff/python/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py in _execute_context

                                    context)

    ...
▶ Local vars
/home/krystianm/stuff/python/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py in _execute_context

                                        context)

    ...
▶ Local vars
/home/krystianm/stuff/python/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py in do_execute

            cursor.execute(statement, parameters)

    ...
▶ Local vars

Request information GET Variable Value cluster

u'None'

POST

No POST data FILES

No FILES data COOKIES Variable Value csrftoken

'29736c2fd1f8a70ad415c3e057821191'

sessionid

'9629a5a0a711fe93c26d84707ea16512'

META Variable Value HTTP_REFERER

'http://localhost:8183/zato/stats/settings/?cluster='

wsgi.multithread

True

SERVER_SOFTWARE

'WSGIServer/0.1 Python/2.7.5+'

UPSTART_EVENTS

'started xsession'

SCRIPT_NAME

u''

REQUEST_METHOD

'GET'

DAEMON_MANAGER_MODE

'1'

SERVER_PROTOCOL

'HTTP/1.1'

LC_PAPER

'pl_PL.UTF-8'

HOME

'/home/krystianm'

DISPLAY

':0'

KDE_FULL_SESSION

'true'

LANG

'en_US.UTF-8'

PROFILEHOME

''

SHELL

'/bin/bash'

COLORFGBG

'15;0'

LC_MONETARY

'pl_PL.UTF-8'

XDG_SESSION_ID

'c2'

MANDATORY_PATH

'/usr/share/gconf/kde-plasma.mandatory.path'

DBUS_SESSION_BUS_ADDRESS

'unix:abstract=/tmp/dbus-LTQwPkGsSr'

UPSTART_INSTANCE

''

JOB

'dbus'

SESSION

'kde-plasma'

ZATO_CLI_DONT_SHOW_OUTPUT

'1'

PATH_INFO

u'/zato/scheduler/'

XDG_RUNTIME_DIR

'/run/user/1000'

LC_ADDRESS

'pl_PL.UTF-8'

CONTENT_TYPE

'text/plain'

KONSOLE_DBUS_SERVICE

':1.72'

HTTP_CONNECTION

'keep-alive'

HTTP_HOST

'localhost:8183'

GNOME_KEYRING_PID

'1839'

wsgi.version

(1, 0)

XDG_CURRENT_DESKTOP

'KDE'

GS_LIB

'/home/krystianm/.fonts'

SHELL_SESSION_ID

'91a827d5eb464000a4cb6e4fbb24c6f4'

LC_MESSAGES

'POSIX'

HTTP_ACCEPT

'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8'

DESKTOP_SESSION

'kde-plasma'

LESSCLOSE

'/usr/bin/lesspipe %s %s'

DEFAULTS_PATH

'/usr/share/gconf/kde-plasma.default.path'

wsgi.run_once

False

wsgi.errors

<open file '', mode 'w' at 0x7faf0d5d11e0>

wsgi.multiprocess

False

HTTP_ACCEPT_LANGUAGE

'en-gb,en;q=0.5'

INSTANCE

''

LC_NAME

'pl_PL.UTF-8'

LS_COLORS

'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.lzma=01;31:.tlz=01;31:.txz=01;31:.zip=01;31:.z=01;31:.Z=01;31:.dz=01;31:.gz=01;31:.lz=01;31:.xz=01;31:.bz2=01;31:.bz=01;31:.tbz=01;31:.tbz2=01;31:.tz=01;31:.deb=01;31:.rpm=01;31:.jar=01;31:.war=01;31:.ear=01;31:.sar=01;31:.rar=01;31:.ace=01;31:.zoo=01;31:.cpio=01;31:.7z=01;31:.rz=01;31:.jpg=01;35:.jpeg=01;35:.gif=01;35:.bmp=01;35:.pbm=01;35:.pgm=01;35:.ppm=01;35:.tga=01;35:.xbm=01;35:.xpm=01;35:.tif=01;35:.tiff=01;35:.png=01;35:.svg=01;35:.svgz=01;35:.mng=01;35:.pcx=01;35:.mov=01;35:.mpg=01;35:.mpeg=01;35:.m2v=01;35:.mkv=01;35:.webm=01;35:.ogm=01;35:.mp4=01;35:.m4v=01;35:.mp4v=01;35:.vob=01;35:.qt=01;35:.nuv=01;35:.wmv=01;35:.asf=01;35:.rm=01;35:.rmvb=01;35:.flc=01;35:.avi=01;35:.fli=01;35:.flv=01;35:.gl=01;35:.dl=01;35:.xcf=01;35:.xwd=01;35:.yuv=01;35:.cgm=01;35:.emf=01;35:.axv=01;35:.anx=01;35:.ogv=01;35:.ogx=01;35:.aac=00;36:.au=00;36:.flac=00;36:.mid=00;36:.midi=00;36:.mka=00;36:.mp3=00;36:.mpc=00;36:.ogg=00;36:.ra=00;36:.wav=00;36:.axa=00;36:.oga=00;36:.spx=00;36:.xspf=00;36:'

XDG_SEAT

'seat0'

LC_NUMERIC

'pl_PL.UTF-8'

HTTP_COOKIE

'csrftoken=29736c2fd1f8a70ad415c3e057821191; sessionid=9629a5a0a711fe93c26d84707ea16512'

LESSOPEN

'| /usr/bin/lesspipe %s'

QUERY_STRING

'cluster=None'

LOGNAME

'krystianm'

USER

'krystianm'

GNOME_KEYRING_CONTROL

'/run/user/1000/keyring-TJI5wh'

XDG_VTNR

'7'

PATH

'/home/krystianm/bin:/usr/lib/lightdm/lightdm:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/home/krystianm/stuff/python/zato-1.1/bin/'

wsgi.url_scheme

'http'

KDE_SESSION_VERSION

'4'

SSH_AGENT_PID

'1900'

TERM

'xterm'

HTTP_USER_AGENT

'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:26.0) Gecko/20100101 Firefox/26.0'

XDG_SESSION_PATH

'/org/freedesktop/DisplayManager/Session0'

XAUTHORITY

'/tmp/kde-krystianm/xauth-1000-_0'

LANGUAGE

'en_US:en'

SESSION_MANAGER

'local/paradoks:@/tmp/.ICE-unix/2027,unix/paradoks:/tmp/.ICE-unix/2027'

LC_MEASUREMENT

'pl_PL.UTF-8'

KONSOLE_PROFILE_NAME

'Shell'

XCURSOR_THEME

'oxy-white'

KONSOLE_DBUS_WINDOW

'/Windows/1'

WINDOWID

'62914586'

SERVER_PORT

'8183'

SESSIONTYPE

''

IM_CONFIG_PHASE

'1'

GPG_AGENT_INFO

'/tmp/gpg-mNrhmP/S.gpg-agent:1901:1'

KONSOLE_DBUS_SESSION

'/Sessions/1'

CONTENT_LENGTH

''

SSH_AUTH_SOCK

'/tmp/ssh-Wo7DDvnAsvGY/agent.1896'

QT_PLUGIN_PATH

'/home/krystianm/.kde/lib/kde4/plugins/:/usr/lib/kde4/plugins/'

KDE_SESSION_UID

'1000'

GDMSESSION

'kde-plasma'

UPSTART_JOB

'startkde'

TEXTDOMAINDIR

'/usr/share/locale/'

GTK2_RC_FILES

'/etc/gtk-2.0/gtkrc:/home/krystianm/.gtkrc-2.0:/home/krystianm/.kde/share/config/gtkrc-2.0'

XDG_DATA_DIRS

'/usr/share:/usr/share/kde-plasma:/usr/local/share/:/usr/share/'

XDG_SEAT_PATH

'/org/freedesktop/DisplayManager/Seat0'

LC_ALL

'en_GB.utf8'

_

'/home/krystianm/stuff/python/zato-1.1/bin/zato'

wsgi.input

<socket._fileobject object at 0x5300450>

LC_IDENTIFICATION

'pl_PL.UTF-8'

UPSTART_SESSION

'unix:abstract=/com/ubuntu/upstart-session/1000/1841'

XDG_CONFIG_DIRS

'/etc/xdg/xdg-kde-plasma:/usr/share/upstart/xdg:/etc/xdg'

SERVER_NAME

'paradoks.nask.waw.pl'

GATEWAY_INTERFACE

'CGI/1.1'

OLDPWD

'/home/krystianm/stuff/python/zato_text/server2'

REMOTE_ADDR

'127.0.0.1'

GDM_LANG

'en_US'

LC_TELEPHONE

'pl_PL.UTF-8'

NODE_PATH

'/usr/lib/nodejs:/usr/lib/node_modules:/usr/share/javascript'

SHLVL

'2'

PWD

'/home/krystianm/stuff/python/zato_text/web-admin'

GTK_RC_FILES

'/etc/gtk/gtkrc:/home/krystianm/.gtkrc:/home/krystianm/.kde/share/config/gtkrc'

TEXTDOMAIN

'im-config'

LC_TIME

'pl_PL.UTF-8'

wsgi.file_wrapper

''

REMOTE_HOST

'localhost'

HTTP_ACCEPT_ENCODING

'gzip, deflate'

KDE_MULTIHEAD

'false'

Settings Using settings module zato.admin.settings Setting Value USE_L10N

False

USE_THOUSAND_SEPARATOR

False

LANGUAGE_CODE

u'en-us'

ROOT_URLCONF

'zato.admin.urls'

MANAGERS

()

SSL_KEY_FILE

u'./config/repo/web-admin-priv-key.pem'

DEFAULT_CHARSET

'utf-8'

STATIC_ROOT

''

TEST_DATABASE_CHARSET

None

TRACE1

6

MESSAGE_STORAGE

'django.contrib.messages.storage.session.SessionStorage'

DATABASE_HOST

'localhost'

EMAIL_SUBJECT_PREFIX

'[Django] '

SEND_BROKEN_LINK_EMAILS

False

URL_VALIDATOR_USER_AGENT

'Django/1.3.1 (http://www.djangoproject.com)'

STATICFILES_FINDERS

('django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder')

SESSION_COOKIE_DOMAIN

None

SESSION_COOKIE_NAME

'sessionid'

ADMIN_FOR

()

TIME_INPUT_FORMATS

('%H:%M:%S', '%H:%M')

DATABASES

{u'default': {'ENGINE': u'django.db.backends.postgresql_psycopg2', u'HOST': 'localhost', u'NAME': 'zato1', 'OPTIONS': {}, u'PASSWORD': '****', u'PORT': '5432', 'TEST_CHARSET': None, 'TEST_COLLATION': None, 'TEST_MIRROR': None, 'TEST_NAME': None, 'TIME_ZONE': u'America/New_York', u'USER': 'postgres'}}

TEMPLATE_DEBUG

True

FILE_UPLOAD_PERMISSIONS

None

FILE_UPLOAD_HANDLERS

('django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler')

DEFAULT_CONTENT_TYPE

'text/html'

APPEND_SLASH

True

FIRST_DAY_OF_WEEK

0

DATABASE_ROUTERS

[]

YEAR_MONTH_FORMAT

'F Y'

STATICFILES_STORAGE

'django.contrib.staticfiles.storage.StaticFilesStorage'

CACHES

{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache', 'LOCATION': ''}}

SERVER_EMAIL

'root@localhost'

SESSION_COOKIE_PATH

'/'

USE_X_FORWARDED_HOST

False

IGNORABLE_404_ENDS

('mail.pl', 'mailform.pl', 'mail.cgi', 'mailform.cgi', 'favicon.ico', '.php')

MIDDLEWARE_CLASSES

('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.middleware.csrf.CsrfResponseMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'zato.admin.middleware.ZatoMiddleware')

USE_I18N

True

THOUSAND_SEPARATOR

','

SECRET_KEY

'****'

LANGUAGE_COOKIE_NAME

'django_language'

FILE_UPLOAD_TEMP_DIR

None

TRANSACTIONS_MANAGED

False

LOGGING_CONFIG

'django.utils.log.dictConfig'

TEMPLATE_LOADERS

('django.template.loaders.filesystem.load_template_source', 'django.template.loaders.app_directories.load_template_source')

ADMIN_INVOKE_PATH

u'/zato/admin/invoke'

DONT_REQUIRE_LOGIN

['/static/', '/favicon.ico']

CSRF_COOKIE_NAME

'csrftoken'

TEST_DATABASE_COLLATION

None

FORCE_SCRIPT_NAME

None

CACHE_BACKEND

'locmem://'

SESSION_COOKIE_SECURE

False

CSRF_COOKIE_DOMAIN

None

FILE_CHARSET

'utf-8'

DEBUG

1

SESSION_FILE_PATH

None

DEFAULT_FILE_STORAGE

'django.core.files.storage.FileSystemStorage'

INSTALLED_APPS

['django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.messages', 'django.contrib.humanize', 'debug_toolbar', 'django_settings', 'zato.admin.web']

LANGUAGES

(('ar', 'Arabic'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('bn', 'Bengali'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('el', 'Greek'), ('en', 'English'), ('en-gb', 'British English'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy-nl', 'Frisian'), ('ga', 'Irish'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hu', 'Hungarian'), ('id', 'Indonesian'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('nl', 'Dutch'), ('no', 'Norwegian'), ('nb', 'Norwegian Bokmal'), ('nn', 'Norwegian Nynorsk'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional Chinese'))

DATABASE_ENGINE

u'django.db.backends.postgresql_psycopg2'

DATABASE_NAME

'zato1'

COMMENTS_FIRST_FEW

0

PREPEND_WWW

False

SESSION_COOKIE_HTTPONLY

False

DATABASE_PORT

'5432'

DEBUG_PROPAGATE_EXCEPTIONS

False

MONTH_DAY_FORMAT

'F j'

LOGIN_URL

'/accounts/login/'

SESSION_EXPIRE_AT_BROWSER_CLOSE

False

SSL_CA_CERTS

u'./config/repo/web-admin-ca-certs.pem'

TIME_FORMAT

'P'

LB_AGENT_CONNECT_TIMEOUT

500

DATE_INPUT_FORMATS

('%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y')

AUTHENTICATION_BACKENDS

('django.contrib.auth.backends.ModelBackend',)

EMAIL_HOST_PASSWORD

'****'

PASSWORD_RESET_TIMEOUT_DAYS

'****'

CACHE_MIDDLEWARE_ALIAS

'default'

SESSION_SAVE_EVERY_REQUEST

False

ADMIN_MEDIA_PREFIX

'/media/'

NUMBER_GROUPING

0

ADMIN_INVOKE_NAME

u'admin.invoke'

SCHEDULER_JOB_TYPE

<zato.common.SCHEDULER_JOB_TYPE instance at 0x53967a0>

CSRF_FAILURE_VIEW

'django.views.csrf.csrf_failure'

COMMENTS_SKETCHY_USERS_GROUP

None

LOGIN_REDIRECT_URL

'/accounts/profile/'

LOGGING

{'disable_existing_loggers': False, 'handlers': {'mail_admins': {'class': 'django.utils.log.AdminEmailHandler', 'level': 'ERROR'}}, 'loggers': {'django.request': {'handlers': ['mail_admins'], 'level': 'ERROR', 'propagate': True}}, 'version': 1}

CACHE_MIDDLEWARE_KEY_PREFIX

''

LOCALE_PATHS

()

SSL_CERT_FILE

u'./config/repo/web-admin-cert.pem'

COMMENTS_ALLOW_PROFANITIES

False

LOGOUT_URL

'/accounts/logout/'

EMAIL_USE_TLS

False

TEMPLATE_DIRS

('/home/krystianm/stuff/python/zato-1.1/zato-web-admin/src/zato/admin/templates',)

FIXTURE_DIRS

()

EMAIL_HOST

'localhost'

DATE_FORMAT

'N j, Y'

MEDIA_ROOT

'/home/krystianm/stuff/python/zato-1.1/zato-web-admin/src/zato/admin/static'

ADMINS

()

FORMAT_MODULE_PATH

None

DEFAULT_FROM_EMAIL

'webmaster@localhost'

STATICFILES_DIRS

()

MEDIA_URL

'/static/'

DATETIME_FORMAT

'N j, Y, P'

IGNORABLE_404_STARTS

('/cgi-bin/', '/_vti_bin', '/_vti_inf')

SITE_ID

580674

DISALLOWED_USER_AGENTS

()

ALLOWED_INCLUDE_ROOTS

()

DECIMAL_SEPARATOR

'.'

SHORT_DATE_FORMAT

'm/d/Y'

DATABASE_USER

'postgres'

TEST_DATABASE_NAME

None

TEST_RUNNER

'django.test.simple.DjangoTestSuiteRunner'

TIME_ZONE

u'America/New_York'

FILE_UPLOAD_MAX_MEMORY_SIZE

2621440

EMAIL_BACKEND

'django.core.mail.backends.smtp.EmailBackend'

DEFAULT_TABLESPACE

''

TEMPLATE_CONTEXT_PROCESSORS

('django.contrib.auth.context_processors.auth', 'django.core.context_processors.debug', 'django.core.context_processors.i18n', 'django.core.context_processors.media', 'django.core.context_processors.static', 'django.contrib.messages.context_processors.messages')

SESSION_COOKIE_AGE

1209600

SETTINGS_MODULE

u'zato.admin.settings'

USE_ETAGS

False

ADMIN_INVOKE_PASSWORD

'****'

LANGUAGES_BIDI

('he', 'ar', 'fa')

DEFAULT_INDEX_TABLESPACE

''

INTERNAL_IPS

('127.0.0.1',)

STATIC_URL

None

EMAIL_PORT

25

SESSION_ENGINE

'django.contrib.sessions.backends.db'

SHORT_DATETIME_FORMAT

'm/d/Y P'

ABSOLUTE_URL_OVERRIDES

{}

DATABASE_OPTIONS

{}

CACHE_MIDDLEWARE_SECONDS

600

BANNED_IPS

()

TEMPLATE_STRING_IF_INVALID

''

DATETIME_INPUT_FORMATS

('%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M', '%m/%d/%y')

DATABASE_PASSWORD

'****'

COMMENTS_MODERATORS_GROUP

None

PROFANITIES_LIST

'****'

EMAIL_HOST_USER

''

COMMENTS_BANNED_USERS_GROUP

None

You're seeing this error because you have DEBUG = True in your Django settings file. Change that to False, and Django will display a standard 500 page.

dsuch commented 10 years ago

Thanks @mentis-pl - this was recently fixed in git master in commit d5d089ee11184252624dfa7108d923acb29a6683 - I'll backport it to 1.1 as well.

dsuch commented 10 years ago

Just a quick update - this happens only when you log into web admin and choose Scheduler first. If you pick any other menu option, such as Channels, and choose a cluster there, the error won't happen.

Unfortunately, once it happens, you need to run 'zato stop' and 'zato start' on the web admin.

dsuch commented 10 years ago

As in #138 - a hotfix has just been released. Thanks for spotting it!