question 500 status code received on DELETE method for API: /api/v1/clusters/mycluster in Archives of Support Questions (Read Only)

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

facundo — Sat, 11 Jun 2016 04:44:24 GMT

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.

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

rajkumar_singh — Sat, 11 Jun 2016 15:55:56 GMT

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

vpoornalingam — Mon, 13 Jun 2016 16:32:36 GMT

@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

santoshh — Tue, 14 Aug 2018 17:59:23 GMT

@Facundo Bianco Please check disk space on the master node

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

dewei123 — Tue, 12 Feb 2019 17:15:09 GMT

I managed to solve the problem

ambari-server restart