Ask Your Question
0

Sahara can not access its tables in MySQL database

asked 2015-03-20 22:32:20 -0600

sahara201503 gravatar image

updated 2015-03-21 22:11:22 -0600

SamYaple gravatar image

Environment:

OpenStack icehouse + Sahara

OS: CentOS 6.5

DB: MySQL

Problem: Click on Sahara from the OpenStack Dashboard which prompts sahara database queries, and the following type of error occurs:

2015-03-21 06:30:21.301 16633 TRACE sahara.openstack.common.periodic_task OperationalError: (OperationalError) no such table: job_executions u'SELECT job_executions.created_at AS job_executions_created_at, job_executions.updated_at AS job_executions_updated_at, job_executions.id AS job_executions_id, job_executions.tenant_id AS job_executions_tenant_id, job_executions.job_id AS job_executions_job_id, job_executions.input_id AS job_executions_input_id, job_executions.output_id AS job_executions_output_id, job_executions.start_time AS job_executions_start_time, job_executions.end_time AS job_executions_end_time, job_executions.cluster_id AS job_executions_cluster_id, job_executions.info AS job_executions_info, job_executions.progress AS job_executions_progress, job_executions.oozie_job_id AS job_executions_oozie_job_id, job_executions.return_code AS job_executions_return_code, job_executions.job_configs AS job_executions_job_configs, job_executions.extra AS job_executions_extra \nFROM job_executions \nWHERE job_executions.end_time IS NULL' ()

Database Config:

 "sahara-db-manage --config-file sahara/etc/sahara/sahara.conf upgrade head"  was a SUCCESS, using database connection = mysql://root:@127.0.0.1:3306/sahara.

The tables are clearly there as well ...

mysql> show tables;
+----------------------+
| Tables_in_sahara     |
+----------------------+
| alembic_version      |
| cluster_templates    |
| clusters             |
| data_sources         |
| instances            |
| job_binaries         |
| job_binary_internal  |
| job_executions       |
| jobs                 |
| libs_association     |
| mains_association    |
| node_group_templates |
| node_groups          |
| templates_relations  |
+----------------------+
14 rows in set (0.00 sec)
mysql>

WOULD GREATLY APPRECIATE ANY ADVICE

edit retag flag offensive close merge delete

Comments

Just check the tables job_executions is populated with the needed details and make sure that the mysql entry in the sahara.conf is correct. And if again the issue persist. Make sure the settings in the sahara.conf are correct, then drop / recreate the mysql database and try again.

rahulrajvn gravatar imagerahulrajvn ( 2015-03-23 09:04:43 -0600 )edit

1 answer

Sort by ยป oldest newest most voted
0

answered 2015-03-23 12:40:07 -0600

sahara201503 gravatar image

Thanks rahulrajvn. Turns out my sahara.conf file is not at the default / expected sahara location: /etc/sahara/sahara.conf.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

Stats

Asked: 2015-03-20 22:32:20 -0600

Seen: 99 times

Last updated: Mar 21 '15