You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@vcl.apache.org by Andy Kurth <an...@ncsu.edu> on 2010/12/03 16:06:12 UTC

Re: Reservation always in Pending-state

Hello,
Sorry for the delay.  I believe the problem is caused by the 
imagerevision ID.  The value set for the request is 7 but there is no 
entry in the imagerevision table with ID=7.  The imagerevision entry for 
your new image is 5.  Change reservation.imagerevisionid to 5.  This 
should allow the imaging reservation to proceed.

Hope this helps,
Andy

On 11/24/2010 11:16 AM, Mauricio Cesar Ramirez Torres wrote:
> This is the content in my database.
>
>
> Last login: Tue Nov 23 18:42:53 2010
> [root@vcl ~]# mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 66394
> Server version: 5.0.77 Source distribution
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> use vcl;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Database changed
> mysql> select * from request;
> +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+
> | id | stateid | userid | laststateid | logid | forimaging | test |
> preload | start | end | daterequested | datemodified | checkuser |
> +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+
> | 1 | 16 | 1 | 16 | 0 | 1 | 0 | 0 | 2010-11-12 17:10:06 | 2010-11-12
> 19:10:06 | 2010-11-12 17:10:06 | NULL | 1 |
> | 10 | 14 | 1 | 13 | 3 | 0 | 0 | 0 | 2010-11-16 16:45:00 | 2010-11-16
> 18:00:00 | 2010-11-16 16:54:44 | NULL | 1 |
> | 12 | 14 | 1 | 13 | 4 | 0 | 0 | 0 | 2010-11-16 18:45:00 | 2010-11-16
> 19:15:00 | 2010-11-16 18:01:36 | NULL | 1 |
> | 13 | 14 | 2 | 19 | 0 | 0 | 0 | 0 | 2010-11-16 18:45:00 | 2010-11-16
> 19:05:00 | 2010-11-16 18:52:07 | NULL | 1 |
> | 14 | 14 | 1 | 13 | 5 | 0 | 0 | 0 | 2010-11-17 17:15:00 | 2010-11-17
> 18:00:00 | 2010-11-17 17:22:47 | NULL | 1 |
> | 15 | 14 | 1 | 13 | 6 | 0 | 0 | 0 | 2010-11-17 18:15:00 | 2010-11-17
> 19:00:00 | 2010-11-17 18:26:02 | NULL | 1 |
> | 16 | 14 | 1 | 13 | 7 | 0 | 0 | 0 | 2010-11-18 13:30:00 | 2010-11-18
> 14:15:00 | 2010-11-18 13:32:22 | NULL | 1 |
> | 17 | 14 | 1 | 13 | 8 | 0 | 0 | 0 | 2010-11-18 16:30:00 | 2010-11-18
> 17:15:00 | 2010-11-18 16:32:26 | NULL | 1 |
> | 18 | 14 | 1 | 13 | 10 | 0 | 0 | 0 | 2010-11-18 17:30:00 | 2010-11-18
> 18:00:00 | 2010-11-18 17:01:08 | NULL | 1 |
> | 19 | 14 | 1 | 13 | 11 | 0 | 0 | 0 | 2010-11-18 18:15:00 | 2010-11-18
> 18:45:00 | 2010-11-18 18:09:18 | NULL | 1 |
> | 20 | 14 | 1 | 13 | 12 | 0 | 0 | 0 | 2010-11-18 19:00:00 | 2010-11-18
> 19:45:00 | 2010-11-18 19:09:35 | NULL | 1 |
> | 21 | 14 | 1 | 13 | 13 | 0 | 0 | 0 | 2010-11-19 08:30:00 | 2010-11-19
> 09:15:00 | 2010-11-19 08:38:46 | NULL | 1 |
> +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+
> 12 rows in set (0.00 sec)
>
> mysql> select * from reservation;
> +----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
> | id | requestid | computerid | imageid | imagerevisionid |
> managementnodeid | remoteIP | lastcheck | pw |
> +----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
> | 2 | 1 | 2 | 7 | 7 | 1 | NULL | NULL | NULL |
> | 11 | 10 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
> | 13 | 12 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
> | 14 | 13 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
> | 15 | 14 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
> | 16 | 15 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
> | 17 | 16 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
> | 18 | 17 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
> | 19 | 18 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
> | 20 | 19 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
> | 21 | 20 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
> | 22 | 21 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
> +----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
> 12 rows in set (0.00 sec)
>
> mysql> select * from computer;
> +----+---------+---------+------------+------------+----------------+-------------+-----------------+-------+------------+-----------+---------+----------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+----------------------------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
> | id | stateid | ownerid | platformid | scheduleid | currentimageid |
> nextimageid | imagerevisionid | RAM | procnumber | procspeed | network |
> hostname | IPaddress | privateIPaddress | eth0macaddress |
> eth1macaddress | type | provisioningid | drivetype | deleted | notes |
> lastcheck | location | dsa | dsapub | rsa | rsapub | host | hostpub |
> vmhostid | vmtypeid |
> +----+---------+---------+------------+------------+----------------+-------------+-----------------+-------+------------+-----------+---------+----------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+----------------------------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
> | 1 | 20 | 1 | 1 | 1 | 4 | 4 | 4 | 62000 | 8 | 3000 | 1000 |
> vcl.ndi.com.mx | 192.168.1.40 | NULL | NULL | NULL | lab | 7 | hda | 0 |
> admin 2010-11-16 16:37:30@ | NULL | NULL | NULL | NULL | NULL | NULL |
> NULL | NULL | NULL | NULL |
> | 2 | 2 | 1 | 1 | 1 | 4 | 4 | 4 | 2048 | 2 | 3000 | 100 | vmware1 |
> 192.168.1.41 | NULL | NULL | NULL | virtualmachine | 7 | hda | 0 | |
> NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL |
> +----+---------+---------+------------+------------+----------------+-------------+-----------------+-------+------------+-----------+---------+----------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+----------------------------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
> 2 rows in set (0.00 sec)
>
> mysql> select * from vmhost;
> +----+------------+---------+-------------+-------------+------------+
> | id | computerid | vmlimit | vmprofileid | vmkernalnic | vmwaredisk |
> +----+------------+---------+-------------+-------------+------------+
> | 1 | 1 | 6 | 2 | NULL | localdisk |
> +----+------------+---------+-------------+-------------+------------+
> 1 row in set (0.00 sec)
>
> mysql> select * from image;
> +----+----------------------+------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
> | id | name | prettyname | ownerid | platformid | OSid | imagemetaid |
> minram | minprocnumber | minprocspeed | minnetwork | maxconcurrent |
> reloadtime | deleted | test | lastupdate | forcheckout | maxinitialtime
> | project | size | architecture | description | usage | basedoffrevisionid |
> +----+----------------------+------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
> | 4 | noimage | No Image | 1 | 1 | 2 | NULL | 0 | 1 | 0 | 10 | NULL | 0
> | 0 | 0 | NULL | 0 | 0 | vcl | 1450 | x86 | NULL | NULL | 0 |
> | 7 | vmwarewinxp-base7-v1 | No Apps (WinXP vmware) | 1 | 1 | 16 | NULL
> | 512 | 1 | 1024 | 100 | NULL | 5 | 0 | 0 | 2010-11-12 17:08:54 | 1 | 0
> | vcl | 1500 | x86 | NULL | NULL | 0 |
> +----+----------------------+------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
> 2 rows in set (0.00 sec)
>
> mysql> select * from imagerevision;
> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+----------------------+
> | id | imageid | revision | userid | datecreated | deleted | datedeleted
> | production | comments | imagename |
> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+----------------------+
> | 4 | 4 | 0 | 1 | 1980-01-01 00:00:00 | 0 | NULL | 1 | NULL | noimage |
> | 5 | 7 | 1 | 1 | 2010-11-12 17:09:18 | 0 | NULL | 1 | NULL |
> vmwarewinxp-base7-v1 |
> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+----------------------+
> 2 rows in set (0.00 sec)
>
> mysql> select * from managementnode;
> +----+--------------+----------------+---------+---------+---------------------+-----------------+-------------+----------------+-----------------+--------------+-------------+------------------+--------------------+---------+-----------------------+------------------+----------------------+-----------------+----------------------------------------------------+---------------+----------------+
> | id | IPaddress | hostname | ownerid | stateid | lastcheckin |
> checkininterval | installpath | imagelibenable | imagelibgroupid |
> imagelibuser | imagelibkey | keys | predictivemoduleid | sshport |
> publicIPconfiguration | publicSubnetMask | publicDefaultGateway |
> publicDNSserver | sysadminEmailAddress | sharedMailBox | NOT_STANDALONE |
> +----+--------------+----------------+---------+---------+---------------------+-----------------+-------------+----------------+-----------------+--------------+-------------+------------------+--------------------+---------+-----------------------+------------------+----------------------+-----------------+----------------------------------------------------+---------------+----------------+
> | 1 | 192.168.1.40 | vcl.ndi.com.mx | 1 | 2 | 2010-11-24 10:12:07 | 5 |
> /install | 0 | NULL | NULL | NULL | /etc/vcl/vcl.key | 8 | 22 |
> dynamicDHCP | NULL | NULL | NULL |
> mramirez@nextdata.com.mx,gcarbajal@nextdata.com.mx | NULL | NULL |
> +----+--------------+----------------+---------+---------+---------------------+-----------------+-------------+----------------+-----------------+--------------+-------------+------------------+--------------------+---------+-----------------------+------------------+----------------------+-----------------+----------------------------------------------------+---------------+----------------+
> 1 row in set (0.00 sec)
>
> mysql>
>
> On 24/11/10 08:02, Andy Kurth wrote:
>> It looks like something isn't correct in the database. The reservation
>> isn't being processed at all because vcld is unable to gather all of
>> the information it needs from the database. The only way to
>> troubleshoot this is by looking at the tables. Please include the
>> output from the following commands run from your database server:
>>
>> select * from request;
>> select * from reservation;
>> select * from computer;
>> select * from vmhost;
>> select * from image;
>> select * from imagerevision;
>> select * from managementnode;
>>
>> Regards,
>> Andy
>>
>>
>> On 11/19/2010 12:59 PM, Mauricio Cesar Ramirez Torres wrote:
>>> Good day, annex the last lines of vcld.log, verify that the username and
>>> password access to mysql, but marks a warning.
>>>
>>> I appreciate your comments.
>>>
>>>
>>>
>>> |6232|1:2|image| 2010-11-19
>>> 11:56:42|6232|1:2|image|utils.pm:get_request_info(4364)|request id 1
>>> information could not be retrieved
>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>> |6232|1:2|image| (-1) utils.pm, get_request_info (line: 4364)
>>> |6232|1:2|image| (-2) vcld, main (line: 281)
>>>
>>>
>>> |6232|1:2|image| ---- WARNING ----
>>> |6232|1:2|image| 2010-11-19 11:56:42|6232|1:2|image|vcld:main(294)|could
>>> not retrieve request information from database
>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>> |6232|1:2|image| (-1) vcld, main (line: 294)
>>>
>>> 2010-11-19 11:56:47|6232|vcld:main(166)|lastcheckin time updated for
>>> management node 1: 2010-11-19 11:56:47
>>> 2010-11-19
>>> 11:56:47|6232|1:2|image|utils.pm:reservation_being_processed(9010)|computerloadlog
>>>
>>> 'begin' entry does NOT exist for reservation 2
>>> 2010-11-19 11:56:47|6232|1:2|image|utils.pm:run_command(9082)|executed
>>> command: pgrep -fl 'vcld [0-9]+:2 ', pid: 26958, exit status: 1, output:
>>> 2010-11-19
>>> 11:56:47|6232|1:2|image|utils.pm:is_management_node_process_running(9259)|process
>>>
>>> is NOT running, identifier: 'vcld [0-9]+:2 '
>>> 2010-11-19
>>> 11:56:47|6232|1:2|image|utils.pm:reservation_being_processed(9031)|reservation
>>>
>>> is NOT currently being processed
>>> 2010-11-19 11:56:47|6232|1:2|image|vcld:main(277)|reservation 2 is NOT
>>> already being processed
>>>
>>> |6232|1:2|image| ---- WARNING ----
>>> |6232|1:2|image| 2010-11-19
>>> 11:56:47|6232|1:2|image|utils.pm:get_request_info(4364)|request id 1
>>> information could not be retrieved
>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>> |6232|1:2|image| (-1) utils.pm, get_request_info (line: 4364)
>>> |6232|1:2|image| (-2) vcld, main (line: 281)
>>>
>>>
>>> |6232|1:2|image| ---- WARNING ----
>>> |6232|1:2|image| 2010-11-19 11:56:47|6232|1:2|image|vcld:main(294)|could
>>> not retrieve request information from database
>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>> |6232|1:2|image| (-1) vcld, main (line: 294)
>>>
>>>
>>> On 18/11/10 18:13, Andy Kurth wrote:
>>>> Hello,
>>>> Please include the vcld.log output.
>>>> Regards,
>>>> Andy
>>>>
>>>> Mauricio Cesar Ramirez Torres wrote:
>>>>> Hi, I'm working in a RHEL 5.5 VCL 2 VMware Server 2 Local Storage,
>>>>> all this is installed in the same server (Dell Power Edge R510) 2
>>>>> NIC's, all was installed with the manual instructions, seemingly all
>>>>> is fine, but when I try to make a reservation status remains pending
>>>>> until the period ends the reservation and in the statistics shows
>>>>> that the reservation was never used.
>>>>>
>>>>> When I click on the "pending" state shows the detail of reservation
>>>>> status and the time consumed by each task and the last item shown is
>>>>> ready to connect and do not know what to do to determine what is
>>>>> happening.
>>>>>
>>>>> In an earlier attempt had failed received emails when creating the
>>>>> reservation, but now I don't receive it and I think the settings are
>>>>> the same.
>>>>>
>>>>> Can someone help me identify my error.
>>>>>
>>>>> Thanks in advance.
>>>>>
>>>>> Mauricio.
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> -----------------------------------------------------------------------------------------------------------------
>>>>>
>>>>>
>>>>> Antes de imprimir este correo electrónico, piensa bien si es
>>>>> imprescindible hacerlo. El Medio Ambiente es cosa de todos.
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>>
>>>
>>> -----------------------------------------------------------------------------------------------------------------
>>>
>>> Antes de imprimir este correo electrónico, piensa bien si es
>>> imprescindible hacerlo.
>>> El Medio Ambiente es cosa de todos.
>>>
>>>
>>>
>>
>>
>
>
>
> ------------------------------------------------------------------------
>
>
>
>
> -----------------------------------------------------------------------------------------------------------------
> Antes de imprimir este correo electrónico, piensa bien si es
> imprescindible hacerlo.
> El Medio Ambiente es cosa de todos.
>
>
>

