- discuss - lists.mariadb.org

[Maria-discuss] MariaDB files wiped out after reboot
by Allan Mendoza 20 Jun '18

20 Jun '18

Hi, Good Day! I have a weird experience on one of our mysql servers. After a reboot all the database files have been wiped out. May I know if someone had expereienced the same, My OS is Centos 6.9 and MariaDB version is 5.5.35 Attaching is the error log that we have salvaged after the reboot. Thank you lanz_s99zx :)

1 0

Re: [Maria-discuss] Chewing Through Swap - Swappiness = 0
by Michael Caplan 15 Jun '18

15 Jun '18

Just found this interesting article on the "The MySQL 'swap insanity' problem": https://blog.jcole.us/2010/09/28/mysql-swap-insanity-and-the-numa-architect… Has anyone else tried the mentioned solutions? - Forcing interleaved allocation with numactl --interleave=all. - Flushing Linux’s buffer caches just before mysqld startup with sysctl -q -w vm.drop_caches=3. - Forcing the OS to allocate InnoDB’s buffer pool immediately upon startup, using MAP_POPULATE where supported (Linux 2.6.23+), and falling back to memset otherwise. One of the solutions seems dependent on the Twitter fork that was absorbed by the now removed XtraDB. Thanks, Mike On 2018-06-15 08:24 AM, Michael Caplan wrote: > Hi, > > I'm trying to figure out why my recently put into production MariaDB > is so swap hungry. > > I'm running 10.2.14, with roughly 300GB data (1000K +/- tables). 95% > tables are innodb. I have 64GB RAM, with INNODB buffer pool size set > to 50GB (full my.cnf below). The OS is Ubuntu 16.04.4. This is a > dedicated MariaDB server. > > I have swappiness set to 0. > > I started with available swap set to just shy of 1GB. When swap got > to 85% used, I bumped swap to 3GB. A day later, swap again was 85% > used, and I bumped it to 5GB. A day later, swap again was 85% used, > so I bumped it to 15GB. 2 days later 50% of the available swap was > used. I restarted the DB moments ago, freeing up all 15GB but 128MB > of swap: > > total used free shared buff/cache > available > Mem: 62G 20G 4.7G 266M 37G 41G > Swap: 14G 128M 14G > > My understanding is that the OS should never allocate swap when > swappiness is 0, so that has me confused. > > > I've had similar issues with MySQL 5.6 (what I upgraded from) dipping > into swap, but that instance had swappiness set to 1, and never > consumed more than 5GB of swap. > > > Questions: > > 1) How much of this is an OS issue vs MariaDB issue? > > 2) What MariaDB config vars should I be looking at to fix this issue? > > 3) What linux config vars should I be looking at to fix this issue? > > > Thanks, > > Mike > > > > [mysqld] > > # GENERAL # > user = mysql > default-storage-engine = InnoDB > character-set-server = utf8 > collation_server = utf8_general_ci > performance_schema = 0 > max_allowed_packet = 16777216 > sql_mode = > "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" > > # MyISAM # > key-buffer-size = 32M > myisam-recover = FORCE,BACKUP > > # SAFETY # > max-allowed-packet = 16777216 > max-connect-errors = 1000000 > skip-name-resolve > sysdate-is-now = 1 > innodb = FORCE > local_infile = 0 > secure_auth = 1 > safe_user_create = 1 > skip_symbolic_links = 1 > wait_timeout = 28800 > > # DATA STORAGE # > datadir = /var/lib/mysql/ > > # BINARY LOGGING # > log-bin = /var/lib/mysql/mysql-bin > binlog_format = MIXED > server-id = 3 > expire-logs-days = 7 > sync-binlog = 1 > > # REPLICATION # > read-only = 1 > skip-slave-start = 1 > log-slave-updates = 1 > relay-log = /var/lib/mysql/relay-bin > slave-net-timeout = 60 > sync-master-info = 1 > sync-relay-log = 1 > sync-relay-log-info = 1 > > # CACHES AND LIMITS # > tmp-table-size = 32M > max-heap-table-size = 32M > query-cache-type = 0 > query-cache-size = 0 > max-connections = 500 > thread-cache-size = 50 > open-files-limit = 65535 > table-definition-cache = 4096 > table-open-cache = 10240 > > # INNODB # > innodb-flush-method = O_DIRECT > innodb-log-files-in-group = 2 > innodb-log-file-size = 512M > innodb-flush-log-at-trx-commit = 2 > innodb-file-per-table = 1 > innodb-buffer-pool-size = 50G > >

1 0

[Maria-discuss] Timezones Table
by Kurniadi Asrigo 12 Jun '18

12 Jun '18

Hi, I am following the instruction to update the timezone table from MySQL: https://mariadb.com/kb/en/library/time-zones/ And the file is downloaded from MySQL page. I got MariaDB from XAMPP, running on Window10. I downloaded the "timezone_2018e_posix_sql.zip<https://downloads.mysql.com/general/timezone_2018e_posix_sql.zip> - POSIX standard" https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html Once downloaded, I extracted the package into a directory. From the instruction, I executed the command: .\mysql_tzinfo_to_sql.exe C:\dev\xampp_download\timezone\timezone_posix.sql | .\mysql.exe -D mysql -u root -p Now, the timezone Table is all empty. I am wondering if I am missing a step or an option. Thanks, Ti.

2 1

[Maria-discuss] MariaDB Developers Unconference in a few weeks!
by Otto Kekäläinen 09 Jun '18

09 Jun '18

Hello everybody! The next developers unconference will be in a few weeks: https://mariadb.org/2018-2-developers-unconference-in-finland/ There are still open slots so we encourage you to sign up now. https://www.meetup.com/MariaDB-Developers/events/249024232/ We have plenty of break-out rooms this time and there is space, so we also encourage you to suggest sessions/discussions you would like to have to ian(a)mariadb.org. Around mid-summer is a great time to visit Finland. The nights that don't get dark are worth experiencing! Getting to the venue in Tampere., Finlnd is also very easy. https://mariadb.org/travel-tips-to-tampere-finland/#why-visit Hope to see you there! - Otto

1 0

[Maria-discuss] Upgrade paths through more major versions
by Michal Schorm 06 Jun '18

06 Jun '18

Hello, MariaDB changed its release cycle to 1 major version / year. However the upgrades remained supported only from one major version to the very next. I see a raise of users (of RH products - RHEL and RHSCL mainly) that would like to jump several versions. They had an application build on, let's say, 5.5 (RHEL7 default) and would like to get the features from 10.2 (available in RH software collections - we provide plenty of versions this way). So far, they have to upgrade one by one 5.5->10.0->10.1->10.2; and solve the conflicts at each stage. Lately, we discontinued support fo 10.0 in RHSCL, which means, the upgrade path metioned above won't be as easy anymore. Also mysqldump can't be used for upgrade to 10.3, which is IMHO frequently used. For other RH products, there is an ongoing discussions, whether support all major releases or if to skip some. Which implies the questions about the upgrades through versions we wouldn't pack. However skipping several versions is IMHO quite normal for products with slow release cycle, like RHEL, so I'd expect other companies providing similar systems / products with slow release cycle to face the same problems. Are there any plans to extend the upgrade paths through more versions? Have you encountered simmilar needs of the users? -- Michal Schorm Associate Software Engineer Core Services - Databases Team Red Hat

4 6

[Maria-discuss] Why MyISAM as default engine for system tables ?
by Julien Muchembled 06 Jun '18

06 Jun '18

Hello, A few weeks ago, we got the following fatal error when starting mariadb: [Note] Starting crash recovery... [Note] Crash recovery finished. [ERROR] mysqld: Table './mysql/db' is marked as crashed and should be repaired [Warning] Checking table: './mysql/db' [ERROR] mysql.db: 1 client is using or hasn't closed the table properly tch value count at row 1 [ERROR] Aborting Unfortunately, what led to this is unclear. We only rebooted the machine. Maybe a hw raid issue. We did a copy at that time. I tried recently if it could be repaired but I don't have the a fatal error anymore. We also don't know why system tables were touched during the reboot. Anyway, given the description of Aria ("Crash-safe tables with MyISAM heritage"), I understand that MyISAM is not crash-safe. Then, why keep using MyISAM as default engine for system tables, when MariaDB has Aria or InnoDB ? Not sure a crash-safe engine would have helped in the above case (there's no miracle for data corruption). But we'd like at least that all our mariadb setups are crash-safe (e.g. power cuts) and we use InnoDB partly for that. And I don't know if a InnoDB DB could be always recoverable if the 'mysql' DB is lost but we don't want to do manually (and learn how to) what the machine can do automatically. Julien

6 8

[Maria-discuss] Python 3 Handler Socket
by Roberto Spadim 28 May '18

28 May '18

Hi guys! Any link to a working handler socket python module? pyhs is old and working only with python2, we need to update the C lib or use plain python with python3 (i did some changes, don't know if there's a running job on this) -- Roberto Spadim

2 4

[Maria-discuss] MariaDB Compile Size
by Tom Jay 21 May '18

21 May '18

Hello, Has anyone got any idea how to reduce the MariaDB install size, when compiling from source? I've had multiple attempts, all with different options such as 'WITHOUT_EXAMPLE_STORAGE_ENGINE=1' and 'FEATURE_SET:STRING=large', for example, but with no effect. The installation size is usually around 2.1 GB, whereas the official Arch package, which also compiles from source, is about 231.78 MB. The official Arch build script is here [https://git.archlinux.org/svntogit/packages.git/tree/trunk/PKGBUILD?h=packa…] and the only difference I can notice is that they delete a lot of stuff afterwards. Is there any reference for stuff that can be deleted after MariaDB has been installed? Thanks.

4 5

[Maria-discuss] R: MariaDB Compile Size
by Federico Razzoli 19 May '18

19 May '18

You maybe interested in this article: http://datacharmer.blogspot.nl/2016/02/mysql-sandboxes-in-docker.html?m=1 Federico -------------------------------------------- Sab 19/5/18, Tom Jay <tom_jay(a)hotmail.com> ha scritto: Oggetto: [Maria-discuss] MariaDB Compile Size A: "maria-discuss(a)lists.launchpad.net" <maria-discuss(a)lists.launchpad.net> Data: Sabato 19 maggio 2018, 07:33 Hello, Has anyone got any idea how to reduce the MariaDB install size, when compiling from source? I've had multiple attempts, all with different options such as 'WITHOUT_EXAMPLE_STORAGE_ENGINE=1' and 'FEATURE_SET:STRING=large', for example, but with no effect. The installation size is usually around 2.1 GB, whereas the official Arch package, which also compiles from source, is about 231.78 MB. The official Arch build script is here [https://git.archlinux.org/svntogit/packages.git/tree/trunk/PKGBUILD?h=packa…] and the only difference I can notice is that they delete a lot of stuff afterwards. Is there any reference for stuff that can be deleted after MariaDB has been installed? Thanks. _______________________________________________ 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] Query ambiguity
by Dev C 17 May '18

17 May '18

Hello I have query ambiguity as attached. Please help me on how to solve that.

4 6

[Maria-discuss] Interval in MYsql query
by Dev C 16 May '18

16 May '18

Hello If I use below query (metrics_5.created_at)>'5/10/2018'- 28 ) it gives me some result but if i use below query (metrics_5.created_at)>'5/10/2018'- INTERVAL 28 DAY ) It does not give me any result, any one know why ?

3 2

[Maria-discuss] MySQL Quries and Error
by Dev C 16 May '18

16 May '18

Below is my queries SELECT AdData4w.`Campaign Name`, AdData4w.`Adgroup Name`, AdData4w.`4w Clicks`, AdData1w.`1w Clicks`, AdData4w.`4w Orders`, AdData1w.`1w Orders`, AdData4w.`4w Spend`, AdData1w.`1w Spend`, AdData4w.`4w Sales`, AdData1w.`1w Sales`, AdData4w.`4w Conv Rate`, AdData1w.`1w Conv Rate`, AdData4w.`4w ACOS`, AdData1w.`1w ACOS`, AdData4w.`4w CPC`, AdData1w.`1w CPC`,AdData4w.`4w Bid`, AdData1w.`1w Bid` FROM AdData4w INNER JOIN AdData1w ON (AdData4w.`Adgroup Name` = AdData1w.`Adgroup Name`) AND (AdData4w.`Campaign Name` = AdData1w.`Campaign Name`) GROUP BY AdData4w.`Campaign Name`, AdData4w.`Adgroup Name`, AdData4w.`4w Clicks`, AdData1w.`1w Clicks`, AdData4w.`4w Orders`, AdData1w.`1w Orders`, AdData4w.`4w Spend`, AdData1w.`1w Spend`, AdData4w.`4w Sales`, AdData1w.`1w Sales`, AdData4w.`4w Conv Rate`, AdData1w.`1w Conv Rate`, AdData4w.`4w ACOS`, AdData1w.`1w ACOS`, AdData4w.`4w CPC`, AdData1w.`1w CPC`, AdData4w.`4w Bid`, AdData1w.`1w Bid` From (SELECT campaigns_5.name AS `Campaign Name`, adgroups_5.name AS `Adgroup Name`, Sum(metrics_5.clicks) AS `1w Clicks`, Sum(metrics_5.orders) AS `1w Orders`, Sum(metrics_5.costs) AS `1w Spend`, Sum(metrics_5.sales) AS `1w Sales`, If(Sum(clicks)=0,0,Sum(orders)/Sum(clicks)) AS `1w Conv Rate`, If(Sum(metrics_5.sales)=0,0,Sum(metrics_5.costs)/Sum(metrics_5.sales)) AS `1w ACOS`, IF (Sum(clicks)=0,0,Sum(costs)/Sum(clicks)) AS `1w CPC`, Avg(bid_info_5.value) AS `1w Bid` FROM ((adgroups_5 INNER JOIN campaigns_5 ON adgroups_5.campaignId = campaigns_5.campaignId) INNER JOIN metrics_5 ON adgroups_5.adGroupId = metrics_5.type_id) INNER JOIN bid_info_5 ON adgroups_5.adGroupId = bid_info_5.type_id WHERE (((metrics_5.created_at)>'5/10/2018'-7)) GROUP BY campaigns_5.name, adgroups_5.name, campaigns_5.user_market_id, RIGHT(campaigns_5.name,4) HAVING (((campaigns_5.user_market_id)=12) AND ((Right(campaigns_5.name,4))="PFUS") AND ((Sum(metrics_5.impressions))>0)) ORDER BY campaigns_5.name, adgroups_5.name) AS AdData1w INNER JOIN (SELECT campaigns_5.name AS `Campaign Name`, adgroups_5.name AS `Adgroup Name`, Sum(metrics_5.clicks) AS `4w Clicks`, Sum(metrics_5.orders) AS `4w Orders`, Sum(metrics_5.costs) AS `4w Spend`, Sum(metrics_5.sales) AS `4w Sales`, If(Sum(clicks)=0,0,Sum(orders)/Sum(clicks)) AS `4w Conv Rate`, If(Sum(metrics_5.sales)=0,0,Sum(metrics_5.costs)/Sum(metrics_5.sales)) AS `4w ACOS`, If(Sum(clicks)=0,0,Sum(costs)/Sum(clicks)) AS `4w CPC`, Avg(bid_info_5.value) AS `4w Bid` FROM ((adgroups_5 INNER JOIN campaigns_5 ON adgroups_5.campaignId = campaigns_5.campaignId) INNER JOIN metrics_5 ON adgroups_5.adGroupId = metrics_5.type_id) INNER JOIN bid_info_5 ON adgroups_5.adGroupId = bid_info_5.type_id WHERE (((metrics_5.created_at)>'5/10/2018'-28)) GROUP BY campaigns_5.name, adgroups_5.name, campaigns_5.user_market_id, RIGHT(campaigns_5.name,4) HAVING (((campaigns_5.user_market_id)=12) AND ((Right(campaigns_5.name,4))="PFUS") AND ((Sum(metrics_5.impressions))>0)) ORDER BY campaigns_5.name, adgroups_5.name) AS AdData4w it gives error on as below 4 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'From (SELECT campaigns_5.name AS `Campaign Name`, adgroups_5.name AS `Adgroup N' at line 4 Query12.sql 1 1 Please assist.

2 1

[Maria-discuss] [question] password input length
by Michal Schorm 16 May '18

16 May '18

Hello everyone, 1) I found out, that passwords longer than 79 characters aren't accepted via password prompt. Is that expected? Morie info and reproducer in RH bugzilla: https://bugzilla.redhat.com/show_bug.cgi?id=1566179 -- 2) Another password length cap at 213 characters can be found when using sha256_password authentification plugin. Is that expected too? Morie info and reproducer in RH bugzilla: https://bugzilla.redhat.com/show_bug.cgi?id=1566219 -- 3) Different theme: why aren't tests for mariadb-connector-odbc, that can be found on GitHub, packged to the source tarball ? -- Michal Schorm Associate Software Engineer Core Services - Databases Team Red Hat

2 2

[Maria-discuss] Installing MariaDB Alongside MySQL
by Muhammad Bashir Al-Noimi 15 May '18

15 May '18

4 27

[Maria-discuss] Charsets and collations
by Peter Laursen 20 Apr '18

20 Apr '18

Does anybody know if there are any plans to bring collations added in MySQL 8 - refer http://mysqlserverteam.com/new-collations-in-mysql-8-0-0/ - to MariaDB and are there any plans to change the default charset to a unicode-based one? -- Peter -- Webyog

2 2

[Maria-discuss] MariaDB Developers Unconference in June
by Ian Gilfillan 10 Apr '18

10 Apr '18

The next MariaDB Developers Unconference is going to be held in Tampera, Finland, from 26 June to 29 June. This will be a four-day event; the first day focusing on new contributors, the 2nd and 3rd the regular Unconference sessions and discussions, and the 4th day on getting patches reviewed and implemented, taking advantage of the chance to have in-person discussions. Details, as well as where to sign up, are at https://mariadb.org/2018-2-developers-unconference-in-finland/

1 0

[Maria-discuss] MDEV-15765 BETWEEN not working in certain cases
by Michael Caplan 08 Apr '18

08 Apr '18

Hello, I've just stalled a rollout to production of 10.2.14 because of this what I think is rather huge SQL break (https://jira.mariadb.org/browse/MDEV-15765) Anyone else holding 10.2.14 from production? Anyone running 10.2.14 in production? Trying to get some additional perspective on this issue. Thanks, Mike

1 0

[Maria-discuss] Replication New to Old
by Michael Caplan 08 Apr '18

08 Apr '18

Hello, I realize that in general replication from a newer master to an older slave is typically not recommended. This said, does anyone have an experience replicating from MariaDB 10.2 to MySQL 5.6? The compatibility matrix found here: https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/ Seems to be missing data on this type of setup. Thanks, Mike

5 6

[Maria-discuss] galera & restore a database
by lejeczek 28 Mar '18

28 Mar '18

hi guys I have mariadb in a three nodes galera cluster, when I restore a database on a node: $ mysql wordpress_local < db.sql it works well on that node but the remaining two nodes database tables are empty. Tables structure is there, but no records. What am I missing, doing wrong? many thanks, L.

1 0

[Maria-discuss] MDEV-10286 - Adjustment of table_open_cache according to system limits does not work when open-files-limit option is provided
by Sergey Vojtovich 21 Mar '18

21 Mar '18

