[Koha-devel] mariadb versions and koha

[Marcel de Rooy]

See also the discussion on the dev meeting of Nov 6 now.

I just saw another bug (23960) about an issue with MariaDB 10.3.
Can't we add a keyword in Bugzilla to mark such ones to find them back easier ? sql_version_dependent or something ?


 

​Museumstraat 1
Postbus 74888
1070 DN Amsterdam
Rijksmuseum.nl
​
​Nu te zien:
​​​​​Rembrandt-Velázquez. Nederlandse & Spaanse meesters
Louise Bourgeois in de Rijksmuseumtuinen  
Rineke Dijkstra: Night Watching
Document Nederland: Martijn van de Griendt ON/OFF 
Operatie Nachtwacht​
​
​T/m 18 jaar gratis
  
 Please think before you print
________________________________
Van: Koha-devel <koha-devel-bounces at lists.koha-community.org> namens Renvoize, Martin <martin.renvoize at ptfs-europe.com>
Verzonden: maandag 4 november 2019 17:09
Aan: Laurent Ducos <laurent.ducos at biblibre.com>
CC: Koha Devel <koha-devel at lists.koha-community.org>
Onderwerp: Re: [Koha-devel] mariadb versions and koha

Our CI framework currently tests against MySQL5.5, MariaDB10.1 and will soon also be testing against MariaDB10.3 (Once we have D10 building packages building correctly).

We have chosen these DB versions as they're the ones shipped by default with D8, D9 and U18 which are our current listed supported OS's. D8 will soon be deprecated (Debian themselves are dropping support come June 2020) and we are in the process of adopting D10 support (and hence MariaDB10.3).

As those are the only DBs we are currently regularly testing I would suggest those are the ones people generally use, though of course if issues are reported against other we will accept bugfixes so long as they do not break the existing support but we cannot guarantee stability around the newer DBs otherwise.

It does raise other questions as I've recently hit in a few occasions where recent MariaDB and MySQL have started to diverge more and as such it's getting increasingly difficult to support both in the current manor we are.


Martin Renvoize

[https://www.ptfs-europe.com/wp-content/uploads/2018/10/ptfs-logo-full-email-sig.png]<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ptfs-europe.com&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061008283&sdata=qa0QpvrnZB%2BirkojK530plEBnLRxQlnLcLtLm55KGBM%3D&reserved=0>

Development Team Manager





Phone: +44 (0) 1483 378728

Mobile: +44 (0) 7725 985 636

Email: martin.renvoize at ptfs-europe.com<mailto:martin.renvoize at ptfs-europe.com>

Fax: +44 (0) 800 756 6384


www.ptfs-europe.com<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ptfs-europe.com&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061008283&sdata=qa0QpvrnZB%2BirkojK530plEBnLRxQlnLcLtLm55KGBM%3D&reserved=0>







Registered in the United Kingdom No. 06416372   VAT Reg No. 925 7211 30


The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info at ptfs-europe.com<mailto:info at ptfs-europe.com>



On Fri, 23 Aug 2019 at 08:44, Laurent Ducos <laurent.ducos at biblibre.com<mailto:laurent.ducos at biblibre.com>> wrote:
the update has many advantages and new features.

There is a new feature with 10.4 that limits the size of temporary tables. This is useful when running poorly constructed reports (Cartesian products) that can generate gigabytes of temporary tables. For exemple:

[mysqld]
innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:1G
did anyone ever test this feature?

Laurent Ducos
Administrateur système et réseaux chez BibLibre

23 août 2019 04:24 "Tomas Cohen Arazi" <tomascohen at gmail.com<mailto:tomascohen at gmail.com?to=%22Tomas%20Cohen%20Arazi%22%20%3Ctomascohen at gmail.com%3E>> a écrit:
We've been testing MySQL 8 as well, without major issues, besides the need to solve the authentication issue (i.e. making mysql-client v5.x work).
Regards
El jue., 22 ago. 2019 a las 22:53, Mark Tompsett (<mtompset at hotmail.com<mailto:mtompset at hotmail.com>>) escribió:
Greetings,

In order to avoid the auto-increment bug, you really want 10.3 or higher. :)

GPML,
Mark Tompsett


