-
Notifications
You must be signed in to change notification settings - Fork 4.4k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Queries search is not working on release/7.0.x #3602
Comments
How did you build the database? |
use redash/setup/docker-compose.yml
|
Yes, but how did you create the database tables? |
Replace the original image with the built image in redash/setup/docker-compose.yml,
|
Just to make sure: this is a new install not an upgrade, correct? |
Yes, just to test the new version |
Thanks. I managed to confirm this :-( @jezdez maybe we need to setup something for the trigger to be created when creating DB from scratch (using the |
Ah, right, we simply have to run the migrations in the |
Because from my experience migrations don't age well. Usually over time they tend to break. When creating a database from scratch the ORM usually does a better job by creating the tables from their definitions than trying to mutate the DB over all the different versions we ever had. |
Yeah, I've had that experience as well, especially when migrations are leaky and codify subtle data model structure or use specific code paths. I don't have enough experience with it to say if that's the case for Alembic though. One thing we could consider is resetting the migrations to reduce the risk of decay, basically squash them to just a few migration files. Alternatively we could create a command to hook up the search update trigger manually if needed. |
Yes, it's fixed! |
How do I build the database for postgres db when I use kubernetes? postgres was error : I have found a solution myself, as follows: kubectl -n redash exec -it server-c86dd7579-knnn5 -- /app/bin/docker-entrypoint create_db [2019-03-29 15:09:22,520][PID:630][INFO][root] Generating grammar tables from /usr/lib/python2.7/lib2to3/Grammar.txt |
Issue Summary
I try building docker image with the redash dockerfile and start by docker-compose. But queries search is not working
Steps to Reproduce
Check out the queries table and find that search_vector is null.
Technical details:
The text was updated successfully, but these errors were encountered: