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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. PeerTube
  3. Peertube export not working...

Peertube export not working...

Scheduled Pinned Locked Moved Solved PeerTube
14 Posts 4 Posters 2.0k Views 4 Watching
  • 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.
  • luckowL Offline
    luckowL Offline
    luckow
    translator
    wrote on last edited by
    #5

    image.png
    and then
    image.png

    Pronouns: he/him | Primary language: German

    1 Reply Last reply
    1
    • DanTheManD Offline
      DanTheManD Offline
      DanTheMan
      wrote on last edited by DanTheMan
      #6

      That one is actually really easy to solve. Only thing is, that my Peertube instance is in Dutch language and i can't find an option to change it 🥴

      Anyway, i shall do my best to help you get there, because there's a setting for that...

      As Peertube admin logged into your instance,
      Go to:

      Administration > Configuration > Basic >

      In there you scroll (almost) all the way down, until you reached the "user import/export" settings.
      There you will also find the value for max take out.

      Set it to your desired value and voila 😎

      luckowL 1 Reply Last reply
      3
      • DanTheManD DanTheMan

        Thanks @girish for checking.

        I tried it with an other account (test-account) on the same Peertube instance.
        Strangely this test-account gives an succesfull export.

        So my thought is that the export from the account that throws the error, simply is too big to export maybe?
        (around 19GB)

        I'm now trying to delete some videos to get to a smaller volume and see if that helps...

        Maybe it's worth mentioning this error i see in postgresql on Cloudron itself:
        ERROR: value "18519529041" is out of range for type integer<27>1 2024-06-01T13:41:40+02:00 cloudronserver postgresql 920 postgresql - 2024-06-01 11:41:40.171 UTC [2226] userdxxxxxxx4b34b2e2b12ab16a57eb@xxxxxxdbd6d0b666 CONTEXT: unnamed portal parameter $1 = '...'<27>1 2024-06-01T13:41:40+02:00 cloudronserver postgresql 920 postgresql - 2024-06-01 11:41:40.171 UTC [2226] userdxxxxxxx4b34b2e2b12ab16a57eb@xxxxxxdbd6d0b666 STATEMENT: UPDATE "userExport" SET "size"=$1,"state"=$2,"error"=$3,"updatedAt"=$4 WHERE "id" = $5

        girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #7

        @DanTheMan the postgres error seems like an app issue. Maybe worth reporting upstream.

        1 Reply Last reply
        1
        • DanTheManD DanTheMan

          That one is actually really easy to solve. Only thing is, that my Peertube instance is in Dutch language and i can't find an option to change it 🥴

          Anyway, i shall do my best to help you get there, because there's a setting for that...

          As Peertube admin logged into your instance,
          Go to:

          Administration > Configuration > Basic >

          In there you scroll (almost) all the way down, until you reached the "user import/export" settings.
          There you will also find the value for max take out.

          Set it to your desired value and voila 😎

          luckowL Offline
          luckowL Offline
          luckow
          translator
          wrote on last edited by
          #8

          @DanTheMan same here e81e1b0e-04b7-4d49-b0f0-7cf82023a141-image.png

          Pronouns: he/him | Primary language: German

          1 Reply Last reply
          0
          • DanTheManD Offline
            DanTheManD Offline
            DanTheMan
            wrote on last edited by DanTheMan
            #9

            Thanks for the report😉

            definitely a 🐛 somewhere...

            I already did some deep diving into the error, but it's kinda complicated...

            I found an older post that explains a little about the error in relation with postgresql..
            https://stackoverflow.com/questions/52238781/postgres-integer-out-of-range-why-this-error-occur

            And some pure details:
            https://pganalyze.com/docs/log-insights/app-errors/U130#:~:text=Explanation%3A,large value into the database.

            I guess it's better (like Girish mentioned) to report this upstream with the developers of Peertube...

            @girish I'm no database expert, but isn't this something that has to be done on the database that holds Peertube on Cloudron, Postgresql?
            Like to adjust the integer to the appropriate values of the database of Peertube?

            I'm gonna report it on their Github and keep this forum post updated when I have more info from there...

            girishG 1 Reply Last reply
            2
            • DanTheManD DanTheMan

              Thanks for the report😉

              definitely a 🐛 somewhere...

              I already did some deep diving into the error, but it's kinda complicated...

              I found an older post that explains a little about the error in relation with postgresql..
              https://stackoverflow.com/questions/52238781/postgres-integer-out-of-range-why-this-error-occur

              And some pure details:
              https://pganalyze.com/docs/log-insights/app-errors/U130#:~:text=Explanation%3A,large value into the database.

              I guess it's better (like Girish mentioned) to report this upstream with the developers of Peertube...

              @girish I'm no database expert, but isn't this something that has to be done on the database that holds Peertube on Cloudron, Postgresql?
              Like to adjust the integer to the appropriate values of the database of Peertube?

              I'm gonna report it on their Github and keep this forum post updated when I have more info from there...

              girishG Offline
              girishG Offline
              girish
              Staff
              wrote on last edited by
              #10

              @DanTheMan said in Peertube export not working...:

              Like to adjust the integer to the appropriate values of the database of Peertube?

              My reading of the error is that the app (peertube) contructed a sql query and the query has a bug in it. Let me know what the upstream devs say, happy to fix accordingly.

              1 Reply Last reply
              1
              • DanTheManD Offline
                DanTheManD Offline
                DanTheMan
                wrote on last edited by DanTheMan
                #11

                I reported upstream and this is the outcome:
                https://github.com/Chocobozzz/PeerTube/commit/e7ebcb16acbd43043fd7f95e8918b8ab50595796

                Should be fixed within the next update(s) of Peertube 👍

                I'll keep an eye open 🧐

                1 Reply Last reply
                3
                • DanTheManD Offline
                  DanTheManD Offline
                  DanTheMan
                  wrote on last edited by DanTheMan
                  #12

                  Peertube has a new release, the export problem should be fixed in this one 😉

                  "Fix big user export file size"
                  https://github.com/Chocobozzz/PeerTube/releases/tag/v6.2.0#:~:text=Fix big user export file size

                  1 Reply Last reply
                  3
                  • nebulonN Offline
                    nebulonN Offline
                    nebulon
                    Staff
                    wrote on last edited by
                    #13

                    The release is out by now. Does it work again?

                    1 Reply Last reply
                    1
                    • nebulonN nebulon marked this topic as a question on
                    • nebulonN nebulon forked this topic on
                    • DanTheManD Offline
                      DanTheManD Offline
                      DanTheMan
                      wrote on last edited by DanTheMan
                      #14

                      I saw this post as still being "unsolved".

                      Yesterday i succefully downloaded a exported backup from my Peertube instance (35GB).

                      So that's working fine now 👌

                      Did not yet import it to another instance. But will try to do that in a short matter of time...

                      1 Reply Last reply
                      0
                      • nebulonN nebulon has marked this topic as solved on
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • Bookmarks
                      • Search