vcl-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitri Chebotarov <dcheb...@gmu.edu>
Subject Re: Problem when reservation is completed.
Date Fri, 03 Aug 2012 17:17:40 GMT

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" <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.
> 
> Norvin Basilio
> nbasilio@odu.edu
> 
> -----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.
> 
> 
> 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" <nbasilio@odu.edu> 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: 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 
>> |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
>> nbasilio@odu.edu
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> -----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.
>> 
>> 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" <nbasilio@odu.edu> 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
>>> nbasilio@odu.edu
>> 
>> 
>> 
>> --
>> 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





Mime
View raw message