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


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved Redash workers not executing jobs

    Redash
    2
    9
    508
    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.
    • ChristopherMag
      ChristopherMag last edited by

      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

      girish 2 Replies Last reply Reply Quote 0
      • Moved from Support by  girish girish 
      • girish
        girish Staff @ChristopherMag last edited by

        @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 Reply Quote 0
        • girish
          girish Staff @ChristopherMag last edited by

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

          ChristopherMag 1 Reply Last reply Reply Quote 0
          • ChristopherMag
            ChristopherMag @girish last edited by

            @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.

            girish 1 Reply Last reply Reply Quote 0
            • girish
              girish Staff @ChristopherMag last edited by

              @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

              ChristopherMag 1 Reply Last reply Reply Quote 0
              • ChristopherMag
                ChristopherMag @girish last edited by 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.

                girish 1 Reply Last reply Reply Quote 0
                • girish
                  girish Staff @ChristopherMag last edited by

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

                  ChristopherMag 1 Reply Last reply Reply Quote 0
                  • ChristopherMag
                    ChristopherMag @girish last edited by

                    @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.

                    girish 1 Reply Last reply Reply Quote 1
                    • girish
                      girish Staff @ChristopherMag last edited by

                      @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 Reply Quote 0
                      • First post
                        Last post
                      Powered by NodeBB