It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Community showcase
Posted in Portfolio for Jira

Program managers, we need your help! We want to learn about how you plan work for a team of teams

Hi community members, My name is Erika and I’m a product manager at Atlassian. We’re currently investigating how teams are planning work at the program level. We understand that every team in a tea...

86 views 0 4
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you