Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-4183

Enable invalidating Hibernate cache to read changes from database

    • 0
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      A possibility to invalidate Hibernate cache used in ORM on Bamboo's database would be handy to reload/re-read data directly from database after e.g. making bulk changes in plans. In case when a myriad of similar plans is maintained rather via database (updating XML_DEFINITION_DATA) than by clicking on all the possible plans in UI. Now it has to be done by restarting Bamboo, since Hibernate cache (with a rather long TTL) keeps the old definitions and the new ones from the database are visible after restart. Restarting the build server's app is very inconvenient especially when using Elastic Bamboo, since shutting down instances and starting them up again (with success!) takes a significant amount of time.

      The functionality itself could be implemented either as a button e.g. "Reload DB" in Administration interface e.g. on Database Configuration tab. A more sophisticated version could show it only in case of real databases - MySQLs or PostgreSQLs, but not in case of embedded HSQL databases - as it doesn't make sense I suppose. Having it in UI would allow the verification of who can reload it (not allowing of mischievous behaviour if Bamboo server is accessible from public network).

      A simplified (or just a quick-win solution) would be to allow making an HTTP request to Bamboo's UI or API to execute Hibernate cache invalidation.

            [BAM-4183] Enable invalidating Hibernate cache to read changes from database

            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3018959 ] New: JAC Suggestion Workflow 3 [ 3605710 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Krystian Brazulewicz made changes -
            Resolution New: Won't Fix [ 2 ]
            Status Original: Gathering Interest [ 11772 ] New: Resolved [ 5 ]

            Atlassian Update – [12 April 2019]

            Hi everyone,

            Thank you for your interest in this issue.

            While this suggestion has gathered significant interest, we're unable to implement all of the excellent suggestions you make. We don't plan to work on this for the foreseeable future.
            For all the configuration at scale issues we suggest using Bamboo Specs.

            Kind regards,
            Bamboo Team

            Krystian Brazulewicz added a comment - Atlassian Update – [12 April 2019] Hi everyone, Thank you for your interest in this issue. While this suggestion has gathered significant interest, we're unable to implement all of the excellent suggestions you make. We don't plan to work on this for the foreseeable future. For all the configuration at scale issues we suggest using Bamboo Specs . Kind regards, Bamboo Team
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2699268 ] New: JAC Suggestion Workflow [ 3018959 ]
            Krystian Brazulewicz made changes -
            UIS New: 0
            Owen made changes -
            Backlog Order (Obsolete) Original: 9660000000
            Issue Type Original: Improvement [ 4 ] New: Suggestion [ 10000 ]
            Owen made changes -
            Status Original: Not Being Considered [ 11776 ] New: Gathering Interest [ 11772 ]
            Owen made changes -
            Status Original: Gathering Interest [ 11772 ] New: Not Being Considered [ 11776 ]
            Owen made changes -
            Workflow Original: Bamboo Workflow 2016 v1 [ 1418488 ] New: Confluence Workflow - Public Facing v4 [ 2699268 ]
            Status Original: Open [ 1 ] New: Gathering Interest [ 11772 ]
            Marek Went (Inactive) made changes -
            Workflow Original: Bamboo Workflow 2014 v2 [ 615534 ] New: Bamboo Workflow 2016 v1 [ 1418488 ]

              Unassigned Unassigned
              ac345ce11761 Krystian Nowak
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: