-
Suggestion
-
Resolution: Done
-
None
-
None
Upgrade task 2806 carries out the conversion of column type from TEXT to VARCHAR. However, when using MySQL as DB one might encounter following error in the logs:
ERROR [main] [SchemaUpdate] Unsuccessful: create index commit_rev_idx on USER_COMMIT (COMMIT_REVISION) ERROR [main] [SchemaUpdate] BLOB/TEXT column 'COMMIT_REVISION' used in key specification without a key length
After next Bamboo restart the indices will re-create correctly.
It would be cool if, we add something to 3.4.5 so:
- at the end of upgrade logs there would be a pretty obvious message (about the necessary Bamboo restart)
- in admin screen there would be proper information if Bamboo detects the non-existence of the index
- is related to
-
BAM-10090 Indexing problem in table USER_COMMIT because of column COMMIT_REVISION text type
-
- Closed
-
[BAM-11070] upgrade task 2806 improvements (better logs/informations)
Workflow | Original: JAC Suggestion Workflow [ 3016091 ] | New: JAC Suggestion Workflow 3 [ 3602261 ] |
Status | Original: RESOLVED [ 5 ] | New: Closed [ 6 ] |
Workflow | Original: Confluence Workflow - Public Facing v4 [ 2702723 ] | New: JAC Suggestion Workflow [ 3016091 ] |
Issue Type | Original: Improvement [ 4 ] | New: Suggestion [ 10000 ] |
Workflow | Original: Bamboo Workflow 2016 v1 [ 1409313 ] | New: Confluence Workflow - Public Facing v4 [ 2702723 ] |
Resolution | Original: Fixed [ 1 ] | New: Done [ 17 ] |
Status | Original: In Progress [ 3 ] | New: Resolved [ 5 ] |
Status | Original: Open [ 1 ] | New: In Progress [ 3 ] |
Workflow | Original: Bamboo Workflow 2014 v2 [ 615059 ] | New: Bamboo Workflow 2016 v1 [ 1409313 ] |
Workflow | Original: Bamboo Workflow 2014 [ 600365 ] | New: Bamboo Workflow 2014 v2 [ 615059 ] |
Workflow | Original: Bamboo Workflow 2010 [ 373464 ] | New: Bamboo Workflow 2014 [ 600365 ] |
Component/s | New: Database (other) [ 12663 ] | |
Component/s | New: Upgrading [ 11560 ] | |
Fix Version/s | Original: Milestone Discoveries [ 20791 ] |