|
Bugzilla – Full Text Bug Listing |
| Summary: | mariadb "security update" breaks database | ||
|---|---|---|---|
| Product: | [openSUSE] openSUSE 11.4 | Reporter: | Stefan Seyfried <seife> |
| Component: | Basesystem | Assignee: | Michal Hrusecky <mhrusecky> |
| Status: | RESOLVED FIXED | QA Contact: | E-mail List <qa-bugs> |
| Severity: | Critical | ||
| Priority: | P1 - Urgent | CC: | maintenance, meissner, security-team, wlad |
| Version: | Final | ||
| Target Milestone: | --- | ||
| Hardware: | Other | ||
| OS: | Other | ||
| Whiteboard: | . | ||
| Found By: | Third Party Developer/Partner | Services Priority: | |
| Business Priority: | Blocker: | --- | |
| Marketing QA Status: | --- | IT Deployment: | --- |
| Bug Depends on: | |||
| Bug Blocks: | 676973 | ||
| Deadline: | 2011-07-13 | ||
| Attachments: | tarball of /var/log/mysql | ||
oh, very funny to see that the problem is known since 3 days and nothing happened :-( Anyway, the same solution as in bug 676973 (downgrading to version of 11.4GA) helped. The SWAMPID for this issue is 42141. This issue was rated as critical. Please submit fixed packages until 2011-07-13. Also create a patchinfo file using this link: https://swamp.suse.de/webswamp/wf/42141 11.4 test rpms: http://download.opensuse.org/repositories/home:/msmeissn:/branches:/openSUSE:/11.4:/Update:/Test/standard/ do you know if 11.3 is broken too? it builds with innodb_plzugin still at least. - --with-plugins=partition,csv,heap,myisam,ndbcluster,maria,myisammrg \ + --with-plugins=partition,csv,heap,myisam,ndbcluster,maria,myisammrg,innodb_plugin \ submitted against 11.4 I believe it should be xtradb rather than (or in addition too) to the list of plugins, because xtradb == default builtin Innodb in MariaDB. innodb_plugin is dynamic ,i.e unless someone loads it explicitely, there is be no Innodb. Fix submited against 11.4 as sr#76054. Adding innodb_plugin to --with-plugins= wouldn't work as innodb_plugin can be compiled only as a plugin. And it is currently still in mariadb even after the security update, but it had to be enabled manually :-/ I added xtradb as a builtin engine (it's innodb dropin replacement in the same way as mariadb is dropin replacement for mysql). 11.3 will follow as well, just checking that everything builts fine. we need it for 11.3 too I guess This is an autogenerated message for OBS integration: This bug (704811) was mentioned in https://build.opensuse.org/request/show/76054 11.4 / mariadb This is an autogenerated message for OBS integration: This bug (704811) was mentioned in https://build.opensuse.org/request/show/76067 11.3 / mariadb Update released for: libmariadbclient16, libmariadbclient16-debuginfo, libmariadbclient_r16, libmariadbclient_r16-debuginfo, mariadb, mariadb-bench, mariadb-bench-debuginfo, mariadb-client, mariadb-client-debuginfo, mariadb-debug, mariadb-debug-debuginfo, mariadb-debuginfo, mariadb-debugsource, mariadb-test, mariadb-test-debuginfo, mariadb-tools, mariadb-tools-debuginfo Products: openSUSE 11.4 (debug, i586, x86_64) Update released for: libmariadbclient16, libmariadbclient16-debuginfo, libmariadbclient_r16, libmariadbclient_r16-debuginfo, mariadb, mariadb-bench, mariadb-bench-debuginfo, mariadb-client, mariadb-client-debuginfo, mariadb-debug, mariadb-debug-debuginfo, mariadb-debuginfo, mariadb-debugsource, mariadb-test, mariadb-test-debuginfo, mariadb-tools, mariadb-tools-debuginfo Products: openSUSE 11.3 (debug, i586, x86_64) done |
Created attachment 439103 [details] tarball of /var/log/mysql During the "security update" of "libmariadbclient16", I got lots of Installing: mariadb-5.1.55-0.3.1 [done] Additional rpm output: Shutting down service MySQL ..done install-info: warning: no info dir entry in `/usr/share/info/mysql.info.gz' Will update MySQL now, if you encounter any problems, please read following file: /usr/share/doc/packages/mariadb/README.SuSE Running protected MySQL... Upgrading MySQL... Phase 1/3: Fixing table and database names Phase 2/3: Checking and upgrading tables Processing databases information_schema gallery2 gallery2.g2_AccessMap Error : Unknown table engine 'InnoDB' error : Corrupt gallery2.g2_AccessSubscriberMap Error : Unknown table engine 'InnoDB' error : Corrupt gallery2.g2_AlbumItem Error : Unknown table engine 'InnoDB' error : Corrupt ... gallery2.g2_UserGroupMap Error : Unknown table engine 'InnoDB' error : Corrupt Phase 3/3: Running 'mysql_fix_privilege_tables'... OK Starting service MySQL ..done And now my gallery installation is toast :-( I suggest to retract this update immediately as it seems to be very dangerous.