Re: Reservation always in Pending-state

Posted by Andy Kurth <an...@ncsu.edu>.
Hello,
Which version of the VMware Perl SDK is installed on your management 
node?  I think I have seen this before with either the 4.0 or 4.1 
version of the SDK.  I can't recall which was installed, but 
uninstalling it via vmware-uninstall-vSphere-CLI.pl and then installing 
the other version fixed the problem.

-Andy


On 12/3/2010 2:59 PM, Mauricio Cesar Ramirez Torres wrote:
> Hi, make the change you suggest, but do not change anything in the
> process of reservation is kept "pending" during the whole period and I
> can not use a reservation, you can do me any suggestions, thanks in advance.
>
> Do yuo know how can I test if my SDK is correctly installed?
>
> This is the content of Current Reservations and Detailed Reservation Status.
>
>
> C/urrent Reservations
> You currently have the following normal reservations:
> Environment Starting Ending Initially requested Req ID Comp ID
> Management Node IP address Current State Last State Computer State
> Pending...
> Est: 1 min remaining No Apps (WinXP vmware) Friday, Dec 3rd, 12:45 pm
> Friday, Dec 3rd, 1:15 pm Friday, Dec 3rd, 11:24 am 26 2 vcl.ndi.com.mx
> 192.168.1.41 14 13 2
>
>
> This page will automatically update every 20 seconds until the
> Pending... reservation is ready.
>
>
>
> Detailed Reservation Status
> State Est/Act
> Time Total
> Time
> confirming image exists(22) 0:04/81:57 81:57
> starting load process(40) 0:06
> transferring image files to host server(27) 4:15
> creating configuration file(28) 0:02
> starting virtual machine(48) 0:03
> machine booting(46) 1:08
> running post configuration(9) 0:00
> resource ready(43) 0:00
> adding user account(41) 0:18
> ready for Connect(18) 0:00 /
>
>
> and this is the content of my vcld log (only the last lines)
>
> 2010-12-03 13:44:34|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:44:34
> 2010-12-03
> 13:44:34|26406|27:28|new|utils.pm:reservation_being_processed(9010)|computerloadlog
> 'begin' entry does NOT exist for reservation 28
> 2010-12-03 13:44:34|26406|27:28|new|utils.pm:run_command(9082)|executed
> command: pgrep -fl 'vcld [0-9]+:28 ', pid: 7921, exit status: 1, output:
> 2010-12-03
> 13:44:34|26406|27:28|new|utils.pm:is_management_node_process_running(9259)|process
> is NOT running, identifier: 'vcld [0-9]+:28 '
> 2010-12-03
> 13:44:34|26406|27:28|new|utils.pm:reservation_being_processed(9031)|reservation
> is NOT currently being processed
> 2010-12-03 13:44:34|26406|27:28|new|vcld:main(277)|reservation 28 is NOT
> already being processed
> 2010-12-03
> 13:44:34|26406|27:28|new|utils.pm:get_request_info(4589)|standalone
> affiliation found: Local
> 2010-12-03 13:44:34|26406|27:28|new|vcld:main(282)|retrieved request
> information from database
> 2010-12-03
> 13:44:34|26406|27:28|new|DataStructure.pm:is_parent_reservation(943)|returning
> true: parent reservation ID for this request: 28
> 2010-12-03
> 13:44:34|26406|27:28|new|utils.pm:update_request_state(2049)|request 27
> state updated to: pending, laststate to: new
> 2010-12-03
> 13:44:34|26406|27:28|new|utils.pm:insertloadlog(3933)|inserted
> computer=2, begin, beginning to process, state is new
> 2010-12-03 13:44:34|26406|27:28|new|vcld:make_new_child(510)|loaded
> VCL::new module
> 2010-12-03 13:44:34|7935|27:28|new|vcld:make_new_child(583)|vcld
> environment variable set to 0 for this process
> 2010-12-03 13:44:34|7935|27:28|new|Module.pm:new(134)|constructor
> called, class=VCL::new
> 2010-12-03 13:44:34|26406|27:28|new|vcld:make_new_child(567)|current
> number of forked kids: 1
> 2010-12-03 13:44:34|7935|27:28|new|Module.pm:new(156)|VCL::new object
> created
> 2010-12-03 13:44:34|7935|27:28|new|State.pm:initialize(85)|obtained a
> database handle for this state process, stored as $ENV{dbh}
> 2010-12-03 13:44:34|7935|27:28|new|State.pm:check_image_os(817)|no
> corrections need to be made, not an imaging request, returning 1
> 2010-12-03
> 13:44:34|7935|27:28|new|DataStructure.pm:is_parent_reservation(943)|returning
> true: parent reservation ID for this request: 28
> 2010-12-03
> 13:44:34|7935|27:28|new|utils.pm:rename_vcld_process(7183)|reservation
> count: 1
> 2010-12-03
> 13:44:34|7935|27:28|new|utils.pm:rename_vcld_process(7202)|PARENTIMAGE: 1
> 2010-12-03
> 13:44:34|7935|27:28|new|utils.pm:rename_vcld_process(7203)|SUBIMAGE: 0
> 2010-12-03
> 13:44:34|7935|27:28|new|utils.pm:rename_vcld_process(7221)|renamed
> process to 'vcld 27:28 new vmware1 vmwarewinxp-base7-v1 admin (imaging)'
> 2010-12-03
> 13:44:34|7935|27:28|new|DataStructure.pm:is_parent_reservation(943)|returning
> true: parent reservation ID for this request: 28
> 2010-12-03
> 13:44:34|7935|27:28|new|DataStructure.pm:is_parent_reservation(943)|returning
> true: parent reservation ID for this request: 28
> 2010-12-03 13:44:34|7935|27:28|new|State.pm:initialize(118)|attempting
> to load provisioning module: VCL::Module::Provisioning::VMware::VMware
> 2010-12-03
> 13:44:34|7935|27:28|new|State.pm:initialize(124)|VCL::Module::Provisioning::VMware::VMware
> module loaded
> 2010-12-03 13:44:34|7935|27:28|new|Module.pm:new(134)|constructor
> called, class=VCL::Module::Provisioning::VMware::VMware
> 2010-12-03
> 13:44:34|7935|27:28|new|Module.pm:new(156)|VCL::Module::Provisioning::VMware::VMware
> object created
> 2010-12-03
> 13:44:34|7935|27:28|new|DataStructure.pm:_initialize(594)|computer ID
> argument was specified, retrieving data for computer ID: 1
> 2010-12-03
> 13:44:34|7935|27:28|new|VMware.pm:get_vmhost_datastructure(923)|created
> DataStructure object for VM host: vcl.ndi.com.mx
> 2010-12-03
> 13:44:34|7935|27:28|new|DataStructure.pm:_initialize(594)|computer ID
> argument was specified, retrieving data for computer ID: 1
> 2010-12-03
> 13:44:34|7935|27:28|new|VMware.pm:get_vmhost_datastructure(923)|created
> DataStructure object for VM host: vcl.ndi.com.mx
> 2010-12-03
> 13:44:34|7935|27:28|new|VMware.pm:get_vmhost_api_object(1027)|attempting
> to load VMware control module:
> VCL::Module::Provisioning::VMware::vSphere_SDK
> 2010-12-03
> 13:44:34|7935|27:28|new|VMware.pm:get_vmhost_api_object(1033)|loaded
> VMware control module: VCL::Module::Provisioning::VMware::vSphere_SDK
> 2010-12-03 13:44:34|7935|27:28|new|Module.pm:new(134)|constructor
> called, class=VCL::Module::Provisioning::VMware::vSphere_SDK
> 2010-12-03
> 13:44:34|7935|27:28|new|Module.pm:new(156)|VCL::Module::Provisioning::VMware::vSphere_SDK
> object created
> 2010-12-03
> 13:44:34|7935|27:28|new|vSphere_SDK.pm:initialize(1816)|attempting to
> connect to VM host: https://vcl.ndi.com.mx/sdk
> 2010-12-03
> 13:44:34|7935|27:28|new|vSphere_SDK.pm:initialize(1822)|unable to
> connect to VM host: https://vcl.ndi.com.mx/sdk, username: 'root', error:
> |7935|27:28|new| Server version unavailable at
> 'https://vcl.ndi.com.mx:443/sdk/vimService.wsdl' at
> /usr/lib/perl5/site_perl/5.8.8/VMware/VICommon.pm line 545.
> 2010-12-03
> 13:44:34|7935|27:28|new|vSphere_SDK.pm:initialize(1816)|attempting to
> connect to VM host: https://vcl.ndi.com.mx:8333/sdk
> 2010-12-03
> 13:44:34|7935|27:28|new|vSphere_SDK.pm:initialize(1826)|connected to VM
> host: https://vcl.ndi.com.mx:8333/sdk
> 2010-12-03
> 13:44:34|7935|27:28|new|VMware.pm:get_vmhost_api_object(1046)|created
> API object: VCL::Module::Provisioning::VMware::vSphere_SDK
> 2010-12-03
> 13:44:35|7935|27:28|new|vSphere_SDK.pm:is_restricted(1079)|access to the
> VM host via the vSphere SDK is NOT restricted due to the license
> 2010-12-03 13:44:35|7935|27:28|new|VMware.pm:initialize(229)|vSphere SDK
> object will be used to control the VM: vmware1, and to control the OS of
> the VM host: vcl.ndi.com.mx
> 2010-12-03 13:44:39|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:44:39
> 2010-12-03 13:44:44|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:44:44
> 2010-12-03 13:44:49|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:44:49
> 2010-12-03 13:44:54|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:44:54
> 2010-12-03 13:44:59|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:44:59
> 2010-12-03 13:45:04|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:04
> 2010-12-03 13:45:09|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:09
> 2010-12-03 13:45:14|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:14
> 2010-12-03 13:45:19|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:19
> 2010-12-03 13:45:24|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:24
> 2010-12-03 13:45:29|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:29
> 2010-12-03 13:45:34|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:34
> 2010-12-03 13:45:35|7935|27:28|new|utils.pm:mail(1247)|SUCCESS --
> Sending mail To: mramirez@nextdata.com.mx,gcarbajal@nextdata.com.mx,
> PROBLEM -- vcld
>
> |7935|27:28|new| ---- CRITICAL ----
> |7935|27:28|new| 2010-12-03
> 13:44:35|7935|27:28|new|vcld:die_handler(663)|SOAP Fault:
> |7935|27:28|new| -----------
> |7935|27:28|new| Fault string:
> |7935|27:28|new| Fault detail: InvalidPropertyFault
> |7935|27:28|new| ( 0) utils.pm, notify (line: 630)
> |7935|27:28|new| (-1) vcld, die_handler (line: 663)
> |7935|27:28|new| (-2) Carp.pm, confess (line: 270)
> |7935|27:28|new| (-3) VICommon.pm, check_fault (line: 28)
> |7935|27:28|new| (-4) VICommon.pm, find_entity_view (line: 1263)
> |7935|27:28|new| (-5) VIExt.pm, get_host_view (line: 50)
> |7935|27:28|new| (-6) vSphere_SDK.pm, get_vmware_product_name (line: 951)
>
> 2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(902)|destructor
> called, ref($self)=VCL::new
> 2010-12-03
> 13:45:35|7935|27:28|new|utils.pm:delete_computerloadlog_reservation(6829)|removing
> computerloadlog entries matching loadstate = begin
> 2010-12-03
> 13:45:35|7935|27:28|new|utils.pm:delete_computerloadlog_reservation(6876)|deleted
> rows from computerloadlog for reservation id=28
> 2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(909)|removed
> computerloadlog rows with loadstate=begin for reservation
> 2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(921)|number of
> database handles state process created: 1
> 2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(930)|process has a
> database handle stored in $ENV{dbh}, attempting disconnect
> 2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(932)|$ENV{dbh}:
> database disconnect successful
> 2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(946)|VCL::new
> process 7935 exiting
> 2010-12-03 13:45:35|26406|vcld:REAPER(745)|VCL process exited for
> reservation 28, PID: 7935, signal: CHLD
> 2010-12-03 13:45:35|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:35
> 2010-12-03 13:45:40|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:40
> 2010-12-03 13:45:45|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:45
> 2010-12-03 13:45:50|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:50
> 2010-12-03 13:45:55|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:45:55
> 2010-12-03 13:46:00|26406|vcld:main(166)|lastcheckin time updated for
> management node 1: 2010-12-03 13:46:00
>
>
>
>
> On 03/12/10 09:06, Andy Kurth wrote:
>> Hello,
>> Sorry for the delay. I believe the problem is caused by the
>> imagerevision ID. The value set for the request is 7 but there is no
>> entry in the imagerevision table with ID=7. The imagerevision entry
>> for your new image is 5. Change reservation.imagerevisionid to 5. This
>> should allow the imaging reservation to proceed.
>>
>> Hope this helps,
>> Andy
>>
>> On 11/24/2010 11:16 AM, Mauricio Cesar Ramirez Torres wrote:
>>> This is the content in my database.
>>>
>>>
>>> Last login: Tue Nov 23 18:42:53 2010
>>> [root@vcl ~]# mysql
>>> Welcome to the MySQL monitor. Commands end with ; or \g.
>>> Your MySQL connection id is 66394
>>> Server version: 5.0.77 Source distribution
>>>
>>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>>
>>> mysql> use vcl;
>>> Reading table information for completion of table and column names
>>> You can turn off this feature to get a quicker startup with -A
>>>
>>> Database changed
>>> mysql> select * from request;
>>> +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+
>>>
>>> | id | stateid | userid | laststateid | logid | forimaging | test |
>>> preload | start | end | daterequested | datemodified | checkuser |
>>> +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+
>>>
>>> | 1 | 16 | 1 | 16 | 0 | 1 | 0 | 0 | 2010-11-12 17:10:06 | 2010-11-12
>>> 19:10:06 | 2010-11-12 17:10:06 | NULL | 1 |
>>> | 10 | 14 | 1 | 13 | 3 | 0 | 0 | 0 | 2010-11-16 16:45:00 | 2010-11-16
>>> 18:00:00 | 2010-11-16 16:54:44 | NULL | 1 |
>>> | 12 | 14 | 1 | 13 | 4 | 0 | 0 | 0 | 2010-11-16 18:45:00 | 2010-11-16
>>> 19:15:00 | 2010-11-16 18:01:36 | NULL | 1 |
>>> | 13 | 14 | 2 | 19 | 0 | 0 | 0 | 0 | 2010-11-16 18:45:00 | 2010-11-16
>>> 19:05:00 | 2010-11-16 18:52:07 | NULL | 1 |
>>> | 14 | 14 | 1 | 13 | 5 | 0 | 0 | 0 | 2010-11-17 17:15:00 | 2010-11-17
>>> 18:00:00 | 2010-11-17 17:22:47 | NULL | 1 |
>>> | 15 | 14 | 1 | 13 | 6 | 0 | 0 | 0 | 2010-11-17 18:15:00 | 2010-11-17
>>> 19:00:00 | 2010-11-17 18:26:02 | NULL | 1 |
>>> | 16 | 14 | 1 | 13 | 7 | 0 | 0 | 0 | 2010-11-18 13:30:00 | 2010-11-18
>>> 14:15:00 | 2010-11-18 13:32:22 | NULL | 1 |
>>> | 17 | 14 | 1 | 13 | 8 | 0 | 0 | 0 | 2010-11-18 16:30:00 | 2010-11-18
>>> 17:15:00 | 2010-11-18 16:32:26 | NULL | 1 |
>>> | 18 | 14 | 1 | 13 | 10 | 0 | 0 | 0 | 2010-11-18 17:30:00 | 2010-11-18
>>> 18:00:00 | 2010-11-18 17:01:08 | NULL | 1 |
>>> | 19 | 14 | 1 | 13 | 11 | 0 | 0 | 0 | 2010-11-18 18:15:00 | 2010-11-18
>>> 18:45:00 | 2010-11-18 18:09:18 | NULL | 1 |
>>> | 20 | 14 | 1 | 13 | 12 | 0 | 0 | 0 | 2010-11-18 19:00:00 | 2010-11-18
>>> 19:45:00 | 2010-11-18 19:09:35 | NULL | 1 |
>>> | 21 | 14 | 1 | 13 | 13 | 0 | 0 | 0 | 2010-11-19 08:30:00 | 2010-11-19
>>> 09:15:00 | 2010-11-19 08:38:46 | NULL | 1 |
>>> +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+
>>>
>>> 12 rows in set (0.00 sec)
>>>
>>> mysql> select * from reservation;
>>> +----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
>>>
>>> | id | requestid | computerid | imageid | imagerevisionid |
>>> managementnodeid | remoteIP | lastcheck | pw |
>>> +----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
>>>
>>> | 2 | 1 | 2 | 7 | 7 | 1 | NULL | NULL | NULL |
>>> | 11 | 10 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>>> | 13 | 12 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>>> | 14 | 13 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>>> | 15 | 14 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>>> | 16 | 15 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>>> | 17 | 16 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>>> | 18 | 17 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>>> | 19 | 18 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>>> | 20 | 19 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>>> | 21 | 20 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>>> | 22 | 21 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>>> +----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
>>>
>>> 12 rows in set (0.00 sec)
>>>
>>> mysql> select * from computer;
>>> +----+---------+---------+------------+------------+----------------+-------------+-----------------+-------+------------+-----------+---------+----------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+----------------------------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
>>>
>>> | id | stateid | ownerid | platformid | scheduleid | currentimageid |
>>> nextimageid | imagerevisionid | RAM | procnumber | procspeed | network |
>>> hostname | IPaddress | privateIPaddress | eth0macaddress |
>>> eth1macaddress | type | provisioningid | drivetype | deleted | notes |
>>> lastcheck | location | dsa | dsapub | rsa | rsapub | host | hostpub |
>>> vmhostid | vmtypeid |
>>> +----+---------+---------+------------+------------+----------------+-------------+-----------------+-------+------------+-----------+---------+----------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+----------------------------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
>>>
>>> | 1 | 20 | 1 | 1 | 1 | 4 | 4 | 4 | 62000 | 8 | 3000 | 1000 |
>>> vcl.ndi.com.mx | 192.168.1.40 | NULL | NULL | NULL | lab | 7 | hda | 0 |
>>> admin 2010-11-16 16:37:30@ | NULL | NULL | NULL | NULL | NULL | NULL |
>>> NULL | NULL | NULL | NULL |
>>> | 2 | 2 | 1 | 1 | 1 | 4 | 4 | 4 | 2048 | 2 | 3000 | 100 | vmware1 |
>>> 192.168.1.41 | NULL | NULL | NULL | virtualmachine | 7 | hda | 0 | |
>>> NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL |
>>> +----+---------+---------+------------+------------+----------------+-------------+-----------------+-------+------------+-----------+---------+----------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+----------------------------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
>>>
>>> 2 rows in set (0.00 sec)
>>>
>>> mysql> select * from vmhost;
>>> +----+------------+---------+-------------+-------------+------------+
>>> | id | computerid | vmlimit | vmprofileid | vmkernalnic | vmwaredisk |
>>> +----+------------+---------+-------------+-------------+------------+
>>> | 1 | 1 | 6 | 2 | NULL | localdisk |
>>> +----+------------+---------+-------------+-------------+------------+
>>> 1 row in set (0.00 sec)
>>>
>>> mysql> select * from image;
>>> +----+----------------------+------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
>>>
>>> | id | name | prettyname | ownerid | platformid | OSid | imagemetaid |
>>> minram | minprocnumber | minprocspeed | minnetwork | maxconcurrent |
>>> reloadtime | deleted | test | lastupdate | forcheckout | maxinitialtime
>>> | project | size | architecture | description | usage |
>>> basedoffrevisionid |
>>> +----+----------------------+------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
>>>
>>> | 4 | noimage | No Image | 1 | 1 | 2 | NULL | 0 | 1 | 0 | 10 | NULL | 0
>>> | 0 | 0 | NULL | 0 | 0 | vcl | 1450 | x86 | NULL | NULL | 0 |
>>> | 7 | vmwarewinxp-base7-v1 | No Apps (WinXP vmware) | 1 | 1 | 16 | NULL
>>> | 512 | 1 | 1024 | 100 | NULL | 5 | 0 | 0 | 2010-11-12 17:08:54 | 1 | 0
>>> | vcl | 1500 | x86 | NULL | NULL | 0 |
>>> +----+----------------------+------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
>>>
>>> 2 rows in set (0.00 sec)
>>>
>>> mysql> select * from imagerevision;
>>> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+----------------------+
>>>
>>> | id | imageid | revision | userid | datecreated | deleted | datedeleted
>>> | production | comments | imagename |
>>> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+----------------------+
>>>
>>> | 4 | 4 | 0 | 1 | 1980-01-01 00:00:00 | 0 | NULL | 1 | NULL | noimage |
>>> | 5 | 7 | 1 | 1 | 2010-11-12 17:09:18 | 0 | NULL | 1 | NULL |
>>> vmwarewinxp-base7-v1 |
>>> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+----------------------+
>>>
>>> 2 rows in set (0.00 sec)
>>>
>>> mysql> select * from managementnode;
>>> +----+--------------+----------------+---------+---------+---------------------+-----------------+-------------+----------------+-----------------+--------------+-------------+------------------+--------------------+---------+-----------------------+------------------+----------------------+-----------------+----------------------------------------------------+---------------+----------------+
>>>
>>> | id | IPaddress | hostname | ownerid | stateid | lastcheckin |
>>> checkininterval | installpath | imagelibenable | imagelibgroupid |
>>> imagelibuser | imagelibkey | keys | predictivemoduleid | sshport |
>>> publicIPconfiguration | publicSubnetMask | publicDefaultGateway |
>>> publicDNSserver | sysadminEmailAddress | sharedMailBox |
>>> NOT_STANDALONE |
>>> +----+--------------+----------------+---------+---------+---------------------+-----------------+-------------+----------------+-----------------+--------------+-------------+------------------+--------------------+---------+-----------------------+------------------+----------------------+-----------------+----------------------------------------------------+---------------+----------------+
>>>
>>> | 1 | 192.168.1.40 | vcl.ndi.com.mx | 1 | 2 | 2010-11-24 10:12:07 | 5 |
>>> /install | 0 | NULL | NULL | NULL | /etc/vcl/vcl.key | 8 | 22 |
>>> dynamicDHCP | NULL | NULL | NULL |
>>> mramirez@nextdata.com.mx,gcarbajal@nextdata.com.mx | NULL | NULL |
>>> +----+--------------+----------------+---------+---------+---------------------+-----------------+-------------+----------------+-----------------+--------------+-------------+------------------+--------------------+---------+-----------------------+------------------+----------------------+-----------------+----------------------------------------------------+---------------+----------------+
>>>
>>> 1 row in set (0.00 sec)
>>>
>>> mysql>
>>>
>>> On 24/11/10 08:02, Andy Kurth wrote:
>>>> It looks like something isn't correct in the database. The reservation
>>>> isn't being processed at all because vcld is unable to gather all of
>>>> the information it needs from the database. The only way to
>>>> troubleshoot this is by looking at the tables. Please include the
>>>> output from the following commands run from your database server:
>>>>
>>>> select * from request;
>>>> select * from reservation;
>>>> select * from computer;
>>>> select * from vmhost;
>>>> select * from image;
>>>> select * from imagerevision;
>>>> select * from managementnode;
>>>>
>>>> Regards,
>>>> Andy
>>>>
>>>>
>>>> On 11/19/2010 12:59 PM, Mauricio Cesar Ramirez Torres wrote:
>>>>> Good day, annex the last lines of vcld.log, verify that the
>>>>> username and
>>>>> password access to mysql, but marks a warning.
>>>>>
>>>>> I appreciate your comments.
>>>>>
>>>>>
>>>>>
>>>>> |6232|1:2|image| 2010-11-19
>>>>> 11:56:42|6232|1:2|image|utils.pm:get_request_info(4364)|request id 1
>>>>> information could not be retrieved
>>>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>>>> |6232|1:2|image| (-1) utils.pm, get_request_info (line: 4364)
>>>>> |6232|1:2|image| (-2) vcld, main (line: 281)
>>>>>
>>>>>
>>>>> |6232|1:2|image| ---- WARNING ----
>>>>> |6232|1:2|image| 2010-11-19
>>>>> 11:56:42|6232|1:2|image|vcld:main(294)|could
>>>>> not retrieve request information from database
>>>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>>>> |6232|1:2|image| (-1) vcld, main (line: 294)
>>>>>
>>>>> 2010-11-19 11:56:47|6232|vcld:main(166)|lastcheckin time updated for
>>>>> management node 1: 2010-11-19 11:56:47
>>>>> 2010-11-19
>>>>> 11:56:47|6232|1:2|image|utils.pm:reservation_being_processed(9010)|computerloadlog
>>>>>
>>>>>
>>>>> 'begin' entry does NOT exist for reservation 2
>>>>> 2010-11-19 11:56:47|6232|1:2|image|utils.pm:run_command(9082)|executed
>>>>> command: pgrep -fl 'vcld [0-9]+:2 ', pid: 26958, exit status: 1,
>>>>> output:
>>>>> 2010-11-19
>>>>> 11:56:47|6232|1:2|image|utils.pm:is_management_node_process_running(9259)|process
>>>>>
>>>>>
>>>>> is NOT running, identifier: 'vcld [0-9]+:2 '
>>>>> 2010-11-19
>>>>> 11:56:47|6232|1:2|image|utils.pm:reservation_being_processed(9031)|reservation
>>>>>
>>>>>
>>>>> is NOT currently being processed
>>>>> 2010-11-19 11:56:47|6232|1:2|image|vcld:main(277)|reservation 2 is NOT
>>>>> already being processed
>>>>>
>>>>> |6232|1:2|image| ---- WARNING ----
>>>>> |6232|1:2|image| 2010-11-19
>>>>> 11:56:47|6232|1:2|image|utils.pm:get_request_info(4364)|request id 1
>>>>> information could not be retrieved
>>>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>>>> |6232|1:2|image| (-1) utils.pm, get_request_info (line: 4364)
>>>>> |6232|1:2|image| (-2) vcld, main (line: 281)
>>>>>
>>>>>
>>>>> |6232|1:2|image| ---- WARNING ----
>>>>> |6232|1:2|image| 2010-11-19
>>>>> 11:56:47|6232|1:2|image|vcld:main(294)|could
>>>>> not retrieve request information from database
>>>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>>>> |6232|1:2|image| (-1) vcld, main (line: 294)
>>>>>
>>>>>
>>>>> On 18/11/10 18:13, Andy Kurth wrote:
>>>>>> Hello,
>>>>>> Please include the vcld.log output.
>>>>>> Regards,
>>>>>> Andy
>>>>>>
>>>>>> Mauricio Cesar Ramirez Torres wrote:
>>>>>>> Hi, I'm working in a RHEL 5.5 VCL 2 VMware Server 2 Local Storage,
>>>>>>> all this is installed in the same server (Dell Power Edge R510) 2
>>>>>>> NIC's, all was installed with the manual instructions, seemingly all
>>>>>>> is fine, but when I try to make a reservation status remains pending
>>>>>>> until the period ends the reservation and in the statistics shows
>>>>>>> that the reservation was never used.
>>>>>>>
>>>>>>> When I click on the "pending" state shows the detail of reservation
>>>>>>> status and the time consumed by each task and the last item shown is
>>>>>>> ready to connect and do not know what to do to determine what is
>>>>>>> happening.
>>>>>>>
>>>>>>> In an earlier attempt had failed received emails when creating the
>>>>>>> reservation, but now I don't receive it and I think the settings are
>>>>>>> the same.
>>>>>>>
>>>>>>> Can someone help me identify my error.
>>>>>>>
>>>>>>> Thanks in advance.
>>>>>>>
>>>>>>> Mauricio.
>>>>>>>
>>>>>>>
>>>>>>> ------------------------------------------------------------------------
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> -----------------------------------------------------------------------------------------------------------------
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Antes de imprimir este correo electrónico, piensa bien si es
>>>>>>> imprescindible hacerlo. El Medio Ambiente es cosa de todos.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> -----------------------------------------------------------------------------------------------------------------
>>>>>
>>>>>
>>>>> Antes de imprimir este correo electrónico, piensa bien si es
>>>>> imprescindible hacerlo.
>>>>> El Medio Ambiente es cosa de todos.
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>>
>>>
>>> -----------------------------------------------------------------------------------------------------------------
>>>
>>> Antes de imprimir este correo electrónico, piensa bien si es
>>> imprescindible hacerlo.
>>> El Medio Ambiente es cosa de todos.
>>>
>>>
>>>
>>
>>
>
>
>
> ------------------------------------------------------------------------
>
>
>
>
> -----------------------------------------------------------------------------------------------------------------
> Antes de imprimir este correo electrónico, piensa bien si es
> imprescindible hacerlo.
> El Medio Ambiente es cosa de todos.
>
>
>

