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

Allow one to specify max length for a BLOB/TEXT

Details

    Description

      InnoDB can't handle rows that has a longer row length than 64K (this is excluding BLOB and TEXT fields).
      One solution is to convert all long VARCHAR fields to TEXT.
      The problem with this is that the length constraint one used on VARCHAR isn't supported by TEXT.

      This could be solved by allowing one to specify a max length for BLOB/TEXT.

      Inserting 100 characters in a BLOB(99) would in this case give an error.

      The relevant SQL Standard grammar:

      <character large object type> ::=
      		 
          CHARACTER LARGE OBJECT [ <left paren> <character large object length> <right paren> ]
      		 
        | CHAR LARGE OBJECT [ <left paren> <character large object length> <right paren> ]
      		 
        | CLOB [ <left paren> <character large object length> <right paren> ]
      		 
       
      		 
      <character large object length> ::=
      		 
        <large object length> [ <char length units> ]
      		 
       
      		 
      <large object length> ::=
      		 
          <length> [ <multiplier> ]
      		 
        | <large object length token>
      		 
       
      		 
       
      		 
      // Similar to <length> [ <multiplier> ] but with
      		 
      // no separators between <digit>s and <multiplier>
      		 
      <large object length token> ::=
      		 
          <digit>... <multiplier>
      		 
       
      		 
      <multiplier> ::=
      		 
          K
      		 
        | M
      		 
        | G
      		 
        | T
      		 
        | P
      		 
       
      		 
      <char length units> ::=
      		 
        CHARACTERS | OCTETS

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          Manasa ManasaTulluri added a comment - - edited

          Hi,

          We have tried creating a table with 311 columns . We have replaced few varchar columns with text datatype in order to avoid the error "A row cannot handle more than 64K". This error is resolved , But now we are getting below warning.

          Warning 139 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

          Please suggest a solution for the warning and let us know if it can be ignored. I have tried using ROW_FORMAT=DYNAMIC , got the below error

          ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

          Below is the table DDL.

          CREATE TABLE test
          ( test_ID INT AUTO_INCREMENT NOT NULL,
          COLUMN1 VARCHAR(10),
          COLUMN2 VARCHAR(20),
          COLUMN3 VARCHAR(63),
          COLUMN4 VARCHAR(63),
          COLUMN5 VARCHAR(40),
          COLUMN6 VARCHAR(63),
          COLUMN7 VARCHAR(40),
          COLUMN8 VARCHAR(80),
          COLUMN9 VARCHAR(40),
          COLUMN10 VARCHAR(40),
          COLUMN11 DATE,
          COLUMN12 VARCHAR(15),
          COLUMN13 VARCHAR(40),
          COLUMN14 VARCHAR(241),
          COLUMN15 VARCHAR(241),
          COLUMN16 DATE,
          COLUMN17 DATETIME(6),
          COLUMN18 DATE,
          COLUMN19 VARCHAR(3),
          COLUMN20 DATETIME(6),
          COLUMN21 DATETIME(6),
          COLUMN22 VARCHAR(63),
          COLUMN23 VARCHAR(63),
          COLUMN24 VARCHAR(255),
          COLUMN25 VARCHAR(63),
          COLUMN26 VARCHAR(40),
          COLUMN27 VARCHAR(80),
          COLUMN28 VARCHAR(63),
          COLUMN29 VARCHAR(40),
          COLUMN30 VARCHAR(80),
          COLUMN31 VARCHAR(3),
          COLUMN32 DECIMAL(30,10),
          COLUMN33 DATE,
          COLUMN34 VARCHAR(63),
          COLUMN35 TEXT(630),
          COLUMN36 VARCHAR(40),
          COLUMN37 VARCHAR(241),
          COLUMN38 VARCHAR(3),
          COLUMN39 VARCHAR(241),
          COLUMN40 VARCHAR(241),
          COLUMN41 VARCHAR(241),
          COLUMN42 VARCHAR(63),
          COLUMN43 VARCHAR(40),
          COLUMN44 VARCHAR(3),
          COLUMN45 VARCHAR(63),
          COLUMN46 VARCHAR(63),
          COLUMN47 VARCHAR(40),
          COLUMN48 VARCHAR(80),
          COLUMN49 VARCHAR(63),
          COLUMN50 VARCHAR(40),
          COLUMN51 VARCHAR(80),
          COLUMN52 VARCHAR(63),
          COLUMN53 VARCHAR(40),
          COLUMN54 VARCHAR(80),
          COLUMN55 VARCHAR(63),
          COLUMN56 VARCHAR(40),
          COLUMN57 VARCHAR(80),
          COLUMN58 VARCHAR(63),
          COLUMN59 VARCHAR(40),
          COLUMN60 VARCHAR(80),
          COLUMN61 VARCHAR(63),
          COLUMN62 VARCHAR(40),
          COLUMN63 VARCHAR(80),
          COLUMN64 VARCHAR(63),
          COLUMN65 VARCHAR(40),
          COLUMN66 VARCHAR(80),
          COLUMN67 VARCHAR(255),
          COLUMN68 VARCHAR(255),
          COLUMN69 VARCHAR(63),
          COLUMN70 VARCHAR(63),
          COLUMN71 DATETIME(6),
          COLUMN72 VARCHAR(63),
          COLUMN73 VARCHAR(40),
          COLUMN74 VARCHAR(80),
          COLUMN75 VARCHAR(63),
          COLUMN76 VARCHAR(40),
          COLUMN77 VARCHAR(80),
          COLUMN78 VARCHAR(255),
          COLUMN79 VARCHAR(3),
          COLUMN80 VARCHAR(255),
          COLUMN81 VARCHAR(63),
          COLUMN82 VARCHAR(63),
          COLUMN83 VARCHAR(40),
          COLUMN84 VARCHAR(80),
          COLUMN85 VARCHAR(63),
          COLUMN86 VARCHAR(40),
          COLUMN87 VARCHAR(80),
          COLUMN88 VARCHAR(63),
          COLUMN89 VARCHAR(63),
          COLUMN90 VARCHAR(3),
          COLUMN91 VARCHAR(3),
          COLUMN92 DATETIME(6),
          COLUMN93 DATETIME(6),
          COLUMN94 VARCHAR(255),
          COLUMN95 VARCHAR(255),
          COLUMN96 DATE,
          COLUMN97 VARCHAR(63),
          COLUMN98 VARCHAR(276),
          COLUMN99 VARCHAR(63),
          COLUMN100 VARCHAR(40),
          COLUMN101 VARCHAR(80),
          COLUMN102 VARCHAR(63),
          COLUMN103 VARCHAR(40),
          COLUMN104 VARCHAR(80),
          COLUMN105 VARCHAR(63),
          COLUMN106 VARCHAR(40),
          COLUMN107 VARCHAR(80),
          COLUMN108 VARCHAR(63),
          COLUMN109 VARCHAR(40),
          COLUMN110 VARCHAR(80),
          COLUMN111 VARCHAR(63),
          COLUMN112 VARCHAR(63),
          COLUMN113 VARCHAR(63),
          COLUMN114 VARCHAR(40),
          COLUMN115 VARCHAR(80),
          COLUMN116 VARCHAR(3),
          COLUMN117 DECIMAL(30,10),
          COLUMN118 DECIMAL(8,7),
          COLUMN119 VARCHAR(63),
          COLUMN120 VARCHAR(40),
          COLUMN121 VARCHAR(80),
          COLUMN122 VARCHAR(3),
          COLUMN123 DECIMAL(30,10),
          COLUMN124 DECIMAL(8,7),
          COLUMN125 VARCHAR(241),
          COLUMN126 VARCHAR(3),
          COLUMN127 DECIMAL(30,10),
          COLUMN128 VARCHAR(3),
          COLUMN129 DECIMAL(30,10),
          COLUMN130 VARCHAR(255),
          COLUMN131 VARCHAR(255),
          COLUMN132 VARCHAR(63),
          COLUMN133 VARCHAR(63),
          COLUMN134 DATE,
          COLUMN135 DATE,
          COLUMN136 VARCHAR(315),
          COLUMN137 VARCHAR(63),
          COLUMN138 VARCHAR(40),
          COLUMN139 VARCHAR(80),
          COLUMN140 VARCHAR(63),
          COLUMN141 VARCHAR(40),
          COLUMN142 VARCHAR(80),
          COLUMN143 VARCHAR(3),
          COLUMN144 DECIMAL(30,10),
          COLUMN145 DATE,
          COLUMN146 VARCHAR(63),
          COLUMN147 TEXT(630),
          COLUMN148 DATE,
          COLUMN149 VARCHAR(63),
          COLUMN150 TEXT(630),
          COLUMN151 VARCHAR(63),
          COLUMN152 TEXT(630),
          COLUMN153 VARCHAR(63),
          COLUMN154 VARCHAR(4),
          COLUMN155 VARCHAR(63),
          COLUMN156 VARCHAR(4),
          COLUMN157 VARCHAR(63),
          COLUMN158 VARCHAR(4),
          COLUMN159 VARCHAR(63),
          COLUMN160 VARCHAR(63),
          COLUMN161 TEXT(630),
          COLUMN162 VARCHAR(63),
          COLUMN163 VARCHAR(4),
          COLUMN164 VARCHAR(63),
          COLUMN165 VARCHAR(63),
          COLUMN166 TEXT(630),
          COLUMN167 VARCHAR(4),
          COLUMN168 VARCHAR(63),
          COLUMN169 VARCHAR(63),
          COLUMN170 TEXT(630),
          COLUMN171 VARCHAR(4),
          COLUMN172 VARCHAR(63),
          COLUMN173 VARCHAR(4),
          COLUMN174 VARCHAR(63),
          COLUMN175 VARCHAR(63),
          COLUMN176 TEXT(630),
          COLUMN177 VARCHAR(63),
          COLUMN178 VARCHAR(4),
          COLUMN179 DECIMAL(28,10),
          COLUMN180 VARCHAR(63),
          COLUMN181 DECIMAL(8,7),
          COLUMN182 VARCHAR(63),
          COLUMN183 DECIMAL(1,0),
          COLUMN184 VARCHAR(63),
          COLUMN185 VARCHAR(63),
          COLUMN186 VARCHAR(63),
          COLUMN187 VARCHAR(63),
          COLUMN188 DATE,
          COLUMN189 DATE,
          COLUMN190 VARCHAR(63),
          COLUMN191 TEXT(630),
          COLUMN192 DATE,
          COLUMN193 DATE,
          COLUMN194 DATE,
          COLUMN195 DATE,
          COLUMN196 VARCHAR(63),
          COLUMN197 VARCHAR(4),
          COLUMN198 VARCHAR(63),
          COLUMN199 VARCHAR(4),
          COLUMN200 DECIMAL(8,7),
          COLUMN201 VARCHAR(3),
          COLUMN202 DECIMAL(30,10),
          COLUMN203 VARCHAR(63),
          COLUMN204 VARCHAR(4),
          COLUMN205 VARCHAR(63),
          COLUMN206 VARCHAR(4),
          COLUMN207 DECIMAL(8,7),
          COLUMN208 VARCHAR(3),
          COLUMN209 DECIMAL(30,10),
          COLUMN210 DATE,
          COLUMN211 VARCHAR(63),
          COLUMN212 TEXT(630),
          COLUMN213 DATE,
          COLUMN214 VARCHAR(63),
          COLUMN215 TEXT(630),
          COLUMN216 VARCHAR(63),
          COLUMN217 TEXT(630),
          COLUMN218 VARCHAR(63),
          COLUMN219 VARCHAR(4),
          COLUMN220 VARCHAR(63),
          COLUMN221 VARCHAR(4),
          COLUMN222 VARCHAR(63),
          COLUMN223 VARCHAR(4),
          COLUMN224 VARCHAR(63),
          COLUMN225 VARCHAR(63),
          COLUMN226 TEXT(630),
          COLUMN227 DECIMAL(18,12),
          COLUMN228 VARCHAR(63),
          COLUMN229 DATE,
          COLUMN230 VARCHAR(63),
          COLUMN231 TEXT(630),
          COLUMN232 DATE,
          COLUMN233 DATE,
          COLUMN234 DATE,
          COLUMN235 DATE,
          COLUMN236 VARCHAR(3),
          COLUMN237 DECIMAL(30,10),
          COLUMN238 VARCHAR(3),
          COLUMN239 DECIMAL(30,10),
          COLUMN240 VARCHAR(3),
          COLUMN241 VARCHAR(3),
          COLUMN242 VARCHAR(63),
          COLUMN243 VARCHAR(40),
          COLUMN244 VARCHAR(80),
          COLUMN245 VARCHAR(63),
          COLUMN246 VARCHAR(40),
          COLUMN247 VARCHAR(80),
          COLUMN248 VARCHAR(3),
          COLUMN249 DECIMAL(30,10),
          COLUMN250 DATE,
          COLUMN251 VARCHAR(63),
          COLUMN252 TEXT(630),
          COLUMN253 VARCHAR(63),
          COLUMN254 VARCHAR(40),
          COLUMN255 VARCHAR(80),
          COLUMN256 VARCHAR(63),
          COLUMN257 VARCHAR(40),
          COLUMN258 VARCHAR(80),
          COLUMN259 VARCHAR(3),
          COLUMN260 DECIMAL(30,10),
          COLUMN261 DATE,
          COLUMN262 VARCHAR(63),
          COLUMN263 TEXT(630),
          COLUMN264 VARCHAR(63),
          COLUMN265 VARCHAR(40),
          COLUMN266 VARCHAR(80),
          COLUMN267 VARCHAR(63),
          COLUMN268 VARCHAR(40),
          COLUMN269 VARCHAR(80),
          COLUMN270 VARCHAR(3),
          COLUMN271 DECIMAL(30,10),
          COLUMN272 DATE,
          COLUMN273 VARCHAR(63),
          COLUMN274 TEXT(630),
          COLUMN275 VARCHAR(63),
          COLUMN276 VARCHAR(40),
          COLUMN277 VARCHAR(80),
          COLUMN278 VARCHAR(63),
          COLUMN279 VARCHAR(40),
          COLUMN280 VARCHAR(80),
          COLUMN281 VARCHAR(3),
          COLUMN282 DECIMAL(30,10),
          COLUMN283 DATE,
          COLUMN284 VARCHAR(63),
          COLUMN285 TEXT(630),
          COLUMN286 VARCHAR(63),
          COLUMN287 VARCHAR(40),
          COLUMN288 VARCHAR(80),
          COLUMN289 VARCHAR(63),
          COLUMN290 VARCHAR(40),
          COLUMN291 VARCHAR(80),
          COLUMN292 VARCHAR(3),
          COLUMN293 DECIMAL(30,10),
          COLUMN294 DATE,
          COLUMN295 VARCHAR(63),
          COLUMN296 TEXT(630),
          COLUMN297 VARCHAR(63),
          COLUMN298 VARCHAR(40),
          COLUMN299 VARCHAR(80),
          COLUMN300 VARCHAR(63),
          COLUMN301 VARCHAR(40),
          COLUMN302 VARCHAR(80),
          COLUMN303 VARCHAR(3),
          COLUMN304 DECIMAL(30,10),
          COLUMN305 DATE,
          COLUMN306 VARCHAR(63),
          COLUMN307 TEXT(630),
          COLUMN308 VARCHAR(63),
          COLUMN309 VARCHAR(255),
          COLUMN310 VARCHAR(3),
          COLUMN311 VARCHAR(3),
          CREATED_DATE DATETIME(6),
          ENTITY_ID VARCHAR(20),
          CONSTRAINT test_PK PRIMARY KEY (test_ID)
          ) ;

          Manasa ManasaTulluri added a comment - - edited Hi, We have tried creating a table with 311 columns . We have replaced few varchar columns with text datatype in order to avoid the error "A row cannot handle more than 64K". This error is resolved , But now we are getting below warning. Warning 139 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. Please suggest a solution for the warning and let us know if it can be ignored. I have tried using ROW_FORMAT=DYNAMIC , got the below error ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. Below is the table DDL. CREATE TABLE test ( test_ID INT AUTO_INCREMENT NOT NULL, COLUMN1 VARCHAR(10), COLUMN2 VARCHAR(20), COLUMN3 VARCHAR(63), COLUMN4 VARCHAR(63), COLUMN5 VARCHAR(40), COLUMN6 VARCHAR(63), COLUMN7 VARCHAR(40), COLUMN8 VARCHAR(80), COLUMN9 VARCHAR(40), COLUMN10 VARCHAR(40), COLUMN11 DATE, COLUMN12 VARCHAR(15), COLUMN13 VARCHAR(40), COLUMN14 VARCHAR(241), COLUMN15 VARCHAR(241), COLUMN16 DATE, COLUMN17 DATETIME(6), COLUMN18 DATE, COLUMN19 VARCHAR(3), COLUMN20 DATETIME(6), COLUMN21 DATETIME(6), COLUMN22 VARCHAR(63), COLUMN23 VARCHAR(63), COLUMN24 VARCHAR(255), COLUMN25 VARCHAR(63), COLUMN26 VARCHAR(40), COLUMN27 VARCHAR(80), COLUMN28 VARCHAR(63), COLUMN29 VARCHAR(40), COLUMN30 VARCHAR(80), COLUMN31 VARCHAR(3), COLUMN32 DECIMAL(30,10), COLUMN33 DATE, COLUMN34 VARCHAR(63), COLUMN35 TEXT(630), COLUMN36 VARCHAR(40), COLUMN37 VARCHAR(241), COLUMN38 VARCHAR(3), COLUMN39 VARCHAR(241), COLUMN40 VARCHAR(241), COLUMN41 VARCHAR(241), COLUMN42 VARCHAR(63), COLUMN43 VARCHAR(40), COLUMN44 VARCHAR(3), COLUMN45 VARCHAR(63), COLUMN46 VARCHAR(63), COLUMN47 VARCHAR(40), COLUMN48 VARCHAR(80), COLUMN49 VARCHAR(63), COLUMN50 VARCHAR(40), COLUMN51 VARCHAR(80), COLUMN52 VARCHAR(63), COLUMN53 VARCHAR(40), COLUMN54 VARCHAR(80), COLUMN55 VARCHAR(63), COLUMN56 VARCHAR(40), COLUMN57 VARCHAR(80), COLUMN58 VARCHAR(63), COLUMN59 VARCHAR(40), COLUMN60 VARCHAR(80), COLUMN61 VARCHAR(63), COLUMN62 VARCHAR(40), COLUMN63 VARCHAR(80), COLUMN64 VARCHAR(63), COLUMN65 VARCHAR(40), COLUMN66 VARCHAR(80), COLUMN67 VARCHAR(255), COLUMN68 VARCHAR(255), COLUMN69 VARCHAR(63), COLUMN70 VARCHAR(63), COLUMN71 DATETIME(6), COLUMN72 VARCHAR(63), COLUMN73 VARCHAR(40), COLUMN74 VARCHAR(80), COLUMN75 VARCHAR(63), COLUMN76 VARCHAR(40), COLUMN77 VARCHAR(80), COLUMN78 VARCHAR(255), COLUMN79 VARCHAR(3), COLUMN80 VARCHAR(255), COLUMN81 VARCHAR(63), COLUMN82 VARCHAR(63), COLUMN83 VARCHAR(40), COLUMN84 VARCHAR(80), COLUMN85 VARCHAR(63), COLUMN86 VARCHAR(40), COLUMN87 VARCHAR(80), COLUMN88 VARCHAR(63), COLUMN89 VARCHAR(63), COLUMN90 VARCHAR(3), COLUMN91 VARCHAR(3), COLUMN92 DATETIME(6), COLUMN93 DATETIME(6), COLUMN94 VARCHAR(255), COLUMN95 VARCHAR(255), COLUMN96 DATE, COLUMN97 VARCHAR(63), COLUMN98 VARCHAR(276), COLUMN99 VARCHAR(63), COLUMN100 VARCHAR(40), COLUMN101 VARCHAR(80), COLUMN102 VARCHAR(63), COLUMN103 VARCHAR(40), COLUMN104 VARCHAR(80), COLUMN105 VARCHAR(63), COLUMN106 VARCHAR(40), COLUMN107 VARCHAR(80), COLUMN108 VARCHAR(63), COLUMN109 VARCHAR(40), COLUMN110 VARCHAR(80), COLUMN111 VARCHAR(63), COLUMN112 VARCHAR(63), COLUMN113 VARCHAR(63), COLUMN114 VARCHAR(40), COLUMN115 VARCHAR(80), COLUMN116 VARCHAR(3), COLUMN117 DECIMAL(30,10), COLUMN118 DECIMAL(8,7), COLUMN119 VARCHAR(63), COLUMN120 VARCHAR(40), COLUMN121 VARCHAR(80), COLUMN122 VARCHAR(3), COLUMN123 DECIMAL(30,10), COLUMN124 DECIMAL(8,7), COLUMN125 VARCHAR(241), COLUMN126 VARCHAR(3), COLUMN127 DECIMAL(30,10), COLUMN128 VARCHAR(3), COLUMN129 DECIMAL(30,10), COLUMN130 VARCHAR(255), COLUMN131 VARCHAR(255), COLUMN132 VARCHAR(63), COLUMN133 VARCHAR(63), COLUMN134 DATE, COLUMN135 DATE, COLUMN136 VARCHAR(315), COLUMN137 VARCHAR(63), COLUMN138 VARCHAR(40), COLUMN139 VARCHAR(80), COLUMN140 VARCHAR(63), COLUMN141 VARCHAR(40), COLUMN142 VARCHAR(80), COLUMN143 VARCHAR(3), COLUMN144 DECIMAL(30,10), COLUMN145 DATE, COLUMN146 VARCHAR(63), COLUMN147 TEXT(630), COLUMN148 DATE, COLUMN149 VARCHAR(63), COLUMN150 TEXT(630), COLUMN151 VARCHAR(63), COLUMN152 TEXT(630), COLUMN153 VARCHAR(63), COLUMN154 VARCHAR(4), COLUMN155 VARCHAR(63), COLUMN156 VARCHAR(4), COLUMN157 VARCHAR(63), COLUMN158 VARCHAR(4), COLUMN159 VARCHAR(63), COLUMN160 VARCHAR(63), COLUMN161 TEXT(630), COLUMN162 VARCHAR(63), COLUMN163 VARCHAR(4), COLUMN164 VARCHAR(63), COLUMN165 VARCHAR(63), COLUMN166 TEXT(630), COLUMN167 VARCHAR(4), COLUMN168 VARCHAR(63), COLUMN169 VARCHAR(63), COLUMN170 TEXT(630), COLUMN171 VARCHAR(4), COLUMN172 VARCHAR(63), COLUMN173 VARCHAR(4), COLUMN174 VARCHAR(63), COLUMN175 VARCHAR(63), COLUMN176 TEXT(630), COLUMN177 VARCHAR(63), COLUMN178 VARCHAR(4), COLUMN179 DECIMAL(28,10), COLUMN180 VARCHAR(63), COLUMN181 DECIMAL(8,7), COLUMN182 VARCHAR(63), COLUMN183 DECIMAL(1,0), COLUMN184 VARCHAR(63), COLUMN185 VARCHAR(63), COLUMN186 VARCHAR(63), COLUMN187 VARCHAR(63), COLUMN188 DATE, COLUMN189 DATE, COLUMN190 VARCHAR(63), COLUMN191 TEXT(630), COLUMN192 DATE, COLUMN193 DATE, COLUMN194 DATE, COLUMN195 DATE, COLUMN196 VARCHAR(63), COLUMN197 VARCHAR(4), COLUMN198 VARCHAR(63), COLUMN199 VARCHAR(4), COLUMN200 DECIMAL(8,7), COLUMN201 VARCHAR(3), COLUMN202 DECIMAL(30,10), COLUMN203 VARCHAR(63), COLUMN204 VARCHAR(4), COLUMN205 VARCHAR(63), COLUMN206 VARCHAR(4), COLUMN207 DECIMAL(8,7), COLUMN208 VARCHAR(3), COLUMN209 DECIMAL(30,10), COLUMN210 DATE, COLUMN211 VARCHAR(63), COLUMN212 TEXT(630), COLUMN213 DATE, COLUMN214 VARCHAR(63), COLUMN215 TEXT(630), COLUMN216 VARCHAR(63), COLUMN217 TEXT(630), COLUMN218 VARCHAR(63), COLUMN219 VARCHAR(4), COLUMN220 VARCHAR(63), COLUMN221 VARCHAR(4), COLUMN222 VARCHAR(63), COLUMN223 VARCHAR(4), COLUMN224 VARCHAR(63), COLUMN225 VARCHAR(63), COLUMN226 TEXT(630), COLUMN227 DECIMAL(18,12), COLUMN228 VARCHAR(63), COLUMN229 DATE, COLUMN230 VARCHAR(63), COLUMN231 TEXT(630), COLUMN232 DATE, COLUMN233 DATE, COLUMN234 DATE, COLUMN235 DATE, COLUMN236 VARCHAR(3), COLUMN237 DECIMAL(30,10), COLUMN238 VARCHAR(3), COLUMN239 DECIMAL(30,10), COLUMN240 VARCHAR(3), COLUMN241 VARCHAR(3), COLUMN242 VARCHAR(63), COLUMN243 VARCHAR(40), COLUMN244 VARCHAR(80), COLUMN245 VARCHAR(63), COLUMN246 VARCHAR(40), COLUMN247 VARCHAR(80), COLUMN248 VARCHAR(3), COLUMN249 DECIMAL(30,10), COLUMN250 DATE, COLUMN251 VARCHAR(63), COLUMN252 TEXT(630), COLUMN253 VARCHAR(63), COLUMN254 VARCHAR(40), COLUMN255 VARCHAR(80), COLUMN256 VARCHAR(63), COLUMN257 VARCHAR(40), COLUMN258 VARCHAR(80), COLUMN259 VARCHAR(3), COLUMN260 DECIMAL(30,10), COLUMN261 DATE, COLUMN262 VARCHAR(63), COLUMN263 TEXT(630), COLUMN264 VARCHAR(63), COLUMN265 VARCHAR(40), COLUMN266 VARCHAR(80), COLUMN267 VARCHAR(63), COLUMN268 VARCHAR(40), COLUMN269 VARCHAR(80), COLUMN270 VARCHAR(3), COLUMN271 DECIMAL(30,10), COLUMN272 DATE, COLUMN273 VARCHAR(63), COLUMN274 TEXT(630), COLUMN275 VARCHAR(63), COLUMN276 VARCHAR(40), COLUMN277 VARCHAR(80), COLUMN278 VARCHAR(63), COLUMN279 VARCHAR(40), COLUMN280 VARCHAR(80), COLUMN281 VARCHAR(3), COLUMN282 DECIMAL(30,10), COLUMN283 DATE, COLUMN284 VARCHAR(63), COLUMN285 TEXT(630), COLUMN286 VARCHAR(63), COLUMN287 VARCHAR(40), COLUMN288 VARCHAR(80), COLUMN289 VARCHAR(63), COLUMN290 VARCHAR(40), COLUMN291 VARCHAR(80), COLUMN292 VARCHAR(3), COLUMN293 DECIMAL(30,10), COLUMN294 DATE, COLUMN295 VARCHAR(63), COLUMN296 TEXT(630), COLUMN297 VARCHAR(63), COLUMN298 VARCHAR(40), COLUMN299 VARCHAR(80), COLUMN300 VARCHAR(63), COLUMN301 VARCHAR(40), COLUMN302 VARCHAR(80), COLUMN303 VARCHAR(3), COLUMN304 DECIMAL(30,10), COLUMN305 DATE, COLUMN306 VARCHAR(63), COLUMN307 TEXT(630), COLUMN308 VARCHAR(63), COLUMN309 VARCHAR(255), COLUMN310 VARCHAR(3), COLUMN311 VARCHAR(3), CREATED_DATE DATETIME(6), ENTITY_ID VARCHAR(20), CONSTRAINT test_PK PRIMARY KEY (test_ID) ) ;
          Manasa ManasaTulluri added a comment -

          Some have suggested to increase the innodb_log_file_size.I have increased it to 10G , but still getting the same warning

          Warning 139 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

          Please let me know if innodb_log_file_size should be increased to a much higher value or if there is any other solution.

          innodb_data_file_path = ibdata1:12M:autoextend
          innodb_log_group_home_dir = /mariadb/data/
          innodb_log_files_in_group = 2
          innodb_log_file_size = 10G
          innodb_page_size = 16384
          innodb_log_buffer_size= 2G

          1. mariadb config
            feedback=off
            innodb_file_format_max='Barracuda'
            innodb_file_format='Barracuda'
            innodb_large_prefix='ON'
          1. new changes
            lower_case_table_names=1
            max_allowed_packet = 2G
            net_read_timeout = 60000
            autocommit = off
            transaction-isolation = READ-COMMITTED

          MariaDB [HKTR_DEV]> show variables like 'CHARACTER%'
          -> ;
          --------------------------------------------------------------+
          Variable_name Value
          --------------------------------------------------------------+
          character_set_client utf8
          character_set_connection utf8
          character_set_database utf8
          character_set_filesystem binary
          character_set_results utf8
          character_set_server latin1
          character_set_system utf8

          Manasa ManasaTulluri added a comment - Some have suggested to increase the innodb_log_file_size.I have increased it to 10G , but still getting the same warning Warning 139 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. Please let me know if innodb_log_file_size should be increased to a much higher value or if there is any other solution. innodb_data_file_path = ibdata1:12M:autoextend innodb_log_group_home_dir = /mariadb/data/ innodb_log_files_in_group = 2 innodb_log_file_size = 10G innodb_page_size = 16384 innodb_log_buffer_size= 2G mariadb config feedback=off innodb_file_format_max='Barracuda' innodb_file_format='Barracuda' innodb_large_prefix='ON' new changes lower_case_table_names=1 max_allowed_packet = 2G net_read_timeout = 60000 autocommit = off transaction-isolation = READ-COMMITTED MariaDB [HKTR_DEV] > show variables like 'CHARACTER%' -> ; --------------------------------------------------------------+ Variable_name Value --------------------------------------------------------------+ character_set_client utf8 character_set_connection utf8 character_set_database utf8 character_set_filesystem binary character_set_results utf8 character_set_server latin1 character_set_system utf8

          People

            Unassigned Unassigned
            monty Michael Widenius
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.