Do we have to convert MySQL from MYISAM to InnoDB

Thomas Zöger August 31, 2017

We have our current version of confluence 6.2.1 upgraded to 6.3.3 and now we get an error

"MyISAM is configured as the default storage engine in your database, wh..."

 Problem there is, this system runs on a managed hosting server with no chance to change to innodb db environments. All tables are already innodb.

Question: is there a way to disable this innodb needed check?

otherwise we can not run confluence anymore.

kindly regards

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 31, 2017

No.  You must be using Innodb tables.

However, this is just a warning that your defaults are not suitable.  If your tables really are all Innodb for the confluence database, you can simply ignore it.

Thomas Zöger August 31, 2017

No it's not only a warning. after the startup was finished with running, the browser shows the following page:

 

Bildschirmfoto 2017-09-01 um 07.27.39.png

logfile contains:

..,803 ERROR [localhost-startStop-1] [atlassian.confluence.setup.BootstrapApplicationStartupListener] checkConfigurationOnStartup MyISAM is configured as the default storage engine in your database, which may result in data integrity issues. Please see http://confluence.atlassian.com/x/voTcDQ for more information.

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 1, 2017

Ah, right.  It is theoretically possible to run a set of databases differently, so it can be possible to set up one database with Innodb as the default and leave the *global* default as MyIsam, which gives you this as a warning. It's rare to do this, I'm only familiar with the global flag.

However in your case, it's set incorrectly for your database, not just globally. 

Your hosting provider needs to change the default to InnoDB for this database, or you will need to find a new host.

Thomas Zöger September 1, 2017

No, our hosting partner could not change our db environments for other reasons too. That is our problem we need to fix. It was running with 6.2.1 and 6.3.3 makes this problems. how to let confluence ignore this check?

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 1, 2017

You can't avoid the check.  The setting is *mandatory* for newer versions of confluence.  Confluence will fail without the correct setting.

Your hosting provider *must* change it.

Thomas Zöger September 1, 2017

ok so we need te use another tool, that's bad

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 1, 2017

Yes, you need to use a database that is configured to meet the requirements.

See https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html to see how to move on to a correctly configured database.

Thomas Zöger September 1, 2017

no we will leave the confluence tool and got to another documentation system cause we will not leave the serverprovider only because on parameter from confluence has changed from confluence 6.2.1 to 6.3.3.

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 1, 2017

Wow, you really want to cause yourself massive pains of migration because a service provider is too short-sighted or ill-equipped to provide a single, standard configuration setting?

Please forgive me for being harsh, but that sounds more than a little bit daft.

Seriously.  Finding a better service provider, even though you have to migrate, will be a lot easier, as it's "export, copy file, import".  Moving off Confluence could be a massive task.  Getting a decent provider and migrating is a lot smaller (And given the existing provider's miserable failure to support this makes me wonder where else they're failing).

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events