I ran the query and it returned 8 for predictivemoduleid. Norvin Basilio [email protected]
-----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Friday, August 03, 2012 1:18 PM To: [email protected] Subject: Re: Problem when reservation is completed. 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_predictiv >> |10747|e _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_n >> a >> 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_d >> |10747|a 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)|n >> e 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)|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 >> = >> 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)|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=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)|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 >> 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=5 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 = >> 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=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 > > > > > > > -- > -- 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 690583317) is spam: Spam: https://www.spamtrap.odu.edu/b.php?i=690583317&m=562599422ec3&t=20120803&c=s Not spam: https://www.spamtrap.odu.edu/b.php?i=690583317&m=562599422ec3&t=20120803&c=n Forget vote: https://www.spamtrap.odu.edu/b.php?i=690583317&m=562599422ec3&t=20120803&c=f ------------------------------------------------------ END-ANTISPAM-VOTING-LINKS
