nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Not able to connect JIRA

Abhijit Dongre

2019-06-04 11:27:43,678 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from C:\Program Files\Atlassian\Application Data\JIRA\dbconfig.xml
2019-06-04 11:27:44,059 JIRA-Bootstrap ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: File corrupted in chunk 28589, expected page length =< 192, got 1728392960 [1.4.185/6]" [50000-185]

Accepted answers

All comments

Dave Bosman _Inetum_

Hi @Abhijit Dongre

Is this the first time that you are connecting to the database or is this a an existing setup?

Could you please give some extra context. What is the current setup (OS, DB)? what did you exactly do before getting this issue? What did you already try to solve this problem?

Regards

Dave

Abhijit Dongre

Hi Dave,

kindly find below the details

1. This is not first time I am connecting to DB, it was properly working earlier but due to holidays, installed JIRA server was off for 3 days, but when we try to run again it started to give Database connectivity issue.

2. OS is Windows 10 and database is H2

3. Below steps I tried to resolve it, but still same issue

i. I have deleted files: .jira-home.lock, .bundled-plugins and .osgi-plugins by stopping and restarting Atlassian JIRA service

ii. Deleted Cache folder: Atlassian\Application Data\JIRA\caches

Please refer below screenshot

Dave Bosman _Inetum_

Hi @Abhijit Dongre

I believe the steps you did to resolve it are not the problem.

But are you using it as a production instance or is it just to evaluate Jira?

The reason why i ask is because the internal H2 database is not really supported and should only be used for evaluating jira.

So everything was working before but after a stop - start it does not work anymore.

About your log entries.

2019-06-04 11:27:44,059 JIRA-Bootstrap ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:

This one confused me because if i would have to guess, it seems that there is a connection problem.

But then you have following entry that looks like you have a corrupted database.

org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: File corrupted in chunk 28589, expected page length =< 192, got 1728392960 [1.4.185/6]" [50000-185]

So knowing what happend now it seems to me that you indeed have a corrupted database.

If you are using it as a production instance, I presume (hope) you have a backup of the data because this can not be fixed for as far as i know.

You should install a decent database like MySQL or Postgres. Connect Jira to the new database and import your backup again.

Regards

Dave

Abhijit Dongre

Thanks Dave, for your analysis.

I will be grateful to you if you could guide me on below points

1. How to setup MYSQL/Postgres and how to connect it to JIRA

2. Where I can find backup and How to import it,

currently I am see exports under C:\Program Files\Atlassian\Application Data\JIRA\export and there are .zip files which contains activeobjects.xml and entities.xml

Abhijit Dongre

Hi Dave, I am now succeed to connect JIRA and MySQL, also imported previous data.

But now once I logged into JIRA, it is showing error popup as "Your licenses' user limits are exceeded. Users may not be able to create issues until you have upgraded your licenses or reduced the number of users."

I have deleted user entry from database from tables: cwd_user, cwd_user_attributes, cwd_membership, app_user

But still it is showing same error, kindly refer screenshot

Abhijit Dongre

Hi Dave, I have un-installed MySQL and installed 5.6 version and it worked fine, thanks.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server