Redmine

I had this problem too, and it turned out I needed to update mariaDB to beta v10.2.5 from (10.0.?) to get the additional setting for innodb_default_row_format

In your mysql cnf file for mariaDB, add these lines:
innodb_file_format=Barracuda #default for >= 10.2.2
innodb_file_per_table=ON #default for >= 5.5
innodb_large_prefix=1 #default for >= 10.2.2
innodb_default_row_format=DYNAMIC #default for >= 10.2.2

These lines should all be default at this point, but since it started working, I just left it.

My system:
Environment:
Redmine version 3.3.3.stable.16539
Ruby version 2.2.5-p319 (2016-04-26) [x86_64-linux]
Rails version 4.2.7.1
Environment production
Database adapter Mysql2

Sorry for broken English.
I install the version of Redmine 3.4.3 on Debian 9.
The redmine version was downloaded here: https://www.redmine.org/releases/redmine-3.4.3.tar.gz

An error during the import of the database to the redmine database being installed is repeated exactly as described above:

== 28 CreateWikiPages: migrating ============================================ ==
- create_table (: wiki_pages)
   -> 0.0206s
- add_index (: wiki_pages, [: wiki_id,: title], {: name =>: wiki_pages_wiki_id_title})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2 :: Error: Index column size too large. The maximum column size is 767 bytes .: CREATE INDEX `wiki_pages_wiki_id_title` ON` wiki_pages` (`wiki_id`,` title`)

It is not possible to overcome this on my system:

Debian 9.
redmine 3.4.3.
ruby 2.3.3
rails 4.2.7.1
Environment production
Database adapter Mysql2

Modifying the /home/sat/Redmine/redmine-3.4.3/db/migrate/028_create_wiki_pages.rb file to the following:

 class CreateWikiPages < ActiveRecord::Migration
  def self.up
      create_table :wiki_pages , options: ' ROW_FORMAT=DYNAMIC ' do |t|
      t.column :wiki_id, :integer, :null => false
      t.column :title, :string, :limit => 255, :null => false
      t.column :created_on, :datetime, :null => false
    end
    add_index :wiki_pages, [:wiki_id, :title], :name => :wiki_pages_wiki_id_title
  end
  def self.down
    drop_table :wiki_pages
  end
end

I skipped migration to a similar problem:

 67 CreateWikiRedirects: migrating ==========================================
-- create_table(:wiki_redirects)
   -> 0.0205s
-- add_index(:wiki_redirects, [:wiki_id, :title], {:name=>:wiki_redirects_wiki_id_title})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: Index column size too large. The maximum column size is 767 bytes.: CREATE  INDEX `wiki_redirects_wiki_id_title`  ON `wiki_redirects` (`wiki_id`, `title`) 

Changed the file /home/sat/Redmine/redmine-3.4.3/db/migrate/067_create_wiki_redirects.rb
adding to it:

, options: ' ROW_FORMAT=DYNAMIC '

having resulted a line to a kind:

create_table :wiki_redirects , options: ' ROW_FORMAT=DYNAMIC ' do |t|

The database structure was imported, but there was an error importing data into this structure:

-- add_index(:changesets, [:repository_id, :revision], {:unique=>true, :name=>:changesets_repos_rev})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: Index column size too large. The maximum column size is 767 bytes.: CREATE UNIQUE INDEX `changesets_repos_rev`  ON `changesets` (`repository_id`, `revision`)

ups...

In the course of studying this problem, I found the following solution on the materials of this page: https://github.com/rails/rails/issues/9855#issuecomment-35618750

Created the file:

/home/sat/Redmine/redmine-3.4.3/config/initializers/ar_innodb_row_format.rb

With the following content:

ActiveSupport.on_load :active_record do
    module ActiveRecord::ConnectionAdapters
        class AbstractMysqlAdapter
            def create_table_with_innodb_row_format(table_name, options = {})
                table_options = options.reverse_merge(:options => 'ENGINE=InnoDB ROW_FORMAT=DYNAMIC')
                create_table_without_innodb_row_format(table_name, table_options) do |td|
                    yield td if block_given?
                end
            end
            alias_method_chain :create_table, :innodb_row_format
        end
    end
