May 2020 - discuss - lists.mariadb.org

[Maria-discuss] Mariadb 10.3 crashing continuously on Centos 8
by Ralf Hartings 18 May '20

18 May '20

Hi My up-to-date Wordpress website running with mariadb 10.3 on CentOS8 (up to date) has been running for a long time without any issues. Suddenly, yesterday, my server became unreachable and did not respond to anything. Only power off/on helped to get it to respond again, but the website is down. I did not update the server in the last 2 weeks. No changes whatsoever. The logs show the mariadb server is restarting and crashing continuously. I switched off the mariadb.service to avoid any possible further issues, as I run a mailserver on the same machine (which runs just fine now). Please look at my post in the CentOS forum: https://forums.centos.org/viewtopic.php?f=54&t=74436&p=313469#p313469 The people there are great experts in CentOS, but probably no experts in mariadb in the same way as you are, and I really would like to get my site up again ASAP. Thanks a lot for reading this post and helping me out on this! /Ralf

3 3

Re: [Maria-discuss] Nosql language with plugins
by Justin Swanhart 16 May '20

16 May '20

I am not going to engage with you on this mailing list. On Thu, May 14, 2020, 1:44 PM Reindl Harald <h.reindl(a)thelounge.net> wrote: > just a dumb fucker which don't realize that his idiot posts talking to > himslef are annoying and if he once again comes with "You want a flame war? > I was a Usenet admin. I know the game. I will burn you to the ground and > piss on your ashes" and take the challenge and make this idot my new hobby > Am 14.05.20 um 19:38 schrieb Jan Steinman: > > "Closed: Fixed None Opened 5 years ago by rhughes.” > > FIVE YEARS AGO! > > Grudge much? > > On May 14, 2020, at 10:30, Justin Swanhart <greenlion(a)gmail.com> wrote: > > https://pagure.io/CoC/issue/6 > > On Thu, May 14, 2020, 1:28 PM Reindl Harald <h.reindl(a)thelounge.net> > wrote: > >> > I had to go on disability for mental health reasons >> >> didn't work well - shut the fuck up! >> >> Am 14.05.20 um 19:20 schrieb Justin Swanhart: >> > I propose we just let it go. >> > >> > I will never speak of MariaDB again and you stop fucking me over. We >> > both win. >> > >> > Can we please just stop this stupid fight. I have nothing to gain by >> > tilting and windmills and you have nothing to gain by doing demonstrably >> > shitty things to me. >> > >> > On Mon, May 11, 2020, 5:57 PM Justin Swanhart <greenlion(a)gmail.com >> > <mailto:greenlion@gmail.com>> wrote: >> > >> > MariaDB isn't an honest actor. They repeatedly utilize FUD to push >> > their agenda. >> > >> > I was so frustrated by the columnstore experience that I had to go >> > on disability for mental health reasons, and I was fired while on >> > disability for blogging about BSL. >> > >> > To attack me for my religious views after criticizing their >> > characterization of RedShift on LinkedIn was unconscionable. The >> > account had zero connections, no activity except commenting on my >> > post, had only one job listed (33 years it said) and the university >> > the person claimed to be from did not have the person in the alumni >> > directory. >> > >> > MariaDB won't respond to this, but you know it is true because there >> > was no reason other than spite to remove articles about my tools >> > that I did not even contribute and which are now dead links from >> > other community webpages and blogs. >> > >> > On Mon, May 11, 2020, 5:41 PM Justin Swanhart <greenlion(a)gmail.com >> > <mailto:greenlion@gmail.com>> wrote: >> > >> > >> > ---------- Forwarded message --------- >> > From: *Justin Swanhart* <greenlion(a)gmail.com >> > <mailto:greenlion@gmail.com>> >> > Date: Mon, May 11, 2020, 5:38 PM >> > Subject: Re: [Maria-discuss] Nosql language with plugins >> > To: Roberto Spadim <roberto(a)spadim.com.br >> > <mailto:roberto@spadim.com.br>> >> > >> > >> > MariaDB relicensed MaxScale from GPL to Business Source >> > License. The license change effectively extorted customers >> > requiring customers using it to pay for it. While older >> > versions of MaxScale become GPL, the license terms prohibit >> > backporting any security fixes and MariaDB abandons each release >> > and never backports any fixes so it is impossible to use old >> > versions in production. >> > >> > On Mon, May 11, 2020, 5:34 PM Roberto Spadim >> > <roberto(a)spadim.com.br <mailto:roberto@spadim.com.br>> wrote: >> > >> > What’s BSL? >> > >> > Em seg, 11 de mai de 2020 às 18:19, Justin Swanhart >> > <greenlion(a)gmail.com <mailto:greenlion@gmail.com>> >> escreveu: >> > >> > *crickets* >> > >> > On Fri, May 8, 2020, 2:33 PM Justin Swanhart >> > <greenlion(a)gmail.com <mailto:greenlion@gmail.com>> >> wrote: >> > >> > Seems I didn't get Federico's reply. The answer is >> > because: >> > War, war never changes... >> > >> > I made a stink about BSL, and I have shamed Monty in >> > public. >> > >> > MariaDB recently created a sock puppet LinkedIn >> > account to attack me for my religious views. >> > >> > We are at war >> > >> > On Wed, Apr 29, 2020, 9:48 PM Justin Swanhart >> > <greenlion(a)gmail.com <mailto:greenlion@gmail.com>> >> > wrote: >> > >> > MariaDB doesn't have rewrite plugins. >> > >> > What you want could still not be done with a >> > preparse plugin in MySQL because there is no way >> > to speak an arbitrary protocol. You could have >> > a client that speaks the MySQL protocol but >> > sends non-sql text commands that have some 1:1 >> > match with SQL, for example MDX. >> > >> > For MySQL 8 I have developed an alternative >> > rewrite plugin interface that can execute any >> > number of SQL statements serially on the THD of >> > the client connection, or an arbitrary THD. It >> > would be possible to port to MariaDB but as >> > MariaDB has deleted the KB entries related to my >> > tools, I highly doubt they would upstream it, >> > and I would expect some form of >> > compensation/sponsorship from you if you wanted >> > me to do it. In any case the plugin would still >> > not speak arbitrary binary protocols. >> > >> > MySQL 8 supports the X protocol for document >> > access. It would probably be possible to create >> > an X protocol proxy that speaks arbitrary >> > protocols but that would be a big project that >> > probably not many people would be interested >> in. >> > >> > On Wed, Apr 29, 2020, 9:14 PM Roberto Spadim >> > <roberto(a)spadim.com.br >> > <mailto:roberto@spadim.com.br>> wrote: >> > >> > Could be possible use the query rewrite >> > plugin to execute no sql commands? Something >> > like disable sql parser and execute some >> > specific protocol, returning standard sql >> > datasets as result? > > >

