- discuss - lists.mariadb.org

[Maria-discuss] ibdata1 file grow quickly in MariaDB 10.1 ?
by Ljr Yang 25 Aug '16

25 Aug '16

Hi, All we use MariaDB 10.1.16 , about have 30 machines. Recently ,there one master and slave's ibdat1 growed to about 4GB, others machine are normal. mainly parameter in my.cnf : innodb_data_home_dir = /data/mysql/data innodb_data_file_path = ibdata1:2G:autoextend innodb_log_files_in_group=3 innodb_log_file_size = 1G innodb_undo_logs=128 innodb_undo_tablespaces=4 innodb_file_per_table= 1 ls -l /data/mysql/data -rw-r--r-- 1 mysql mysql 4429185024 Aug 25 21:38 ibdata1 -rw-r--r-- 1 mysql mysql 1073741824 Aug 25 21:38 ib_logfile0 -rw-r--r-- 1 mysql mysql 1073741824 Aug 25 21:38 ib_logfile1 -rw-r--r-- 1 mysql mysql 1073741824 Aug 25 20:13 ib_logfile2 -rw-r--r-- 1 mysql mysql 616562688 Aug 25 21:36 undo001 -rw-r--r-- 1 mysql mysql 411041792 Aug 25 21:27 undo002 -rw-r--r-- 1 mysql mysql 708837376 Aug 25 21:34 undo003 -rw-r--r-- 1 mysql mysql 981467136 Aug 25 21:34 undo004 Today, when found the problem, there are not some big transaction in show processlist. We guess ibdata1 had growed to 4GB in previous some time, but we want to know how confirm the cause and shrink ibdate1 file ? Thank . -- Ljr

2 1

[Maria-discuss] MariaDB 10.0.27 now available
by Daniel Bartholomew 25 Aug '16

25 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.27. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.27 - Release Notes: https://mariadb.com/kb/en/mdb-10027-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10027-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.27 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: Maria DB Account Deletion
by AskMonty KB 25 Aug '16

25 Aug '16

Hello, A new question has been asked in "MariaDB Community" by tomibic. Please answer it at http://mariadb.com/kb/en/maria-db-account-deletion/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi there, Does anybody know how to delete one's MariaDB account? Help would be really appreaciated! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maria-db-account-deletion/

1 0

[Maria-discuss] Spider Engine
by Suresh Rajagopal 24 Aug '16

24 Aug '16

Hi, I am looking for some references for Spider Engine in production. Any known issues/recommendations for setup ? ThanksSuresh Rajagopal

2 2

[Maria-discuss] Backporting bug fixes to 1.0?
by Justin Swanhart 24 Aug '16

24 Aug '16

I have created a GitHub fork of MaxScale which does not include the 2.0 branch. The repository is called GPLScale. There is a big potential problem with this. Take for example the file server/core/utils.c, which now has a new license: https://github.com/mariadb-corporation/MaxScale/blob/2.0/server/core/utils.c This file WAS covered under GPL: https://github.com/mariadb-corporation/MaxScale/blob/cb3213af6382c380df9fc4… When there is a bugfix in 2.0 for server code that existed in 1.0, can that code be backported directly into GPLscale? a) util.c in 2.0 is clearly derivative of 1.0, and is therefore a derivative work of 1.0 and therefore still covered by GPL and b) there is a "violation" of GPL, because 1.0 GPL code is being linked against code covered by an incompatible license (other code in MaxScale). Almost all of the files in MaxScale 2.0 derive from 1.0 so this problem is not just in one file of course. The FSF says that the owner of the software can't legally violate the GPL they can morally violate the GPL. Will MariaDB commit to backporting all bugs in 1.0 code into the 1.0 branch?

2 4

Re: [Maria-discuss] Backporting bug fixes to 1.0?
by Federico Razzoli 24 Aug '16

24 Aug '16

Thank you for expressing your honest opinions about the MySQL/MariaDB ecosystem. Best wishes for your next job and your open source projects. Federico -------------------------------------------- Mer 24/8/16, Justin Swanhart <greenlion(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] Backporting bug fixes to 1.0? A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 24 agosto 2016, 14:21 I have been fired for speaking out about the GPL and MariaDB actions that have caused great harm to our ecosystem. It has been pointed out that I have a non-compete agreement. None of my tools compete with MariaDB and I have no non-public knowledge of MariaDB technology. GPLScale remains free software under the GNU GPL license and it is my right to fork a github repo. I am not paid to work on GPLScale and I don't intend to get paid to maintain it by anyone. All my projects are labors of love. Who wants to hire me? I'm dedicated, honest, open, and I have integrity. I'm willing to risk everything for what I believe in. Email me at:greenlion at gmail dot com ---- I have been a proponent of GPL for a long time, and I don't need publicity.http://swanhart.livejournal.com/128586r.html https://libraries.io/github/greenlion https://blog.jcole.us/2008/07/23/on-mysql-forks-and-mysqls-non-open-source-… Swanhart on July 23, 2008 at 12:09Brian, The “thing is” that we shouldn’t have to write it. MySQL may be ‘open source’, but it isn’t ‘open software’. With all the talk recently of proprietary extensions, the documentation licensing issues, the whole ‘enterprise’ vs ‘community’ debacle, well, MySQL has totally shown that they are not ‘Open Software’ company. WHEN I WAS SEVENTEEN I BROKE THE LAW AND DROVE FROM PITTSBURGH PA TO BOSTON MA FOR THE FIRST FREE SOFTWARE FOUNDATION CONFERENCE. I sat down and had breakfast with STALLMAN, TORVALDS, AND RAYMOND! My whole life is open source. I've made my living off it and I intend to make sure others have the same opportunities that I have. Sent from my iPhone On Aug 18, 2016, at 9:51 AM, Justin Swanhart <greenlion(a)gmail.com> wrote: I have created a GitHub fork of MaxScale which does not include the 2.0 branch. The repository is called GPLScale. There is a big potential problem with this. Take for example the file server/core/utils.c, which now has a new license: https://github.com/mariadb-corporation/MaxScale/blob/2.0/server/core/utils.c This file WAS covered under GPL: https://github.com/mariadb-corporation/MaxScale/blob/cb3213af6382c380df9fc4… When there is a bugfix in 2.0 for server code that existed in 1.0, can that code be backported directly into GPLscale? a) util.c in 2.0 is clearly derivative of 1.0, and is therefore a derivative work of 1.0 and therefore still covered by GPL and b) there is a "violation" of GPL, because 1.0 GPL code is being linked against code covered by an incompatible license (other code in MaxScale). Almost all of the files in MaxScale 2.0 derive from 1.0 so this problem is not just in one file of course. The FSF says that the owner of the software can't legally violate the GPL they can morally violate the GPL. Will MariaDB commit to backporting all bugs in 1.0 code into the 1.0 branch? -----Segue allegato----- _______________________________________________ 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

