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; } } }

Very frustrated new user

Justin Kelly

JIRA support,

No matter what I have done I am having trouble with my self-hosted installation. I have re-installed JIRA and MySQL multiple times. My first post about my issues was marked SPAM for some reason which is unacceptable. I am looking for real customer support.

I have had a positive experience with JIRA before. But the software keeps giving me HTTP 500 errors when I click on Issues or View All Boards. After my latest re-install I get a 500 error when I select the project I created.

If this cannot be resolved I am going to abandon Atlassian JIRA and I will not carry with my a positive message to anyone that asks me about it going forward. I appreciate the <10 user $10 a year license but if it doesn't work, it has no worth and shouldn't even be available.

This issue has taken hours from my schedule of continuing to get anything truly productive done. I've re-installed MySQL and Jira multiple times.

Versions, as recommended by your own site....Jira 7.7.1, MySQL Server 5.7, mysql-connector-java-5.1.45-bin.jar

The JIRA software seems to have issues with HTTP 500 in multiple cases from the local machine, not even trying to access it from another machine. Why??!??!?!

Please help,

Justin Kelly

Accepted answers

Justin Kelly

The following resolved my issue, hopefully this will help anyone that experiences the project creation errors and the "table already exists" errors I saw.

As odd as it sounds, it related to HipChat integration settings when I don't have or need Hipchat.

I started here:

https://community.atlassian.com/t5/Jira-Software-questions/Crashes-at-creating-a-project/qaq-p/651662

and followed what it says here:

https://confluence.atlassian.com/confkb/how-to-disable-hipchat-integration-pop-up-dialog-794500518.html

I searched for anything "hipchat" while on the system "manage add-ons" page and disabled all of them.

Once I did this, I was able to create a new Jira project with no errors that occur or when I click on anything or select any options within the Jira application. It finally works!

Just a guess...the initial project creation error related to hipchat somehow left things in a half-baked state. No idea, but it works now.

All comments

Jobin Kuruvilla [Adaptavist]

Check out the answer on your original question: https://community.atlassian.com/t5/Jira-Software-questions/Problems-accessing-Issues-and-View-All-Boards/qaq-p/731007

Hope that helps!

Nic Brough -Adaptavist-

Http 500 is a simple web error meaning the server hasn't responded correctly.

We'll need to read the application log to see what the server side error problem is.

Justin Kelly

Thanks much for all of the responses @Jobin Kuruvilla [Adaptavist] and @Nic Brough -Adaptavist-.

I will work with the information that @Jobin sent in his first replies and go from there.

Justin Kelly

Well I am still seeing the errors even though my Jira MySql user has a grant for REFERENCES.

Specifically, I can view the dashboard and some other areas but when I do anything with Issues, I get an error (shown as HTTP 500 on the surface). And, when I click on "View All Boards" I still get a spinner icon that seems to hang.

The SHOW GRANTS results for the Jira user (jirauser) shown at the end of this post, followed by an error/stack trace from the Jira stdout log in the C:\Program Files\Atlassian\JIRA\logs folder.

Versions I am using:

- Windows: v10 Pro 64-bit, latest build

- MySQL: community-5.7.21.0

- JDBC driver in Jira lib folder: mysql-connector-java-5.1.45-bin.jar

- Jira Version: 7.7.1

GRANTS

mysql> show grants for 'jirauser'@'%';
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for jirauser@% |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON *.* TO 'jirauser'@'%' WITH GRANT OPTION |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `mysql`.* TO 'jirauser'@'%'

ERROR INFO

Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:MySQL
- version:5.7.21
- minor version:7
- major version:5
- name:MySQL Connector Java
- version:mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ao_e8b6cc_issue_mapping' already exists
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:53)
at com.atlassian.jira.plugins.dvcs.activeobjects.PropertyMigrator.upgrade(PropertyMigrator.java:40)
at com.atlassian.activeobjects.internal.ActiveObjectUpgradeManagerImpl$1.doInTransaction(ActiveObjectUpgradeManagerImpl.java:68)
at com.atlassian.activeobjects.internal.ActiveObjectUpgradeManagerImpl$1.doInTransaction(ActiveObjectUpgradeManagerImpl.java:64)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:21)
at com.atlassian.jira.DefaultHostContextAccessor.doInTransaction(DefaultHostContextAccessor.java:34)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
at com.sun.proxy.$Proxy36.doInTransaction(Unknown Source)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:136)
at com.sun.proxy.$Proxy36.doInTransaction(Unknown Source)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at com.sun.proxy.$Proxy3467.execute(Unknown Source)
at com.atlassian.activeobjects.internal.SalTransactionManager.inTransaction(SalTransactionManager.java:42)
at com.atlassian.activeobjects.internal.AbstractLoggingTransactionManager.doInTransaction(AbstractLoggingTransactionManager.java:16)
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.executeInTransaction(EntityManagedActiveObjects.java:204)
at com.atlassian.activeobjects.internal.ActiveObjectUpgradeManagerImpl.upgrade(ActiveObjectUpgradeManagerImpl.java:64)
at com.atlassian.activeobjects.internal.ActiveObjectUpgradeManagerImpl.upgrade(ActiveObjectUpgradeManagerImpl.java:36)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.upgrade(AbstractActiveObjectsFactory.java:87)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:67)
at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:32)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:91)
... 6 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ao_e8b6cc_issue_mapping' already exists
at sun.reflect.GeneratedConstructorAccessor54.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480)
at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1552)
at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2607)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1480)
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:234)
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:234)
at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2246)
at net.java.ao.DatabaseProvider.executeUpdateForAction(DatabaseProvider.java:2302)
at net.java.ao.DatabaseProvider.executeUpdatesForActions(DatabaseProvider.java:2274)
at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:91)
at net.java.ao.EntityManager.migrate(EntityManager.java:128)
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:51)
... 51 more

