Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4537

Insert into CS select.. from MyISAM table causes assertion 'dbyte == BYTE_PER_BLOCK' failed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 5.5.1
    • N/A
    • N/A
    • None

    Description

      Here is what customer tried.

      Its a cross engine insert. stg_sh_fact_click_denorm is MyISAM table and sh_fact_click_denorm is columnstore. Selecting from myisam and inserting into CS.
       
      * MyISAm has 0 rows...
      MariaDB [dwhs]> select count(*) from stg_sh_fact_click_denorm;
      +----------+
      | count(*) |
      +----------+
      | 0 |
      +----------+
      1 row in set (0.000 sec)
       
      * CS has 36m rows
      MariaDB [dwhs]> select count(*) from sh_fact_click_denorm;
      +----------+
      | count(*) |
      +----------+
      | 36026721 |
      +----------+
      1 row in set (0.275 sec)
       
      INSERT INTO dwhs.sh_fact_click_denorm SELECT stg.click_id, stg.clickid, stg.impression_id, stg.impressionid, stg.search_id, stg.search_date, stg.status_id, stg.click_date, stg.source_id, stg.buyer_id, stg.ip_address, stg.user_agent, stg.physical_device_type_name, stg.physical_device_type_id, stg.browser_name, stg.os_name, stg.click_key, stg.click_url, stg.product_id, stg.investment_term_months, stg.advertiser_cost, stg.premargin_supplier_earnings, stg.supplier_earnings, stg.clickcapturekey, stg.quad_clk, stg.web_server, stg.data_pass_attempted, stg.data_pass_success, stg.geo_country, stg.geo_country_cf, stg.geo_region, stg.geo_state, stg.geo_state_cf, stg.geo_city, stg.geo_city_cf, stg.geo_zip, stg.geo_dma, stg.ip_routing_type, stg.lp_click_session_id, stg.reconciliation_updated_date, stg.date_updated_date, stg.encrypted_affiliate_key, stg.physical_device_type_name_imp, stg.matching_device_type_name, stg.state_code, stg.state_name, stg.var1, stg.var2, stg.var3, stg.search_status_id, stg.service_code, stg.age, stg.gender, stg.married, stg.home_owner, stg.currently_insured, stg.insured_time_frame, stg.insurance_carrier, stg.credit_rating, stg.recent_incident_count, stg.sr22, stg.average_credit_score, stg.fico_score, stg.mortgage_ltv, stg.mortgage_term, stg.mortgage_term_name, stg.mortgage_loan_amount, stg.current_banks, stg.savings_goal, stg.investment_amount, stg.deposit_frequency, stg.yearly_gross_income, stg.investment_term_months_imp, stg.personal_loan_purpose, stg.personal_loan_amount, stg.type_of_insurance, stg.coverage_amount, stg.rank, stg.bid, stg.phone_call_bid, stg.credit_card_id, stg.qmp_creative_key, stg.qmp_click_portal_vendor_key, stg.qmp_click_campaign_key, stg.qmp_click_vendor_key, stg.qmp_click_parent_vendor_key, stg.qmp_phone_campaign_key, stg.qmp_phone_parent_vendor_key, stg.qmp_phone_portal_vendor_key, stg.qmp_phone_vendor_key, stg.category_id, stg.military_affiliation, stg.age_bucket, stg.search_date_key, stg.click_date_key, stg.transaction_id, stg.click_type, stg.click_ref_url, stg.click_hour, stg.publisher_click_trn_id, stg.anura_result, stg.has_media_cost, stg.zip_code, stg.any_recent_incidents, stg.vehicle_count, stg.occupation, stg.education, stg.license_status, stg.driver_count, stg.data_pass_available, stg.click_date_clk, stg.search_date_clk, stg.browser_version, stg.browser_vendor, stg.device_manufacturer, stg.device_model, stg.device_atlas_device_id, stg.display_width, stg.display_height, stg.browser_rendering_engine, stg.inapp_browser, stg.interstitial_used, stg.original_click_key, stg.publisher_key, stg.profile_key, stg.media_group_key, stg.bid_to_position_honored, stg.date_added, stg.pex_advertiser_cost, stg.pex_quinstreet_commission, stg.data_pass_debug_info, stg.searchid, stg.qmp_publisher_exchange_key, stg.pet_type, stg.pet_count, stg.pet_breed, stg.qmp_clk_ab_test_variant_key, stg.pet_age, stg.pet_gender, stg.external_click_id, stg.display_strategy_name, stg.qmp_aff_inventory_type_key, stg.qmp_parent_aff_invtry_type_key, stg.inventory_type, stg.dui, stg.standard_industry_code, stg.tobacco_use, stg.body_mass_index, stg.life_event, stg.medical_condition, stg.hazardous_occupation, stg.is_cellular_network, stg.household_income, stg.publisher_account_name, stg.publisher_customer_id, stg.publisher_company, stg.service_key, stg.service_name, stg.vendor_service_key, stg.vendor_service_description, stg.advertiser_account_name, stg.advertiser_customer_id, stg.advertiser_company, stg.credit_card_type_name, stg.credit_card_name, stg.blurb_title, stg.product_key, stg.product_name, stg.dms_client_key, stg.vendor_name, stg.publisher, stg.publisher_company_name, stg.hash_id, stg.profile_name, stg.media_group_name, stg.ab_test_variant_name, stg.exchange_name, stg.affiliate_key, stg.publisher_display_name, stg.advertiser_display_name, stg.client_name, stg.vertical, stg.client_model, stg.business_unit, stg.isqmpclient, stg.category_code_key, stg.category_code_name, stg.country_code, stg.country, stg.entered_dtm, stg.dms_publisher_key, stg.trx_hour, stg.trx_week, stg.trx_month, stg.trx_date FROM dwhs.stg_sh_fact_click_denorm stg where update_flag = 'I';
      ERROR 1815 (HY000): Internal error: load failed. The detailed error information is listed in err.log.
      

      Attachments

        1. Columnstore.xml
          20 kB
          Allen Lee
        2. mariadbd.err
          330 kB
          Allen Lee
        3. pm1.log.tar
          1.95 MB
          Allen Lee

        Activity

          People

            Unassigned Unassigned
            allen.lee@mariadb.com Allen Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.