- discuss - lists.mariadb.org

[Maria-discuss] warning from binary tarball file installation.
by Peter Boston 28 Feb '15

28 Feb '15

I am installing mariadb-10.0.15 on Fedora 20 from a binary tarball file. After several changes on .my.cnf file, I minimized the installation warning to three. I am using the default my-large.cnf file from the release. How can I eliminate them, particularly the last one: Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist. Thanks, [root@dev2 mysql]# ./scripts/mysql_install_db --defaults-file=~/.my.cnf --user=mysql Installing MariaDB/MySQL system tables in './data' ... 150225 10:37:35 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 10:37:35 [Note] InnoDB: The InnoDB memory heap is disabled 150225 10:37:35 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 10:37:35 [Note] InnoDB: Memory barrier is not used 150225 10:37:35 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 10:37:35 [Note] InnoDB: Using Linux native AIO 150225 10:37:35 [Note] InnoDB: Not using CPU crc32 instructions 150225 10:37:35 [Note] InnoDB: Initializing buffer pool, size = 384.0M 150225 10:37:35 [Note] InnoDB: Completed initialization of buffer pool 150225 10:37:35 [Note] InnoDB: The first specified data file /usr/local/mysql/data/ibdata1 did not exist: a new database to be created! 150225 10:37:35 [Note] InnoDB: Setting file /usr/local/mysql/data/ibdata1 size to 2000 MB 150225 10:37:35 [Note] InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 150225 10:37:42 [Note] InnoDB: Data file /usr/local/mysql/data/ibdata2 did not exist: new to be created 150225 10:37:42 [Note] InnoDB: Setting file /usr/local/mysql/data/ibdata2 size to 10 MB 150225 10:37:42 [Note] InnoDB: Database physically writes the file full: wait... 150225 10:37:42 [Note] InnoDB: Setting log file /usr/local/mysql/data/ib_logfile101 size to 100 MB InnoDB: Progress in MB: 100 150225 10:37:43 [Note] InnoDB: Setting log file /usr/local/mysql/data/ib_logfile1 size to 100 MB InnoDB: Progress in MB: 100 150225 10:37:43 [Note] InnoDB: Renaming log file /usr/local/mysql/data/ib_logfile101 to /usr/local/mysql/data/ib_logfile0 150225 10:37:43 [Warning] InnoDB: New log files created, LSN=45782 150225 10:37:43 [Note] InnoDB: Doublewrite buffer not found: creating new 150225 10:37:43 [Note] InnoDB: Doublewrite buffer created 150225 10:37:43 [Note] InnoDB: 128 rollback segment(s) are active. 150225 10:37:43 [Warning] InnoDB: Creating foreign key constraint system tables. 150225 10:37:43 [Note] InnoDB: Foreign key constraint system tables created 150225 10:37:43 [Note] InnoDB: Creating tablespace and datafile system tables. 150225 10:37:43 [Note] InnoDB: Tablespace and datafile system tables created. 150225 10:37:43 [Note] InnoDB: Waiting for purge to start 150225 10:37:43 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 0 150225 10:37:43 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 150225 10:37:43 [Note] InnoDB: FTS optimize thread exiting. 150225 10:37:43 [Note] InnoDB: Starting shutdown... 150225 10:37:45 [Note] InnoDB: Shutdown completed; log sequence number 1616698 OK Filling help tables... 150225 10:37:45 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 10:37:45 [Note] InnoDB: The InnoDB memory heap is disabled 150225 10:37:45 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 10:37:45 [Note] InnoDB: Memory barrier is not used 150225 10:37:45 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 10:37:45 [Note] InnoDB: Using Linux native AIO 150225 10:37:45 [Note] InnoDB: Not using CPU crc32 instructions 150225 10:37:45 [Note] InnoDB: Initializing buffer pool, size = 384.0M 150225 10:37:45 [Note] InnoDB: Completed initialization of buffer pool 150225 10:37:45 [Note] InnoDB: Highest supported file format is Barracuda. 150225 10:37:45 [Note] InnoDB: 128 rollback segment(s) are active. 150225 10:37:45 [Note] InnoDB: Waiting for purge to start 150225 10:37:45 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 1616698 150225 10:37:46 [Note] InnoDB: FTS optimize thread exiting. 150225 10:37:46 [Note] InnoDB: Starting shutdown... 150225 10:37:48 [Note] InnoDB: Shutdown completed; log sequence number 1616708 OK