Justin Kelly

@Jobin Kuruvilla [Adaptavist] or @Nic Brough -Adaptavist- do you think this is a JDBC driver version issue? Why would the Issues table already exist -- I had completely re-installed both MySQL and Jira. Should I fall back to an earlier version of any of the software (Jira, MySQL or JDBC driver)? Are the versions I am using known to be compatible?

Thanks for any help.

Nic Brough -Adaptavist-

No, I don't think it's the driver. I think there's a wider picture we are missing.

You are talking about errors on the front-end a lot, but I'm not 100% clear on when they happen. You say you've tried re-installing several times, but not exactly what you cleared out.

When you re-install, did you start "clean"?

Deleted the whole of /opt/atlassian/jira (assuming that's where you installed it)
Deleted /etc/init.d/jira*
Dropped the Jira database on the MySQL server

When you ran the new install, does this ask you for a new database (which you create manually, but totally empty) and an empty directory to use for "home"?

Justin Kelly

Your responses haven't been very helpful and have been more along the lines of insulting (I know what a 500 error is and my latest long post included a detailed log from your product -- hardly "front-end" and yet you didn't even mention the log I sent). So that being said,

First of all, this isn't a Linux install (I had mentioned it is on Windows), so no it wasn't in folders with names like opt/.... etc/...anything like that.

Secondly, the errors and behaviors exhibited in Jira have not differed *at all* since my first "pristine" installation, so it would seem to follow that any uninstalls I've done have not been the cause of the same exact error pattern I first described. By that I mean I get an error when I click something like "Search for Issues", and got that same error after the very first install, hence why I contacted support and what I described earlier already.

Thirdly, I provided a long explanatory stack trace since you had commented on the HTTP 500 errors being the server error at the web page and how you would need more detail. If you looked in the stack trace it says "Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ao_e8b6cc_issue_mapping' already exists".

Fourthly, to your questions....for the Jira and MySQL uninstalls I chose the normal uninstall options from the "Windows Programs And Features" dialog and watched it perform the uninstall to completion.

I then deleted the MySQL folders:

- C:\Program Files (x86)\MySQL

- C:\ProgramData\MySQL

(Regarding MySql file locations, see https://dev.mysql.com/doc/refman/5.7/en/windows-installation-layout.html). I don't think I would need to drop any tables with this full and complete uninstall/deletion process but, please correct me if I'm wrong on that.

I then deleted the Atlassian folder at C:\Program Files\Atlassian.

...after all those steps I started the fresh re-install of MySql, then proceeded to install Jira server again, only to end up getting the same error behaviors I got with my very first install. I can log in, view my dashboard but can't access items or boards.

My installation is so straight-up "by the book" I would think there would be some information on what is going on, and what went on after my first install because they are the same thing. I never even had MySql on my system before needing it for my new Jira installation, and I've followed all of the directions for the installs.

I am still needing real help on this but I found

https://confluence.atlassian.com/jirakb/jira-throws-table-already-exist-error-due-to-incorrect-mysql-schema-338364885.html

...and will look into that in the meantime.

Justin Kelly

The following resolved my issue, hopefully this will help anyone that experiences the project creation errors and the "table already exists" errors I saw.

As odd as it sounds, it related to HipChat integration settings when I don't have or need Hipchat.

I started here:

https://community.atlassian.com/t5/Jira-Software-questions/Crashes-at-creating-a-project/qaq-p/651662

and followed what it says here:

https://confluence.atlassian.com/confkb/how-to-disable-hipchat-integration-pop-up-dialog-794500518.html

I searched for anything "hipchat" while on the system "manage add-ons" page and disabled all of them.

Once I did this, I was able to create a new Jira project with no errors that occur or when I click on anything or select any options within the Jira application. It finally works!

Just a guess...the initial project creation error related to hipchat somehow left things in a half-baked state. No idea, but it works now.

Jobin Kuruvilla [Adaptavist]

Hey Justin,

Glad your issue is resolved. Couple of things for handling issues like this in future:

This is an Atlassian User forum where people like Nic, who is very experienced in JIRA Administration and Customizations, and newbies who just started on JIRA hang out. It is not a support forum but a place where people from different timezones pitch in to help each other. You might find some Atlassians weighing in here but that is not the norm.
If you have a support issue and if you do not get any satisfactory help here, you might want to raise it directly with Atlassian via their support channel (support.atlassian.com). If you find a bug in JIRA/other Atlassian products or have a feature requests for them, raise them at jira.atlassian.com.

Hopefully you are all set now but I am sure you will have more questions as you start using the product. And I am sure you will find lot of help here or via one of the aforementioned JIRA instances. Have a good time!

Justin Kelly

Thank you Jobin for the information. I appreciate the help. I will be more aware next time about my options.

ms_j6d0vp

Jobin response to Justin wrt "raise it directly with Atlassian via their support channel (support.atlassian.com)" would normally be fine only if they would respond. Sharon Tan appears to be the only person associated with presales@atlassian.com and as hard as that is to believe, perhaps that's why still no response after 4 days! Has anyone else experienced such slow response from Atlassian hence why apparently they refer everyone so strongly to the "community?" All I'd like to do is have the Atlassian instructions for adding Jira Software to my AWS instance of Jira Data Center work?

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-software