Does this SQL query return anything?
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 = predictivemodule.id
AND managementnode.stateid = state.id
AND managementnode.hostname = 'vclMgmtNode.vcls.priv.odu.edu'
On Aug 3, 2012, at 12:13 , "Basilio, Norvin" <[email protected]> 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.
>
> Norvin Basilio
> [email protected]
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]]
> Sent: Friday, August 03, 2012 12:09 PM
> To: [email protected]
> Subject: Re: Problem when reservation is completed.
>
>
> Norvin
>
> Looks like the error is caused by "get_management_predictive_info(5436)|zero
> rows were returned from database select".
>
> Can you check that management node has Predictive Loading Module set?
> It's under 'Management Nodes->Edit Mgm nodes'.
>
> You can also check in VCL database:
>
> SELECT predictivemoduleid FROM vcl.managementnode;
>
> You should get id 8 or 9, depends on what you have set PLM for this
> management node.
>
> Thanks.
>
> On Aug 3, 2012, at 11:42 , "Basilio, Norvin" <[email protected]> wrote:
>
>> Sure here is the log for the reservation ID. It's a bit Long:
>>
>> ....
>
>> |10747|13:13|deleted| ---- WARNING ---- 13:13|deleted| 2012-08-03
>> |10747|09:31:44|10747|13:13|deleted|utils.pm:get_management_predictive
>> |10747|_info(5436)|zero rows were returned from database select
>> |10747|13:13|deleted| ( 0) utils.pm, get_management_predictive_info
>> |10747|(line: 5436) 13:13|deleted| (-1) DataStructure.pm,
>> |10747|get_next_image_dataStructure (line: 1218) 13:13|deleted| (-2)
>> |10747|reclaim.pm, insert_reload_and_exit (line: 198) 13:13|deleted|
>> |10747|(-3) reclaim.pm, process (line: 159) 13:13|deleted| (-4) vcld,
>> |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 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
>> 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_na
>> me(2118)|image owner id: 1
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|DataStructure.pm:retrieve_user_data(1401)|attempting
>> to retrieve and store data for user: user.id = '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 --
>> Sending mail To: [email protected], 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
>> |10747|09:31:44|10747|13:13|deleted|DataStructure.pm:get_next_image_da
>> |10747|taStructure(1220)|unable to obtain management node info for
>> |10747|this node, returning current reservation image information
>> |10747|13:13|deleted| ( 0) DataStructure.pm,
>> |10747|get_next_image_dataStructure (line: 1220) 13:13|deleted| (-1)
>> |10747|reclaim.pm, insert_reload_and_exit (line: 198) 13:13|deleted|
>> |10747|(-2) reclaim.pm, process (line: 159) 13:13|deleted| (-3) vcld,
>> |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)|ne
>> xt image: vmwarewin7-Windows764bitBase4-v0, image id=4, imagerevision
>> id=4
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerload
>> log entry not inserted, reservation has been deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:update_computer_state(1587)|comp
>> uter 2 state updated to: reload
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insert_reload_request(8173)|req=
>> 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=14
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insert_request(8107)|inserted
>> new reload request into reservation table, reservation id=14
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insert_reload_request(8183)|req=
>> 13: inserted new reload request, id=14 nodeid=2, imageid=4,
>> imagerevision_id=4
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerload
>> 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)|in
>> serted reload request into database for computer id=2,
>> image=vmwarewin7-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:
>> parent reservation ID for this request: 13
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerload
>> log entry not inserted, reservation has been deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:update_request_state(1545)|reque
>> 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 state
>> changed: deleted->complete, laststate: inuse->deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerload
>> log entry not inserted, reservation has been deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerload
>> log entry not inserted, reservation has been deleted
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:update_computer_state(1587)|comp
>> 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=5 will not be updated
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:insertloadlog(3676)|computerload
>> 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_reservati
>> on(6429)|removing computerloadlog entries matching loadstate = begin
>> 2012-08-03
>> 09:31:44|10747|13:13|deleted|utils.pm:delete_computerloadlog_reservati
>> on(6476)|deleted rows from computerloadlog for reservation id=13
>> 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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Norvin Basilio
>> [email protected]
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> -----Original Message-----
>> From: [email protected] [mailto:[email protected]]
>> Sent: Friday, August 03, 2012 11:16 AM
>> To: [email protected]
>> Subject: Re: Problem when reservation is completed.
>>
>> Hi Norvin
>>
>> Could you please send more logs?
>> You can grep by reservation ID and send it.
>>
>> On Aug 3, 2012, at 10:15 , "Basilio, Norvin" <[email protected]> wrote:
>>
>>> 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.
>>>
>>> unable to obtain management node info for this node, returning
>>> 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)
>>>
>>>
>>> Norvin Basilio
>>> [email protected]
>>
>>
>>
>> --
>> 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
>>
>>
>>
>>
>>
>>
>> --
>>
>
>
>
> --
> 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
>
>
>
>
>
>
> --
> BEGIN-ANTISPAM-VOTING-LINKS
> ------------------------------------------------------
>
> Teach CanIt if this mail (ID 690558743) is spam:
> Spam:
> https://www.spamtrap.odu.edu/b.php?i=690558743&m=c3103e237924&t=20120803&c=s
> Not spam:
> https://www.spamtrap.odu.edu/b.php?i=690558743&m=c3103e237924&t=20120803&c=n
> Forget vote:
> https://www.spamtrap.odu.edu/b.php?i=690558743&m=c3103e237924&t=20120803&c=f
> ------------------------------------------------------
> END-ANTISPAM-VOTING-LINKS
>
--
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