Hi Monty, > diff --git a/mysql-test/mysql-test-run.pl b/mysql-test/mysql-test-run.pl > index 55543e529a6..54dc0aa17cc 100755 > --- a/mysql-test/mysql-test-run.pl > +++ b/mysql-test/mysql-test-run.pl > @@ -4469,6 +4469,7 @@ sub extract_warning_lines ($$) { > qr/InnoDB: See also */, > qr/InnoDB: Cannot open .*ib_buffer_pool.* for reading: No such file or directory*/, > qr/InnoDB: Table .*mysql.*innodb_table_stats.* not found./, > + qr/Changed limits: max_open_files/, I wonder how did you get this warning? > qr/InnoDB: User stopword table .* does not exist./ > > ); > diff --git a/sql/mysqld.cc b/sql/mysqld.cc > index b21d50a20fe..b3414279ac9 100644 > --- a/sql/mysqld.cc > +++ b/sql/mysqld.cc > @@ -4446,11 +4446,18 @@ static int init_common_variables() > > /* connections and databases needs lots of files */ > { > - uint files, wanted_files, max_open_files; > + uint files, wanted_files, max_open_files, min_tc_size, extra_files, > + min_connections; > + ulong org_max_connections= max_connections, org_tc_size= tc_size; > > + /* Number of files reserved for temporary files */ > + extra_files= 30; > + min_connections= 10; > /* MyISAM requires two file handles per table. */ > - wanted_files= (10 + max_connections + extra_max_connections + > + wanted_files= (extra_files + max_connections + extra_max_connections + > tc_size * 2); > + min_tc_size= MY_MIN(tc_size, TABLE_OPEN_CACHE_MIN); > + > /* > We are trying to allocate no less than max_connections*5 file > handles (i.e. we are trying to set the limit so that they will I believe the following is easier to read: ulong org_max_connections= max_connections; ulong org_tc_size= tc_size; ulong min_tc_size= MY_MIN(tc_size, TABLE_OPEN_CACHE_MIN); /* Number of files reserved for temporary files */ uint extra_files= 30; uint min_connections= 10; /* MyISAM requires two file handles per table. */ uint wanted_files= extra_files + max_connections + extra_max_connections + tc_size * 2; /* We are trying to allocate no less than max_connections*5 file handles (i.e. we are trying to set the limit so that they will be available). In addition, we allocate no less than how much was already allocated. However below we report a warning and recompute values only if we got less file handles than were explicitly requested. No warning and re-computation occur if we can't get max_connections*5 but still got no less than was requested (value of wanted_files). */ uint max_open_files= MY_MAX(MY_MAX(wanted_files, (max_connections + extra_max_connections)*5), open_files_limit); uint files= my_set_max_open_files(max_open_files); > @@ -4463,43 +4470,43 @@ static int init_common_variables() > */ > max_open_files= MY_MAX(MY_MAX(wanted_files, > (max_connections + extra_max_connections)*5), > - open_files_limit); > + open_files_limit); > files= my_set_max_open_files(max_open_files); > > - if (files < wanted_files) > - { > - if (!open_files_limit || IS_SYSVAR_AUTOSIZE(&open_files_limit)) > - { > - /* > - If we have requested too much file handles than we bring > - max_connections in supported bounds. > - */ > - SYSVAR_AUTOSIZE(max_connections, > - (ulong) MY_MIN(files-10-TABLE_OPEN_CACHE_MIN*2, max_connections)); > - /* > - Decrease tc_size according to max_connections, but > - not below TABLE_OPEN_CACHE_MIN. Outer MY_MIN() ensures that we > - never increase tc_size automatically (that could > - happen if max_connections is decreased above). > - */ > - SYSVAR_AUTOSIZE(tc_size, > - (ulong) MY_MIN(MY_MAX((files - 10 - max_connections) / 2, > - TABLE_OPEN_CACHE_MIN), tc_size)); > - DBUG_PRINT("warning", > - ("Changed limits: max_open_files: %u max_connections: %ld table_cache: %ld", > - files, max_connections, tc_size)); > - if (global_system_variables.log_warnings > 1) > - sql_print_warning("Changed limits: max_open_files: %u max_connections: %ld table_cache: %ld", > - files, max_connections, tc_size); > - } > - else if (global_system_variables.log_warnings) > - sql_print_warning("Could not increase number of max_open_files to more than %u (request: %u)", files, wanted_files); > - } > - SYSVAR_AUTOSIZE(open_files_limit, files); > + if (files < wanted_files && global_system_variables.log_warnings) > + sql_print_warning("Could not increase number of max_open_files to more than %u (request: %u)", files, wanted_files); > + > + /* > + If we have requested too much file handles than we bring > + max_connections in supported bounds. Still leave at least > + 'min_connections' connections > + */ > + SYSVAR_AUTOSIZE(max_connections, > + (ulong) MY_MAX(MY_MIN(files- extra_files- min_tc_size*2, > + max_connections), min_connections)); > + /* > + Decrease tc_size according to max_connections, but > + not below min_tc_size. Outer MY_MIN() ensures that we > + never increase tc_size automatically (that could > + happen if max_connections is decreased above). > + */ > + SYSVAR_AUTOSIZE(tc_size, > + (ulong) MY_MIN(MY_MAX((files - extra_files - > + max_connections) / 2, min_tc_size), > + tc_size)); > + DBUG_PRINT("warning", > + ("Current limits: max_open_files: %u max_connections: %ld table_cache: %ld", > + files, max_connections, tc_size)); > + if (global_system_variables.log_warnings > 1 && > + (max_connections < org_max_connections || > + tc_size < org_tc_size)) > + sql_print_warning("Changed limits: max_open_files: %u max_connections: %lu (%lu) table_cache: %lu (%lu)", I'd say this format is quite confusing. Probably add something like "was %lu" in brackets? > + files, max_connections, org_max_connections, > + tc_size, org_tc_size); I think the above code must be executed under "if (files < wanted_files)". We don't really want to "autosize" max_connections and tc_size if we got enough file descriptors. Also you missed to "autosize" open_files_limit. I think it should be done "if (open_files_limit != files) SYSVAR_AUTOSIZE(open_files_limit, files);". > } > > /* > - Max_connections is now set. > + Max_connections and tc_cache is now set. s/is/are/ > Now we can fix other variables depending on this variable. > */ > > diff --git a/sql/sql_const.h b/sql/sql_const.h > index 65742235bee..e28a0649f04 100644 > --- a/sql/sql_const.h > +++ b/sql/sql_const.h > @@ -127,7 +127,7 @@ > #define MAX_FIELDS_BEFORE_HASH 32 > #define USER_VARS_HASH_SIZE 16 > #define SEQUENCES_HASH_SIZE 16 > -#define TABLE_OPEN_CACHE_MIN 400 > +#define TABLE_OPEN_CACHE_MIN 200 > #define TABLE_OPEN_CACHE_DEFAULT 2000 > #define TABLE_DEF_CACHE_DEFAULT 400 > /** > diff --git a/sql/sys_vars.cc b/sql/sys_vars.cc > index de9806ab289..41317a5c259 100644 > --- a/sql/sys_vars.cc > +++ b/sql/sys_vars.cc > @@ -3477,7 +3477,7 @@ static bool fix_table_open_cache(sys_var *, THD *, enum_var_type) > static Sys_var_ulong Sys_table_cache_size( > "table_open_cache", "The number of cached open tables", > GLOBAL_VAR(tc_size), CMD_LINE(REQUIRED_ARG), > - VALID_RANGE(1, 1024*1024), DEFAULT(TABLE_OPEN_CACHE_DEFAULT), > + VALID_RANGE(10, 1024*1024), DEFAULT(TABLE_OPEN_CACHE_DEFAULT), Why? There're at least a few test cases that do table_open_cache=1: partition_open_files_limit, sp, myisam. > BLOCK_SIZE(1), NO_MUTEX_GUARD, NOT_IN_BINLOG, ON_CHECK(0), > ON_UPDATE(fix_table_open_cache)); > Regards, Sergey

2 1

[Maria-discuss] columns compression
by Roberto Spadim 19 Mar '18

19 Mar '18

hi guys! anyone testing column compression and have problems when changing form one table format to other? i created a new table with blob compressed column, and i'm trying to insert select from old table, but i got a problem: MariaDB [test]> insert into new_table select * from old_table; ERROR 1406 (22001): Data too long for column 'data' at row 1 using aria or innodb engine give the same error, it's a BLOB columns tahnks -- Roberto Spadim

2 8

[Maria-discuss] SQL_MODE=ORACLE documentation
by Federico Razzoli 05 Mar '18

05 Mar '18

With SQL_MODE='ORACLE' a completely new syntax has been introduced. Basic syntax constructs of MariaDB become unavailable, but not all Oracle syntax seems to be supported. Is there any plan to document the supported syntax? Current documentation looks like an unfinished draft and doesn't save much time for the poor user. Regards,Federico

4 5

[Maria-discuss] 10.3.5 tokudb rpm missing for Opensuse
by Reinis Rozitis 04 Mar '18

04 Mar '18

Hello, It seems that the Mariadb 10.3.5 Tokudb rpm package hasn't been built (and replicated on mirrors) for Opensuse (though all other like SLES, Rhel, Centos do have it). rr

2 1

[Maria-discuss] Backing up a single database with mariabackup?
by Kevin Poitra 01 Mar '18

01 Mar '18

I've been working on redoing our database backup routines, and have looked into mariabackup as mysqldump doesn't cut it anymore given the size of our schemas. We have multiple schemas that need to be backed up - they all vary in size, and they also vary in backup frequency (some need to be backed up on a six hour period, others can go a day in between backups). On top of that, our database consists of two database servers, running in a master-slave configuration. To start, I ran this command against one of our schemas: mariabackup --backup --user root --password <pass> --databases db1 That generated a copy of the 'db1' schema's data files, along with some files used by MariaDB itself (aria_log, ib_buffer_pool, ib_logfile, ibdata, so on). This works perfectly - we can create separate backups of each of our schemas. Restoring seems to be another story however. After '--prepare'ing the backup and issuing the mariabackup --copy-back command, it complains that the data directory must be empty. If I have separated backups, would it be possible for me to restore those schemas under one database (or rather, one MariaDB instance)? To be even clearer, if I've made backups of schemas 'db1', 'db2', and 'db3', I don't seem to be able to restore them all under the same database instance - is there something I'm not understanding?

2 1

[Maria-discuss] procedure to change database encryption with file_key_management plugin?
by obsa＠mm.st 27 Feb '18

27 Feb '18

I've built mysqld -V mysqld Ver 10.2.14-MariaDB-log for Linux on x86_64 (Source distribution) I'm setting up encryption, following https://mariadb.com/kb/en/library/encryption/ https://mariadb.com/kb/en/library/data-at-rest-encryption/ I created my key file openssl rand -hex 32 b650adbc0c5df1bc3e766b4b65f26dc76c76ed81b955bbedaf50e1d4e16fc732 /etc/mariadb/keys.txt 1;b650adbc0c5df1bc3e766b4b65f26dc76c76ed81b955bbedaf50e1d4e16fc732 encrypted it openssl enc -aes-256-cbc -k 'test_passphrase' -md sha1 -in /etc/mariadb/keys.txt -out /etc/mariadb/keys.enc verified it openssl aes-256-cbc -d -md sha1 -k 'test_passphrase' -in /etc/mariadb/keys.enc 1;b650adbc0c5df1bc3e766b4b65f26dc76c76ed81b955bbedaf50e1d4e16fc732 I've enabled "everything" encryption using that keyfile [mysqld] plugin_dir=/opt/mariadb/lib/plugin plugin-load-add=file_key_management file-key-management file_key_management_encryption_algorithm=aes_ctr file_key_management_filekey = 'test_filekey' file_key_management_filename = /etc/mariadb/enc/keys.enc aria-encrypt-tables = 1 encrypt-binlog = 1 encrypt-tmp-disk-tables = 1 encrypt-tmp-files = 1 innodb_default_encryption_key_id = 1 innodb-encrypt-log = off innodb-encrypt-tables = on innodb-encryption-threads = 4 innodb-tablespaces-encryption = 1 verified the plugin loads mysql -e "show plugins;" | grep ENC INNODB_TABLESPACES_ENCRYPTION ACTIVE INFORMATION SCHEMA NULL BSD file_key_management ACTIVE ENCRYPTION file_key_management.so GPL on startup it looks like it starts up ok 2018-02-21 13:01:29 139729003899072 [Note] InnoDB: 5.7.21 started; log sequence number 7206290786 2018-02-21 13:01:29 139729003899072 [Note] InnoDB: Creating #1 encryption thread id 139727810316032 total threads 4. 2018-02-21 13:01:29 139729003899072 [Note] InnoDB: Creating #2 encryption thread id 139727801923328 total threads 4. 2018-02-21 13:01:29 139727818708736 [Note] InnoDB: Loading buffer pool(s) from /home/data/db/ib_buffer_pool 2018-02-21 13:01:29 139729003899072 [Note] InnoDB: Creating #3 encryption thread id 139727793530624 total threads 4. 2018-02-21 13:01:29 139729003899072 [Note] InnoDB: Creating #4 encryption thread id 139727785137920 total threads 4. 2018-02-21 13:01:29 139727818708736 [Note] InnoDB: Buffer pool(s) load completed at 180222 13:01:29 2018-02-21 13:01:29 139729003899072 [Note] Using encryption key id 1 for temporary files 2018-02-21 13:01:29 139729003899072 [Note] Server socket created on IP: '127.0.0.1'. 2018-02-21 13:01:29 139729003899072 [Note] Reading of all Master_info entries succeded 2018-02-21 13:01:29 139729003899072 [Note] Added new Master_info '' to hash table 2018-02-21 13:01:29 139729003899072 [Note] /opt/mariadb/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/var/cache/mariadb/mariadb.sock' port: 3306 Source distribution and verified table encryption mysql -e "SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION;" +-------+-------------------------------------------+-------------------+--------------------+-----------------+---------------------+--------------------------+------------------------------+----------------+----------------------+ | SPACE | NAME | ENCRYPTION_SCHEME | KEYSERVER_REQUESTS | MIN_KEY_VERSION | CURRENT_KEY_VERSION | KEY_ROTATION_PAGE_NUMBER | KEY_ROTATION_MAX_PAGE_NUMBER | CURRENT_KEY_ID | ROTATING_OR_FLUSHING | +-------+-------------------------------------------+-------------------+--------------------+-----------------+---------------------+--------------------------+------------------------------+----------------+----------------------+ | 1375 | mysql/gtid_slave_pos | 1 | 1 | 1 | 1 | NULL | NULL | 1 | 0 | | 1465 | mysql/innodb_index_stats | 1 | 1 | 1 | 1 | NULL | NULL | 1 | 0 | | 1466 | mysql/innodb_table_stats | 1 | 1 | 1 | 1 | NULL | NULL | 1 | 0 | | 18999 | testdata/table0001 | 1 | 0 | 1 | 1 | NULL | NULL | 1 | 0 | ... ... ... | 0 | innodb_system | 1 | 1 | 1 | 1 | NULL | NULL | 1 | 0 | +-------+-------------------------------------------+-------------------+--------------------+-----------------+---------------------+--------------------------+------------------------------+----------------+----------------------+ reading Encryption key management MariaDB encryption supports multiple encryption keys, they are identified by a key identifier — a 32-bit integer. To support automatic key rotation every key additionally might have different versions. XtraDB and InnoDB can automatically re-encrypt the data from an older to a newer version of the same key. But how different keys are stored and rotated depends on the key management solution that you choose. but for this plugin file_key_management This plugin does not support key rotation — all keys always have the version 1. So I understand that I can't rotate the keys similar to what the AWS plugin provides. But if I need to change the key at any time, either just its encrypted form /etc/mariadb/keys.enc &/or the 'master' /etc/mariadb/keys.txt What's the procedure to re-key all the encrypted tables? Do I need to (1) stop the server (2) manually decrypt each table with its old key (3) reencrypt each table with the new key (4) restart the server ? True also for having used multiple keys for global/default, temp tables, and per-table? Is there any tool/procedure that automates that? I suppose that the AWS plugin takes care of that automated-rotation. Is there another non-commercial/open-source plugin with similar rotation capability?

3 4

[Maria-discuss] JSON column type
by Brent Clark 22 Feb '18

22 Feb '18

Good day Guys I have a client that is looking for JSON support, or better 'JSON column type'. He is asking for MySQL/5.7.8 (Currently on MySQL 5.6). And his comment is : "/This is so that we can use the JSON column type introduced in this version." We don't use MySQL, well we shipping away to MariaDB. The question I would like to ask is. Based on reading : https://mariadb.com/resources/blog/best-both-worlds-relational-json Is it fair to say, the clients needs are met? If anyone has any comment or further thought on this matter or any tips to share it would gratefully be appreciated. Regards and many thanks. Brent Clark

2 2

[Maria-discuss] mysqld_safe
by Ruben Safir 21 Feb '18

21 Feb '18

I did an update on my package manager and it seems that mysqld_safe was removed from the system, and I have that integrated into my openrc init system. Has it stopped being supported? ruben -- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and and extermination camps, but incompatible with living as a free human being. -RI Safir 2013

2 1

[Maria-discuss] build broken again -> Fwd: [MariaDB Announce] MariaDB 10.2.13, MariaDB Connector/ODBC 3.0.3 and MariaDB Connector/ODBC 2.0.16 now available
by Reindl Harald 14 Feb '18

14 Feb '18

can we have a release which simply builds? see my complaint about 10.2.12 10.2.13 is also broken different place would you guys mind sent out a link to the users list *before* GA annoucements so that such likely easy to fix bugs can be fixed *before* the announcement? and no it's not a option build with partition support and disable it in my.cnf because the next build won't start because the unknown option and i danced these dance now often enough while MariaDB is the only project in the whole opensource-ecosystem where can place a bet that the next release won't build with the same options Scanning dependencies of target mysqld Scanning dependencies of target explain_filename-t [ 99%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o [100%] Building CXX object unittest/sql/CMakeFiles/explain_filename-t.dir/explain_filename-t.cc.o [100%] Linking CXX executable mysqld [100%] Linking CXX executable explain_filename-t libsql.a(sql_yacc.cc.o): In function `MYSQLparse(THD*)': /home/buildbot/git/sql/sql_yacc.yy:5211: undefined reference to `partition_info::error_if_requires_values() const' collect2: error: ld returned 1 exit status make[2]: *** [sql/CMakeFiles/mysqld.dir/build.make:115: sql/mysqld] Error 1 make[1]: *** [CMakeFiles/Makefile2:8465: sql/CMakeFiles/mysqld.dir/all] Error 2 make[1]: *** Waiting for unfinished jobs.... ../../sql/libsql.a(sql_yacc.cc.o): In function `MYSQLparse(THD*)': /home/buildbot/git/sql/sql_yacc.yy:5211: undefined reference to `partition_info::error_if_requires_values() const' collect2: error: ld returned 1 exit status make[2]: *** [unittest/sql/CMakeFiles/explain_filename-t.dir/build.make:116: unittest/sql/explain_filename-t] Error 1 make[1]: *** [CMakeFiles/Makefile2:1336: unittest/sql/CMakeFiles/explain_filename-t.dir/all] Error 2 make: *** [Makefile:163: all] Error 2 Fehler: Fehler-Status beim Beenden von /var/tmp/rpm-tmp.Xg5GXO (%build) -------- Weitergeleitete Nachricht -------- Betreff: [Maria-discuss] Fwd: [MariaDB Announce] MariaDB 10.2.12 now available Datum: Thu, 4 Jan 2018 19:29:36 +0100 Von: Reindl Harald <h.reindl(a)thelounge.net> An: Mailing-List mariadb <maria-discuss(a)lists.launchpad.net> and once again a update don't build with the same rpm-spec as before - frankly how often should i offer that someone sends out a mail to the ML with a link to a proposed release tarball to get such things fixed *before* release? + cmake . -DFEATURE_SET=large -DCMAKE_INSTALL_PREFIX=/usr -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_LAYOUT=RPM -DDAEMON_NAME=mysqld -DDAEMON_NO_PREFIX=mysqld -DNICE_PROJECT_NAME=MariaDB -DINSTALL_LIBDIR=lib64/mysql -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql-test -DINSTALL_PLUGINDIR=lib64/mysql/plugin -DINSTALL_SBINDIR=libexec -DINSTALL_SCRIPTDIR=bin -DINSTALL_SQLBENCHDIR= -DINSTALL_SUPPORTFILESDIR=share/mysql -DMYSQL_DATADIR=/var/lib/mysql -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DENABLED_PROFILING=OFF -DENABLE_DEBUG_SYNC=OFF -DENABLE_DTRACE=OFF -DPLUGIN_ARIA=YES -DPLUGIN_CSV=YES -DPLUGIN_MYISAM=YES -DPLUGIN_ARCHIVE=NO -DPLUGIN_BLACKHOLE=NO -DPLUGIN_CASSANDRA=NO -DPLUGIN_CONNECT=NO -DPLUGIN_EXAMPLE=NO -DPLUGIN_FEDERATED=NO -DPLUGIN_FEDERATEDX=NO -DPLUGIN_FEEDBACK=NO -DPLUGIN_MROONGA=NO -DPLUGIN_MYISAMMRG=NO -DPLUGIN_OQGRAPH=NO -DPLUGIN_PARTITION=NO -DPLUGIN_PERFSCHEMA=NO -DPLUGIN_ROCKSDB=NO -DPLUGIN_SEMISYNC=NO -DPLUGIN_SEQUENCE=NO -DPLUGIN_SPHINX=NO -DPLUGIN_SPIDER=NO -DPLUGIN_TOKUDB=NO -DPLUGIN_XTRADB=NO -DWITHOUT_DYNAMIC_PLUGINS=ON -DWITH_ATOMIC_OPS=smp -DWITH_EMBEDDED_SERVER=OFF -DWITH_INNODB_DISALLOW_WRITES=OFF -DWITH_INNODB_BZIP2=OFF -DWITH_INNODB_LZ4=OFF -DWITH_INNODB_LZMA=OFF -DWITH_INNODB_LZO=OFF -DWITH_INNODB_SNAPPY=OFF -DWITH_MYSQLCOMPAT=ON -DSECURITY_HARDENED=OFF -DWITH_LIBARCHIVE=OFF -DWITH_LIBWRAP=OFF -DWITH_MARIABACKUP=OFF -DWITH_PIC=NO -DWITH_READLINE=OFF -DWITH_SAFEMALLOC=OFF -DWITH_VALGRIND=OFF -DWITH_WSREP=OFF -DWITH_JEMALLOC=OFF -DWITH_SSL=system -DWITH_ZLIB=system -DCOMPILATION_COMMENT=thelounge [ 99%] Built target sql Scanning dependencies of target explain_filename-t Scanning dependencies of target mysqld [ 99%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o [100%] Linking CXX executable mysqld [100%] Building CXX object unittest/sql/CMakeFiles/explain_filename-t.dir/explain_filename-t.cc.o [100%] Linking CXX executable explain_filename-t libsql.a(sql_yacc.cc.o): In function .`MYSQLparse.(/THD.*.)/'sql:/ libsql.a/(homesql_yacc.cc.o/)buildbot:/ Ingit /functionsql /`sql_yacc.yyMYSQLparse(:THD*5211):' :undefined /referencehome /tobuildbot /`gitpartition_info/sql:/:sql_yacc.yyerror_if_requires_values:5211(: )undefined referenceconst 'to `partition_info::error_if_requires_values() const' collect2: error: ld returned 1 exit status collect2: error: ld returned 1 exit status make[2]: *** [sql/CMakeFiles/mysqld.dir/build.make:115: sql/mysqld] Error 1 make[2]: *** [unittest/sql/CMakeFiles/explain_filename-t.dir/build.make:116: unittest/sql/explain_filename-t] Error 1 make[1]: *** [CMakeFiles/Makefile2:8464: sql/CMakeFiles/mysqld.dir/all] Error 2 make[1]: *** Waiting for unfinished jobs.... make[1]: *** [CMakeFiles/Makefile2:1336: unittest/sql/CMakeFiles/explain_filename-t.dir/all] Error 2 -------- Weitergeleitete Nachricht -------- Betreff: [MariaDB Announce] MariaDB 10.2.13, MariaDB Connector/ODBC 3.0.3 and MariaDB Connector/ODBC 2.0.16 now available Datum: Tue, 13 Feb 2018 21:03:01 +0200 Von: MariaDB Announce List <announce(a)mariadb.org> An: announce(a)mariadb.org The MariaDB project is pleased to announce the availability of MariaDB 10.2.13, the latest stable release in the MariaDB 10.2 series, MariaDB Connector/ODBC 3.0.3, the latest stable release in the MariaDB Connector/ODBC 3.0 series, and MariaDB Connector/ODBC 2.0.16, the latest stable release in the MariaDB Connector/ODBC 2.0 series. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.13 - Release Notes: https://mariadb.com/kb/en/mdb-10213-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10213-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.13 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/ODBC 3.0.3 - Release Notes: https://mariadb.com/kb/en/mco-303-rn/ - Changelog: https://mariadb.com/kb/en/mco-303-cl/ - Downloads: https://downloads.mariadb.org/connector-odbc/3.0.3/ MariaDB Connector/C 2.0.16 - Release Notes: https://mariadb.com/kb/en/mco-2016-rn/ - Changelog: https://mariadb.com/kb/en/mco-2016-cl/ - Downloads: https://downloads.mariadb.org/connector-odbc/2.0.16/ About MariaDB Connector/C: - https://mariadb.com/kb/en/about-mariadb-connector-c/ - - 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://jira.mariadb.org - - 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/mariadbfdn Knowledge Base - http://mariadb.com/kb

2 2

Re: [Maria-discuss] mariadb-backup meta deb package
by Reindl Harald 14 Feb '18

14 Feb '18

Am 14.02.2018 um 12:56 schrieb Florent B: > On 14/02/2018 12:49, Sergei Golubchik wrote: >> Hi, Florent! >> >> On Feb 14, Florent B wrote: >>> Hi, >>> >>> Wouldn't be nice to have a metapackage mariadb-backup in Debian >>> repository, that depends on the current best version >>> (mariadb-backup-10.2, etc..) ? >>> >>> Like "mariadb-server" package in fact. >> Yes, I guess. >> It'll be consistent with what we do with the server. >> >> Of course, if you also have a solution how to reduce the number of >> packages, that'd be perfect :) >> >> Hmm, how about that? >> We rename the following packages to remove "-10.1" at the end. >> >> mariadb-connect-engine-10.1 >> mariadb-oqgraph-engine-10.1 >> mariadb-cracklib-password-check-10.1 >> mariadb-gssapi-server-10.1 >> mariadb-gssapi-client-10.1 >> mariadb-backup-10.1 >> >> This way the server package will specify the version (either >> "mariadb-server-10.1" for 10.1 or "mariadb-server" for the latest) >> and everything else will follow. >> >> Looks logical and doesn't increase the number of packages (!!!). >> But I need to try whether it'll actually work in Debian :) > > Wow ! Someone understood what I mean. Thank you a lot Sergei, I though I > was crazy seeing other people's answers well, i don't get why there needs to be a metapackage at all http://yum.mariadb.org/10.1/rhel6-x86/rpms/ http://yum.mariadb.org/10.2/rhel6-x86/rpms/ these are different repos and you have either 10.1 or 10.2 enabled whatever packages in whatever versions are there, the update manager without mention a version explicit takes the one with the highest number independent of a new install or update %package server Summary: The MariaDB server and related files Requires: %{name} = %{epoch}:%{version}-%{release}, %{name}-libs = %{epoch}:%{version}-%{release} Requires: sh-utils Requires(pre): shadow-utils Provides: mysql-server = %{epoch}:%{version}-%{release}, mysql-server%{?_isa} = %{epoch}:%{version}-%{release} Obsoletes: mysql-server, community-mysql-server %description server "dnf install mysql-server" == "dnf install mariadb-server" == "dnf install community-mysql-server" why? because the Provides/Obsoletes in my spec say so

1 0

Re: [Maria-discuss] mariadb-backup meta deb package
by Reindl Harald 14 Feb '18

14 Feb '18

Am 14.02.2018 um 10:51 schrieb Florent B: > Wouldn't be nice to have a metapackage mariadb-backup in Debian > repository, that depends on the current best version > (mariadb-backup-10.2, etc..) ? > > Like "mariadb-server" package in fact you missed to describe the problem you want to solve by step in with a solution which is always the wrong start because in case you didn't understand the real problem any solution is wrong

2 1

Re: [Maria-discuss] mariadb-backup meta deb package
by Sergei Golubchik 14 Feb '18

14 Feb '18

Hi, Florent! On Feb 14, Florent B wrote: > Hi, > > Wouldn't be nice to have a metapackage mariadb-backup in Debian > repository, that depends on the current best version > (mariadb-backup-10.2, etc..) ? > > Like "mariadb-server" package in fact. Yes, I guess. It'll be consistent with what we do with the server. Of course, if you also have a solution how to reduce the number of packages, that'd be perfect :) Hmm, how about that? We rename the following packages to remove "-10.1" at the end. mariadb-connect-engine-10.1 mariadb-oqgraph-engine-10.1 mariadb-cracklib-password-check-10.1 mariadb-gssapi-server-10.1 mariadb-gssapi-client-10.1 mariadb-backup-10.1 This way the server package will specify the version (either "mariadb-server-10.1" for 10.1 or "mariadb-server" for the latest) and everything else will follow. Looks logical and doesn't increase the number of packages (!!!). But I need to try whether it'll actually work in Debian :) Regards, Sergei Chief Architect MariaDB and security(a)mariadb.org

1 0

Re: [Maria-discuss] mariadb-backup meta deb package
by Reindl Harald 14 Feb '18

14 Feb '18

Am 14.02.2018 um 12:22 schrieb Florent B: > I'm sorry but that's what not I mean. > > My message was just a suggestion, to have a "meta-package" for Debian > repository, like we have a meta-package "mariadb-server" that points to > "mariadb-server-10.2" (for example, if you installed 10.2 repository). > > In my deployment script, I just install "mariadb-server", without > specifying version. I would like to do the same for "mariadb-backup". > For now, I have to specify version of package : mariadb-backup-10.2. It > could be nice to have a "mariadb-backup" meta-package to point > automatically to the latest version available. stop talking about metapackages DAMNED! you mean "mariadb-backup" in it's last recent point-version should be in the 10.2 or 10.1 repository - why don't you say it then? don't get me wrong but it's hard when people fail to say what they mean and every response is a new riddle > On 14/02/2018 12:08, Vladislav Vaintroub wrote: >> >> The latest backup will not work with your 10.1 server. Mariabackup >> version should match server version that you have on the same box. >> >> mariabackup from 10.1 appears to work with 5.5 and 10.0, but this is >> merely by luck and by accident. >> >> *From: *Florent B <mailto:florent@coppint.com> >> *Sent: *Wednesday, February 14, 2018 11:58 AM >> *To: *maria-discuss(a)lists.launchpad.net >> <mailto:maria-discuss@lists.launchpad.net> >> *Subject: *Re: [Maria-discuss] mariadb-backup meta deb package >> >> On 14/02/2018 11:16, Reindl Harald wrote: >> >> > Am 14.02.2018 um 10:51 schrieb Florent B: >> >> >> Wouldn't be nice to have a metapackage mariadb-backup in Debian >> >> >> repository, that depends on the current best version >> >> >> (mariadb-backup-10.2, etc..) ? >> >> >> Like "mariadb-server" package in fact >> >> > you missed to describe the problem you want to solve by step in with a >> >> > solution which is always the wrong start because in case you didn't >> >> > understand the real problem any solution is wrong >> >> I just want to install the latest mariadb-backup package, without >> >> checking version by myself (10.1, 10.2...). >> >> Exactly the same as the "mariadb-server" metapackage for Debian, which >> >> points to latest version possible.

1 1

Re: [Maria-discuss] mariadb-backup meta deb package
by Federico Razzoli 14 Feb '18

14 Feb '18

I am not sure this is a good idea. Having a meta-package for the server and not one for mariabackup may seem inconsistent, but users are different. A lot of people just want MariaDB and don't (need to) care about versions. Maybe they barely know SQL and just want to run a simple script. For backups, it's different. If you need mariabackup you manage a MariaDB instance, and you need to care about versions. Federico Da: Florent B <florent(a)coppint.com> A: Vladislav Vaintroub <vvaintroub(a)gmail.com>; "maria-discuss(a)lists.launchpad.net" <maria-discuss(a)lists.launchpad.net> Inviato: Mercoledì 14 Febbraio 2018 12:23 Oggetto: Re: [Maria-discuss] mariadb-backup meta deb package I'm sorry but that's what not I mean. My message was just a suggestion, to have a "meta-package" for Debian repository, like we have a meta-package "mariadb-server" that points to "mariadb-server-10.2" (for example, if you installed 10.2 repository). In my deployment script, I just install "mariadb-server", without specifying version. I would like to do the same for "mariadb-backup". For now, I have to specify version of package : mariadb-backup-10.2. It could be nice to have a "mariadb-backup" meta-package to point automatically to the latest version available. On 14/02/2018 12:08, Vladislav Vaintroub wrote: #yiv8725764717 #yiv8725764717 -- _filtered #yiv8725764717 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv8725764717 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv8725764717 #yiv8725764717 p.yiv8725764717MsoNormal, #yiv8725764717 li.yiv8725764717MsoNormal, #yiv8725764717 div.yiv8725764717MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv8725764717 a:link, #yiv8725764717 span.yiv8725764717MsoHyperlink {color:blue;text-decoration:underline;}#yiv8725764717 a:visited, #yiv8725764717 span.yiv8725764717MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;}#yiv8725764717 .yiv8725764717MsoChpDefault {} _filtered #yiv8725764717 {margin:70.85pt 70.85pt 56.7pt 70.85pt;}#yiv8725764717 div.yiv8725764717WordSection1 {}#yiv8725764717 The latest backup will not work with your 10.1 server. Mariabackup version should match server version that you have on the same box. mariabackup from 10.1 appears to work with 5.5 and 10.0, but this is merely by luck and by accident. From: Florent B Sent: Wednesday, February 14, 2018 11:58 AM To: maria-discuss(a)lists.launchpad.net Subject: Re: [Maria-discuss] mariadb-backup meta deb package On 14/02/2018 11:16, Reindl Harald wrote: > > > Am 14.02.2018 um 10:51 schrieb Florent B: >> Wouldn't be nice to have a metapackage mariadb-backup in Debian >> repository, that depends on the current best version >> (mariadb-backup-10.2, etc..) ? >> >> Like "mariadb-server" package in fact > > you missed to describe the problem you want to solve by step in with a > solution which is always the wrong start because in case you didn't > understand the real problem any solution is wrong I just want to install the latest mariadb-backup package, without checking version by myself (10.1, 10.2...). Exactly the same as the "mariadb-server" metapackage for Debian, which points to latest version possible. _______________________________________________ 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 _______________________________________________ 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

Re: [Maria-discuss] mariadb-backup meta deb package
by Reindl Harald 14 Feb '18

14 Feb '18

Am 14.02.2018 um 11:58 schrieb Florent B: > On 14/02/2018 11:16, Reindl Harald wrote: >> >> Am 14.02.2018 um 10:51 schrieb Florent B: >>> Wouldn't be nice to have a metapackage mariadb-backup in Debian >>> repository, that depends on the current best version >>> (mariadb-backup-10.2, etc..) ? >>> >>> Like "mariadb-server" package in fact >> >> you missed to describe the problem you want to solve by step in with a >> solution which is always the wrong start because in case you didn't >> understand the real problem any solution is wrong > > I just want to install the latest mariadb-backup package, without > checking version by myself (10.1, 10.2...). > Exactly the same as the "mariadb-server" metapackage for Debian, which > points to latest version possible besides that "mariadb-server" for sure is not a metapackage i doubt and hope for debian users that you don't get *major upgrade* and 10.1 to 10.2 *is* a major upgrade nobody upgrades just by the way you heavily confuse point updates and major upgrades 10.1 versus 10.2 is practically the same as 10 versus 11 just with different numbers but must not be confused with 10.1.10 to 10.1.11 and when you are at it learn what a meta-package is because in communication it's important to know what you are talking about https://askubuntu.com/questions/66257/what-is-the-difference-between-a-meta…

1 0

Re: [Maria-discuss] mariadb-backup meta deb package
by Vladislav Vaintroub 14 Feb '18

14 Feb '18

The latest backup will not work with your 10.1 server. Mariabackup version should match server version that you have on the same box. mariabackup from 10.1 appears to work with 5.5 and 10.0, but this is merely by luck and by accident. From: Florent B Sent: Wednesday, February 14, 2018 11:58 AM To: maria-discuss(a)lists.launchpad.net Subject: Re: [Maria-discuss] mariadb-backup meta deb package On 14/02/2018 11:16, Reindl Harald wrote: > > > Am 14.02.2018 um 10:51 schrieb Florent B: >> Wouldn't be nice to have a metapackage mariadb-backup in Debian >> repository, that depends on the current best version >> (mariadb-backup-10.2, etc..) ? >> >> Like "mariadb-server" package in fact > > you missed to describe the problem you want to solve by step in with a > solution which is always the wrong start because in case you didn't > understand the real problem any solution is wrong I just want to install the latest mariadb-backup package, without checking version by myself (10.1, 10.2...). Exactly the same as the "mariadb-server" metapackage for Debian, which points to latest version possible. _______________________________________________ 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] [GSoC Idea Discussion] "mcsapi needs a new read API" project
by Udit Juneja 14 Feb '18

