Hey Zaw, You can post your CPBM queries on http://forums.citrix.com/forum.jspa?forumID=1465
-Radhika -----Original Message----- From: Pranav Saxena [mailto:pranav.sax...@citrix.com] Sent: Tuesday, January 15, 2013 10:43 AM To: cloudstack-users@incubator.apache.org Subject: RE: Regarding cloudstack pod issues If you have any CPBM related issues , we'll have to take it off the dev - mailing list . Just FYI - CPBM related issues aren't supposed to be discussed here. Thanks, Pranav -----Original Message----- From: FIP)ゾーミョーテッ [mailto:fj656...@aa.jp.fujitsu.com] Sent: Tuesday, January 15, 2013 10:35 AM To: cloudstack-users@incubator.apache.org Subject: RE: Regarding cloudstack pod issues Hey Pranav, Thanks again. If you have any information regarding CPBM, please send it to me as quickly as possible. Regards, Zaw -----Original Message----- From: Pranav Saxena [mailto:pranav.sax...@citrix.com] Sent: Tuesday, January 15, 2013 1:42 PM To: cloudstack-users@incubator.apache.org Cc: Vaibhav Gupta Subject: RE: Regarding cloudstack pod issues Hey Zaw , I don't have much idea about installation of CPBM but certainly I can help you by asking somebody who's worked on CPBM to help you out with your queries. @Vaibhav , Do you have any idea about this issue ? Regards, Pranav -----Original Message----- From: FIP)ゾーミョーテッ [mailto:fj656...@aa.jp.fujitsu.com] Sent: Tuesday, January 15, 2013 9:59 AM To: cloudstack-users@incubator.apache.org Subject: RE: Regarding cloudstack pod issues Hi Pranav, Firstly I'd like to say thank you. And I'm really sorry for late reply email and it is settle now. Can you do me a favour for one thing? Why should we need to create new user in mysql database regarding CloudPortal BM installation. Kindly request you to review the following information; #mysql -u root -p user name: xxxxx (and) password: xxxxx mysql>prompt mysql> create user cpbm identified by `Citrix123` UPDATE mysql.user SET mysql>password = PASSWORD(`xxxxx`) WHERE User = `cpbm`; GRANT ALL PRIVILEGES ON *.* TO 'cpbm'@'%' WITH GRANT OPTION; FLUSH PRIVILEGES; quit (Exit MySQL) Regards, Zaw -----Original Message----- From: Pranav Saxena [mailto:pranav.sax...@citrix.com] Sent: Friday, January 11, 2013 9:36 PM To: cloudstack-users@incubator.apache.org Subject: RE: Regarding cloudstack pod issues I think you can try something like this to check your database capacity and the current used capacity by your tables in cloudstack management's database. *CURRENT CAPACITY* -----Original Message----- mysql> SELECT table_schema "Database Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema; +--------------------+----------------------+ | Database Name | Data Base Size in MB | +--------------------+----------------------+ | cloud | 11.57368469 | | cloudbridge | 0.76562500 | | cloud_usage | 0.82812500 | | information_schema | 0.00781250 | | mysql | 0.62359524 | +--------------------+----------------------+ 5 rows in set (0.29 sec) You could also try doing this to calculate used and free space in your database - mysql> SELECT table_schema "Data Base Name", -> sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", -> sum( data_free )/ 1024 / 1024 "Free Space in MB" -> FROM information_schema.TABLES -> GROUP BY table_schema; +--------------------+----------------------+------------------+ | Data Base Name | Data Base Size in MB | Free Space in MB | +--------------------+----------------------+------------------+ | cloud | 11.57368469 | 3212.00127125 | | cloudbridge | 0.76562500 | 308.00000000 | | cloud_usage | 0.82812500 | 330.00000000 | | information_schema | 0.00781250 | 0.00000000 | | mysql | 0.62359524 | 0.00000000 | +--------------------+----------------------+------------------+ 5 rows in set (0.09 sec) Thanks, Pranav From: FIP)ゾーミョーテッ [mailto:fj656...@aa.jp.fujitsu.com] Sent: Friday, January 11, 2013 5:10 PM To: cloudstack-users@incubator.apache.org Subject: RE: Regarding cloudstack pod issues Hi Prana, Thank you so much for your reply email. Did you mean that cloudstack management's database? Can you please do me a favour how to proceed to fix that error? -----Original Message----- From: Pranav Saxena [mailto:pranav.sax...@citrix.com] Sent: Friday, January 11, 2013 8:02 PM To: cloudstack-users@incubator.apache.org Subject: RE: Regarding cloudstack pod issues Hey Zaw , Can you provide the detailed logs . Something seems to be missing here . The exception which you are getting here could be - throw new CloudRuntimeException("Unable to insert queue item into database, DB is full?"); Can you check if your DB capacity is ok ? Regards, Pranav -----Original Message----- From: FIP)ゾーミョーテッ [mailto:fj656...@aa.jp.fujitsu.com] Sent: Friday, January 11, 2013 4:28 PM To: cloudstack-users@incubator.apache.org Subject: Regarding cloudstack pod issues Dear cloudstack team, I am facing an issue regarding cloudstack pod settings and kindly request you to check the following error messages. Please reply to this email address as soon as possible if someone who have an experience with the following error. ERROR [cloud.api.ApiDispatcher] (catalina-exec-14:null) Exception while executing CreatePodCmd: com.cloud.utils.exception.CloudRuntimeException: Unable to insert ERROR [cloud.api.ApiDispatcher] (catalina-exec-16:null) Exception while executing CreatePodCmd: com.cloud.utils.exception.CloudRuntimeException: Unable to insert Thank you so much for your help and cooperation. Kind regards, Zaw