[Maria-discuss] New Question: Prepared statements support in MariaDB
by AskMonty KB 23 Aug '16

23 Aug '16

Hello, A new question has been asked in "Does MariaDB support..." by Sibin.. Please answer it at http://mariadb.com/kb/en/prepared-statements-support-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Can you please tell me if MariaDB supports Prepared statements (related instrumentation were added in MySQL-5.7.4)? If not, then please tell me in which MariaDB version support for prepared statements will be added ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/prepared-statements-support-in-mariadb/

1 0

[Maria-discuss] New Question: How to use Maxscale for maximum reliability?
by AskMonty KB 22 Aug '16

22 Aug '16

Hello, A new question has been asked in "MaxScale Routers" by patrik_63236. Please answer it at http://mariadb.com/kb/en/how-to-use-maxscale-for-maximum-reliability/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to use Maxscale in front of a Galera cluster. Performance is not an issue. The reason I'm using it is so that I can take down a node for maintenance and upgrades without downtime. But I'm not sure how to achieve this. When I run m my tests I get failures. I suspect that the problem occurs when Maxscale writes to one node and then immidiately tries to read that data from another node. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-use-maxscale-for-maximum-reliability/

1 0

[Maria-discuss] New Question: Connectin Excel with MariaDB
by AskMonty KB 21 Aug '16

21 Aug '16

Hello, A new question has been asked in "MariaDB Connector/ODBC" by alejandro_reyna_g. Please answer it at http://mariadb.com/kb/en/connectin-excel-with-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello ! A Question from a begginer. I have been trying to connect Excel 2007 with MariaDB. 1) I downloaded the latest ODBC connector. 2) I created in Windows a new ODBC connection fron the control panel 3) From excel I created selected the connection and I can only see the TEST and PERFORMANCE_SCHEMA Databases. I don´t see any of my DataTables. What could be happening? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connectin-excel-with-mariadb/

1 0

[Maria-discuss] New Question: MONyog ssh authentication using private key
by AskMonty KB 19 Aug '16

19 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-ssh-authentication-using-private-key/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- When we configure the ssh connection and we choose the key based authentication method we have to copy paste the private ssh keys...IS there any other way to get the private key or authenticate by giving the public key...something like that?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-ssh-authentication-using-private-key/

1 0

[Maria-discuss] New Question: MONyog SNMP Traps
by AskMonty KB 19 Aug '16

19 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-snmp-traps/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- When we are sending the traps seems like the tags are not present in the raw data. Also the server name is the name which we give rather than the actual host name.. Is it possible to add tags and get the original host via SNMP traps?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-snmp-traps/

1 0

[Maria-discuss] Query the list of dynamic variables
by Игорь Пашев 19 Aug '16

19 Aug '16

If there are way to query the list of dynamic variables, e. i. variables that can be changed globally without restarting the server?

2 2

[Maria-discuss] maxscale 2.0 bug fixes
by Federico Razzoli 18 Aug '16

18 Aug '16

Hi all I see that MaxScale 2.0 will not be open source until 2009.01.01. I have some questions. 1) I expect next releases to fix bugs, including critical and security bugs. When will these versions be open source? 2) At some point MaxScale 2.0 will be open and 3.0 will be released but not open. When a software exists in both an open and a closed source, I expect the open form to be low-quality. This applies to all examples I can think of. I will feel a bit better if you could explain why you will maintain 2.0 for a reasonable number of years. 3) From my understanding part of MariaDB code belongs to Oracle, thus cannot be closed-sourced by you. But what about connectors and some storage engines? Do you plan to change their license? Thanks in advance for your answers. Federico

5 4

Re: [Maria-discuss] maxscale 2.0 bug fixes
by Federico Razzoli 17 Aug '16

17 Aug '16

Hi Kaj Yes you did answer all my questions. Thanks for that. I disagree about point 2, precisely the "reasonable number of years" a server software should be supported. Even if a software is very old (say MySQL 5.0 for example) it is very possible that new security holes are found. That's why customers using servers/versions which reached their EOL should definitely upgrade to a more recent version. (yes there are exceptions, but I'm talking about the general case) Let's get back to your example: on 2019.01.02 MaxScale 3.0 could be out and GA. Should we expect the typical user to be ready to upgrade? Based on my experience, definitely not. They need time to decode, plan, test, etc. The possibility that 2.0 will be discontinued (or almost discontinued) immediately after the Change Date is scary, and your answer doesn't provide any guarantees that this won't happen. So, as much as I appreciate your honest answers, and as much as I like the software itself, I am seriously concerned. And also, let me add that I don't like to use a software that is not (yet) open source. I totally understand the problems explained by Monty in his blog post, but I don't like the solution you've found. However I am glad to hear that you don't have plans to do the same changes to connectors and storage engines. If I may give an advice, maybe the Foundation should officially "protect" that software to dissipate any doubt. Regards, Federico -------------------------------------------- Mer 17/8/16, Kaj Arnö <kaj(a)mariadb.com> ha scritto: Oggetto: Re: maxscale 2.0 bug fixes A: "Federico Razzoli" <federico_raz(a)yahoo.it>, maria-discuss(a)lists.launchpad.net Data: Mercoledì 17 agosto 2016, 20:23 Hi Federico, Thank you for your questions. Wed, 17 Aug 2016 08:15:33 +0000 (UTC) Federico Razzoli <federico_raz(a)yahoo.it>:Hi all I see that MaxScale 2.0 will not be open source until 2009.01.01. I have some questions. 1) I expect next releases to fix bugs, including critical and security bugs. When will these versions be open source? 1. Fixes to 2.0 will be in 2.0.1, 2.0.2, 2.0.3 and so on. All of these will become "GPLv2 or later" on 2019-01-01. 2) At some point MaxScale 2.0 will be open and 3.0 will be released but not open. When a software exists in both an open and a closed source, I expect the open form to be low-quality. This applies to all examples I can think of. I will feel a bit better if you could explain why you will maintain 2.0 for a reasonable number of years. 2. At some point (say: 2019-01-02), MaxScale 2.0 will be "GPLv2 or later", but another release (say: MaxScale 2.1 or MaxScale 3.0) will not yet be "GPLv2 or later" but still BSL, correct. MaxScale 2.0 will by then have gone through a list of bug fix releases. I don't expect there to be many bugs left in the MaxScale 2.0 code on 2019-01-02. In a way, what I am saying is that the period until the Change Date is already "a reasonable number of years". What the *exact* situation is on 2019-01-02 depends on how many new releases we will have by then. At any rate, we want to grow the user base of MaxScale. We are interested in large-scale adoption. There won't be much adoption if we don't fix bugs for a "reasonable number of years". All in all, on 2019-01-02, MaxScale 2.0 will be bug-wise of high quality and the only reason to use 2.1 (or 3.0 or whatever) instead of 2.0 will be the added functionality on top of what 2.0 has. So MariaDB Corporation has a high motivation to add desirable functionality. 3) From my understanding part of MariaDB code belongs to Oracle, thus cannot be closed-sourced by you. But what about connectors and some storage engines? Do you plan to change their license? 3. Correct, MariaDB Server cannot be closed sourced by us. We have no current plans for changing licenses of any connectors or storage engines. Thanks in advance for your answers.Federico Did this answer your questions? Kaj-- Kaj Arnö, Chief of Staff MariaDB Corporation