14 Feb '18

Hi, I am Udit Juneja, a Compter Science undergraduate student at Thapar Institute of Engineering and Technology, India. I am interested in contributing to MariaDB. A brief introduction about me: I am familiar with programming languages (C, C++, Python, PyCUDA, MySQL). I have won many hackathons. I am interested in "mcsapi needs a new read API" project. I have already started exploring MariaDB, and the APIs which are currently published on the website. I would like to discuss the idea further and maybe submit a proposal in GSoC later. Regards, Udit Juneja

3 2

[Maria-discuss] Google Summer of Code 2018 - MariaDB Foundation accepted
by Colin Charles 14 Feb '18

14 Feb '18

Hi, I just noticed this piece of good news — MariaDB Foundation is accepted to participate in the Google Summer of Code 2018 again — https://summerofcode.withgoogle.com/ There is an already healthy list of ideas: https://mariadb.com/kb/en/library/google-summer-of-code-2018/ Many already have mentors from MariaDB Corporation or MariaDB Foundation. Some are looking for mentors. Happy coding this summer! cheers, -colin -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

1 0

Re: [Maria-discuss] System versioned tables inquiry
by serg＠mariadb.org 12 Feb '18

12 Feb '18

Hi, Benjamin! First: please send questions like this to maria-discuss(a)lists.launchpad.net it's a public mailing list dedicated to MariaDB. I am subscribed, so I'll see you mail there, and you may be sure I will, because it won't be accidentally catched by my spam filter, or sorted out in some obscure folder. Furthermore other subscribers will see your question and could reply if I will be not available (e.g. I could be travelling). Thank you. On Feb 05, bartels.benjamin(a)tutanota.de wrote: > Hello Mr. Golubchik, > I have a couple of questions on MariaDB's implementation of the system > versioned tables if you are not busy. > 1. Is there any mechanism in the current implementation to insert rows > with custom values for ROW START and ROW END? I know that since they > are automatically implemented as auto generated columns that they are > not allowed to be modified. But I feel like this would make backup > migration very hard, since you cannot insert into these generated > columns. Maybe I am missing something but from what I can tell it is > not possible at the moment.MSSQL from my understanding doesn't > restrict the ROW START and ROW END columns to generated columns so it > is possible to insert some data into those columns and then alter the > table to make it system versioned.See (Listing > 1): http://www.itprotoday.com/microsoft-sql-server/first-look-system-versioned-… No, there is none. It is intentional, to protect the integrity of the history. SQL Standard, as far as I know, does not provide any way of falsifying the history of system versioned tables. There is another feature in the standard: application-time period tables, in there one can provide arbitrary values for start and end timestamps. But MariaDB 10.3 doesn't support application-time period tables. As for backups, yes, I agree, it's a problem. Binary backups will preserve the history just fine, but mysqldump backups will not, they'll reset the history. > 2. What is supposed to be done in 2038 when NOW() will surpass the ROW > END column? Will there be a way to have a bigger underlying datatype > to represent the historic columns? That's the common issue for any TIMESTAMP columns. We don't have any solution specific to system versioned tables. I could *guess* that closer to that date TIMESTAMP width will be increased and, perhaps, there will be some migration procedure in mysql_uprade. There are no specific plans yet. Regards, Sergei Chief Architect MariaDB and security(a)mariadb.org

