Was this a fresh 2.5 install or upgrade? It appears as though your version
of utils.pm 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 = '$request_state_name'),
(SELECT id FROM state WHERE state.name = '$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]> wrote:
>
>
> 2018-01-26 09:56:28|4156|||vcld|utils.pm: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: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: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 = 'image'),
>
> |4156|||vcld|utils.pm:database_execute|2852| (SELECT id FROM state WHERE
> state.name = '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,
> database_execute (line: 2852)
>
> |4156|||vcld|utils.pm:database_execute|2852| (-1) utils.pm,
> insert_request (line: 8051)
>
> |4156|||vcld|utils.pm:database_execute|2852| (-2) image.pm,
> 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:get_management_node_info|4589|retrieving
> current management node info for 'mgtvcl01.fiu.edu' from database, cached
> data is stale: 64 seconds old
>
> 2018-01-26 09:56:28|4156|||vcld|utils.pm:get_variable|12093|variable
> 'cluster_inuse_check' is not set in the database
>
> 2018-01-26
> 09:56:28|4156|||vcld|utils.pm:get_management_node_info|4751|retrieved
> management node info: 'mgtvcl01.fiu.edu' (mgtvcl01)
>
> 2018-01-26 09:56:28|4156|||vcld|utils.pm:mail|1262|SUCCESS -- Sending
> mail To: [email protected], PROBLEM -- mgtvcl01|utils.pm:insert_request(8056)
>
>
>
>
>
> *From: *Aaron Peeler <[email protected]>
> *Reply-To: *"[email protected]" <[email protected]>, "
> [email protected]" <[email protected]>
> *Date: *Thursday, January 25, 2018 at 7:12 AM
> *To: *"[email protected]" <[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]> 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]>:
>
> 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
