[arch-general] Maria update
this mornings update of mariadb failed with this error:- Phase 7/7: Running 'FLUSH PRIVILEGES' OK Could not create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' in the MariaDB Servers datadir, errno: 13 what does it mean and how do I fix it mick, freezing in glen innes
Maybe this? https://www.archlinux.org/news/mariadb-104x-update-requires-manual-intervent... /Emil On Fri, 28 Jun 2019, 03:10 mick howe via arch-general, < arch-general@archlinux.org> wrote:
this mornings update of mariadb failed with this error:- Phase 7/7: Running 'FLUSH PRIVILEGES' OK Could not create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' in the MariaDB Servers datadir, errno: 13
what does it mean and how do I fix it
mick, freezing in glen innes
did that 7 phases earlier here is the FULL output from that command string systemctl restart mariadb.service && mariadb-upgrade -u root -p Enter password: Phase 1/7: Checking and upgrading mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.gtid_slave_pos OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.transaction_registry OK mysql.user OK Phase 2/7: Installing used storage engines... Skipped Phase 3/7: Fixing views Phase 4/7: Running 'mysql_fix_privilege_tables' Phase 5/7: Fixing table and database names Phase 6/7: Checking and upgrading tables Processing databases information_schema performance_schema webtrees webtrees.wt_block OK webtrees.wt_block_setting OK webtrees.wt_change OK webtrees.wt_dates OK webtrees.wt_default_resn OK webtrees.wt_families OK webtrees.wt_favorite OK webtrees.wt_gedcom OK webtrees.wt_gedcom_chunk OK webtrees.wt_gedcom_setting OK webtrees.wt_hit_counter OK webtrees.wt_individuals OK webtrees.wt_link OK webtrees.wt_log OK webtrees.wt_media OK webtrees.wt_message OK webtrees.wt_module OK webtrees.wt_module_privacy OK webtrees.wt_module_setting OK webtrees.wt_name OK webtrees.wt_news OK webtrees.wt_next_id OK webtrees.wt_other OK webtrees.wt_placelinks OK webtrees.wt_placelocation OK webtrees.wt_places OK webtrees.wt_session OK webtrees.wt_site_access_rule OK webtrees.wt_site_setting OK webtrees.wt_sources OK webtrees.wt_user OK webtrees.wt_user_gedcom_setting OK webtrees.wt_user_setting OK Phase 7/7: Running 'FLUSH PRIVILEGES' OK Could not create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' in the MariaDB Servers datadir, errno: 13 On Fri, 28 Jun 2019 at 01:14, Emil Lundberg <lundberg.emil@gmail.com> wrote:
Maybe this?
https://www.archlinux.org/news/mariadb-104x-update-requires-manual-intervent...
/Emil
On Fri, 28 Jun 2019, 03:10 mick howe via arch-general, < arch-general@archlinux.org> wrote:
this mornings update of mariadb failed with this error:- Phase 7/7: Running 'FLUSH PRIVILEGES' OK Could not create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' in the MariaDB Servers datadir, errno: 13
what does it mean and how do I fix it
mick, freezing in glen innes
mick howe via arch-general <arch-general@archlinux.org> on Fri, 2019/06/28 01:37:
Could not create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' in the MariaDB Servers datadir, errno: 13
What's the permission of /var/lib/mysql directory? I guess these were borked before without being noticed. My systems have 0700 with mysql:mysql. -- main(a){char*c=/* Schoene Gruesse */"B?IJj;MEH" "CX:;",b;for(a/* Best regards my address: */=0;b=c[a++];) putchar(b-1/(/* Chris cc -ox -xc - && ./x */b/42*2-3)*42);}
Am 28.06.19 um 11:49 schrieb Christian Hesse:
mick howe via arch-general <arch-general@archlinux.org> on Fri, 2019/06/28 01:37:
Could not create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' in the MariaDB Servers datadir, errno: 13
What's the permission of /var/lib/mysql directory? I guess these were borked before without being noticed. My systems have 0700 with mysql:mysql.
That is normal if you run mariadb-upgrade as an unprivileged user. It will work if you execute it as root or the mysql user. Your database has been upgraded successfully, but the logfile has not been written. You can ignore the error if you don't need the logfile.
participants (4)
-
Christian Hesse
-
Emil Lundberg
-
mick howe
-
ProgAndy