1 0

[Maria-discuss] [MARIADB 5.5] Profiling truncated
by Fabien CLERC 12 Feb '18

12 Feb '18

Hello, I'm trying to profile a very long query in production (MariaDB 5.5) using "set session profiling = 1" but when I run the command "show profile for query 1", there is only the only 100 last steps of the query. It's the same checking in "INFORMATION_SCHEMA.PROFILING" I understand the parameter "profiling_history_size" is the maximum number of queries and not the maximum steps stored fora query. => How can I change the number of steps available in the result of the profiling ? Thanks and Regards *Fabien CLERC* <https://www.facebook.com/Yieloo-184624595039051/?fref=ts> <https://twitter.com/intraknow> <https://plus.google.com/+Intraknow?hl=fr> fabien.clerc(a)yieloo.com ____________________________________________________________ *Editeur de la solution intra'know* Espace performance 3 - Bâtiment Z - 35769 Saint-Grégoire www.intraknow.com <https://www.intra-know.com/yieloo/admin/cciaux/modif/www.intraknow.com> 02 99 55 15 03

2 1

[Maria-discuss] Clarification about have_ssl and have_openssl variables
by Peter Laursen 11 Feb '18

11 Feb '18

MySQL documentation states https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar… simply states "This variable is an alias for have_ssl.". I checked with a few Oracle/MySQL installations that the two variables have identical values. But this is not the case on MariaDB (I checked my local Windows installs of 10.1 and 10.2). have_openssl is NO - have_ssl is YES|DISABLED. We believe that this is the reason for a newly reported problem to us: SSL-connections is not possibe to MariaDB on Amazon RDS. We verified the problem with a fresh RDS instance with MariaDB 10.2 and running with SSL enabled. The 3 different 'mysql' CLI's give results: *MariaDB 10.2.6 version:* - without ssl, gives 'Access denied error' - with ssl, it gives Error No. 2026: SSl Connection error: Certificate signature check failed *using MySQL 5.7.x version:* it connects to the server irrespective of the ssl parameter passed or not (but we don't know if SSL is actually used. It may silently connect without SSL if SSL is not possible) *MariaDB 10.1.22 version:* without ssl: it gives 'Access denied error' with ssl (Works as expected) Any thoughts on this? What can we do? We are affected as we use MariaDB Connector/C 2.33 currently -- Peter -- Webyog

2 1

[Maria-discuss] MariaDB server 10.1.31 a little question ?
by Ljr Yang 08 Feb '18

08 Feb '18

