Bug 46435 – Call mysql_upgrade in 4.3 postup

Bug 46435 - Call mysql_upgrade in 4.3 postup


Summary:	Call mysql_upgrade in 4.3 postup

Status:	CLOSED FIXED

Product:	UCS
Classification:	Unclassified
Component:	MySQL
Version:	UCS 4.3
Hardware:	Other Linux

Importance:	P5 normal (vote)
Target Milestone:	UCS 4.3
Assigned To:	Erik Damrose
QA Contact:	Stefan Gohmann

URL:
Keywords:	interim-3

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2018-02-27 13:20 CET by Erik Damrose
Modified:	2018-03-14 14:38 CET (History)
CC List:	1 user (show)

See Also:
What kind of report is it?:	Development Internal
What type of bug is this?:	---
Who will be affected by this bug?:	---
How will those affected feel about the bug?:	---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Erik Damrose

2018-02-27 13:20:04 CET

Although the mariadb-server package / scripts contain logic for this, mysql-upgrade is not called when updating to UCS 4.3. We should call the script in our postup to fix potential DB issues.

One known issue that this fixes is correcting the permissions for the mysql.proc table.

Comment 1 Erik Damrose

2018-02-27 13:31:33 CET

f457d4ae Run mysql_upgrade in postup
univention-updater 13.0.1-21A~4.3.0.201802271328

f457d4ae changelog

Comment 2 Erik Damrose

2018-02-27 15:10:47 CET

I missed redirecting the output to the updater log.

4ab33155 Run mysql_upgrade in postup; redirect output
univention-mariadb 1.0.1-3A~4.3.0.201802271510

Comment 3 Stefan Gohmann

2018-03-02 08:31:45 CET

Code review: OK

Changelog: OK

Tests: OK, /usr/bin/mysql_upgrade is executed in postup.sh

Comment 4 Stefan Gohmann

2018-03-14 14:38:54 CET

UCS 4.3 has been released:
 https://docs.software-univention.de/release-notes-4.3-0-en.html
 https://docs.software-univention.de/release-notes-4.3-0-de.html

If this error occurs again, please use "Clone This Bug".