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` mysql> UPDATE mysql.user SET 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
