JIRA Standalone won't start

Erwan_5bk8zm

Hello,

Since 2 days, our JIRA standalone doesn't start.

Logs:

2018-12-22 08:26:32,274 JIRA-Bootstrap INFO [c.a.jira.startup.JiraHomeStartupCheck] The jira.home directory '/var/atlassian/application-data/jira' is validated and locked for exclusive use by this instance.
2018-12-22 08:26:32,286 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /var/atlassian/application-data/jira/dbconfig.xml
2018-12-22 08:26:32,432 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2018-12-22 08:26:32,432 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.
2018-12-22 08:26:33,393 JIRA-Bootstrap INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Product Name is MySQL
2018-12-22 08:26:33,393 JIRA-Bootstrap INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Product Version is 5.1.73
2018-12-22 08:26:33,393 JIRA-Bootstrap INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Driver Name is MySQL Connector Java
2018-12-22 08:26:33,393 JIRA-Bootstrap INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Driver Version is mysql-connector-java-5.1.39 ( Revision: 3289a357af6d09ecc1a10fd3c26e95183e5790ad )
2018-12-22 08:26:33,567 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Error getting column metadata for Error was:java.sql.SQLException: Incorrect information in file: './jira/AO_013613_WORK_ATTRIBUTE.frm'. Not checking columns.
2018-12-22 08:26:33,568 JIRA-Bootstrap WARN [o.o.c.entity.jdbc.DatabaseUtil] Entity "Action" has 11 fields but table "jiraaction" has 0 columns.
2018-12-22 08:26:33,568 JIRA-Bootstrap WARN [o.o.c.entity.jdbc.DatabaseUtil] Field "created" of entity "Action" is missing its corresponding column "CREATED"
2018-12-22 08:26:33,578 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Could not add column "CREATED" to table "jiraaction"
2018-12-22 08:26:33,578 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
ALTER TABLE jiraaction ADD CREATED DATETIME
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'CREATED'
2018-12-22 08:26:33,579 JIRA-Bootstrap WARN [o.o.c.entity.jdbc.DatabaseUtil] Field "updateauthor" of entity "Action" is missing its corresponding column "UPDATEAUTHOR"
2018-12-22 08:26:33,581 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Could not add column "UPDATEAUTHOR" to table "jiraaction"
2018-12-22 08:26:33,581 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
ALTER TABLE jiraaction ADD UPDATEAUTHOR VARCHAR(255)
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'UPDATEAUTHOR'
2018-12-22 08:26:33,581 JIRA-Bootstrap WARN [o.o.c.entity.jdbc.DatabaseUtil] Field "level" of entity "Action" is missing its corresponding column "actionlevel"
2018-12-22 08:26:33,583 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Could not add column "actionlevel" to table "jiraaction"
2018-12-22 08:26:33,583 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:


And a lot of the same errors...

We don't have never problem with Jira before.

Could you help me? Thanks a lot.

 

 

 

 

 

Nic Brough -Adaptavist-

This looks like the database is damaged - it is reporting missing columns and duplicates, plus an inability to modify it to try to fix it.  This suggests either the database has failed, something has gone awry with the permissions the jira-database user has, or it has been modified by something outside Jira.

I would want to identify what has been changed, or who broke the database, fix that, and then probably look to restore a backup from before the breakage.