Re: Reservation always in Pending-state

Posted by Mauricio Cesar Ramirez Torres <mr...@cft.com.mx>.
Hi, make the change you suggest, but do not change anything in the
process of reservation is kept "pending" during the whole period and I
can not use a reservation, you can do me any suggestions, thanks in advance.

Do yuo know how can I test if my SDK is correctly installed?

This is the content of Current Reservations and Detailed Reservation Status.


C/urrent Reservations
You currently have the following normal reservations:
 Environment Starting Ending Initially requested Req ID Comp ID
Management Node IP address Current State Last State Computer State
Pending...
Est: 1 min remaining        No Apps (WinXP vmware) Friday, Dec 3rd,
12:45 pm Friday, Dec 3rd, 1:15 pm Friday, Dec 3rd, 11:24 am 26 2
vcl.ndi.com.mx 192.168.1.41 14 13 2


This page will automatically update every 20 seconds until the
Pending... reservation is ready. 



Detailed Reservation Status
State Est/Act
Time Total
Time
confirming image exists(22) 0:04/81:57 81:57
starting load process(40) 0:06 
transferring image files to host server(27) 4:15 
creating configuration file(28) 0:02 
starting virtual machine(48) 0:03 
machine booting(46) 1:08 
running post configuration(9) 0:00 
resource ready(43) 0:00 
adding user account(41) 0:18 
ready for Connect(18) 0:00 /


