Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12354

MariaDB CONNECT CSV (Zipped Tables)

    XMLWordPrintable

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

            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.