- discuss - lists.mariadb.org

[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