1 0

[Maria-discuss] New Question: Range of values for INT
by AskMonty KB 17 Aug '16

17 Aug '16

Hello, A new question has been asked in "Data Types" by cay_mia_g. Please answer it at http://mariadb.com/kb/en/range-of-values-for-int/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I believe the note for INT above: Integer from -2147483648 to 2147483648 signed Should be corrected to: Integer from -2147483648 to 2147483647 signed -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/range-of-values-for-int/

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.51 & Connector/J 1.5.1 now available
by Daniel Bartholomew 17 Aug '16

17 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.51 Stable (GA), and MariaDB Connector/J 1.5.1 Release Candidate (RC). See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.51 Stable (GA) - Release Notes: https://mariadb.com/kb/en/mgc-5551-rn/ - Changelog: https://mariadb.com/kb/en/mgc-5551-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.51 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.5.1 RC - Release Notes: https://mariadb.com/kb/en/mcj-151-rn/ - Changelog: https://mariadb.com/kb/en/mcj-151-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.5.1/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: MONyog ssh authentication using key
by AskMonty KB 17 Aug '16

17 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-ssh-authentication-using-key/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have monyog installed on server a and mariadb on server b. When i give the key for ssh connection on a user on b it gives me error "Could not get private key:access denied. What is this error and why do we have to give private key?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-ssh-authentication-using-key/

1 0

Re: [Maria-discuss] Semi-sync replication hangs when changing binlog filename.
by Joseph Glanville 16 Aug '16

16 Aug '16

Hi Pavel. Yes, by "binlog filename changes" I mean the master begins writing to a new binlog file. Output of all the requested commands are in this gist: https://gist.github.com/josephglanville/7b96c34bb6e79ace33e56627672b98a5 Joseph Glanville Sent from Polymail<https://polymail.io/?utm_source=polymail&utm_medium=referral&utm_campaign=s…> On Fri, 29 Jul 2016 at 3:08 PM Pavel Ivanov <Pavel Ivanov <mailto:Pavel%20Ivanov%20<pivanof(a)google.com>> > wrote: By "binlog filename changes" you mean when master starts writing binlogs into a new file? Can you clarify how the replication stalls? What "show processlist" shows at that time on master and on slave? What does "show slave status" show on the slave? On Thu, Jul 28, 2016 at 10:03 PM, Will Fong wrote: > Hi Joseph, > > On Fri, Jul 29, 2016 at 10:11 AM, Joseph Glanville wrote: >> However whenever the binlog filename changes the replication stalls >> indefinitely. > > Interesting! I may have reproduced this, but it was only a quick test. > Let me (or someone else) dig into this more. > > Thanks for reporting this. > -will > > > -- > Will Fong, Senior Support Engineer > MariaDB Corporation > > _______________________________________________ > 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

4 16

Re: [Maria-discuss] can we use load data infile from moving a database to a 4 node cluster
by Guillaume Lefranc 16 Aug '16

16 Aug '16

unfortunately no, you can't do that. your cluster needs to be empty. Maybe have a look at mydumper/myloader that has parallel dump and restore capabilities? Regards GL On Tue, Aug 16, 2016 at 10:30 AM bbnlaccts acnts <bbnlaccts(a)gmail.com> wrote: > Thanks for the help Guillaume, > Can we take a snapshot of a standalone database and run against a cluster > which already has many other databases running on it ? > > Also an u please do point me to a link which talks about this methodology. > > Please do let me know > > Thanks in advance for helping out. > > Arun > > > On Tue, Aug 16, 2016 at 1:51 PM, Guillaume Lefranc < > guillaume.lefranc(a)mariadb.com> wrote: > >> Hi Arun, >> >> Galera requires only InnoDB tables, so the fastest way would be to take >> an Xtrabackup snapshot of your MariaDB 10 standalone database, restore it >> on one node of the Galera cluster and then turn on the 3 other nodes. >> >> Of course LOAD DATA INFILE is supported by Galera, but it would be slower. >> >> On Tue, Aug 16, 2016 at 9:55 AM bbnlaccts acnts <bbnlaccts(a)gmail.com> >> wrote: >> >>> Hi, >>> I am planning on moving a mariadb 10 database to a 4 node galera cluster. >>> Since the db is kind of big with around 40 gigs capacity and i am >>> getting very less maintenance window to complete this activity. >>> Hence planning on using load data infile on alll the big tables. >>> >>> Can anybody please do let me know if i am going to see any >>> drawbacks/bugs in this concept. >>> Are there any precautionary measures i need to take in order to >>> accomplish this task. >>> >>> Your help is greatly appreciated >>> >>> Thanks >>> Arun >>> _______________________________________________ >>> 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 >>> >> -- >> Guillaume Lefranc >> Remote DBA Services Manager >> MariaDB Corporation >> > > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation

1 0

[Maria-discuss] can we use load data infile from moving a database to a 4 node cluster
by bbnlaccts acnts 16 Aug '16

16 Aug '16

Hi, I am planning on moving a mariadb 10 database to a 4 node galera cluster. Since the db is kind of big with around 40 gigs capacity and i am getting very less maintenance window to complete this activity. Hence planning on using load data infile on alll the big tables. Can anybody please do let me know if i am going to see any drawbacks/bugs in this concept. Are there any precautionary measures i need to take in order to accomplish this task. Your help is greatly appreciated Thanks Arun

