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

Assertion `buf < end' failed in mtr_t::encrypt()

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      write_file $MYSQL_TMP_DIR/keys.txt;
      1;526540c9854d26cea56a463e4ccff3ec59af70fb2f9f9e0acbff9af9c81dec91
      EOF
       
      --let $restart_parameters=--plugin-load-add=file_key_management --file-key-management-filename=$MYSQL_TMP_DIR/keys.txt --innodb-encrypt-tables=ON --innodb-encrypt-log=ON --innodb-encryption-threads=4 --innodb-tablespaces-encryption
      --let $restart_noprint=2
      --source include/restart_mysqld.inc
       
      CREATE TABLE t1 ( 
      	col_enum enum('','a','b','c','d','e','f','foo','bar'), 
      	col_dec decimal(3,2), 
      	col_char binary(132), 
      	col_int int , 
      	col_varchar varchar(2723), 
      	UNIQUE KEY col_char (col_char(64) DESC), 
      	UNIQUE KEY col_char_2 (col_char(64))
      ) engine=innodb ;
       
       
      INSERT  IGNORE INTO t1 (col_char,col_dec,col_enum,col_int,col_varchar) VALUES
      ('fg',0.536712646484375,'',NULL,'n'), ('geq',0.609268188476562,'',6,'eqvvdul'), ('qvvdulsqntjrjowtzjivzmhl',0.027435302734375,'',NULL,'v'), ('vdu',0.27142333984375,'',NULL,'d'), ('b',0.32171630859375,'',0,'ulsqntjrjo'), ('ls',0.969711303710938,'',2,'r'), ('s',0.052764892578125,'',9,'qn'), ('ntjrj',0.915664672851562,'',NULL,'tjrjo'), ('j',0.806381225585938,'',241,'rjow'), ('',0.78985595703125,'',7,'jowtz'), ('ow',0.415664672851562,'',0,'wt'), ('t',0.307296752929688,'',7,'zjivzmhlaplwzehnnyvjvdyodbfztlhhvigbbwqcmrmxoqoknekjzlnlmhwyvpoqlinuwvholgqbmlcxbpwhxaqzzofjdedjqxmsnxga'), ('jivzmh',0.5526123046875,'',4,'ivzmh'), ('vz',NULL,'',6,'zmh'), ('c',0.804962158203125,'',7,'mhlap'), ('o',0.272735595703125,'',6,'hlaplw'), ('p',0.296630859375,'',1,''), ('l',NULL,'',1,'apl'), ('plw',0.59674072265625,'',7,''), ('lwz',0.592269897460938,'',NULL,'w'), ('',NULL,'',4,''), ('zehnnyvjvdyodbfztlhhvigbbwqcmrmxoqoknekjzlnlmhwyvpoqlinuwvho',0.138458251953125,'',3,'ehnnyv'), ('hn',NULL,'',4,'nny'), ('u',0.471908569335938,'',3,'ny'), ('yvjvdyodbfztlhhvigbbwqcmrmxoqoknekjzlnlmhwyvpoqlinuwvh',0.556884765625,'',7,'vj'), ('jvd',0.31121826171875,'',3,'vdy'), ('dy',0.229248046875,'',4,'yodb'), ('odb',0.570709228515625,'',5,'m'), ('dbf',0.703994750976562,'',0,'b'), ('y',0.36962890625,'',9,'fztlhh'), ('n',0.427627563476562,'',7,'ztl'), ('tlhhvig',0.544586181640625,'',NULL,''), ('lhh',0.378494262695312,'',3,'h'), ('h',0.810546875,'',6,'vig'), ('igbbwqcmrmxoqoknekjzlnlmhwyvpoqlinuwvholgqbmlcxbpwhxaqzzofjdedjqxmsnxgamcqydtfqessyszhuc',0.0059051513671875,'',NULL,'gbbwqcmrmxoqoknekjzlnlmhwyvpoqlinuwvholgqbmlcxbp'), ('b',0.53118896484375,'',5,''), ('b',0.271026611328125,'',7,'wqcmrm'), ('qcm',0.0714263916015625,'',NULL,'cm'), ('m',0.940277099609375,'',7,'b'), ('rm',0.856399536132812,'',5,'m'), ('xoqoknekjzlnlmhwyvpoqlinuwvholgqbmlcxbpwhxaqzzofjdedjqxm',0.747543334960938,'',5,'o'), ('lnl',NULL,'',9,'nlmhwyvpoqlinuwvholgqbmlcxbpwhxaqzzofjdedjqxmsnxgamcqydtfqessyszhucaqyngjtxwsdvotcofzeilauutbodhjcrpwfnvyzpkxcoelsxvets'), ('p',NULL,'',NULL,'oqlin'), ('qli',0.369384765625,'',9,''), ('f',0.576095581054688,'',NULL,'l'), ('',NULL,'',1,'in'), ('lgqbmlcxbpwhxaqzzofjdedjqxmsnxgamcqydtfqessyszhucaqyngjtxwsdvotcofzeila',0.41156005859375,'',7,'gqbml'), ('qbml',0.914215087890625,'',NULL,'b'), ('mlcxbpw',0.0949859619140625,'',9,'lcxb'), ('f',0.596115112304688,'',5,'c'), ('xbpw',0.24969482421875,'',7,'bpwhxaqzzofjdedjqxmsnxgamcqydtfqessyszhucaqyngjtxwsdvotcofzeilauutbodhjcrpwfnvyzpkxcoelsxvetsaavyzabvqvbocspeqjpcvscxguzwuhlesrrpolfkbugjjngipsndkgedcsryzdzmcuyhajyxeuhsqvitgnkzuhsswkquotinnkhztvopekgqlhtmetablqdhrpkavnlcbioqtpslbjwggalzvxjxfmffpvilfuejxfnzlaxpvfrgbgbwfodopqsvunkiihkuwmzbtcguyqxntvdvwpcvzbtuuesfkzvrhzimdbrrwvwglllgakhuxjiyvvdocvghsowxzjbqmsoqekmawysnoflsguwlvttbrszjfeetkj'), ('t',0.17230224609375,'',9,'pwhxaqz'), ('whxaqzzofjdedjqxmsnxgamcqydtfqessysz',0.438674926757812,'',6,'hxa'), ('xaqz',0.203659057617188,'',131,'aq'), ('qzzo',0.248214721679688,'',9,'zzo'), ('z',NULL,'',7,''), ('dt',NULL,'',1,'p'), ('tfqessyszhucaqyngjtxwsdvotcofzeilauutbodhj',0.84661865234375,'',NULL,'fq'), ('q',0.513748168945312,'',2,''), ('e',0.0661468505859375,'',8,'ssy'), ('syszh',0.554290771484375,'',0,'yszhucaqyngjtxwsdvotcofzeilauutbodhjcrpwfnvyzpkxcoelsxvetsaavyzabvqvbocspeqjpcvscxguzwuhlesrrpolfkbugjjngipsndkgedcsryzdzmcuyhajyxeuhsqvitgnkzuhsswkquotinnkhztvopekgqlhtmetablqdhrpkavnlcbioqtpslbjwggalzvxjxfmffpvilfuejxfnzlaxpvfrgbgbwfodopqsvunkiihkuwmzbtcguyqxntvdvwpcvzbtuuesfkzvrhzimdbrrwvwglllgakhuxjiyvvdocvghsowxzjbqmsoqekmawysnoflsguwlvttbrszjfeetkjqjesgfuongkeclvevozjxxendaakzusxcuyktyorbwxmbfyqjjbghkvjwnlrspsqiglqjnqucmtkvdomfdyqmpmkjbvffyxkhglsgfbncgwtqkvbxguaqzuyjzidcwnzkbpbnwjbfhpklltgnjkgxqtkxgjhpvmrrfazyogfraoeinckdthmzlfctwggfmbpmzcazxrdtwtxayykpiyveppysoebqetrdufztiwcxtvigfsasdpuyrnravjmmfovnoezcyfbngmqpicwuywuoqbokikgpfxkiqigreyhfzyeizmhlcvneljunxwosfoihnkvmhfdgnijeiwovheqpqyvovgmzkjxruwqlzuhbmvcgbngxmevopuhgrjvvdohwzgjimmpzijarxtyhauxbluoenhdmkqhezutllznkgvqkquxffhopwgavikgotxlyxwkfjhuotmmbnerwyodslhzaupedvobbyuuvgvdvnwhqhdbfmqlyuzzsfkjhwijrcqhlfggfolzdbzcyobvqvlvvsplvxdltcifvkbonwxmqkmfrqocowcvqdkfpcghlgoozdjwipkqubrodnjzuxbczdtfynocpnizcxvtvzcuotqtovytoxqyjihrollidforwmqnmmdazvkrtgjyykzsvhmcuyrnravjmmfovnoezcyfbngmqpicwuywuoqbokikgpfxkiqigreyhfzyeizmhlcvneljunxwosfoihnkvmhfdgnijeiwovheqpqyvovgmzkjxruwqlzuhbmvcgbngxmevopuhgrjvvdohwzgjimmpzijarxtyhauxbluoenhdmkqhezutllznkgvqkquxffhopwgavikgotxlyxwkfjhuotmmbnerwyodslhzaupedvobbyuuvgvdvnwhqhdbfmqlyuzzsfkjhwijrcqhlfggfolzdbzcyobvqvlvvsplvxdltcifvkbonwxmqkmfrqocowcvqdkfpcghlgoozdjwipkqubrodnjzuxbczdtfynocpnizcxvtvzcuotqtovytoxqyjihrollidforwmqnmmdazvkrtgjyykzsvhmc'), ('szhucaqyng',0.692169189453125,'',6,''), ('hjcrpw',0.61492919921875,'',1,''), ('jcrpwfn',0.320846557617188,'',0,'crpwfnv'), ('d',0.0172271728515625,'',97,'rpwfnvyzpkxcoelsxvetsaavyzabvqvbocspeqjpcvscxguzwuhlesrrpolfkbugjjngipsndkgedcsryzdzmcuyhajyxeuhsqvitgnkzuhsswkquotinnkhztvopekgqlhtmetablqdhrpkavnlcbioqtpslbjwggalzvxjxfmffpvilfuejxfnzlaxpvfrgbgbwfodopqsvunkiihkuwmzbtcguyqxntvdvwpcvzbtuuesfkzvrhzimdbrrwvwglllgakhuxjiyvvdocvghsowxzjbqmsoqekmawysnoflsguwlvttbrszjfeetkjqjesgfuongkeclvevozjxxendaakzusxcuyktyorbwxmbfyqjjbghkvjwnlrspsqiglqjnqucmtkvdomfdyqmpmkjbvffyxkhglsgfbncgwtqkvbxguaqzuyjzidcwnzkbpbnwjbfhpklltgnjkgxqtkxgjhpvmrrfazyogfraoeinckdthmzlfctwggfmbpmzcazxrdtwtxayykpiyveppysoebqetrdufztiwcxtvigfsasdpuyrnravjmmfovnoezcyfbngmqpicwuywuoqbokikgpfxkiqigreyhfzyeizmhlcvneljunxwosfoihnkvmhfdgnijeiwovheqpqyvovgmzkjxruwqlzuhbmvcgbngxmevopuhgrjvvdohwzgjimmpzijarxtyhauxbluoenhdmkqhezutllznkgvqkquxffhopwgavikgotxlyxwkfjhuotmmbnerwyodslhzaupedvobbyuuvgvdvnwhqhdbfmqlyuzzsfkjhwijrcqhlfggfolzdbzcyobvqvlvvsplvxdltcifvkbonwxmqkmfrqocowcvqdkfpcghlgoozdjwipkqubr'), ('pwfnvyzpkxcoelsxvetsa',0.670639038085938,'',6,''), ('za',0.329833984375,'',5,'abvqvbocspeqjpcvscxguzwuhlesrrpolfkbugjjngipsndkgedcsryzdzmcuyhajyxeuhsqvitgnkzuhsswkquotinnkhztvopekgqlhtmetablqdhrpkavnlcbioqtpslbjwggalzvxjxfmffpvilfuejxfnzlaxpvfrgbgbwfodopqsvunkiihkuwmzbtcguyqxntvdvwpcvzbtuuesfkzvrhzimdbrrwvwglllgakhuxjiyvvdocvghsowxzjbqmsoqekmawysnoflsguwlvttbrszjfeetkjqjesgfuongkeclvevozjxxendaakzusxcuyktyorbwxmbfyqjjbghkvjwnlrspsqiglqjnqucmtkvdomfdyqmpmkjbvffyxkhglsgfbncgwtqkvbxguaqzuyjzidcwnzkbpbnwjbfhpklltgnjkgxqtkxgjhpvmrrfazyogfraoeinckdthmzlfctwggfmbpmzcazxrdtwtxayykpiyveppysoebqetrdufztiwcxtvigfsasdpuyrnravjmmfovnoezcyfbngmqpicwuywuoqbokikgpfxkiqigreyhfzyeizmhlcvneljunxwosfoihnkvmhfdgnijeiwovheqpqyvovgmzkjxruwqlzuhbmvcgbngxmevopuhgrjvvdohwzgjimmpzijarxtyhauxbluoenhdmkqhezutllznkgvqkquxffhopwgavikgotxlyxwkfjhuotmmbnerwyodslhzaupedvobbyuuvgvdv'), ('bvqvb',0.866683959960938,'',5,'vqv'), ('qvbocspe',0.715972900390625,'',NULL,''), ('vbocspeqjpcvscxguzwuhlesrrpolfkbugjjngipsndkgedcsryzdzmcuyha',0.0101776123046875,'',5,'bo'), ('ocspeqjp',0.910446166992188,'',NULL,'cs'), ('g',0.219406127929688,'',NULL,''), ('speqjp',0.073394775390625,'',3,'peqjpcv'), ('eqjpcvscxguzwuhlesrrpolfkbugjjngipsndkgedcsryzdzmcuyhajyxeuhsqvitgnkzuhsswkquotinnkhztvopekgq',0.0789337158203125,'',0,'qjpcv'), ('j',0.73626708984375,'',1,'pcvscxguzwuhlesrrpolfkbugjjngipsndkgedcsryzdzmcuyhajyxeuhsqvitgnkzuhsswkquotinnkhztvopekgqlhtmetablqdhrpkavnlcbioqtpslbjwggalzv');
       
      drop table t1;
      

      caused by commit cc277a7d24e9b353878ddee92b8123bad78e6513 MDEV-36024: Redesign innodb_encrypt_log=ON :

      mariadbd: /10.11/storage/innobase/log/log0crypt.cc:693: size_t mtr_t::encrypt(): Assertion `buf < end' failed.
      251001 11:46:23 [ERROR] /10.11/sql/mariadbd got signal 6 ;
       
      Server version: 10.11.15-MariaDB-asan-debug-log source revision: cc277a7d24e9b353878ddee92b8123bad78e6513
       
      stdlib/abort.c:81(__GI_abort)[0x7f4d1ae57535]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f4d1ae5740f]
      /lib/x86_64-linux-gnu/libc.so.6(+0x301a2)[0x7f4d1ae651a2]
      log/log0crypt.cc:687(mtr_t::encrypt())[0x55ea1e795023]
      mtr/mtr0mtr.cc:1062(mtr_t::do_write())[0x55ea1e7a976a]
      mtr/mtr0mtr.cc:483(mtr_t::commit())[0x55ea1e7a39a3]
      row/row0ins.cc:2984(row_ins_clust_index_entry_low(unsigned long, btr_latch_mode, dict_index_t*, unsigned long, dtuple_t*, unsigned long, que_thr_t*))[0x55ea1e8cfb41]
      row/row0ins.cc:3367(row_ins_clust_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, unsigned long))[0x55ea1e8d2353]
      row/row0ins.cc:3495(row_ins_index_entry(dict_index_t*, dtuple_t*, que_thr_t*))[0x55ea1e8d2d8f]
      row/row0ins.cc:3661(row_ins_index_entry_step(ins_node_t*, que_thr_t*))[0x55ea1e8d3f1e]
      row/row0ins.cc:3786(row_ins(ins_node_t*, que_thr_t*))[0x55ea1e8d49b0]
      row/row0ins.cc:3915(row_ins_step(que_thr_t*))[0x55ea1e8d5904]
      row/row0mysql.cc:1303(row_insert_for_mysql(unsigned char const*, row_prebuilt_t*, ins_mode_t))[0x55ea1e91e1b9]
      handler/ha_innodb.cc:7830(ha_innobase::write_row(unsigned char const*))[0x55ea1e5220e1]
      sql/handler.cc:7765(handler::ha_write_row(unsigned char const*))[0x55ea1dab6dc0]
      sql/sql_insert.cc:2315(Write_record::single_insert(unsigned long long*))[0x55ea1d0c43f0]
      sql/sql_insert.cc:2357(Write_record::write_record())[0x55ea1d0c4aad]
      sql/sql_insert.cc:1217(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x55ea1d0bb354]
      sql/sql_parse.cc:4628(mysql_execute_command(THD*, bool))[0x55ea1d189570]
      sql/sql_parse.cc:8180(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55ea1d1a1c67]
      sql/sql_parse.cc:1908(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55ea1d177949]
      sql/sql_parse.cc:1419(do_command(THD*, bool))[0x55ea1d174650]
      sql/sql_connect.cc:1386(do_handle_one_connection(CONNECT*, bool))[0x55ea1d63ca26]
      sql/sql_connect.cc:1300(handle_one_connection)[0x55ea1d63c572]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55ea1e325a3d]
      nptl/pthread_create.c:487(start_thread)[0x7f4d1b322fa3]
      x86_64/clone.S:97(clone)[0x7f4d1af2e06f]
      
      

      Attachments

        Issue Links

          Activity

            People

              alice Alice Sherepa
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.