cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chiradeep Vittal <Chiradeep.Vit...@citrix.com>
Subject Re: Exception when inserting Event
Date Wed, 17 Jul 2013 06:34:11 GMT


On 7/16/13 11:18 PM, "Chip Childers" <chip.childers@sungard.com> wrote:

>I'd suggest shortening your event type literals.
>

+1

>
>On Tue, Jul 16, 2013 at 1:45 PM, Soheil Eizadi <seizadi@infoblox.com>
>wrote:
>
>> I have code to delete the Plugin device from the system, when I try to
>> execute this code I get an exception before my Command gets invoked in
>> system code that tries to create an event. I debugged this to the event
>> table underlying SQL definition. I wanted to know what the best practice
>> was for CloudStack:
>>
>>   *   Update the Event Table definition to accommodate a longer Type
>>Field
>>   *   Limit my choice of naming to fit the existing 32 byte Event Field
>>
>> Ideally I wanted to change the event definition, but the change will
>> impact database upgrade as we go from one release to another.
>> -Soheil
>>
>> mysql> describe event;
>>
>> 
>>+-------------+---------------------+------+-----+-----------+-----------
>>-----+
>> | Field       | Type                | Null | Key | Default   | Extra
>>    |
>>
>> 
>>+-------------+---------------------+------+-----+-----------+-----------
>>-----+
>> | id          | bigint(20) unsigned | NO   | PRI | NULL      |
>> auto_increment |
>> .....
>> | type        | varchar(32)         | NO   | MUL | NULL      |
>>    |
>> .....
>>
>> 
>>+-------------+---------------------+------+-----+-----------+-----------
>>-----+
>> -------
>>
>>
>> @Entity
>>
>> @Table(name="event")
>>
>> public class EventVO implements Event {
>>
>>
>> ....
>>
>>     @Column(name="type")
>>
>>     private String type;
>>
>>
>> ------
>>
>> ERROR [cloud.api.ApiServer] (183551903@qtp-729770861-5:) unhandled
>> exception executing api command: deleteInfobloxDevice
>> com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
>> com.mysql.jdbc.JDBC4PreparedStatement@59c7f05d: INSERT INTO event
>> (event.type, event.state, event.description, event.created,
>>event.user_id,
>> event.account_id, event.domain_id, event.level, event.start_id,
>> event.parameters, event.uuid, event.archived) VALUES
>> (_binary'PHYSICAL.INFOBLOXCONTROLLER.DELETE', 'Scheduled',
>>_binary'Deleting
>> Infoblox Controller', '2013-07-16 04:11:58', 2, 2, 1, _binary'INFO', 0,
>> null, _binary'eefc03f0-f60b-4450-a43a-319e66c15e94', 0)
>> at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1342)
>> ......
>> at
>> 
>>org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:
>>582)
>> Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too
>> long for column 'type' at row 1
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4072)
>>


Mime
View raw message