-----Original Message-----
From: Laurent Ducos
Sent: Thursday, August 22, 2019 4:50 AM
To: koha-devel at lists.koha-community.org<mailto:koha-devel at lists.koha-community.org>
Subject: [Koha-devel] mariadb versions and koha

Hello
We are currently using version 10.0 of mariadb with koha.
We are planning a upgrade.
Have you noticed problems with versions 10.1 10.2, 10.3 or 10.4?

--
Laurent Ducos
Administrateur système et réseaux chez BibLibre
IT system and network administrator at BibLibre
_______________________________________________
Koha-devel mailing list
Koha-devel at lists.koha-community.org<mailto:Koha-devel at lists.koha-community.org>
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.koha-community.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fkoha-devel&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061018280&sdata=z9C1ZXDvUNRhLg9zYDHFdP5poCe116gjlvU3cC14Dx4%3D&reserved=0>
website : http://www.koha-community.org/<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.koha-community.org%2F&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061028274&sdata=2psr760vu7JWq127prOVbanVNZKhdlrkmv2JSumnG5Y%3D&reserved=0>
git : http://git.koha-community.org/<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgit.koha-community.org%2F&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061028274&sdata=Gow3EQIAcxp%2BMtVFuRSYFuLE2v3T1lhONTI%2FmoXrCkM%3D&reserved=0>
bugs : http://bugs.koha-community.org/<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fbugs.koha-community.org%2F&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061038267&sdata=hJI%2F2dIkEwH3Mj08GPlfhmXHu95NpkWEfcgybpzq%2FXM%3D&reserved=0>

_______________________________________________
Koha-devel mailing list
Koha-devel at lists.koha-community.org<mailto:Koha-devel at lists.koha-community.org>
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.koha-community.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fkoha-devel&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061038267&sdata=yQKY40G3lPzn56NsvsI4UOn3IVnyfrfgbpiVdeMeTL0%3D&reserved=0>
website : http://www.koha-community.org/<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.koha-community.org%2F&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061048270&sdata=zLCJsm4PevX9%2B9o8mHjotahhiyhNHLOgNYHtXOcgRws%3D&reserved=0>
git : http://git.koha-community.org/<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgit.koha-community.org%2F&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061048270&sdata=Nv4lfqCxJBE3LNIouZ4Gce%2F3VIztxudcLW%2FddfwLg2A%3D&reserved=0>
bugs : http://bugs.koha-community.org/<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fbugs.koha-community.org%2F&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061058259&sdata=OKGBd4PSYsPwH8EnSMLINFLWmUWAEo2pNuzxHPSNvxU%3D&reserved=0>
--
Tomás Cohen Arazi
Theke Solutions (http://theke.io<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Ftheke.io%2F&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061068256&sdata=mTHkaWRVpFxTdTwcOn8IT39mavBoS4PlKPd9MUO7AK0%3D&reserved=0>)
✆ +54 9351 3513384
GPG: B2F3C15F
_______________________________________________
Koha-devel mailing list
Koha-devel at lists.koha-community.org<mailto:Koha-devel at lists.koha-community.org>
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.koha-community.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fkoha-devel&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061068256&sdata=L%2BiGrUkw7GIYdkjBwEruPj8FBOG1yhQBHE0lwbB2dqg%3D&reserved=0>
website : http://www.koha-community.org/<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.koha-community.org%2F&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061078252&sdata=iiFOElEqb%2FtzSAkejycV6Iemr%2FkZ14sv06on1%2Fh%2BSSQ%3D&reserved=0>
git : http://git.koha-community.org/<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgit.koha-community.org%2F&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061078252&sdata=1Q4OG3%2BnpPiHhRarOo%2BZMgJz4rJxnIjMZbUQEzUcowM%3D&reserved=0>
bugs : http://bugs.koha-community.org/<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fbugs.koha-community.org%2F&data=02%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Ca1d797badb3f4ddf8fe708d7614173fc%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637084806061088248&sdata=srQu05ZGoVOZqWxT8DCblGHO7TF3OxsbFJtNdOAV6lw%3D&reserved=0>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20191106/e7080980/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image831116.png
Type: image/png
Size: 2974 bytes
Desc: image831116.png
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20191106/e7080980/attachment-0001.png>