error after deleting issue

Question

Dear all,

we are running this error, after deletting any issue.

Database:
- name:MySQL
- version:5.5.5-10.5.12-MariaDB-0+deb11u1
- minor version:5
- major version:5
Driver:
- name:MySQL Connector/J
- version:mysql-connector-java-8.0.27 (Revision: e920b979015ae7117d60d72bcc8f077a839cd791)

java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs.

Thanks for help.

Tomas Pekar · Answer

Thanks Fabio, for answer. Here is complete procedure:

1) backup all data!

mysqldump --max_allowed_packet=1024M -udebian-sys-maint -p jiradb > all-jiradb.sql

2) drop database

mysql -udebian-sys-maint -pXXX

DROP DATABASE jiradb;

/etc/init.d/mysql stop

3) delete /var/lib/mysql
ibdata1 and ib_logfile0

4) changing  innodb_page_size=32k

/etc/mysql/my.cfg
innodb_page_size=32k

/etc/init.d/mysql start

5) create database

mysql -udebian-sys-maint -pXXX

CREATE DATABASE IF NOT EXISTS `jiradb` ;
GRANT ALL PRIVILEGES ON `jiradb` . * TO 'jira'@'localhost';

6) restore data

mysql -udebian-sys-maint -pXXX -Djiradb < all-jiradb.sql

Fabio Racobaldo _Catworkx_ · Answer

Hi @Tomas Pekar ,

it seems an issue related to innodb_page_size  system variable. You should try to :

Stop JIRA

Increase that value https://mariadb.com/kb/en/how-to-change-innodb_page_size/#:~:text=Just%20export%20your%20data%2C%20move,with%20the%20smaller%20page%20size.

Start JIRA

My suggestion is to test it in a testing environment first.

Fabio