Inedo Community Forums Forums
    • Recent
    • Tags
    • Popular
    • Login

    Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

    If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

    [ProGet] Manual database upgrade (docker, kubernetes)

    Scheduled Pinned Locked Moved Support
    21 Posts 4 Posters 109 Views 2 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • atrippA Offline
      atripp inedo-engineer @viceice
      last edited by

      @viceice thanks! We will add a command via PG-1897 to handle this, it seems quite straight forward...

      Stay tuned :)

      1 Reply Last reply Reply Quote 0
      • V Offline
        viceice
        last edited by

        The issue is closed, so can i implement it to my kubernetes deployment?

        atrippA 1 Reply Last reply Reply Quote 0
        • atrippA Offline
          atripp inedo-engineer @viceice
          last edited by

          @viceice it was shipped in 5.3.23, so please give it a shot and let us know!

          We didn't test it in a Kubernetes deployment (I hope we can get great docs on that some day!), but in the meantime I did add this to the documentation:

          https://github.com/Inedo/inedo-docs/commit/358be6d03160ff569d791532f14cc5f05012b2a8

          If you have any suggestions, especially on how to improve the docs, please share it or submit a PR to our docs :)

          1 Reply Last reply Reply Quote 0
          • V Offline
            viceice
            last edited by

            https://github.com/Inedo/inedo-docs/pull/223 😏

            1 Reply Last reply Reply Quote 0
            • V Offline
              viceice
              last edited by

              getting this when trying to run upgrade command

              For help on a specific command, type: ProGet.Service help [command]
              To run interactively, type: ProGet.Service interactive
              Invalid command: upgrade
              
              ProGet.Service 5.3.24.7
              Usage: ProGet.Service [command]
              
              Commands:
              run Runs the ProGet service and/or the ProGet web server interactively.
              install Installs the ProGet service as a Windows service.
              uninstall Uninstalls the ProGet Windows service.
              resetadminpassword Switches to the built-in user directory and changes the Admin account password to "Admin".
              upgradedb Upgrades the database schema version to this version of ProGet.
              
              For help on a specific command, type: ProGet.Service help [command]
              To run interactively, type: ProGet.Service interactive
              
              1 Reply Last reply Reply Quote 0
              • V Offline
                viceice
                last edited by

                @viceice said in [ProGet] Manual database upgrade (docker, kubernetes):

                upgradedb

                needs to be ProGet.Service upgradedb. fixed it in my pr

                1 Reply Last reply Reply Quote 0
                • V Offline
                  viceice
                  last edited by

                  It's now always dooing upgrade 😕

                  ProGet version is 5.3.24.7.
                  Current DB schema version is 5.3.24.
                  Executing untracked script DDL-DML/0000. Untracked/10. Block 5.3 Upgrades.sql...
                  Executing untracked script DDL-DML/0000. Untracked/10. Block SQL Server 2005.sql...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/10 SET DATABASE PROPERTIES.sql has already been executed; skipping...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/20 CREATE TYPES.sql has already been executed; skipping...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/21 CREATE ROLE ProGetUser_Role.sql has already been executed; skipping...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/30 CREATE TABLE Configuration.sql has already been executed; skipping...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/30 CREATE TABLE Environments.sql has already been executed; skipping...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/30CTC1 CREATE TABLE Connectors.sql has already been executed; skipping...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/30CTC2 CREATE TABLE ConnectorFilters.sql has already been executed; skipping...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/30EVT1 CREATE TABLE EventTypes.sql has already been executed; skipping...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/30EVT2 CREATE TABLE EventTypeDetails.sql has already been executed; skipping...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/30EVT3 CREATE TABLE EventOccurences.sql has already been executed; skipping...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/30EVT4 CREATE TABLE EventOccurenceDetails.sql has already been executed; skipping...
                  Tracked script DDL-DML/v1-3/0002. 0.1.0/30USR1 CREATE TABLE Groups.sql has already been executed; skipping...
                  

                  It should skip updates update at all if already uptodate, otherwise startup will be very slow

                  atrippA 1 Reply Last reply Reply Quote 0
                  • atrippA Offline
                    atripp inedo-engineer @viceice
                    last edited by

                    Thanks for making the pull request @viceice !!

                    Well, I can see the issue... 5.3.24.7 != 5.3.24 😅

                    Okay, so next version it should work. Diagnostics.DbVersion is set in the build/release process, so we just changed the code that sets Diagnostics.DbVersion.

                    Next time it should work.

                    1 Reply Last reply Reply Quote 0
                    • V Offline
                      viceice
                      last edited by

                      I know, i saw that difference. Just wanted to inform you 😉

                      1 Reply Last reply Reply Quote 0
                      • S Offline
                        saml_4392
                        last edited by

                        I can't wait to see this works. Is this one fixed in 5.3.25? Also could we have a helm chart? If you guys don't mind, I think you guys can work with https://github.com/bitnami/charts They are pretty good at creating helm chart.

                        stevedennisS 1 Reply Last reply Reply Quote 0
                        • stevedennisS Offline
                          stevedennis inedo-engineer @saml_4392
                          last edited by

                          @saml_4392 in theory it's fixed, but we didn't test it

                          Could you open a new thread about a creating a Helm chart for ProGet itself? That'd be a great place to start that discussion, and get community direction and feedback from users - and provide nice opportunities to partner with organizations like bitnami, who could help

                          1 Reply Last reply Reply Quote 0

                          Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                          Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                          With your input, this post could be even better 💗

                          Register Login
                          • 1
                          • 2
                          • 2 / 2
                          • First post
                            Last post
                          Inedo Website Home • Support Home • Code of Conduct • Forums Guide • Documentation