#metabrainz

/

      • Nyanko-sensei has quit
      • Nyanko-sensei joined the channel
      • D4RK-PH0_ joined the channel
      • D4RK-PH0ENiX has quit
      • fs has quit
      • Nyanko-sensei has quit
      • D4RK-PH0ENiX joined the channel
      • davic has quit
      • D4RK-PH0ENiX has quit
      • Huskers_1 joined the channel
      • Huskers_1 has left the channel
      • rektide has quit
      • Major_Lurker joined the channel
      • MajorLurker has quit
      • devorizon joined the channel
      • devorizon
        hi
      • 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
      • devorizon
        shivam-kapila, Here is the pastebin link: https://pastebin.com/kHMCX6q7
      • devorizon_ joined the channel
      • devorizon has quit
      • devorizon_ is now known as devorizon
      • flamingspinach joined the channel
      • flamingspinach has quit
      • lks joined the channel
      • Gazooo79494 has quit
      • shivam-kapila
        devorizon: I couldn't reproduce it on my system
      • Gazooo79494 joined the channel
      • 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
      • Mr_Monkey
      • devorizon
        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
      • shivam-kapila
        Mr_Monkey: LB-777
      • BrainzBot
        LB-777: Upgrade timescale bits so that they can work with Timescale 2.0 release https://tickets.metabrainz.org/browse/LB-777
      • Mr_Monkey
        Good, thanks !
      • devorizon
        @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`
      • devorizon
        ok thanks @_lucifer
      • Mr_Monkey
        Nice, good to hear.
      • Here's the good-first-bug issues: https://tickets.metabrainz.org/issues/?jql=proj...
      • flamingspinach joined the channel
      • devorizon
        👍
      • flamingspinach is now known as fs
      • sumedh joined the channel
      • sumedh has quit
      • Major_Lurker has quit
      • Major_Lurker joined the channel
      • sumedh joined the channel
      • v6lur joined the channel
      • davic joined the channel
      • jjjj joined the channel
      • jjjj has quit
      • sumedh has quit
      • Gazooo79494 has quit
      • Gazooo79494 joined the channel
      • alastairp has quit
      • reosarevok has quit
      • zas has quit
      • zas joined the channel
      • alastairp joined the channel
      • reosarevok joined the channel
      • BestSteve has quit
      • BestSteve joined the channel
      • rektide joined the channel
      • v6lur has quit
      • BestSteve has quit
      • BestSteve joined the channel