Hi, There two little qustion in MariaDB 10.1.31, please confirm, thanks. 1) After install MariaDB 10.1.31 , in error log show xtradb version 5.6.36-83.0 ? it should 5.6.38-83.0 2018-02-07 19:07:47 140196300970016 [Note] InnoDB: Percona XtraDB ( http://www.percona.com) 5.6.36-83.0 started; log seque nce number 6162730 2) in the web page , show " Download MariaDB Server 10.2.10" , it should "10.0.34 Galera cluster", https://mariadb.com/resources/blog/mariadb-server-10131-and-mariadb-galera-…

2 1

[Maria-discuss] MariaDB threads optimalization
by Brano Gege 07 Feb '18

07 Feb '18

Hi All, I got problem with mariadb performance, NEW (pcie) server: Intel(R) Xeon(R) CPU E5-2637 v4 @ 3.50GHz, 1TB NVMe disks, 128 GB RAM, installed Debian 4.9.65-3+deb9u1, Ver 15.1 Distrib 10.1.26-MariaDB OLD server: Intel(R) Xeon(R) CPU E5-1630 v3 @ 3.70GHz, SSD disk, 64 GB RAM, FreeBSD 11.0-STABLE, 10.1.21-MariaDB On servers is running just mysql, I copy my.ini file, config files are same. mysql slap results for example employees db: #less /root/slap/select_query.sql SELECT emp_no, first_name, last_name, gender FROM employees LIMIT 10; SELECT emp_no, first_name, last_name, gender FROM employees ORDER BY last_name ASC LIMIT 10; SELECT COUNT(emp_no) FROM employees WHERE last_name = 'Aamodt'; SELECT last_name, COUNT(emp_no) AS num_emp FROM employees GROUP BY last_name ORDER BY num_emp DESC LIMIT 10; SELECT employees.* FROM employees LEFT JOIN dept_emp ON ( dept_emp.emp_no = employees.emp_no ) LEFT JOIN salaries ON ( salaries.emp_no = salaries.emp_no ) WHERE employees.first_name LIKE '%Jo%' AND salaries.from_date > '1993-01-21' AND salaries.to_date < '1998-01-01' LIMIT 0, 100; root@pcie:~/slap# mysqlslap --pre-query="RESET QUERY CACHE;" --create-schema=employees --query="/root/slap/select_query.sql" --iterations=10 --concurrency=1 Average number of seconds to run all queries: 0.459 seconds DB1: Average number of seconds to run all queries: 0.627 seconds root@pcie:~/slap# mysqlslap --pre-query="RESET QUERY CACHE;" --create-schema=employees --query="/root/slap/select_query.sql" --iterations=10 --concurrency=2 Benchmark Average number of seconds to run all queries: 0.473 seconds DB1: Average number of seconds to run all queries: 0.626 seconds root@pcie:~/slap# mysqlslap --pre-query="RESET QUERY CACHE;" --create-schema=employees --query="/root/slap/select_query.sql" --iterations=10 --concurrency=4 Average number of seconds to run all queries: 0.486 seconds DB1: Average number of seconds to run all queries: 0.656 seconds root@pcie:~/slap# mysqlslap --pre-query="RESET QUERY CACHE;" --create-schema=employees --query="/root/slap/select_query.sql" --iterations=10 --concurrency=8 Average number of seconds to run all queries: 0.569 seconds DB1: Average number of seconds to run all queries: 1.136 seconds root@pcie:~/slap# mysqlslap --pre-query="RESET QUERY CACHE;" --create-schema=employees --query="/root/slap/select_query.sql" --iterations=10 --concurrency=16 Benchmark Average number of seconds to run all queries: 0.948 seconds DB1: Average number of seconds to run all queries: 1.750 seconds root@pcie:~/slap# mysqlslap --pre-query="RESET QUERY CACHE;" --create-schema=employees --query="/root/slap/select_query.sql" --iterations=10 --concurrency=32 Average number of seconds to run all queries: 1.650 seconds DB1: Average number of seconds to run all queries: 2.455 seconds root@pcie:~/slap# mysqlslap --pre-query="RESET QUERY CACHE;" --create-schema=employees --query="/root/slap/select_query.sql" --iterations=10 --concurrency=64 Average number of seconds to run all queries: 3.306 seconds DB1: Average number of seconds to run all queries: 3.176 seconds root@pcie:~/slap# mysqlslap --pre-query="RESET QUERY CACHE;" --create-schema=employees --query="/root/slap/select_query.sql" --iterations=10 --concurrency=128 Average number of seconds to run all queries: 6.744 seconds DB1: Average number of seconds to run all queries: 5.737 seconds root@pcie:~/slap# mysqlslap --pre-query="RESET QUERY CACHE;" --create-schema=employees --query="/root/slap/select_query.sql" --iterations=10 --concurrency=256 Average number of seconds to run all queries: 13.474 seconds (verified 2nd run: 12.883 seconds) DB1: Average number of seconds to run all queries: 3.451 seconds (verified 2nd run: 4.935 seconds) root@pcie:~/slap# mysqlslap --pre-query="RESET QUERY CACHE;" --create-schema=employees --query="/root/slap/select_query.sql" --iterations=10 --concurrency=512 Average number of seconds to run all queries: 26.085 seconds (verified 2nd run: 26.307 seconds) DB1: Average number of seconds to run all queries: 15.862 seconds (verified 2nd run: 11.280 seconds) as you can see with raising threads PCIE performance is lowering rapidly. Any idea what to check? Thank you. I post this question couple of days with more information also here: https://serverfault.com/questions/895506/mariadb-threads-optimalization

4 7

[Maria-discuss] Triangular FKs - Cascade delete leaves DB in state with broken referential integrity
by Oliver Schonrock 05 Feb '18

05 Feb '18

I have come across a very strange symptom with triangular FKs (see below) where a cascade delete of the central (member) record leaves the DB in a state with broken referential integrity. The FK structure is a little bit demanding and somewhat "triangular/circular", but has been in operation in our application for many years without problems. After recent upgrade from 10.1 to 10.2.12, we promptly got broken FKs. (I have not yet retested with 10.1). How to reproduce: (example reduced to the bare essentials with 3 tables with 1 record each). SET FOREIGN_KEY_CHECKS=0; CREATE TABLE member ( id int(11) NOT NULL AUTO_INCREMENT, default_address_id int(11) DEFAULT NULL, default_card_id int(11) DEFAULT NULL, PRIMARY KEY (id), KEY member_FI_2 (default_address_id), KEY member_FI_3 (default_card_id), CONSTRAINT member_FK_2 FOREIGN KEY (default_address_id) REFERENCES address (id) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT member_FK_3 FOREIGN KEY (default_card_id) REFERENCES payment_method (id) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB; INSERT INTO member VALUES (1,2,3); CREATE TABLE address ( id int(11) NOT NULL AUTO_INCREMENT, member_id int(11) NOT NULL, PRIMARY KEY (id), KEY address_FI_1 (member_id), CONSTRAINT address_FK_1 FOREIGN KEY (member_id) REFERENCES member (id) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB; INSERT INTO address VALUES (2,1); CREATE TABLE payment_method ( id int(11) NOT NULL AUTO_INCREMENT, member_id int(11) NOT NULL, cardholder_address_id int(11) DEFAULT NULL, PRIMARY KEY (id), KEY payment_method_FI_1 (member_id), KEY payment_method_FI_2 (cardholder_address_id), CONSTRAINT payment_method_FK_1 FOREIGN KEY (member_id) REFERENCES member (id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT payment_method_FK_2 FOREIGN KEY (cardholder_address_id) REFERENCES address (id) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB; INSERT INTO payment_method VALUES (3,1,2); SET FOREIGN_KEY_CHECKS=1; SELECT * FROM member; +----+--------------------+-----------------+ | id | default_address_id | default_card_id | +----+--------------------+-----------------+ | 1 | 2 | 3 | +----+--------------------+-----------------+ SELECT * FROM address; +----+-----------+ | id | member_id | +----+-----------+ | 2 | 1 | +----+-----------+ SELECT * FROM payment_method; +----+-----------+-----------------------+ | id | member_id | cardholder_address_id | +----+-----------+-----------------------+ | 3 | 1 | 2 | +----+-----------+-----------------------+ DELETE FROM member WHERE id = 1; SELECT * FROM member; [ empty ] SELECT * FROM address; [ empty ] SELECT * FROM payment_method; +----+-----------+-----------------------+ | id | member_id | cardholder_address_id | +----+-----------+-----------------------+ | 3 | 1 | NULL | +----+-----------+-----------------------+ ------------ DB is now in an inconsistent state: payment_method.member_id=1 references a non-existent member record. Am I missing something, or should this never happen? Thanks -- Oliver Schönrock

1 2

[Maria-discuss] Aurora 'rds.amazonaws.com' string detection
by Evan Burke 31 Jan '18

31 Jan '18

Hi, I recently resolved an issue with an application using the MariaDB JDBC driver being unable to connect to an Amazon Aurora MySQL-compatible database (single instance, not cluster). This turned out to be caused by using 'dblink.[examplehostname].com' for my Aurora connection string, rather than the ...rds.amazonaws.com string checked for in UrlParser.java - https://github.com/MariaDB/mariadb-connector-j/blob/386819936ffad08d0ac2134… I see the code comment indicating that there are problems with detecting Aurora via other methods, as well as compatibility issues preventing the ability to connect to Aurora without a special case, so to some extent I can understand the decision to use hostname or haMode detection. But I wanted to point out that this approach comes with downsides - particularly when it is not documented anywhere that I can see. We had to review the code itself on Github in order to identify the solution, and that's a problem. While I don't expect my experience to be the same as most users, I can't be the only one using an alternate hostname or an IP address to connect, or the only one making the reasonable assumption that the driver is hostname-agnostic. The other consideration - which I am admittedly making somewhat naively - is that the MySQL JDBC driver is able to connect to this Aurora instance without any problems, regardless of hostname. From the perspective of an end user who doesn't care too much about implementation details, I'm probably going to prefer the option that doesn't exhibit unexpected behavior. In any case - despite the frustrating experience I had - I am grateful to everyone who's contributed to the MariaDB project, and I hope my feedback is helpful. -Evan

1 0

[Maria-discuss] Fwd: mysql_insert_id() for INSERT...SELECT statement
by Yuki . 30 Jan '18

30 Jan '18

Hi, I made a post at https://stackoverflow.com/questions/48306962/mysql- insert-id-for-insert-select-statement, but have not received any helpful answer, may be you could help me. I am using MaridDB but I read MySQL documentation because it has much more elaborated documentation than the same page for MariaDB. I am doing similar INSERT...SELECT query to this INSERT INTO table (value1, value2) SELECT 'stuff for value1', 'stuff for value2' FROM DUAL WHERE NOT EXISTS (SELECT * FROM table WHERE value1='stuff for value1' AND value2='stuff for value2') LIMIT 1 , where table has auto-genrated id. And I would like to know if it was inserted or not, of course. I assume the way to do that is to use `mysql_insert_id()`. It returns 0 if no insertions happen and 1 if insertions happen. Looking more details [here]( https://dev.mysql.com/doc/refman/5.7/en/mysql-insert-id.html) > If an INSERT ... SELECT statement is executed, and **NO** automatically > generated value is successfully inserted, mysql_insert_id() **RETURNS** > the ID of the last inserted row. What does it return if no auto-generated ID was successfully inserted? Is this a doc typo? So far I did testing in C and `mysql_insert_id()` returns always 0 if insertion did not happen even if the last insertion succeeded and `mysql_insert_id()` returned non-zero result. A paragraphs in the same manual, mentioned above, confirms this behavior by saying: > mysql_insert_id() returns 0 if the previous statement does not use an AUTO_INCREMENT value. .... > > The value of mysql_insert_id() is affected only by statements issued within the current client connection. It is not affected by statements issued by other clients. > > The LAST_INSERT_ID() SQL function will contain the value of the first automatically generated value that was successfully inserted. LAST_INSERT_ID() is not reset between statements because the value of that function is maintained in the server. .... And that feels kind of logical otherwise `INSERT...SELECT` would be useless in many cases, if you cannot know within the code if your insertion worked or not. But it totally contradicts to the statement above. Did anyone have experience with this? >From MariaDB manual, also suggests that the value should be zero in case of insertion did not happen: > The mysql_insert_id() function returns the ID generated by a query on > a table with a column having the AUTO_INCREMENT attribute or the value > for the last usage of LAST_INSERT_ID(expr). If the last query wasn't > an INSERT or UPDATE statement or if the modified table does not have a > column with the AUTO_INCREMENT attribute and LAST_INSERT_ID was not > used, this function will return zero. Does `mysql_insert_id()` of MariaDB returns 0 for `INSERT...SELECT` if an insertion did not happen, or it might return some other non-zero value? Do you think it is a typo at MySQL documentation? Best, Yuki

2 3

[Maria-discuss] Replication set up to ignore Delete statements
by Furlong, John 25 Jan '18

25 Jan '18

I am new to MariaDB and am wondering if it's possible to set up replication to only replicate INSERTS & UPDATES? Can Deletes be ignored? The purpose is to keep the primary DB small and the secondary DB would be a data warehouse. Does --binlog-format=STATEMENT mean all writes? I've been reading the documention but haven't been able to find a definitive answer. If Delete statements are executed by a different user is it possible to ignore them that way such as through the CURRENT_USER()<https://mariadb.com/kb/en/current_user/> function? Thanks. John

1 0

[Maria-discuss] ALTER TABLE ENIGNE=InnoDB performance
by Conor Murphy 25 Jan '18

25 Jan '18

Hi, We're looking at changing an existing database from MyISAM to InnoDB. The existing system is using MariaDB 5.5.56 on RHEL 7.4 The plan is to - create a replication slave on the same host - use ALTER TABLE .. ENGINE=InnoDB on the slave, with 4 ALTERs running concurrently - replace the master with the "coverted" slave Doing this with a small database (~ 3.5GB) works okay with the largest table taking ~ 7 minutes to convert. However, while trying to figure out how to replicate from the new master, we found that we need "FLUSH TABLES .. FOR EXPORT" which isn't available in MariaDB 5.5. So we updated to MariaDB 10.2.12 and started again. Now when we run the "ALTER TABLE .. ENIGNE=InnoDB", it takes hours from the ALTERs to complete and we're getting the following log entries 2018-01-09 12:36:03 140132036818688 [ERROR] InnoDB: Cannot save table statistics for table `statsdb`.`#sql-6d1a_12#P#P20160101` /* Partition `P20160101` */: Lock wait timeout 2018-01-09 12:36:54 140132036515584 [ERROR] InnoDB: Cannot save table statistics for table `statsdb`.`#sql-6d1a_13#P#P20160101` /* Partition `P20160101` */: Lock wait timeout 2018-01-09 12:37:45 140132036818688 [ERROR] InnoDB: Cannot save table statistics for table `statsdb`.`#sql-6d1a_12#P#P20160601` /* Partition `P20160601` */: Lock wait timeout 2018-01-09 12:38:36 140132036818688 [ERROR] InnoDB: Cannot save table statistics for table `statsdb`.`#sql-6d1a_12#P#P20160701` /* Partition `P20160701` */: Lock wait timeout 2018-01-09 12:39:27 140132037728000 [ERROR] InnoDB: Cannot save table statistics for table `statsdb`.`#sql-6d1a_11#P#P20160701` /* Partition `P20160701` */: Lock wait timeout ... Any ideas on what's wrong here? Thanks, Conor

3 8

[Maria-discuss] MariaDB 10.3.4 consumes extremely much CPU on Windows.
by Peter Laursen 21 Jan '18

21 Jan '18

On a 4-core (4 physical, 8 logical cores), 3.5 Ghz box, MariaDB 10.3.4 consumes typically 35-40% of available CPU even when completely idle according to Task Manager. Please see image. I cannot tell if previous 10.3 versions also did, as I don't have 10.3 running constantly in the backgorund. I just observed this now. This does not happen with MariaDB 10.1, MariaDB 10.2, MySQL 5.6, MySQL 5.7 and MySQL 8.0 (all those I have starting with Windows on this box), where the CPU-load is neglible unless the server is "doing real work". As a result, the CPU clock frequency is always highest possible 3.5 Ghz (this CPU model is a 4th generation Intel with the option to scale down CPU frequency to around 40-50% of max. when there is no need for more) when MariaDB 10.3.4 is running. -- Peter -- Webyog

2 7

[Maria-discuss] OpenLDAP & PAM authentication
by Adam Balgach 19 Jan '18

19 Jan '18

Hello – I am having an issue configuring openLDAP to authenticate users on an instance in RHEL (CentOS 7) MariaDB server configured with plugin-load=auth_pam.so in my /etc/pam.d/mysql: auth required pam_ldap.so account required pam_ldap.so when I try and access the server from either the localhost, or any server inside my internal network, I see the LDAP authentication happen without issue and login is fine. When I try and access the server from outside the network, on the mariadb server in /var/log/secure I see the following: Jan 19 08:32:35 mysqld: pam_ldap(mysql:auth): unexpected response from failed conversation function Jan 19 08:32:35 mysqld: pam_ldap(mysql:auth): conversation failed Jan 19 08:32:35 mysqld: pam_ldap(mysql:auth): failed to get password: Authentication token manipulation error And in my client (Cygwin) I get the following error: ERROR 2059 (HY000): Authentication plugin 'mysql_clear_password' cannot be loaded: No such file or directory However I see this plugin in the /usr/lib64/mysql/plugin directory Any idea what is going wrong with remote logins? Thanks-

2 1

[Maria-discuss] MariaDB 10.3.4 installation blocked ny MS "Windows Defender" malware protection
by Peter Laursen 19 Jan '18

19 Jan '18

Please see image. (you can clik "more info" adn the option to "install anyway" will appear. Did you forget to sign the installer this time or has some certificate expired? -- Peter -- Webog

2 5

Re: [Maria-discuss] Parallel Databases and network security
by Reindl Harald 16 Jan '18

16 Jan '18

Am 16.01.2018 um 05:10 schrieb Jan Steinman: >> On 2018-01-15, at 17:15, Reindl Harald <h.reindl(a)thelounge.net> wrote: >> >> Am 16.01.2018 um 01:58 schrieb Jan Steinman: >>>> On 2018-01-15, at 16:37, Ruben Safir <ruben(a)mrbrklyn.com> wrote: >>>> >>>> Because that is how I want it. The longer explanation is, because that >>>> is how I want to do it, period. >>> You have the freedom to be foolish. And I have the freedom to not help you be foolish >> >> forget it - that fool obviously never wants answers to his questions nor tries to understand what people tell him > > He doesn’t understand how TCP/IP and routed works, either: “I'd like it to only listen on a specific interface altogether.” > > That’s okay. It’s been cheap entertainment for me! :-) :-) however, it's heartwarming that someone who don't want anserws from humans types his questions not in a search engine like https://www.google.at/search?q=mysql+listen gicen that the first hit is not too bad... https://www.howtogeek.com/howto/mysql/switch-mysql-to-listen-on-tcp/

3 8

[Maria-discuss] Parallel Databases and network security
by Ruben Safir 16 Jan '18

16 Jan '18

Is there a way to hot copy a database from one machine to another and restrict network access to only between those two machines without using a firewall? Ruben -- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and and extermination camps, but incompatible with living as a free human being. -RI Safir 2013

3 6

Re: [Maria-discuss] Parallel Databases and network security
by Reindl Harald 16 Jan '18

16 Jan '18

Am 16.01.2018 um 01:58 schrieb Jan Steinman: >> On 2018-01-15, at 16:37, Ruben Safir <ruben(a)mrbrklyn.com> wrote: >> >> Because that is how I want it. The longer explanation is, because that >> is how I want to do it, period. > > You have the freedom to be foolish. And I have the freedom to not help you be foolish forget it - that fool obviously never wants answers to his questions nor tries to understand what people tell him - leaves the questions why someone is aksing at all isntead just RTFM in silent in the thread below i did not say anything about that he should use systemd but how systemd does create the folder and why it should go to a subfolder and why that subfolder needs to created at every boot before try to start mysqld and his best answer was "I've seen already far too many security breakins of systemd" which i call a uneducated lie based on FUD https://www.mail-archive.com/maria-discuss@lists.launchpad.net/msg04760.html

1 0

[Maria-discuss] Submitting talks for Percona Live Santa Clara?
by Colin Charles 09 Jan '18

09 Jan '18

Hi all, As part of the program committee, I’m writing in to say we’ve seen only a handful of talks mention MariaDB Server out of the several hundred submissions so far. With all the amazing use cases of MariaDB Server out there, I would expect a lot more. The CFP ends January 12 2018, so please feel free to get ideas and submissions in: https://www.percona.com/live/18/ Kind Regards, Colin Charles -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

3 2

[Maria-discuss] Problem with bit operations in certain expressions
by Mats Eklund 09 Jan '18

09 Jan '18

Hi, Need some help here. I have the following expression: SELECT IF(1=1, 0x2, 0x4) | 0x1 which in MySQL evaluates to: 3 but in MariaDB it evaluates to: 1 MySQL's result seems correct to me. Would appreciate any advice on this. Many thanks! Mats

3 2

[Maria-discuss] mariadb-connector-c mariadb_config: Faulty output with static gssapi plugin
by Stefan Scherfke 08 Jan '18

08 Jan '18

Hi all, the output of "mariadb_config --libs[_r]" is faulty if the AUTH_GSSAPI plugin is configured as static: I built mariadb-connector-c 3.0.2 on Fedora 26 with this command: mkdir build cd build cmake -DAUTH_GSSAPI=STATIC .. make The output of "mariadb_config" then looks like this: $ mariadb_config/mariadb_config --libs_r -L/usr/local/lib/mariadb/ -lmariadb -lpthread -ldl -lm -lssl -lcrypto -l-lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err All libs should be named like "-l<name>" but gssapi_krb5 has a double "-l-l" prefix. This problems becomes more apparent when I build mariadb-connector-c as a Python Conda package. Without the "AUTH_GSSAPI=STATIC" flag, I get the following libs: -L/opt/emsconda/conda-bld/mariadb-connector-c/env/lib/ -lmariadb -lpthread -ldl -lm -lssl -lcrypto With the "AUTH_GSSAPI=STATIC" flag, I get the following libs: -L/opt/emsconda/conda-bld/mariadb-connector-c/env/lib/ -lmariadb -lpthread -ldl -lm -lssl -lcrypto -l-L/opt/emsconda/conda-bld/mariadb-connector-c/envplaceho/lib -Wl,--enable-new-dtags -Wl,-rpath -Wl,/opt/emsconda/conda-bld/mariadb-connector-c/envplaceho/lib -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err The problematic part there is the "-l-L/opt/emsconda/.../lib" part which confuses other tools like Mydumper when they are compiled against mariadb-connector-c. Is this an issue with mariadb-connector-c or can I fix it in my build process somehow? Cheers, Stefan

2 2

[Maria-discuss] Fwd: [MariaDB Announce] MariaDB 10.2.12 now available
by Reindl Harald 04 Jan '18

04 Jan '18

and once again a update don't build with the same rpm-spec as before - frankly how often should i offer that someone sends out a mail to the ML with a link to a proposed release tarball to get such things fixed *before* release? + cmake . -DFEATURE_SET=large -DCMAKE_INSTALL_PREFIX=/usr -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_LAYOUT=RPM -DDAEMON_NAME=mysqld -DDAEMON_NO_PREFIX=mysqld -DNICE_PROJECT_NAME=MariaDB -DINSTALL_LIBDIR=lib64/mysql -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql-test -DINSTALL_PLUGINDIR=lib64/mysql/plugin -DINSTALL_SBINDIR=libexec -DINSTALL_SCRIPTDIR=bin -DINSTALL_SQLBENCHDIR= -DINSTALL_SUPPORTFILESDIR=share/mysql -DMYSQL_DATADIR=/var/lib/mysql -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DENABLED_PROFILING=OFF -DENABLE_DEBUG_SYNC=OFF -DENABLE_DTRACE=OFF -DPLUGIN_ARIA=YES -DPLUGIN_CSV=YES -DPLUGIN_MYISAM=YES -DPLUGIN_ARCHIVE=NO -DPLUGIN_BLACKHOLE=NO -DPLUGIN_CASSANDRA=NO -DPLUGIN_CONNECT=NO -DPLUGIN_EXAMPLE=NO -DPLUGIN_FEDERATED=NO -DPLUGIN_FEDERATEDX=NO -DPLUGIN_FEEDBACK=NO -DPLUGIN_MROONGA=NO -DPLUGIN_MYISAMMRG=NO -DPLUGIN_OQGRAPH=NO -DPLUGIN_PARTITION=NO -DPLUGIN_PERFSCHEMA=NO -DPLUGIN_ROCKSDB=NO -DPLUGIN_SEMISYNC=NO -DPLUGIN_SEQUENCE=NO -DPLUGIN_SPHINX=NO -DPLUGIN_SPIDER=NO -DPLUGIN_TOKUDB=NO -DPLUGIN_XTRADB=NO -DWITHOUT_DYNAMIC_PLUGINS=ON -DWITH_ATOMIC_OPS=smp -DWITH_EMBEDDED_SERVER=OFF -DWITH_INNODB_DISALLOW_WRITES=OFF -DWITH_INNODB_BZIP2=OFF -DWITH_INNODB_LZ4=OFF -DWITH_INNODB_LZMA=OFF -DWITH_INNODB_LZO=OFF -DWITH_INNODB_SNAPPY=OFF -DWITH_MYSQLCOMPAT=ON -DSECURITY_HARDENED=OFF -DWITH_LIBARCHIVE=OFF -DWITH_LIBWRAP=OFF -DWITH_MARIABACKUP=OFF -DWITH_PIC=NO -DWITH_READLINE=OFF -DWITH_SAFEMALLOC=OFF -DWITH_VALGRIND=OFF -DWITH_WSREP=OFF -DWITH_JEMALLOC=OFF -DWITH_SSL=system -DWITH_ZLIB=system -DCOMPILATION_COMMENT=thelounge [ 99%] Built target sql Scanning dependencies of target explain_filename-t Scanning dependencies of target mysqld [ 99%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o [100%] Linking CXX executable mysqld [100%] Building CXX object unittest/sql/CMakeFiles/explain_filename-t.dir/explain_filename-t.cc.o [100%] Linking CXX executable explain_filename-t libsql.a(sql_yacc.cc.o): In function .`MYSQLparse.(/THD.*.)/'sql:/ libsql.a/(homesql_yacc.cc.o/)buildbot:/ Ingit /functionsql /`sql_yacc.yyMYSQLparse(:THD*5211):' :undefined /referencehome /tobuildbot /`gitpartition_info/sql:/:sql_yacc.yyerror_if_requires_values:5211(: )undefined referenceconst 'to `partition_info::error_if_requires_values() const' collect2: error: ld returned 1 exit status collect2: error: ld returned 1 exit status make[2]: *** [sql/CMakeFiles/mysqld.dir/build.make:115: sql/mysqld] Error 1 make[2]: *** [unittest/sql/CMakeFiles/explain_filename-t.dir/build.make:116: unittest/sql/explain_filename-t] Error 1 make[1]: *** [CMakeFiles/Makefile2:8464: sql/CMakeFiles/mysqld.dir/all] Error 2 make[1]: *** Waiting for unfinished jobs.... make[1]: *** [CMakeFiles/Makefile2:1336: unittest/sql/CMakeFiles/explain_filename-t.dir/all] Error 2 -------- Weitergeleitete Nachricht -------- Betreff: [MariaDB Announce] MariaDB 10.2.12 now available Datum: Thu, 4 Jan 2018 19:20:40 +0200 Von: MariaDB Announce List <announce(a)mariadb.org> An: announce(a)mariadb.org The MariaDB project is pleased to announce the availability of MariaDB 10.2.12, the latest stable release in the MariaDB 10.2 series. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.12 - Release Notes: https://mariadb.com/kb/en/mdb-10212-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10212-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.12 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - 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://jira.mariadb.org - - 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/mariadbfdn Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Is this normal behaviour?
by Karthick Subramanian 04 Jan '18

04 Jan '18

All, When I tried to connect in centos 7 mariadb 10.2.11 server using root user, by mistake I gave wrong user name, but it connected successfully. I am not sure why. When I check show databases, it didnt list all DBs, but when I connect with root again, I can see all valid Dbs. Is this normal that even if I give wrong user, it authenticate into DB server from root. [root@ipaddr ~]# mysql -u rot Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 22 Server version: 10.2.11-MariaDB MariaDB Server Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | test | +--------------------+ 2 rows in set (0.00 sec) MariaDB [(none)]> exit Bye [root@ipaddr~]# mysql -u root Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 24 Server version: 10.2.11-MariaDB MariaDB Server Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | mydb01 | | information_schema | | mydb02 | | mysql | | performance_schema | | test | +--------------------+ 6 rows in set (0.00 sec)

4 4

[Maria-discuss] Replication Upgrade Strategy MySQL 5.6 to MariaDB 10.2
by Michael Caplan 29 Dec '17

29 Dec '17

Hello, Am hoping to get some feedback on an upgrade strategy to go from MySQL 5.6 (two separate servers, one replication slave) to MariaDB 10.2 (installed on new servers). I'm looking at an rsync process to seed the two new instances on MariaDB, and am unsure if this is sound (https://www.stephenrlang.com/2016/08/setting-up-mysql-master-slave-replicat…) Roughly, the process would look like this: - rsync data from MySQL 5.6 Master to MariaDB 10.2 Slave - Lock master - Get master status - Refresh rsync - Remove lock - Run upgrade process on MariaDB 10.2 Slave. - Change MASTER.... on MariaDB 10.2 Slave - Create second MariaDB 10.2 Slave from first MariaDB 10.2 Slave - Promote MariaDB 10.2 Slave to Master (redirect all DB traffic at this point) - Redirect other MariaDB 10.2 Slave to new Master - Shutdown MySQL 5.6 servers. What I'm most concerned about is the viability of rsync as a method to seed the new MariaDB server from MySQL 5.6. I've come across some chatter that there are risks using rsync instead of a proper dump and restore. Can anyone comment on this? Thanks, Mike

2 3

[Maria-discuss] WSREP: BF lock wait long
by Jesus 22 Dec '17

22 Dec '17

Hi I'm getting this message almost daily or even more and I must restart the server that generates it: WSREP: BF lock wait long How can I solve this? Thanks for your help

2 3

Re: [Maria-discuss] About data encryption
by Sergei Golubchik 15 Dec '17

15 Dec '17

Hi, Cesar! On Dec 15, Cesar Hernandez wrote: > > Thanks Sergei! > > So the database is encrypted by using AES-128-CBC or AES-128-CRT, right? > Can I use AES-256-CBC? No. Each tablespace is encrypted with a different per-tablespace key. This key is 128 bit. It's generated by encrypting a random 128-bit nonce with the user-specified key. So, if you specify a 256-bit key in the file_key_manager plugin, this 256-bit key will be used to generate the 128-bit tablespace key. The tablespace itself will be encrypted using the 128-bit key. Regards, Sergei Chief Architect MariaDB and security(a)mariadb.org

1 0

[Maria-discuss] About data encryption
by Cesar Hernandez 14 Dec '17

14 Dec '17

Hi Can someone tell me which algorithm uses MariaDB when using table encryption? Looking at https://mariadb.com/kb/en/library/data-at-rest-encryption/ <https://mariadb.com/kb/en/library/data-at-rest-encryption/> Seems to talk only about encryption of the key file, but not on the database data. I've been looking for a while and haven't found complete documentation about it. I've even taken a look at the MariaDB source code, in the file /storage/innobase/fil/fil0crypt.cc <http://fil0crypt.cc/> Seems the encryption is done by AES algorithm, but I'm not sure, and I don't know the key size neither the mode of operation. Thanks Cesar

2 1

[Maria-discuss] Debian 9.2 - Kytea
by Guillermo Cespedes 30 Nov '17

30 Nov '17

Hi, I'm compiling MariaDb in Debian 9.2. Is dependence on Kytea necessary? I need to compile Kytea previously. As you know, the Kytea package is no longer available in the Debian repositories. http://www.phontron.com/kytea/ <http://www.phontron.com/kytea/> https://github.com/dertin/lemp-stack-debian/blob/develop/install.sh#L105 <https://github.com/dertin/lemp-stack-debian/blob/develop/install.sh#L105> regards Guillermo Céspedes Full Stack Developer

3 2

[Maria-discuss] Mariadb-10.2.11 missing tokudb rpm
by Reinis Rozitis 29 Nov '17

29 Nov '17

Hi, the mariadb-10.2.11 release (all distros) is missing *-tokudb-engine.rpm package. Is this a build/packaging error or something more (though nothing in the Release notes)? rr

2 1

[Maria-discuss] MariaDB 10.2 now available on CentOS 6 &7 via SCL !!
by Michal Schorm 29 Nov '17

29 Nov '17

Hello everybody, In case you missed it, I just want to share an announce of availability of MariaDB 10.2 on CentOS 6 & 7 as a Software collections. Here are the announce emails from CentOS mailing list, which contains most basic howto: https://lists.centos.org/pipermail/centos-announce/2017-November/022640.html https://lists.centos.org/pipermail/centos-announce/2017-November/022642.html -- This made MariaDB 10.2 a big step closer to a new mass of users, because the standard MDB version in CentOS & RHEL is 5.5. It took quite an effort to fine-tune and perk-up the MDB 10.2 since its first attemps in Fedora, however it is always pleasure to cooperate with developers like you :) -- Michal Schorm Associate Software Engineer Core Services - Databases Team Red Hat

1 0

[Maria-discuss] installing mariadb using rpm
by Mark Edwards 28 Nov '17

28 Nov '17

hello - i was following an earlier thread titled: [Maria-discuss] Install MariaDB repo official Centos-7 this is the first time i have attempted an RPM install. so i decided to try it myself, using 10.2 on a new Centos7 installation created in google-console. the installation went perfectly, but now i have a question. i let mariadb generate my repo using this link: https://downloads.mariadb.org/mariadb/repositories/#mirror=jaleco&distro=Ce… and the following repo was generated: # MariaDB 10.2 CentOS repository list - created 2017-11-28 17:28 UTC # http://downloads.mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.2/centos7-amd64 gpgkey= https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 my question: when i cat /proc/cpuinfo, i see the following: vendor_id : GenuineIntel model name : Intel(R) Xeon(R) CPU @ 2.30GHz and yet the repo specifies "centos7-amd64". does it matter that amd64 is being specified rather than Intel? Thank you, Mark Edwards

2 2

[Maria-discuss] Install MariaDB repo official Centos-7
by Wilmer Arambula 28 Nov '17

28 Nov '17

Hi, install MariaDB from the official repository [mariadb.org] for Centos-7: 1.- yum install MariaDB-server MariaDB-client When executing: 2.- systemctl start mariadb.service Error: Failed to start mariadb.service: Unit not found. Thks,

4 4

[Maria-discuss] MariaDB won't start after updating Fedora 26 to Fedora 27
by Bill Damage 23 Nov '17

23 Nov '17

After checking the logs I see mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2 "No such file or directory")If I manually create this dir I can then start it ... until the next reboot. What is the correct fix to ensure its works as it did before the update please?

3 4

[Maria-discuss] ALTER TABLE removes check constraint
by Peter Laursen 22 Nov '17

22 Nov '17

Test case: CREATE TABLE checks (a INT CHECK (a>2), b INT CHECK (b>2), CONSTRAINT a_greater CHECK (a>b)); SHOW CREATE TABLE checks; ALTER TABLE `test`.`checks` CHANGE `a` `a` INT(11) NULL; SHOW CREATE TABLE checks; /' -- and now one constraint is gone! CREATE TABLE `checks` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL CHECK (`b` > 2), CONSTRAINT `a_greater` CHECK (`a` > `b`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 */ This docs page https://mariadb.com/kb/en/library/constraint/ does not say that (unnamed) CHECK constraints (ie. defined "column-wise") may be removed like this. In this case the ALTER changes one column to what it already was and still the CONSTRAINT is removed. A more realistic scenario is that someone has an INT column that is about to overflow and wants to change it to a BIGINT. I am not sure if this is an oversight/a bug or not. But if it is not, I think the docs page should clearly state that "an unnamed CHECK constraint is droppped implicitly when an ALTER TABLE statement is executed and this ALTER TABLE statement references the particular column and the ALTER TABLE statement does not recreate the CONSTRAINT". There will be other cases where such ALTER TABLE would violate the CONSTRAINT due to already existing data. Wasn't it better if the ALTER TABLE failed then, rather than dropping the CONSTRAINT? What do standards say? How do other RDBMS behave with this? Does somebody know more about this? What say? -- Peter -- Webyog

3 5

[Maria-discuss] innodb and corrupted tables
by Federico Razzoli 20 Nov '17

20 Nov '17

I just noticed this old MySQL bug:https://bugs.mysql.com/bug.php?id=10132 In the comments (2005 to 2014) everyone seems to agree that current behaviour should be treated as a bug.The main commenter now works for MariaDB.What is currently your opinion? Will this behaviour change at some point? If so, what will be the consequences for Galera? Federico

3 3

[Maria-discuss] MariaDB GUI: BSL 1.1 - Debate
by Juan Telleria 19 Nov '17

19 Nov '17

Dear MariaDb Developers, I am writing because I would like to open a debate whether if MariaDB, now that has gained investment from Microsoft, Alibaba, and the European Union, shall create its own SQL Graphical User Interface, as good as (or better than) MySQL Workbench. I agree that MariaDB includes by default HeidiSQL in its Windows builds, but in my opinion, if MariaDB really wants to look Oracle's MySQL face to face, HeidiSQL is not nearly as good as MySQL Workbench. If this wants to be done: 1st) The brand new GUI shall have a Business Source Licence v1.1, which only companies which invest in MariaDB would be able to use. 2nd) In 3 years now, MariaDB would be better positioned and have a fully Open Source GUI which would allow MariaDB to look face to face to Oracle. 3rd) And in 4/5 years now, MariaDB Corporation shall be brave enough to to continue Developing this GUI as a truly open source product, without the BSL, and adopting a purely GPLv2 with incremental improvements, distributing it through the MariaDB Foundation Webpage, as individuals or other companies apart from MariaDB Corporation, will not support the product if it is not totally Open Source. So BSL v1.1 might prove useful to launch the project, but with time, it shall have a GPLv2 for gaining investment from third companies. ¿What do you thing on the topic? Thank you all, Juan Telleria

1 1

[Maria-discuss] MariaDB upgrade 10.1 to 10.2 CentOS7
by Karthick Subramanian 13 Nov '17

13 Nov '17

All, Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to login to root user as shown below: mysql -u root I got the error - unix_socket not loaded. I noticed that the unix_socket authentication is required after the upgrade for root login from localhost. Can anyone confirm whether this is part of the feature after upgrades. In my previous version: select user, plugin from mysql.user; +-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | | ------------------------------------ After upgrade: select user, plugin from mysql.user; +-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | unix_socket | --------------------------------------- Regards, Karthick

3 9

[Maria-discuss] RPM CMake build arguments - Fedora
by Michal Schorm 13 Nov '17

13 Nov '17

Hello everybody, I want to update Fedora SPECfile to the latest best practise. This time, I want to fix CMake arguments. As the time flown, we were adding more and more arguments and for many of them, I'm not sure of their correct values. Are they (the values) ON/OFF? ON/NO? ... I already - incorrectly - filed it as a JIRA issue, but it is nicely formated, so I'd recomment to read it through. https://jira.mariadb.org/browse/MDEV-14344 You can reply to both mail and JIRA, I guess, I'll check them both. -- I'll be glad for any advice on how the values should look like, because reading through the Cmake files is kinda hard and slow for me. -- Michal Schorm Associate Software Engineer Core Services - Databases Team Red Hat

3 4

[Maria-discuss] Contributing my ideas with Mariadb
by Rajat Rawat 11 Nov '17

11 Nov '17

Respected Sir/Mam Hello, Myself Rajat from India. I wanted to contribute/work with Mariadb. As we know that Mariadb dosen’t have cascade truncate function available yet, so I want to contribute to Mariadb towards this topic. My topic is “Cascade Truncate”. Since we can’t truncate the parent table unless the referential integrity constraints are present in the child table also. Hence, we can do a way that we can provide a command that truncate the child table as well. This enhancement is already provided in the Oracle Database in their 12c Version, by using the truncate cascade command. It is better to truncate the child table at the time when we want to truncate our parent table. As we know that we have already on Delete Cascade command available, but that command works only row by row and not for all rows at one time. So, at one time if we want to truncate our whole table then Cascade Truncate is a better Option. That’s all about my proposal. If you like my proposal, then let me know about about it. I am very eager to contribute for you. I also forked and downloaded on my local machine, the file of Maraidb which is available on Github, and currently I am reading/understanding all the patches, but I am confused with only 1 thing that from where should I start. So, if you like proposal then let me know about it and please guide me that from where should I start contributing for it. My skills: C, C++, Java, SQL, PL/SQL Achievement: Oracle Certified Associate Java Programmer SE 7. By contributing for you I will definitely learn many new things and implement my ideas, while working with you. Hope I could be of any help for you. Your sincerely Rajat

2 1

[Maria-discuss] slow_query_log: Binlog Dump
by Reindl Harald 05 Nov '17

05 Nov '17

these entries are *not* helpful when you need to seek for real queryies like a needle SET timestamp=1509853561; # administrator command: Binlog Dump; # Time: 171105 4:47:04 # User@Host: replication[replication] @ [192.168.196.106] # Thread_id: 415842 Schema: QC_hit: No # Query_time: 62.807846 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 # Rows_affected: 0 SET timestamp=1509853624; # administrator command: Binlog Dump; # Time: 171105 4:49:04 # User@Host: replication[replication] @ [192.168.196.106] # Thread_id: 415899 Schema: QC_hit: No # Query_time: 120.228237 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 # Rows_affected: 0 SET timestamp=1509853744; # administrator command: Binlog Dump; # Time: 171105 4:51:01 # User@Host: replication[replication] @ [192.168.196.106] # Thread_id: 416036 Schema: QC_hit: No # Query_time: 117.412204 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 # Rows_affected: 0 SET timestamp=1509853861; # administrator command: Binlog Dump; # Time: 171105 4:52:01 # User@Host: replication[replication] @ [192.168.196.106] # Thread_id: 416184 Schema: QC_hit: No # Query_time: 60.132083 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 # Rows_affected: 0 SET timestamp=1509853921; # administrator command: Binlog Dump; # Time: 171105 4:56:01 # User@Host: replication[replication] @ [192.168.196.106] # Thread_id: 416257 Schema: QC_hit: No # Query_time: 240.021180 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 # Rows_affected: 0 SET timestamp=1509854161; # administrator command: Binlog Dump; # Time: 171105 4:58:08 # User@Host: replication[replication] @ [192.168.196.106] # Thread_id: 416567 Schema: QC_hit: No # Query_time: 127.012674 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 # Rows_affected: 0 SET timestamp=1509854288; # administrator command: Binlog Dump;

1 0

[Maria-discuss] Question on building 10.1.26 binary from sources
by Prasad Rallapalli 03 Nov '17

03 Nov '17

Hi, I am trying to build 10.1.26 from mariadb sources and compare the performance with the release binary for the same query on the same database. cmake using -DBUILD_CONFIG=mysql_release resulted in a "jemalloc not found" error. So, I did a cmake without any parameters and the build was successful. The binary which i built has a performance drop of 20-30% for the queries, compared to that of the released binary, for the same queries. I compared both the mysqld binaries. The release binary seems to be accessing jemalloc functions and the mysqld binary which i built do not have these functions. I am building this on Centos 6.8. Any help or pointers will be appreciated. Regards Prasad

3 3

[Maria-discuss] Building 10.2 from source issues
by Guillaume Lefranc 02 Nov '17

02 Nov '17

Hi, I am trying to build 10.2 from sources while disabling some plugins (building with all plugins works without issues). e.g. $ cmake . -DPLUGIN_MROONGA=NO -DPLUGIN_TOKUDB=NO -DPLUGIN_SPHINX=NO -DPLUGIN_ROCKSDB=NO $ make This fails with the following errors: [ 98%] Building CXX object extra/mariabackup/CMakeFiles/mariabackup.dir/changed_page_bitmap.cc.o In file included from /home/tanj/mariadb-10.2/storage/innobase/include/univ.i:83:0, from /home/tanj/mariadb-10.2/storage/innobase/include/ut0rbt.h:29, from /home/tanj/mariadb-10.2/extra/mariabackup/changed_page_bitmap.h:28, from /home/tanj/mariadb-10.2/extra/mariabackup/changed_page_bitmap.cc:25: /home/tanj/mariadb-10.2/extra/mariabackup/common.h: In function ‘size_t xb_read_full(File, uchar*, size_t)’: /home/tanj/mariadb-10.2/extra/mariabackup/common.h:162:45: error: ‘MY_WME’ was not declared in this scope tbytes = my_read(fd, buf, len - tlen, MYF(MY_WME)); ^ /home/tanj/mariadb-10.2/include/my_global.h:1025:24: note: in definition of macro ‘MYF’ #define MYF(v) (myf) (v) ^ In file included from /home/tanj/mariadb-10.2/extra/mariabackup/changed_page_bitmap.cc:27:0: /home/tanj/mariadb-10.2/extra/mariabackup/common.h:162:12: error: ‘my_read’ was not declared in this scope tbytes = my_read(fd, buf, len - tlen, MYF(MY_WME)); ^~~~~~~ /home/tanj/mariadb-10.2/extra/mariabackup/common.h:162:12: note: suggested alternative: ‘my_sha1’ tbytes = my_read(fd, buf, len - tlen, MYF(MY_WME)); ^~~~~~~ my_sha1 /home/tanj/mariadb-10.2/extra/mariabackup/common.h:163:32: error: ‘MY_FILE_ERROR’ was not declared in this scope if (tbytes == 0 || tbytes == MY_FILE_ERROR) { ^~~~~~~~~~~~~ /home/tanj/mariadb-10.2/extra/mariabackup/common.h:163:32: note: suggested alternative: ‘DB_IO_ERROR’ if (tbytes == 0 || tbytes == MY_FILE_ERROR) { ^~~~~~~~~~~~~ DB_IO_ERROR make[2]: *** [extra/mariabackup/CMakeFiles/mariabackup.dir/build.make:111: extra/mariabackup/CMakeFiles/mariabackup.dir/changed_page_bitmap.cc.o] Error 1 make[2]: *** Waiting for unfinished jobs.... make[1]: *** [CMakeFiles/Makefile2:4270: extra/mariabackup/CMakeFiles/mariabackup.dir/all] Error 2 make[1]: *** Waiting for unfinished jobs.... [ 98%] Built target mysqld [ 98%] Built target explain_filename-t make: *** [Makefile:163: all] Error 2 $ gcc -v Using built-in specs. COLLECT_GCC=gcc COLLECT_LTO_WRAPPER=/usr/lib/gcc/x86_64-pc-linux-gnu/7.2.0/lto-wrapper Target: x86_64-pc-linux-gnu Configured with: /build/gcc-multilib/src/gcc/configure --prefix=/usr --libdir=/usr/lib --libexecdir=/usr/lib --mandir=/usr/share/man --infodir=/usr/share/info --with-bugurl=https://bugs.archlinux.org/ --enable-languages=c,c++,ada,fortran,go,lto,objc,obj-c++ --enable-shared --enable-threads=posix --enable-libmpx --with-system-zlib --with-isl --enable-__cxa_atexit --disable-libunwind-exceptions --enable-clocale=gnu --disable-libstdcxx-pch --disable-libssp --enable-gnu-unique-object --enable-linker-build-id --enable-lto --enable-plugin --enable-install-libiberty --with-linker-hash-style=gnu --enable-gnu-indirect-function --enable-multilib --disable-werror --enable-checking=release --enable-default-pie --enable-default-ssp Thread model: posix gcc version 7.2.0 (GCC) Please advise. Thanks

2 5

[Maria-discuss] Async replication between two Galera clusters, GTIDs on non slave node in "slave cluster" don't match
by Warner, Paul 02 Nov '17

02 Nov '17

Hi! I have two Galera clusters of three nodes each, let's call them cluster A and cluster B. Cluster B has one member set up as a slave to one of the members in cluster A. The cluster B member that runs the slave protocol shows it's GTID matches that of the nodes in cluster A, but the other two nodes in cluster B (not running slaves themselves, but in the cluster with the node running as a slave) have GTIDs that are always 4 behind the other nodes. So just to lay it out again: A0 5-24-5 - master A1 5-24-5 A2 5-24-5 B0 5-24-5 - slave to A0 B1 5-24-1 B2 5-24-1 The GTIDS stay 4 apart, and replication seems fine. I add rows on any A cluster node and they show up in all three B nodes. The GTID on the node running slave stays in sync with the A cluster. The A0 cluster is set up using xtrabackupv2 for SST. The A cluster is completely up before doing anything on the B cluster. The B cluster is started like: 1. Start B0 as first node in the Galera cluster 2. mysqldump from A0 to B0 with --gtid. <https://gist.github.com/warnerpr/011cabb876600c33e5bee42d7d0b17d2> https://gist.github.com/warnerpr/011cabb876600c33e5bee42d7d0b17d2 3. Master of B0 is set to A0 4. Slave is started on B0 5. B1 and B2 are started and set to join the existing cluster. Cluster A and B have log_slave_updates = ON. Details: B0 Slave - https://gist.github.com/warnerpr/59c287bb201302961742bb89d5035559 B1 - https://gist.github.com/warnerpr/0fb8825e49bce72761e0bdd95b0512d9 A1 Master - https://gist.github.com/warnerpr/91e0df1eb04f425baca3675335639c0f Any pointers are greatly appreciated! Paul

2 1

[Maria-discuss] Current Kernel/Distro with best support for performance/stability for VMs (HyperV)
by Alexandre hadjinlian guerra 01 Nov '17

01 Nov '17

Hi I've been looking for improvements in block device handling / XFS filesystem on linux kernel and it looks like that on Kernel 4.11 there is some interesting improvements Im looking to settle on a newer distro/kernel which supports MariaDB 10.2 and ColumnStore and have a long term support. its a new deployment Thanks

1 0

[Maria-discuss] MariaDB 10.2 'show engine innodb status' format change for Pending AIO
by Jonathan Nicol 31 Oct '17

31 Oct '17

Hi, Starting with 10.2, in 'show engine innodb status', the format has changed for pending reads/writes... The old (pre-5.5) format looked like: Pending normal aio reads: 0, aio writes: 0, In 5.5 it switched to: Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , (where each value in the brackets corresponds to a read or write thread) Now in 10.2 it looks like: Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , I was never clear on what the values outsides the brackets in 5.5-10.1 represented... assumed it was a total of all threads. We were previously monitoring this value, should we move forward monitoring a sum of all threads? It seems a little odd to remove a useful metric from the status output. thanks Jon

1 0

Re: [Maria-discuss] upgrading from 10.1 -> 10.2 with galera cluster
by Jeff Dyke 31 Oct '17

31 Oct '17

Thanks for the tip, that will be helpful for sure. I'm about to set it up on three aws instances and see what happens. Perhaps i can contribute my learnings to the ticket you opened. Best, Jeff On Tue, Oct 31, 2017 at 2:20 PM, Chris Calender <chris.calender(a)mariadb.com> wrote: > Hi Jeff, > > Be sure you have upgraded Xtrabackup to 2.4, or if one of the 10.2 needs > to SST, it will fail with an "No valid checkpoint found" error (as > Xtrabackup 2.3 is not 100% compatible with MariaDB 10.2): > > https://jira.mariadb.org/browse/MDEV-13657 > > Also, I did file a documentation request about this topic last light, if > interested (though you might have this implemented before the page is > added): > > https://jira.mariadb.org/browse/MDEV-14226 > > Hope this helps. > > Best wishes, > Chris > > > > On 10/31/2017 10:09 AM, Jeff Dyke wrote: > >> I have a 10.1 install of galera cluster running in master master mode, i >> would like to upgrade to 10.2.9, and have seen the instructions here[1] >> about "regular" updates, but i'd like to keep the cluster online while i >> upgrade. Is there any difference or things to look out for to keep data >> consistency. can a 10.2 node replicate to a 10.1 node (my guess would be >> no due to the new fields after mysql_upgrade) Downtime offline is a >> possibility, but i'd like to avoid it, as would anyone. >> >> Any hints/links are greatly appreciated. >> Jeff >> >> [1] https://mariadb.com/kb/en/library/upgrading-from-mariadb- >> 101-to-mariadb-102/ >> >> >> _______________________________________________ >> 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 >> >> > > -- > Chris Calender, M.S., Technical Support Manager > MariaDB Corporation >

1 0

[Maria-discuss] upgrading from 10.1 -> 10.2 with galera cluster
by Jeff Dyke 31 Oct '17

31 Oct '17

I have a 10.1 install of galera cluster running in master master mode, i would like to upgrade to 10.2.9, and have seen the instructions here[1] about "regular" updates, but i'd like to keep the cluster online while i upgrade. Is there any difference or things to look out for to keep data consistency. can a 10.2 node replicate to a 10.1 node (my guess would be no due to the new fields after mysql_upgrade) Downtime offline is a possibility, but i'd like to avoid it, as would anyone. Any hints/links are greatly appreciated. Jeff [1] https://mariadb.com/kb/en/library/upgrading-from-mariadb-101-to-mariadb-102/

1 0

[Maria-discuss] Aria_pack error
by Kenneth Penza 27 Oct '17

27 Oct '17

Good afternoon, I am currently working on MariaDB version 10.1.26-MariaDB-1~yakkety running on Ubuntu 16.10 and have encountered an error whilst using aria_pack. The process used to generate the tables is as follows: 1) create table SQL script 2) shutdown MariaDB (systemctl shutdown mariadb.service) 3 )Disable indexes to speedup loading $ aria_chk --keys-used=0 -rq /var/lib/mysql/mygo/term - recovering (with keycache) Aria-table '/var/lib/mysql/mygo/term' Data records: 0 Table: /var/lib/mysql/mygo/term doesn't have an auto increment key State updated 4) startup MariaDB (systemctl start mariadb.service) 5) load data $ mysqlimport -u penzk001 --password=penzk100 -L mygo term.txt mygo.term: Records: 46032 Deleted: 0 Skipped: 0 Warnings: 0 6) shutdown mariadb (systemctl shutdown mariadb.service) 7) Check table $ aria_chk /var/lib/mysql/mygo/term Checking Aria file: /var/lib/mysql/mygo/term Data records: 46032 Deleted blocks: 0 - check file-size - check key delete-chain - check index reference - check record links State update 8) Compress table $ aria_pack /var/lib/mysql/mygo/term Compressing /var/lib/mysql/mygo/term.MAD: (46032 records) - Calculating statistics - Compressing file Segmentation fault (core dumped) When I run steps 1, 5 and 8 I get the following error message: $ aria_pack /var/lib/mysql/mygo/term /var/lib/mysql/mygo/term gave error 132 on open Am I doing something wrong? Any pointers what I can check? Thanks

1 0

[Maria-discuss] Aria_pack error
by Kenneth Penza 27 Oct '17

27 Oct '17

Good afternoon, I am currently working on MariaDB version 10.1.26-MariaDB-1~yakkety running on Ubuntu 16.10 and have encountered an error whilst using aria_pack. The process used to generate the tables is as follows: 1) create table SQL script 2) shutdown MariaDB (systemctl shutdown mariadb.service) 3 )Disable indexes to speedup loading $ aria_chk --keys-used=0 -rq /var/lib/mysql/mygo/term - recovering (with keycache) Aria-table '/var/lib/mysql/mygo/term' Data records: 0 Table: /var/lib/mysql/mygo/term doesn't have an auto increment key State updated 4) startup MariaDB (systemctl start mariadb.service) 5) load data $ mysqlimport -u penzk001 --password=penzk100 -L mygo term.txt mygo.term: Records: 46032 Deleted: 0 Skipped: 0 Warnings: 0 6) shutdown mariadb (systemctl shutdown mariadb.service) 7) Check table $ aria_chk /var/lib/mysql/mygo/term Checking Aria file: /var/lib/mysql/mygo/term Data records: 46032 Deleted blocks: 0 - check file-size - check key delete-chain - check index reference - check record links State update 8) Compress table $ aria_pack /var/lib/mysql/mygo/term Compressing /var/lib/mysql/mygo/term.MAD: (46032 records) - Calculating statistics - Compressing file Segmentation fault (core dumped) When I run steps 1, 5 and 8 I get the following error message: $ aria_pack /var/lib/mysql/mygo/term /var/lib/mysql/mygo/term gave error 132 on open Am I doing something wrong? Any pointers what I can check? Thanks Kenneth

