我认为问题出在这里：
更新存储的时候 available_bytes=-184549376
注意后面是一个负数，字面理解应该是存储的“有效字节数”不应该是一个负数啊！况且按照表结构的定义也是这样，该字段是无符号的bigint，其范围是0~
18446744073709551615
2013/9/5 WXR <474745...@qq.com>
>
> 今天我在添加一个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
