FEDORA-2017-7b83201239 created by mschorm 2 years ago for Fedora 27
stable

MariaDB 10.2.10

https://mariadb.com/kb/en/library/mariadb-10210-release-notes/

CVE fixes:

 CVE-2017-10378, CVE-2017-10268, CVE-2017-15365

Bug fixes:

 - PID file location fixed 
 - Start using location libdir/mariadb for plugins
 - Move libraries to libdir
 - Divided to more sub-packages to match upstream's RPM list
 - Update of Cmake arguments to supported format
 - Remove false Provides
 - Fix client library obsolete
 - Remove unused python scripts which remained from TokuDB upstream

How to install

sudo dnf upgrade --advisory=FEDORA-2017-7b83201239

This update has been submitted for testing by mschorm.

2 years ago

This update has been pushed to testing.

2 years ago
User Icon imabug provided feedback 2 years ago
karma
BZ#1508196 mariadb-10.2.10 is available
User Icon g6avk commented & provided feedback 2 years ago
karma

Works for me.
Also fixed a problem where Cqrlog was not able to start.

BZ#1483331 Couldn't start mariadb.service
BZ#1508196 mariadb-10.2.10 is available
User Icon bt0dotninja commented & provided feedback 2 years ago
karma

client side packages works fine

User Icon cserpentis commented & provided feedback 2 years ago
karma

works for me

User Icon nb commented & provided feedback 2 years ago
karma

wfm

This update has reached 7 days in testing and can be pushed to stable now if the maintainer wishes

2 years ago
User Icon amessina commented & provided feedback 2 years ago

I haven't installed, but what in this version is supposed to provide libmysqlclient.so.18()(64bit)?

Problem: problem with installed package mysql-connector-odbc-5.3.4-6.fc26.x86_64
- package mysql-connector-odbc-5.3.4-6.fc26.x86_64 requires libmysqlclient.so.18()(64bit), but none of the providers can be installed
- cannot install both mariadb-libs-3:10.2.10-2.fc27.x86_64 and mariadb-libs-3:10.2.9-3.fc27.x86_64
- cannot install both mariadb-libs-3:10.2.9-3.fc27.x86_64 and mariadb-libs-3:10.2.10-2.fc27.x86_64
- cannot install the best update candidate for package mariadb-libs-3:10.2.9-3.fc27.x86_64
User Icon lupinix commented & provided feedback 2 years ago
karma

works fine

User Icon mschorm commented & provided feedback 2 years ago

Maintainer note: This update won't be pushed to stable until fixed: as "amessina" comment says - it could potentialy break update.

User Icon frantisekz commented & provided feedback 2 years ago
karma

Works fine!

User Icon anonymous commented & provided feedback 2 years ago

Didn't work for me, and had to revert back to 10.2.9-3.fc27

2017-12-09 22:20:47 139933492747712 [Note] InnoDB: Initializing buffer pool, total size = 2.5G, instances = 2, chunk size = 128M
2017-12-09 22:20:47 139933492747712 [Note] InnoDB: Completed initialization of buffer pool
2017-12-09 22:20:47 139929181533952 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-12-09 22:20:47 139933492747712 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-09 22:20:47 139933492747712 [Note] InnoDB: The log sequence number 20406422848 in the system tablespace does not match the log sequence number 20406423052 in the ib_logfiles!
2017-12-09 22:20:48 139933492747712 [Note] InnoDB: Last binlog file './bin.000033', position 27520143
2017-12-09 22:20:54 139933492747712 [Note] InnoDB: 128 out of 128 rollback segments are active.
2017-12-09 22:20:54 139933492747712 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-12-09 22:20:54 139933492747712 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-12-09 22:20:54 139933492747712 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 22
2017-12-09 22:20:54 139933492747712 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
2017-12-09 22:20:54 139933492747712 [ERROR] InnoDB: Unable to create the shared innodb_temporary
2017-12-09 22:20:54 139933492747712 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-12-09 22:20:59 139933492747712 [Note] InnoDB: Starting shutdown...
2017-12-09 22:20:59 139933492747712 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-12-09 22:20:59 139933492747712 [ERROR] Plugin 'InnoDB' init function returned error.
2017-12-09 22:20:59 139933492747712 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-12-09 22:20:59 139933492747712 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-12-09 22:20:59 139933492747712 [ERROR] Aborting

/var/lib/mysql has plenty of space!

and

