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 Fri, 11 Jan 2013 12:36:20 GMT
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