1 0

[Maria-discuss] maria won't start after giving up on mysql 5.7
by Richard Whitney 24 Oct '17

24 Oct '17

Hello, I have been trying for a week to get mysql 5.7 setup on raspbian and have thrown in the towel. I have now installed (tried to install) mariadb 10.1 and it seems to hang on install and then won't start Let me try one more time ....... sudo apt autoremove Reading package lists... Done Building dependency tree Reading state information... Done The following packages will be REMOVED: default-mysql-server 0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded. 3 not fully installed or removed. After this operation, 9,216 B disk space will be freed. Do you want to continue? [Y/n] (Reading database ... 126235 files and directories currently installed.) Removing default-mysql-server (1.0.2) ... Setting up mariadb-server-10.1 (10.1.23-9+deb9u1) ... Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. invoke-rc.d: initscript mysql, action "start" failed. ● mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Tue 2017-10-24 13:25:21 MST; 60ms ago Process: 5576 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 5487 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 5482 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 5479 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 5576 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" Oct 24 13:25:16 qa.com systemd[1]: Starting MariaDB database server... Oct 24 13:25:18 qa.com mysqld[5576]: 2017-10-24 13:25:18 1996230656 [Note] /usr/sbin/mysqld (mysqld 10.1.…576 ... Oct 24 13:25:21 qa.com systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Oct 24 13:25:21 qa.com systemd[1]: Failed to start MariaDB database server. Oct 24 13:25:21 qa.com systemd[1]: mariadb.service: Unit entered failed state. Oct 24 13:25:21 qa.com systemd[1]: mariadb.service: Failed with result 'exit-code'. Hint: Some lines were ellipsized, use -l to show in full. 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.23-9+deb9u1); 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) any ideas? Thank you! -- Richard Whitney phpMyDEV, LLC phpmydev.com 602-334-7771 May there always be tread and air in your tires and oatmeal and butter in your bowl - Author Unknown

