Date: Tue, 06 Jun 2017 09:20:04 +0000 From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 219818] databases/mariadb102-server Unexpected behavior with INNOBASE setting Message-ID: <bug-219818-13@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D219818 Bug ID: 219818 Summary: databases/mariadb102-server Unexpected behavior with INNOBASE setting Product: Ports & Packages Version: Latest Hardware: Any OS: Any Status: New Severity: Affects Only Me Priority: --- Component: Individual Port(s) Assignee: brnrd@freebsd.org Reporter: martin@sugioarto.com Flags: maintainer-feedback?(brnrd@freebsd.org) Assignee: brnrd@freebsd.org Hi, I have a problem with the port configuration of MariaDB 10.2. After upgrade from MariaDB 10.1 to 10.2, all InnoDB tables are inaccessible, despite the fact that upstream says in upgrade instructions that InnoDB is default and the upgrade should not introduce problems. The port has default setting INNOBASE, but it just installs a plugin that n= eeds to be loaded (not mentioned in the pkg-plist). Here is how to load InnoDB plugin (this appears to be non-standard, different from original docs): [mysqld]=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 plugin_dir =3D /usr/local/lib/mysql/plugin plugin_load =3D ha_innobase.so Then, INNOBASE setting says in port configuration that InnoDB is default. E= ven with this setting above, it is not true: MariaDB [(none)]> show engines;=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20 +--------------------+---------+-------------------------------------------= ---------------------------------------+--------------+------+------------+ | Engine | Support | Comment=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20 | Transactions | XA | Savepoints | +--------------------+---------+-------------------------------------------= ---------------------------------------+--------------+------+------------+ | MRG_MyISAM | YES | Collection of identical MyISAM tables=20= =20=20=20=20=20=20=20=20 | NO | NO | NO | | CSV | YES | CSV storage engine=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | MyISAM | DEFAULT | MyISAM storage engine=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 | NO | NO | NO | | PERFORMANCE_SCHEMA | YES | Performance Schema=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 | NO | NO | NO | | Aria | YES | Crash-safe tables with MyISAM heritage=20= =20=20=20=20=20=20=20 | NO | NO | NO | | SEQUENCE | YES | Generated tables filled with sequential va= lues | YES | NO | YES | | InnoDB | YES | Supports transactions, row-level locking, foreign keys and encryption for tables | YES | YES | YES | +--------------------+---------+-------------------------------------------= ---------------------------------------+--------------+------+------------+ You can see: MyISAM is default. Suggestion: Please fix the port to behave as closely as possible as the upstream docs. Thank you. Martin --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-219818-13>