Version: '10.2.10-MariaDB-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
2017-12-09 22:33:26 139987483092736 [Note] Slave I/O thread: connected to master 'repl@192.168.1.9:3306',replication started in log 'bin.000334' at position 528429187
2017-12-09 22:34:22 139987482892032 [ERROR] InnoDB: preallocating 65536 bytes for file ./db/users_most_active.ibd failed with error 22
2017-12-09 22:34:22 139987482892032 [Warning] InnoDB: Cannot create table `db`.`users_most_active` because tablespace full
2017-12-09 22:34:22 139987482892032 [Warning] mysqld: The table 'users_most_active' is full
2017-12-09 22:34:22 139987482892032 [ERROR] Slave SQL: Error 'Can't create table `db`.`users_most_active` (errno: 135 "No more room in record file")' on query. Default database: 'db'. Query: 'CREATE TABLE `users_most_active` ( `userid` int(10) unsigned NOT NULL, `c` int(10) unsigned NOT NULL, PRIMARY KEY (`userid`), KEY `idx_c` (`c`), CONSTRAINT `fk_active` FOREIGN KEY (`userid`) REFERENCES `users_user` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1', Gtid 0-3-94776137, Internal MariaDB error code: 1005
2017-12-09 22:34:22 139987482892032 [Warning] Slave: Can't create table `db`.`users_most_active` (errno: 135 "No more room in record file") Error_code: 1005
2017-12-09 22:34:22 139987482892032 [Warning] Slave: The table 'users_most_active' is full Error_code: 1114
2017-12-09 22:34:22 139987482892032 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'bin.000334' position 528961171
2017-12-09 22:34:22 139987482892032 [Note] Slave SQL thread exiting, replication stopped in log 'bin.000334' at position 528961171
2017-12-09 22:35:00 139987482892032 [Note] /usr/libexec/mysqld (unknown): Normal shutdown

After downgrading back to mariadb-server-10.2.9-3.fc27, replication continued from stalled position.

Still have an issue where the server shutdown hangs for 10 minutes waiting for mariadb service to stop.

karma: -1

BZ#1483331 Couldn't start mariadb.service
User Icon gtwilliams commented & provided feedback 2 years ago
karma

Verified 1483331 is fixed. WFM.

User Icon amessina commented & provided feedback 2 years ago

@mschorm for my comment above regarding package dependency issues...

Do the dependent packages need to be rebuilt against new versions of mariadb? For example, mysql-connector-odbc hasn't had any change except for being rebuilt since Fedora 23: https://src.fedoraproject.org/rpms/mysql-connector-odbc/commits/f27.

Or does mariadb need to provide libmysqlclient.so.18()(64bit)?

User Icon gtwilliams commented & provided feedback 2 years ago

Please see dnf provides 'libmysqlclient.so.18()(64bit)'. You need mariadb-libs.

User Icon amessina commented & provided feedback 2 years ago

@gtwilliams, correct. But the 101.2.10 builds don't provide it:

# dnf --refresh --best --enablerepo=updates-testing provides 'libmysqlclient.so.18()(64bit)'
Last metadata expiration check: 0:00:00 ago on Sun 17 Dec 2017 11:14:18 AM CST.
mariadb-libs-3:10.2.9-3.fc27.x86_64 : The shared libraries required for MariaDB/MySQL clients
Repo        : @System
Matched from:
Provide    : libmysqlclient.so.18()(64bit)

mariadb-libs-3:10.2.9-3.fc27.x86_64 : The shared libraries required for MariaDB/MySQL clients
Repo        : fedora
Matched from:
Provide    : libmysqlclient.so.18()(64bit)
User Icon besser82 commented & provided feedback 2 years ago
karma

Works great! LGTM! =)

User Icon mschorm commented & provided feedback 2 years ago

@amessina Yes, a new version of packages will be needed. There are several big issues connected together.

Currently I'm working on it and my plan is following: 1) begin provides of the static mysql client library by "community-mysql" package (because "mysql-connector-odbc" canĀ“t be linked dynamically in newer versions) 2) begin building of "mysql-connector-odbc" against "community-mysql" again (because needed mariadb source codes aren't available in newer version - and that's why the "mysql-connector-odbc" wasn't updated so long) 3) build "mysql-connector-odbc" against that static library (that will both make the package working again and enable the update for MariaDB that dropped the dynamic library)


And I'll see, if I'll push this update to stable. Probabbly not, because of @anonymous issue. However MariaDB 10.2.11 is already packed and built for 27 and Rawhide, so maybe I'll override this update by the newer one.

This update has been submitted for batched by mschorm.

2 years ago

This update has been submitted for stable by bodhi.

2 years ago

This update has been pushed to stable.

2 years ago

Please login to add feedback.

Metadata
Type
enhancement
Severity
high
Karma
9
Signed
Content Type
RPM
Test Gating
Settings
Unstable by Karma
-4
Stable by Karma
disabled
Stable by Time
disabled
Dates
submitted
2 years ago
in testing
2 years ago
in stable
2 years ago
BZ#1400463 MariaDB does not build when some devel packages are installed
0
0
BZ#1483331 Couldn't start mariadb.service
-1
1
BZ#1490401 Split mariadb package to more sub-packages to match upstream's RPM list
0
0
BZ#1498956 mariadb-common has an Obsoletes with %{?_isa} - not functional
0
0
BZ#1508196 mariadb-10.2.10 is available
0
2

Automated Test Results