[openstack-dev] [Sahara][Horizon] Can't open "Data Processing" panel after update sahara & horizon
chen.li at intel.com
Thu Mar 19 01:34:11 UTC 2015
Thanks all for the help.
I get help from IRC, and now I have solved my issues:
1. The reason after I update horizon and the "Data Processing" panel do not work is because I missed a step for horizon to work.
The correct step to update horizon is:
a. git pull origin master (update horizon code)
b. python manage.py collectstatic
c. python manage.py compress
d. sudo service apache2 restart
2. I can't open "job_executions" page is due to bug: https://bugs.launchpad.net/horizon/+bug/1376738
It can be solved by patch https://review.openstack.org/#/c/125927/
3. I can't delete "job" is because a job can only be deleted after all related "job_executions" deleted.
From: Li, Chen [mailto:chen.li at intel.com]
Sent: Wednesday, March 18, 2015 11:05 AM
To: OpenStack Development Mailing List (not for usage questions) (openstack-dev at lists.openstack.org)
Subject: [openstack-dev] [Sahara][Horizon] Can't open "Data Processing" panel after update sahara & horizon
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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the OpenStack-dev