JIRA H2 Database: Could not successfully test your database
0
Unfortunately, our VM rebooted automatically. As a result JIRA shutdown
in an abrupt manner. When we tried to restart JIRA, tomcat is starting but we are unable to access JIRA via web browser.
We deleted catalina.pid & .jira-home.lock file. Yet, JIRA is not starting up.
We are getting the following error:
2018-11-14 14:10:40,508 JIRA-Bootstrap ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
org.h2.jdbc.JdbcSQLException: Database may be already in use: "/app/atlassian/application-data/jira/database/h2db.mv.db". Possible solutions: close all other connection(s); use the server mode [90020-185]
From the logs it looks like a DB issue, and I don't know how to find if DB is receiving connections.
Can we kill the PID related with JIRA and restart JIRA?
Regards
tomcat jira h2
asked Nov 14 '18 at 10:26
KrisTKrisT
143212
|
show 1 more comment
0
Unfortunately, our VM rebooted automatically. As a result JIRA shutdown
in an abrupt manner. When we tried to restart JIRA, tomcat is starting but we are unable to access JIRA via web browser.
We deleted catalina.pid & .jira-home.lock file. Yet, JIRA is not starting up.
We are getting the following error:
2018-11-14 14:10:40,508 JIRA-Bootstrap ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
org.h2.jdbc.JdbcSQLException: Database may be already in use: "/app/atlassian/application-data/jira/database/h2db.mv.db". Possible solutions: close all other connection(s); use the server mode [90020-185]
From the logs it looks like a DB issue, and I don't know how to find if DB is receiving connections.
Can we kill the PID related with JIRA and restart JIRA?
Regards
tomcat jira h2
asked Nov 14 '18 at 10:26
KrisTKrisT
143212
Maybe look for and remove the H2 lock file? See stackoverflow.com/a/29058294/2220556. Also, H2 is only supported for evaluation purposes. If there is any data in Jira you care about, you really should configure it to use an external production dB.
– Scott Dudley
Nov 14 '18 at 14:23
@ScottDudley I browsed but didn’t find db lock file. Is there a way to migrate JIRA’s H2 data to Oracle DB or MSSQL?
– KrisT
Nov 14 '18 at 15:27
Yes, XML export, set up the new DB, XML import. For smaller Jira DBs at least.
– mdoar
Nov 14 '18 at 17:50
I assume you looked for a lock file in /app/atlassian/application-data/jira/database/? You might also try accessing the dB directly to see if it works (confluence.atlassian.com/jirakb/…). @mdoar's suggestion is the way to go for migration, but it admittedly requires that you first be able to start your instance while still running H2.
– Scott Dudley
Nov 14 '18 at 18:15
@ScottDudley Yes, I was looking in that folder. And regarding migration, I am unable to restart JIRA. So can’t I import?
– KrisT
Nov 15 '18 at 1:33
|
show 1 more comment
0
0
0
Unfortunately, our VM rebooted automatically. As a result JIRA shutdown
in an abrupt manner. When we tried to restart JIRA, tomcat is starting but we are unable to access JIRA via web browser.
We deleted catalina.pid & .jira-home.lock file. Yet, JIRA is not starting up.
We are getting the following error:
2018-11-14 14:10:40,508 JIRA-Bootstrap ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
org.h2.jdbc.JdbcSQLException: Database may be already in use: "/app/atlassian/application-data/jira/database/h2db.mv.db". Possible solutions: close all other connection(s); use the server mode [90020-185]
From the logs it looks like a DB issue, and I don't know how to find if DB is receiving connections.
Can we kill the PID related with JIRA and restart JIRA?
Regards
tomcat jira h2
asked Nov 14 '18 at 10:26
KrisTKrisT
143212
Unfortunately, our VM rebooted automatically. As a result JIRA shutdown
in an abrupt manner. When we tried to restart JIRA, tomcat is starting but we are unable to access JIRA via web browser.
We deleted catalina.pid & .jira-home.lock file. Yet, JIRA is not starting up.
We are getting the following error:
2018-11-14 14:10:40,508 JIRA-Bootstrap ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
org.h2.jdbc.JdbcSQLException: Database may be already in use: "/app/atlassian/application-data/jira/database/h2db.mv.db". Possible solutions: close all other connection(s); use the server mode [90020-185]
From the logs it looks like a DB issue, and I don't know how to find if DB is receiving connections.
Can we kill the PID related with JIRA and restart JIRA?
Regards
tomcat jira h2
tomcat jira h2
asked Nov 14 '18 at 10:26
KrisTKrisT
143212
asked Nov 14 '18 at 10:26
KrisTKrisT
143212
asked Nov 14 '18 at 10:26
KrisTKrisT
143212
asked Nov 14 '18 at 10:26
KrisTKrisT
143212
asked Nov 14 '18 at 10:26
KrisTKrisT
143212
143212
Maybe look for and remove the H2 lock file? See stackoverflow.com/a/29058294/2220556. Also, H2 is only supported for evaluation purposes. If there is any data in Jira you care about, you really should configure it to use an external production dB.
– Scott Dudley
Nov 14 '18 at 14:23
@ScottDudley I browsed but didn’t find db lock file. Is there a way to migrate JIRA’s H2 data to Oracle DB or MSSQL?
– KrisT
Nov 14 '18 at 15:27
Yes, XML export, set up the new DB, XML import. For smaller Jira DBs at least.
– mdoar
Nov 14 '18 at 17:50
I assume you looked for a lock file in /app/atlassian/application-data/jira/database/? You might also try accessing the dB directly to see if it works (confluence.atlassian.com/jirakb/…). @mdoar's suggestion is the way to go for migration, but it admittedly requires that you first be able to start your instance while still running H2.
– Scott Dudley
Nov 14 '18 at 18:15
@ScottDudley Yes, I was looking in that folder. And regarding migration, I am unable to restart JIRA. So can’t I import?
– KrisT
Nov 15 '18 at 1:33
|
show 1 more comment
Maybe look for and remove the H2 lock file? See stackoverflow.com/a/29058294/2220556. Also, H2 is only supported for evaluation purposes. If there is any data in Jira you care about, you really should configure it to use an external production dB.
– Scott Dudley
Nov 14 '18 at 14:23
@ScottDudley I browsed but didn’t find db lock file. Is there a way to migrate JIRA’s H2 data to Oracle DB or MSSQL?
– KrisT
Nov 14 '18 at 15:27
Yes, XML export, set up the new DB, XML import. For smaller Jira DBs at least.
– mdoar
Nov 14 '18 at 17:50
I assume you looked for a lock file in /app/atlassian/application-data/jira/database/? You might also try accessing the dB directly to see if it works (confluence.atlassian.com/jirakb/…). @mdoar's suggestion is the way to go for migration, but it admittedly requires that you first be able to start your instance while still running H2.
– Scott Dudley
Nov 14 '18 at 18:15
@ScottDudley Yes, I was looking in that folder. And regarding migration, I am unable to restart JIRA. So can’t I import?
– KrisT
Nov 15 '18 at 1:33
Maybe look for and remove the H2 lock file? See stackoverflow.com/a/29058294/2220556. Also, H2 is only supported for evaluation purposes. If there is any data in Jira you care about, you really should configure it to use an external production dB.
– Scott Dudley
Nov 14 '18 at 14:23
Maybe look for and remove the H2 lock file? See stackoverflow.com/a/29058294/2220556. Also, H2 is only supported for evaluation purposes. If there is any data in Jira you care about, you really should configure it to use an external production dB.
– Scott Dudley
Nov 14 '18 at 14:23
@ScottDudley I browsed but didn’t find db lock file. Is there a way to migrate JIRA’s H2 data to Oracle DB or MSSQL?
– KrisT
Nov 14 '18 at 15:27
@ScottDudley I browsed but didn’t find db lock file. Is there a way to migrate JIRA’s H2 data to Oracle DB or MSSQL?
– KrisT
Nov 14 '18 at 15:27
Yes, XML export, set up the new DB, XML import. For smaller Jira DBs at least.
– mdoar
Nov 14 '18 at 17:50
Yes, XML export, set up the new DB, XML import. For smaller Jira DBs at least.
– mdoar
Nov 14 '18 at 17:50
I assume you looked for a lock file in /app/atlassian/application-data/jira/database/? You might also try accessing the dB directly to see if it works (confluence.atlassian.com/jirakb/…). @mdoar's suggestion is the way to go for migration, but it admittedly requires that you first be able to start your instance while still running H2.
– Scott Dudley
Nov 14 '18 at 18:15
I assume you looked for a lock file in /app/atlassian/application-data/jira/database/? You might also try accessing the dB directly to see if it works (confluence.atlassian.com/jirakb/…). @mdoar's suggestion is the way to go for migration, but it admittedly requires that you first be able to start your instance while still running H2.
– Scott Dudley
Nov 14 '18 at 18:15
@ScottDudley Yes, I was looking in that folder. And regarding migration, I am unable to restart JIRA. So can’t I import?
– KrisT
Nov 15 '18 at 1:33
@ScottDudley Yes, I was looking in that folder. And regarding migration, I am unable to restart JIRA. So can’t I import?
– KrisT
Nov 15 '18 at 1:33
|
show 1 more comment
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53297962%2fjira-h2-database-could-not-successfully-test-your-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53297962%2fjira-h2-database-could-not-successfully-test-your-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Maybe look for and remove the H2 lock file? See stackoverflow.com/a/29058294/2220556. Also, H2 is only supported for evaluation purposes. If there is any data in Jira you care about, you really should configure it to use an external production dB.
– Scott Dudley
Nov 14 '18 at 14:23
@ScottDudley I browsed but didn’t find db lock file. Is there a way to migrate JIRA’s H2 data to Oracle DB or MSSQL?
– KrisT
Nov 14 '18 at 15:27
Yes, XML export, set up the new DB, XML import. For smaller Jira DBs at least.
– mdoar
Nov 14 '18 at 17:50
I assume you looked for a lock file in /app/atlassian/application-data/jira/database/? You might also try accessing the dB directly to see if it works (confluence.atlassian.com/jirakb/…). @mdoar's suggestion is the way to go for migration, but it admittedly requires that you first be able to start your instance while still running H2.
– Scott Dudley
Nov 14 '18 at 18:15
@ScottDudley Yes, I was looking in that folder. And regarding migration, I am unable to restart JIRA. So can’t I import?
– KrisT
Nov 15 '18 at 1:33