[MCOL-1785] ERROR 1030 (HY000): Got error -1 "Internal error < 0 (Not system error)" from storage engine Columnstore Created: 2018-10-09 Updated: 2021-01-15 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | None |
| Affects Version/s: | 1.1.6 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | thomas lloancy | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
I got this error with a "insert into clone_columnstore_table from innodb_model_table"
-------------------------------
------------------------------- |
| Comments |
| Comment by David Thompson (Inactive) [ 2018-10-10 ] |
|
Can you exec into the container and check the logs under /var/log/mariadb/columnstore and see what is reported. Start at err.log and then go down to debug.log which has the most info. The logs will usually have a more descriptive error as in some cases we can't surface the more specific error due to the way this is implemented. For a real workload server you might want to map that dir to a volume so you preserve logs across container restarts. |
| Comment by thomas lloancy [ 2018-10-10 ] |
|
Here is the content of err.log Oct 10 09:33:49 bfa8440cfce4 cpimport.bin[107674]: 49.773186 |0|0|0| E 34 CAL0087: BulkLoad Error: Actual error row count(1) exceeds the max error rows(0) allowed for table db_name.table_name |
| Comment by Andrew Hutchings (Inactive) [ 2018-10-10 ] |
|
This looks like the kind of error we would see if there is UTF-8 or non-latin1 characters in the data. Is this possible in your case? |
| Comment by thomas lloancy [ 2018-10-10 ] |
|
By the way i dont know how to put europe timezone into this container since nor dpkg-reconfigure neither apt update seems to be available. (logs are two hours early). |
| Comment by thomas lloancy [ 2018-10-10 ] |
|
original is ENGINE=InnoDB DEFAULT_CHARSET=utf8 ROW_FORMAT=REDUNDANT target is Engine=ColumnStore DEFAULT_CHARSET=utf8 and ROW_FORMAT was deleted because it's not supported. I deleted a lot of keys but if special characters are present it is by mistake. |
| Comment by thomas lloancy [ 2018-10-10 ] |
|
For memories: CREATE TABLE `ma_table` ( `ma_table_id` int(11) NOT NULL, `label` text NOT NULL ) ENGINE=ColumnStore DEFAULT CHARSET=utf8; MariaDB [target]> insert into ma_table select * from source.ma_table; drop table ma_table. insert into ma_table select * from source.ma_table; |
| Comment by thomas lloancy [ 2018-10-10 ] |
|
One more exemple: MariaDB [target]> CREATE TABLE `ma_table` ( MariaDB [target]> insert into ma_table select a,b,c,d,e,f,g,h,i,j,k,l,m from source.ma_table; MariaDB [target]> CREATE TABLE `ma_table` ( MariaDB [target]> insert into ma_table select a,b,c,d,e,f,g,h,i,j,k from source.ma_table; So if a columns is a problem (text empty or special char) i must drop it ? |
| Comment by Andrew Hutchings (Inactive) [ 2018-10-10 ] |
|
so, to be clear. The original problem you are reporting is that you have two extra TEXT based columns on the destination table? |
| Comment by thomas lloancy [ 2018-10-10 ] |
|
But i don't understand why it is a problem. |
| Comment by Andrew Hutchings (Inactive) [ 2018-10-11 ] |
|
do you have test data and source/destination schemas you can provide us to reproduce the problem? |