cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-7830) Usage Job fails with "Data too long for column 'user_name'"
Date Mon, 10 Nov 2014 09:57:33 GMT

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

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

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

CLOUDSTACK-7830: Usage Job fails with "Data too long for column 'user_name'"


>  Usage Job fails with "Data too long for column 'user_name'"
> ------------------------------------------------------------
>
>                 Key: CLOUDSTACK-7830
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-7830
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Usage
>    Affects Versions: 4.4.0
>            Reporter: Damodar Reddy T
>            Assignee: Damodar Reddy T
>             Fix For: Future, 4.5.0
>
>
> ISSUE:
> ======
> Usage Job is failing with the following exception in the logs
> {noformat}
> 2014-03-25 00:15:00,239 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Creating
VPN user: 4 for account: 13
> 2014-03-25 00:15:00,240 DEBUG [db.Transaction.Transaction] (Usage-Job-1:null) Rolling
back the transaction: Time = 2 Name =  -UsageEventDaoImpl.getRecentEvents:93-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:125-UsageManagerImpl.parse:541-UsageManagerImpl.run:334-Executors$RunnableAdapter.call:471-FutureTask$Sync.innerRunAndReset:351-FutureTask.runAndReset:178-ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201:165-ScheduledThreadPoolExecutor$ScheduledFutureTask.run:267-ThreadPoolExecutor.runWorker:1146-ThreadPoolExecutor$Worker.run:615-Thread.run:701;
called by -Transaction.rollback:897-Transaction.removeUpTo:840-Transaction.close:664-TransactionContextBuilder.interceptException:63-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:133-UsageManagerImpl.createVPNUserEvent:1583-UsageManagerImpl.createHelperRecord:893-UsageManagerImpl.parse:562-UsageManagerImpl.run:334-Executors$RunnableAdapter.call:471-FutureTask$Sync.innerRunAndReset:351-FutureTask.runAndReset:178
> 2014-03-25 00:15:00,252 ERROR [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Exception
in usage manager
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@74b4624e:
INSERT INTO usage_vpn_user (usage_vpn_user.zone_id, usage_vpn_user.account_id, usage_vpn_user.domain_id,
usage_vpn_user.user_id, usage_vpn_user.user_name, usage_vpn_user.created, usage_vpn_user.deleted)
VALUES (0, 13, 14, 4, _binary'timothy.lothering@dcxclouddemo.co.za', '2014-03-11 14:36:50',
null)
> 	at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1348)
> 	at com.cloud.usage.dao.UsageVPNUserDaoImpl_EnhancerByCloudStack_60ddd7cc.CGLIB$persist$45(<generated>)
> 	at com.cloud.usage.dao.UsageVPNUserDaoImpl_EnhancerByCloudStack_60ddd7cc_FastClassByCloudStack_d13d3284.invoke(<generated>)
> 	at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> 	at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> 	at com.cloud.usage.dao.UsageVPNUserDaoImpl_EnhancerByCloudStack_60ddd7cc.persist(<generated>)
> 	at com.cloud.usage.UsageManagerImpl.createVPNUserEvent(UsageManagerImpl.java:1583)
> 	at com.cloud.usage.UsageManagerImpl.createHelperRecord(UsageManagerImpl.java:893)
> 	at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:562)
> 	at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:334)
> 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> 	at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
> 	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
> 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:165)
> 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:267)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> 	at java.lang.Thread.run(Thread.java:701)
> Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column
'user_name' at row 1
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4072)



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

Mime
View raw message