fresh (this morning) security hg pull -u: OperationalError: (OperationalError) no such column: dataset.purged - same error with a new, empty db

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

fresh (this morning) security hg pull -u: OperationalError: (OperationalError) no such column: dataset.purged - same error with a new, empty db

Ross-2
URL: http://localhost:8080/user/create
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/WebError-0.8a-py2.5.egg/weberror/evalexception/middleware.py',
line 364 in respond
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/Paste-1.5.1-py2.5.egg/paste/debug/prints.py',
line 98 in __call__
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/Paste-1.5.1-py2.5.egg/paste/wsgilib.py',
line 539 in intercept_output
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/Beaker-0.5-py2.5.egg/beaker/session.py',
line 103 in __call__
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/Paste-1.5.1-py2.5.egg/paste/recursive.py',
line 80 in __call__
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/Paste-1.5.1-py2.5.egg/paste/httpexceptions.py',
line 632 in __call__
File '/home/rossl/py/galaxy_security/lib/galaxy/web/framework/base.py',
line 125 in __call__
  body = method( trans, **kwargs )
File '/home/rossl/py/galaxy_security/lib/galaxy/web/controllers/user.py',
line 120 in create
  trans.app.security_agent.setup_new_user( user )
File '/home/rossl/py/galaxy_security/lib/galaxy/security/__init__.py',
line 42 in setup_new_user
  self.user_set_default_access( user, history = True, dataset = True )
File '/home/rossl/py/galaxy_security/lib/galaxy/security/__init__.py',
line 196 in user_set_default_access
  for history in user.active_histories:
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/orm/attributes.py',
line 44 in __get__
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/orm/attributes.py',
line 279 in get
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/orm/strategies.py',
line 466 in __call__
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/orm/query.py',
line 878 in all
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/orm/query.py',
line 938 in __iter__
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/orm/query.py',
line 941 in _execute_and_instances
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/orm/session.py',
line 628 in execute
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/engine/base.py',
line 844 in execute
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/engine/base.py',
line 895 in execute_clauseelement
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/engine/base.py',
line 907 in _execute_compiled
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/engine/base.py',
line 916 in __execute_raw
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/engine/base.py',
line 960 in _cursor_execute
File '/home/rossl/py/galaxy_security/eggs/py2.5-noplatform/SQLAlchemy-0.4.7p1-py2.5.egg/sqlalchemy/engine/base.py',
line 942 in _handle_dbapi_exception
OperationalError: (OperationalError) no such column: dataset.purged
u'SELECT history.id AS history_id, history.create_time AS
history_create_time, history.update_time AS history_update_time,
history.user_id AS history_user_id, history.name AS history_name,
history.hid_counter AS history_hid_counter, history.deleted AS
history_deleted, history.purged AS history_purged,
history.genome_build AS history_genome_build, dataset_1.id AS
dataset_1_id, dataset_1.create_time AS dataset_1_create_time,
dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS
dataset_1_state, dataset_1.deleted AS dataset_1_deleted,
dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS
dataset_1_purgable, dataset_1.external_filename AS
dataset_1_external_filename, dataset_1._extra_files_path AS
dataset_1__extra_files_path, dataset_1.file_size AS
dataset_1_file_size, history_dataset_association_1.id AS
history_dataset_association_1_id,
history_dataset_association_1.history_id AS
history_dataset_association_1_history_id,
history_dataset_association_1.dataset_id AS
history_dataset_association_1_dataset_id,
history_dataset_association_1.create_time AS
history_dataset_association_1_create_time,
history_dataset_association_1.update_time AS
history_dataset_association_1_update_time,
history_dataset_association_1.copied_from_history_dataset_association_id
AS history_dataset_association_1_copied_from_history_dataset_association_id,
history_dataset_association_1.copied_from_library_folder_dataset_association_id
AS history_dataset_association_1_copied_from_library_folder_dataset_association_id,
history_dataset_association_1.hid AS
history_dataset_association_1_hid, history_dataset_association_1.name
AS history_dataset_association_1_name,
history_dataset_association_1.info AS
history_dataset_association_1_info,
history_dataset_association_1.blurb AS
history_dataset_association_1_blurb,
history_dataset_association_1.peek AS
history_dataset_association_1_peek,
history_dataset_association_1.extension AS
history_dataset_association_1_extension,
history_dataset_association_1.metadata AS
history_dataset_association_1_metadata,
history_dataset_association_1.parent_id AS
history_dataset_association_1_parent_id,
history_dataset_association_1.designation AS
history_dataset_association_1_designation,
history_dataset_association_1.deleted AS
history_dataset_association_1_deleted,
history_dataset_association_1.visible AS
history_dataset_association_1_visible, dataset_2.id AS dataset_2_id,
dataset_2.create_time AS dataset_2_create_time, dataset_2.update_time
AS dataset_2_update_time, dataset_2.state AS dataset_2_state,
dataset_2.deleted AS dataset_2_deleted, dataset_2.purged AS
dataset_2_purged, dataset_2.purgable AS dataset_2_purgable,
dataset_2.external_filename AS dataset_2_external_filename,
dataset_2._extra_files_path AS dataset_2__extra_files_path,
dataset_2.file_size AS dataset_2_file_size,
history_dataset_association_2.id AS history_dataset_association_2_id,
history_dataset_association_2.history_id AS
history_dataset_association_2_history_id,
history_dataset_association_2.dataset_id AS
history_dataset_association_2_dataset_id,
history_dataset_association_2.create_time AS
history_dataset_association_2_create_time,
history_dataset_association_2.update_time AS
history_dataset_association_2_update_time,
history_dataset_association_2.copied_from_history_dataset_association_id
AS history_dataset_association_2_copied_from_history_dataset_association_id,
history_dataset_association_2.copied_from_library_folder_dataset_association_id
AS history_dataset_association_2_copied_from_library_folder_dataset_association_id,
history_dataset_association_2.hid AS
history_dataset_association_2_hid, history_dataset_association_2.name
AS history_dataset_association_2_name,
history_dataset_association_2.info AS
history_dataset_association_2_info,
history_dataset_association_2.blurb AS
history_dataset_association_2_blurb,
history_dataset_association_2.peek AS
history_dataset_association_2_peek,
history_dataset_association_2.extension AS
history_dataset_association_2_extension,
history_dataset_association_2.metadata AS
history_dataset_association_2_metadata,
history_dataset_association_2.parent_id AS
history_dataset_association_2_parent_id,
history_dataset_association_2.designation AS
history_dataset_association_2_designation,
history_dataset_association_2.deleted AS
history_dataset_association_2_deleted,
history_dataset_association_2.visible AS
history_dataset_association_2_visible \nFROM history LEFT OUTER JOIN
history_dataset_association AS history_dataset_association_1 ON
history_dataset_association_1.history_id = history.id AND NOT
history_dataset_association_1.deleted LEFT OUTER JOIN dataset AS
dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id
LEFT OUTER JOIN history_dataset_association AS
history_dataset_association_2 ON
history_dataset_association_2.history_id = history.id AND NOT
dataset.purged LEFT OUTER JOIN dataset AS dataset_2 ON dataset_2.id =
history_dataset_association_2.dataset_id \nWHERE history.user_id = ?
AND NOT history.deleted ORDER BY history.update_time DESC,
history_dataset_association_1.hid ASC, dataset_1.oid,
history_dataset_association_2.hid ASC, dataset_2.oid' [1]