[ 
https://issues.apache.org/jira/browse/CLOUDSTACK-8706?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14659886#comment-14659886
 ] 

ASF subversion and git services commented on CLOUDSTACK-8706:
-------------------------------------------------------------

Commit b6a78044a0881e17d045f35850222c275a84642e in cloudstack's branch 
refs/heads/master from [~rajanik]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=b6a7804 ]

CLOUDSTACK-8696: Create Region fails with exception

'id' in the region table should not be an autoincrement unlike other
tables. This is because, region ids must be in sync across installs and
hence is accepted as input to the addRegions api.

It is not a good practise to override id for this purpose. another
column 'regionId' has to be created and used(CLOUDSTACK-8706). until it
is fixed, id should never be autoincrement in regions table.


> id of the regions table is not an autoincrement
> -----------------------------------------------
>
>                 Key: CLOUDSTACK-8706
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-8706
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the 
> default.) 
>            Reporter: Rajani Karuturi
>
> This cannot be autoincrement as region ids must be in sync across installs 
> and hence is accepted as input to the addregions api. 
> It is not a good practise to override id for this purpose. another column 
> 'regionId' should to be created and used.
> It caused regression(CLOUDSTACK-8696) when autoincrement was added on this 
> field (commit: eb666453f3bd4f9ff06d12fad94bf7a2ca427099)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to