Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

500 status code received on DELETE method for API: /api/v1/clusters/mycluster

Solved Go to solution
Highlighted

500 status code received on DELETE method for API: /api/v1/clusters/mycluster

Contributor

In "Cluster install wizard", "Review" step, when I hit "Deploy" button I get the error message

500 status codereceived on DELETE method for API: /api/v1/clusters/mycluster
Error message: Server error

The ambari-server log is

10 Jun 2016 18:31:19,317 ERROR [pool-3-thread-1] AmbariJpaLocalTxnInterceptor:180 - [DETAILED ERROR] Rollback reason: 
Local Exception Stack: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: DELETE command denied to user 'ambari'@'localhost' for table 'alert_notice'
Error Code: 1142
Call: DELETE FROM alert_notice WHERE (history_id IN (?))
        bind => [1 parameter bound]
Query: DeleteAllQuery(name="AlertNoticeEntity.removeByHistoryIds" referenceClass=AlertNoticeEntity sql="DELETE FROM alert_notice WHERE (history_id IN ?)")

And the ambari user privileges on MySQL

+--------------+--------+-------------------------------------------+------------+------------+
| host         | user   | password                                  | Grant_priv | Super_priv |
+--------------+--------+-------------------------------------------+------------+------------+
| localhost    | ambari | *AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA | Y          | Y          |
| 192.168.1.2  | ambari | *AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA | Y          | Y          |
| 127.0.0.1    | ambari | *AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA | Y          | Y          |
+--------------+--------+-------------------------------------------+------------+------------+

Also, ambari user has granted privileges on `ambari.*`.

I running ambari-server (2.2.2.0) on Debian 7.11 (Wheezy), and MySQL server version is 5.5.49. Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: 500 status code received on DELETE method for API: /api/v1/clusters/mycluster

seems you dont have delete on alert_notice table can you check it with mysql

in mysql prompt

use information_schema

select * from TABLE_PRIVILEGES;

4 REPLIES 4

Re: 500 status code received on DELETE method for API: /api/v1/clusters/mycluster

seems you dont have delete on alert_notice table can you check it with mysql

in mysql prompt

use information_schema

select * from TABLE_PRIVILEGES;

Re: 500 status code received on DELETE method for API: /api/v1/clusters/mycluster

@Facundo Bianco

Is it a fresh installation of the cluster? It's strange that in a fresh cluster installation, there are entries in alert_notice table.

What is observed when you do a select * from alert_notice ? how many rows are returned? Please backup the database using mysql dump and then try to remove a row from this table to check the privileges [without committing]

Re: 500 status code received on DELETE method for API: /api/v1/clusters/mycluster

New Contributor

@Facundo Bianco Please check disk space on the master node

Re: 500 status code received on DELETE method for API: /api/v1/clusters/mycluster

New Contributor
  • I managed to solve the problem

ambari-server restart

,
Don't have an account?
Coming from Hortonworks? Activate your account here