- discuss - lists.mariadb.org

[Maria-discuss] New Question: Fresh Installation of Mariadb
by AskMonty KB 09 Apr '16

09 Apr '16

Hello, A new question has been asked in "MariaDB Binary Packages" by francis_adekunle_45706. Please answer it at http://mariadb.com/kb/en/fresh-installation-of-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are in the process of setting up our Developments env on Cloud Foundry and Mariadb is the DB of choice. I have Oracle background. I m trying to download and install the Mariadb software binaries as well as setup the database in our development environment. OS is RHEL 6.5 and I tried to use yum to install but got error message. I also obtain the tar.zip file and uncompressed the file on the linux server but most of the files are zero bytes.. Questions: a) What binaries do I need to download for Mariadb installation? b) What OS username and group id etc..would I be installing Mariadb as? c) Where do I get Mariadb files to download since I m having issue with yum.. I m trying to get a Maria db book but need the above basic info to get started. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/fresh-installation-of-mariadb/

1 0

[Maria-discuss] systemctl startup script gives “WSREP: Failed to recover position” - manual startup works
by Lukas Lehner 08 Apr '16

08 Apr '16

Hi please post your ideas http://dba.stackexchange.com/questions/134762/systemctl-startup-script-give… best Lukas

1 0

[Maria-discuss] New Question: Galera errors in mysqld.log but works OK
by AskMonty KB 08 Apr '16

08 Apr '16

Hello, A new question has been asked in "MariaDB Community" by aferrett. Please answer it at http://mariadb.com/kb/en/galera-errors-in-mysqldlog-but-works-ok/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a 3 node Galera cluster that I am testing. It generally works OK, and I have been doing various failure / recovery tests as part of a certification project. I continuously get 3 error messages even though it is working OK. I'd like to eliminate any unnecessary error messages so that DBAs would not taking time to resolve this in a production situation. Here is a sampling of the three errors: I included a bit before and after the error for context: 2016-04-06 11:01:22 140287919777536 [Note] WSREP: Quorum results: version = 3, component = PRIMARY, conf_id = 26, members = 3/3 (joined/total), act_id = 8017357, last_appl. = 0, protocols = 0/7/3 (gcs/repl/appl), group UUID = db762c6b-e246-11e5-90df-4adee5e6b24e 2016-04-06 11:01:22 140287919777536 [Note] WSREP: Flow-control interval: [28, 28] 2016-04-06 11:01:22 140290187433728 [Note] WSREP: New cluster view: global state: db762c6b-e246-11e5-90df-4adee5e6b24e:8017357, view# 27: Primary, number of nodes: 3, my index: 2, protocol version 3 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 2016-04-06 11:01:22 140290187433728 [ERROR] WSREP: Process completed with error: /opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…: 1 (Operation not permitted) 2016-04-06 11:01:22 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 11:01:22 140290187433728 [Note] WSREP: REPL Protocols: 7 (3, 2) 2016-04-06 11:01:22 140287985837824 [Note] WSREP: Service thread queue flushed. 2016-04-06 11:01:22 140290187433728 [Note] WSREP: Assign initial position for certification: 8017357, protocol version: 3 2016-04-06 11:01:22 140287985837824 [Note] WSREP: Service thread queue flushed. 2016-04-06 16:18:22 140287930267392 [Note] WSREP: (8180e0ba, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.242.60.235:4567 I grepped for just one of the errors so you can get an idea of the frequency: 2016-04-06 1:58:15 140290151147264 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 2:15:49 140290151147264 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 2:15:49 140290151147264 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Donor" 2016-04-06 3:40:41 140287908230912 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced" 2016-04-06 9:28:48 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 9:29:00 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 10:05:09 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 10:07:34 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 11:01:10 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 11:01:22 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" mysql@zlx70605 /opt/app/mysql -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-errors-in-mysqldlog-but-works-ok/

1 0

[Maria-discuss] New Question: Java Client 1.4.0 Release Notes
by AskMonty KB 08 Apr '16

08 Apr '16

Hello, A new question has been asked in "MariaDB Connector/J" by Sebastian_S. Please answer it at http://mariadb.com/kb/en/java-client-140-release-notes/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Why Jira CONJ-260: "Add jdbc nString, nCharacterStream, nClob implementation" (https://jira.mariadb.org/browse/CONJ-260) is on BugFix list of Java Client 1.4.0 Release Notes since it is not implemented and already moved to release 1.5.0? Sebastian Stroz -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/java-client-140-release-notes/

1 0

[Maria-discuss] expire_logs_days
by Reindl Harald 07 Apr '16

07 Apr '16

i find a config variable with "days" just annoying - why - because in case of thin-provisioned virtual servers it wastes space in environment where the slave is for sure not down longer then a view hours and if it is longer sown it's just my problem to act http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_…

2 2

[Maria-discuss] First MariaDB Berlin Meetup
by Colin Charles 06 Apr '16

06 Apr '16

Hi! Many of the core server developers for MariaDB Server and MariaDB MaxScale will be having a meetup in Berlin, on April 12 2016 at Wikimedia’s offices. Feel free to drop by, have a drink, say hi, and listen to the upcoming plans http://www.meetup.com/MariaDB-Developers-Berlin-Meetup/events/230026151/ Looking forward to seeing you if you’re local to Berlin, and if you have friends that would be interested, please feel free to forward this note to them Thanks Kind Regards, Colin Charles -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

1 0

[Maria-discuss] New Question: can maxscal support router like this?
by AskMonty KB 06 Apr '16

06 Apr '16

Hello, A new question has been asked in "MaxScale Routers" by hei_yingzi_(darkz)_g. Please answer it at http://mariadb.com/kb/en/can-maxscal-support-router-like-this/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have some server storage some records,like this server_id -> column value server1 -> s1 server2 -> s2 server3 -> s3 server4 -> s4 table table_name1 struce like column1,column2,sid a,1,s1 when I query select * from table_name1 where sid=s1, then route the query to server1 ... select * from table_name1 where sid=s2, then route the query to server2 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/can-maxscal-support-router-like-this/

1 0

[Maria-discuss] New Question: MariaDB support
by AskMonty KB 05 Apr '16

05 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-faq-mariadb-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is 32 bit linux client machines supported...if mariadb server is installed on 64bit machines only? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-faq-mariadb-support/

1 0

[Maria-discuss] New Question: MariaDB support
by AskMonty KB 05 Apr '16

05 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- In the mariadb subscription packages Email and web support is provided. Is there any provision for phone support and any forum which is mainly for enterprises so that there bugs or issues can be resolved immediately?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-support/

1 0

[Maria-discuss] New Question: MariaDB Monitoring
by AskMonty KB 05 Apr '16

05 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-monitoring/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- are there any other monitoring tools other than MONyog and Nagios?? like for eg cacti or any other ?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-monitoring/

1 0