You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by Fatima Khan <fa...@gmail.com> on 2018/08/10 13:22:13 UTC
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
Re: Review Request 68293: RANGER-2114 : Internal Exception:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
column 'content' at row 1
Posted by Gautam Borad <gb...@gmail.com>.
-----------------------------------------------------------
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
Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
-----------------------------------------------------------
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
>
>
Re: Review Request 68293: RANGER-2114 : Internal Exception:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
column 'content' at row 1
Posted by bhavik patel <bh...@gmail.com>.
-----------------------------------------------------------
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
Posted by Fatima Khan <fa...@gmail.com>.
> 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
Posted by bhavik patel <bh...@gmail.com>.
-----------------------------------------------------------
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
>
>