Mailing-List: contact user-help@vcl.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@vcl.apache.org
Received-SPF: pass (athena.apache.org: domain of nbasilio@odu.edu designates
 128.82.96.116 as permitted sender)
From: "Basilio, Norvin" <nbasilio@odu.edu>
To: "'user@vcl.apache.org'" <user@vcl.apache.org>
Subject: RE: Problem when reservation is completed.
Thread-Topic: Problem when reservation is completed.
Thread-Index: 
 Ac1xgmSL56lebkqZSDeDpkgx8yEzawAKfVYAAAeAndD//9LoAIAAQnig///QugCAADyQwA==
Date: Fri, 3 Aug 2012 17:47:59 +0000
Message-ID: <FFA99CBB118318408A970E512653A7600BE5E0@JANEWAY.ts.odu.edu>
References: <FFA99CBB118318408A970E512653A7600BDE93@JANEWAY.ts.odu.edu>
 <9BF1B6BD-D2C6-45B7-8CD9-1CF03D0340A1@gmu.edu>
 <FFA99CBB118318408A970E512653A7600BE2E0@JANEWAY.ts.odu.edu>
 <7F6F763C-1702-400A-803F-5423A355CF09@gmu.edu>
 <FFA99CBB118318408A970E512653A7600BE38E@JANEWAY.ts.odu.edu>
 <38843691-1BF6-4F10-A656-833C1F1A9FEF@gmu.edu>
In-Reply-To: <38843691-1BF6-4F10-A656-833C1F1A9FEF@gmu.edu>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

I ran the query and it returned 8 for predictivemoduleid.

Norvin Basilio
nbasilio@odu.edu

-----Original Message-----
From: dchebota@gmu.edu [mailto:dchebota@gmu.edu]=20
Sent: Friday, August 03, 2012 1:18 PM
To: user@vcl.apache.org
Subject: Re: Problem when reservation is completed.


Does this SQL query return anything?=20
It should return one row, column predictivemoduleid should be 8 or 9.

SELECT
   managementnode.*,
   predictivemodule.name AS predictive_name,
   predictivemodule.prettyname AS predictive_prettyname,
   predictivemodule.description AS predictive_description,
   predictivemodule.perlpackage  AS predictive_perlpackage,
        state.name AS statename
   FROM
   managementnode,
   module predictivemodule,
        state
   WHERE
   managementnode.predictivemoduleid =3D predictivemodule.id
        AND managementnode.stateid =3D state.id AND managementnode.hostname=
 =3D 'vclMgmtNode.vcls.priv.odu.edu'


On Aug 3, 2012, at 12:13 , "Basilio, Norvin" <nbasilio@odu.edu> wrote:

> During that reservation it was set to "Predictive Loading Module Level 0"=
. I've also experienced this issue with "Predictive Loading Module Level 1"=
 in previous reservations.