2 1

[Maria-discuss] Regarding Automatic fail-over - Maxscale
by Karthick Subramanian 16 Aug '16

16 Aug '16

Hi All, Can anyone help me to figure out this. I am planning to use Binlogrouter for replication (single master and single slave topology). I read from google forums for maxscale that with binlog router, it'snot possible to use automatic failover. Did anyone try this. >From google forum ( https://groups.google.com/forum/#!msg/maxscale/DnFT4eb0BbQ/cHQ3TLEfBAAJ;con… ) "With the 1.3.0 version of MaxScale, the binlogrouter accepts STOP SLAVE, START SLAVE and CHANGE MASTER TO ... commands. These can be used to change the master server but automating this process with the repmgr is not currently possible. Since the binlogrouter supports the normal slave management commands, using something like MHA could be possible: https://code.google.com/p/mysql-master-ha/ " Could anyone help me to understand whether I can use binlog router along with automatic failover feature using maxscale. I have read this blog using shell script we can achieve, but not sure whether with binlog router, it ll work? ( https://mariadb.com/blog/mariadb-automatic-failover-maxscale-and-mariadb-re… ) Regards, Karth

2 2

[Maria-discuss] replication failing to recover due to HA_ERR_KEY_NOT_FOUND
by bbnlaccts acnts 16 Aug '16

16 Aug '16

Hi, I am trying to set up a master slave replication between 2 servers running mariadb 10 on centos 6.7 In the initial setup itself i keep getting HA_ERR_KEY_NOT_FOUND. I have tried all methodology based on my novice knowledge ro rectify but in vain. i am new to this env. Any help will be greatly appreciated. - Server version 10.0.23-MariaDB-log - Protocol version 10 - UNIX socket /var/lib/mysql/mysql.sock. The scenario I have followed is this: 1. Shut the prod (mc1), took a cold backup and restored on slave (mc2). 2. On master ran show master status; prodarchivedlogs-bin.000001 and the pos as 582240 3. Set these info in slave. 4. Started the slave, it started throwing up error: 160812 3:31:50 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table radius1.radacct; Can't find record in 'radacct', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log prodarchivedlogs-bin.000001, end_log_pos 587695, Gtid 0-1-79, Internal MariaDB error code: 1032 160812 3:17:18 [Warning] Slave: Can't find record in 'radacct' Error_code: 1032 160812 3:17:18 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'prodarchivedlogs-bin.000001' position 587072 I have tried all methods based on my knowledge, but it is just not functioning. I tried using mysqlbinlog tool to extract to a file and then tried inserting, even then it is failing. Any help will be greatly appreciated. The prod my.cnf is as follows symbolic-links=0 innodb_buffer_pool_size=10G innodb_data_home_dir= /var/lib/mysql/data2 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/redologs innodb_log_file_size = 256M innodb_buffer_pool_size = 10000M innodb_flush_method = O_DIRECT thread_stack = 256K max_connections=100000 expire_logs_days = 5 max_binlog_size = 100M log-bin=/backup/archivedlogs/prodarchivedlogs-bin binlog_format=row server-id=1 The slave my.cnf is as follows skip-name-resolve skip-slave-start datadir=/var/lib/mysql/data1 socket=/var/lib/mysql/mysql.sockuser=mysql symbolic-links=0 innodb_buffer_pool_size=10G innodb_data_home_dir= /var/lib/mysql/data2 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/redologs innodb_log_file_size = 256M innodb_buffer_pool_size = 10000M innodb_flush_method = O_DIRECT thread_stack = 256K max_connections=100000 expire_logs_days = 5 max_binlog_size = 100M log-bin=/backup/archivedlogs/prodarchivedlogs-bin binlog_format=row server-id=2

1 0

[Maria-discuss] New Question: ST_AsGeoJSON
by AskMonty KB 12 Aug '16

12 Aug '16

Hello, A new question has been asked in "Geographic Functions" by dbauszus. Please answer it at http://mariadb.com/kb/en/st_asgeojson/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Are there plans to implement ST_AsGeoJSON in MariaDB? This is by far the most widely use format to present data in web mapping applications. It will be a large overhead if we need to format records in the client prior to rendering the data on a web map. Best, Dennis -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/st_asgeojson/

1 0

[Maria-discuss] New Question: Percona XtraBackup Trigger Restore
by AskMonty KB 11 Aug '16

11 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/percona-xtrabackup-trigger-restore/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i restore the triggers using percona xtrabackup?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/percona-xtrabackup-trigger-restore/

1 0

[Maria-discuss] New Question: where can i download connector c which build with glibc2.11
by AskMonty KB 11 Aug '16

11 Aug '16

Hello, A new question has been asked in "MariaDB Connector/C" by shuianle. Please answer it at http://mariadb.com/kb/en/where-can-i-download-connector-c-which-build-with-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- i download mariadb-connector-c-2.3.0-linux-x86_64.tar.gz, it need glibc2.14, but my os is suse11 sp1 with glibc2.11, so it not work. Our customer user mysql now， and we have program use mysql connector c。 In the further，our customer will use mariadb。 The os is suse11 sp1，glib version is 2.11。So the download of mariadb connector can't work. Where can I download ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/where-can-i-download-connector-c-which-build-with-…

1 0

[Maria-discuss] Known limitation with TokuDB in Read Free Replication & parallel replication ?
by jocelyn fournier 10 Aug '16

10 Aug '16

Hi, After upgrading from TokuDB Enterprise with MariaDB 5.5 to MariaDB 10.1.14, I tried to enable the parallel replication (parallel_mode=optimistic, slave_parallel_threads=4) on a GTID enabled RFR slave, but it leads to random failures. (both master & slave are running 10.1.14) E.g : Could not execute Update_rows_v1 event on table sc_2.sc_param_index; Can't find record in 'sc_param_index', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.008418, end_log_pos 217608066 If I issue a start slave (with sql_slave_skip_counter=0) : Could not execute Update_rows_v1 event on table sc_2.sc_log_cron; Can't find record in 'sc_log_cron', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.008418, end_log_pos 218275984 If I put back slave_parallel_threads to 0, the slave keeps replicating happily without any issue. Is this a known limitation with TokuDB ? Tokudb configuration : tokudb_rpl_lookup_rows=0 tokudb_rpl_unique_checks=0 tokudb_pk_insert_mode=2 tokudb_directio = 1 Thanks and regards, Jocelyn Fournier

