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

CONNECT engine JDBC error HY000 Got error 122 'Out of range valblock index value' from CONNECT

    XMLWordPrintable

Details

    Description

      We frequently get this error from connect, but not 100% of the time. Sometimes it will run fine 9 out of 10 times, then fail with this message.

      HY000 Got error 122 'Out of range valblock index value' from CONNECT

      I've included the output of the log file in case this helps (there are two valblock errors below with 100 lines before and after each for context... please let me know if you need more or less to help diagnose):

      Jul 30 06:00:00 di-mariadb-test1 mysqld: cdp(29).Name=Tags cp=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: New BLOCK: size=144 g=0x7f640c5ca6b0 p=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: SubAlloc in 0x7f63fffff010 size=144 used=19296 free=67089568
      Jul 30 06:00:00 di-mariadb-test1 mysqld: Done memp=0x7f6400003b70 used=19440 free=67089424
      Jul 30 06:00:00 di-mariadb-test1 mysqld: making new JDBCCOL C29 Tags at 0x7f6400003b70
      Jul 30 06:00:00 di-mariadb-test1 mysqld: colp=0x7f6400003b70
      Jul 30 06:00:00 di-mariadb-test1 mysqld: ColDB: am=102 colname=FulfillmentStatus tabname=Orders num=0
      Jul 30 06:00:00 di-mariadb-test1 mysqld: cdp(30).Name=FulfillmentStatus cp=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: New BLOCK: size=144 g=0x7f640c5ca6b0 p=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: SubAlloc in 0x7f63fffff010 size=144 used=19440 free=67089424
      Jul 30 06:00:00 di-mariadb-test1 mysqld: Done memp=0x7f6400003c00 used=19584 free=67089280
      Jul 30 06:00:00 di-mariadb-test1 mysqld: making new JDBCCOL C30 FulfillmentStatus at 0x7f6400003c00
      Jul 30 06:00:00 di-mariadb-test1 mysqld: colp=0x7f6400003c00
      Jul 30 06:00:00 di-mariadb-test1 mysqld: ColDB: am=102 colname=FinancialStatus tabname=Orders num=0
      Jul 30 06:00:00 di-mariadb-test1 mysqld: cdp(31).Name=FinancialStatus cp=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: New BLOCK: size=144 g=0x7f640c5ca6b0 p=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: SubAlloc in 0x7f63fffff010 size=144 used=19584 free=67089280
      Jul 30 06:00:00 di-mariadb-test1 mysqld: Done memp=0x7f6400003c90 used=19728 free=67089136
      Jul 30 06:00:00 di-mariadb-test1 mysqld: making new JDBCCOL C31 FinancialStatus at 0x7f6400003c90
      Jul 30 06:00:00 di-mariadb-test1 mysqld: colp=0x7f6400003c90
      Jul 30 06:00:00 di-mariadb-test1 mysqld: ColDB: am=102 colname=DiscountCodes tabname=Orders num=0
      Jul 30 06:00:00 di-mariadb-test1 mysqld: cdp(32).Name=DiscountCodes cp=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: New BLOCK: size=144 g=0x7f640c5ca6b0 p=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: SubAlloc in 0x7f63fffff010 size=144 used=19728 free=67089136
      Jul 30 06:00:00 di-mariadb-test1 mysqld: Done memp=0x7f6400003d20 used=19872 free=67088992
      Jul 30 06:00:00 di-mariadb-test1 mysqld: making new JDBCCOL C32 DiscountCodes at 0x7f6400003d20
      Jul 30 06:00:00 di-mariadb-test1 mysqld: colp=0x7f6400003d20
      Jul 30 06:00:00 di-mariadb-test1 mysqld: ColDB: am=102 colname=ShippingAddressFirstName tabname=Orders num=0
      Jul 30 06:00:00 di-mariadb-test1 mysqld: cdp(56).Name=ShippingAddressFirstName cp=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: New BLOCK: size=144 g=0x7f640c5ca6b0 p=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: SubAlloc in 0x7f63fffff010 size=144 used=19872 free=67088992
      Jul 30 06:00:00 di-mariadb-test1 mysqld: Done memp=0x7f6400003db0 used=20016 free=67088848
      Jul 30 06:00:00 di-mariadb-test1 mysqld: making new JDBCCOL C56 ShippingAddressFirstName at 0x7f6400003db0
      Jul 30 06:00:00 di-mariadb-test1 mysqld: colp=0x7f6400003db0
      Jul 30 06:00:00 di-mariadb-test1 mysqld: ColDB: am=102 colname=ShippingAddressLastName tabname=Orders num=0
      Jul 30 06:00:00 di-mariadb-test1 mysqld: cdp(57).Name=ShippingAddressLastName cp=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: New BLOCK: size=144 g=0x7f640c5ca6b0 p=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: SubAlloc in 0x7f63fffff010 size=144 used=20016 free=67088848
      Jul 30 06:00:00 di-mariadb-test1 mysqld: Done memp=0x7f6400003e40 used=20160 free=67088704
      Jul 30 06:00:00 di-mariadb-test1 mysqld: making new JDBCCOL C57 ShippingAddressLastName at 0x7f6400003e40
      Jul 30 06:00:00 di-mariadb-test1 mysqld: colp=0x7f6400003e40
      Jul 30 06:00:00 di-mariadb-test1 mysqld: ColDB: am=102 colname=ShippingAddressAddress1 tabname=Orders num=0
      Jul 30 06:00:00 di-mariadb-test1 mysqld: cdp(58).Name=ShippingAddressAddress1 cp=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: New BLOCK: size=144 g=0x7f640c5ca6b0 p=(nil)
      Jul 30 06:00:00 di-mariadb-test1 mysqld: SubAlloc in 0x7f63fffff010 size=144 used=20160 free=67088704
      Jul 30 06:00:00 di-mariadb-test1 mysqld: Done memp=0x7f6400003ed0 used=20304 free=67088560
      

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            rdyas Robert Dyas
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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