• Public UDD mirror not updated

    From Andreas Tille@21:1/5 to All on Wed Nov 30 06:50:01 2022
    Hi,

    when logging into public UDD mirror and doing a simple example query

    udd=> select source, version, release from sources where source='r-cran-blockmodeling';
    source | version | release ----------------------+---------+----------
    r-cran-blockmodeling | 0.1.8-1 | stretch
    r-cran-blockmodeling | 0.3.4-1 | buster
    r-cran-blockmodeling | 1.0.0-1 | bullseye
    r-cran-blockmodeling | 1.1.3-1 | bookworm
    r-cran-blockmodeling | 1.1.3-1 | sid

    I realise that it is lagging behind what UDD has. If you look at

    https://tracker.debian.org/pkg/r-cran-blockmodeling

    the package even migrated to testing with version 1.1.4 so I guess
    the public mirror was not updated the last 2-3 days.

    Could you please have a look?

    Thanks a ton anyway for thie great service

    Andreas.

    --
    http://fam-tille.de

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Mattia Rizzolo@21:1/5 to Andreas Tille on Thu Dec 1 09:40:01 2022
    On Wed, Nov 30, 2022 at 06:46:34AM +0100, Andreas Tille wrote:
    I realise that it is lagging behind what UDD has.
    […]
    Could you please have a look?

    Already looking at https://udd-mirror.debian.net/ shows that the last
    update was on the 26th.

    It seems one import failed due to ENOSPC, despite more than 30 GB
    available...
    No idea what's that about, so I just kicked it for now.

    --
    regards,
    Mattia Rizzolo

    GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
    More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'`
    Debian QA page: https://qa.debian.org/developer.php?login=mattia `-

    -----BEGIN PGP SIGNATURE-----

    iQIzBAEBCgAdFiEEi3hoeGwz5cZMTQpICBa54Yx2K60FAmOIZlgACgkQCBa54Yx2 K61FnA//XsdSbFidyiWxkaAEhH7zUsH82LOBoMbZ0VrBaWHU1p/FmRSF5mpCA1pi suIus9s7r0HHnSP64PM7FiEfEGwvHTe9EvpOQRyFwbDOugrZMEKb8t0mMU4ByFsE VTEmOxP7oNhnIY+4z3bN0wL4S+OfLfpewgsi/7o+WjbPuWNPYqRoueq3nHelxFze muCGYKZyJnUDnXlXFVzOG8SLeYkV/N4A5mhPAoFibQ+gOGMkuNsAPZz2o8DKWYLD 9FWj+xbzVywZc6uW1CEkpbPXgSCCUUoyJvCHOUREA3JAsH/2KRZaowu9UFrRUH1V WwlfUxI7JrWnzN7NdyvGfE2ci3IEbczIwVoar+Z557j9hreYucEHYUDT9nM6M0NT jxiq5gMbIwh5H9Ffdrh4NSXp6VzNobfOc+AvG2rCer5tujAFHuME9Ab1TIV0XJ4m /rOUdommAnLK+aBg4v6VPXTc5676yUOPNVc8esnDR6ufMceDn3Lc4SLStuaw76s4 uQ+IDNwkU1oaORjv5LzVfIYbkLHhyUW2rTsJg3ZiXpuvMnktSsN
  • From Stuart Prescott@21:1/5 to Mattia Rizzolo on Fri Dec 2 01:50:01 2022
    On 01/12/2022 19:31, Mattia Rizzolo wrote:
    On Wed, Nov 30, 2022 at 06:46:34AM +0100, Andreas Tille wrote:
    I realise that it is lagging behind what UDD has.
    […]
    Could you please have a look?

    Already looking at https://udd-mirror.debian.net/ shows that the last
    update was on the 26th.

    It seems one import failed due to ENOSPC, despite more than 30 GB available...
    No idea what's that about, so I just kicked it for now.

    This is familiar...

    On another (non-public) UDD mirror I had a similar problem when ullmann
    was upgraded to bullseye while the mirror was still running (*cough*)
    jessie. The format of the postgresql dump changed slightly and so
    importing the dump into the mirror started failing. Delightfully, pg
    felt the need to include the entirety of the failed dump in its logs, so
    the log files grew by many GB every cron run, and ENOSPC ensued,
    rotating logs cleaned up some space, people were confused.

    That said, the timing of this failure doesn't seem right for this to be
    the problem, which should have hit in the last days of October 2022.

    If, however, this is indeed the same problem, then upgrading the mirror
    so that it has a newer postgresql should be enough. Alternatively,
    removing a single offending line from the dump makes the dump compatible
    with the older postgresql:

    $ xzcat $DUMP | sed "/SET default_table_access_method = heap;/d" | psql…

    ymmv!

    cheers
    Stuart

    --
    Stuart Prescott http://www.nanonanonano.net/ [email protected]
    Debian Developer http://www.debian.org/ [email protected]
    GPG fingerprint 90E2 D2C1 AD14 6A1B 7EBB 891D BBC1 7EBB 1396 F2F7

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)