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
        2. mariadbd.err
          330 kB
        3. pm1.log.tar
          1.95 MB

        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.