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-boun...@lists.koha-community.org> namens Renvoize, Martin <martin.renvo...@ptfs-europe.com> Verzonden: maandag 4 november 2019 17:09 Aan: Laurent Ducos <laurent.du...@biblibre.com> CC: Koha Devel <koha-devel@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.renvo...@ptfs-europe.com<mailto:martin.renvo...@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 i...@ptfs-europe.com<mailto:i...@ptfs-europe.com> On Fri, 23 Aug 2019 at 08:44, Laurent Ducos <laurent.du...@biblibre.com<mailto:laurent.du...@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" <tomasco...@gmail.com<mailto:tomasco...@gmail.com?to=%22tomas%20cohen%20arazi%22%20%3ctomasco...@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 (<mtomp...@hotmail.com<mailto:mtomp...@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@lists.koha-community.org<mailto:koha-devel@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@lists.koha-community.org<mailto:Koha-devel@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@lists.koha-community.org<mailto:Koha-devel@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@lists.koha-community.org<mailto:Koha-devel@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>
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
