Hey Guys.. I am Kshitiz from NIT Hamirpur and i am proficient in MERN stack, and have a decent experience in React (i love it actually)... i want to contribute in listenBrainz-server so tried building the docker containers as described in docs but "./develop.sh manage init_ts_db --create-db" is giving me this error
2020-12-26 36154, 2020
devorizon
*psycopg2.errors.InternalError_: cannot create continuous aggregate with CREATE VIEW*
2020-12-26 36136, 2020
devorizon
Can anyone help me in this?
2020-12-26 36155, 2020
shivam-kapila
Hi devorizon, welcome. Can you pastebin the complete error
Maybe try `./develop.sh manage init_ts_db -f ` once
2020-12-26 36130, 2020
devorizon
same error happened again (by using -f flag), and then i deleted all the images and started again, still the same error, the line *psycopg2.errors.InternalError_: cannot create continuous aggregate with CREATE VIEW HINT: Use CREATE MATERIALIZED VIEW to create a continuous aggregate.* can mean something i guess
2020-12-26 36156, 2020
Mr_Monkey
I'm just passing by, but it looks like a new image of timescaledb was published 5 days ago with a new timescale version (2.0). In the changelog I see this which would explain the issue:
2020-12-26 36158, 2020
Mr_Monkey
A continuous aggregate is now created with CREATE MATERIALIZED VIEW instead of CREATE VIEW
2020-12-26 36137, 2020
shivam-kapila
Ah ha
2020-12-26 36148, 2020
shivam-kapila
Thanks Mr_Monkey
2020-12-26 36156, 2020
shivam-kapila
I will open a pr
2020-12-26 36118, 2020
Mr_Monkey
shivam-kapila: I think just opening an issue for now, until we analyse what needs to be done
2020-12-26 36107, 2020
shivam-kapila
Mr_Monkey: actually right. There might be more things to look into
2020-12-26 36113, 2020
Mr_Monkey
devorizon: You can try replacing `image: timescale/timescaledb:latest-pg12` with `image: timescale/timescaledb:1.7.4-pg12` on line 30 of the docker-compose.yml file in the project, and see if that allows you to move forward until we fix the issue
2020-12-26 36136, 2020
shivam-kapila
I actually removed image and rebuilt but disnt see it
this following error came: `psycopg2.errors.UndefinedFile: could not access file "$libdir/timescaledb-2.0.0": No such file or directory` full error: https://pastebin.com/9Lw0kPJ4 .. i can't find this `$libdir/timescaledb-2.0.0` word using text search
2020-12-26 36136, 2020
Mr_Monkey
hm, you might have to remove the docker volumes to recreate them
2020-12-26 36126, 2020
Mr_Monkey
The command `docker volume ls` will list the volumes, and `docker volume rm the-volume-id` to remove them
@Mr_Monkey thanks.. it worked like charm.. can you guys suggest me an open beginner issue so that i can start contributing and understand the codebase?
2020-12-26 36144, 2020
_lucifer
devorizon: you can take a look at the issues labelled `good-first-issue`
