Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Not a Bug
-
Affects Version/s: 10.0.16
-
Fix Version/s: N/A
-
Component/s: Storage Engine - Connect
-
Labels:None
-
Environment:OS:Scientific Linux release 6.4 (Carbon)
Kernel : 2.6.32-358.el6.x86_64
gcc : 4.4.7
Memory space:24GB
Description
Dear Sir,
I'm trying to load an INI table into Mariadb, but it seems connect engine didn't fully load my table. The data is broken by a certain line, and it didn't be loaded into the database after that line. I also tried to set seclen like your website said : option_list='seclen=4000'; but it's not helpful, would you please let me know how to solve this issue so that my INI table can be fully loaded ? Thanks a lot for your help.
Best Regards,
W.J. Chang
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Thanks for your quick reply. I just attach two files, primary_info is the file which I'd to load into MariaDB, and there are 1720 sections. But I can just see 911 rows after I query the table. I also attach the end of the result of "select * from primary_info". Here is how I created my table: create table primary_info ( Hostname varchar(20) not null flag=1, MM_IP varchar(20) not null, Bay varchar(10) not null, Location varchar(20) not null, Purpose varchar(15), Annotation varchar(50)) engine=CONNECT table_type=INI file_name='/tmp/asgc_resource/primary_info/primary_info';
Thanks a lot.
Best Regards,
W.J. Chang
Actually the documentation is out of date and you have been mislead because of this.
The default section buffer size is not 2K but 8K, and the option name is not seclen but secsize. Specifying:
option_list='secsize=16K'
I was able to display the 1720 sections.
Hi,
Could you provide a more thorough description of the problem and if you have repeatable set of commands/test case or database that would help to start resolving the actual issue.