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:[email protected]]
Sent: Friday, January 11, 2013 5:10 PM
To: [email protected]
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:[email protected]]
Sent: Friday, January 11, 2013 8:02 PM
To: [email protected]
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:[email protected]]
Sent: Friday, January 11, 2013 4:28 PM
To: [email protected]
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