4 4

[Maria-discuss] Fwd: Nosql language with plugins
by Justin Swanhart 14 May '20

14 May '20

---------- Forwarded message --------- From: Justin Swanhart <greenlion(a)gmail.com> Date: Mon, May 11, 2020, 5:38 PM Subject: Re: [Maria-discuss] Nosql language with plugins To: Roberto Spadim <roberto(a)spadim.com.br> MariaDB relicensed MaxScale from GPL to Business Source License. The license change effectively extorted customers requiring customers using it to pay for it. While older versions of MaxScale become GPL, the license terms prohibit backporting any security fixes and MariaDB abandons each release and never backports any fixes so it is impossible to use old versions in production. On Mon, May 11, 2020, 5:34 PM Roberto Spadim <roberto(a)spadim.com.br> wrote: > What’s BSL? > > Em seg, 11 de mai de 2020 às 18:19, Justin Swanhart <greenlion(a)gmail.com> > escreveu: > >> *crickets* >> >> On Fri, May 8, 2020, 2:33 PM Justin Swanhart <greenlion(a)gmail.com> wrote: >> >>> Seems I didn't get Federico's reply. The answer is because: >>> War, war never changes... >>> >>> I made a stink about BSL, and I have shamed Monty in public. >>> >>> MariaDB recently created a sock puppet LinkedIn account to attack me for >>> my religious views. >>> >>> We are at war >>> >>> On Wed, Apr 29, 2020, 9:48 PM Justin Swanhart <greenlion(a)gmail.com> >>> wrote: >>> >>>> MariaDB doesn't have rewrite plugins. >>>> >>>> What you want could still not be done with a preparse plugin in MySQL >>>> because there is no way to speak an arbitrary protocol. You could have a >>>> client that speaks the MySQL protocol but sends non-sql text commands that >>>> have some 1:1 match with SQL, for example MDX. >>>> >>>> For MySQL 8 I have developed an alternative rewrite plugin interface >>>> that can execute any number of SQL statements serially on the THD of the >>>> client connection, or an arbitrary THD. It would be possible to port to >>>> MariaDB but as MariaDB has deleted the KB entries related to my tools, I >>>> highly doubt they would upstream it, and I would expect some form of >>>> compensation/sponsorship from you if you wanted me to do it. In any case >>>> the plugin would still not speak arbitrary binary protocols. >>>> >>>> MySQL 8 supports the X protocol for document access. It would probably >>>> be possible to create an X protocol proxy that speaks arbitrary protocols >>>> but that would be a big project that probably not many people would be >>>> interested in. >>>> >>>> On Wed, Apr 29, 2020, 9:14 PM Roberto Spadim <roberto(a)spadim.com.br> >>>> wrote: >>>> >>>>> Could be possible use the query rewrite plugin to execute no sql >>>>> commands? Something like disable sql parser and execute some specific >>>>> protocol, returning standard sql datasets as result? >>>>> -- >>>>> Roberto Spadim >>>>> SPAEmpresarial - Software ERP/Scada >>>>> Eng. Automação e Controle, Eng. Financeira >>>>> _______________________________________________ >>>>> 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 >>>>> >>>> -- > Roberto Spadim > SPAEmpresarial - Software ERP/Scada > Eng. Automação e Controle, Eng. Financeira >

