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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

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
4,463,569
Community Members
 
Community Events
176
Community Groups

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

Edited

 

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

 

 

Ex.

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] [net.java.ao.sql] 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(T4CTTIoer.java:450)

 

 

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

Comment

Log in or Sign up to comment
TAGS

Atlassian Community Events