2 1

[Maria-discuss] Default privileges for anon. user.
by dE 26 Feb '15

26 Feb '15

Hi! I've realized that by default MariaDB allow full access to a database for anon. users. $ mysql --user asdfasdf test MariaDB [test]> insert into test (sr) values (1); Query OK, 1 row affected (0.12 sec) I tried to revoke but -- Revoke all on test.test from ''@''; ERROR 1141 (42000): There is no such grant defined for user '' on host '%' Is there anyway to disallow all types of access to anon. users?

2 2

[Maria-discuss] questions from a new user
by Peter Boston 25 Feb '15

25 Feb '15

I am new to use mariadb on linux machine. I am using Fedora 20 and I have downloaded the mariadb 10.0.15 tar.gz file and its instruction. I removed the existing mariadb from my Fedora 20. I have installed the mariadb on my machine by following the official instruction. It seems successful (without error) but I cannot start it as expected. I also have few other basic questions. Some background information here: this database will be accessed by a local application. This local application may be running under a general user account, user1. I installed it in /var/local as a root user. Questions: 1. How to uninstall it completely? I want to try again to see if I did anything wrong before. 2. Because it will be accessed by a local application and the local application will be running by a general user, user1, should I install it with user1? 3. Basically I am confused with these three users: user1, mysql and root. "user1" will be used to run the application and login the machine. "mysql" will be used to connect the mariadb. "root" will be used to install mariadb into /usr/local. Who will start the mariadb? It will be "root", I guess. But if "root" starts the service, "user1" and "mysql" don't have problem to access its resources? 4. If I don't want to install it as root, can I still install it under the /usr/local directory? 5. I renamed the my-large.cnf to .my.cnf and uncomment the InnoDB table section. Is this only change I need to make if I want to use InnoDB? should I disable the myisam? how? 6. where should I put the .my.cnf file? put into the home directory of the user who starts the mariadb or the user who logon the system if they are different? 7. there is a my.cnf file from the Fedora 20 installation, when I start mariadb without the "--defaults-file=~/.my.cnf" option, I will get the following error from the log: [ERROR] mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 "No such file or directory") I have to manually create the mysqld folder inside the /var/run folder each time after reboot. how to avoid this? 8. After started with that "old" my.cnf, I try to stop the mariadb but cannot because I cannot find its service name: [user1@dev2 mysql]$ ./bin/mysqladmin -u root -p status Enter password: Uptime: 685 Threads: 1 Questions: 3 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 62 Queries per second avg: 0.004 [user1@dev2 mysql]$ sudo systemctl status mariadb.service mariadb.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) [user1@dev2 mysql]$ sudo systemctl status mysql.service mysql.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) [user1@dev2 mysql]$ sudo systemctl status mysqld.service mysqld.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) how stop it? 9. if I start mariadb with the renamed my-large.cnf ([root@dev2 mysql]# ./bin/mysqld_safe --defaults-file=~/.my.cnf --user=mysql), I got the following error: 150225 0:09:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 150225 0:09:28 [Note] Recovering after a crash using mysql-bin 150225 0:09:28 [Note] Starting crash recovery... 150225 0:09:28 [Note] Crash recovery finished. 150225 0:09:28 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 150225 0:09:28 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 150225 0:09:28 [Note] Server socket created on IP: '::'. 150225 0:09:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 150225 00:09:28 mysqld_safe mysqld from pid file /usr/local/mysql/data/dev2.pid ended Then I try do upgrade as suggested above: [root@dev2 mysql]# ./bin/mysql_upgrade Version check failed. Got the following error when calling the 'mysql' command line client ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2 "No such file or directory") FATAL ERROR: Upgrade failed so I think I need to make the mariadb running first, I use above 7 to make server running and then do upgrade, I got the following errors: [user1@dev2 mariadb-10.0.15-linux-x86_64]$ sudo ./bin/mysql_upgrade [sudo] password for user1: Phase 1/5: Checking 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 Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine status : Operation failed 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 Error : Table 'mysql.innodb_index_stats' doesn't exist in engine status : Operation failed mysql.innodb_table_stats Error : Table 'mysql.innodb_table_stats' doesn't exist in engine status : Operation failed 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.user OK Repairing tables mysql.gtid_slave_pos Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine status : Operation failed mysql.innodb_index_stats Error : Table 'mysql.innodb_index_stats' doesn't exist in engine status : Operation failed mysql.innodb_table_stats Error : Table 'mysql.innodb_table_stats' doesn't exist in engine status : Operation failed Phase 2/5: Running 'mysql_fix_privilege_tables'... ERROR 1932 (42S02) at line 580: Table 'mysql.innodb_index_stats' doesn't exist in engine ERROR 1932 (42S02) at line 583: Table 'mysql.innodb_table_stats' doesn't exist in engine FATAL ERROR: Upgrade failed why I cannot run mariadb with the my.cnf which comes with this version of mariadb? The old my.cnf doesn't have innoDB section and I cannot enable it. Is this the reason? does the Fedora 20 support mariadb 10.0.15? Thanks, Peter

3 4

[Maria-discuss] New Question: other connectors
by AskMonty KB 24 Feb '15

24 Feb '15

Hello, A new question has been asked in "Client Libraries" by ferreirah. Please answer it at http://mariadb.com/kb/en/other-connectors/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Any plans for connectors for the dot net framework? H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/other-connectors/

1 0

[Maria-discuss] SHOW GRANTS: MySQL vs. MariaDB
by Felipe Gasper 24 Feb '15

24 Feb '15

Hi all, We have custom logic in place that “suspends” a MySQL user by: - reversing the password hash - replacing the leading “*” with “-” In other words (pseudo-code): my $hash = SELECT password FROM mysql.user WHERE user = 'theuser'; $hash = $hash.replace(/^\*/,"").reverse(); UPDATE mysql.user SET password = "-$hash" WHERE user = 'theuser'; I have noticed that MySQL’s SHOW GRANTS reports these “suspended” password hashes with the leading dash “fixed” to a leading asterisk. MariaDB 10, though, has SHOW GRANTS report the literal contents of mysql.user. Is this behavior by design in MariaDB 10? Is it behavior that we can depend on moving forward? -FG

2 1

[Maria-discuss] Dependency questions regarding MariaDB 10 on CentOS6.5 with local mirror of repo
by Sophie L 23 Feb '15

23 Feb '15

Hi everybody, I mirrored MariaDB repo,but noticed servers had unmet dependencies when I tried to install. I have this message: Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libssl.so.1.0.0()(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libcrypto.so.1.0.0()(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.17)(64bit) Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.14)(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.17)(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.15)(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.14)(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.14)(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: aaa_base Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) My server has libstdc++ 4.4.7. Can MariaDb 10 run with this recent version? My apologies if this is not specific to MariaDB. Maybe it it. Would somebody give me some advice? Kind regards, Sophie. Some details, Linux maria1 2.6.32-431.5.1.el6.x86_64 #1 SMP Wed Feb 12 00:41:43 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux # cat /etc/centos-release CentOS release 6.5 (Final) # locate libstdc++.so.6 /usr/lib64/libstdc++.so.6 /usr/lib64/libstdc++.so.6.0.13 # locate libc.so.6 /lib64/libc.so.6 Installed Packages Name : libstdc++ Arch : x86_64 Version : 4.4.7 Release : 4.el6 Size : 964 k Repo : installed >From repo : anaconda-CentOS-201311291202.x86_64

3 4

[Maria-discuss] Mariadb galera tolerance to network and io latency
by Lyle Franklin 21 Feb '15

21 Feb '15

Recently we observed that when network and IO latency increased significantly (and correspondingly, that bandwidth reduced significantly) all nodes in a 3-node mariadb galera cluster reported the other nodes as partitioned. We understand that by default galera is configured to wait 6 seconds before declaring other nodes partitioned. Is there any additional documentation on the performance on mariadb/galera with respect to network/IO latency and bandwidth? Are there hard limits beyond which a cluster is known to fail, and soft limits which are known to degrade performance? Thanks, Rob and Lyle Cloud Foundry Core Services

1 0

[Maria-discuss] New Question: Replication with 2 different minor version
by AskMonty KB 20 Feb '15

20 Feb '15

Hello, A new question has been asked in "Standard Replication" by micimici. Please answer it at http://mariadb.com/kb/en/replication-with-2-different-minor-version/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hallo Support I have a question about replication As source... I have MariaDB 5.5.37 and destination is 5.5.41 Do you know if replication will work with those 2 different versions ? thanks for any info -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/replication-with-2-different-minor-version/

1 0

[Maria-discuss] R: Re: R: Re: R: Re: Switch from rsync to xtrabackup
by absolutely_free＠libero.it 18 Feb '15

18 Feb '15

Ok, thank you all, switch to xtrabackup-v2 accomplished :)