2 6

[Maria-discuss] Is galera 26.4.4 a pre-rc version?
by Adam Purkrt 13 May '20

13 May '20

Hi, I do not understand the following: MariaDB has been shipping galera 26.4.x line for some time now - for example, with yesterday's release of 10.4.13, which is Stable (GA), there is galera 26.4.4 for download https://downloads.mariadb.org/mariadb/10.4.13/ How come that on https://galeracluster.com/downloads/ which is the origin of galera (afaict) the currently most advanced version in the 4.x line is only release candidate? the version is 4.5 (i.e. 26.4.5) and it is RC it seems like the whole galera 26.4.x line up to now (26.4.1, 26.4.2, 26.4.3. 26.4.4) are only pre-release versions(?) Or do I get it wrong? Thanks Adam Purkrt

2 1

[Maria-discuss] is galera 26.4.4 a pre-rc version?
by Adam Purkrt 13 May '20

13 May '20

Hi, I do not understand the following: MariaDB has been shipping galera 26.4.x line for some time now - for example, with yesterday's release of 10.4.13, which is Stable (GA), there is galera 26.4.4 for download https://downloads.mariadb.org/mariadb/10.4.13/ How come that on https://galeracluster.com/downloads/ which is the origin of galera (afaict) the currently most advanced version in the 4.x line is only RC? 4.5.rc (i.e. 26.4.5.rc) to be exact there are no publicly available 4.x (i.e. 26.4.x) downloads so it seems like the whole galera 26.4.x line up to now (26.4.1, 26.4.2, 26.4.3. 26.4.4) are only pre-release versions(?) Or do I get it wrong? Thanks Adam Purkrt

1 0

[Maria-discuss] Nosql language with plugins
by Roberto Spadim 11 May '20

11 May '20

