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
 
 -