You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@vcl.apache.org by Mauricio Cesar Ramirez Torres <mr...@cft.com.mx> on 2010/11/18 00:28:07 UTC
Reservation always in Pending-state
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.
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.
Re: Reservation always in Pending-state
Posted by Andy Kurth <an...@ncsu.edu>.
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 Mauricio Cesar Ramirez Torres <mr...@cft.com.mx>.
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>.
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.
>
>
>
Re: Reservation always in Pending-state
Posted by Mauricio Cesar Ramirez Torres <mr...@cft.com.mx>.
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.
Re: Reservation always in Pending-state
Posted by Andy Kurth <an...@ncsu.edu>.
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.
>
>
>