1 0

[Maria-discuss] MaxScale behaviour differs for TLs and non-TLS clients
by Pak Chan 16 Oct '17

16 Oct '17

Hi, I'm (still) testing MaxScale, set up to connect only to the master node, on Ubuntu 16.04 fronting a Galera cluster. The cluster comprises of 2 MariaDB 10.1 instances on different servers, with a Galera Arbitrator instance running on the MaxScale server. I'm testing this using the MariaDB client (mysql) from a fourth machine. My test scenario is to see what the client experiences if I stop and restart a MariaDB node part-way through a transaction. I start with the "slave" node, to give me a baseline for comparison, before doing it with the master node. However, the baseline case gives me different results, depending on whether the MySQL client is connecting via TLS or not. If I connect to MaxScale via TLS, the connection disappears when the "slave" node comes back (but not when it goes down). Watching it via a network packet trace, I can see that, just after the slave comes back up, MaxScale sends the client an encrypted packet to the mysql client, then sends a MySQL Quit command to the master node before disconnecting. The syslog contains the line "[galeramon] There are no cluster members". If I connect to MaxScale without TLS, the connection remains stable regardless of the number of times the slave node goes down and up, and the "galeramon" line doesn't appear in the syslog. (I discovered this when I disabled the TLS in order to see what the encrypted packet being sent to the client was...I still don't know what it is!) Has anyone else come across this behaviour? MaxScale is configured as follows (the commented-out configuration is uncommented when connecting via TLS): [dbnode1] type=server address=172.16.1.22 port=3306 protocol=MySQLBackend priority=1 [dbnode2] type=server address=172.16.1.23 port=3306 protocol=MySQLBackend priority=2 [Galera Monitor] type=monitor module=galeramon servers=dbnode1,dbnode2 user=galeramon passwd=galeramon monitor_interval=1000 available_when_donor=true use_priority=true [Galera Service] type=service router=readrouteconn router_options=master servers=dbnode1,dbnode2 user=galeramon passwd=galeramon [MaxAdmin Service] type=service router=cli [Galera Listener] type=listener service=Galera Service protocol=MySQLClient port=3306 #ssl=required #ssl_version=TLSv12 #ssl_cert=/etc/mysql/ssl/server-cert.pem #ssl_key=/etc/mysql/ssl/server-key.pem #ssl_ca_cert=/etc/mysql/ssl/ca-cert.pem #ssl_cert_verify_depth=1 [MaxAdmin Listener] type=listener service=MaxAdmin Service protocol=maxscaled socket=default PC

2 3

[Maria-discuss] GitHub morgo/mysql-compatibility-config - add MariaDB
by Lukas Lehner 15 Oct '17

15 Oct '17

Hey I really like https://github.com/morgo/mysql-compatibility-config is there something similar for MariaDB? Since the repo is owned by some Oracle guy, I guess he won't add MariaDB. Lukas

1 0

[Maria-discuss] MaxScale (lack of) resilience to Galera cluster changes
by Pak Chan 06 Oct '17

06 Oct '17

Hi, Following on from my other thread, I'm testing MaxScale fronting a 2-node Galera cluster (with a Galera Arbitrator acting as the third node). My current test outline is as follows: 1. Identify the Write Master server in MaxScale 2. Connect two mysql clients to MaxScale, and put them both into "READ COMMITTED" isolation level ("set global transaction isolation level read committed") 3. Begin a transaction in each client session 4. Take down the non-Write master node in the Galera cluster ("systemctl stop mysql" on that server) 5. Commit the transaction in client 1 6. Confirm that the clients can see the committed change 7. Start up the stopped node in the Galera cluster ("systemctl start mysql" on that server) 8. Commit the transaction in client 2 9. Confirm that the clients can see the committed change 10. ... What happens is that everything appear to work up until step 8, when client 2 loses its connection to the database when trying to commit, reconnects and loses its uncommitted transaction as a result. At step 9, client 1 announces that it has lost the connection and reconnects. Is this meant to happen? If I run the same test, bypassing MaxScale and connecting both clients directly to the same Galera node, I don't get the connection loss. I understand that MaxScale will route writes to one node and reads to another, but surely the loss of connection to a read node should not result in the loss of connection to the write node? Am I doing something wrong? Yours very puzzled. PC

1 1

[Maria-discuss] MaxScale Server SSL version
by Pak Chan 05 Oct '17

05 Oct '17

Hi, I'm in the process of setting up MaxScale on Ubuntu 16.04 fronting a Galera cluster where the MariaDB database nodes (also on Ubuntu 16.04) are set to use TLSv1.2. There is a "test" user and a "galeramon" user on the database, both requiring SSL. According to the documentation, I can configure this in MaxScale as follows: [dbnode1] type=server address=172.16.1.22 port=3306 protocol=MySQLBackend ssl=required ssl_version=TLSv12 ssl_cert=/etc/mysql/ssl/db-client-cert.pem ssl_key=/etc/mysql/ssl/db-client-key.pem ssl_ca_cert=/etc/mysql/ssl/ca-cert.pem [dbnode2] type=server address=172.16.1.23 port=3306 protocol=MySQLBackend ssl=required ssl_version=TLSv12 ssl_cert=/etc/mysql/ssl/db-client-cert.pem ssl_key=/etc/mysql/ssl/db-client-key.pem ssl_ca_cert=/etc/mysql/ssl/ca-cert.pem [Galera Monitor] type=monitor module=galeramon servers=dbnode1,dbnode2 user=galeramon passwd=galeramon monitor_interval=1000 [Galera Service] type=service router=readwritesplit servers=dbnode1,dbnode2 user=galeramon passwd=galeramon [MaxAdmin Service] type=service router=cli [Galera Listener] type=listener service=Galera Service protocol=MySQLClient port=3306 authenticator=MySQL ssl=required ssl_version=TLSv12 ssl_cert=/etc/mysql/ssl/server-cert.pem ssl_key=/etc/mysql/ssl/server-key.pem ssl_ca_cert=/etc/mysql/ssl/ca-cert.pem ssl_cert_verify_depth=9 [MaxAdmin Listener] type=listener service=MaxAdmin Service protocol=maxscaled socket=default However, this never successfully connects. I ran a packet capture on the connection, and found that the reason it was failing was that MaxScale was trying to connect using TLSv1.0 despite the specification. Changing the "ssl_version" setting to "MAX" had no effect. The version of openssl and libssl1.0.0 on the server are both 1.0.2g-1ubuntu4.8, so it should support TLSv1.2. I installed MaxScale with: curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=mariadb-10.1 sudo apt install maxscale I can disable the TLS requirement for the "galeramon" user, which allows MaxScale to start up, but the moment I log into the database via MaxScale as the "test" user, the connection fails, as the following transcript (from a different server) shows: test@dbclient01:~$ mysql -h 172.16.2.1 -u test -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 31200 Server version: 10.0.0 2.1.9-maxscale Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [(none)]> show databases; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 31200 Current database: *** NONE *** ERROR 2003 (HY000): Authentication with backend failed. Session will be closed. MySQL [(none)]> Is this a known issue, or is there something wrong with the configuration? For the record, I can connect to a database instance over TLSv1.2 from the MaxScale server using the mysql client with the same ("db-client-*") certificate as specified above. PC

2 2

[Maria-discuss] 10.2: Aborted connection 1880 to db.....
by Reindl Harald 30 Sep '17

30 Sep '17

what are these messages which appear in 10.2 regulary - the single enry below is nothing else than stop a slave service and the other flood which is really annoying is libnss-mysql (system users and groups wihtin a mysql database) 2017-09-30 22:28:02 140709059794688 [Warning] Aborted connection 1880 to db: 'unconnected' user: 'replication' host: 'x.x.x.x' (Got an error writing communication packets) at least name it 'Notice' instead of 'Warning' so that it don't trigger alert mails seeking for 'error', 'failed' and 'warning' over severeal hosts and service logs _____________________________________ 2017-09-30 11:06:27 140340005750528 [Warning] Aborted connection 5 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:06:27 140340005144320 [Warning] Aborted connection 6 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:06:27 140340004538112 [Warning] Aborted connection 7 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:06:34 140340005750528 [Warning] Aborted connection 13 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:06:34 140340005144320 [Warning] Aborted connection 14 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:06:35 140340004538112 [Warning] Aborted connection 15 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:06:35 140340003325696 [Warning] Aborted connection 17 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:06:35 140340003628800 [Warning] Aborted connection 16 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:07:30 140340005144320 [Warning] Aborted connection 22 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:07:30 140340005750528 [Warning] Aborted connection 21 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:10:01 140340006356736 [Warning] Aborted connection 28 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:10:01 140340006962944 [Warning] Aborted connection 27 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:10:01 140339927049984 [Warning] Aborted connection 26 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:15:01 140340005144320 [Warning] Aborted connection 38 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:15:01 140340003628800 [Warning] Aborted connection 40 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:15:01 140340004538112 [Warning] Aborted connection 39 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:15:01 140340003325696 [Warning] Aborted connection 41 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:15:02 140340005750528 [Warning] Aborted connection 37 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:17:15 140340005144320 [Warning] Aborted connection 46 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:19:08 140339927049984 [Warning] Aborted connection 34 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:19:08 140340003325696 [Warning] Aborted connection 33 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:20:01 140340006962944 [Warning] Aborted connection 59 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:20:01 140340003628800 [Warning] Aborted connection 56 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:20:01 140340006356736 [Warning] Aborted connection 60 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:20:01 140340005750528 [Warning] Aborted connection 61 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:20:01 140339927049984 [Warning] Aborted connection 58 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:20:02 140340003325696 [Warning] Aborted connection 57 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:25:01 140340003628800 [Warning] Aborted connection 72 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:25:01 140340004538112 [Warning] Aborted connection 71 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:30:01 140340003628800 [Warning] Aborted connection 80 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:30:01 140340004538112 [Warning] Aborted connection 79 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:30:01 140340006962944 [Warning] Aborted connection 83 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:30:01 140340005750528 [Warning] Aborted connection 85 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:30:01 140339927049984 [Warning] Aborted connection 82 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:30:01 140340006356736 [Warning] Aborted connection 84 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:30:01 140340003325696 [Warning] Aborted connection 81 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:35:01 140340005144320 [Warning] Aborted connection 94 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:35:01 140340005750528 [Warning] Aborted connection 93 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:40:01 140340004538112 [Warning] Aborted connection 103 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:40:01 140340003628800 [Warning] Aborted connection 104 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:40:01 140340003325696 [Warning] Aborted connection 105 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:40:01 140339927049984 [Warning] Aborted connection 106 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:40:01 140340005144320 [Warning] Aborted connection 102 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:40:01 140340005750528 [Warning] Aborted connection 101 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:45:01 140340006356736 [Warning] Aborted connection 116 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:45:01 140340005750528 [Warning] Aborted connection 117 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:45:01 140340004538112 [Warning] Aborted connection 119 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:45:02 140340003628800 [Warning] Aborted connection 120 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:45:02 140340005144320 [Warning] Aborted connection 118 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:50:01 140340003628800 [Warning] Aborted connection 128 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:50:01 140340003325696 [Warning] Aborted connection 129 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:55:01 140340003628800 [Warning] Aborted connection 136 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 11:55:01 140340003325696 [Warning] Aborted connection 137 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140340003325696 [Warning] Aborted connection 145 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140339927049984 [Warning] Aborted connection 146 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140340006962944 [Warning] Aborted connection 147 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140340005750528 [Warning] Aborted connection 149 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140340006962944 [Warning] Aborted connection 155 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140340006356736 [Warning] Aborted connection 148 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140339927049984 [Warning] Aborted connection 154 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140340003325696 [Warning] Aborted connection 153 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140340003628800 [Warning] Aborted connection 152 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140340003628800 [Warning] Aborted connection 144 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140340005144320 [Warning] Aborted connection 150 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:00:01 140340004538112 [Warning] Aborted connection 151 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:01:01 140339927049984 [Warning] Aborted connection 162 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:01:01 140340006356736 [Warning] Aborted connection 164 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:01:02 140340006962944 [Warning] Aborted connection 163 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:02:01 140340003325696 [Warning] Aborted connection 169 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:02:01 140340003628800 [Warning] Aborted connection 168 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:03:01 140340006356736 [Warning] Aborted connection 172 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:05:01 140340004538112 [Warning] Aborted connection 175 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:05:01 140340003628800 [Warning] Aborted connection 176 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:10:01 140340003628800 [Warning] Aborted connection 184 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:10:01 140340003325696 [Warning] Aborted connection 185 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:10:01 140340004538112 [Warning] Aborted connection 183 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:15:01 140340003628800 [Warning] Aborted connection 192 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:15:01 140340003325696 [Warning] Aborted connection 193 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:15:01 140340006962944 [Warning] Aborted connection 195 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:15:01 140340006356736 [Warning] Aborted connection 196 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:15:01 140339927049984 [Warning] Aborted connection 194 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:20:01 140340006356736 [Warning] Aborted connection 204 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:20:01 140340004538112 [Warning] Aborted connection 207 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:20:01 140340003628800 [Warning] Aborted connection 208 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:20:01 140340003325696 [Warning] Aborted connection 209 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:20:02 140340005750528 [Warning] Aborted connection 205 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:20:02 140340005144320 [Warning] Aborted connection 206 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:25:01 140340006962944 [Warning] Aborted connection 219 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:25:01 140340006356736 [Warning] Aborted connection 220 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:26:53 140340003628800 [Warning] Aborted connection 224 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:30:01 140340005750528 [Warning] Aborted connection 229 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:30:01 140339927049984 [Warning] Aborted connection 234 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:30:01 140340003628800 [Warning] Aborted connection 232 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:30:01 140340004538112 [Warning] Aborted connection 231 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) 2017-09-30 12:30:01 140340006356736 [Warning] Aborted connection 228 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)

1 0

[Maria-discuss] 10.2: https://mariadb.com/kb/en/library/defragmenting-innodb-tablespaces/
by Reindl Harald 30 Sep '17

30 Sep '17

https://mariadb.com/kb/en/library/defragmenting-innodb-tablespaces/ seems to be silently broken in 10.2 or why is there a fat temp-file as well as the progress display from previous versions don't work in 10.1/10.2 in a useable way (a pseudo progress for small tables is nice but when you see no output at all when 'optimize table' is running on a table with 10 GB it's broken) "innodb-defragment = 1" is set -rw-rw---- 1 mysql mysql 2,6G 2017-09-30 21:39 '#sql-ib3030-2883732087.ibd' MariaDB [dbmail]> OPTIMIZE TABLE `dbmail_users`; +---------------------+----------+----------+-------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +---------------------+----------+----------+-------------------------------------------------------------------+ | dbmail.dbmail_users | optimize | note | Table does not support optimize, doing recreate + analyze instead | | dbmail.dbmail_users | optimize | status | OK | +---------------------+----------+----------+-------------------------------------------------------------------+

1 1

[Maria-discuss] Fwd: [MariaDB Announce] MariaDB 10.2.9, MariaDB 10.1.28 and MariaDB Connector/J releases
by Reindl Harald 29 Sep '17

29 Sep '17

it would be really cool if MariaDB minor updates (10.2.8 to 10.2.9 in that case) would work like for any other software - just replace the tarball, raise the version in the spec-file and hit "rpmbuild -bb mariadb.spec" CMakeError.log as tar.bz2 attached.... ________________________________________________________________________________________ CMake Error at sql/CMakeLists.txt:387 (TARGET_LINK_LIBRARIES): Target "mysqld" of type EXECUTABLE may not be linked into another target. One may link only to STATIC or SHARED libraries, or to executables with the ENABLE_EXPORTS property set. CMake Deprecation Warning at cmake/for_clients.cmake:15 (CMAKE_POLICY): The OLD behavior for policy CMP0007 will be removed from a future version of CMake. The cmake-policies(7) manual explains that the OLD behaviors of all policies are deprecated and that a policy should be set to OLD only under specific short-term circumstances. Projects should be ported to the NEW behavior and not rely on setting a policy to OLD. Call Stack (most recent call first): CMakeLists.txt:415 (INCLUDE) ________________________________________________________________________________________ cmake . \ -DFEATURE_SET="large" \ -DCMAKE_INSTALL_PREFIX="%{_prefix}" \ -DINSTALL_INCLUDEDIR=include/mysql \ -DINSTALL_LAYOUT=RPM \ -DDAEMON_NAME="mysqld" \ -DDAEMON_NO_PREFIX="mysqld" \ -DNICE_PROJECT_NAME="MariaDB" \ -DINSTALL_LIBDIR="%{_lib}/mysql" \ -DINSTALL_MANDIR=share/man \ -DINSTALL_MYSQLSHAREDIR=share/mysql \ -DINSTALL_MYSQLTESTDIR=share/mysql-test \ -DINSTALL_PLUGINDIR="%{_lib}/mysql/plugin" \ -DINSTALL_SBINDIR=libexec \ -DINSTALL_SCRIPTDIR=bin \ -DINSTALL_SQLBENCHDIR= \ -DINSTALL_SUPPORTFILESDIR=share/mysql \ -DMYSQL_DATADIR="%{_sharedstatedir}/mysql" \ -DMYSQL_UNIX_ADDR="%{_sharedstatedir}/mysql/mysql.sock" \ -DENABLED_PROFILING=OFF \ -DENABLE_DEBUG_SYNC=OFF \ -DENABLE_DTRACE=OFF \ -DPLUGIN_ARIA=YES \ -DPLUGIN_CSV=YES \ -DPLUGIN_MYISAM=YES \ -DPLUGIN_ARCHIVE=NO \ -DPLUGIN_BLACKHOLE=NO \ -DPLUGIN_CASSANDRA=NO \ -DPLUGIN_CONNECT=NO \ -DPLUGIN_EXAMPLE=NO \ -DPLUGIN_FEDERATED=NO \ -DPLUGIN_FEDERATEDX=NO \ -DPLUGIN_FEEDBACK=NO \ -DPLUGIN_MROONGA=NO \ -DPLUGIN_MYISAMMRG=NO \ -DPLUGIN_OQGRAPH=NO \ -DPLUGIN_PARTITION=NO \ -DPLUGIN_PERFSCHEMA=NO \ -DPLUGIN_ROCKSDB=NO \ -DPLUGIN_SEMISYNC=NO \ -DPLUGIN_SEQUENCE=NO \ -DPLUGIN_SPHINX=NO \ -DPLUGIN_SPIDER=NO \ -DPLUGIN_TOKUDB=NO \ -DPLUGIN_XTRADB=NO \ -DWITHOUT_DYNAMIC_PLUGINS=ON \ -DWITH_ATOMIC_OPS=smp \ -DWITH_EMBEDDED_SERVER=OFF \ -DWITH_INNODB_DISALLOW_WRITES=OFF \ -DWITH_INNODB_BZIP2=OFF \ -DWITH_INNODB_LZ4=OFF \ -DWITH_INNODB_LZMA=OFF \ -DWITH_INNODB_LZO=OFF \ -DWITH_INNODB_SNAPPY=OFF \ -DWITH_MYSQLCOMPAT=ON \ -DSECURITY_HARDENED=OFF \ -DWITH_LIBARCHIVE=OFF \ -DWITH_LIBWRAP=OFF \ -DWITH_MARIABACKUP=OFF \ -DWITH_PIC=NO \ -DWITH_READLINE=OFF \ -DWITH_SAFEMALLOC=OFF \ -DWITH_VALGRIND=OFF \ -DWITH_WSREP=OFF \ -DWITH_JEMALLOC=OFF \ -DWITH_SSL=system \ -DWITH_ZLIB=system \ -DCOMPILATION_COMMENT="thelounge" %{__make} %{?_smp_mflags} ________________________________________________________________________________________ -------- Weitergeleitete Nachricht -------- Betreff: [MariaDB Announce] MariaDB 10.2.9, MariaDB 10.1.28 and MariaDB Connector/J releases Datum: Thu, 28 Sep 2017 11:57:47 +0200 Von: MariaDB Announce List <announce(a)mariadb.org> An: announce(a)mariadb.org The MariaDB project is pleased to announce the availability of MariaDB 10.2.9, MariaDB 10.1.28, MariaDB Connector/J 2.1.2 and MariaDB Connector/J 1.6.5. These are all stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.9 - Release Notes: https://mariadb.com/kb/en/mdb-1029-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1029-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.9 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ MariaDB 10.1.28 - Release Notes: https://mariadb.com/kb/en/mdb-10128-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10128-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.28 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 2.1.2 - Release Notes: https://mariadb.com/kb/en/mcj-212-rn/ - Changelog: https://mariadb.com/kb/en/mcj-212-cl/ - Downloads: https://downloads.mariadb.org/connector-java/2.1.2/ MariaDB Connector/J 1.6.5 - Release Notes: https://mariadb.com/kb/en/mcj-165-rn/ - Changelog: https://mariadb.com/kb/en/mcj-165-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.6.5/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - 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://jira.mariadb.org - - 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/mariadbfdn Knowledge Base - http://mariadb.com/kb _______________________________________________ announce mailing list announce(a)mariadb.org https://lists.askmonty.org/cgi-bin/mailman/listinfo/announce To unsubscribe, send an email with "unsubscribe" as the Subject: to announce-request(a)mariadb.org

