I am facing issue while connecting with JIRA

[Abhijit Dongre]

ERROR:

Database: JIRA couldn't connect to your database

HOW TO CHECK DATABASE IS RUNNING?

[Abhijit Dongre]

please help on below exception:

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]

[Nic Brough -Adaptavist-]

What do the logs say the connection problem is?

[PVS]

That Is the Over Rite the Plugin data Problem 

[PVS]

May I know the Which Data Base Your Using 

Thanks,

PVS

[Abhijit Dongre]

It is self managed,

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>h2</database-type>
<schema-name>PUBLIC</schema-name>

Error Logs:

2019-06-03 15:32:28,816 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from C:\Program Files\Atlassian\Application Data\JIRA\dbconfig.xml
2019-06-03 15:32:29,222 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]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:295)
at org.h2.engine.Database.openDatabase(Database.java:297)
at org.h2.engine.Database.<init>(Database.java:260)

[PVS]

One Do those All Steps And Clear Data 

[PVS]

As the JIRA application starts up, it goes through the following steps when starting the Plugin System:

1. $JIRA_INSTALL/atlassian-jira/WEB-INF/classes/atlassian-bundled-plugins.zip is extracted to $JIRA_HOME/plugins/.bundled-plugins.
2. $JIRA_HOME/plugins/installed-plugins is extracted to $JIRA_HOME/plugins/.osgi-plugins.

This is a fairly resource intensive process and can place a sizeable load on the I/O of the disk and CPU of the machine that is hosting the JIRA application instance. If the required resources aren't available, the plugins may timeout and cause the application to be left in an unusable state.

[Abhijit Dongre]

will you please mention the file locations to do below steps

Clear Cache

Delete Lock File

Delete  PLugin .osgi-plugins and .bundled-plugins 

[PVS]

1. C:\Program Files\Atlassian\Application Data\JIRA\plugins

[PVS]

[Abhijit Dongre]

yes I deleted .lock file and below folders

.osgi-plugins

.bundled-plugins.

but still it is giving same error:

[PVS]

Your Using  Trial  Jia  

[Abhijit Dongre]

no, it is licensed one and self managed JIRA software.

[PVS]

AFTER DELETING THE data Its Work Properly I have also Facing the Same issue my JIra after its Clear Its Working I am Using the PostgreSQL  database

[PVS]

 Hi @Abhijit Dongre 

First You Will Shutdown Jira And Go to Application Folder And Clear Cache And Delete Lock File Ann Delete  PLugin .osgi-plugins and .bundled-plugins after That Open Data base  Its Running or Not U can check When Its Running U can Restart The jira U Can do Success Fully Doing This that time jira is not Showing the Error That is the .Error  

Thanks ,

Venkatesh Penumuchu