You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by Qiang Zhang <zh...@zte.com.cn> on 2017/02/13 07:18:39 UTC
Review Request 56588: There is Page not found (404) error when
clicking Admin tab in Audit.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56588/
-----------------------------------------------------------
Review request for ranger, Alok Lal, Don Bosco Durai, Colm O hEigeartaigh, Ramesh Mani, Selvamohan Neethiraj, and Velmurugan Periasamy.
Bugs: RANGER-1378
https://issues.apache.org/jira/browse/RANGER-1378
Repository: ranger
Description
-------
There is Page not found (404) error when clicking Admin tab in Audit.
Wrong reason: There is no vx_trx_log table in ranger database.
Diffs
-----
security-admin/src/main/java/org/apache/ranger/entity/view/VXXTrxLog.java 28d6f03
Diff: https://reviews.apache.org/r/56588/diff/
Testing
-------
Thanks,
Qiang Zhang
Re: Review Request 56588: There is Page not found (404) error when
clicking Admin tab in Audit.
Posted by Pradeep Agrawal <pr...@freestoneinfotech.com>.
> On Feb. 14, 2017, 10:55 a.m., Velmurugan Periasamy wrote:
> > security-admin/src/main/java/org/apache/ranger/entity/view/VXXTrxLog.java, line 40
> > <https://reviews.apache.org/r/56588/diff/1/?file=1631694#file1631694line40>
> >
> > This is not required. View vx_trx_log should exist. My suggestion is to investigate the root cause. This change may not be required.
>
> Qiang Zhang wrote:
> Ok. I will further analyze the problem.
@zhangqiang2 : Please provide MySQL version.
- Pradeep
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56588/#review165487
-----------------------------------------------------------
On Feb. 13, 2017, 10:51 a.m., Qiang Zhang wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/56588/
> -----------------------------------------------------------
>
> (Updated Feb. 13, 2017, 10:51 a.m.)
>
>
> Review request for ranger, Alok Lal, Don Bosco Durai, Colm O hEigeartaigh, Ramesh Mani, Selvamohan Neethiraj, and Velmurugan Periasamy.
>
>
> Bugs: RANGER-1378
> https://issues.apache.org/jira/browse/RANGER-1378
>
>
> Repository: ranger
>
>
> Description
> -------
>
> There is Page not found (404) error when clicking Admin tab in Audit.
> Wrong reason: There is no vx_trx_log table in ranger database.
>
> Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ranger.x_trx_log.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
> Error Code: 1055
> Call: SELECT ID AS a1, ACTION AS a2, ADDED_BY_ID AS a3, ATTR_NAME AS a4, CREATE_TIME AS a5, NEW_VAL AS a6, CLASS_TYPE AS a7, OBJECT_ID AS a8, OBJECT_NAME AS a9, PARENT_OBJECT_CLASS_TYPE AS a10, PARENT_OBJECT_ID AS a11, PARENT_OBJECT_NAME AS a12, PREV_VAL AS a13, REQ_ID AS a14, SESS_ID AS a15, SESS_TYPE AS a16, TRX_ID AS a17, UPDATE_TIME AS a18, UPD_BY_ID AS a19 FROM vx_trx_log ORDER BY CREATE_TIME DESC LIMIT ?, ?
> bind => [2 parameters bound]
> Query: ReadAllQuery(referenceClass=VXXTrxLog sql="SELECT ID AS a1, ACTION AS a2, ADDED_BY_ID AS a3, ATTR_NAME AS a4, CREATE_TIME AS a5, NEW_VAL AS a6, CLASS_TYPE AS a7, OBJECT_ID AS a8, OBJECT_NAME AS a9, PARENT_OBJECT_CLASS_TYPE AS a10, PARENT_OBJECT_ID AS a11, PARENT_OBJECT_NAME AS a12, PREV_VAL AS a13, REQ_ID AS a14, SESS_ID AS a15, SESS_TYPE AS a16, TRX_ID AS a17, UPDATE_TIME AS a18, UPD_BY_ID AS a19 FROM vx_trx_log ORDER BY CREATE_TIME DESC LIMIT ?, ?")
>
>
> Diffs
> -----
>
> security-admin/src/main/java/org/apache/ranger/entity/view/VXXTrxLog.java 28d6f03
>
> Diff: https://reviews.apache.org/r/56588/diff/
>
>
> Testing
> -------
>
>
> Thanks,
>
> Qiang Zhang
>
>
Re: Review Request 56588: There is Page not found (404) error when
clicking Admin tab in Audit.
Posted by Qiang Zhang <zh...@zte.com.cn>.
> On \u4e8c\u6708 14, 2017, 10:55 a.m., Velmurugan Periasamy wrote:
> > security-admin/src/main/java/org/apache/ranger/entity/view/VXXTrxLog.java, line 40
> > <https://reviews.apache.org/r/56588/diff/1/?file=1631694#file1631694line40>
> >
> > This is not required. View vx_trx_log should exist. My suggestion is to investigate the root cause. This change may not be required.
Ok. I will further analyze the problem.
- Qiang
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56588/#review165487
-----------------------------------------------------------
On \u4e8c\u6708 13, 2017, 10:51 a.m., Qiang Zhang wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/56588/
> -----------------------------------------------------------
>
> (Updated \u4e8c\u6708 13, 2017, 10:51 a.m.)
>
>
> Review request for ranger, Alok Lal, Don Bosco Durai, Colm O hEigeartaigh, Ramesh Mani, Selvamohan Neethiraj, and Velmurugan Periasamy.
>
>
> Bugs: RANGER-1378
> https://issues.apache.org/jira/browse/RANGER-1378
>
>
> Repository: ranger
>
>
> Description
> -------
>
> There is Page not found (404) error when clicking Admin tab in Audit.
> Wrong reason: There is no vx_trx_log table in ranger database.
>
> Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ranger.x_trx_log.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
> Error Code: 1055
> Call: SELECT ID AS a1, ACTION AS a2, ADDED_BY_ID AS a3, ATTR_NAME AS a4, CREATE_TIME AS a5, NEW_VAL AS a6, CLASS_TYPE AS a7, OBJECT_ID AS a8, OBJECT_NAME AS a9, PARENT_OBJECT_CLASS_TYPE AS a10, PARENT_OBJECT_ID AS a11, PARENT_OBJECT_NAME AS a12, PREV_VAL AS a13, REQ_ID AS a14, SESS_ID AS a15, SESS_TYPE AS a16, TRX_ID AS a17, UPDATE_TIME AS a18, UPD_BY_ID AS a19 FROM vx_trx_log ORDER BY CREATE_TIME DESC LIMIT ?, ?
> bind => [2 parameters bound]
> Query: ReadAllQuery(referenceClass=VXXTrxLog sql="SELECT ID AS a1, ACTION AS a2, ADDED_BY_ID AS a3, ATTR_NAME AS a4, CREATE_TIME AS a5, NEW_VAL AS a6, CLASS_TYPE AS a7, OBJECT_ID AS a8, OBJECT_NAME AS a9, PARENT_OBJECT_CLASS_TYPE AS a10, PARENT_OBJECT_ID AS a11, PARENT_OBJECT_NAME AS a12, PREV_VAL AS a13, REQ_ID AS a14, SESS_ID AS a15, SESS_TYPE AS a16, TRX_ID AS a17, UPDATE_TIME AS a18, UPD_BY_ID AS a19 FROM vx_trx_log ORDER BY CREATE_TIME DESC LIMIT ?, ?")
>
>
> Diffs
> -----
>
> security-admin/src/main/java/org/apache/ranger/entity/view/VXXTrxLog.java 28d6f03
>
> Diff: https://reviews.apache.org/r/56588/diff/
>
>
> Testing
> -------
>
>
> Thanks,
>
> Qiang Zhang
>
>
Re: Review Request 56588: There is Page not found (404) error when
clicking Admin tab in Audit.
Posted by Qiang Zhang <zh...@zte.com.cn>.
> On \u4e8c\u6708 14, 2017, 10:55 a.m., Velmurugan Periasamy wrote:
> > security-admin/src/main/java/org/apache/ranger/entity/view/VXXTrxLog.java, line 40
> > <https://reviews.apache.org/r/56588/diff/1/?file=1631694#file1631694line40>
> >
> > This is not required. View vx_trx_log should exist. My suggestion is to investigate the root cause. This change may not be required.
>
> Qiang Zhang wrote:
> Ok. I will further analyze the problem.
>
> Pradeep Agrawal wrote:
> @zhangqiang2 : Please provide MySQL version.
MySQL version: Ver 14.14 Distrib 5.7.17, for Linux (x86_64).
You checkout the latest source code from https://git-wip-us.apache.org/repos/asf/ranger.git. The question will be repeated when you click Admin tab in Audit after compiling and installing ranger accroding to normal steps.
- Qiang
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56588/#review165487
-----------------------------------------------------------
On \u4e8c\u6708 13, 2017, 10:51 a.m., Qiang Zhang wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/56588/
> -----------------------------------------------------------
>
> (Updated \u4e8c\u6708 13, 2017, 10:51 a.m.)
>
>
> Review request for ranger, Alok Lal, Don Bosco Durai, Colm O hEigeartaigh, Ramesh Mani, Selvamohan Neethiraj, and Velmurugan Periasamy.
>
>
> Bugs: RANGER-1378
> https://issues.apache.org/jira/browse/RANGER-1378
>
>
> Repository: ranger
>
>
> Description
> -------
>
> There is Page not found (404) error when clicking Admin tab in Audit.
> Wrong reason: There is no vx_trx_log table in ranger database.
>
> Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ranger.x_trx_log.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
> Error Code: 1055
> Call: SELECT ID AS a1, ACTION AS a2, ADDED_BY_ID AS a3, ATTR_NAME AS a4, CREATE_TIME AS a5, NEW_VAL AS a6, CLASS_TYPE AS a7, OBJECT_ID AS a8, OBJECT_NAME AS a9, PARENT_OBJECT_CLASS_TYPE AS a10, PARENT_OBJECT_ID AS a11, PARENT_OBJECT_NAME AS a12, PREV_VAL AS a13, REQ_ID AS a14, SESS_ID AS a15, SESS_TYPE AS a16, TRX_ID AS a17, UPDATE_TIME AS a18, UPD_BY_ID AS a19 FROM vx_trx_log ORDER BY CREATE_TIME DESC LIMIT ?, ?
> bind => [2 parameters bound]
> Query: ReadAllQuery(referenceClass=VXXTrxLog sql="SELECT ID AS a1, ACTION AS a2, ADDED_BY_ID AS a3, ATTR_NAME AS a4, CREATE_TIME AS a5, NEW_VAL AS a6, CLASS_TYPE AS a7, OBJECT_ID AS a8, OBJECT_NAME AS a9, PARENT_OBJECT_CLASS_TYPE AS a10, PARENT_OBJECT_ID AS a11, PARENT_OBJECT_NAME AS a12, PREV_VAL AS a13, REQ_ID AS a14, SESS_ID AS a15, SESS_TYPE AS a16, TRX_ID AS a17, UPDATE_TIME AS a18, UPD_BY_ID AS a19 FROM vx_trx_log ORDER BY CREATE_TIME DESC LIMIT ?, ?")
>
>
> Diffs
> -----
>
> security-admin/src/main/java/org/apache/ranger/entity/view/VXXTrxLog.java 28d6f03
>
> Diff: https://reviews.apache.org/r/56588/diff/
>
>
> Testing
> -------
>
>
> Thanks,
>
> Qiang Zhang
>
>
Re: Review Request 56588: There is Page not found (404) error when
clicking Admin tab in Audit.
Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56588/#review165487
-----------------------------------------------------------
security-admin/src/main/java/org/apache/ranger/entity/view/VXXTrxLog.java (line 40)
<https://reviews.apache.org/r/56588/#comment237334>
This is not required. View vx_trx_log should exist. My suggestion is to investigate the root cause. This change may not be required.
- Velmurugan Periasamy
On Feb. 13, 2017, 10:51 a.m., Qiang Zhang wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/56588/
> -----------------------------------------------------------
>
> (Updated Feb. 13, 2017, 10:51 a.m.)
>
>
> Review request for ranger, Alok Lal, Don Bosco Durai, Colm O hEigeartaigh, Ramesh Mani, Selvamohan Neethiraj, and Velmurugan Periasamy.
>
>
> Bugs: RANGER-1378
> https://issues.apache.org/jira/browse/RANGER-1378
>
>
> Repository: ranger
>
>
> Description
> -------
>
> There is Page not found (404) error when clicking Admin tab in Audit.
> Wrong reason: There is no vx_trx_log table in ranger database.
>
> Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ranger.x_trx_log.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
> Error Code: 1055
> Call: SELECT ID AS a1, ACTION AS a2, ADDED_BY_ID AS a3, ATTR_NAME AS a4, CREATE_TIME AS a5, NEW_VAL AS a6, CLASS_TYPE AS a7, OBJECT_ID AS a8, OBJECT_NAME AS a9, PARENT_OBJECT_CLASS_TYPE AS a10, PARENT_OBJECT_ID AS a11, PARENT_OBJECT_NAME AS a12, PREV_VAL AS a13, REQ_ID AS a14, SESS_ID AS a15, SESS_TYPE AS a16, TRX_ID AS a17, UPDATE_TIME AS a18, UPD_BY_ID AS a19 FROM vx_trx_log ORDER BY CREATE_TIME DESC LIMIT ?, ?
> bind => [2 parameters bound]
> Query: ReadAllQuery(referenceClass=VXXTrxLog sql="SELECT ID AS a1, ACTION AS a2, ADDED_BY_ID AS a3, ATTR_NAME AS a4, CREATE_TIME AS a5, NEW_VAL AS a6, CLASS_TYPE AS a7, OBJECT_ID AS a8, OBJECT_NAME AS a9, PARENT_OBJECT_CLASS_TYPE AS a10, PARENT_OBJECT_ID AS a11, PARENT_OBJECT_NAME AS a12, PREV_VAL AS a13, REQ_ID AS a14, SESS_ID AS a15, SESS_TYPE AS a16, TRX_ID AS a17, UPDATE_TIME AS a18, UPD_BY_ID AS a19 FROM vx_trx_log ORDER BY CREATE_TIME DESC LIMIT ?, ?")
>
>
> Diffs
> -----
>
> security-admin/src/main/java/org/apache/ranger/entity/view/VXXTrxLog.java 28d6f03
>
> Diff: https://reviews.apache.org/r/56588/diff/
>
>
> Testing
> -------
>
>
> Thanks,
>
> Qiang Zhang
>
>
Re: Review Request 56588: There is Page not found (404) error when
clicking Admin tab in Audit.
Posted by Qiang Zhang <zh...@zte.com.cn>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56588/
-----------------------------------------------------------
(Updated \u4e8c\u6708 13, 2017, 10:51 a.m.)
Review request for ranger, Alok Lal, Don Bosco Durai, Colm O hEigeartaigh, Ramesh Mani, Selvamohan Neethiraj, and Velmurugan Periasamy.
Bugs: RANGER-1378
https://issues.apache.org/jira/browse/RANGER-1378
Repository: ranger
Description (updated)
-------
There is Page not found (404) error when clicking Admin tab in Audit.
Wrong reason: There is no vx_trx_log table in ranger database.
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ranger.x_trx_log.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Error Code: 1055
Call: SELECT ID AS a1, ACTION AS a2, ADDED_BY_ID AS a3, ATTR_NAME AS a4, CREATE_TIME AS a5, NEW_VAL AS a6, CLASS_TYPE AS a7, OBJECT_ID AS a8, OBJECT_NAME AS a9, PARENT_OBJECT_CLASS_TYPE AS a10, PARENT_OBJECT_ID AS a11, PARENT_OBJECT_NAME AS a12, PREV_VAL AS a13, REQ_ID AS a14, SESS_ID AS a15, SESS_TYPE AS a16, TRX_ID AS a17, UPDATE_TIME AS a18, UPD_BY_ID AS a19 FROM vx_trx_log ORDER BY CREATE_TIME DESC LIMIT ?, ?
bind => [2 parameters bound]
Query: ReadAllQuery(referenceClass=VXXTrxLog sql="SELECT ID AS a1, ACTION AS a2, ADDED_BY_ID AS a3, ATTR_NAME AS a4, CREATE_TIME AS a5, NEW_VAL AS a6, CLASS_TYPE AS a7, OBJECT_ID AS a8, OBJECT_NAME AS a9, PARENT_OBJECT_CLASS_TYPE AS a10, PARENT_OBJECT_ID AS a11, PARENT_OBJECT_NAME AS a12, PREV_VAL AS a13, REQ_ID AS a14, SESS_ID AS a15, SESS_TYPE AS a16, TRX_ID AS a17, UPDATE_TIME AS a18, UPD_BY_ID AS a19 FROM vx_trx_log ORDER BY CREATE_TIME DESC LIMIT ?, ?")
Diffs
-----
security-admin/src/main/java/org/apache/ranger/entity/view/VXXTrxLog.java 28d6f03
Diff: https://reviews.apache.org/r/56588/diff/
Testing
-------
Thanks,
Qiang Zhang