Details

    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

          Activity

            Juan Juan Telleria added a comment - - edited

            Works perfectly!

            Juan Juan Telleria added a comment - - edited Works perfectly!
            Juan Juan Telleria added a comment - - edited

            For final check, what about:

            CREATE OR REPLACE TABLE MyTable AS 
                 SELECT SCADA, TAG, ID_del_AEG, Es_Ultima FROM tell
                 WHERE Descripcion = '534 Maximum slip rings heating time';
            

            ¿This shall throw an error because no table definition and using Multiple = 1 or Multiple = 3?

            ¿When will it be available new CONNECT Version?

            Juan Juan Telleria added a comment - - edited For final check, what about: CREATE OR REPLACE TABLE MyTable AS SELECT SCADA, TAG, ID_del_AEG, Es_Ultima FROM tell WHERE Descripcion = '534 Maximum slip rings heating time' ; ¿This shall throw an error because no table definition and using Multiple = 1 or Multiple = 3? ¿When will it be available new CONNECT Version?

            I don't think so. You are creating a InnoDB (or MyISAM) table with standard MySQL syntax (column definitions come from the selected table) and multiple applies to tell, not MyTable.

            When will it be available new CONNECT Version
            Good question. I wish I could know.

            bertrandop Olivier Bertrand added a comment - I don't think so. You are creating a InnoDB (or MyISAM) table with standard MySQL syntax (column definitions come from the selected table) and multiple applies to tell , not MyTable . When will it be available new CONNECT Version Good question. I wish I could know.
            Juan Juan Telleria added a comment -

            ok. Thank you

            Juan Juan Telleria added a comment - ok. Thank you
            Juan Juan Telleria added a comment -

            Does Multiple = 3 (For subfolders) already work for the actual version of CONNECT?

            The currently Generally Available distribution of CONNECT (Connect 1.05.0003) does still not support this feature.

            Thank you.

            Looking forward for MariaDB 10.2.6

            Juan Juan Telleria added a comment - Does Multiple = 3 (For subfolders) already work for the actual version of CONNECT? The currently Generally Available distribution of CONNECT (Connect 1.05.0003) does still not support this feature. Thank you. Looking forward for MariaDB 10.2.6

            People

              bertrandop Olivier Bertrand
              Juan Juan Telleria
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.