[MDEV-12275] debian-start spams the syslog after an upgrade - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Affects Version/s: 10.0(EOL), 10.3(EOL)
Fix Version/s: 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3, 10.9.1
Component/s: Platform Debian, Scripts & Clients
Labels:
Environment:
Debian Jessie amd64

Description

After upgrading MariaDB 10.0 using the MariaDB repository (even a minor upgrade), debian-start.sh executes mysql_upgrade and sends its output to the syslog.

The default behavior of mysql_upgrade is to output "database.table OK" for each tables that didnt require an upgrade.
The server i did upgrade have more than 200000 tables, which means that more than 200000 log lines are added to the syslog that does just states that nothing has been done.

Suggested fix : Add '--silent' to the call of "mysql_upgrade" which should only log tables that have been upgraded.

Attachments

Issue Links

relates to

MDEV-12576 Upgrade MariaDB 10.0 from Distro to 10.1 from MariaDB Repo does not happen

Closed

Activity

Ascending order - Click to sort in descending order

Tuukka Pasanen added a comment - 2022-03-21 09:26

Is there any down sides that you add '--silent' to upgrade? otto Can you come any downside that user can't see huge logs?

Tuukka Pasanen added a comment - 2022-03-21 09:26 Is there any down sides that you add '--silent' to upgrade? otto Can you come any downside that user can't see huge logs?

Otto Kekäläinen added a comment - 2022-03-21 18:25

I don't know. Do we have a normal output and --silent output examples to
view and compare to see what they reveal/hide?

Otto Kekäläinen added a comment - 2022-03-21 18:25 I don't know. Do we have a normal output and --silent output examples to view and compare to see what they reveal/hide?

Tuukka Pasanen added a comment - 2022-04-04 06:51

Ok I need to test what test suppress

Tuukka Pasanen added a comment - 2022-04-04 06:51 Ok I need to test what test suppress

Tuukka Pasanen added a comment - 2022-05-03 07:39

Testing this on systemd system is not easy but this should not make any harm

Tuukka Pasanen added a comment - 2022-05-03 07:39 Testing this on systemd system is not easy but this should not make any harm

Tuukka Pasanen added a comment - 2022-05-03 07:41

danblack could you take look on PR.

Tuukka Pasanen added a comment - 2022-05-03 07:41 danblack could you take look on PR.

People

Assignee:: Tuukka Pasanen

Reporter:: Jean Weisbuch

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2017-03-15 13:54

Updated:: 2022-05-05 00:22

Resolved:: 2022-05-05 00:22

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server