and this is the content of my vcld log (only the last lines)

2010-12-03 13:44:34|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:44:34
2010-12-03
13:44:34|26406|27:28|new|utils.pm:reservation_being_processed(9010)|computerloadlog
'begin' entry does NOT exist for reservation 28
2010-12-03 13:44:34|26406|27:28|new|utils.pm:run_command(9082)|executed
command: pgrep -fl 'vcld [0-9]+:28 ', pid: 7921, exit status: 1, output:
2010-12-03
13:44:34|26406|27:28|new|utils.pm:is_management_node_process_running(9259)|process
is NOT running, identifier: 'vcld [0-9]+:28 '
2010-12-03
13:44:34|26406|27:28|new|utils.pm:reservation_being_processed(9031)|reservation
is NOT currently being processed
2010-12-03 13:44:34|26406|27:28|new|vcld:main(277)|reservation 28 is NOT
already being processed
2010-12-03
13:44:34|26406|27:28|new|utils.pm:get_request_info(4589)|standalone
affiliation found: Local
2010-12-03 13:44:34|26406|27:28|new|vcld:main(282)|retrieved request
information from database
2010-12-03
13:44:34|26406|27:28|new|DataStructure.pm:is_parent_reservation(943)|returning
true: parent reservation ID for this request: 28
2010-12-03
13:44:34|26406|27:28|new|utils.pm:update_request_state(2049)|request 27
state updated to: pending, laststate to: new
2010-12-03
13:44:34|26406|27:28|new|utils.pm:insertloadlog(3933)|inserted
computer=2, begin, beginning to process, state is new
2010-12-03 13:44:34|26406|27:28|new|vcld:make_new_child(510)|loaded
VCL::new module
2010-12-03 13:44:34|7935|27:28|new|vcld:make_new_child(583)|vcld
environment variable set to 0 for this process
2010-12-03 13:44:34|7935|27:28|new|Module.pm:new(134)|constructor
called, class=VCL::new
2010-12-03 13:44:34|26406|27:28|new|vcld:make_new_child(567)|current
number of forked kids: 1
2010-12-03 13:44:34|7935|27:28|new|Module.pm:new(156)|VCL::new object
created
2010-12-03 13:44:34|7935|27:28|new|State.pm:initialize(85)|obtained a
database handle for this state process, stored as $ENV{dbh}
2010-12-03 13:44:34|7935|27:28|new|State.pm:check_image_os(817)|no
corrections need to be made, not an imaging request, returning 1
2010-12-03
13:44:34|7935|27:28|new|DataStructure.pm:is_parent_reservation(943)|returning
true: parent reservation ID for this request: 28
2010-12-03
13:44:34|7935|27:28|new|utils.pm:rename_vcld_process(7183)|reservation
count: 1
2010-12-03
13:44:34|7935|27:28|new|utils.pm:rename_vcld_process(7202)|PARENTIMAGE: 1
2010-12-03
13:44:34|7935|27:28|new|utils.pm:rename_vcld_process(7203)|SUBIMAGE: 0
2010-12-03
13:44:34|7935|27:28|new|utils.pm:rename_vcld_process(7221)|renamed
process to 'vcld 27:28 new vmware1 vmwarewinxp-base7-v1 admin (imaging)'
2010-12-03
13:44:34|7935|27:28|new|DataStructure.pm:is_parent_reservation(943)|returning
true: parent reservation ID for this request: 28
2010-12-03
13:44:34|7935|27:28|new|DataStructure.pm:is_parent_reservation(943)|returning
true: parent reservation ID for this request: 28
2010-12-03 13:44:34|7935|27:28|new|State.pm:initialize(118)|attempting
to load provisioning module: VCL::Module::Provisioning::VMware::VMware
2010-12-03
13:44:34|7935|27:28|new|State.pm:initialize(124)|VCL::Module::Provisioning::VMware::VMware
module loaded
2010-12-03 13:44:34|7935|27:28|new|Module.pm:new(134)|constructor
called, class=VCL::Module::Provisioning::VMware::VMware
2010-12-03
13:44:34|7935|27:28|new|Module.pm:new(156)|VCL::Module::Provisioning::VMware::VMware
object created
2010-12-03
13:44:34|7935|27:28|new|DataStructure.pm:_initialize(594)|computer ID
argument was specified, retrieving data for computer ID: 1
2010-12-03
13:44:34|7935|27:28|new|VMware.pm:get_vmhost_datastructure(923)|created
DataStructure object for VM host: vcl.ndi.com.mx
2010-12-03
13:44:34|7935|27:28|new|DataStructure.pm:_initialize(594)|computer ID
argument was specified, retrieving data for computer ID: 1
2010-12-03
13:44:34|7935|27:28|new|VMware.pm:get_vmhost_datastructure(923)|created
DataStructure object for VM host: vcl.ndi.com.mx
2010-12-03
13:44:34|7935|27:28|new|VMware.pm:get_vmhost_api_object(1027)|attempting
to load VMware control module:
VCL::Module::Provisioning::VMware::vSphere_SDK
2010-12-03
13:44:34|7935|27:28|new|VMware.pm:get_vmhost_api_object(1033)|loaded
VMware control module: VCL::Module::Provisioning::VMware::vSphere_SDK
2010-12-03 13:44:34|7935|27:28|new|Module.pm:new(134)|constructor
called, class=VCL::Module::Provisioning::VMware::vSphere_SDK
2010-12-03
13:44:34|7935|27:28|new|Module.pm:new(156)|VCL::Module::Provisioning::VMware::vSphere_SDK
object created
2010-12-03
13:44:34|7935|27:28|new|vSphere_SDK.pm:initialize(1816)|attempting to
connect to VM host: https://vcl.ndi.com.mx/sdk
2010-12-03
13:44:34|7935|27:28|new|vSphere_SDK.pm:initialize(1822)|unable to
connect to VM host: https://vcl.ndi.com.mx/sdk, username: 'root', error:
|7935|27:28|new| Server version unavailable at
'https://vcl.ndi.com.mx:443/sdk/vimService.wsdl' at
/usr/lib/perl5/site_perl/5.8.8/VMware/VICommon.pm line 545.
2010-12-03
13:44:34|7935|27:28|new|vSphere_SDK.pm:initialize(1816)|attempting to
connect to VM host: https://vcl.ndi.com.mx:8333/sdk
2010-12-03
13:44:34|7935|27:28|new|vSphere_SDK.pm:initialize(1826)|connected to VM
host: https://vcl.ndi.com.mx:8333/sdk
2010-12-03
13:44:34|7935|27:28|new|VMware.pm:get_vmhost_api_object(1046)|created
API object: VCL::Module::Provisioning::VMware::vSphere_SDK
2010-12-03
13:44:35|7935|27:28|new|vSphere_SDK.pm:is_restricted(1079)|access to the
VM host via the vSphere SDK is NOT restricted due to the license
2010-12-03 13:44:35|7935|27:28|new|VMware.pm:initialize(229)|vSphere SDK
object will be used to control the VM: vmware1, and to control the OS of
the VM host: vcl.ndi.com.mx
2010-12-03 13:44:39|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:44:39
2010-12-03 13:44:44|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:44:44
2010-12-03 13:44:49|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:44:49
2010-12-03 13:44:54|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:44:54
2010-12-03 13:44:59|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:44:59
2010-12-03 13:45:04|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:04
2010-12-03 13:45:09|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:09
2010-12-03 13:45:14|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:14
2010-12-03 13:45:19|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:19
2010-12-03 13:45:24|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:24
2010-12-03 13:45:29|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:29
2010-12-03 13:45:34|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:34
2010-12-03 13:45:35|7935|27:28|new|utils.pm:mail(1247)|SUCCESS --
Sending mail To: mramirez@nextdata.com.mx,gcarbajal@nextdata.com.mx,
PROBLEM -- vcld

