Confluence startup failed

[armstrong hao]

Help！Help,Help！

Background:

1.Yesterday，I try to update the admin account by mysql update command (once use the kill 9  to stop the mysql servervice) due to forgot the admin password.

2.The confluence which we bulid did not have do the backup policy .

And now, issues :

1.can not startup the confluence service ;

   error log：

[confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
2022-01-18 14:35:10,432 ERROR [AtlassianEvent::CustomizableThreadFactory-2] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Communications link failure

2.After check the mysql datatbase, found some tables  are broken，can not be uesd;

3.i try to recovery the tables with command：innodb_force_recovery= 6

what should i do now？

[Pramodh M]

Hi @armstrong hao 

Create a New Database in MySQL & connect with Confluence (Remove the confluence.cfg.xml File in Home directory and restart the Application)

Reference here

https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

(Remember to download the driver)

If you are running MySQL 5.6 or 5.7

CREATE USER 'confuser'@'%' IDENTIFIED BY 'Admin1234.';
CREATE DATABASE confdb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL ON confdb.* TO 'confuser'@'%';

If you are running MySQL 8

CREATE USER 'confuser'@'%' IDENTIFIED BY 'Admin1234.';
CREATE DATABASE confdb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
GRANT ALL ON confdb.* TO 'confuser'@'%';

Let me know if this works for you

Thanks,
Pramodh