> 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 > >