Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Redash
  3. Redash workers not executing jobs

Redash workers not executing jobs

Scheduled Pinned Locked Moved Solved Redash
9 Posts 2 Posters 2.6k Views 2 Watching
  • 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.
    • ChristopherMagC Offline
      ChristopherMagC Offline
      ChristopherMag
      wrote on last edited by
      #1

      After installing redash, configuring a datasource, and submitting a query to be run, it remains in queue and is never executed by a worker.

      I have uninstalled and reinstalled redash and reconfigured the data sources and such as I thought maybe I did something wrong to mess it up the first time but both times I get the same result, queries sit queued but never execute.

      41fc196f-9271-4bda-876c-a264c7e1f750-image.png

      d021fedd-1f83-471b-be43-920bdf90c0e1-image.png

      All the processes for the workers appear to be running:

      901798a7-53ea-4dc1-8de3-104720cd4872-image.png

      4c748fd7-7b4c-4002-9950-b20f273a361b-image.png

      girishG 2 Replies Last reply
      0
      • girishG girish moved this topic from Support on
      • ChristopherMagC ChristopherMag

        After installing redash, configuring a datasource, and submitting a query to be run, it remains in queue and is never executed by a worker.

        I have uninstalled and reinstalled redash and reconfigured the data sources and such as I thought maybe I did something wrong to mess it up the first time but both times I get the same result, queries sit queued but never execute.

        41fc196f-9271-4bda-876c-a264c7e1f750-image.png

        d021fedd-1f83-471b-be43-920bdf90c0e1-image.png

        All the processes for the workers appear to be running:

        901798a7-53ea-4dc1-8de3-104720cd4872-image.png

        4c748fd7-7b4c-4002-9950-b20f273a361b-image.png

        girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #2

        @christophermag I think this is related to https://forum.cloudron.io/topic/6187/has-anyone-used-v10-1-0 . Also see, https://github.com/getredash/redash/issues/5561 . The Cloudron package has a bug which I am fixing. For some reason, even the old package does not build anymore, so it's taking a bit more time. I think it's something to do with redash not having pinned it's deps properly.

        1 Reply Last reply
        0
        • ChristopherMagC ChristopherMag

          After installing redash, configuring a datasource, and submitting a query to be run, it remains in queue and is never executed by a worker.

          I have uninstalled and reinstalled redash and reconfigured the data sources and such as I thought maybe I did something wrong to mess it up the first time but both times I get the same result, queries sit queued but never execute.

          41fc196f-9271-4bda-876c-a264c7e1f750-image.png

          d021fedd-1f83-471b-be43-920bdf90c0e1-image.png

          All the processes for the workers appear to be running:

          901798a7-53ea-4dc1-8de3-104720cd4872-image.png

          4c748fd7-7b4c-4002-9950-b20f273a361b-image.png

          girishG Offline
          girishG Offline
          girish
          Staff
          wrote on last edited by
          #3

          @christophermag I have pushed a new package, can you reinstall redash and try again? (updating won't work).

          ChristopherMagC 1 Reply Last reply
          0
          • girishG girish

            @christophermag I have pushed a new package, can you reinstall redash and try again? (updating won't work).

            ChristopherMagC Offline
            ChristopherMagC Offline
            ChristopherMag
            wrote on last edited by
            #4

            @girish I uninstalled and reinstalled, I made sure when I was installing it from the app store it said last updated 15 hours ago so I believe it pulled the updated version.

            Unfortunately, same problem, queries get queued but never dequeued and run.

            girishG 1 Reply Last reply
            0
            • ChristopherMagC ChristopherMag

              @girish I uninstalled and reinstalled, I made sure when I was installing it from the app store it said last updated 15 hours ago so I believe it pulled the updated version.

              Unfortunately, same problem, queries get queued but never dequeued and run.

              girishG Offline
              girishG Offline
              girish
              Staff
              wrote on last edited by
              #5

              @christophermag just to double check, if you go to App -> Updates, does it say package version as 4.0.0 ? What's a good way to reproduce this?

              In my RQ workers, I see that jobs are running:

              879175c4-3c69-455c-abec-1fce249ac813-image.png

              ChristopherMagC 1 Reply Last reply
              0
              • girishG girish

                @christophermag just to double check, if you go to App -> Updates, does it say package version as 4.0.0 ? What's a good way to reproduce this?

                In my RQ workers, I see that jobs are running:

                879175c4-3c69-455c-abec-1fce249ac813-image.png

                ChristopherMagC Offline
                ChristopherMagC Offline
                ChristopherMag
                wrote on last edited by ChristopherMag
                #6

                @girish Package version shows 4.0.0:

                d79ef173-888f-43d8-9c6e-6cdc6ab6a0f6-image.png

                I also see successful jobs count on that screen but those do not appear to be the queued jobs as we can also see that the queued jobs count only increases, started jobs never increases:

                9f059e51-2766-4217-8fda-9931802d2b15-image.png

                df4a6e96-94bd-4fa3-9cd8-0e8b6c8ce426-image.png

                To reproduce this you can submit any query to any data source and confirm that it never completes.

                Below is an example of submitting select "test" as the query to a CSV data source which may not even be valid but if it is not at least it should error instead of remaining indefinitely queued:

                b6961e14-c742-4468-a3ef-bb16f2c7eff4-image.png

                I have also tried this with a SQLite data source and get the same results, for each query I submit the queued count increases and the screen where the query was submitted just keeps counting up.

                girishG 1 Reply Last reply
                0
                • ChristopherMagC ChristopherMag

                  @girish Package version shows 4.0.0:

                  d79ef173-888f-43d8-9c6e-6cdc6ab6a0f6-image.png

                  I also see successful jobs count on that screen but those do not appear to be the queued jobs as we can also see that the queued jobs count only increases, started jobs never increases:

                  9f059e51-2766-4217-8fda-9931802d2b15-image.png

                  df4a6e96-94bd-4fa3-9cd8-0e8b6c8ce426-image.png

                  To reproduce this you can submit any query to any data source and confirm that it never completes.

                  Below is an example of submitting select "test" as the query to a CSV data source which may not even be valid but if it is not at least it should error instead of remaining indefinitely queued:

                  b6961e14-c742-4468-a3ef-bb16f2c7eff4-image.png

                  I have also tried this with a SQLite data source and get the same results, for each query I submit the queued count increases and the screen where the query was submitted just keeps counting up.

                  girishG Offline
                  girishG Offline
                  girish
                  Staff
                  wrote on last edited by
                  #7

                  @christophermag thanks for reporting, just back from vacation, will fix the package.

                  ChristopherMagC 1 Reply Last reply
                  0
                  • girishG girish

                    @christophermag thanks for reporting, just back from vacation, will fix the package.

                    ChristopherMagC Offline
                    ChristopherMagC Offline
                    ChristopherMag
                    wrote on last edited by
                    #8

                    @girish It doesn't look like Redash has been updated yet, just making sure this didn't fall of the list of things to do as I know it came in over the holidays.

                    girishG 1 Reply Last reply
                    1
                    • ChristopherMagC ChristopherMag

                      @girish It doesn't look like Redash has been updated yet, just making sure this didn't fall of the list of things to do as I know it came in over the holidays.

                      girishG Offline
                      girishG Offline
                      girish
                      Staff
                      wrote on last edited by
                      #9

                      @christophermag yes, didn't forget but got backlogged. Just looking into this now. I have posting at https://forum.cloudron.io/topic/6187/has-anyone-used-v10-1-0 with the progress.

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                        • Login

                        • Don't have an account? Register

                        • Login or register to search.
                        • First post
                          Last post
                        0
                        • Categories
                        • Recent
                        • Tags
                        • Popular
                        • Bookmarks
                        • Search