>=20
> Norvin Basilio
> nbasilio@odu.edu
>=20
> -----Original Message-----
> From: dchebota@gmu.edu [mailto:dchebota@gmu.edu]
> Sent: Friday, August 03, 2012 12:09 PM
> To: user@vcl.apache.org
> Subject: Re: Problem when reservation is completed.
>=20
>=20
> Norvin
>=20
> Looks like the error is caused by "get_management_predictive_info(5436)|z=
ero rows were returned from database select".
>=20
> Can you check that management node has Predictive Loading Module set?
> It's under 'Management Nodes->Edit Mgm nodes'.
>=20
> You can also check in VCL database:
>=20
> SELECT predictivemoduleid FROM vcl.managementnode;
>=20
> You should get id 8 or 9, depends on what you have set PLM for this manag=
ement node.
>=20
> Thanks.
>=20
> On Aug 3, 2012, at 11:42 , "Basilio, Norvin" <nbasilio@odu.edu> wrote:
>=20
>> Sure here is the log for the reservation ID. It's a bit Long:
>>=20
>> ....
>=20
>> |10747|13:13|deleted| ---- WARNING ---- 13:13|deleted| 2012-08-03=20
>> |10747|09:31:44|10747|13:13|deleted|utils.pm:get_management_predictiv
>> |10747|e _info(5436)|zero rows were returned from database select=20
>> |10747|13:13|deleted| ( 0) utils.pm, get_management_predictive_info
>> |10747|(line: 5436) 13:13|deleted| (-1) DataStructure.pm,=20
>> |10747|get_next_image_dataStructure (line: 1218) 13:13|deleted| (-2)=20
>> |10747|reclaim.pm, insert_reload_and_exit (line: 198) 13:13|deleted|
>> |10747|(-3) reclaim.pm, process (line: 159) 13:13|deleted| (-4) vcld,=20
>> |10747|make_new_child (line: 571) 13:13|deleted| (-5) vcld, main
>> |10747|(line: 350)
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|DataStructure.pm:get_computer_private_ip
>> _ address(1630)|attempting to retrieve private IP address for=20
>> computer:
>> vcl485
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|DataStructure.pm:get_computer_private_ip
>> _ address(1634)|retrieved contents of /etc/hosts on this management=20
>> node, contains 7 lines
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|DataStructure.pm:get_computer_private_ip
>> _ address(1694)|returning IP address from /etc/hosts file:
>> 192.168.131.245
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:is_inblockrequest(5793)|zero
>> rows were returned from database select
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|DataStructure.pm:get_image_affiliation_n
>> a
>> me(2118)|image owner id: 1
>> 2012-08-03 09:31:44|10747|13:13|deleted|DataStructure.pm:retrieve_user_d=
ata(1401)|attempting to retrieve and store data for user: user.id =3D '1'
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|DataStructure.pm:retrieve_user_data(1464
>> )
>> |data has been retrieved for user: admin (id: 1)
>> 2012-08-03 09:31:44|10747|13:13|deleted|utils.pm:mail(1253)|SUCCESS=20
>> -- Sending mail To: nbasilio@odu.edu, PROBLEM --
>> vclMgmtNode|13:13|deleted|DataStructure.pm|vcl485>esxiHost1.vcls.priv.
>> odu.edu|vmwarewin7-Windows764bitBase4-v0|admin
>> |10747|13:13|deleted| ---- CRITICAL ---- 13:13|deleted| 2012-08-03=20
>> |10747|09:31:44|10747|13:13|deleted|DataStructure.pm:get_next_image_d
>> |10747|a taStructure(1220)|unable to obtain management node info for=20
>> |10747|this node, returning current reservation image information=20
>> |10747|13:13|deleted| ( 0) DataStructure.pm,=20
>> |10747|get_next_image_dataStructure (line: 1220) 13:13|deleted| (-1)=20
>> |10747|reclaim.pm, insert_reload_and_exit (line: 198) 13:13|deleted|
>> |10747|(-2) reclaim.pm, process (line: 159) 13:13|deleted| (-3) vcld,=20
>> |10747|make_new_child (line: 571) 13:13|deleted| (-4) vcld, main
>> |10747|(line: 350)
>> 2012-08-03 09:31:44|10747|13:13|deleted|DataStructure.pm:_automethod(836=
)|data structure updated, hash path: $self->request_data->{reservation}{13}=
{imagerevision}{imagename}, data identifier: image_name, data:
>> |10747|13:13|deleted| : "vmwarewin7-Windows764bitBase4-v0"
>> 2012-08-03 09:31:44|10747|13:13|deleted|DataStructure.pm:_automethod(836=
)|data structure updated, hash path: $self->request_data->{reservation}{13}=
{image}{id}, data identifier: image_id, data:
>> |10747|13:13|deleted| : 4
>> 2012-08-03 09:31:44|10747|13:13|deleted|DataStructure.pm:_automethod(836=
)|data structure updated, hash path: $self->request_data->{reservation}{13}=
{imagerevision}{id}, data identifier: imagerevision_id, data:
>> |10747|13:13|deleted| : 4
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|reclaim.pm:insert_reload_and_exit(210)|n
>> e xt image: vmwarewin7-Windows764bitBase4-v0, image id=3D4,=20
>> imagerevision
>> id=3D4
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerloa
>> d log entry not inserted, reservation has been deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:update_computer_state(1587)|com
>> p
>> uter 2 state updated to: reload
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insert_reload_request(8173)|req
>> =3D
>> 13: setting computerid 2 into reload state
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insert_request(8076)|inserted
>> new reload request into request table, request id=3D14
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insert_request(8107)|inserted
>> new reload request into reservation table, reservation id=3D14
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insert_reload_request(8183)|req
>> =3D
>> 13: inserted new reload request, id=3D14 nodeid=3D2, imageid=3D4,
>> imagerevision_id=3D4
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerloa
>> d log entry not inserted, reservation has been deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|reclaim.pm:insert_reload_and_exit(214)|i
>> n serted reload request into database for computer id=3D2,
>> image=3Dvmwarewin7-Windows764bitBase4-v0
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:switch_state(6939)|called from
>> VCL::reclaim::insert_reload_and_exit(217)
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:switch_state(6975)|parent:=20
>> parent reservation ID for this request: 13
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerloa
>> d log entry not inserted, reservation has been deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:update_request_state(1545)|requ
>> e st 13 state updated to: complete, laststate to: deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:switch_state(7010)|request=20
>> state
>> changed: deleted->complete, laststate: inuse->deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerloa
>> d log entry not inserted, reservation has been deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerloa
>> d log entry not inserted, reservation has been deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:update_computer_state(1587)|com
>> p
>> uter 2 state updated to: reload
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:switch_state(7028)|computer
>> vcl485 state changed: inuse->reload
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:switch_state(7038)|log table
>> id=3D5 will not be updated
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerloa
>> d log entry not inserted, reservation has been deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:switch_state(7054)|process
>> exiting
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:delete_computerloadlog_reservat
>> i on(6429)|removing computerloadlog entries matching loadstate =3D=20
>> begin
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:delete_computerloadlog_reservat
>> i on(6476)|deleted rows from computerloadlog for reservation id=3D13
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|State.pm:DESTROY(929)|VCL::reclaim
>> process duration: 3 seconds
>> 2012-08-03 09:31:45|10356|13:13|complete|vcld:main(256)|request
>> deleted
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>> Norvin Basilio
>> nbasilio@odu.edu
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>> -----Original Message-----
>> From: dchebota@gmu.edu [mailto:dchebota@gmu.edu]
>> Sent: Friday, August 03, 2012 11:16 AM
>> To: user@vcl.apache.org
>> Subject: Re: Problem when reservation is completed.
>>=20
>> Hi Norvin
>>=20
>> Could you please send more logs?=20
>> You can grep by reservation ID and send it.
>>=20
>> On Aug 3, 2012, at 10:15 , "Basilio, Norvin" <nbasilio@odu.edu> wrote:
>>=20
>>> I'm receiving a problem email when reservations are finished and being =
deleted. I'm using vcl 2.3. Can anyone assists with this issue.
>>>=20
>>> unable to obtain management node info for this node, returning=20
>>> current reservation image information
>>> --------------------------------------------------------------------
>>> -
>>> ---
>>> time: 2012-08-03 09:31:44
>>> caller: DataStructure.pm:get_next_image_dataStructure(1220)
>>> ( 0) DataStructure.pm, get_next_image_dataStructure (line: 1220)
>>> (-1) reclaim.pm, insert_reload_and_exit (line: 198)
>>> (-2) reclaim.pm, process (line: 159)
>>> (-3) vcld, make_new_child (line: 571)
>>> (-4) vcld, main (line: 350)
>>>=20
>>>=20
>>> Norvin Basilio
>>> nbasilio@odu.edu
>>=20
>>=20
>>=20
>> --
>> Thank you,
>>=20
>> Dmitri Chebotarov
>> Virtual Computing Lab Systems Engineer, TSD - Ent Servers & Messaging
>> 223 Aquia Building, Ffx, MSN: 1B5
>> Phone: (703) 993-6175
>> Fax: (703) 993-3404
>>=20
>>=20
>>=20
>>=20
>>=20
>>=20
>> --
>>=20
>=20
>=20
>=20
> --
> Thank you,
>=20
> Dmitri Chebotarov
> Virtual Computing Lab Systems Engineer, TSD - Ent Servers & Messaging
> 223 Aquia Building, Ffx, MSN: 1B5
> Phone: (703) 993-6175
> Fax: (703) 993-3404
>=20
>=20
>=20
>=20
>=20
>=20
> --
>=20


--
Thank you,

Dmitri Chebotarov
Virtual Computing Lab Systems Engineer, TSD - Ent Servers & Messaging
223 Aquia Building, Ffx, MSN: 1B5
Phone: (703) 993-6175
Fax: (703) 993-3404


--=20
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------

Teach CanIt if this mail (ID 690583317) is spam:
Spam:        https://www.spamtrap.odu.edu/b.php?i=3D690583317&m=3D562599422=
ec3&t=3D20120803&c=3Ds
Not spam:    https://www.spamtrap.odu.edu/b.php?i=3D690583317&m=3D562599422=
ec3&t=3D20120803&c=3Dn
Forget vote: https://www.spamtrap.odu.edu/b.php?i=3D690583317&m=3D562599422=
ec3&t=3D20120803&c=3Df
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS