On 08-01-16 15:53, Remi Bergsma wrote: > Hi Wido, > > FYI: I run two 4.7 clouds and both have the AUTO_INCREMENT set properly. >
Hmm, weird. Were they fresh 4.7 installs? I manually fixed it here and looking at the SQL files I don't understand how this might have gone wrong. Wido > Regards, > Remi > > > > > On 08/01/16 14:31, "Wido den Hollander" <w...@widodh.nl> wrote: > >> Hi, >> >> I've been investigating a issue with a freshly installed 4.7 CloudStack >> setup and I was wondering if somebody else has seen this. >> >> The table account was looking like this: >> >> account | CREATE TABLE `account` ( >> `id` bigint(20) unsigned NOT NULL, >> `account_name` varchar(100) DEFAULT NULL COMMENT 'an account name set >> by the creator of the account, defaults to username for single accounts', >> `uuid` varchar(40) DEFAULT NULL, >> `type` int(1) unsigned NOT NULL, >> `domain_id` bigint(20) unsigned DEFAULT NULL, >> `state` varchar(10) NOT NULL DEFAULT 'enabled', >> `removed` datetime DEFAULT NULL COMMENT 'date removed', >> `cleanup_needed` tinyint(1) NOT NULL DEFAULT '0', >> `network_domain` varchar(100) DEFAULT NULL COMMENT 'Network domain >> name of the Vms of the account', >> `default_zone_id` bigint(20) unsigned DEFAULT NULL, >> `default` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '1 if account >> is default', >> PRIMARY KEY (`id`), >> UNIQUE KEY `uc_account__uuid` (`uuid`), >> KEY `i_account__removed` (`removed`) >> ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >> >> The most important part is that the ID is lacking the AUTO_INCREMENT >> flag which caused new account creations to fail. >> >> I've been trying to track this back to where it was modified, but so far >> I haven't been able to find this. >> >> In non of our SQL files I can actually see the account table being created. >> >> Has anybody seen this before? >> >> Wido