Details
-
Type:
Bug
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.0.17
-
Fix Version/s: 10.0
-
Component/s: Storage Engine - Connect
-
Labels:
Description
Compressed files caused an unhandled error.
# echo 1,test1 > test.tsv # echo 2,test2 >> test.tsv # gzip test.tsv
CREATE TABLE test ( c1 VARCHAR(100) NOT NULL field_format='%n%[^,]%n', c2 VARCHAR(100) NOT NULL field_format=',%n%s%n' ) ENGINE=CONNECT table_type=FMT COMPRESS=1 file_name='test.tsv.gz'; Select * from test;
Got error 122 "Internal (unspecified) error in handler" from storage engine CONNECT
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
What do you mean "same result"? Mine or yours?
I tried again, this time on a different box running CentOS6 (CentOS release 6.6 (Final)), and it worked!!!!
So, the problem seems to be with CentOS 7 (CentOS Linux release 7.1.1503 (Core)).
I'll keep digging...
Thanks,
I meant still errors out on Centos7.
Younes
Which library do you use read the compressed files?
y
gzip
Because I am working on Windows and have currently no Linux machine available, I tried different methods to make the compressed table file:
Firstly, using a windows utility called stuffit a got a file called "test.gz" (rather strange when looked in an editor)
Secondly, because your file is indeed a CSV file using:
CREATE TABLE tz ( c1 VARCHAR(100) NOT NULL, c2 VARCHAR(100) NOT NULL ) ENGINE=CONNECT table_type=CSV COMPRESS=1 file_name='test.tsv.gz'; insert into tz values('1','test1'),('2','test2');Thirdly under cygwin, doing your method with gzip.
These 3 files are different. I attached them after renaming the second one as 'test.tsv2.gz'.
Now testing:
I always got the correct display:
No error with all three files.
Could you attach your table file so I can test it? I could you test the files I have attached to see if it produces an error?