Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.1.22
-
None
-
Windows
Description
When using MULTIPLE=1 for importing 566 CSV Zipped Files, of 1000 rows each one, my Server ShutsDown.
My CREATE TABLE is as follows:
CREATE TABLE dispoin.t_CONNECT_CSV_Zipped_DISPOIN_Server
|
(
|
`SCADA` VARCHAR(25) DEFAULT NULL, |
`TAG` VARCHAR(25) DEFAULT NULL, |
`ID_del_AEG` VARCHAR(25) DEFAULT NULL, |
`Descripcion` VARCHAR(255) DEFAULT NULL, |
`Time_ON` VARCHAR(19) DEFAULT NULL, |
`Time_OFF` VARCHAR(19) DEFAULT NULL, |
`Delta_Time` VARCHAR(19) DEFAULT NULL, |
`Comentario` VARCHAR(255) DEFAULT NULL, |
`Es_Alarma` VARCHAR(5) DEFAULT NULL, |
`Es_Ultima` VARCHAR(5) DEFAULT NULL, |
`Comentarios` VARCHAR(255) DEFAULT NULL |
)
|
ENGINE = CONNECT
|
TABLE_TYPE = CSV
|
FILE_NAME='//srvdiscsv/data/2017-03-23/*AL*.zip' |
HEADER=NO
|
SEP_CHAR=';' |
MULTIPLE=1 |
ZIPPED=YES
|
READONLY=YES
|
OPTION_LIST='maxerr=10000'; |
In the same folder. For 1 single CSV ZIP file, same format (MULTIPLE=NO) works perfect.
ERROR LOG
Thread pointer: 0x1e611018
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
ha_connect.dll!MAPFAM::ReadBuffer()[filamap.cpp:365]
ha_connect.dll!TDBCSV::ReadBuffer()[tabfmt.cpp:906]
ha_connect.dll!TDBMUL::ReadDB()[tabmul.cpp:520]
ha_connect.dll!CntReadNext()[connect.cc:464]
ha_connect.dll!ha_connect::rnd_next()[ha_connect.cc:3885]
mysqld.exe!handler::ha_rnd_next()[handler.cc:2578]
mysqld.exe!rr_sequential()[records.cc:470]
mysqld.exe!sub_select()[sql_select.cc:18332]
mysqld.exe!do_select()[sql_select.cc:17968]
mysqld.exe!JOIN::exec_inner()[sql_select.cc:3221]
mysqld.exe!JOIN::exec()[sql_select.cc:2512]
mysqld.exe!mysql_select()[sql_select.cc:3447]
mysqld.exe!handle_select()[sql_select.cc:372]
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5920]
mysqld.exe!mysql_execute_command()[sql_parse.cc:2979]
mysqld.exe!mysql_parse()[sql_parse.cc:7348]
mysqld.exe!dispatch_command()[sql_parse.cc:1492]
mysqld.exe!do_command()[sql_parse.cc:1109]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:271]
mysqld.exe!io_completion_callback()[threadpool_win.cc:568]
kernel32.dll!BaseFormatTimeOut()
ntdll.dll!RtlEqualDomainName()
ntdll.dll!TpIsTimerSet()
kernel32.dll!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x1e488030): SELECT * FROM dispoin.t_CONNECT_CSV_Zipped_DISPOIN_Server
Connection ID (thread ID): 7
Status: NOT_KILLED
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
Attachments
Issue Links
- relates to
-
MDEV-11295 CONNECT Storage Engine - ZIP Engine
- Closed