mariadb102-server-10.2.6 missing innodb?


I've just upgraded to MariaDB 10.2 and couldn't use my my.cnf because InnoDB was missing, I was able to start MariaDB if I removed my my.cnf, but using "show engines" innodb isn't there.


edit: tested on another box and it isn't there either
to be exta sure I re-did everything from scratch with empty /var/db/mysql and no my.cnf, still
cat /var/db/mysql/hostname_error.log
2017-06-01 4:13:33 34418548736 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-06-01 4:13:33 34418548736 [ERROR] Aborting
That's not what I asked. How did you install the port? What method did you use to install MariaDB in the first place?
Hmm, then I can't help wonder if you haven't ran into a package problem. Thing is: I'm trying to reproduce to see what's going on but when I check for the existence of MariaDB ( # pkg search -x mariadb) then I don't see 10.2 as being available.

I eventually traced this down to 10.2 being available for the amd64 branch but not fully for i386 (which is what my test box uses). Seems confirms this (somewhat): when I search for MariaDB I see the existence of a 10.2 client, but not the server.

Now, this is in no way enough to conclude anything, but I did notice that despite InnoDB being the default engine it's still a toggleable option in the Port configuration. Which makes me wonder if anything could have happened with the binary packages.

Sorry, but that's all I can do so far (and I know it doesn't help).
Confirm the InnoDB option is enabled in the package:
# pkg rquery -r FreeBSD -e "%n=maraidb100-server" "%n-%v %Ok %Ov"
root@r:~ # pkg rquery -r FreeBSD -e "%n=mariadb102-server" "%n-%v %Ok %Ov"  
mariadb102-server-10.2.6 CONNECT_EXTRA on
mariadb102-server-10.2.6 GSSAPI_BASE on
mariadb102-server-10.2.6 GSSAPI_HEIMDAL off
mariadb102-server-10.2.6 GSSAPI_MIT off
mariadb102-server-10.2.6 GSSAPI_NONE off
mariadb102-server-10.2.6 INNOBASE on
mariadb102-server-10.2.6 LZ4 off
mariadb102-server-10.2.6 LZO off
mariadb102-server-10.2.6 MROONGA off
mariadb102-server-10.2.6 MSGPACK off
mariadb102-server-10.2.6 OQGRAPH off
mariadb102-server-10.2.6 ROCKSDB off
mariadb102-server-10.2.6 SNAPPY off
mariadb102-server-10.2.6 SPHINX on
mariadb102-server-10.2.6 SPIDER on
mariadb102-server-10.2.6 TOKUDB off
mariadb102-server-10.2.6 XTRADB off
mariadb102-server-10.2.6 ZMQ off
mariadb102-server-10.2.6 ZSTD off
Last edited by a moderator: