????????????????9T??9829107105792??????????????????????????????????????????????????storage_pool????available_bytes????????????
????????????????????????????????bigint??????????????????????????????
????cloudstack???????????????????????????????????????????????????????????????????????????????

--------------------------------

????????????????????
2013-09-05 10:02:02,042 DEBUG [cloud.storage.StorageManagerImpl] 
(catalina-exec-10:null) Adding pool data to  host 11
2013-09-05 10:02:02,045 DEBUG [agent.transport.Request] (catalina-exec-10:null) 
Seq 11-926745485: Sending  { Cmd , MgmtId: 196039272834978, via: 11, Ver: v1, 
Flags: 100011, 
[{"ModifyStoragePoolCommand":{"add":true,"pool":{"id":202,"uuid":"c9ce60bb-6cb2-3531-b36a-ca122f3ef3db","host":"192.168.183.2","path":"/data","port":2049,"type":"NetworkFilesystem"},"localPath":"/mnt//c9ce60bb-6cb2-3531-b36a-ca122f3ef3db","wait":0}}]
 }
2013-09-05 10:02:02,350 DEBUG [agent.transport.Request] 
(AgentManager-Handler-12:null) Seq 11-926745485: Processing:  { Ans: , MgmtId: 
196039272834978, via: 11, Ver: v1, Flags: 10, 
[{"ModifyStoragePoolAnswer":{"poolInfo":{"host":"192.168.183.2","localPath":"/mnt//c9ce60bb-6cb2-3531-b36a-ca122f3ef3db","hostPath":"/data","poolType":"NetworkFilesystem","capacityBytes":9829107105792,"availableBytes":-184549376},"templateInfo":{},"result":true,"wait":0}}]
 }
2013-09-05 10:02:02,350 DEBUG [agent.transport.Request] (catalina-exec-10:null) 
Seq 11-926745485: Received:  { Ans: , MgmtId: 196039272834978, via: 11, Ver: 
v1, Flags: 10, { ModifyStoragePoolAnswer } }
2013-09-05 10:02:02,399 DEBUG [db.Transaction.Transaction] 
(catalina-exec-10:null) Rolling back the transaction: Time = 2 Name =  update; 
called by 
-Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-TransactionContextBuilder.interceptException:63-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:133-GenericDaoBase.update:775-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:125-GenericDaoBase.update:1256-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:125-StorageManagerImpl.connectHostToSharedPool:1652-StorageManagerImpl.createPool:1402-StorageManagerImpl.createPool:147
2013-09-05 10:02:02,400 WARN  [cloud.storage.StorageManagerImpl] 
(catalina-exec-10:null) Unable to establish a connection between 
Host[-11-Routing] and Pool[202|NetworkFilesystem]
com.cloud.utils.exception.CloudRuntimeException: DB Exception on: 
com.mysql.jdbc.JDBC4PreparedStatement@4bdade88: UPDATE storage_pool SET 
storage_pool.available_bytes=-184549376, 
storage_pool.capacity_bytes=9829107105792 WHERE storage_pool.id = 202 
    at com.cloud.utils.db.GenericDaoBase.update(GenericDaoBase.java:822)
    at 
com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
    at com.cloud.utils.db.GenericDaoBase.update(GenericDaoBase.java:775)
    at 
com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
    at com.cloud.utils.db.GenericDaoBase.update(GenericDaoBase.java:1256)
    at 
com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
    at 
com.cloud.storage.StorageManagerImpl.connectHostToSharedPool(StorageManagerImpl.java:1652)
    at 
com.cloud.storage.StorageManagerImpl.createPool(StorageManagerImpl.java:1402)
    at 
com.cloud.storage.StorageManagerImpl.createPool(StorageManagerImpl.java:147)
    at 
org.apache.cloudstack.api.command.admin.storage.CreateStoragePoolCmd.execute(CreateStoragePoolCmd.java:123)
    at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:162)
    at com.cloud.api.ApiServer.queueCommand(ApiServer.java:505)
    at com.cloud.api.ApiServer.handleRequest(ApiServer.java:355)
    at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:302)
    at com.cloud.api.ApiServlet.doGet(ApiServlet.java:66)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
    at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at 
org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:889)
    at 
org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:721)
    at 
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2266)
    at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    at java.lang.Thread.run(Thread.java:679)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range 
value for column 'available_bytes' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4072)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
    at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
    at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)
    at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
    at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355)
    at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at com.cloud.utils.db.GenericDaoBase.update(GenericDaoBase.java:814)
    ... 44 more
2013-09-05 10:02:02,402 WARN  [cloud.storage.StorageManagerImpl] 
(catalina-exec-10:null) No host can access storage pool 
Pool[202|NetworkFilesystem] on cluster 1
2013-09-05 10:02:02,448 INFO  [cloud.api.ApiServer] (catalina-exec-10:null) 
Failed to add storage pool

回复