2 1

Re: [Maria-discuss] MariaDB 10.0.16 now available
by Nirbhay Choubey 18 Feb '15

18 Feb '15

Hi Raina, On Tue, Feb 17, 2015 at 1:04 PM, Raina Masand <rmasand(a)pivotal.io> wrote: > Hi Nirbhay, > > Now that Galera 25.3.9 is available, we have tried swapping it in with our > MariaDB 10.0.16 cluster. Seems to work so far, but wondering whether there > are plans to vet this Galera release as the officially recommended version? > I see that the currently recommended Galera version is 25.3.5, which was > released quite a while ago. Any news as to their compatibility would be > appreciated. > I have just finished running some tests on 10.0.16 with galera-25.3.9 with no failure. So, you should be good. By the way, we have not yet released galera-25.3.9 packages, planning to release them in upcoming MariaDB Galera cluster release. Best, Nirbhay > > Thanks, > > Raina and Lyle > Cloud Foundry Services Team > > On Tue, Feb 3, 2015 at 3:15 PM, Nirbhay Choubey <nirbhay(a)mariadb.com> > wrote: > >> Hi! >> >> On Tue, Feb 3, 2015 at 5:25 PM, Raina Masand < >> cf-core-services-eng(a)pivotal.io> wrote: >> >>> Hello, >>> >>> We are looking to use Galera 25.3.9 with our MariaDB cluster, which >>> claims to improve the stability of communication between nodes in the event >>> of network flakiness. Do you know if it will be compatible with MariaDB >>> 10.0.16? The release notes for MariaDB Galera Cluster 10.0.16 seem to >>> suggest that this should be safe, but it would be useful to know the >>> official recommendation. >>> >> >> MariaDB Galera 10.0.16 should be compatible with any 25.x.x galera >> versions. But, 25.3.9, in particular, has not been tested yet with MGC. >> >> Best, >> Nirbhay >> >> >>> Thanks, >>> >>> Raina and Lyle >>> Cloud Foundry Services Team >>> >>> On Wed, Jan 28, 2015 at 6:45 AM, Daniel Bartholomew <dbart(a)mariadb.com> >>> wrote: >>> >>>> On Wed, Jan 28, 2015 at 9:39 AM, Peter Laursen < >>>> peter_laursen(a)webyog.com> wrote: >>>> > YaST "Online Update" interface did not (both yesterday and two hours >>>> ago), >>>> > does not and will not identify that there is an upgrade available for >>>> > MariaDB 10.0.15, when there actually was/is. I cannot decide it this >>>> is an >>>> > issue with the RPM packaging or the repo configuration. But something >>>> is not >>>> > correct for SuSE. >>>> >>>> Ok, I'll look into it. >>>> >>>> Thanks! >>>> >>>> -- >>>> Daniel Bartholomew, MariaDB Release Manager >>>> MariaDB | http://mariadb.com >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~maria-discuss >>>> Post to : maria-discuss(a)lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~maria-discuss >>>> More help : https://help.launchpad.net/ListHelp >>>> >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~maria-discuss >>> Post to : maria-discuss(a)lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~maria-discuss >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >

1 0