| 2014-05-05 09:09:01 |
Chen Xiao |
description |
When using DB2, Heat event record can not be inserted into table "Event", the root cause is that the ID column is supposed to be auto increasement but it is not. This column was set to auto increasement in 035_event_uuid_to_id.py with the statement:
event_table.c.tmp_id.alter(sqlalchemy.Integer, autoincrement=True)
For DB2, setting "ID" colume "autoincrement=True" can't make sense after above "tmp_id=>id" transformation,
so should work around it. |
When using DB2, Heat event record can not be inserted into table "Event", the root cause is that the ID column is supposed to be auto increasement but it is not. This column was set to auto increasement in 035_event_uuid_to_id.py with the statement:
event_table.c.tmp_id.alter(sqlalchemy.Integer, autoincrement=True)
For DB2, setting "ID" colume "autoincrement=True" can't make sense after above "tmp_id=>id" transformation,
so should work around it.
reproduce steps:
Using DB2 as heat database backend.
[root@control-node ~]# heat create wordpress1 --template-file=heat-templates/cfn/F17/getting_started.template --parameters="KeyName=root_key"
Will found it will try to insert null value to column 'id' in table 'event'. |
|
