Last active
April 25, 2016 14:37
-
-
Save piotr-dobrogost/6d57cacb9e77f59748353b2b6c1334d7 to your computer and use it in GitHub Desktop.
SQLAlchemy bug - processors are cleared
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| File "/opt/pycharm/pycharm-2016.1.2/helpers/pydev/pydevd.py", line 1531, in <module> | |
| globals = debugger.run(setup['file'], None, None, is_module) | |
| File "/opt/pycharm/pycharm-2016.1.2/helpers/pydev/pydevd.py", line 938, in run | |
| pydev_imports.execfile(file, globals, locals) # execute the script | |
| File "/opt/pycharm/pycharm-2016.1.2/helpers/pycharm/pycharm_load_entry_point.py", line 12, in <module> | |
| sys.exit(f()) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/scripts/pserve.py", line 60, in main | |
| return command.run() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/scripts/pserve.py", line 367, in run | |
| global_conf=vars) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/scripts/pserve.py", line 402, in loadapp | |
| return loadapp(app_spec, name=name, relative_to=relative_to, **kw) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 247, in loadapp | |
| return loadobj(APP, uri, name=name, **kw) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 272, in loadobj | |
| return context.create() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 710, in create | |
| return self.object_type.invoke(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 203, in invoke | |
| app = context.app_context.create() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 710, in create | |
| return self.object_type.invoke(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 146, in invoke | |
| return fix_call(context.object, context.global_conf, **context.local_conf) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/util.py", line 55, in fix_call | |
| val = callable(*args, **kw) | |
| File "/home/piotr/projects/kotti/kotti/__init__.py", line 188, in main | |
| initialize_sql(engine) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 889, in initialize_sql | |
| populate() | |
| File "/home/piotr/projects/kotti/kotti/populate.py", line 59, in populate | |
| DBSession.flush() # Initializes workflow | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py", line 157, in do | |
| return getattr(self.registry(), name)(*args, **kwargs) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2019, in flush | |
| self._flush(objects) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2101, in _flush | |
| flush_context.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 368, in execute | |
| n.execute_aggregate(self, set_) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 626, in execute_aggregate | |
| uow) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj | |
| mapper, table, insert) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements | |
| execute(statement, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _execute_context | |
| result = context._setup_crud_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 822, in _setup_crud_result_proxy | |
| result = self.get_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 548, in get_result_proxy | |
| return ReturningResultProxy(self, returning_params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 620, in __init__ | |
| super(ReturningResultProxy, self).__init__(context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 495, in __init__ | |
| self._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 1174, in _init_metadata | |
| super(FullyBufferedResultProxy, self)._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 519, in _init_metadata | |
| import traceback; traceback.print_stack(); self._metadata = self.context.compiled._cached_metadata | |
| Dubugger shows: | |
| metadata: | |
| <type 'list'>: [('ret_0', None)] | |
| self: | |
| <sqlalchemy.dialects.oracle.cx_oracle.ReturningResultProxy object at 0x7fa30c654fd0> | |
| self.context.execution_options: | |
| immutabledict({'compiled_cache': {(<code object <lambda> at 0x7f66480299b0, file "/home/piotr/projects/kotti/kotti/resources.py", line 819>,): [(<code object <lambda> at 0x7f66480299b0, file "/home/piotr/projects/kotti/kotti/resources.py", line 819>,), <sqlalchemy.orm.query.QueryContext object at 0x7f66411d7e50>, 3], (<sqlalchemy.dialects.oracle.cx_oracle.OracleDialect_cx_oracle object at 0x7f6642b3f2d0>, <sqlalchemy.sql.selectable.Select at 0x7f6639b532d0; Select object>, ('name',), False): [(<sqlalchemy.dialects.oracle.cx_oracle.OracleDialect_cx_oracle object at 0x7f6642b3f2d0>, <sqlalchemy.sql.selectable.Select at 0x7f6639b532d0; Select object>, ('name',), False), <sqlalchemy.dialects.oracle.cx_oracle.OracleCompiler_cx_oracle object at 0x7f6639aec110>, 2], (<code object <lambda> at 0x7f6642e60730, file "/home/piotr/projects/kotti/kotti/security.py", line 461>,): [(<code object <lambda> at 0x7f6642e60730, file "/home/piotr/projects/kotti/kotti/security.py", line 461>,), <sqlalchemy.orm.query.QueryContext object at 0x7f66411d7d50>, 1], (<sqlalchemy.dialects.oracle.cx_oracle.OracleDialect_cx_oracle object at 0x7f6642b3f2d0>, <sqlalchemy.sql.selectable.Select at 0x7f6639919bd0; Select object>, (), False): [(<sqlalchemy.dialects.oracle.cx_oracle.OracleDialect_cx_oracle object at 0x7f6642b3f2d0>, <sqlalchemy.sql.selectable.Select at 0x7f6639919bd0; Select object>, (), False), <sqlalchemy.dialects.oracle.cx_oracle.OracleCompiler_cx_oracle object at 0x7f66380cb4d0>, 4]}}) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| File "/usr/local/lib/python2.7/threading.py", line 783, in __bootstrap | |
| self.__bootstrap_inner() | |
| File "/usr/local/lib/python2.7/threading.py", line 810, in __bootstrap_inner | |
| self.run() | |
| File "/usr/local/lib/python2.7/threading.py", line 763, in run | |
| self.__target(*self.__args, **self.__kwargs) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 78, in handler_thread | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/channel.py", line 336, in service | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 169, in service | |
| self.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 388, in execute | |
| app_iter = self.channel.server.application(env, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/publisher.py", line 224, in __call__ | |
| return self.app(environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/injector.py", line 64, in __call__ | |
| response = request.get_response(self.app) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1299, in send | |
| application, catch_exc_info=False) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1263, in call_application | |
| app_iter = application(self.environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__ | |
| response = self.invoke_subrequest(request, use_tweens=True) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 192, in toolbar_tween | |
| response = _handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/panels/performance.py", line 57, in resource_timer_handler | |
| result = handler(request) | |
| File "/home/piotr/projects/kotti/kotti/filedepot.py", line 518, in __call__ | |
| response = self.handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 83, in tm_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 254, in __iter__ | |
| with_session(self.session)._execute_and_instances(context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1161, in _execute_context | |
| result = context.get_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 555, in get_result_proxy | |
| result = _result.BufferedColumnResultProxy(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 495, in __init__ | |
| self._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 1239, in _init_metadata | |
| super(BufferedColumnResultProxy, self)._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 519, in _init_metadata | |
| import traceback; traceback.print_stack(); self._metadata = self.context.compiled._cached_metadata | |
| Dubugger shows: | |
| metadata: | |
| <type 'list'>: [('NODES_ID', <type 'cx_Oracle.NUMBER'>, 39, 22, 38, 0, 0), ('NODES_TYPE', <type 'cx_Oracle.STRING'>, 30, 120, 0, 0, 0), ('NODES_PARENT_ID', <type 'cx_Oracle.NUMBER'>, 39, 22, 38, 0, 1), ('NODES_POSITION', <type 'cx_Oracle.NUMBER'>, 39, 22, 38, 0, 1), ('NODES__ACL', <type 'cx_Oracle.CLOB'>, -1, 4000, 0, 0, 1), ('NODES_NAME', <type 'cx_Oracle.NCHAR'>, 250, 500, 0, 0, 1), ('NODES_TITLE', <type 'cx_Oracle.NCHAR'>, 250, 500, 0, 0, 1), ('NODES_ANNOTATIONS', <type 'cx_Oracle.CLOB'>, -1, 4000, 0, 0, 1), ('NODES_PATH', <type 'cx_Oracle.NCHAR'>, 2000, 4000, 0, 0, 1)] | |
| self: | |
| <sqlalchemy.engine.result.BufferedColumnResultProxy object at 0x7fa30a3fd590> | |
| self.context.execution_options: | |
| immutabledict({'autocommit': True, 'compiled_cache': {(<sqlalchemy.dialects.oracle.cx_oracle.OracleDialect_cx_oracle object at 0x7fab80fa82d0>, <sqlalchemy.sql.dml.Insert object at 0x7fab77f54350>, ('body', 'id', 'mime_type'), False): [(<sqlalchemy.dialects.oracle.cx_oracle.OracleDialect_cx_oracle object at 0x7fab80fa82d0>, <sqlalchemy.sql.dml.Insert object at 0x7fab77f54350>, ('body', 'id', 'mime_type'), False), <sqlalchemy.dialects.oracle.cx_oracle.OracleCompiler_cx_oracle object at 0x7fab77f54310>, 3], (<sqlalchemy.dialects.oracle.cx_oracle.OracleDialect_cx_oracle object at 0x7fab80fa82d0>, <sqlalchemy.sql.dml.Insert object at 0x7fab77f00c50>, ('_acl', 'annotations', 'name', 'parent_id', 'path', 'position', 'title', 'type'), False): [(<sqlalchemy.dialects.oracle.cx_oracle.OracleDialect_cx_oracle object at 0x7fab80fa82d0>, <sqlalchemy.sql.dml.Insert object at 0x7fab77f00c50>, ('_acl', 'annotations', 'name', 'parent_id', 'path', 'position', 'title', 'type'), False), <sqlalchemy.dialects.oracle.cx_oracle.OracleCompiler_cx_oracle object at 0x7fab77f00d90>, 4], (<sqlalchemy.dialects.oracle.cx_oracle.OracleDialect_cx_oracle object at 0x7fab80fa82d0>, <sqlalchemy.sql.dml.Insert object at 0x7fab77f008d0>, ('creation_date', 'default_view', 'description', 'id', 'in_navigation', 'language', 'modification_date', 'owner', 'state'), False): [(<sqlalchemy.dialects.oracle.cx_oracle.OracleDialect_cx_oracle object at 0x7fab80fa82d0>, <sqlalchemy.sql.dml.Insert object at 0x7fab77f008d0>, ('creation_date', 'default_view', 'description', 'id', 'in_navigation', 'language', 'modification_date', 'owner', 'state'), False), <sqlalchemy.dialects.oracle.cx_oracle.OracleCompiler_cx_oracle object at 0x7fab77eea950>, 2]}}) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /home/piotr/.virtualenvs/kotti/bin/python /opt/pycharm/pycharm-2016.1.2/helpers/pydev/pydevd.py --multiproc --qt-support --client 127.0.0.1 --port 36018 --file /opt/pycharm/pycharm-2016.1.2/helpers/pycharm/pycharm_load_entry_point.py /home/piotr/projects/kotti/development.ini | |
| pydev debugger: process 10054 is connecting | |
| Connected to pydev debugger (build 145.844) | |
| 2016-04-25 16:35:55,520 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT USER FROM DUAL | |
| 2016-04-25 16:35:55,520 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,524 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT CAST('test plain returns' AS VARCHAR(60 CHAR)) AS anon_1 FROM DUAL | |
| 2016-04-25 16:35:55,525 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,527 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT CAST('test unicode returns' AS NVARCHAR2(60)) AS anon_1 FROM DUAL | |
| 2016-04-25 16:35:55,527 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,535 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE nvl(tablespace_name, 'no tablespace') NOT IN ('SYSTEM', 'SYSAUX') AND OWNER = :owner AND IOT_NAME IS NULL AND DURATION IS NULL | |
| 2016-04-25 16:35:55,535 INFO [sqlalchemy.engine.base.Engine][MainThread] {'owner': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,602 INFO [sqlalchemy.engine.base.Engine][MainThread] BEGIN (implicit) | |
| 2016-04-25 16:35:55,604 INFO [alembic.runtime.migration][MainThread] Context impl OracleImpl. | |
| 2016-04-25 16:35:55,606 INFO [alembic.runtime.migration][MainThread] Will assume non-transactional DDL. | |
| 2016-04-25 16:35:55,607 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,608 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'KOTTI_ALEMBIC_VERSION', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,614 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,615 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'KOTTI_ALEMBIC_VERSION', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,620 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE kotti_alembic_version ( | |
| version_num VARCHAR2(32 CHAR) NOT NULL | |
| ) | |
| 2016-04-25 16:35:55,620 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,651 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,651 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'KOTTI_ALEMBIC_VERSION', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,661 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT kotti_alembic_version.version_num | |
| FROM kotti_alembic_version | |
| 2016-04-25 16:35:55,661 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,668 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,668 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'KOTTI_ALEMBIC_VERSION', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,678 INFO [sqlalchemy.engine.base.Engine][MainThread] INSERT INTO kotti_alembic_version (version_num) VALUES ('814c4ec72f1') | |
| 2016-04-25 16:35:55,679 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,692 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:55,697 INFO [sqlalchemy.engine.base.Engine][MainThread] BEGIN (implicit) | |
| 2016-04-25 16:35:55,699 INFO [alembic.runtime.migration][MainThread] Context impl OracleImpl. | |
| 2016-04-25 16:35:55,699 INFO [alembic.runtime.migration][MainThread] Will assume non-transactional DDL. | |
| 2016-04-25 16:35:55,701 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,701 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'KOTTI_IMAGE_ALEMBIC_VERSION', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,706 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,706 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'KOTTI_IMAGE_ALEMBIC_VERSION', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,710 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE kotti_image_alembic_version ( | |
| version_num VARCHAR2(32 CHAR) NOT NULL | |
| ) | |
| 2016-04-25 16:35:55,711 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,720 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,721 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'KOTTI_IMAGE_ALEMBIC_VERSION', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,729 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT kotti_image_alembic_version.version_num | |
| FROM kotti_image_alembic_version | |
| 2016-04-25 16:35:55,730 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,736 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,736 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'KOTTI_IMAGE_ALEMBIC_VERSION', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,745 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:55,748 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,748 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'FILES', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,752 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,753 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'DOCUMENTS', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,757 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,757 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'BLOBS', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,761 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,762 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'TAGS', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,765 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,766 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'TAGS_TO_CONTENTS', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,770 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,770 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'LOCAL_GROUPS', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,774 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,774 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'IMAGES', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,779 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,779 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'NODES', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,783 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,783 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'PRINCIPALS', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,787 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT table_name FROM all_tables WHERE table_name = :name AND owner = :schema_name | |
| 2016-04-25 16:35:55,787 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'CONTENTS', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,792 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE blobs ( | |
| id INTEGER NOT NULL, | |
| file_id VARCHAR2(36 CHAR), | |
| filename NVARCHAR2(100), | |
| content_type VARCHAR2(100 CHAR), | |
| content_length INTEGER, | |
| last_modified DATE, | |
| data BLOB, | |
| PRIMARY KEY (id) | |
| ) | |
| 2016-04-25 16:35:55,793 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,811 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:55,813 INFO [sqlalchemy.engine.base.Engine][MainThread] CREATE INDEX ix_blobs_file_id ON blobs (file_id) | |
| 2016-04-25 16:35:55,814 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,891 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:55,893 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT sequence_name FROM all_sequences WHERE sequence_name = :name AND sequence_owner = :schema_name | |
| 2016-04-25 16:35:55,894 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'TAGS_ID_SEQ', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,898 INFO [sqlalchemy.engine.base.Engine][MainThread] CREATE SEQUENCE tags_id_seq | |
| 2016-04-25 16:35:55,899 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,904 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:55,906 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE tags ( | |
| id INTEGER NOT NULL, | |
| title NVARCHAR2(100) NOT NULL, | |
| PRIMARY KEY (id), | |
| UNIQUE (title) | |
| ) | |
| 2016-04-25 16:35:55,906 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,931 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:55,934 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT sequence_name FROM all_sequences WHERE sequence_name = :name AND sequence_owner = :schema_name | |
| 2016-04-25 16:35:55,934 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'NODES_ID_SEQ', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:55,938 INFO [sqlalchemy.engine.base.Engine][MainThread] CREATE SEQUENCE nodes_id_seq | |
| 2016-04-25 16:35:55,939 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:55,944 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:55,948 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE nodes ( | |
| id INTEGER NOT NULL, | |
| type VARCHAR2(30 CHAR) NOT NULL, | |
| parent_id INTEGER, | |
| position INTEGER, | |
| "_acl" CLOB, | |
| name NVARCHAR2(250), | |
| title NVARCHAR2(250), | |
| annotations CLOB, | |
| path NVARCHAR2(2000), | |
| PRIMARY KEY (id), | |
| UNIQUE (parent_id, name), | |
| FOREIGN KEY(parent_id) REFERENCES nodes (id) | |
| ) | |
| 2016-04-25 16:35:55,949 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,004 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,006 INFO [sqlalchemy.engine.base.Engine][MainThread] CREATE INDEX ix_nodes_path ON nodes (path) | |
| 2016-04-25 16:35:56,007 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,023 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,024 INFO [sqlalchemy.engine.base.Engine][MainThread] CREATE INDEX ix_nodes_parent_id ON nodes (parent_id) | |
| 2016-04-25 16:35:56,025 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,524 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,526 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT sequence_name FROM all_sequences WHERE sequence_name = :name AND sequence_owner = :schema_name | |
| 2016-04-25 16:35:56,527 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'PRINCIPALS_ID_SEQ', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:56,531 INFO [sqlalchemy.engine.base.Engine][MainThread] CREATE SEQUENCE principals_id_seq | |
| 2016-04-25 16:35:56,532 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,537 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,541 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE principals ( | |
| id INTEGER NOT NULL, | |
| name NVARCHAR2(100), | |
| password NVARCHAR2(100), | |
| active SMALLINT, | |
| confirm_token NVARCHAR2(100), | |
| title NVARCHAR2(100) NOT NULL, | |
| email NVARCHAR2(100), | |
| groups CLOB NOT NULL, | |
| creation_date DATE NOT NULL, | |
| last_login_date DATE, | |
| PRIMARY KEY (id), | |
| UNIQUE (name), | |
| CHECK (active IN (0, 1)), | |
| UNIQUE (email) | |
| ) | |
| 2016-04-25 16:35:56,541 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,671 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,674 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT sequence_name FROM all_sequences WHERE sequence_name = :name AND sequence_owner = :schema_name | |
| 2016-04-25 16:35:56,675 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'LOCAL_GROUPS_ID_SEQ', 'schema_name': u'TMUB_CMS_DEV'} | |
| 2016-04-25 16:35:56,679 INFO [sqlalchemy.engine.base.Engine][MainThread] CREATE SEQUENCE local_groups_id_seq | |
| 2016-04-25 16:35:56,680 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,685 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,688 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE local_groups ( | |
| id INTEGER NOT NULL, | |
| node_id INTEGER, | |
| principal_name NVARCHAR2(100), | |
| group_name NVARCHAR2(100), | |
| PRIMARY KEY (id), | |
| UNIQUE (node_id, principal_name, group_name), | |
| FOREIGN KEY(node_id) REFERENCES nodes (id) | |
| ) | |
| 2016-04-25 16:35:56,689 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,707 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,709 INFO [sqlalchemy.engine.base.Engine][MainThread] CREATE INDEX ix_local_groups_node_id ON local_groups (node_id) | |
| 2016-04-25 16:35:56,710 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,717 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,718 INFO [sqlalchemy.engine.base.Engine][MainThread] CREATE INDEX ix_local_groups_principal_name ON local_groups (principal_name) | |
| 2016-04-25 16:35:56,719 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,725 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,730 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE contents ( | |
| id INTEGER NOT NULL, | |
| default_view VARCHAR2(50 CHAR), | |
| description NCLOB, | |
| language NVARCHAR2(10), | |
| owner NVARCHAR2(100), | |
| state VARCHAR2(50 CHAR), | |
| creation_date DATE, | |
| modification_date DATE, | |
| in_navigation SMALLINT, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(id) REFERENCES nodes (id), | |
| CHECK (in_navigation IN (0, 1)) | |
| ) | |
| 2016-04-25 16:35:56,731 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,750 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,754 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE files ( | |
| filename NVARCHAR2(100), | |
| mimetype VARCHAR2(100 CHAR), | |
| "size" INTEGER, | |
| id INTEGER NOT NULL, | |
| data VARCHAR2(4000 CHAR), | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(id) REFERENCES contents (id) | |
| ) | |
| 2016-04-25 16:35:56,755 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,771 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,773 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE documents ( | |
| id INTEGER NOT NULL, | |
| body NCLOB, | |
| mime_type VARCHAR2(30 CHAR), | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(id) REFERENCES contents (id) | |
| ) | |
| 2016-04-25 16:35:56,774 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,789 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,791 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE tags_to_contents ( | |
| tag_id INTEGER NOT NULL, | |
| content_id INTEGER NOT NULL, | |
| position INTEGER NOT NULL, | |
| PRIMARY KEY (tag_id, content_id), | |
| FOREIGN KEY(tag_id) REFERENCES tags (id), | |
| FOREIGN KEY(content_id) REFERENCES contents (id) | |
| ) | |
| 2016-04-25 16:35:56,792 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,815 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,816 INFO [sqlalchemy.engine.base.Engine][MainThread] CREATE INDEX ix_tags_to_contents_tag_id ON tags_to_contents (tag_id) | |
| 2016-04-25 16:35:56,817 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,823 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,824 INFO [sqlalchemy.engine.base.Engine][MainThread] CREATE INDEX ix_tags_to_contents_content_id ON tags_to_contents (content_id) | |
| 2016-04-25 16:35:56,825 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,831 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,833 INFO [sqlalchemy.engine.base.Engine][MainThread] | |
| CREATE TABLE images ( | |
| filename NVARCHAR2(100), | |
| mimetype VARCHAR2(100 CHAR), | |
| "size" INTEGER, | |
| id INTEGER NOT NULL, | |
| data VARCHAR2(4000 CHAR), | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(id) REFERENCES contents (id) | |
| ) | |
| 2016-04-25 16:35:56,834 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:56,852 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| 2016-04-25 16:35:56,958 INFO [sqlalchemy.engine.base.Engine][MainThread] BEGIN (implicit) | |
| 2016-04-25 16:35:56,960 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT count(*) AS count_1 | |
| FROM (SELECT nodes.id AS nodes_id | |
| FROM nodes LEFT OUTER JOIN contents ON nodes.id = contents.id LEFT OUTER JOIN documents ON contents.id = documents.id LEFT OUTER JOIN files ON contents.id = files.id LEFT OUTER JOIN images ON contents.id = images.id) anon_1 | |
| 2016-04-25 16:35:56,960 INFO [sqlalchemy.engine.base.Engine][MainThread] {} | |
| 2016-04-25 16:35:57,063 INFO [sqlalchemy.engine.base.Engine][MainThread] INSERT INTO nodes (id, type, parent_id, position, "_acl", name, title, annotations, path) VALUES (nodes_id_seq.nextval, :type, :parent_id, :position, :"_acl", :name, :title, :annotations, :path) RETURNING nodes.id INTO :ret_0 | |
| 2016-04-25 16:35:57,063 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'', 'title': u'Welcome to Kotti', 'ret_0': <cx_Oracle.NUMBER with value None>, 'parent_id': None, '"_acl"': '[["Allow", "role:owner", "view"], ["Allow", "role:owner", "add"], ["Allow", "role:owner", "edit"], ["Allow", "role:owner", "delete"], ["Allow", "role:owner", "manage"], ["Allow", "role:owner", "state_change"], ["Allow", "role:viewer", "view"], ["Allow", "role:editor", "view"], ["Allow", "role:editor", "add"], ["Allow", "role:editor", "edit"], ["Allow", "role:editor", "delete"], ["Allow", "role:editor", "state_change"], ["Deny", "system.Everyone", "__ALL_PERMISSIONS__"]]', 'path': u'/', 'position': None, 'type': 'document', 'annotations': '{}'} | |
| 2016-04-25 16:35:57,340 INFO [sqlalchemy.engine.base.Engine][MainThread] INSERT INTO contents (id, default_view, description, language, owner, state, creation_date, modification_date, in_navigation) VALUES (:id, :default_view, :description, :language, :owner, :state, :creation_date, :modification_date, :in_navigation) | |
| 2016-04-25 16:35:57,341 INFO [sqlalchemy.engine.base.Engine][MainThread] {'default_view': None, 'description': u'Congratulations! You have successfully installed Kotti.', 'language': None, 'creation_date': datetime.datetime(2016, 4, 25, 16, 35, 56, 970780), 'state': u'private', 'owner': None, 'in_navigation': 1, 'id': 1, 'modification_date': datetime.datetime(2016, 4, 25, 16, 35, 56, 970780)} | |
| 2016-04-25 16:35:57,365 INFO [sqlalchemy.engine.base.Engine][MainThread] INSERT INTO documents (id, body, mime_type) VALUES (:id, :body, :mime_type) | |
| 2016-04-25 16:35:57,366 INFO [sqlalchemy.engine.base.Engine][MainThread] {'body': u'\n<h2>Log in</h2>\n<p>\n You can <a class="btn btn-success" href="login">log in</a> to your site\n and start changing its contents. If you haven\'t chosen a password for\n your admin account yet, it\'ll likely be <em>qwerty</em>.\n</p>\n<p>\n Once you\'re logged in, you\'ll see the grey editor bar below the top\n navigation bar. It will allow you to switch between editing and viewing the\n current page as it will appear to your visitors.\n</p>\n<div class="row">\n <div class="col-md-4">\n <h2>Configure</h2>\n <p>\n Find out how to configure your Kotti\'s title and many other\n settings using a simple text file in your file system.\n </p>\n <p>\n <a class="btn btn-info" href="http://kotti.readthedocs.org/en/latest/developing/basic/configuration.html">\n Configuration manual\n </a>\n </p>\n </div>\n <div class="col-md-4">\n <h2>Add-ons</h2>\n <p>\n A number of add-ons allow you to extend the functionality of your\n Kotti site.\n </p>\n <p>\n <a class="btn btn-info" href="http://pypi.python.org/pypi?%3Aaction=search&term=kotti">\n Kotti add-ons\n </a>\n </p>\n </div>\n <div class="col-md-4">\n <h2>Documentation</h2>\n <p>\n Wonder what more you can do with Kotti?\n What license it has?\n Read the manual for more information.\n </p>\n <p>\n <a class="btn btn-info" href="http://kotti.readthedocs.org/en/latest/">\n Documentation\n </a>\n </p>\n </div>\n</div>\n', 'id': 1, 'mime_type': 'text/html'} | |
| 2016-04-25 16:35:57,382 INFO [sqlalchemy.engine.base.Engine][MainThread] INSERT INTO nodes (id, type, parent_id, position, "_acl", name, title, annotations, path) VALUES (nodes_id_seq.nextval, :type, :parent_id, :position, :"_acl", :name, :title, :annotations, :path) RETURNING nodes.id INTO :ret_0 | |
| 2016-04-25 16:35:57,383 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'about', 'title': u'About', 'ret_0': <cx_Oracle.NUMBER with value None>, 'parent_id': 1, '"_acl"': '[["Allow", "role:owner", "view"], ["Allow", "role:owner", "add"], ["Allow", "role:owner", "edit"], ["Allow", "role:owner", "delete"], ["Allow", "role:owner", "manage"], ["Allow", "role:owner", "state_change"], ["Allow", "role:viewer", "view"], ["Allow", "role:editor", "view"], ["Allow", "role:editor", "add"], ["Allow", "role:editor", "edit"], ["Allow", "role:editor", "delete"], ["Allow", "role:editor", "state_change"], ["Deny", "system.Everyone", "__ALL_PERMISSIONS__"]]', 'path': u'/about/', 'position': 0, 'type': 'document', 'annotations': '{}'} | |
| File "/opt/pycharm/pycharm-2016.1.2/helpers/pydev/pydevd.py", line 1531, in <module> | |
| globals = debugger.run(setup['file'], None, None, is_module) | |
| File "/opt/pycharm/pycharm-2016.1.2/helpers/pydev/pydevd.py", line 938, in run | |
| pydev_imports.execfile(file, globals, locals) # execute the script | |
| File "/opt/pycharm/pycharm-2016.1.2/helpers/pycharm/pycharm_load_entry_point.py", line 12, in <module> | |
| sys.exit(f()) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/scripts/pserve.py", line 60, in main | |
| return command.run() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/scripts/pserve.py", line 367, in run | |
| global_conf=vars) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/scripts/pserve.py", line 402, in loadapp | |
| return loadapp(app_spec, name=name, relative_to=relative_to, **kw) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 247, in loadapp | |
| return loadobj(APP, uri, name=name, **kw) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 272, in loadobj | |
| return context.create() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 710, in create | |
| return self.object_type.invoke(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 203, in invoke | |
| app = context.app_context.create() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 710, in create | |
| return self.object_type.invoke(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 146, in invoke | |
| return fix_call(context.object, context.global_conf, **context.local_conf) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/paste/deploy/util.py", line 55, in fix_call | |
| val = callable(*args, **kw) | |
| File "/home/piotr/projects/kotti/kotti/__init__.py", line 188, in main | |
| initialize_sql(engine) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 889, in initialize_sql | |
| populate() | |
| File "/home/piotr/projects/kotti/kotti/populate.py", line 59, in populate | |
| DBSession.flush() # Initializes workflow | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py", line 157, in do | |
| return getattr(self.registry(), name)(*args, **kwargs) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2019, in flush | |
| self._flush(objects) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2101, in _flush | |
| flush_context.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 368, in execute | |
| n.execute_aggregate(self, set_) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 626, in execute_aggregate | |
| uow) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj | |
| mapper, table, insert) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements | |
| execute(statement, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _execute_context | |
| result = context._setup_crud_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 822, in _setup_crud_result_proxy | |
| result = self.get_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 548, in get_result_proxy | |
| return ReturningResultProxy(self, returning_params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 620, in __init__ | |
| super(ReturningResultProxy, self).__init__(context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 495, in __init__ | |
| self._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 1174, in _init_metadata | |
| super(FullyBufferedResultProxy, self)._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 519, in _init_metadata | |
| import traceback; traceback.print_stack(); self._metadata = self.context.compiled._cached_metadata | |
| 2016-04-25 16:35:57,399 INFO [sqlalchemy.engine.base.Engine][MainThread] INSERT INTO contents (id, default_view, description, language, owner, state, creation_date, modification_date, in_navigation) VALUES (:id, :default_view, :description, :language, :owner, :state, :creation_date, :modification_date, :in_navigation) | |
| 2016-04-25 16:35:57,399 INFO [sqlalchemy.engine.base.Engine][MainThread] {'default_view': None, 'description': u'Our company is the leading manufacturer of foo widgets used in a wide variety of aviation and and industrial products.', 'language': None, 'creation_date': datetime.datetime(2016, 4, 25, 16, 35, 57, 35105), 'state': u'private', 'owner': None, 'in_navigation': 1, 'id': 2, 'modification_date': datetime.datetime(2016, 4, 25, 16, 35, 57, 35105)} | |
| 2016-04-25 16:35:57,406 INFO [sqlalchemy.engine.base.Engine][MainThread] INSERT INTO documents (id, body, mime_type) VALUES (:id, :body, :mime_type) | |
| 2016-04-25 16:35:57,407 INFO [sqlalchemy.engine.base.Engine][MainThread] {'body': u'\n<p>\n <img alt="five colorful Extra EA300 airplanes flying in formation" height="376" src="http://upload.wikimedia.org/wikipedia/commons/thumb/5/5d/Northern_Lights_Formation.jpg/640px-Northern_Lights_Formation.jpg" width="640">\n</p>\n\n<p>\n Our worldwide headquarters:\n</p>\n\n<address>\n Foo World<br>\n 123 Nowhere Street, Suite 777<br>\n Omak, WA 98841 USA<br>\n +1-509-555-0100<br>\n [email protected]\n</address>\n\n<p><small style="font-size: smaller;">\n<em>Photo credit:</em> "Northern Lights Formation" by FlugKerl2.\n<a href="http://commons.wikimedia.org/wiki/File:Northern_Lights_Formation.jpg">\nCopyright info</a>.\nOriginally published in the\n<a href="http://en.wikipedia.org/wiki/Extra_EA-300"> Extra EA-300</a>\narticle.\n</small></p>\n', 'id': 2, 'mime_type': 'text/html'} | |
| 2016-04-25 16:35:57,458 INFO [sqlalchemy.engine.base.Engine][MainThread] UPDATE nodes SET "_acl"=:"_acl" WHERE nodes.id = :nodes_id | |
| 2016-04-25 16:35:57,458 INFO [sqlalchemy.engine.base.Engine][MainThread] {'nodes_id': 1, '"_acl"': '[["Allow", "role:owner", "view"], ["Allow", "role:owner", "add"], ["Allow", "role:owner", "edit"], ["Allow", "role:owner", "delete"], ["Allow", "role:owner", "manage"], ["Allow", "role:owner", "state_change"], ["Allow", "role:viewer", "view"], ["Allow", "role:editor", "view"], ["Allow", "role:editor", "add"], ["Allow", "role:editor", "edit"], ["Allow", "role:editor", "delete"], ["Allow", "role:editor", "state_change"], ["Allow", "system.Everyone", "view"], ["Deny", "system.Everyone", "__ALL_PERMISSIONS__"]]'} | |
| 2016-04-25 16:35:57,466 INFO [sqlalchemy.engine.base.Engine][MainThread] UPDATE contents SET state=:state, modification_date=:modification_date WHERE contents.id = :contents_id | |
| 2016-04-25 16:35:57,467 INFO [sqlalchemy.engine.base.Engine][MainThread] {'state': u'public', 'contents_id': 1, 'modification_date': datetime.datetime(2016, 4, 25, 16, 35, 57, 417490)} | |
| 2016-04-25 16:35:57,473 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT principals.id AS principals_id, principals.name AS principals_name, principals.password AS principals_password, principals.active AS principals_active, principals.confirm_token AS principals_confirm_token, principals.title AS principals_title, principals.email AS principals_email, principals.groups AS principals_groups, principals.creation_date AS principals_creation_date, principals.last_login_date AS principals_last_login_da_1 | |
| FROM principals | |
| WHERE principals.name = :name ORDER BY principals.name | |
| 2016-04-25 16:35:57,474 INFO [sqlalchemy.engine.base.Engine][MainThread] {'name': u'admin'} | |
| 2016-04-25 16:35:57,567 INFO [sqlalchemy.engine.base.Engine][MainThread] INSERT INTO principals (id, name, password, active, confirm_token, title, email, groups, creation_date, last_login_date) VALUES (principals_id_seq.nextval, :name, :password, :active, :confirm_token, :title, :email, :groups, :creation_date, :last_login_date) RETURNING principals.id INTO :ret_0 | |
| 2016-04-25 16:35:57,568 INFO [sqlalchemy.engine.base.Engine][MainThread] {'groups': '["role:admin"]', 'confirm_token': None, 'name': u'admin', 'title': u'Administrator', 'creation_date': datetime.datetime(2016, 4, 25, 16, 35, 57, 564070), 'last_login_date': None, 'ret_0': <cx_Oracle.NUMBER with value None>, 'active': 1, 'password': u'$2a$10$PESpl1pLprIBFETF6wvc3u/dBiow2EAHv/rI/N.aEuIDjUhtcuxuG', 'email': None} | |
| 2016-04-25 16:35:57,661 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT | |
| Starting server in PID 10054. | |
| serving on http://0.0.0.0:5000 | |
| 2016-04-25 16:36:02,951 INFO [sqlalchemy.engine.base.Engine][waitress] BEGIN (implicit) | |
| 2016-04-25 16:36:02,954 INFO [sqlalchemy.engine.base.Engine][waitress] SELECT nodes.id AS nodes_id, nodes.type AS nodes_type, nodes.parent_id AS nodes_parent_id, nodes.position AS nodes_position, nodes."_acl" AS nodes__acl, nodes.name AS nodes_name, nodes.title AS nodes_title, nodes.annotations AS nodes_annotations, nodes.path AS nodes_path | |
| FROM nodes LEFT OUTER JOIN contents ON nodes.id = contents.id LEFT OUTER JOIN documents ON contents.id = documents.id LEFT OUTER JOIN files ON contents.id = files.id LEFT OUTER JOIN images ON contents.id = images.id | |
| WHERE nodes.parent_id IS NULL | |
| 2016-04-25 16:36:02,955 INFO [sqlalchemy.engine.base.Engine][waitress] {} | |
| File "/usr/local/lib/python2.7/threading.py", line 783, in __bootstrap | |
| self.__bootstrap_inner() | |
| File "/usr/local/lib/python2.7/threading.py", line 810, in __bootstrap_inner | |
| self.run() | |
| File "/usr/local/lib/python2.7/threading.py", line 763, in run | |
| self.__target(*self.__args, **self.__kwargs) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 78, in handler_thread | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/channel.py", line 336, in service | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 169, in service | |
| self.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 388, in execute | |
| app_iter = self.channel.server.application(env, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/publisher.py", line 224, in __call__ | |
| return self.app(environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/injector.py", line 64, in __call__ | |
| response = request.get_response(self.app) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1299, in send | |
| application, catch_exc_info=False) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1263, in call_application | |
| app_iter = application(self.environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__ | |
| response = self.invoke_subrequest(request, use_tweens=True) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 192, in toolbar_tween | |
| response = _handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/panels/performance.py", line 57, in resource_timer_handler | |
| result = handler(request) | |
| File "/home/piotr/projects/kotti/kotti/filedepot.py", line 518, in __call__ | |
| response = self.handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 83, in tm_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 254, in __iter__ | |
| with_session(self.session)._execute_and_instances(context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1161, in _execute_context | |
| result = context.get_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 555, in get_result_proxy | |
| result = _result.BufferedColumnResultProxy(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 495, in __init__ | |
| self._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 1239, in _init_metadata | |
| super(BufferedColumnResultProxy, self)._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 519, in _init_metadata | |
| import traceback; traceback.print_stack(); self._metadata = self.context.compiled._cached_metadata | |
| 2016-04-25 16:36:02,975 INFO [sqlalchemy.engine.base.Engine][waitress] ROLLBACK | |
| 2016-04-25 16:36:02,986 ERROR [pyramid_debugtoolbar][waitress] Exception at http://localhost:5000/ | |
| traceback url: http://localhost:5000/_debug_toolbar/exception?token=1325882a486db59e4071&tb=139729929603088 | |
| Traceback (most recent call last): | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 192, in toolbar_tween | |
| response = _handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/panels/performance.py", line 57, in resource_timer_handler | |
| result = handler(request) | |
| File "/home/piotr/projects/kotti/kotti/filedepot.py", line 518, in __call__ | |
| response = self.handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 101, in tm_tween | |
| reraise(*exc_info) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 83, in tm_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 86, in instances | |
| util.raise_from_cause(err) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 74, in instances | |
| for row in fetch] | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 596, in polymorphic_instance | |
| return _instance(row) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 432, in _instance | |
| state.manager.dispatch.load(state, context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/event/attr.py", line 256, in __call__ | |
| fn(*args, **kw) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/mutable.py", line 451, in load | |
| val = cls.coerce(key, val) | |
| File "/home/piotr/projects/kotti/kotti/sqla.py", line 116, in coerce | |
| return Mutable.coerce(key, value) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/mutable.py", line 403, in coerce | |
| raise ValueError(msg % (key, type(value))) | |
| ValueError: Attribute '_acl' does not accept objects of type <type 'cx_Oracle.LOB'> | |
| 2016-04-25 16:36:02,990 INFO [sqlalchemy.engine.base.Engine][waitress] BEGIN (implicit) | |
| 2016-04-25 16:36:02,991 INFO [sqlalchemy.engine.base.Engine][waitress] SELECT nodes.id AS nodes_id, nodes.type AS nodes_type, nodes.parent_id AS nodes_parent_id, nodes.position AS nodes_position, nodes."_acl" AS nodes__acl, nodes.name AS nodes_name, nodes.title AS nodes_title, nodes.annotations AS nodes_annotations, nodes.path AS nodes_path | |
| FROM nodes LEFT OUTER JOIN contents ON nodes.id = contents.id LEFT OUTER JOIN documents ON contents.id = documents.id LEFT OUTER JOIN files ON contents.id = files.id LEFT OUTER JOIN images ON contents.id = images.id | |
| WHERE nodes.parent_id IS NULL | |
| 2016-04-25 16:36:02,992 INFO [sqlalchemy.engine.base.Engine][waitress] {} | |
| File "/usr/local/lib/python2.7/threading.py", line 783, in __bootstrap | |
| self.__bootstrap_inner() | |
| File "/usr/local/lib/python2.7/threading.py", line 810, in __bootstrap_inner | |
| self.run() | |
| File "/usr/local/lib/python2.7/threading.py", line 763, in run | |
| self.__target(*self.__args, **self.__kwargs) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 78, in handler_thread | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/channel.py", line 336, in service | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 169, in service | |
| self.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 388, in execute | |
| app_iter = self.channel.server.application(env, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/publisher.py", line 224, in __call__ | |
| return self.app(environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/injector.py", line 64, in __call__ | |
| response = request.get_response(self.app) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1299, in send | |
| application, catch_exc_info=False) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1263, in call_application | |
| app_iter = application(self.environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__ | |
| response = self.invoke_subrequest(request, use_tweens=True) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 218, in toolbar_tween | |
| response = request.invoke_subrequest(subrequest) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 254, in __iter__ | |
| with_session(self.session)._execute_and_instances(context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1161, in _execute_context | |
| result = context.get_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 555, in get_result_proxy | |
| result = _result.BufferedColumnResultProxy(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 495, in __init__ | |
| self._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 1239, in _init_metadata | |
| super(BufferedColumnResultProxy, self)._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 519, in _init_metadata | |
| import traceback; traceback.print_stack(); self._metadata = self.context.compiled._cached_metadata | |
| File "/usr/local/lib/python2.7/threading.py", line 783, in __bootstrap | |
| self.__bootstrap_inner() | |
| File "/usr/local/lib/python2.7/threading.py", line 810, in __bootstrap_inner | |
| self.run() | |
| File "/usr/local/lib/python2.7/threading.py", line 763, in run | |
| self.__target(*self.__args, **self.__kwargs) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 78, in handler_thread | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/channel.py", line 336, in service | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 169, in service | |
| self.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 388, in execute | |
| app_iter = self.channel.server.application(env, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/publisher.py", line 224, in __call__ | |
| return self.app(environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/injector.py", line 64, in __call__ | |
| response = request.get_response(self.app) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1299, in send | |
| application, catch_exc_info=False) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1263, in call_application | |
| app_iter = application(self.environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__ | |
| response = self.invoke_subrequest(request, use_tweens=True) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 218, in toolbar_tween | |
| response = request.invoke_subrequest(subrequest) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 254, in __iter__ | |
| with_session(self.session)._execute_and_instances(context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1161, in _execute_context | |
| result = context.get_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 555, in get_result_proxy | |
| result = _result.BufferedColumnResultProxy(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 495, in __init__ | |
| self._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 1239, in _init_metadata | |
| super(BufferedColumnResultProxy, self)._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 519, in _init_metadata | |
| import traceback; traceback.print_stack(); self._metadata = self.context.compiled._cached_metadata | |
| 2016-04-25 16:36:02,998 ERROR [waitress][waitress] Exception when serving / | |
| Traceback (most recent call last): | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/channel.py", line 336, in service | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 169, in service | |
| self.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 388, in execute | |
| app_iter = self.channel.server.application(env, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/publisher.py", line 224, in __call__ | |
| return self.app(environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/injector.py", line 64, in __call__ | |
| response = request.get_response(self.app) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1299, in send | |
| application, catch_exc_info=False) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1263, in call_application | |
| app_iter = application(self.environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__ | |
| response = self.invoke_subrequest(request, use_tweens=True) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 218, in toolbar_tween | |
| response = request.invoke_subrequest(subrequest) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 86, in instances | |
| util.raise_from_cause(err) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 74, in instances | |
| for row in fetch] | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 596, in polymorphic_instance | |
| return _instance(row) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 432, in _instance | |
| state.manager.dispatch.load(state, context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/event/attr.py", line 256, in __call__ | |
| fn(*args, **kw) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/mutable.py", line 451, in load | |
| val = cls.coerce(key, val) | |
| File "/home/piotr/projects/kotti/kotti/sqla.py", line 116, in coerce | |
| return Mutable.coerce(key, value) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/mutable.py", line 403, in coerce | |
| raise ValueError(msg % (key, type(value))) | |
| ValueError: Attribute '_acl' does not accept objects of type <type 'cx_Oracle.LOB'> | |
| 2016-04-25 16:36:03,461 INFO [sqlalchemy.engine.base.Engine][waitress] BEGIN (implicit) | |
| 2016-04-25 16:36:03,463 INFO [sqlalchemy.engine.base.Engine][waitress] SELECT nodes.id AS nodes_id, nodes.type AS nodes_type, nodes.parent_id AS nodes_parent_id, nodes.position AS nodes_position, nodes."_acl" AS nodes__acl, nodes.name AS nodes_name, nodes.title AS nodes_title, nodes.annotations AS nodes_annotations, nodes.path AS nodes_path | |
| FROM nodes LEFT OUTER JOIN contents ON nodes.id = contents.id LEFT OUTER JOIN documents ON contents.id = documents.id LEFT OUTER JOIN files ON contents.id = files.id LEFT OUTER JOIN images ON contents.id = images.id | |
| WHERE nodes.parent_id IS NULL | |
| 2016-04-25 16:36:03,463 INFO [sqlalchemy.engine.base.Engine][waitress] {} | |
| File "/usr/local/lib/python2.7/threading.py", line 783, in __bootstrap | |
| self.__bootstrap_inner() | |
| File "/usr/local/lib/python2.7/threading.py", line 810, in __bootstrap_inner | |
| self.run() | |
| File "/usr/local/lib/python2.7/threading.py", line 763, in run | |
| self.__target(*self.__args, **self.__kwargs) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 78, in handler_thread | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/channel.py", line 336, in service | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 169, in service | |
| self.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 388, in execute | |
| app_iter = self.channel.server.application(env, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/publisher.py", line 224, in __call__ | |
| return self.app(environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/injector.py", line 64, in __call__ | |
| response = request.get_response(self.app) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1299, in send | |
| application, catch_exc_info=False) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1263, in call_application | |
| app_iter = application(self.environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__ | |
| response = self.invoke_subrequest(request, use_tweens=True) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 192, in toolbar_tween | |
| response = _handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/panels/performance.py", line 57, in resource_timer_handler | |
| result = handler(request) | |
| File "/home/piotr/projects/kotti/kotti/filedepot.py", line 518, in __call__ | |
| response = self.handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 83, in tm_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 254, in __iter__ | |
| with_session(self.session)._execute_and_instances(context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1161, in _execute_context | |
| result = context.get_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 555, in get_result_proxy | |
| result = _result.BufferedColumnResultProxy(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 495, in __init__ | |
| self._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 1239, in _init_metadata | |
| super(BufferedColumnResultProxy, self)._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 519, in _init_metadata | |
| import traceback; traceback.print_stack(); self._metadata = self.context.compiled._cached_metadata | |
| File "/usr/local/lib/python2.7/threading.py", line 783, in __bootstrap | |
| self.__bootstrap_inner() | |
| File "/usr/local/lib/python2.7/threading.py", line 810, in __bootstrap_inner | |
| self.run() | |
| File "/usr/local/lib/python2.7/threading.py", line 763, in run | |
| self.__target(*self.__args, **self.__kwargs) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 78, in handler_thread | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/channel.py", line 336, in service | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 169, in service | |
| self.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 388, in execute | |
| app_iter = self.channel.server.application(env, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/publisher.py", line 224, in __call__ | |
| return self.app(environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/injector.py", line 64, in __call__ | |
| response = request.get_response(self.app) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1299, in send | |
| application, catch_exc_info=False) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1263, in call_application | |
| app_iter = application(self.environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__ | |
| response = self.invoke_subrequest(request, use_tweens=True) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 192, in toolbar_tween | |
| response = _handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/panels/performance.py", line 57, in resource_timer_handler | |
| result = handler(request) | |
| File "/home/piotr/projects/kotti/kotti/filedepot.py", line 518, in __call__ | |
| response = self.handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 83, in tm_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 254, in __iter__ | |
| with_session(self.session)._execute_and_instances(context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1161, in _execute_context | |
| result = context.get_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 555, in get_result_proxy | |
| result = _result.BufferedColumnResultProxy(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 495, in __init__ | |
| self._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 1239, in _init_metadata | |
| super(BufferedColumnResultProxy, self)._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 519, in _init_metadata | |
| import traceback; traceback.print_stack(); self._metadata = self.context.compiled._cached_metadata | |
| 2016-04-25 16:36:03,472 INFO [sqlalchemy.engine.base.Engine][waitress] ROLLBACK | |
| 2016-04-25 16:36:03,481 ERROR [pyramid_debugtoolbar][waitress] Exception at http://localhost:5000/favicon.ico | |
| traceback url: http://localhost:5000/_debug_toolbar/exception?token=1325882a486db59e4071&tb=139729929804496 | |
| Traceback (most recent call last): | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 192, in toolbar_tween | |
| response = _handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/panels/performance.py", line 57, in resource_timer_handler | |
| result = handler(request) | |
| File "/home/piotr/projects/kotti/kotti/filedepot.py", line 518, in __call__ | |
| response = self.handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 101, in tm_tween | |
| reraise(*exc_info) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 83, in tm_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 86, in instances | |
| util.raise_from_cause(err) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 74, in instances | |
| for row in fetch] | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 596, in polymorphic_instance | |
| return _instance(row) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 432, in _instance | |
| state.manager.dispatch.load(state, context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/event/attr.py", line 256, in __call__ | |
| fn(*args, **kw) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/mutable.py", line 451, in load | |
| val = cls.coerce(key, val) | |
| File "/home/piotr/projects/kotti/kotti/sqla.py", line 116, in coerce | |
| return Mutable.coerce(key, value) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/mutable.py", line 403, in coerce | |
| raise ValueError(msg % (key, type(value))) | |
| ValueError: Attribute '_acl' does not accept objects of type <type 'cx_Oracle.LOB'> | |
| 2016-04-25 16:36:03,483 INFO [sqlalchemy.engine.base.Engine][waitress] BEGIN (implicit) | |
| 2016-04-25 16:36:03,483 INFO [sqlalchemy.engine.base.Engine][waitress] SELECT nodes.id AS nodes_id, nodes.type AS nodes_type, nodes.parent_id AS nodes_parent_id, nodes.position AS nodes_position, nodes."_acl" AS nodes__acl, nodes.name AS nodes_name, nodes.title AS nodes_title, nodes.annotations AS nodes_annotations, nodes.path AS nodes_path | |
| FROM nodes LEFT OUTER JOIN contents ON nodes.id = contents.id LEFT OUTER JOIN documents ON contents.id = documents.id LEFT OUTER JOIN files ON contents.id = files.id LEFT OUTER JOIN images ON contents.id = images.id | |
| WHERE nodes.parent_id IS NULL | |
| 2016-04-25 16:36:03,484 INFO [sqlalchemy.engine.base.Engine][waitress] {} | |
| File "/usr/local/lib/python2.7/threading.py", line 783, in __bootstrap | |
| self.__bootstrap_inner() | |
| File "/usr/local/lib/python2.7/threading.py", line 810, in __bootstrap_inner | |
| self.run() | |
| File "/usr/local/lib/python2.7/threading.py", line 763, in run | |
| self.__target(*self.__args, **self.__kwargs) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 78, in handler_thread | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/channel.py", line 336, in service | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 169, in service | |
| self.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 388, in execute | |
| app_iter = self.channel.server.application(env, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/publisher.py", line 224, in __call__ | |
| return self.app(environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/injector.py", line 64, in __call__ | |
| response = request.get_response(self.app) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1299, in send | |
| application, catch_exc_info=False) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1263, in call_application | |
| app_iter = application(self.environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__ | |
| response = self.invoke_subrequest(request, use_tweens=True) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 218, in toolbar_tween | |
| response = request.invoke_subrequest(subrequest) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 254, in __iter__ | |
| with_session(self.session)._execute_and_instances(context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1161, in _execute_context | |
| result = context.get_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 555, in get_result_proxy | |
| result = _result.BufferedColumnResultProxy(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 495, in __init__ | |
| self._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 1239, in _init_metadata | |
| super(BufferedColumnResultProxy, self)._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 519, in _init_metadata | |
| import traceback; traceback.print_stack(); self._metadata = self.context.compiled._cached_metadata | |
| File "/usr/local/lib/python2.7/threading.py", line 783, in __bootstrap | |
| self.__bootstrap_inner() | |
| File "/usr/local/lib/python2.7/threading.py", line 810, in __bootstrap_inner | |
| self.run() | |
| File "/usr/local/lib/python2.7/threading.py", line 763, in run | |
| self.__target(*self.__args, **self.__kwargs) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 78, in handler_thread | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/channel.py", line 336, in service | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 169, in service | |
| self.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 388, in execute | |
| app_iter = self.channel.server.application(env, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/publisher.py", line 224, in __call__ | |
| return self.app(environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/injector.py", line 64, in __call__ | |
| response = request.get_response(self.app) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1299, in send | |
| application, catch_exc_info=False) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1263, in call_application | |
| app_iter = application(self.environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__ | |
| response = self.invoke_subrequest(request, use_tweens=True) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 218, in toolbar_tween | |
| response = request.invoke_subrequest(subrequest) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 254, in __iter__ | |
| with_session(self.session)._execute_and_instances(context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1161, in _execute_context | |
| result = context.get_result_proxy() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 555, in get_result_proxy | |
| result = _result.BufferedColumnResultProxy(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 495, in __init__ | |
| self._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 1239, in _init_metadata | |
| super(BufferedColumnResultProxy, self)._init_metadata() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 519, in _init_metadata | |
| import traceback; traceback.print_stack(); self._metadata = self.context.compiled._cached_metadata | |
| 2016-04-25 16:36:03,489 ERROR [waitress][waitress] Exception when serving /favicon.ico | |
| Traceback (most recent call last): | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/channel.py", line 336, in service | |
| task.service() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 169, in service | |
| self.execute() | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/waitress/task.py", line 388, in execute | |
| app_iter = self.channel.server.application(env, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/publisher.py", line 224, in __call__ | |
| return self.app(environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/fanstatic/injector.py", line 64, in __call__ | |
| response = request.get_response(self.app) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1299, in send | |
| application, catch_exc_info=False) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/webob/request.py", line 1263, in call_application | |
| app_iter = application(self.environ, start_response) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 223, in __call__ | |
| response = self.invoke_subrequest(request, use_tweens=True) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 218, in toolbar_tween | |
| response = request.invoke_subrequest(subrequest) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 198, in invoke_subrequest | |
| response = handle_request(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 86, in instances | |
| util.raise_from_cause(err) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 74, in instances | |
| for row in fetch] | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 596, in polymorphic_instance | |
| return _instance(row) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 432, in _instance | |
| state.manager.dispatch.load(state, context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/event/attr.py", line 256, in __call__ | |
| fn(*args, **kw) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/mutable.py", line 451, in load | |
| val = cls.coerce(key, val) | |
| File "/home/piotr/projects/kotti/kotti/sqla.py", line 116, in coerce | |
| return Mutable.coerce(key, value) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/mutable.py", line 403, in coerce | |
| raise ValueError(msg % (key, type(value))) | |
| ValueError: Attribute '_acl' does not accept objects of type <type 'cx_Oracle.LOB'> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2016-04-25 15:43:32,578 INFO [sqlalchemy.engine.base.Engine][waitress] ROLLBACK | |
| 2016-04-25 15:43:32,590 ERROR [pyramid_debugtoolbar][waitress] Exception at http://localhost:5000/ | |
| traceback url: http://localhost:5000/_debug_toolbar/exception?token=b2464a8eaceeacf3347d&tb=140338227505552 | |
| Traceback (most recent call last): | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 192, in toolbar_tween | |
| response = _handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_debugtoolbar/panels/performance.py", line 57, in resource_timer_handler | |
| result = handler(request) | |
| File "/home/piotr/projects/kotti/kotti/filedepot.py", line 518, in __call__ | |
| response = self.handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 101, in tm_tween | |
| reraise(*exc_info) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 83, in tm_tween | |
| response = handler(request) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/router.py", line 117, in handle_request | |
| root = root_factory(request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 805, in get_root | |
| return get_settings()['kotti.root_factory'][0](request) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 845, in __call__ | |
| return self.get_root() | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 832, in get_root | |
| return Node.query.get(self.root_id) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/pyramid/decorator.py", line 37, in __get__ | |
| val = self.wrapped(inst) | |
| File "/home/piotr/projects/kotti/kotti/resources.py", line 823, in root_id | |
| return query(DBSession()).one().id | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/baked.py", line 275, in one | |
| ret = list(self) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 86, in instances | |
| util.raise_from_cause(err) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 74, in instances | |
| for row in fetch] | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 596, in polymorphic_instance | |
| return _instance(row) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 432, in _instance | |
| state.manager.dispatch.load(state, context) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/event/attr.py", line 256, in __call__ | |
| fn(*args, **kw) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/mutable.py", line 451, in load | |
| val = cls.coerce(key, val) | |
| File "/home/piotr/projects/kotti/kotti/sqla.py", line 116, in coerce | |
| return Mutable.coerce(key, value) | |
| File "/home/piotr/.virtualenvs/kotti/lib/python2.7/site-packages/sqlalchemy/ext/mutable.py", line 403, in coerce | |
| raise ValueError(msg % (key, type(value))) | |
| ValueError: Attribute '_acl' does not accept objects of type <type 'cx_Oracle.LOB'> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment