BODI-320009: Repositories on MySQL require InnoDB storage ..

dataservices administration
1

Hi,

I am getting following error while creating local repository on mysql database on linux machine.

BODI-320009: Repositories on MySQL require the InnoDB storage engine. Enable InnoDB in MySQL for the repository <MySQL.localhost.root>.

Please help.

its_ranjan (BOB member since 2011-02-16)

2

The repository database was probably created using the default MyISAM engine which isn’t transaction-safe.

Have the repository database recreated using the InnoDB storage engine in MySQL and you should be good to go.

ErikR :new_zealand: (BOB member since 2007-01-10)

3

Hi Erik,

Thanks for response.

Looked at the my.cnf file to check for default storage engine. It is innodb already.

datadir=/usr/local/mysql-5.7.11-linux-glibc2.5-x86_64/data/
log-error=/var/log/mysql/mysqld.err
socket=/tmp/mysql.sock
port = 3306
bind-address = 10.238.7.35
default-storage_engine=innodb
innodb_buffer_pool_size=10M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

its_ranjan (BOB member since 2011-02-16)

4

That may have been your default config file, but can you verify that the repository database was actually created in the correct storage engine?

If it was, I would log a call with SAP.

ErikR :new_zealand: (BOB member since 2007-01-10)

5

Hi, its_rajan.

I´m having the same situation here (trying to move a repository to MySQL).

Have you got any answer to this issue already?

Thanks!

mcotrim (BOB member since 2018-09-28)