Project

General

Profile

Actions

tickets #60557

closed

provo-mirror: mirrorbrain database complains about needing an update

Added by cboltz over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Servers hosted in Provo
Target version:
-
Start date:
2019-12-03
Due date:
% Done:

100%

Estimated time:

Description

Since some days, mirrorbrain on provo-mirror sends mails about needing a database update (which then seems to fail) to admin-auto.

This started last friday (Nov 29) around 3:00 CET.

Subject: Cron <root@pontifex>   test -x /usr/bin/create_mirrorbrain-webpages && /usr/bin/create_mirrorbrain-webpages  
Date: Friday, 29. November 2019, 03:00:01 CET
From: (Cron Daemon) <root@provo-mirror.opensuse.org>
To: admin-auto@opensuse.org

Your database needs to be upgraded (to 2.18.0): creating "version" table...
Traceback (most recent call last):
  File "/usr/bin/mb", line 1688, in <module>
    r = mirrordoctor.main()
  File "/usr/lib/python2.7/site-packages/cmdln.py", line 251, in main
    retval = self.postoptparse()
  File "/usr/bin/mb", line 83, in postoptparse
    self.conn = mb.conn.Conn(self.config.dbconfig, debug = self.options.debug)
  File "/usr/lib64/python2.7/site-packages/mb/conn.py", line 177, in __init__
    SQLObject._connection.query(query)
  File "/usr/lib/python2.7/site-packages/sqlobject/dbconnection.py", line 414, in query
    return self._runWithConnection(self._query, s)
  File "/usr/lib/python2.7/site-packages/sqlobject/dbconnection.py", line 327, in _runWithConnection
    val = meth(conn, *args)
  File "/usr/lib/python2.7/site-packages/sqlobject/dbconnection.py", line 411, in _query
    self._executeRetry(conn, conn.cursor(), s)
  File "/usr/lib/python2.7/site-packages/sqlobject/postgres/pgconnection.py", line 172, in _executeRetry
    raise ProgrammingError(ErrorMessage(e))
sqlobject.dberrors.ProgrammingError: relation "version" already exists

[... repeated several times ...]
Actions #1

Updated by cboltz over 4 years ago

  • Private changed from Yes to No
Actions #2

Updated by lrupp over 4 years ago

  • Status changed from New to Workable
  • Assignee set to lrupp

Taking over. This might be a left over from years ago...
But the whole setup should be revised anyway.

Actions #3

Updated by lrupp over 4 years ago

  • Status changed from Workable to In Progress
  • % Done changed from 0 to 70

Disabled the cron jobs for now: provo-mirror needs to be rebased on the latest mirrorbrain packages and the database behind (running on nala.infra.opensuse.org) should also get an update.

IMHO we should setup a VPN tunnel between the two locations (NUE and PRV), to allow either the scanner (olaf) to sync to both, independent databases or we add nala as slave to mirrordb1. IMHO (especially for testing), it might be cool to have nala feeded by an independent scanner machine. But I'm unsure how many mirror servers allow a scan from outside the scanner network range.

Actions #4

Updated by lrupp over 4 years ago

JFYI: The current PostgreSQL 12 server does not like our mb tool...

Actions #5

Updated by lrupp over 4 years ago

  • Status changed from In Progress to Closed
  • % Done changed from 70 to 100

Closing for now: patch exists and just needs final testing. After that, the whole setup needs to get a rewramp anyway.
At least there should not be any mails sent out any more.

Actions

Also available in: Atom PDF