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
*psycopg2.errors.InternalError_: cannot create continuous aggregate with CREATE VIEW*
Can anyone help me in this?
shivam-kapila
Hi devorizon, welcome. Can you pastebin the complete error
Maybe try `./develop.sh manage init_ts_db -f ` once
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
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:
A continuous aggregate is now created with CREATE MATERIALIZED VIEW instead of CREATE VIEW
shivam-kapila
Ah ha
Thanks Mr_Monkey
I will open a pr
Mr_Monkey
shivam-kapila: I think just opening an issue for now, until we analyse what needs to be done
shivam-kapila
Mr_Monkey: actually right. There might be more things to look into
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
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
Mr_Monkey
hm, you might have to remove the docker volumes to recreate them
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?
_lucifer
devorizon: you can take a look at the issues labelled `good-first-issue`