tickets #60557
closedprovo-mirror: mirrorbrain database complains about needing an update
100%
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 ...]
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.
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.
Updated by lrupp over 4 years ago
JFYI: The current PostgreSQL 12 server does not like our mb tool...
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.