Mailing-List: contact cloudstack-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cloudstack-users@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of fj6562ib@aa.jp.fujitsu.com
 designates 192.51.44.36 as permitted sender)
From: =?iso-2022-jp?B?RklQKRskQiU+ITwlXyVnITwlRiVDGyhC?=
 <fj6562ib@aa.jp.fujitsu.com>
To: <cloudstack-users@incubator.apache.org>
References: <003001cdefea$75a907d0$60fb1770$@aa.jp.fujitsu.com>
 <67EF18FDCA335F489B366120481AB6C5F6B4030AA2@BANPMAILBOX01.citrite.net>
 <000601cdeff0$66d5ce90$34816bb0$@aa.jp.fujitsu.com>
 <67EF18FDCA335F489B366120481AB6C5F6B4030AF2@BANPMAILBOX01.citrite.net>
 <00f801cdf2d8$e38f75e0$aaae61a0$@aa.jp.fujitsu.com>
 <67EF18FDCA335F489B366120481AB6C5F6B4030C3B@BANPMAILBOX01.citrite.net>
In-Reply-To: 
 <67EF18FDCA335F489B366120481AB6C5F6B4030C3B@BANPMAILBOX01.citrite.net>
Subject: RE: Regarding cloudstack pod issues
Date: Tue, 15 Jan 2013 14:04:35 +0900
Message-ID: <00fc01cdf2dd$d042def0$70c89cd0$@aa.jp.fujitsu.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-2022-jp"
Content-Transfer-Encoding: 7bit
Thread-Index: 
 AQFRBjh3bB0yohpIEAJJ3eSXRA4CPQHDXz5tAr2Rq5ICq8mfggJmYPucARgNPoWY7lVeYA==
Content-Language: ja

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.saxena@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: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