Failed to load slave replication state from table mysql.gtid_slave_pos:1146:table ' mysql.gtid_slave_pos ' doesn ' t exist

Http://anothermysqldba.blogspot.com/2013/06/mariadb-1003-alpha-install-on-fedora-17.htmlMariaDB 10.0.3 Alpha Install on Fedora x86_64

MariaDB 10.0.3 Alpha was just released.
So for those of the recall my previous MariaDB 5.5 install post, I decided to see how it works with 10.0.3.

I like some of the features that is going into the MariaDB and Percona releases. Even if you is a big supporter of MySQL, when features is available in these releases that is not being back ported int o MySQL releases DBAs has to review their options and make a choice.

So the install ....

As I said before from the previous post I had this installed. So I'll just to an upgrade first.


[[email protected] 10]# rpm -qa | grep maria
mariadb-5.5.31-1.fc17.x86_64
mariadb-server-5.5.31-1.fc17.x86_64
mariadb-libs-5.5.31-1.fc17.x86_64
mariadb-bench-5.5.31-1.fc17.x86_64
mariadb-devel-5.5.31-1.fc17.x86_64


So packages conflicted at the start.


MariaDB-10.0.3-fedora17-x86_64-client.rpm
MariaDB-10.0.3-fedora17-x86_64-common.rpm
MariaDB-10.0.3-fedora17-x86_64-compat.rpm
MariaDB-10.0.3-fedora17-x86_64-connect-engine.rpm
MariaDB-10.0.3-fedora17-x86_64-devel.rpm
MariaDB-10.0.3-fedora17-x86_64-server.rpm
MariaDB-10.0.3-fedora17-x86_64-shared.rpm
MariaDB-10.0.3-fedora17-x86_64-test.rpm
 
[[email protected] 10]# rpm -Uhv *.rpm
warning: MariaDB-10.0.3-fedora17-x86_64-client.rpm: Header V3 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
error: Failed dependencies:
    libodbc.so.2()(64bit) is needed by MariaDB-connect-engine-10.0.3-1.x86_64
    MySQL-devel conflicts with (installed) mariadb-devel-5.5.31-1.fc17.x86_64 

MariaDB-server-10.0.3-1.x86_64 conflicts with file from package mariadb-server-5.5.31-1.fc17.x86_64 
[[email protected] 10]# 


Just a Virtualbox instance , for demo and evaluation, so I just removed all that I could and had to uninstal  L. I was hopeful a upgrade would work, but the is Alpha code still.
Ie:


[[email protected] 10]# rpm -e mariadb mariadb-server mariadb-bench
[[email protected] 10]# rpm -e mariadb-libs perl-DBD-MySQL percona-xtrabackup


So now, the past is cleared out ...


[Email protected] 10]# RPM-IHV *.rpm
Preparing ... ########################################### [100%]
1:mariadb-common ########################################### [11%]
2:mariadb-server ########################################### [22%]
3:mariadb-cassandra-engin########################################### [33%]
4:mariadb-client ########################################### [44%]
5:mariadb-devel ########################################### [56%]
6:mariadb-shared ########################################### [67%]
7:mariadb-test ########################################### [78%]
8:mariadb-compat ########################################### [89%]
9:galera ########################################### [100%]


If you recall the past post, I got the init.d script this time:


[[email protected] 10]# /etc/init.d/mysql start
Starting MySQL..... SUCCESS!
[[email protected] 10]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.0.3-MariaDB MariaDB Server


If They is not terrible on performance then I does not see why these is not on by default:


vi /etc/my.cnf
[mysqld]
userstat=1
# http://www.percona.com/doc/percona-server/5.5/diagnostics/user_stats.html?id=percona-server:features:userstatv2 
# https://kb.askmonty.org/en/user-statistics/  
Feedback=on
# https://kb.askmonty.org/en/user-feedback-plugin/
MariaDB [(None)]> show variables like '%feedback% ';
+--------------------------+------------------------------------------+
| variable_name | Value |
+--------------------------+------------------------------------------+
| feedback_send_retry_wait | 60 |
| Feedback_send_timeout | 60 |
...
| Feedback_url | Https://mariadb.org/feedback_plugin/post |
|                                          Feedback_user_info | |
+--------------------------+------------------------------------------+
MariaDB [(none)]> show variables like ‘%userstat%‘;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| userstat      | ON    |
+---------------+-------+



Issues I found 30seconds after install ...:


MariaDB [(none)]> show variables;
ERROR 1946 (HY000): Failed to load replication slave GTID position from table mysql.gtid_slave_pos 


That's it so far ... I have it installed and can review now ...

UPDATE:
I have the submitted this as a bug. The MariaDB team got right, back to me, and pointed out, that I failed to run Mysql_upgrade and restart. That fixed the Error listed above. Still variables feels like it should show everything it had but it's a valid fix and mistake on my part. Thank you to the MariaDB team.


To learn more:

• https://kb.askmonty.org/en/mariadb-1003-release-notes/
• http://www.percona.com/live/ Mysql-conference-2013/sites/default/files/slides/mariadb10andwhatsnewwiththeproject-130426094744-phpapp01.pdf