Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Logs flooded with Caused by: java.sql.SQLException: ORA-01408: such column list already indexed



Upgraded our Confluence application from 6.4.1 to 6.9.0 including add-ons. Noticed lots of exception in the logs 

 Caused by: java.sql.SQLException: ORA-01408: such column list already indexed




2018-06-18 14:36:49,365 INFO [UpmAsynchronousTaskManager:thread-2] [atlassian.plugin.manager.DefaultPluginManager] updatePlugin Updating plugin 'com.atlassian.troubleshooting.plugin-confluence' from version '1.8.9' to version '1.11.0'

2018-06-18 14:36:49,366 INFO [UpmAsynchronousTaskManager:thread-2] [atlassian.plugin.manager.DefaultPluginManager] broadcastPluginDisabling Disabling com.atlassian.troubleshooting.plugin-confluence
2018-06-18 14:36:51,792 ERROR [active-objects-init-system tenant-0] [] handleUpdateError Exception executing SQL update <CREATE INDEX "index_ao_4789dd_tas639956211" ON "AO_4789DD_TASK_MONITOR"("TASK_ID")>
-- url: /confluence/rest/plugins/1.0/ | referer: https://atlassian-test/confluence/plugins/servlet/upm | traceId: db63a1d9a6735cb8 | userName: caxxxx
java.sql.SQLException: ORA-01408: such column list already indexed

at oracle.jdbc.driver.T4CTTIoer.processError(



Root Cause:  Using plugin  Atlassian Troubleshooting and Support Tools v1.11.0. 


Workaround: Use Atlassian Troubleshooting and Support Tools v1.10.3 plugin instead.


1 comment

Just a suggestion, not sure if that will solve the problem but I would take below actions;

(Always back up your data before performing any modification to the database. If possible, try your modifications on a test server.)

  1. Stop Confluence.
  2. Drop the index in your database:

    DROP INDEX index_ao_4789dd_tas639956211
  3. Start Confluence. Upon restarting, Confluence will re-build the missing index.

I already tried that approach, confirmed/verified that index has been deleted before starting server and didn't help. Thank you!

Fixed version has been released for this plugin v1.11.1


Log in or Sign up to comment

Atlassian Community Events