[Opensim-users] MySQL create table for regions fails on new data base setup?

[Shy Robbiani]

I stumbled over this a wile ago and submitted a patch. I'm not sure it ever
got implemented.

According to the MySQL 5.6 Reference manual in relation to InnoDB tables:
"ROW_FORMAT=FIXED is not supported. If ROW_FORMAT=FIXED is specified while
innodb_strict_mode is disabled, InnoDB issues a warning and assumes
ROW_FORMAT=COMPACT. If ROW_FORMAT=FIXED is specified while
innodb_strict_mode is enabled, InnoDB returns an error".

And a few lines later: "For MyISAM tables, the option value can be FIXED or
DYNAMIC for static or variable-length row format. myisampack sets the type
to COMPRESSED".

Maybe the default in 5.7 changed to strict or the behaviour has been
changed. I don't know.

On Fri, Jan 8, 2016 at 4:02 PM, GarminKawaguichi <
garmin.kawaguichi at magalaxie.com> wrote:

> May be that could help:
>
> http://bugs.mysql.com/bug.php?id=23404
>
> GCI
>
>
> Le 08/01/2016 12:11, Ai Austin a écrit :
>
> hello.. I have a working OpenSim database on MySQL 5.6.21 Community
> Edition and have done a mysqldump on that.  I set up a new server with
> MySQL 5.7.10 Community Edition and created the opensim database as usual...
> I then wanted to load in the dumped mysql from the other server.
>
> I got an error ERROR 1031 (HY000) at line 3016: Table storage engine for
> 'regions' doesn't have this option
>
> I can't edit the very large SQL file to check what that line has on it,
> but after looking round on the web a bit and using a suggestion there I did
> get the create table statement for "regions" from the previous working
> system and try to load that on the new MYSQL setup and that give the same
> error... as noted in the trace below. So I assume its the table create for
> the "regions" table that is the problem.  But what is wrong? I can dump the
> SQL from the original data base again if some parameter is needed there.
>
> Can anyone cast a light on this or suggest a fix?
>
> C:\Users\****> mysql --verbose -u ****** -p opensim < create-regions.sql
> Enter password: *********
> --------------
> CREATE TABLE `regions` (
>   `uuid` varchar(36) NOT NULL,
>   `regionHandle` bigint(20) unsigned NOT NULL,
>   `regionName` varchar(128) DEFAULT NULL,
>   `regionRecvKey` varchar(128) DEFAULT NULL,
>   `regionSendKey` varchar(128) DEFAULT NULL,
>   `regionSecret` varchar(128) DEFAULT NULL,
>   `regionDataURI` varchar(255) DEFAULT NULL,
>   `serverIP` varchar(64) DEFAULT NULL,
>   `serverPort` int(10) unsigned DEFAULT NULL,
>   `serverURI` varchar(255) DEFAULT NULL,
>   `locX` int(10) unsigned DEFAULT NULL,
>   `locY` int(10) unsigned DEFAULT NULL,
>   `locZ` int(10) unsigned DEFAULT NULL,
>   `eastOverrideHandle` bigint(20) unsigned DEFAULT NULL,
>   `westOverrideHandle` bigint(20) unsigned DEFAULT NULL,
>   `southOverrideHandle` bigint(20) unsigned DEFAULT NULL,
>   `northOverrideHandle` bigint(20) unsigned DEFAULT NULL,
>   `regionAssetURI` varchar(255) DEFAULT NULL,
>   `regionAssetRecvKey` varchar(128) DEFAULT NULL,
>   `regionAssetSendKey` varchar(128) DEFAULT NULL,
>   `regionUserURI` varchar(255) DEFAULT NULL,
>   `regionUserRecvKey` varchar(128) DEFAULT NULL,
>   `regionUserSendKey` varchar(128) DEFAULT NULL,
>   `regionMapTexture` varchar(36) DEFAULT NULL,
>   `serverHttpPort` int(10) DEFAULT NULL,
>   `serverRemotingPort` int(10) DEFAULT NULL,
>   `owner_uuid` varchar(36) NOT NULL DEFAULT
> '00000000-0000-0000-0000-000000000000',
>   `originUUID` varchar(36) DEFAULT NULL,
>   `access` int(10) unsigned DEFAULT '1',
>   `ScopeID` char(36) NOT NULL DEFAULT
> '00000000-0000-0000-0000-000000000000',
>   `sizeX` int(11) NOT NULL DEFAULT '0',
>   `sizeY` int(11) NOT NULL DEFAULT '0',
>   `flags` int(11) NOT NULL DEFAULT '0',
>   `last_seen` int(11) NOT NULL DEFAULT '0',
>   `PrincipalID` char(36) NOT NULL DEFAULT
> '00000000-0000-0000-0000-000000000000',
>   `Token` varchar(255) NOT NULL,
>   `parcelMapTexture` varchar(36) DEFAULT NULL,
>   PRIMARY KEY (`uuid`),
>   KEY `regionName` (`regionName`),
>   KEY `regionHandle` (`regionHandle`),
>   KEY `overrideHandles`
> (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`),
>   KEY `ScopeID` (`ScopeID`),
>   KEY `flags` (`flags`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3'
> --------------
>
> ERROR 1031 (HY000) at line 1: Table storage engine for 'regions' doesn't
> have this option
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20160108/f06003e6/attachment-0001.html>