Problem with jira when starting

Yesterday i migrated my JIRA server from H2 database to mysql database, today i had to restart the server and now i'm getting this error when starting jira: 

Error occurred while starting component 'com.atlassian.jira.service.DefaultServiceManager'. caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, JOB_ID, JOB_RUNNER_KEY, SCHED_TYPE, INTERVAL_MILLIS, FIRST_RUN, CRON_EXPRESSION, TIME_ZONE, NEXT_RUN, VERSION, PARAMETERS FROM clusteredjob WHERE JOB_ID=? (Communications link failure The last packet successfully received from the server was 3,961 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.)

3 answers

just updating, the error has now changed 

Error occurred while starting component 'com.atlassian.jira.service.DefaultServiceManager'. caused by: org.ofbiz.core.entity.GenericDataSourceException: Unable to establish a connection with the database. (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)

 

i know this is related to the database connection, but when i run the config.sh the script says the connection test was successful.

It looks like one of the db entries related to one of your scheduled services is missing or corrupted.  If you go to Admin > System > Scheduler Details, you will see the list of scheduled jobs.  Within that list should be one called com.atlassian.jira.service.DefaultServiceManager and it should have at least 4 jobs in it.  If you "Show More", you should get the information about the jobs such as Last Run, Last Run Duration, Schedule and so forth.  One of these will have either a blank or corrupted Last Run time, or Next Run Time.  These jobs will typically equate to the jobs listed under Admin > System > Services.

Since the solution to that problem will be some form of updating the database directly, your safest solution will be to open a support ticket with Atlassian, that way they can give you the correct SQL queries needed. 

Sorry, if it is actually a connection problem, can you please list the contents of your dbconfig.xml file (minus the server info and credentials)?  There maybe a connection pool timeout that is set too short, or maybe the pool size is too small.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira Service Desk

How the Telegram Integration for Jira helps Sergey's team take their support efficiency to the bank

...+ reading Fantasy). The same is true for him at the bank he works for: Efficiency is key when time literally equals money. Read on to learn how Sergey makes most of the time he has by...

343 views 2 4
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you