Re: Review Request 68293: RANGER-2114 : Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at row 1
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/68293/#review207230 --- Ship it! Ship It! - Gautam Borad On Aug. 10, 2018, 1:22 p.m., Fatima Khan wrote: > > --- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/68293/ > --- > > (Updated Aug. 10, 2018, 1:22 p.m.) > > > Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay > Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, > Sailaja Polavarapu, and Velmurugan Periasamy. > > > Bugs: RANGER-2114 > https://issues.apache.org/jira/browse/RANGER-2114 > > > Repository: ranger > > > Description > --- > > An attempt to delete a service definition ends with: > > // Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: > Data too long for column 'content' at row 1 > Error Code: 1406 > Call: INSERT INTO x_data_hist (action, content, CREATE_TIME, from_time, > obj_class_type, obj_guid, obj_id, obj_name, to_time, UPDATE_TIME, version) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > bind = [11 parameters bound] > > > Diffs > - > > security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 9d200ba > security-admin/db/mysql/patches/034-x_data_histContentSize.sql PRE-CREATION > > > Diff: https://reviews.apache.org/r/68293/diff/1/ > > > Testing > --- > > Tested the following > 1.In fresh install and upgrade scenario. > 2.Checked the data type of x_data_hist is changed from text to mediumtext. > > > Thanks, > > Fatima Khan > >
Re: Review Request 68293: RANGER-2114 : Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at row 1
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/68293/#review207149 --- Ship it! Ship It! - bhavik patel On Aug. 10, 2018, 1:22 p.m., Fatima Khan wrote: > > --- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/68293/ > --- > > (Updated Aug. 10, 2018, 1:22 p.m.) > > > Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay > Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, > Sailaja Polavarapu, and Velmurugan Periasamy. > > > Bugs: RANGER-2114 > https://issues.apache.org/jira/browse/RANGER-2114 > > > Repository: ranger > > > Description > --- > > An attempt to delete a service definition ends with: > > // Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: > Data too long for column 'content' at row 1 > Error Code: 1406 > Call: INSERT INTO x_data_hist (action, content, CREATE_TIME, from_time, > obj_class_type, obj_guid, obj_id, obj_name, to_time, UPDATE_TIME, version) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > bind = [11 parameters bound] > > > Diffs > - > > security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 9d200ba > security-admin/db/mysql/patches/034-x_data_histContentSize.sql PRE-CREATION > > > Diff: https://reviews.apache.org/r/68293/diff/1/ > > > Testing > --- > > Tested the following > 1.In fresh install and upgrade scenario. > 2.Checked the data type of x_data_hist is changed from text to mediumtext. > > > Thanks, > > Fatima Khan > >
Re: Review Request 68293: RANGER-2114 : Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at row 1
> On Aug. 11, 2018, 5:20 a.m., bhavik patel wrote: > > @fatima : I think similar changes also required for postgres database. @Bhavik Data type MEDIUMTEXT of mysql is equivalent to Text data type of postgress. Currently in postgress we use Text data type for content column in x_data_hist table. - Fatima --- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/68293/#review207108 --- On Aug. 10, 2018, 1:22 p.m., Fatima Khan wrote: > > --- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/68293/ > --- > > (Updated Aug. 10, 2018, 1:22 p.m.) > > > Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay > Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, > Sailaja Polavarapu, and Velmurugan Periasamy. > > > Bugs: RANGER-2114 > https://issues.apache.org/jira/browse/RANGER-2114 > > > Repository: ranger > > > Description > --- > > An attempt to delete a service definition ends with: > > // Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: > Data too long for column 'content' at row 1 > Error Code: 1406 > Call: INSERT INTO x_data_hist (action, content, CREATE_TIME, from_time, > obj_class_type, obj_guid, obj_id, obj_name, to_time, UPDATE_TIME, version) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > bind = [11 parameters bound] > > > Diffs > - > > security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 9d200ba > security-admin/db/mysql/patches/034-x_data_histContentSize.sql PRE-CREATION > > > Diff: https://reviews.apache.org/r/68293/diff/1/ > > > Testing > --- > > Tested the following > 1.In fresh install and upgrade scenario. > 2.Checked the data type of x_data_hist is changed from text to mediumtext. > > > Thanks, > > Fatima Khan > >
Re: Review Request 68293: RANGER-2114 : Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at row 1
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/68293/#review207108 --- @fatima : I think similar changes also required for postgres database. - bhavik patel On Aug. 10, 2018, 1:22 p.m., Fatima Khan wrote: > > --- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/68293/ > --- > > (Updated Aug. 10, 2018, 1:22 p.m.) > > > Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay > Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, > Sailaja Polavarapu, and Velmurugan Periasamy. > > > Bugs: RANGER-2114 > https://issues.apache.org/jira/browse/RANGER-2114 > > > Repository: ranger > > > Description > --- > > An attempt to delete a service definition ends with: > > // Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: > Data too long for column 'content' at row 1 > Error Code: 1406 > Call: INSERT INTO x_data_hist (action, content, CREATE_TIME, from_time, > obj_class_type, obj_guid, obj_id, obj_name, to_time, UPDATE_TIME, version) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > bind = [11 parameters bound] > > > Diffs > - > > security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 9d200ba > security-admin/db/mysql/patches/034-x_data_histContentSize.sql PRE-CREATION > > > Diff: https://reviews.apache.org/r/68293/diff/1/ > > > Testing > --- > > Tested the following > 1.In fresh install and upgrade scenario. > 2.Checked the data type of x_data_hist is changed from text to mediumtext. > > > Thanks, > > Fatima Khan > >
Re: Review Request 68293: RANGER-2114 : Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at row 1
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/68293/#review207105 --- Ship it! Ship It! - Velmurugan Periasamy On Aug. 10, 2018, 1:22 p.m., Fatima Khan wrote: > > --- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/68293/ > --- > > (Updated Aug. 10, 2018, 1:22 p.m.) > > > Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay > Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, > Sailaja Polavarapu, and Velmurugan Periasamy. > > > Bugs: RANGER-2114 > https://issues.apache.org/jira/browse/RANGER-2114 > > > Repository: ranger > > > Description > --- > > An attempt to delete a service definition ends with: > > // Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: > Data too long for column 'content' at row 1 > Error Code: 1406 > Call: INSERT INTO x_data_hist (action, content, CREATE_TIME, from_time, > obj_class_type, obj_guid, obj_id, obj_name, to_time, UPDATE_TIME, version) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > bind = [11 parameters bound] > > > Diffs > - > > security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 9d200ba > security-admin/db/mysql/patches/034-x_data_histContentSize.sql PRE-CREATION > > > Diff: https://reviews.apache.org/r/68293/diff/1/ > > > Testing > --- > > Tested the following > 1.In fresh install and upgrade scenario. > 2.Checked the data type of x_data_hist is changed from text to mediumtext. > > > Thanks, > > Fatima Khan > >
Review Request 68293: RANGER-2114 : Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at row 1
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/68293/ --- Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, Sailaja Polavarapu, and Velmurugan Periasamy. Bugs: RANGER-2114 https://issues.apache.org/jira/browse/RANGER-2114 Repository: ranger Description --- An attempt to delete a service definition ends with: // Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at row 1 Error Code: 1406 Call: INSERT INTO x_data_hist (action, content, CREATE_TIME, from_time, obj_class_type, obj_guid, obj_id, obj_name, to_time, UPDATE_TIME, version) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind = [11 parameters bound] Diffs - security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 9d200ba security-admin/db/mysql/patches/034-x_data_histContentSize.sql PRE-CREATION Diff: https://reviews.apache.org/r/68293/diff/1/ Testing --- Tested the following 1.In fresh install and upgrade scenario. 2.Checked the data type of x_data_hist is changed from text to mediumtext. Thanks, Fatima Khan