Could be possible use the query rewrite plugin to execute no sql commands? Something like disable sql parser and execute some specific protocol, returning standard sql datasets as result? -- Roberto Spadim SPAEmpresarial - Software ERP/Scada Eng. Automação e Controle, Eng. Financeira

3 4

[Maria-discuss] OSX fix need on MariaDB-10.5
by Daniel Black 09 May '20

09 May '20

Mac lovers (who can use C/C++ and a debugger), As your MariaDB developers are hard at work getting 10.5 ready for you, unfortunately a bug has slipped into the 10.5 branch making it unusable on OSX (at least that's what it looks like on the CI infrastructure). The bug report is here: https://jira.mariadb.org/browse/MDEV-22173 As the time of developers is a little short as is the availability of OSX hardware, I'm hoping some of you are able to spend a few hours tackling this task to understand it better, and if possible, create patch. Steps: 1. build environment https://mariadb.com/kb/en/Build_Environment_Setup_for_Mac/ 2. clone the source git clone --branch 10.5 https://github.com/MariaDB/server.git mariadb-server cd mariadb-server git submodule update --recursive --init 3. build instructions https://mariadb.com/kb/en/generic-build-instructions/ (you don't need to install) 4. test (from build directory) mysql-test/mysql-test-run main.select might be useful here: --debugger=NAME or --gdb client-debugger=NAME or client-gdb To collaborative share your findings and to ask for further help MariaDB's community chat stream has been created for you. https://mariadb.zulipchat.com/#narrow/stream/118759-general/topic/Get.20OSX… To paraphrase J.F.Kennedy ask not what your database server community can do for you — ask what you can do for your database server community. Keep the community spirit going, Daniel Black -- Sent as a community member who noticed OSX failures and that everyone is busy

2 3

[Maria-discuss] Data At Rest Encryption Overhead
by Michael Caplan 09 May '20

09 May '20

Hello, I'm working on a plan to roll out MariaDB per table data at rest encryption. Reading through the docs (https://mariadb.com/kb/en/data-at-rest-encryption-overview/), I understand that "Using encryption has an overhead of roughly 3-5%." I'd like to know what this 3-4% refers to. I am assuming this is a penalty related to transactions a second (as the referenced blog post discusses: https://mariadb.com/resources/blog/table-and-tablespace-encryption-on-maria…). I am hoping I can access the MariaDB community brain trust to understand the overhead of deploying encryption as related to: * Disk: what overhead can I plan around for disk space? * Scale considerations: in my environment I am looking at encrypting around 100,000 smaller tables (spread out over numerous databases). With the tables being encrypted, will they be decrypted and encrypted on demand (as opposed to being "decrypted" on startup)? * Index query performance: does encryption have an effect on how indexes are utilized that I would need to plan against? Are there other factors that others consider when deploying data at rest encryption? Best, Mike

2 1

[Maria-discuss] Maybe OT: we have clients from Centos 7.8 sporadically connecting via 'strange' ipv6 address
by Thomas Plant 08 May '20

08 May '20

Hello, do not know if this is the right place to ask, we have, since updating to Centos 7.8 from 7.7, some PHP Webs which try to connect to the MySQL server with the following IPv6 as address in the addresspart of the user: 'user'@[::ffff:10.11.12.13] They get access denied as the real user is 'user'@'10.11.12.13'. Is this a PHP problem or a MySQL client setting i can set to disable this IPv6 thing? Disabling IPv6 on the interface can be done but I'd rather would not. Regards, Thomas

1 0

Re: [Maria-discuss] Problems copy database files
by Ling, Andy 07 May '20

07 May '20

I’ve been doing a bit more investigation and it looks like the FLUSH TABLES FOR EXPORT isn’t flushing to disk. I monitor the modified time of the .MAD file for a table. If I make a change to the table the modified date doesn’t change. If I do FLUSH TABLES FOR EXPORT the modified time still doesn’t change. If I do a FLUSH TABLES the modified time does change. So adding the FOR EXPORT option seems to stop the data being flushed to disk. Is this expected behaviour? It certainly isn’t how I read the documentation. Regards Andy Ling From: Ling, Andy Sent: Wed 06 May 2020 12:12 To: 'Roberto Spadim' <roberto(a)spadim.com.br> Subject: RE: [EXTERNAL] Re: Re: [Maria-discuss] Problems copy database files As I said, there is no destination server in this simple test. It is all done within the same machine and the same instance of MariaDB server. In the full system where I first noticed the problem the copied files are checked with the aria_chk command and the mysqlcheck command and apart from the “zero filling” message are OK. Still the data is missing. It looks like the FLUSH command isn’t flushing all the way to disk. Regards Andy Ling From: Roberto Spadim [mailto:roberto@spadim.com.br] Sent: Wed 06 May 2020 12:06 To: Ling, Andy <Andy.Ling(a)grassvalley.com<mailto:Andy.Ling@grassvalley.com>> Subject: [EXTERNAL] Re: Re: [Maria-discuss] Problems copy database files there's an aria journaling file too, maybe it's not being sync before you copy, but from what i remember this should work, try to flush table at destination server and open table again just to check if it's not something at destination server Em qua., 6 de mai. de 2020 às 07:59, Ling, Andy <Andy.Ling(a)grassvalley.com<mailto:Andy.Ling@grassvalley.com>> escreveu: They are the same. I’m actually doing this simple test on a single machine (and disk). So the files are just being copied from the original database folder to a backup folder on the same disk drive. Regards Andy Ling From: Roberto Spadim [mailto:roberto@spadim.com.br<mailto:roberto@spadim.com.br>] Sent: Wed 06 May 2020 11:55 To: Ling, Andy <Andy.Ling(a)grassvalley.com<mailto:Andy.Ling@grassvalley.com>> Cc: Mailing-List mariadb <maria-discuss(a)lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net>> Subject: [EXTERNAL] Re: [Maria-discuss] Problems copy database files what about file size on both servers? Em qua., 6 de mai. de 2020 às 07:35, Ling, Andy <Andy.Ling(a)grassvalley.com<mailto:Andy.Ling@grassvalley.com>> escreveu: Hi, I am having problems copying database files. I am using MariaDB 10.4.12 on Windows server 2019. And all the tables use the Aria engine A simple set of operations that reproduces the problem is… Add some data to a table FLUSH TABLE “table” FOR EXPORT Copy the .FRM, .MAI, .MAD files for the table to a backup folder. UNLOCK TABLES switch to the database in the backup folder and check the contents of the copied table. I doesn’t contain the data just added. So it looks like the data is not being flushed to disk. The documentation suggests this should work, so are there some settings I need to change to make sure the data is flushed before I do the file copies. Thanks for any help Andy Ling _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss<https://urldefense.proofpoint.com/v2/url?u=https-3A__launchpad.net_-7Emaria…> Post to : maria-discuss(a)lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss<https://urldefense.proofpoint.com/v2/url?u=https-3A__launchpad.net_-7Emaria…> More help : https://help.launchpad.net/ListHelp<https://urldefense.proofpoint.com/v2/url?u=https-3A__help.launchpad.net_Lis…> -- Roberto Spadim SPAEmpresarial - Software ERP/Scada Eng. Automação e Controle, Eng. Financeira ________________________________ DISCLAIMER: Privileged and/or Confidential information may be contained in this message. If you are not the addressee of this message, you may not copy, use or deliver this message to anyone. In such event, you should destroy the message and kindly notify the sender by reply e-mail. It is understood that opinions or conclusions that do not relate to the official business of the company are neither given nor endorsed by the company. Thank You. -- Roberto Spadim SPAEmpresarial - Software ERP/Scada Eng. Automação e Controle, Eng. Financeira ********************************************************************** DISCLAIMER: Privileged and/or Confidential information may be contained in this message. If you are not the addressee of this message, you may not copy, use or deliver this message to anyone. In such event, you should destroy the message and kindly notify the sender by reply e-mail. It is understood that opinions or conclusions that do not relate to the official business of the company are neither given nor endorsed by the company. Thank You.

1 0