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

Row size too large

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.22
    • 10.6
    • Galera, Server
    • None
    • redhat 8 on vmare

    Description

      We get the following errors:

      2025-08-21 19:44:22 6 [ERROR] Slave SQL: Error 'Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs' on query. Default database: 'ltxxps'. Query: '#SHOW CREATE TABLE xxxsubmissionlog;

      CREATE TABLE `archivexxxsubmissionlog2` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'' fie
      2025-08-21 19:44:22 6 [Warning] WSREP: Ignoring error 'Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs' on query. Default database: 'ltxxps'. Query: '#SHOW CREATE TABLE xxxsubmissionlog;

      CREATE TABLE `archivexxxsubmissionlog2` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'
      2025-08-21 19:45:01 2 [ERROR] Slave SQL: Error 'Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs' on query. Default database: 'ltxxps'. Query: 'CREATE TABLE `archivexxxsubmissionlog2` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'' field in this record.',
      `ContactPersonName
      2025-08-21 19:45:01 2 [Warning] WSREP: Ignoring error 'Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs' on query. Default database: 'ltxxps'. Query: 'CREATE TABLE `archivexxxsubmissionlog2` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'' field in this record.',
      `ContactPerso
      2025-08-21 19:46:34 7 [ERROR] Slave SQL: Error 'Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs' on query. Default database: 'ltxxps'. Query: 'CREATE TABLE `archivexxxsubmissionlog2` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'' field in this record.',
      `ContactPersonName
      2025-08-21 19:46:34 7 [Warning] WSREP: Ignoring error 'Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs' on query. Default database: 'ltxxps'. Query: 'CREATE TABLE `archivexxxsubmissionlog2` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'' field in this record.',
      `ContactPerso
      2025-08-21 19:46:52 6 [ERROR] Slave SQL: Error 'Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs' on query. Default database: 'ltxxps'. Query: 'CREATE TABLE `archivexxxsubmissionlog2` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'' field in this record.',
      `ContactPersonName
      2025-08-21 19:46:52 6 [Warning] WSREP: Ignoring error 'Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs' on query. Default database: 'ltxxps'. Query: 'CREATE TABLE `archivexxxsubmissionlog2` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'' field in this record.',
      `ContactPerso
      2025-08-21 19:49:02 16 [ERROR] Slave SQL: Error 'Table 'xxxsubmissionlog' already exists' on query. Default database: 'ltxxps'. Query: 'CREATE TABLE `xxxsubmissionlog` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'' field in this record.',
      `ContactPersonName` longtext DEFAULT NULL COMMENT 'N/A',
      `ContactPersonTel` longtext DEFAULT NULL COMMENT 'N/A',
      `ContactPersonEmail` longtext DEFAULT NULL COMMENT 'N/A',
      `
      2025-08-21 19:49:02 16 [Warning] WSREP: Ignoring error 'Table 'xxxsubmissionlog' already exists' on query. Default database: 'ltxxps'. Query: 'CREATE TABLE `xxxsubmissionlog` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'' field in this record.',
      `ContactPersonName` longtext DEFAULT NULL COMMENT 'N/A',
      `ContactPersonTel` longtext DEFAULT NULL COMMENT 'N/A',
      `ContactPersonEmail` longtext DEFAULT NULL COMMENT 'N/A',
      2025-08-21 19:49:11 13 [ERROR] InnoDB: Cannot add field `ExcelApName` in table `ltxxps`.`archivexxxsubmissionlog2` because after adding it, the row size is 8249 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
      2025-08-21 19:49:11 13 [ERROR] Slave SQL: Error '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.' on query. Default database: 'ltxxps'. Query: 'CREATE TABLE `archivexxxsubmissionlog2` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'' field in this record.',
      `ContactPersonName` longtext DEFAULT NULL COMMENT 'N/A',
      `ContactPers
      2025-08-21 19:49:11 13 [Warning] WSREP: Ignoring error '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.' on query. Default database: 'ltxxps'. Query: 'CREATE TABLE `archivexxxsubmissionlog2` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `LogDate` datetime(3) DEFAULT NULL,
      `IsProcessed` tinyint(1) NOT NULL DEFAULT 0,
      `Action` varchar(1) NOT NULL,
      `ECMSubmissionID` int(10) NOT NULL,
      `SubmissionTitle` longtext DEFAULT NULL,
      `ProjectID` int(11) NOT NULL,
      `ElectronicCaseFileID` int(11) NOT NULL COMMENT 'Pointer to case file table',
      `Status` int(11) NOT NULL COMMENT 'Pending = 10, supplement, ctr-11 Processing = 20, Completed = 30, Withdrawn = 40, Resubmitted = 50, WithdrawnAndResubmitted = 60',
      `SubmissionFolderID` int(11) DEFAULT NULL,
      `ECFFolderID` int(11) DEFAULT NULL COMMENT 'Create a folder as a Filio. Folio number use ''Foilio'' field in this record.',
      `ContactPersonName` longtext DEFAULT NULL COMMENT 'N/A',
      `Contac
      2025-08-21 19:51:11 12 [Warning] WSREP: BF applier thread=12 failed to open_and_lock_tables for Table 'ltxxps.archivexxxsubmissionlog2' doesn't exist, fatal: 0 wsrep = (exec_mode: 2 conflict_state: 0 seqno: 83445989)
      2025-08-21 19:51:11 12 [ERROR] Slave SQL: Error executing row event: 'Table 'ltxxps.archivexxxsubmissionlog2' doesn't exist', Internal MariaDB error code: 1146
      2025-08-21 19:51:11 12 [Warning] WSREP: Event 3 Write_rows_v1 apply failed: 1146, seqno 83445989

      Attachments

        Activity

          People

            Unassigned Unassigned
            Sandy LAM Sandy LAM
            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.