[SOLVED] Fix a problem installing ITSM bundle with MySQL 5.6

[Giulio Soleni]

Hi,
I would like to share this info with the community:

I recently tried to install the last available stable release (otrs 3.3.10) with ITSM bundle on CentOS release 6.6 with MySQL 5.6 and InnoDB engine.

The installation of OTRS went fine, but as soon as I tried to install ITSM bundle I got this error:

Code: Select all

[otrs@x-otrs bin]$ ./otrs.PackageManager.pl -a install -p /otrs_bck/bck_config/ver3.3.10/ITSM-3.3.10.opm
Notice: Install /opt/otrs/Kernel/Config/Files/FrameworkITSM.xml (644)!
Notice: Create Directory /opt/otrs/var/packagesetup!
Notice: Create Directory /opt/otrs/var/packagesetup/ITSM!
Notice: Install /opt/otrs/var/packagesetup/ITSM/GeneralCatalog.opm (644)!
Notice: Install /opt/otrs/var/packagesetup/ITSM/ImportExport.opm (644)!
Notice: Install /opt/otrs/var/packagesetup/ITSM/ITSMChangeManagement.opm (644)!
Notice: Install /opt/otrs/var/packagesetup/ITSM/ITSMConfigurationManagement.opm (644)!
Notice: Install /opt/otrs/var/packagesetup/ITSM/ITSMCore.opm (644)!
Notice: Install /opt/otrs/var/packagesetup/ITSM/ITSMIncidentProblemManagement.opm (644)!
Notice: Install /opt/otrs/var/packagesetup/ITSM/ITSMServiceLevelManagement.opm (644)!
Notice: Install /opt/otrs/var/packagesetup/ITSM.pm (644)!
[Sat Nov  8 23:04:16 2014] otrs.PackageManager.pl: DBD::mysql::db do failed: 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. at /opt/otrs/Kernel/System/DB.pm line 499.
ERROR: OTRS-otrs.PackageManager.pl-10 Perl: 5.10.1 OS: linux Time: Sat Nov  8 23:04:16 2014

 Message: 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., SQL: 'INSERT INTO package_repository (name, version, vendor, filename,  content_size, content_type, content, install_status,  create_time, create_by, change_time, change_by) VALUES  (?, ?, ?, ?, '213', 'text/xml', ?, 'not installed',
        '2014-11-08 23:04:16'
    , 1,
        '2014-11-08 23:04:16'
    , 1)'

 Traceback (2902):
   Module: Kernel::System::Package::RepositoryAdd (OTRS 3.3.10) Line: 359
   Module: Kernel::System::Package::PackageInstall (OTRS 3.3.10) Line: 522
   Module: ./otrs.PackageManager.pl (unknown version) Line: 353

googling I found this in MySQL documentation: http://dev.mysql.com/doc/refman/5.6/en/ ... _file_size

Specifically this document reports that to address Bug #69477 in MySQL...

a patch introduced in MySQL 5.6.20 limits the size of redo log BLOB writes to 10% of the redo log file size. As a result of this limit, innodb_log_file_size should be set to a value greater than 10 times the largest BLOB data size found in the rows of your tables plus the length of other variable length fields.

Therefore I set

Code: Select all

innodb_log_file_size = 256M

in /etc/my.cnf and I restarted mysql.

I could then install ITSM bundle without any other issue.

Hope this may help.

[parvez]

I am also facing same problem but where to find /etc/my.cnf. I am using windows server 2008r2

[Giulio Soleni]

Hi,
I have not so much experience of MySQL in Windows, but I think you might look for my.ini instead of my.cnf.
Take a look here: http://stackoverflow.com/questions/4292 ... in-windows