3 18

[Maria-discuss] MariaDB 5.5.51, Connector/J 1.5.0, & Connector/C 2.3.1 now available
by Daniel Bartholomew 10 Aug '16

10 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.51 Stable (GA), MariaDB Connector/J 1.5.0 Release Candidate (RC), and MariaDB Connector/C 2.3.1 Stable (GA). See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.51 Stable (GA) - Release Notes: https://mariadb.com/kb/en/mdb-5551-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5551-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.51 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.5.0 RC - Release Notes: https://mariadb.com/kb/en/mcj-150-rn/ - Changelog: https://mariadb.com/kb/en/mcj-150-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.5.0/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/C 2.3.1 - Release Notes: https://mariadb.com/kb/en/mcc-231-rn/ - Changelog: https://mariadb.com/kb/en/mcc-231-cl/ - Downloads: https://downloads.mariadb.org/connector-c/2.3.1/ About MariaDB Connector/C: - https://mariadb.com/kb/en/about-mariadb-connector-c/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: Percona XtraBackup restore
by AskMonty KB 09 Aug '16

09 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/percona-xtrabackup-restore/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i restore a single database from a full backup or from a single database backup?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/percona-xtrabackup-restore/

1 0

[Maria-discuss] Help on ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
by Karthick Subramanian 07 Aug '16

07 Aug '16

Dear Experts, I almost tried all sort of combinations that I think of very difficult to crack, but repeatedly failed to satisfy MariaDB not throw this error. Can anyone guide me on what is the specific needs for successful password. Warning message: +---------+------+----------------------------------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------------------------------+ | Warning | 1819 | cracklib: error loading dictionary | | Error | 1819 | Your password does not satisfy the current policy requirements | +---------+------+----------------------------------------------------------------+ Regards, Karth

2 2

[Maria-discuss] Discrepancy with innodb table statistics
by Mark Wadham 05 Aug '16

05 Aug '16

Can anyone explain this? http://pastebin.com/Zctaj8BE TL;DR index sizes seem to differ drastically in size depending on how you request them. Thanks, Mark

1 1

[Maria-discuss] New Question: 2 node replication failover/recovery
by AskMonty KB 03 Aug '16

03 Aug '16

Hello, A new question has been asked in "MariaDB Community" by greg_brownell_g. Please answer it at http://mariadb.com/kb/en/2-node-replication-failoverrecovery/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a way to automate the following: 1. 2 node system set up as master-master replication 2. node 1, master 1 fails. 3. node 2 master 2 is now the active instance. Up to here, all works well. Replication is fast enough. We detect failure and code now uses master 2 on node 2. The problem is sync'ing master 1 when the node 1 restarts, perhaps 5 minutes later. Requirement is: 1. node 2 master 2 continues to run without interruption 2. node 1 master 1 must sync as quickly as possible with node 2 master 2 3. this must be done without human intervention (using scripts, programs, whatever) Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/2-node-replication-failoverrecovery/

1 0

[Maria-discuss] New Question: MariaDB Backup using Percona XtraBackup
by AskMonty KB 03 Aug '16

03 Aug '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-backup-using-percona-xtrabacku… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Percona suggests to use the xtrabackup script for taking backup but it does not have anything to take compressed backup.The compact backup reduces the size of 48gb database to 47gb which is of no use. How to acheive compressed backup using percona xtrabackup utility?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-faq-mariadb-backup-using-percona-xtrabacku…

1 0

[Maria-discuss] New Question: How to trace events status?
by AskMonty KB 03 Aug '16

03 Aug '16

Hello, A new question has been asked in "Events" by dzlsnw53r4_60336. Please answer it at http://mariadb.com/kb/en/how-to-trace-events-status/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, I want to trace the events last results and fail events at 3 days, how can i do this? Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-trace-events-status/

1 0

[Maria-discuss] Orphaned TokuDB tables
by Rich Prohaska 02 Aug '16

02 Aug '16

