[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
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
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
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