Some errors in logs
Hi Team
We are upgrading our instance from Jira 5 to Jira 6 and we noticed the following warnings in the logs:
2015-03-16 11:42:24,012 UpmAsynchronousTaskManager:thread-1 WARN arevrt01 683x971x6 75nqk7 10.1.135.36 /rest/plugins/1.0/installed-marketplace [timesheet.plugin.job.TimesheetJobScheduler] Can't schedule jira-timesheet-plugin:report#a64c50f4 on 0 0 8 ? * *: Couldn't store trigger 'SUBSCRIPTION_1' for 'TIMESHEET_SUBSCRIPTION' job:Duplicate entry 'SUBSCRIPTION_1-TIMESHEET_SUBSCRIPTION' for key 'PRIMARY'
2015-03-16 11:42:24,076 UpmAsynchronousTaskManager:thread-1 WARN arevrt01 683x971x6 75nqk7 10.1.135.36 /rest/plugins/1.0/installed-marketplace [timesheet.plugin.job.TimesheetJobScheduler] Can't schedule jira-timesheet-plugin:report#779a4048 on 0 0 8 ? * 1: Couldn't store trigger 'SUBSCRIPTION_4' for 'TIMESHEET_SUBSCRIPTION' job:Duplicate entry 'SUBSCRIPTION_4-TIMESHEET_SUBSCRIPTION' for key 'PRIMARY'
Could you please let me know what I can check for this?
Regards,
Comments (10)
-
-
Account Deleted Hi
I have identified the users who created the subscription and during the actual upgrade I will remove that subscription and will ask users to recreate them.
Thanks for information.
Regards, Areg
-
- changed status to resolved
-
Account Deleted Hi
I would like to check with you how I can find subscriptions section in Jira 5 or it is Jira 6 feature only? So I need to clean up database manually in Jira 5 before upgrade ... ?
Regards, Areg
-
Hi,
It should be similarly in Administration - Plugins - Timesheet Subscriptions. Note, 2.8.3.1 has important fix - when admin deletes subscription it is also unscheduled. Previously scheduler records were not removed.
Thank you.
-
Account Deleted Hi
Looks like I can't see that in Jira 5.2.11 with 2.7.5-JRA-32510 version of PlugIn ...
Regards, Areg
-
Ah, you have plugin version 2.7.5, it's been added later, I'm not sure when exactly, but can figure it out if really needed. I would recommend to install latest version though.
-
Account Deleted Looks like I don't have Update option there ....
Need to update manually. Will do that before Upgrade.
-
- removed version
Removing version: 2.8 (automated comment)
-
- removed component
Removing component: Time Sheet report and gadget (automated comment)
- Log in to comment
Unfortunately timesheet subscriptions can not go through upgrade. There are few workarounds:
Remove all Timesheet Subscription in Administration - Add-Ons - Timesheet Subscription before upgrade. Let user to subscribe again after upgrade.
Uninstall plugin before upgrade, then install it again after upgrade. It should remove all subscriptions on uninstallation, but any other settings too. So users will need to recreate their dashboard gadgets and subscriptions.
See issue
#545for way to remove records in JIRA database manually.Please let me know if it helps.
Thank you.