|7935|27:28|new| ---- CRITICAL ----
|7935|27:28|new| 2010-12-03
13:44:35|7935|27:28|new|vcld:die_handler(663)|SOAP Fault:
|7935|27:28|new| -----------
|7935|27:28|new| Fault string:
|7935|27:28|new| Fault detail: InvalidPropertyFault
|7935|27:28|new| ( 0) utils.pm, notify (line: 630)
|7935|27:28|new| (-1) vcld, die_handler (line: 663)
|7935|27:28|new| (-2) Carp.pm, confess (line: 270)
|7935|27:28|new| (-3) VICommon.pm, check_fault (line: 28)
|7935|27:28|new| (-4) VICommon.pm, find_entity_view (line: 1263)
|7935|27:28|new| (-5) VIExt.pm, get_host_view (line: 50)
|7935|27:28|new| (-6) vSphere_SDK.pm, get_vmware_product_name (line: 951)

2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(902)|destructor
called, ref($self)=VCL::new
2010-12-03
13:45:35|7935|27:28|new|utils.pm:delete_computerloadlog_reservation(6829)|removing
computerloadlog entries matching loadstate = begin
2010-12-03
13:45:35|7935|27:28|new|utils.pm:delete_computerloadlog_reservation(6876)|deleted
rows from computerloadlog for reservation id=28
2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(909)|removed
computerloadlog rows with loadstate=begin for reservation
2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(921)|number of
database handles state process created: 1
2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(930)|process has a
database handle stored in $ENV{dbh}, attempting disconnect
2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(932)|$ENV{dbh}:
database disconnect successful
2010-12-03 13:45:35|7935|27:28|new|State.pm:DESTROY(946)|VCL::new
process 7935 exiting
2010-12-03 13:45:35|26406|vcld:REAPER(745)|VCL process exited for
reservation 28, PID: 7935, signal: CHLD
2010-12-03 13:45:35|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:35
2010-12-03 13:45:40|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:40
2010-12-03 13:45:45|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:45
2010-12-03 13:45:50|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:50
2010-12-03 13:45:55|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:45:55
2010-12-03 13:46:00|26406|vcld:main(166)|lastcheckin time updated for
management node 1: 2010-12-03 13:46:00




