cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chip Childers <chip.child...@sungard.com>
Subject Re: Exception when inserting Event
Date Tue, 16 Jul 2013 17:48:48 GMT
I'd suggest shortening your event type literals.


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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message