This is a re-install from 2.4.2. what steps did I miss when trying to update? For all intents and purposes, this is supposed to be a fresh install. Do I need to wipe out the entire install and start again ?
From: Andy Kurth <[email protected]> Reply-To: "[email protected]" <[email protected]> Date: Friday, January 26, 2018 at 11:25 AM To: "[email protected]" <[email protected]> Subject: Re: New 2.5 install error Was this a fresh 2.5 install or upgrade? It appears as though your version of utils.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__utils.pm&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=Mwh_6EQC3cxk3k5Rb2qYDZB9mETWyvOl1C30l1ngr50&e=> is outdated. Your output doesn't match what is currently being done by the 2.5 code's insert_request subroutine that generated the error. The subroutine in 2.5 isn't trying to set request.logid to 0: INSERT INTO request ( request.stateid, request.laststateid, request.userid, request.forimaging, request.test, request.preload, request.start, request.end, request.daterequested ) VALUES ( (SELECT id FROM state WHERE state.name<https://urldefense.proofpoint.com/v2/url?u=http-3A__state.name&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=EFdbG6I8Kox389TUA8rvO6B1lA1nPLDjYVyoK0bRoiY&e=> = '$request_state_name'), (SELECT id FROM state WHERE state.name<https://urldefense.proofpoint.com/v2/url?u=http-3A__state.name&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=EFdbG6I8Kox389TUA8rvO6B1lA1nPLDjYVyoK0bRoiY&e=> = '$request_laststate_name'), (SELECT id FROM user WHERE user.unityid = '$user_unityid'), '0', '0', '0', TIMESTAMPADD(MINUTE, $start_minutes_in_future, NOW()), TIMESTAMPADD(MINUTE, $end_minutes_in_future, NOW()), NOW() ) -Andy On Fri, Jan 26, 2018 at 10:02 AM, Evelio Quiros <[email protected]<mailto:[email protected]>> wrote: 2018-01-26 09:56:28|4156|||vcld|utils.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__utils.pm&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=Mwh_6EQC3cxk3k5Rb2qYDZB9mETWyvOl1C30l1ngr50&e=>:xmlrpc_call|9202|created RPC::XML client object: |4156|||vcld|utils.pm:xmlrpc_call|9202| URL: https://webvcl01.fiu.edu/vcl/index.php?mode=xmlrpccall |4156|||vcld|utils.pm:xmlrpc_call|9202| username: vclsystem@Local 2018-01-26 09:56:28|4156|||vcld|utils.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__utils.pm&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=Mwh_6EQC3cxk3k5Rb2qYDZB9mETWyvOl1C30l1ngr50&e=>:xmlrpc_call|9247|called RPC::XML::Client::send_request: |4156|||vcld|utils.pm:xmlrpc_call|9247| arguments: XMLRPCfinishBaseImageCapture, 1, 23, 1 |4156|||vcld|utils.pm:xmlrpc_call|9247| response value: |4156|||vcld|utils.pm:xmlrpc_call|9247| : { |4156|||vcld|utils.pm:xmlrpc_call|9247| : "status" => "success" |4156|||vcld|utils.pm:xmlrpc_call|9247| : } |4156|||vcld|utils.pm:database_execute|2852| ---- WARNING ---- |4156|||vcld|utils.pm:database_execute|2852| 2018-01-26 09:56:28|4156|||vcld|utils.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__utils.pm&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=Mwh_6EQC3cxk3k5Rb2qYDZB9mETWyvOl1C30l1ngr50&e=>:database_execute|2852|could not execute SQL statement: |4156|||vcld|utils.pm:database_execute|2852| INSERT INTO |4156|||vcld|utils.pm:database_execute|2852| request |4156|||vcld|utils.pm:database_execute|2852| ( |4156|||vcld|utils.pm:database_execute|2852| request.stateid, |4156|||vcld|utils.pm:database_execute|2852| request.laststateid, |4156|||vcld|utils.pm:database_execute|2852| request.userid, |4156|||vcld|utils.pm:database_execute|2852| request.logid, |4156|||vcld|utils.pm:database_execute|2852| request.forimaging, |4156|||vcld|utils.pm:database_execute|2852| request.test, |4156|||vcld|utils.pm:database_execute|2852| request.preload, |4156|||vcld|utils.pm:database_execute|2852| request.start, |4156|||vcld|utils.pm:database_execute|2852| request.end, |4156|||vcld|utils.pm:database_execute|2852| request.daterequested |4156|||vcld|utils.pm:database_execute|2852| ) |4156|||vcld|utils.pm:database_execute|2852| VALUES |4156|||vcld|utils.pm:database_execute|2852| ( |4156|||vcld|utils.pm:database_execute|2852| (SELECT id FROM state WHERE state.name<https://urldefense.proofpoint.com/v2/url?u=http-3A__state.name&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=EFdbG6I8Kox389TUA8rvO6B1lA1nPLDjYVyoK0bRoiY&e=> = 'image'), |4156|||vcld|utils.pm:database_execute|2852| (SELECT id FROM state WHERE state.name<https://urldefense.proofpoint.com/v2/url?u=http-3A__state.name&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=EFdbG6I8Kox389TUA8rvO6B1lA1nPLDjYVyoK0bRoiY&e=> = 'image'), |4156|||vcld|utils.pm:database_execute|2852| (SELECT id FROM user WHERE user.unityid = 'admin'), |4156|||vcld|utils.pm:database_execute|2852| '0', |4156|||vcld|utils.pm:database_execute|2852| '0', |4156|||vcld|utils.pm:database_execute|2852| '0', |4156|||vcld|utils.pm:database_execute|2852| '0', |4156|||vcld|utils.pm:database_execute|2852| TIMESTAMPADD(MINUTE, 0, NOW()), |4156|||vcld|utils.pm:database_execute|2852| TIMESTAMPADD(MINUTE, 60, NOW()), |4156|||vcld|utils.pm:database_execute|2852| NOW() |4156|||vcld|utils.pm:database_execute|2852| ) |4156|||vcld|utils.pm:database_execute|2852| Cannot add or update a child row: a foreign key constraint fails (`vcl`.`request`, CONSTRAINT `request_ibfk_4` FOREIGN KEY (`logid`) REFERENCES `log` (`id`) ON UPDATE CASCADE) |4156|||vcld|utils.pm:database_execute|2852| ( 0) utils.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__utils.pm&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=Mwh_6EQC3cxk3k5Rb2qYDZB9mETWyvOl1C30l1ngr50&e=>, database_execute (line: 2852) |4156|||vcld|utils.pm:database_execute|2852| (-1) utils.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__utils.pm&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=Mwh_6EQC3cxk3k5Rb2qYDZB9mETWyvOl1C30l1ngr50&e=>, insert_request (line: 8051) |4156|||vcld|utils.pm:database_execute|2852| (-2) image.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__image.pm&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=qDz5X4b_oQ7RyuDhYKROeYLSl1YdFp3DzDjA2pINVHc&e=>, setup_capture_base_image (line: 980) |4156|||vcld|utils.pm:database_execute|2852| (-3) vcld, setup_management_node (line: 929) 2018-01-26 09:56:28|4156|||vcld|utils.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__utils.pm&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=Mwh_6EQC3cxk3k5Rb2qYDZB9mETWyvOl1C30l1ngr50&e=>:get_management_node_info|4589|retrieving current management node info for 'mgtvcl01.fiu.edu<http://mgtvcl01.fiu.edu>' from database, cached data is stale: 64 seconds old 2018-01-26 09:56:28|4156|||vcld|utils.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__utils.pm&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=Mwh_6EQC3cxk3k5Rb2qYDZB9mETWyvOl1C30l1ngr50&e=>:get_variable|12093|variable 'cluster_inuse_check' is not set in the database 2018-01-26 09:56:28|4156|||vcld|utils.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__utils.pm&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=Mwh_6EQC3cxk3k5Rb2qYDZB9mETWyvOl1C30l1ngr50&e=>:get_management_node_info|4751|retrieved management node info: 'mgtvcl01.fiu.edu<http://mgtvcl01.fiu.edu>' (mgtvcl01) 2018-01-26 09:56:28|4156|||vcld|utils.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__utils.pm&d=DwMFaQ&c=lhMMI368wojMYNABHh1gQQ&r=iomW2cpnE-Hdilsh5YvIBg&m=yjbBQ0F103dSHUJLo4RriZ_DawzJBN2yUcEduHS2cNE&s=Mwh_6EQC3cxk3k5Rb2qYDZB9mETWyvOl1C30l1ngr50&e=>:mail|1262|SUCCESS -- Sending mail To: [email protected]<mailto:[email protected]>, PROBLEM -- mgtvcl01|utils.pm:insert_request(8056) From: Aaron Peeler <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>, "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Thursday, January 25, 2018 at 7:12 AM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: Re: New 2.5 install error Hi Al, Can you send the log snippet for that imaging request? Aaron On Jan 25, 2018 3:58 AM, "António Aragão" <[email protected]<mailto:[email protected]>> wrote: Test if you can insert the request using mysql client from the management node. Kind regards. 2018-01-24 19:18 GMT+00:00 Evelio Quiros <[email protected]<mailto:[email protected]>>: Hello, In vcld –setupI try to capture a linux image on a VMware host. I get as far as adding the image to the database, then I get ERROR: failed to insert new imaging request. The management node can SSH to the VM and to the VM host. The host has SSH turned on, and the key is in place for passwordless connections. Vcld is running, and the management node is checking the DB. This is a new installation, and have followed the steps in the guide. Any ideas on what I could check for ? Thanks Al Quiros -- António Aragão (Especialista de Informática) Universidade do Minho Departamento de Informática Edificio 7 - 1.07 (DI-1.03) Campus de Gualtar Braga Telefone: +351 253 6044 86 -- Andy Kurth Research Storage Specialist NC State University Office of Information Technology P: 919-513-4090 311A Hillsborough Building Campus Box 7109 Raleigh, NC 27695 [https://docs.google.com/uc?export=download&id=0B1RAxkyXdSMEX21iNU45NUhNSkk&revid=0B1RAxkyXdSMEdFhLeG9GNHVNM21YajA4djFXK0YzejQ4N2FrPQ]
