Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

i'm stuck at application setup step during JIRA configuration

Wajahat Gul January 2, 2019

i have installed jira server 7.13 it successfully installed and database test connection was successful when i submit the form it took so long and then it stopped after refereshing of page it move to application setup wizard but i'm stuck there because i'm not able to move to next step  here is the exception in jira log:

2019-01-02 09:50:58,024 http-nio-8089-exec-23 ERROR anonymous 580x200x1 w7mgh7 0:0:0:0:0:0:0:1 /secure/SetupDatabase.jspa [c.a.jira.startup.JiraStartupLogger] Cannnot obtain JIRA system information
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT COUNT(P.ID) FROM project P (Table 'jiradb.project' doesn't exist)
    at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCountByAnd(DefaultOfBizDelegator.java:379)
    at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCount(DefaultOfBizDelegator.java:368)
    at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.getCount(WrappingOfBizDelegator.java:224)
    at com.atlassian.jira.startup.JiraSystemInfo.obtainDatabaseStatistics(JiraSystemInfo.java:334)
    at com.atlassian.jira.startup.JiraStartupLogger.printStartedMessage(JiraStartupLogger.java:128)
    at com.atlassian.jira.upgrade.ConsistencyCheckerImpl.printJIRAStartupMessage(ConsistencyCheckerImpl.java:200)
    at com.atlassian.jira.upgrade.ConsistencyCheckerImpl.initialise(ConsistencyCheckerImpl.java:185)
    at com.atlassian.jira.startup.DefaultJiraLauncher.postDBActivated(DefaultJiraLauncher.java:164)
    at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:144)
    at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.runPostDbSetupRunnables(DatabaseConfigurationManagerImpl.java:286)
    at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.activateDatabase(DatabaseConfigurationManagerImpl.java:279)
    at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.activateDatabase(DatabaseConfigurationManagerImpl.java:243)
    at com.atlassian.jira.web.action.setup.SetupDatabase.doExecute(SetupDatabase.java:207)
    ... 1 filtered
    at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
    ... 7 filtered
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    ... 45 filtered
    at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
    ... 1 filtered
    at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
    ... 31 filtered
    at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
    ... 24 filtered
    at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
    ... 24 filtered
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT COUNT(P.ID) FROM project P (Table 'jiradb.project' doesn't exist)
    at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:533)
    at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:877)
    at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:857)
    at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:795)
    at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:775)
    at org.ofbiz.core.entity.GenericDelegator.findByCondition(GenericDelegator.java:1091)
    at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCountByAnd(DefaultOfBizDelegator.java:375)
    ... 155 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jiradb.project' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
    at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:527)
    ... 162 more

1 answer

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 2, 2019

It looks to me like the database user either did not have the rights to create all the tables it needed during setup, or it does not have the rights to see the data in the database.

I would read the logs from when you ran setup to see what errors are in there, and check that your database user has all the right privileges in the database (i.e. try logging in with a command line tool and check the tables exist and are visible to that user)

Wajahat Gul January 2, 2019

jiradbuser have all the privileges for jiradb and there are multiple exception for creating table and selecting records from table in log file

Wajahat Gul January 2, 2019
01114:10:24CREATE TABLE project1 (ID DECIMAL(18,0) NOT NULL, pname VARCHAR(255), URL VARCHAR(255), LEAD VARCHAR(255), DESCRIPTION TEXT, pkey VARCHAR(255), pcounter DECIMAL(18,0), ASSIGNEETYPE DECIMAL(18,0), AVATAR DECIMAL(18,0), ORIGINALKEY VARCHAR(255), PROJECTTYPE VARCHAR(255), CONSTRAINT PK_project PRIMARY KEY (ID))Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEAD VARCHAR(255), DESCRIPTION TEXT, pkey VARCHAR(255), pcounter DECIMAL(18,0), ' at line 10.000 sec

above table shows the output that i get after testing on of the query from log that shown exception

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 2, 2019

Ok, so the setup failed because of something wrong in the database connection.

What database driver are you using, and is the version of MySQL right for Jira 7.13?

Wajahat Gul January 2, 2019

Mysql workbench 8.0

Driver mysql-java 8.0.13

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 2, 2019

But what version of MySQL is it?  (Workbench is a client, not a server)

Wajahat Gul January 2, 2019

Server version: 8.0.13 mysql community server gpl

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 2, 2019

Ok, that answers it - that version is not supported by Jira 7.13.  Try installing it on a supported database - see https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html

Like Shannon S likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events