Hello All, Sometimes, TokuDB gets left in a state where it thinks that parts of a table exist (as observed in TokuDB's file map), but not all of the underlying files (the TokuDB data files and/or the frm file) exist. This probably occurs due to the interaction between the non-transactional DDL that MySQL/MariaDB uses to create or drop tables, and the transactional TokuDB engine underneath. There is some bug there. So, what can one do to remove broken TokuDB file maps? There is an internal fractal tree called the tokudb.directory that names high level data names to an underlying file that the data is stored in. The tokudb_file_map information schema dumps out the contents of this tree. The key to this tree is the high level data name (called a dname). In TokuDB, this data name consists of the database name, the table name, and the index name. There is also a tree for the table (called status) that contains table wide metadata. I added the tokudb_delete_dnames_from_directory tool to the https://github.com/prohaska7/mariadb-server/tree/fix-tokudb-filemap branch. This standalone tool can be used to delete dnames from the tokudb.directory. Standalone means that MariaDB must have been previously shutdown cleanly (which puts the tokudb recovery logs in a nice clean state so that the tool does not have to run crash recovery). The input to the tool is the MariaDB data directory with nice and clean tokudb recovery logs along with a sequence of dname's. The tool transactionally deletes rows from the tokudb.directory fractal tree, which updates the recovery logs. Building the tool requires a MariaDB build environment a simple compile sequence something like this: gcc -g -o tokudb_delete_dnames_from_directory tokudb_delete_dnames_from_directory.cc -I$TFT/buildheader -L$TFT/src -ltokufractaltree Running the tool looks something like this: Get the dnames of interest from the tokudb_file_map. In this case, they are ./test/s-main and ./test/s-status. shutdown MariaDB ./tokudb_delete_dnames_from_directory ~/projects/mariadb-server-install/data ./test/s-main ./test/s-status

2 2

[Maria-discuss] New Question: Missing CentOS7 RPM: MariaDB-10.1.16-centos7-x86_64-cassandra-engine.rpm?
by AskMonty KB 02 Aug '16

02 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by justin.w.calloway_60714. Please answer it at http://mariadb.com/kb/en/missing-centos7-rpm-mariadb-10116-centos7-x86_64-c… as the person asking the question may not be subscribed to the mailing list. -------------------------------- It appears the rpm for the Cassandra storage engine is not available in your repository for centos7 or rhel7. The package exist in in centos 6 repository but not 7, is this on purpose? Is the Cassandra storage engine supported on CentOS7? Example of Cassandra storage engine rpm in the CentOS6 repo: http://yum.mariadb.org/10.1/centos6-amd64/rpms/ Example of the CentOS7 repo not containing the Cassandra storage engine rpm: http://yum.mariadb.org/10.1/centos7-amd64/rpms/ -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/missing-centos7-rpm-mariadb-10116-centos7-x86_64-c…

1 0

[Maria-discuss] New Question: MONyog Monitoring
by AskMonty KB 02 Aug '16

02 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-monitoring/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is MONyog capable of monitoring INNODB table locks and mutex locks?? Also can it monitor binary logs of MariaDB database.?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-monitoring/

1 0

[Maria-discuss] New Question: MONyog Table Alert
by AskMonty KB 02 Aug '16

02 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-table-alert/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i set up an alert for all the tables in all databases if they grow more than specified size ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-table-alert/

1 0

[Maria-discuss] Semi-sync replication hangs when changing binlog filename.
by Joseph Glanville 29 Jul '16

29 Jul '16

Hi, I am using semi-sync replication with the `rpl_semi_sync_master_timeout` set to a very high value to ensure commits aren't committed on the master unless they have been replicated to the slave. However whenever the binlog filename changes the replication stalls indefinitely. A trace of this interaction between the master and the semi-sync slave is here: https://gist.github.com/josephglanville/e87ae96b9be9125427b58cd3a43d5c1e The semi-sync settings I have configured on the master are: rpl_semi_sync_master_wait_point = "AFTER_SYNC" rpl_semi_sync_master_timeout = 18446744073709551615 # effectively infinite as we don't want to fallback to async repl rpl_semi_sync_master_enabled = 1 rpl_semi_sync_master_wait_no_slave = 1 # don't allow writes if slave isn't connected Up until the binlog filename change everything works as expected. Anyone have any ideas on how to fix the problem or is this a bug in semi-sync replication? Joseph.

3 3

[Maria-discuss] Orphaned TokuDB tables
by Reinis Rozitis 29 Jul '16

29 Jul '16

Hello, tldr - Is there a way (similarly as with the InnoDB workaround of DROP TABLE `#mysql50##sql-..') to delete an orphaned TokuDB table (and/or clean the information_schema.tokudb_file_map)? Or should I address this to Percona/Toku people? The long version: I have noticed on one db instance (currently running 10.0.26) and orphaned table (no idea how it got there): ls -la /data/mysql/db/ -rw-r----- 1 mysql mysql 1114 Jul 29 01:41 #sql-6f2d_9.frm -rw-r----- 1 mysql mysql 908 Jul 29 01:41 #sql-6f2d_9.par Also: MariaDB [(none)]> SELECT * FROM information_schema.tokudb_file_map limit 10; +--------------------------------+-----------------------------------------------------+--------------+------------+-----------------------+ | dictionary_name | internal_file_name | table_schema | table_name | table_dictionary_name | +--------------------------------+-----------------------------------------------------+--------------+------------+-----------------------+ | ./db/#sql-6f2d_9#P#p1-key-aid | ./_db_sql_6f2d_9_P_p1_key_aid_1734_2_1b_B_0.tokudb | db | #sql | 6f2d_9#P#p1-key-aid | | ./db/#sql-6f2d_9#P#p1-main | ./_db_sql_6f2d_9_P_p1_main_1734_2_1b_B_1.tokudb | db | #sql | 6f2d_9#P#p1-main | | ./db/#sql-6f2d_9#P#p1-status | ./_db_sql_6f2d_9_P_p1_status_1609_1_1b.tokudb | db | #sql | 6f2d_9#P#p1-status | .... While I can DROP the table: MariaDB [db]> drop table `#mysql50##sql-6f2d_9`; Query OK, 0 rows affected, 1 warning (3.99 sec) And even physically delete the ./_db_sql_6f2d_9_P* files from the root datadir it never disappears from the information_schema tables. It doesn't seem to currently affect anything but I wanted to know if maybe there is a workaround or other ways to rebuild to Toku directory (without dumping/reimporting the whole database). rr

2 2

[Maria-discuss] Crash when adding a column to a very large table
by Mark Wadham 27 Jul '16

27 Jul '16

Hi, MariaDB 10.1.16 with a 3-node galera cluster. We had 187GB free disk space and had the gcache set to 800GB. We started firing write traffic at the cluster and then began testing the process of performing DDL on a single node in RSU mode. Our command was a single ALTER TABLE statement that added a column to a ~160GB table. While this was occurring we were firing around 20GB/hour of write traffic at the cluster which was being collected in the gcache for catchup after the node completed the DDL. At around 3h 45min into the DDL process the node performing it crashed with an error indicating it was unable to write to a temporary ibdata file. There was still plenty of disk space available. Full crash log is below, if anyone can shed light on this we'd be very grateful. My own research so far suggests that the problem is because the ALTER TABLE statement inserts all of the rows into the newly rebuilt table at once, effectively requiring a rollback to be created for every row in the table and this is just too much for *some limit* that I haven't worked out yet. I saw a suggestion[1] to increase the number of ibdata files but this doesn't really make sense to me given that we have two and the second one is set to autoextend. It's a very slow debug process so I'd like to get a reasonable idea of what happened here before starting another test run. Thanks, Mark [1] http://dba.stackexchange.com/questions/68319/mysql-index-creation-failing-o… -------------------- 2016-07-27 8:45:59 140258863733504 [Note] InnoDB: Online DDL : Start 2016-07-27 8:45:59 140258863733504 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files 2016-07-27 9:42:23 140258863733504 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files 2016-07-27 9:42:23 140258863733504 [Note] InnoDB: Online DDL : Start merge-sorting index `PRIMARY` (1 / 4), estimated cost : 14.7886 2016-07-27 9:42:23 140258863733504 [Note] InnoDB: Online DDL : merge-sorting has estimated 72714 runs 2016-07-27 11:47:05 140258863733504 [Note] InnoDB: Online DDL : End of merge-sorting index `PRIMARY` (1 / 4) 2016-07-27 11:47:05 140258863733504 [Note] InnoDB: Online DDL : Start building index `PRIMARY` (1 / 4), estimated cost : 22.1242 2016-07-27 12:26:52 7f908fbfdb00 InnoDB: Error: Write to file ./db/#sql-ib16588-3044794026.ibd failed at offset 54409560064. InnoDB: 1048576 bytes should have been written, only 991232 were written. InnoDB: Operating system error n2016-07-27 12:26:52 140258863733504 [Note] InnoDB: Online DDL : Completed 2016-07-27 12:26:53 7f908fbfdb00 InnoDB: Assertion failure in thread 140258863733504 in file handler0alter.cc line 137 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 160727 12:26:53 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.1.16-MariaDB key_buffer_size=33554432 read_buffer_size=16777216 max_used_connections=4 max_threads=770 thread_count=11 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 37895560 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x7ebbabfb9008 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f908fbfd180 thread_stack 0x48400 (my_addr_resolve failure: fork) /usr/sbin/mysqld(my_print_stacktrace+0x2b) [0x555e557caaab] /usr/sbin/mysqld(handle_fatal_signal+0x475) [0x555e55327ef5] /lib64/libpthread.so.0(+0xf100) [0x7f90982ce100] /lib64/libc.so.6(gsignal+0x37) [0x7f909663b5f7] /lib64/libc.so.6(abort+0x148) [0x7f909663cce8] /usr/sbin/mysqld(+0x734ff9) [0x555e55491ff9] /usr/sbin/mysqld(+0x736eec) [0x555e55493eec] /usr/sbin/mysqld(+0x3a4c24) [0x555e55101c24] /usr/sbin/mysqld(mysql_alter_table(THD*, char*, char*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool)+0x27f9) [0x555e5523dff9] /usr/sbin/mysqld(Sql_cmd_alter_table::execute(THD*)+0x5d7) [0x555e5527f8b7] /usr/sbin/mysqld(mysql_execute_command(THD*)+0x140f) [0x555e551b533f] /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x28d) [0x555e551bd1ed] /usr/sbin/mysqld(+0x4602ec) [0x555e551bd2ec] /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x1c63) [0x555e551bf673] /usr/sbin/mysqld(do_command(THD*)+0x16b) [0x555e551c023b] /usr/sbin/mysqld(do_handle_one_connection(THD*)+0x17f) [0x555e5527c74f] /usr/sbin/mysqld(handle_one_connection+0x47) [0x555e5527c8a7] /lib64/libpthread.so.0(+0x7dc5) [0x7f90982c6dc5] /lib64/libc.so.6(clone+0x6d) [0x7f90966fcc9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7ebb7102f020): is an invalid pointer Connection ID (thread ID): 212 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. We think the query pointer is invalid, but we will try to print it anyway. Query: alter table delivery_person add column boris int(11) null 160727 12:26:58 mysqld_safe Number of processes running now: 0 160727 12:26:58 mysqld_safe WSREP: not restarting wsrep node automatically 160727 12:26:58 mysqld_safe mysqld from pid file /mysql/data/galera0.pid ended

1 0

[Maria-discuss] Finicky syntax with RETURNING?
by Rhys.Campbell＠swisscom.com 27 Jul '16

27 Jul '16

Hello All, I'm having a bit of an issue with the RETURNING feature of DELETE<https://mariadb.com/kb/en/mariadb/delete/>. This was introduced in MariaDB 10.0.5. Specifically there seems to be an issue when using aliases with the RETURNING keyword. It involves a query like this. A user came to me with queries of this form that were running slowly. Here is the explain plan... EXPLAIN DELETE from t1 where id in (select id from t1 where acc_id = 9999) \G *************************** 1. row *************************** id: 1 select_type: PRIMARY table: t1 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4675 Extra: Using where *************************** 2. row *************************** id: 2 select_type: DEPENDENT SUBQUERY table: t2 type: unique_subquery possible_keys: XXXXXXXXXX key: PRIMARY key_len: 4 ref: func rows: 1 Extra: Using where 2 rows in set (0.00 sec) You can see it's being forced to run a table scan and run the subquery for each row. This was fixed by properly aliasing the query... EXPLAIN EXTENDED DELETE uc from t1 AS uc where uc. id in (select p. id from t2 p where p.acc_id = 9999) \G *************************** 1. row *************************** id: 1 select_type: PRIMARY table: p type: ref possible_keys: XXXXXXXXXXXXXXXXXXXXXXXX key: uk_XXXXXXXXXXXXXXXXXXXX key_len: 4 ref: const rows: 1 filtered: 100.00 Extra: Using index *************************** 2. row *************************** id: 1 select_type: PRIMARY table: uc type: ref possible_keys: XXXXXXXXXXXXXXXXXXX key: XXXXXXXXXXXXXX key_len: 4 ref: XXXXXXXXXXXXXX rows: 1 filtered: 100.00 Extra: 2 rows in set (0.00 sec) There now seems to be an issue when attempting to use the RETURNING keyword with this aliases version of the query. I have tried numerous versions of this query... EXPLAIN DELETE uc FROM t1 AS uc WHERE uc.id IN (SELECT p.id FROM t2 AS p WHERE p.account_id = 9999) RETURNING uc.some_id; EXPLAIN DELETE uc FROM t1 uc INNER JOIN t2 p ON uc.id = p.id WHERE p.acc_id = 9999 RETURNING some_id; All of these produce a SQL syntax error. I've tried a range of ways of writing this, using different joins, subqueries, with and without the AS keyword. The issues seems to be with aliases. The only version I can seem to get to work is this (note the removal of the aliases)... EXPLAIN DELETE FROM t1 WHERE id IN (SELECT id FROM t2 WHERE acc_id = 9999) RETURNING some_id; But then that creates the slow table scan problem again. Anyone have any experience of this? Cheers, Rhys

2 3

[Maria-discuss] New Question: Maria DB and Pro*C
by AskMonty KB 25 Jul '16

25 Jul '16

Hello, A new question has been asked in "MariaDB Connector/C" by Koyeli Roy. Please answer it at http://mariadb.com/kb/en/maria-db-and-proc/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Is there any plugin/code convertor available to perform DB operations on maria DB from Pro*C code? I have a huge application written using C and Pro*C and I want to migrate to maria DB without changing the Pro*C layer or making very few changes in it. Thanks, Koyeli -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maria-db-and-proc/

1 0

[Maria-discuss] New Question: Cobol and Maria DB
by AskMonty KB 25 Jul '16

25 Jul '16

Hello, A new question has been asked in "MariaDB Connector/C" by Koyeli Roy. Please answer it at http://mariadb.com/kb/en/cobol-and-maria-db/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Can I write a routine using C connector provided by Maria DB and call that routine from Cobol code? Will it work? If not , what do I need to do perform database operations on Maria DB from Cobol code. Thanks, Koyeli -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cobol-and-maria-db/

1 0

[Maria-discuss] New Question: MONyog server configuration via command line
by AskMonty KB 25 Jul '16

25 Jul '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-server-configuration-via-command-line/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to add new servers in monyog via shell commands?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-server-configuration-via-command-line/

1 0

[Maria-discuss] New Question: MONyog Audit Log Monitoring
by AskMonty KB 22 Jul '16

22 Jul '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-audit-log-monitoring/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- MariaDB has a plugin server_audit which records all the events happening on the server. Does MONyog monitor these audit log files?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-audit-log-monitoring/

1 0

[Maria-discuss] New Question: InnoDB/XtraDB Configuration for optimum performance (MySQL 5.1 to MariaDB 10.1)
by AskMonty KB 22 Jul '16

22 Jul '16

Hello, A new question has been asked in "Moving to MariaDB" by rajeev_joshi_g. Please answer it at http://mariadb.com/kb/en/innodbxtradb-configuration-for-optimum-performance… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, we were using MySQL 5.1 with MyISAM till now and now moving to MariaDB10.1. Instead of taking a Hop of MariaDB5.5, we will be removing MySQL after taking backup of data and then install MariaDB 10.1 & import the Data dump. We will also be changing our engine to InnoDB/XtrDB. May I know what are the configuration we need to take care of with regard to InnoDB/XTraDB for better/faster responses. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/innodbxtradb-configuration-for-optimum-performance…

2 1

[Maria-discuss] New Question: Upgrade (10.1.16+maria-1~jessie) broke system
by AskMonty KB 21 Jul '16

21 Jul '16

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by olliblum_59359. Please answer it at http://mariadb.com/kb/en/upgrade-10116maria-1jessie-broke-system/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- sudo apt-get -f install ....... Setting up mariadb-server-10.1 (10.1.16+maria-1~jessie) ... Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details. invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mariadb-server: mariadb-server depends on mariadb-server-10.1 (= 10.1.16+maria-1~jessie); however: Package mariadb-server-10.1 is not configured yet. dpkg: error processing package mariadb-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mariadb-server-10.1 mariadb-server E: Sub-process /usr/bin/dpkg returned an error code (1) ------------- ystemctl status mariadb.service mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: failed (Result: exit-code) since Thu 2016-07-21 22:46:21 UTC; 2min 1s ago Process: 9595 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=227/NO_NEW_PRIVILEGES) Process: 9592 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Process: 9433 ExecStartPre=/bin/sh -c VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 9429 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Main PID: 9595 (code=exited, status=227/NO_NEW_PRIVILEGES) Jul 21 22:46:21 systemd[1]: mariadb.service: main process exited, code=exited, status=227/NO_NEW_PRIVILEGES Jul 21 22:46:21 systemd[1]: Failed to start MariaDB database server. Jul 21 22:46:21 systemd[1]: Unit mariadb.service entered failed state. ------- syslog Jul 21 22:49:15 systemd[1]: mariadb.service: main process exited, code=exited, status=227/NO_NEW_PRIVILEGES Jul 21 22:49:15 systemd[1]: Failed to start MariaDB database server. Jul 21 22:49:15 systemd[1]: Unit mariadb.service entered failed state. ------- I have tried so far apt-get clean system restart dpkg --configure -a dpkg --configure -f apt-get is blocked now as it always tries to configure mariadb and then fail Any ideas? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/upgrade-10116maria-1jessie-broke-system/

1 0

[Maria-discuss] New Question: data base issue
by AskMonty KB 21 Jul '16

21 Jul '16

Hello, A new question has been asked in "MariaDB Community" by annamae_moreno_g. Please answer it at http://mariadb.com/kb/en/data-base-issue/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- hello im using xampp because im doing some web programming with php and i also using mariadb with data base . my question how can i use mariadb without using the port of mysql in xampp.. what program do i have to download so i can use this 2 products. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/data-base-issue/

1 0

[Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade
by Mark Wadham 21 Jul '16

21 Jul '16

Hi, We have a repeatable failure to initiate IST with MariaDB 10.1.14 after performing a schema upgrade on a single node in RSU mode. The error condition is when there is a delete query in the format: delete from <table> where id >= <n> on the non-RSU cluster nodes while the node is disconnected from the cluster. On rejoining the node determines that it is in sync with the other cluster nodes and no IST is performed, despite the rows that were deleted in the cluster. If we then delete the rows manually from the joining node, mysqld immediately crashes on the other nodes because they can't execute the new write transaction. The process we followed is: 1. Set up a 3-node cluster, nodes 0,1,2 2. Enable RSU on node 0: SET GLOBAL wsrep_OSU_method='RSU'; 3. Isolate node 0 from the cluster: SET GLOBAL wsrep_cluster_address="gcomm://"; 4. Perform a backward-compatible schema change, since this is the point of this process. In our test we added a single column to a table with a default value of null. Additionally we deleted some rows from a table on nodes 1 and 2, with: delete from <table> where id >= 100; which affected around 20 rows. 5. Rejoin the node to the cluster: SET GLOBAL wsrep_cluster_address="<gcomm string from config file>"; At this point the node immediately rejoins without doing IST and believes it is in sync, yet the rows are deleted on nodes 1 and 2 but not node 0. Interestingly if the delete query is: delete from <table> where id = <n>; there is no problem. Also we have not had any issue with syncing INSERT and UPDATE statements. A combination of INSERT, UPDATE and DELETE where id >= resulted in the insert/update statements being synced but the deletes not synced. It is as if the quorum somehow doesn't recognise delete where id >= as an event. Our next test cases are: 1. Switching node 0 back to TOI mode before rejoining the cluster, although I can't really see how this would make a difference. 2. Upgrading to MariaDB 10.1.16 which was released a couple of days ago. 3. Testing whether regular IST is affected, ie IST that should occur normally without switching to RSU mode or dropping a node out of the cluster. This seems like a pretty basic failure and I'm concerned that it may also affect regular IST, i.e. a node falling behind the cluster for normal reasons without any involvement of RSU mode, which would effectively make the whole system useless if it could randomly drop delete statements. If anyone can shed any light on why this may be happening we would be very grateful! Thanks, Mark

2 6

[Maria-discuss] Creating Custom Storage Engine
by Jonathan Ellithorpe 21 Jul '16

21 Jul '16

Hi All, I searched around but couldn't find documentation / tutorials on creating a custom storage backend for MariaDB. Could anyone point me in the right direction? Thanks, Jonathan

5 11