Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Sahara: Error database when reboot server

Hi,

I have installed Sahara in Openstack Icehouse. It's worked!

But if reboot server Openstack. When i run sahara-api, received error messages:

ERROR sahara.openstack.common.periodic_task [-] Error during SaharaPeriodicTasks.update_job_statuses: (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' ()

In sahara.conf, i set:

[database]
connection=sqlite:////tmp/sahara.db

However, if i delete old /tmp/sahara.db and run "sahara-venv/bin/sahara-db-manage --config-file sahara-venv/etc/sahara.conf upgrade head". Then start sahara-api, sahara can continue to work.

Can you help me fix it? Thank you very much!