2 9

[Maria-discuss] 10.2.9: failing innodb tests
by Reindl Harald 29 Sep '17

29 Sep '17

that looks not good innodb.table_flags '32k,innodb' w1 [ fail ] Test ended at 2017-09-29 14:17:44 CURRENT_TEST: innodb.table_flags /usr/bin/mysqltest: Error on delete of '/usr/share/mysql-test/var/1/tmp/table_flags/ibtmp1' (Errcode: 2 "No such file or directory") --- /usr/share/mysql-test/suite/innodb/r/table_flags,32k.result~ 2017-09-26 17:07:32.071814438 +0200 +++ /usr/share/mysql-test/suite/innodb/r/table_flags,32k.reject 2017-09-29 14:17:44.692570878 +0200 @@ -176,7 +176,6 @@ SELECT * FROM tp; a DROP TABLE tr,tc,td,tz,tp; -ib_buffer_pool ib_logfile0 ib_logfile1 ibdata1 mysqltest: Result length mismatch - saving '/usr/share/mysql-test/var/1/log/innodb.table_flags-32k,innodb/' to '/usr/share/mysql-test/var/log/innodb.table_flags-32k,innodb/' ***Warnings generated in error logs during shutdown after running tests: innodb.table_flags 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x1a1); dictionary contains id=3, flags=0x101a1 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. 2017-09-29 14:17:39 139655137466688 [Warning] InnoDB: Ignoring tablespace for `test`.`td` because it could not be opened. 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12321 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x1a1); dictionary contains id=3, flags=0x101a1 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12321 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 innodb.table_flags '64k,innodb' w4 [ fail ] Test ended at 2017-09-29 14:17:46 CURRENT_TEST: innodb.table_flags /usr/bin/mysqltest: Error on delete of '/usr/share/mysql-test/var/4/tmp/table_flags/ibtmp1' (Errcode: 2 "No such file or directory") --- /usr/share/mysql-test/suite/innodb/r/table_flags,64k.result~ 2017-09-26 17:07:29.435940019 +0200 +++ /usr/share/mysql-test/suite/innodb/r/table_flags,64k.reject 2017-09-29 14:17:46.209498842 +0200 @@ -176,7 +176,6 @@ SELECT * FROM tp; a DROP TABLE tr,tc,td,tz,tp; -ib_buffer_pool ib_logfile0 ib_logfile1 ibdata1 mysqltest: Result length mismatch - saving '/usr/share/mysql-test/var/4/log/innodb.table_flags-64k,innodb/' to '/usr/share/mysql-test/var/log/innodb.table_flags-64k,innodb/' ***Warnings generated in error logs during shutdown after running tests: innodb.table_flags 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x1e1); dictionary contains id=3, flags=0x101e1 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. 2017-09-29 14:17:40 139995643373888 [Warning] InnoDB: Ignoring tablespace for `test`.`td` because it could not be opened. 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12321 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x1e1); dictionary contains id=3, flags=0x101e1 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12321 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 innodb.table_flags '4k,innodb' w2 [ fail ] Test ended at 2017-09-29 14:18:19 CURRENT_TEST: innodb.table_flags /usr/bin/mysqltest: Error on delete of '/usr/share/mysql-test/var/2/tmp/table_flags/ibtmp1' (Errcode: 2 "No such file or directory") --- /usr/share/mysql-test/suite/innodb/r/table_flags,4k.result~ 2017-09-26 17:08:10.304992901 +0200 +++ /usr/share/mysql-test/suite/innodb/r/table_flags,4k.reject 2017-09-29 14:18:18.954943828 +0200 @@ -174,7 +174,6 @@ SELECT * FROM tp; a DROP TABLE tr,tc,td,tz,tp; -ib_buffer_pool ib_logfile0 ib_logfile1 ibdata1 mysqltest: Result length mismatch - saving '/usr/share/mysql-test/var/2/log/innodb.table_flags-4k,innodb/' to '/usr/share/mysql-test/var/log/innodb.table_flags-4k,innodb/' ***Warnings generated in error logs during shutdown after running tests: innodb.table_flags 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0xe1); dictionary contains id=3, flags=0x100e1 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. 2017-09-29 14:18:13 140291687692608 [Warning] InnoDB: Ignoring tablespace for `test`.`td` because it could not be opened. 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12323 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0xe1); dictionary contains id=3, flags=0x100e1 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12323 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 sys_vars.innodb_file_per_table_basic 'innodb' w2 [ pass ] 4 innodb.index_tree_operation 'innodb' w1 [ pass ] 19 innodb.innodb_bug60049 'innodb' w3 [ pass ] 2522 innodb.create_isl_with_direct 'innodb' w2 [ pass ] 8 innodb.innodb_force_pk 'innodb' w2 [ pass ] 13 innodb.101_compatibility '8k,innodb' w4 [ pass ] 4519 main.flush_block_commit_notembedded 'innodb' w3 [ pass ] 2061 binlog.binlog_checksum 'innodb,row' w2 [ pass ] 834 main.mysql_upgrade 'innodb' w3 [ skipped ] Test requires partitioning innodb.alter_missing_tablespace '8k,innodb' w4 [ pass ] 2518 innodb.innodb_bug14147491 'innodb' w1 [ pass ] 4107 innodb.innodb_autoinc_lock_mode_zero 'innodb' w3 [ pass ] 12 innodb.innodb-mdev-7408 'innodb' w1 [ pass ] 6 innodb.innodb_bug42101-nonzero 'innodb' w3 [ pass ] 5 innodb.innodb-alter-nullable '8k,innodb' w4 [ pass ] 52 innodb.innodb_information_schema_buffer 'innodb' w1 [ pass ] 25 innodb.innodb-alter-table '8k,innodb' w4 [ pass ] 523 binlog.binlog_commit_wait 'innodb,row' w2 [ pass ] 5275 binlog.binlog_dmls_on_tmp_tables_readonly 'innodb,row' w2 [ pass ] 11 innodb.innodb_bug39438 'innodb' w3 [ pass ] 8 main.bug46760 'innodb' w1 [ pass ] 12 main.row-checksum-old 'innodb' w3 [ pass ] 16 innodb.innodb_trx_weight 'innodb' w1 [ pass ] 40 innodb.innodb-alter 'innodb' w3 [ pass ] 245 main.row-checksum 'innodb' w1 [ pass ] 10 innodb.temporary_table_optimization 'innodb' w3 [ pass ] 47 innodb.data_types 'innodb' w1 [ pass ] 5 innodb.innodb-index-online-norebuild 'innodb' w3 [ pass ] 8 innodb.innodb-stats-modified-counter 'innodb' w1 [ pass ] 8 innodb.table_flags '8k,innodb' w4 [ fail ] Test ended at 2017-09-29 14:18:40 CURRENT_TEST: innodb.table_flags /usr/bin/mysqltest: Error on delete of '/usr/share/mysql-test/var/4/tmp/table_flags/ibtmp1' (Errcode: 2 "No such file or directory") --- /usr/share/mysql-test/suite/innodb/r/table_flags,8k.result~ 2017-09-26 17:08:28.249137992 +0200 +++ /usr/share/mysql-test/suite/innodb/r/table_flags,8k.reject 2017-09-29 14:18:40.460922576 +0200 @@ -174,7 +174,6 @@ SELECT * FROM tp; a DROP TABLE tr,tc,td,tz,tp; -ib_buffer_pool ib_logfile0 ib_logfile1 ibdata1 mysqltest: Result length mismatch - saving '/usr/share/mysql-test/var/4/log/innodb.table_flags-8k,innodb/' to '/usr/share/mysql-test/var/log/innodb.table_flags-8k,innodb/' ***Warnings generated in error logs during shutdown after running tests: innodb.table_flags 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x121); dictionary contains id=3, flags=0x10121 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. 2017-09-29 14:18:35 139736414353728 [Warning] InnoDB: Ignoring tablespace for `test`.`td` because it could not be opened. 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12323 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x121); dictionary contains id=3, flags=0x10121 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12323 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 innodb.innodb_information_schema_tables 'innodb' w3 [ pass ] 17 innodb.innodb-trim 'innodb' w1 [ pass ] 1101 innodb.innodb-autoinc-56228 'innodb' w1 [ pass ] 4 innodb.innodb_mysql_rbk 'innodb' w3 [ pass ] 3885 binlog.binlog_implicit_commit 'innodb,row' w2 [ pass ] 16518 binlog.binlog_innodb 'innodb,row' w2 [ pass ] 2708 innodb.innodb-lock-schedule-algorithm 'innodb' w4 [ pass ] 10193 main.commit_1innodb 'innodb' w2 [ fail ] Test ended at 2017-09-29 14:18:51 CURRENT_TEST: main.commit_1innodb --- /usr/share/mysql-test/r/commit_1innodb.result 2017-09-25 08:33:24.000000000 +0200 +++ /usr/share/mysql-test/r/commit_1innodb.reject 2017-09-29 14:18:51.351405429 +0200 @@ -710,12 +710,12 @@ # drop temporary table t2; call p_verify_status_increment(1, 0, 1, 0); -SUCCESS - +ERROR +Expected commit increment: 1 actual: 0 commit; call p_verify_status_increment(1, 0, 1, 0); -SUCCESS - +ERROR +Expected commit increment: 1 actual: 0 # 26. Verify that SET AUTOCOMMIT issues an implicit commit # insert t1 set a=3; @@ -831,8 +831,8 @@ Note 1050 Table 't2' already exists # Sic: first commits the statement, and then the transaction. call p_verify_status_increment(0, 0, 0, 0); -SUCCESS - +ERROR +Expected commit increment: 0 actual: 2 create table t3 select a from t2; call p_verify_status_increment(2, 0, 4, 4); SUCCESS mysqltest: Result length mismatch - saving '/usr/share/mysql-test/var/2/log/main.commit_1innodb-innodb/' to '/usr/share/mysql-test/var/log/main.commit_1innodb-innodb/'

1 0

[Maria-discuss] perl-dbi
by Ruben Safir 26 Sep '17

26 Sep '17

Does anything need to be ported to mariabd if we are using perl::DBI or can I just pull the files from cpan. I have a large number of legacy applications I need to adapt based on MYSQL::DBI modules. Ruben -- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and and extermination camps, but incompatible with living as a free human being. -RI Safir 2013

1 0

[Maria-discuss] mysqld_safe and pid files
by Ruben Safir 26 Sep '17

26 Sep '17

hello monty et al i'm trying to write an init script for maria and artix, which is using openrc I got it to start up but the pid-file is a problem and I think that the command line options for mysqld_safe is not working. it doesnt create the specified pid file [www3 ~]# /usr/bin/mysqld_safe --pid-file=/run/mariadb.pid 170926 10:41:52 mysqld_safe Logging to '/usr/local/var/www3.err'. 170926 10:41:52 mysqld_safe Starting mysqld daemon with databases from /usr/local/var [www3 ~]# cat /run/mariadb.pid cat: /run/mariadb.pid: No such file or directory [www3 ~]# tail -f /usr/local/var/www3.err 2017-09-26 10:41:53 139828287336192 [Note] InnoDB: 128 rollback segment(s) are active. 2017-09-26 10:41:53 139828287336192 [Note] InnoDB: Waiting for purge to start 2017-09-26 10:41:53 139828287336192 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1601111 2017-09-26 10:41:53 139828287336192 [Note] Plugin 'FEEDBACK' is disabled. 2017-09-26 10:41:53 139827658368768 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-09-26 10:41:53 139828287171328 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 2017-09-26 10:41:53 139828287336192 [Note] Server socket created on IP: '::'. 2017-09-26 10:41:53 139828286868224 [ERROR] mysqld: Can't create/write to file '/run/mariadb.pid' (Errcode: 13 "Permission denied") 2017-09-26 10:41:53 139828286868224 [ERROR] Can't start server: can't create PID file: Permission denied 170926 10:41:53 mysqld_safe mysqld from pid file /run/mariadb.pid ended drwxr-xr-x 16 root root 620 Sep 25 21:45 run what do you recommend to do? The system is uniform -- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and and extermination camps, but incompatible with living as a free human being. -RI Safir 2013

3 6

Re: [Maria-discuss] URI data source for XML/JSON CONNECT tables?
by Olivier Bertrand 14 Sep '17

14 Sep '17

Hi! Le 18/02/2015 à 08:05, Kolbe Kegel a écrit : > Hi! > > I had some fun using the JSON table type recently. But what fun is it to read JSON from a file. FYI, CONNECT new versions (already distributed in 10.2) include getting Json info directly from MongoDB collections. > JSON comes from RESTful APIs :) > > Has there been any thought about functionality to read JSON from a URI? See above and the attached doc. > This introduces loads of complications and dependencies, but maybe it'd be worth looking into. Or maybe that's something that could be provided by some other plugin that'd handle the HTTP heavy lifting? > > We'd want to take into account that most RESTful APIs worth pulling JSON from would require some form of authentication that we probably would not want to force users to store in their table definition. > > Kolbe > Olivier

1 0

[Maria-discuss] Mariadb cluster on windows
by vv2599 06 Sep '17

06 Sep '17

Hello Guys, I would like to know if there is a way to setup mariadb cluster on windows or is there any way that a high availability system can be setup on windows server 2008. Appreciate any response. Regards, Vino

4 7

[Maria-discuss] Issues with get SSL replication going (I.e. Encrypting Replication Traffic as well as Encrypting SST Traffic)
by Brent Clark 30 Aug '17

30 Aug '17

Good day Guys Im trying to get SSL replication going (I.e. Encrypting Replication Traffic as well as Encrypting SST Traffic). For the likes of me I just cant get it working. If I set the variable, encrypt = 0 (i.e. encryption off) replication works. Please can I ask if someone could please review my logs / setup are see where my issue lays. Here is my configuration setup https://pastebin.com/9JDP4LCr This is the /var/log/mysql/error.log of First node (i.e. Donor) https://pastebin.com/MrWDcECA This is the /var/log/mysql/error.log of 2nd node (i.e. joiner) https://pastebin.com/wZiNDP4P If anyone can assist, it would most appreciated. Kind Regards Brent Clark

1 0

Re: [Maria-discuss] Pacemaker and mariadb semi-sync
by Pavel Ivanov 23 Aug '17

23 Aug '17

Yes, having processlist while it's hung might be handy. On Tue, Aug 22, 2017 at 3:45 PM, Nils Carlson <nils.carlson(a)ludd.ltu.se> wrote: > On 08/22/2017 10:42 PM, Pavel Ivanov wrote: > >> Can you clarify what SHOW SLAVE STATUS blocks on for you? > > Not really. Basically, just after performing a failover, I run SHOW SLAVE > STATUS on the slave and that can take up to 30 seconds sometimes before the > query returns. Once it does return everything looks like normal. I can try > to dump the thread status maybe. > > /Nils > > > >> On Sun, Aug 20, 2017 at 9:47 AM, Nils Carlson <nils.carlson(a)ludd.ltu.se> >> wrote: >>> >>> Hi Pavel and Kristian, >>> >>> On 08/10/2017 10:58 PM, Pavel Ivanov wrote: >>>> >>>> Note also that you don't want to set rpl_semi_sync_master_enabled='ON' >>>> on all your slaves, it should be set only on the master. With the >>>> setting your slaves' SQL threads will hang waiting for semi-sync ack >>>> as well, and they will hang forever if >>>> rpl_semi_sync_master_wait_no_slave is set to ON too. >>>> >>> Thank you. >>> >>>> On Wed, Aug 9, 2017 at 2:30 AM, Kristian Nielsen >>>> <knielsen(a)knielsen-hq.org> wrote: >>>>> >>>>> Hope this helps, >>> >>> >>> And thank you for all this! >>> >>> I have updated the resource-agent based on this and run some light >>> testing. >>> I will try to write automated tests soon. >>> >>> I was also wondering about one thing, the block SHOW SLAVE STATUS >>> command. >>> Is there any way to ensure this doesn't block? Maybe this is something to >>> suggest to the development mailing list? >>> >>> Thanks again. >>> >>> Cheers, >>> Nils >>> >>> >>>>> - Kristian. >>>>> >>>>> _______________________________________________ >>>>> 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

Re: [Maria-discuss] Pacemaker and mariadb semi-sync
by Pavel Ivanov 23 Aug '17

23 Aug '17

Can you clarify what SHOW SLAVE STATUS blocks on for you? On Sun, Aug 20, 2017 at 9:47 AM, Nils Carlson <nils.carlson(a)ludd.ltu.se> wrote: > Hi Pavel and Kristian, > > On 08/10/2017 10:58 PM, Pavel Ivanov wrote: >> >> Note also that you don't want to set rpl_semi_sync_master_enabled='ON' >> on all your slaves, it should be set only on the master. With the >> setting your slaves' SQL threads will hang waiting for semi-sync ack >> as well, and they will hang forever if >> rpl_semi_sync_master_wait_no_slave is set to ON too. >> > Thank you. > >> On Wed, Aug 9, 2017 at 2:30 AM, Kristian Nielsen >> <knielsen(a)knielsen-hq.org> wrote: >>> >>> Hope this helps, > > > And thank you for all this! > > I have updated the resource-agent based on this and run some light testing. > I will try to write automated tests soon. > > I was also wondering about one thing, the block SHOW SLAVE STATUS command. > Is there any way to ensure this doesn't block? Maybe this is something to > suggest to the development mailing list? > > Thanks again. > > Cheers, > Nils > > >>> >>> - Kristian. >>> >>> _______________________________________________ >>> 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