On 03/12/10 09:06, Andy Kurth wrote:
> Hello,
> Sorry for the delay.  I believe the problem is caused by the
> imagerevision ID.  The value set for the request is 7 but there is no
> entry in the imagerevision table with ID=7.  The imagerevision entry
> for your new image is 5.  Change reservation.imagerevisionid to 5. 
> This should allow the imaging reservation to proceed.
>
> Hope this helps,
> Andy
>
> On 11/24/2010 11:16 AM, Mauricio Cesar Ramirez Torres wrote:
>> This is the content in my database.
>>
>>
>> Last login: Tue Nov 23 18:42:53 2010
>> [root@vcl ~]# mysql
>> Welcome to the MySQL monitor. Commands end with ; or \g.
>> Your MySQL connection id is 66394
>> Server version: 5.0.77 Source distribution
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>
>> mysql> use vcl;
>> Reading table information for completion of table and column names
>> You can turn off this feature to get a quicker startup with -A
>>
>> Database changed
>> mysql> select * from request;
>> +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+
>>
>> | id | stateid | userid | laststateid | logid | forimaging | test |
>> preload | start | end | daterequested | datemodified | checkuser |
>> +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+
>>
>> | 1 | 16 | 1 | 16 | 0 | 1 | 0 | 0 | 2010-11-12 17:10:06 | 2010-11-12
>> 19:10:06 | 2010-11-12 17:10:06 | NULL | 1 |
>> | 10 | 14 | 1 | 13 | 3 | 0 | 0 | 0 | 2010-11-16 16:45:00 | 2010-11-16
>> 18:00:00 | 2010-11-16 16:54:44 | NULL | 1 |
>> | 12 | 14 | 1 | 13 | 4 | 0 | 0 | 0 | 2010-11-16 18:45:00 | 2010-11-16
>> 19:15:00 | 2010-11-16 18:01:36 | NULL | 1 |
>> | 13 | 14 | 2 | 19 | 0 | 0 | 0 | 0 | 2010-11-16 18:45:00 | 2010-11-16
>> 19:05:00 | 2010-11-16 18:52:07 | NULL | 1 |
>> | 14 | 14 | 1 | 13 | 5 | 0 | 0 | 0 | 2010-11-17 17:15:00 | 2010-11-17
>> 18:00:00 | 2010-11-17 17:22:47 | NULL | 1 |
>> | 15 | 14 | 1 | 13 | 6 | 0 | 0 | 0 | 2010-11-17 18:15:00 | 2010-11-17
>> 19:00:00 | 2010-11-17 18:26:02 | NULL | 1 |
>> | 16 | 14 | 1 | 13 | 7 | 0 | 0 | 0 | 2010-11-18 13:30:00 | 2010-11-18
>> 14:15:00 | 2010-11-18 13:32:22 | NULL | 1 |
>> | 17 | 14 | 1 | 13 | 8 | 0 | 0 | 0 | 2010-11-18 16:30:00 | 2010-11-18
>> 17:15:00 | 2010-11-18 16:32:26 | NULL | 1 |
>> | 18 | 14 | 1 | 13 | 10 | 0 | 0 | 0 | 2010-11-18 17:30:00 | 2010-11-18
>> 18:00:00 | 2010-11-18 17:01:08 | NULL | 1 |
>> | 19 | 14 | 1 | 13 | 11 | 0 | 0 | 0 | 2010-11-18 18:15:00 | 2010-11-18
>> 18:45:00 | 2010-11-18 18:09:18 | NULL | 1 |
>> | 20 | 14 | 1 | 13 | 12 | 0 | 0 | 0 | 2010-11-18 19:00:00 | 2010-11-18
>> 19:45:00 | 2010-11-18 19:09:35 | NULL | 1 |
>> | 21 | 14 | 1 | 13 | 13 | 0 | 0 | 0 | 2010-11-19 08:30:00 | 2010-11-19
>> 09:15:00 | 2010-11-19 08:38:46 | NULL | 1 |
>> +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+
>>
>> 12 rows in set (0.00 sec)
>>
>> mysql> select * from reservation;
>> +----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
>>
>> | id | requestid | computerid | imageid | imagerevisionid |
>> managementnodeid | remoteIP | lastcheck | pw |
>> +----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
>>
>> | 2 | 1 | 2 | 7 | 7 | 1 | NULL | NULL | NULL |
>> | 11 | 10 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>> | 13 | 12 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>> | 14 | 13 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>> | 15 | 14 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>> | 16 | 15 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>> | 17 | 16 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>> | 18 | 17 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>> | 19 | 18 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>> | 20 | 19 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>> | 21 | 20 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>> | 22 | 21 | 2 | 7 | 5 | 1 | NULL | 0000-00-00 00:00:00 | NULL |
>> +----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
>>
>> 12 rows in set (0.00 sec)
>>
>> mysql> select * from computer;
>> +----+---------+---------+------------+------------+----------------+-------------+-----------------+-------+------------+-----------+---------+----------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+----------------------------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
>>
>> | id | stateid | ownerid | platformid | scheduleid | currentimageid |
>> nextimageid | imagerevisionid | RAM | procnumber | procspeed | network |
>> hostname | IPaddress | privateIPaddress | eth0macaddress |
>> eth1macaddress | type | provisioningid | drivetype | deleted | notes |
>> lastcheck | location | dsa | dsapub | rsa | rsapub | host | hostpub |
>> vmhostid | vmtypeid |
>> +----+---------+---------+------------+------------+----------------+-------------+-----------------+-------+------------+-----------+---------+----------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+----------------------------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
>>
>> | 1 | 20 | 1 | 1 | 1 | 4 | 4 | 4 | 62000 | 8 | 3000 | 1000 |
>> vcl.ndi.com.mx | 192.168.1.40 | NULL | NULL | NULL | lab | 7 | hda | 0 |
>> admin 2010-11-16 16:37:30@ | NULL | NULL | NULL | NULL | NULL | NULL |
>> NULL | NULL | NULL | NULL |
>> | 2 | 2 | 1 | 1 | 1 | 4 | 4 | 4 | 2048 | 2 | 3000 | 100 | vmware1 |
>> 192.168.1.41 | NULL | NULL | NULL | virtualmachine | 7 | hda | 0 | |
>> NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL |
>> +----+---------+---------+------------+------------+----------------+-------------+-----------------+-------+------------+-----------+---------+----------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+----------------------------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
>>
>> 2 rows in set (0.00 sec)
>>
>> mysql> select * from vmhost;
>> +----+------------+---------+-------------+-------------+------------+
>> | id | computerid | vmlimit | vmprofileid | vmkernalnic | vmwaredisk |
>> +----+------------+---------+-------------+-------------+------------+
>> | 1 | 1 | 6 | 2 | NULL | localdisk |
>> +----+------------+---------+-------------+-------------+------------+
>> 1 row in set (0.00 sec)
>>
>> mysql> select * from image;
>> +----+----------------------+------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
>>
>> | id | name | prettyname | ownerid | platformid | OSid | imagemetaid |
>> minram | minprocnumber | minprocspeed | minnetwork | maxconcurrent |
>> reloadtime | deleted | test | lastupdate | forcheckout | maxinitialtime
>> | project | size | architecture | description | usage |
>> basedoffrevisionid |
>> +----+----------------------+------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
>>
>> | 4 | noimage | No Image | 1 | 1 | 2 | NULL | 0 | 1 | 0 | 10 | NULL | 0
>> | 0 | 0 | NULL | 0 | 0 | vcl | 1450 | x86 | NULL | NULL | 0 |
>> | 7 | vmwarewinxp-base7-v1 | No Apps (WinXP vmware) | 1 | 1 | 16 | NULL
>> | 512 | 1 | 1024 | 100 | NULL | 5 | 0 | 0 | 2010-11-12 17:08:54 | 1 | 0
>> | vcl | 1500 | x86 | NULL | NULL | 0 |
>> +----+----------------------+------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
>>
>> 2 rows in set (0.00 sec)
>>
>> mysql> select * from imagerevision;
>> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+----------------------+
>>
>> | id | imageid | revision | userid | datecreated | deleted | datedeleted
>> | production | comments | imagename |
>> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+----------------------+
>>
>> | 4 | 4 | 0 | 1 | 1980-01-01 00:00:00 | 0 | NULL | 1 | NULL | noimage |
>> | 5 | 7 | 1 | 1 | 2010-11-12 17:09:18 | 0 | NULL | 1 | NULL |
>> vmwarewinxp-base7-v1 |
>> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+----------------------+
>>
>> 2 rows in set (0.00 sec)
>>
>> mysql> select * from managementnode;
>> +----+--------------+----------------+---------+---------+---------------------+-----------------+-------------+----------------+-----------------+--------------+-------------+------------------+--------------------+---------+-----------------------+------------------+----------------------+-----------------+----------------------------------------------------+---------------+----------------+
>>
>> | id | IPaddress | hostname | ownerid | stateid | lastcheckin |
>> checkininterval | installpath | imagelibenable | imagelibgroupid |
>> imagelibuser | imagelibkey | keys | predictivemoduleid | sshport |
>> publicIPconfiguration | publicSubnetMask | publicDefaultGateway |
>> publicDNSserver | sysadminEmailAddress | sharedMailBox |
>> NOT_STANDALONE |
>> +----+--------------+----------------+---------+---------+---------------------+-----------------+-------------+----------------+-----------------+--------------+-------------+------------------+--------------------+---------+-----------------------+------------------+----------------------+-----------------+----------------------------------------------------+---------------+----------------+
>>
>> | 1 | 192.168.1.40 | vcl.ndi.com.mx | 1 | 2 | 2010-11-24 10:12:07 | 5 |
>> /install | 0 | NULL | NULL | NULL | /etc/vcl/vcl.key | 8 | 22 |
>> dynamicDHCP | NULL | NULL | NULL |
>> mramirez@nextdata.com.mx,gcarbajal@nextdata.com.mx | NULL | NULL |
>> +----+--------------+----------------+---------+---------+---------------------+-----------------+-------------+----------------+-----------------+--------------+-------------+------------------+--------------------+---------+-----------------------+------------------+----------------------+-----------------+----------------------------------------------------+---------------+----------------+
>>
>> 1 row in set (0.00 sec)
>>
>> mysql>
>>
>> On 24/11/10 08:02, Andy Kurth wrote:
>>> It looks like something isn't correct in the database. The reservation
>>> isn't being processed at all because vcld is unable to gather all of
>>> the information it needs from the database. The only way to
>>> troubleshoot this is by looking at the tables. Please include the
>>> output from the following commands run from your database server:
>>>
>>> select * from request;
>>> select * from reservation;
>>> select * from computer;
>>> select * from vmhost;
>>> select * from image;
>>> select * from imagerevision;
>>> select * from managementnode;
>>>
>>> Regards,
>>> Andy
>>>
>>>
>>> On 11/19/2010 12:59 PM, Mauricio Cesar Ramirez Torres wrote:
>>>> Good day, annex the last lines of vcld.log, verify that the
>>>> username and
>>>> password access to mysql, but marks a warning.
>>>>
>>>> I appreciate your comments.
>>>>
>>>>
>>>>
>>>> |6232|1:2|image| 2010-11-19
>>>> 11:56:42|6232|1:2|image|utils.pm:get_request_info(4364)|request id 1
>>>> information could not be retrieved
>>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>>> |6232|1:2|image| (-1) utils.pm, get_request_info (line: 4364)
>>>> |6232|1:2|image| (-2) vcld, main (line: 281)
>>>>
>>>>
>>>> |6232|1:2|image| ---- WARNING ----
>>>> |6232|1:2|image| 2010-11-19
>>>> 11:56:42|6232|1:2|image|vcld:main(294)|could
>>>> not retrieve request information from database
>>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>>> |6232|1:2|image| (-1) vcld, main (line: 294)
>>>>
>>>> 2010-11-19 11:56:47|6232|vcld:main(166)|lastcheckin time updated for
>>>> management node 1: 2010-11-19 11:56:47
>>>> 2010-11-19
>>>> 11:56:47|6232|1:2|image|utils.pm:reservation_being_processed(9010)|computerloadlog
>>>>
>>>>
>>>> 'begin' entry does NOT exist for reservation 2
>>>> 2010-11-19 11:56:47|6232|1:2|image|utils.pm:run_command(9082)|executed
>>>> command: pgrep -fl 'vcld [0-9]+:2 ', pid: 26958, exit status: 1,
>>>> output:
>>>> 2010-11-19
>>>> 11:56:47|6232|1:2|image|utils.pm:is_management_node_process_running(9259)|process
>>>>
>>>>
>>>> is NOT running, identifier: 'vcld [0-9]+:2 '
>>>> 2010-11-19
>>>> 11:56:47|6232|1:2|image|utils.pm:reservation_being_processed(9031)|reservation
>>>>
>>>>
>>>> is NOT currently being processed
>>>> 2010-11-19 11:56:47|6232|1:2|image|vcld:main(277)|reservation 2 is NOT
>>>> already being processed
>>>>
>>>> |6232|1:2|image| ---- WARNING ----
>>>> |6232|1:2|image| 2010-11-19
>>>> 11:56:47|6232|1:2|image|utils.pm:get_request_info(4364)|request id 1
>>>> information could not be retrieved
>>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>>> |6232|1:2|image| (-1) utils.pm, get_request_info (line: 4364)
>>>> |6232|1:2|image| (-2) vcld, main (line: 281)
>>>>
>>>>
>>>> |6232|1:2|image| ---- WARNING ----
>>>> |6232|1:2|image| 2010-11-19
>>>> 11:56:47|6232|1:2|image|vcld:main(294)|could
>>>> not retrieve request information from database
>>>> |6232|1:2|image| ( 0) utils.pm, notify (line: 630)
>>>> |6232|1:2|image| (-1) vcld, main (line: 294)
>>>>
>>>>
>>>> On 18/11/10 18:13, Andy Kurth wrote:
>>>>> Hello,
>>>>> Please include the vcld.log output.
>>>>> Regards,
>>>>> Andy
>>>>>
>>>>> Mauricio Cesar Ramirez Torres wrote:
>>>>>> Hi, I'm working in a RHEL 5.5 VCL 2 VMware Server 2 Local Storage,
>>>>>> all this is installed in the same server (Dell Power Edge R510) 2
>>>>>> NIC's, all was installed with the manual instructions, seemingly all
>>>>>> is fine, but when I try to make a reservation status remains pending
>>>>>> until the period ends the reservation and in the statistics shows
>>>>>> that the reservation was never used.
>>>>>>
>>>>>> When I click on the "pending" state shows the detail of reservation
>>>>>> status and the time consumed by each task and the last item shown is
>>>>>> ready to connect and do not know what to do to determine what is
>>>>>> happening.
>>>>>>
>>>>>> In an earlier attempt had failed received emails when creating the
>>>>>> reservation, but now I don't receive it and I think the settings are
>>>>>> the same.
>>>>>>
>>>>>> Can someone help me identify my error.
>>>>>>
>>>>>> Thanks in advance.
>>>>>>
>>>>>> Mauricio.
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> -----------------------------------------------------------------------------------------------------------------
>>>>>>
>>>>>>
>>>>>>
>>>>>> Antes de imprimir este correo electrónico, piensa bien si es
>>>>>> imprescindible hacerlo. El Medio Ambiente es cosa de todos.
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> -----------------------------------------------------------------------------------------------------------------
>>>>
>>>>
>>>> Antes de imprimir este correo electrónico, piensa bien si es
>>>> imprescindible hacerlo.
>>>> El Medio Ambiente es cosa de todos.
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>>
>>
>> -----------------------------------------------------------------------------------------------------------------
>>
>> Antes de imprimir este correo electrónico, piensa bien si es
>> imprescindible hacerlo.
>> El Medio Ambiente es cosa de todos.
>>
>>
>>
>
>







-----------------------------------------------------------------------------------------------------------------
Antes de imprimir este correo electrónico, piensa bien si es imprescindible hacerlo. 
El Medio Ambiente es cosa de todos.