Support Questions
Find answers, ask questions, and share your expertise

Oozie jobs not running

Explorer

Oozie jobs are not running currently. I tried to restart mysqldb and Oozie server, upon checking in the logs found out that in Ozziee-error log

  • E0810: Job state is not [RUNNING]. Skipping ActionStart Execution, Error Code: E0810
  • An Exception occured while talking to the database: Access denied for user 'oozie'@'<host>' (using password: YES)

java.sql.SQLException: Access denied for user 'oozie'@'<host>' (using password: YES)

In Oozie Web UI I see Job is stuck in PREP status.

Can you please help?

4 REPLIES 4

Explorer

@Jay Kumar SenSharma Hey Can you please help in this?

Super Mentor

@Madhura Mhatre

Have you performed the following step on Oozie mysql DB?

# mysql -u root -p
CREATE USER '<OOZIEUSER>'@'%' IDENTIFIED BY '<OOZIEPASSWORD>';
GRANT ALL PRIVILEGES ON *.* TO '<OOZIEUSER>'@'%';
FLUSH PRIVILEGES;

.

Example:

# mysql -u root -p
Enter password: <DB_PASSWORD>


mysql> CREATE USER 'oozie'@'%' IDENTIFIED BY '<OOZIEPASSWORD>';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'oozie'@'%';
mysql> FLUSH PRIVILEGES;

Please change the <OOZIEPASSWORD> with your own Oozie user password.

Reference: https://docs.hortonworks.com/HDPDocuments/Ambari-2.7.1.0/administering-ambari/content/amb_using_oozi...

Explorer

Hi @Jay Kumar SenSharma, I already have user oozie. From command line I am able to access the db using oozie user

I am not sure suddenly oozie jobs stopped working and not running it.

Super Mentor

@Madhura Mhatre

The error indicates that the oozie user is not allowed to make the MySQL DB queries from the host mentioned in the exception. So you will need to check your MySQL DB host to see if the user "oozie' is allowed to make MySQL queries from the mentioned host (% means all). Thats why you will need to execute the previously mentioned queries on MySQL DB.

mysql> CREATE USER 'oozie'@'%' IDENTIFIED BY '<OOZIEPASSWORD>';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'oozie'@'%';
mysql> FLUSH PRIVILEGES;

.

Please change the <OOZIEPASSWORD> with your own Oozie user password.

NOTE: You will need to make sure that it matches with the password which you have defined inside the

Ambari UI --> Oozie --> Configs --> "Oozie Server" (section) --> "Database Password"  (oozie.service.JPAService.jdbc.password)

.

If you want to check the user permissions then please connect to mySQL DB and then run the following query:

# mysql -u root -p
Enter password: <MYSQL_ROOT_PASSWORD>

mysql> use mysql;
mysql> SELECT user, host FROM user;
+---------------+-------------------------+
| user          | host                    |
+---------------+-------------------------+
| oozie         | %                       |
+---------------+-------------------------+

.

; ;