cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pranav Saxena <pranav.sax...@citrix.com>
Subject RE: Regarding cloudstack pod issues
Date Tue, 15 Jan 2013 04:42:24 GMT
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:fj6562ib@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.saxena@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:fj6562ib@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.saxena@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:fj6562ib@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

 




Mime
View raw message