Hi all,
I'm working under Ubuntu14.04 with devstack.
After the fresh devstack installation, I run a integration test to test the
environment.
After the test, cluster and tested edp jobs remains in my environment.
Then I updated sahara to the lasted code.
To make the newest code work, I also did :
1. manually download python-novaclient and by running "python setup.py
install" to install it
2. run "sahara-db-manage --config-file /etc/sahara/sahara.conf upgrade
head"
Then I restarted sahara.
I tried to delete things remained from last test from dashboard, but :
1. The table for "job_executions" can't be opened anymore.
2. When I try to delete "job", an error happened:
2015-03-18 10:34:33.031 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError
exception wrapped from (IntegrityError) (1451, 'Cannot delete or update a
parent row: a foreign key constraint fails (`sahara`.`job_executions`,
CONSTRAINT `job_executions_ibfk_3` FOREIGN KEY (`job_id`) REFERENCES `jobs`
(`id`))') 'DELETE FROM jobs WHERE jobs.id = %s'
('10c36a9b-a855-44b6-af60-0effee31efc9',)
2015-03-18 10:34:33.031 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most
recent call last):
2015-03-18 10:34:33.031 TRACE oslo_db.sqlalchemy.exc_filters File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951,
in _execute_context
2015-03-18 10:34:33.031 TRACE oslo_db.sqlalchemy.exc_filters context)
2015-03-18 10:34:33.031 TRACE oslo_db.sqlalchemy.exc_filters File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
436, in do_execute
2015-03-18 10:34:33.031 TRACE oslo_db.sqlalchemy.exc_filters
cursor.execute(statement, parameters)
2015-03-18 10:34:33.031 TRACE oslo_db.sqlalchemy.exc_filters File
"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2015-03-18 10:34:33.031 TRACE oslo_db.sqlalchemy.exc_filters
self.errorhandler(self, exc, value)
2015-03-18 10:34:33.031 TRACE oslo_db.sqlalchemy.exc_filters File
"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
2015-03-18 10:34:33.031 TRACE oslo_db.sqlalchemy.exc_filters raise
errorclass, errorvalue
2015-03-18 10:34:33.031 TRACE oslo_db.sqlalchemy.exc_filters IntegrityError:
(1451, 'Cannot delete or update a parent row: a foreign key constraint fails
(`sahara`.`job_executions`, CONSTRAINT `job_executions_ibfk_3` FOREIGN KEY
(`job_id`) REFERENCES `jobs` (`id`))')
2015-03-18 10:34:33.031 TRACE oslo_db.sqlalchemy.exc_filters
2015-03-18 10:34:33.073 DEBUG sahara.openstack.common.periodic_task [-] Running
periodic task SaharaPeriodicTasks.terminate_unneeded_transient_clusters from
(pid=8084) run_periodic_tasks
/opt/stack/sahara/sahara/openstack/common/periodic_task.py:219
2015-03-18 10:34:33.073 DEBUG sahara.service.periodic [-] Terminating unneeded
transient clusters from (pid=8084) terminate_unneeded_transient_clusters
/opt/stack/sahara/sahara/service/periodic.py:131
2015-03-18 10:34:33.108 ERROR sahara.utils.api [-] Validation Error occurred:
error_code=400, error_message=Job deletion failed on foreign key constraint
Error ID: e65b3fb1-b142-45a7-bc96-416efb14de84, error_name=DELETION_FAILED
I assume this might be caused by an old horizon version, so I did :
1. update horizon code.
2. python manage.py compress
3. sudo python setup.py install
4. sudo service apache2 restart
But these only make things worse.
Now, when I click "Data Processing" on dashboard, there is no return action
anymore.
Anyone can help me here ?
What I did wrong ?
How can I fix this ?
I tested sahara CLI, command like "sahara job-list" & "sahara job-delete" can
still work.
So I guess sahara is working fine.
Thanks.
-chen
__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