end

As a result, migration is performed completely:

• Invoke db:_dump (first_time)
• Execute db:_dump
• Invoke db:schema:dump (first_time)
• Invoke environment
• Invoke db:load_config
• Execute db:schema:dump

In the course of studying this problem, I found the following solution on the materials of this page: https://github.com/rails/rails/issues/9855#issuecomment-35618750

Created the file:

/home/sat/Redmine/redmine-3.4.3/config/initializers/ar_innodb_row_format.rb

With the following content:

ActiveSupport.on_load :active_record do
    module ActiveRecord::ConnectionAdapters
        class AbstractMysqlAdapter
            def create_table_with_innodb_row_format(table_name, options = {})
                table_options = options.reverse_merge(:options => 'ENGINE=InnoDB ROW_FORMAT=DYNAMIC')
                create_table_without_innodb_row_format(table_name, table_options) do |td|
                    yield td if block_given?
                end
            end
            alias_method_chain :create_table, :innodb_row_format
        end
    end
end

Changed my.conf:

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

adding to it:

innodb_large_prefix = 1
innodb_file_format = barracuda
innodb_file_per_table = 1

As a result, migration is performed completely:

• Invoke db:_dump (first_time)
• Execute db:_dump
• Invoke db:schema:dump (first_time)
• Invoke environment
• Invoke db:load_config
• Execute db:schema:dump

Stanislav Tilsh wrote:

Sorry for broken English.
I install the version of Redmine 3.4.3 on Debian 9.

What is version of MySQL or MariaDB?
Which do you use utf8 or utf8mb4?

Toshi MARUYAMA wrote:

What is version of MySQL or MariaDB?
Which do you use utf8 or utf8mb4?

mysql Ver 15.1 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

MariaDB [(none)]> SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

character_set_client utf8mb4
character_set_connection utf8mb4
character_set_database utf8mb4
character_set_filesystem binary
character_set_results utf8mb4
character_set_server utf8mb4
character_set_system utf8
collation_connection utf8mb4_general_ci
collation_database utf8mb4_general_ci
collation_server utf8mb4_general_ci

MariaDB [(none)]>

This patch did nothing here (Debian 9 - 4.9.30-2+deb9u5 (2017-09-19), Ruby 2.5.1, MySQL 10.1.26-MariaDB-0+deb9u1).

I had to recreate the database with the correct charset, as explained by Leslie in issue 54308

This solved the problem... Add this script redmine/config/initializers/mysqlpls.rb:

require 'active_record/connection_adapters/abstract_mysql_adapter'

module ActiveRecord
module ConnectionAdapters
class AbstractMysqlAdapter
NATIVE_DATABASE_TYPES[:string] = { :name => "varchar", :limit => 191 }
end
end
end

I would like to give credit to the person who came up with this solution... But I can't remember where I got it from.

Stanislav Tilsh wrote:

Created the file:

/home/sat/Redmine/redmine-3.4.3/config/initializers/ar_innodb_row_format.rb

With the following content:

ActiveSupport.on_load :active_record do
module ActiveRecord::ConnectionAdapters
class AbstractMysqlAdapter
def create_table_with_innodb_row_format(table_name, options = {})
table_options = options.reverse_merge(:options => 'ENGINE=InnoDB ROW_FORMAT=DYNAMIC')
create_table_without_innodb_row_format(table_name, table_options) do |td|
yield td if block_given?
end
end
alias_method_chain :create_table, :innodb_row_format
end
end
end

As a result, migration is performed completely:

• Invoke db:_dump (first_time)
• Execute db:_dump
• Invoke db:schema:dump (first_time)
• Invoke environment
• Invoke db:load_config
• Execute db:schema:dump

THX! this is still needed on my ubuntu 18.04 installation with mariadb from the repos...!