Group Multicast - Dev-Branch

[edvandro]

Hello everyone,

I am currently testing the dev-branch of FOG and have run into an issue when trying to create a new Multicast deployment task for a group of hosts.

Whenever I attempt to start the task, it fails immediately. The web UI shows a generic “Failed to create tasking” error, and the debug log reveals the following SQL integrity constraint violation:

The full query and parameters from the log show that the INSERT into the tasks table is trying to set taskPassreset to NULL, but the column definition in the database does not allow null values.

Additional context:

This issue occurs only on the dev-branch.
I have tested the exact same configuration (same server, same image, same host group) on the stable branch, and Multicast group tasks work perfectly fine there.

I have attached the error screenshot/print for reference.

Has anyone else encountered this specific issue on the dev-branch? Could it be a schema mismatch (e.g., missing default value for taskPassreset), or is this a known regression in the development code? Any pointers on how to fix or patch this temporarily would be greatly appreciated.

Thank you in advance for your help!

FOG Version: Dev-Branch (latest pull)
Init/Kernel: (Not relevant, happens in web UI before PXE boot)
Storage: NFS (working fine on stable)

####################

Tasking Failed
Failed to create tasking

```

teste Failed to start tasking type Multi-Cast
Failed to query: Error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘taskPassreset’ cannot be null Error Message: Error Code: “23000”, Error Message: [“23000”,1048,“Column ‘taskPassreset’ cannot be null”], Debug: SQL: [1115] INSERT INTO tasks (taskName,taskCreateBy,taskHostID,taskForce,taskStateID,taskTypeID,taskNFSGroupID,taskNFSMemberID,taskWOL,taskImageID,taskShutdown,taskIsDebug,taskPassreset,taskLastMemberID) VALUES (:name_0,:createdBy_0,:hostID_0,:isForced_0,:stateID_0,:typeID_0,:storagegroupID_0,:storagenodeID_0,:wol_0,:imageID_0,:shutdown_0,:isDebug_0,:passreset_0,:NFSLastMemberID_0),(:name_1,:createdBy_1,:hostID_1,:isForced_1,:stateID_1,:typeID_1,:storagegroupID_1,:storagenodeID_1,:wol_1,:imageID_1,:shutdown_1,:isDebug_1,:passreset_1,:NFSLastMemberID_1) ON DUPLICATE KEY UPDATE taskName=VALUES(taskName),taskCreateBy=VALUES(taskCreateBy),taskHostID=VALUES(taskHostID),taskForce=VALUES(taskForce),taskStateID=VALUES(taskStateID),taskTypeID=VALUES(taskTypeID),taskNFSGroupID=VALUES(taskNFSGroupID),taskNFSMemberID=VALUES(taskNFSMemberID),taskWOL=VALUES(taskWOL),taskImageID=VALUES(taskImageID),taskShutdown=VALUES(taskShutdown),taskIsDebug=VALUES(taskIsDebug),taskPassreset=VALUES(taskPassreset),taskLastMemberID=VALUES(taskLastMemberID) Params: 28 Key: Name: [7] :name_0 paramno=0 name=[7] “:name_0” is_param=1 param_type=2 Key: Name: [12] :createdBy_0 paramno=1 name=[12] “:createdBy_0” is_param=1 param_type=2 Key: Name: [9] :hostID_0 paramno=2 name=[9] “:hostID_0” is_param=1 param_type=2 Key: Name: [11] :isForced_0 paramno=3 name=[11] “:isForced_0” is_param=1 param_type=2 Key: Name: [10] :stateID_0 paramno=4 name=[10] “:stateID_0” is_param=1 param_type=2 Key: Name: [9] :typeID_0 paramno=5 name=[9] “:typeID_0” is_param=1 param_type=2 Key: Name: [17] :storagegroupID_0 paramno=6 name=[17] “:storagegroupID_0” is_param=1 param_type=2 Key: Name: [16] :storagenodeID_0 paramno=7 name=[16] “:storagenodeID_0” is_param=1 param_type=2 Key: Name: [6] :wol_0 paramno=8 name=[6] “:wol_0” is_param=1 param_type=2 Key: Name: [10] :imageID_0 paramno=9 name=[10] “:imageID_0” is_param=1 param_type=2 Key: Name: [11] :shutdown_0 paramno=10 name=[11] “:shutdown_0” is_param=1 param_type=2 Key: Name: [10] :isDebug_0 paramno=11 name=[10] “:isDebug_0” is_param=1 param_type=2 Key: Name: [12] :passreset_0 paramno=12 name=[12] “:passreset_0” is_param=1 param_type=2 Key: Name: [18] :NFSLastMemberID_0 paramno=13 name=[18] “:NFSLastMemberID_0” is_param=1 param_type=2 Key: Name: [7] :name_1 paramno=14 name=[7] “:name_1” is_param=1 param_type=2 Key: Name: [12] :createdBy_1 paramno=15 name=[12] “:createdBy_1” is_param=1 param_type=2 Key: Name: [9] :hostID_1 paramno=16 name=[9] “:hostID_1” is_param=1 param_type=2 Key: Name: [11] :isForced_1 paramno=17 name=[11] “:isForced_1” is_param=1 param_type=2 Key: Name: [10] :stateID_1 paramno=18 name=[10] “:stateID_1” is_param=1 param_type=2 Key: Name: [9] :typeID_1 paramno=19 name=[9] “:typeID_1” is_param=1 param_type=2 Key: Name: [17] :storagegroupID_1 paramno=20 name=[17] “:storagegroupID_1” is_param=1 param_type=2 Key: Name: [16] :storagenodeID_1 paramno=21 name=[16] “:storagenodeID_1” is_param=1 param_type=2 Key: Name: [6] :wol_1 paramno=22 name=[6] “:wol_1” is_param=1 param_type=2 Key: Name: [10] :imageID_1 paramno=23 name=[10] “:imageID_1” is_param=1 param_type=2 Key: Name: [11] :shutdown_1 paramno=24 name=[11] “:shutdown_1” is_param=1 param_type=2 Key: Name: [10] :isDebug_1 paramno=25 name=[10] “:isDebug_1” is_param=1 param_type=2 Key: Name: [12] :passreset_1 paramno=26 name=[12] “:passreset_1” is_param=1 param_type=2 Key: Name: [18] :NFSLastMemberID_1 paramno=27 name=[18] “:NFSLastMemberID_1” is_param=1 param_type=2 SQL: INSERT INTO tasks (taskName,taskCreateBy,taskHostID,taskForce,taskStateID,taskTypeID,taskNFSGroupID,taskNFSMemberID,taskWOL,taskImageID,taskShutdown,taskIsDebug,taskPassreset,taskLastMemberID) VALUES (:name_0,:createdBy_0,:hostID_0,:isForced_0,:stateID_0,:typeID_0,:storagegroupID_0,:storagenodeID_0,:wol_0,:imageID_0,:shutdown_0,:isDebug_0,:passreset_0,:NFSLastMemberID_0),(:name_1,:createdBy_1,:hostID_1,:isForced_1,:stateID_1,:typeID_1,:storagegroupID_1,:storagenodeID_1,:wol_1,:imageID_1,:shutdown_1,:isDebug_1,:passreset_1,:NFSLastMemberID_1) ON DUPLICATE KEY UPDATE taskName=VALUES(taskName),taskCreateBy=VALUES(taskCreateBy),taskHostID=VALUES(taskHostID),taskForce=VALUES(taskForce),taskStateID=VALUES(taskStateID),taskTypeID=VALUES(taskTypeID),taskNFSGroupID=VALUES(taskNFSGroupID),taskNFSMemberID=VALUES(taskNFSMemberID),taskWOL=VALUES(taskWOL),taskImageID=VALUES(taskImageID),taskShutdown=VALUES(taskShutdown),taskIsDebug=VALUES(taskIsDebug),taskPassreset=VALUES(taskPassreset),taskLastMemberID=VALUES(taskLastMemberID) Params: Array ( [name_0] => Multi-Cast Task - teste [createdBy_0] => fog [hostID_0] => 2 [isForced_0] => 0 [stateID_0] => 1 [typeID_0] => 8 [storagegroupID_0] => 1 [storagenodeID_0] => 1 [wol_0] => 1 [imageID_0] => 1 [shutdown_0] => [isDebug_0] => [passreset_0] => [NFSLastMemberID_0] => 1 [name_1] => Multi-Cast Task - teste [createdBy_1] => fog [hostID_1] => 3 [isForced_1] => 0 [stateID_1] => 1 [typeID_1] => 8 [storagegroupID_1] => 1 [storagenodeID_1] => 1 [wol_1] => 1 [imageID_1] => 1 [shutdown_1] => [isDebug_1] => [passreset_1] => [NFSLastMemberID_1] => 1 ) ErrorInfo: Array ( [0] => 23000 [1] => 1048 [2] => Column ‘taskPassreset’ cannot be null ) Debug: SQL: [1115] INSERT INTO tasks (taskName,taskCreateBy,taskHostID,taskForce,taskStateID,taskTypeID,taskNFSGroupID,taskNFSMemberID,taskWOL,taskImageID,taskShutdown,taskIsDebug,taskPassreset,taskLastMemberID) VALUES (:name_0,:createdBy_0,:hostID_0,:isForced_0,:stateID_0,:typeID_0,:storagegroupID_0,:storagenodeID_0,:wol_0,:imageID_0,:shutdown_0,:isDebug_0,:passreset_0,:NFSLastMemberID_0),(:name_1,:createdBy_1,:hostID_1,:isForced_1,:stateID_1,:typeID_1,:storagegroupID_1,:storagenodeID_1,:wol_1,:imageID_1,:shutdown_1,:isDebug_1,:passreset_1,:NFSLastMemberID_1) ON DUPLICATE KEY UPDATE taskName=VALUES(taskName),taskCreateBy=VALUES(taskCreateBy),taskHostID=VALUES(taskHostID),taskForce=VALUES(taskForce),taskStateID=VALUES(taskStateID),taskTypeID=VALUES(taskTypeID),taskNFSGroupID=VALUES(taskNFSGroupID),taskNFSMemberID=VALUES(taskNFSMemberID),taskWOL=VALUES(taskWOL),taskImageID=VALUES(taskImageID),taskShutdown=VALUES(taskShutdown),taskIsDebug=VALUES(taskIsDebug),taskPassreset=VALUES(taskPassreset),taskLastMemberID=VALUES(taskLastMemberID) Params: 28 Key: Name: [7] :name_0 paramno=0 name=[7] “:name_0” is_param=1 param_type=2 Key: Name: [12] :createdBy_0 paramno=1 name=[12] “:createdBy_0” is_param=1 param_type=2 Key: Name: [9] :hostID_0 paramno=2 name=[9] “:hostID_0” is_param=1 param_type=2 Key: Name: [11] :isForced_0 paramno=3 name=[11] “:isForced_0” is_param=1 param_type=2 Key: Name: [10] :stateID_0 paramno=4 name=[10] “:stateID_0” is_param=1 param_type=2 Key: Name: [9] :typeID_0 paramno=5 name=[9] “:typeID_0” is_param=1 param_type=2 Key: Name: [17] :storagegroupID_0 paramno=6 name=[17] “:storagegroupID_0” is_param=1 param_type=2 Key: Name: [16] :storagenodeID_0 paramno=7 name=[16] “:storagenodeID_0” is_param=1 param_type=2 Key: Name: [6] :wol_0 paramno=8 name=[6] “:wol_0” is_param=1 param_type=2 Key: Name: [10] :imageID_0 paramno=9 name=[10] “:imageID_0” is_param=1 param_type=2 Key: Name: [11] :shutdown_0 paramno=10 name=[11] “:shutdown_0” is_param=1 param_type=2 Key: Name: [10] :isDebug_0 paramno=11 name=[10] “:isDebug_0” is_param=1 param_type=2 Key: Name: [12] :passreset_0 paramno=12 name=[12] “:passreset_0” is_param=1 param_type=2 Key: Name: [18] :NFSLastMemberID_0 paramno=13 name=[18] “:NFSLastMemberID_0” is_param=1 param_type=2 Key: Name: [7] :name_1 paramno=14 name=[7] “:name_1” is_param=1 param_type=2 Key: Name: [12] :createdBy_1 paramno=15 name=[12] “:createdBy_1” is_param=1 param_type=2 Key: Name: [9] :hostID_1 paramno=16 name=[9] “:hostID_1” is_param=1 param_type=2 Key: Name: [11] :isForced_1 paramno=17 name=[11] “:isForced_1” is_param=1 param_type=2 Key: Name: [10] :stateID_1 paramno=18 name=[10] “:stateID_1” is_param=1 param_type=2 Key: Name: [9] :typeID_1 paramno=19 name=[9] “:typeID_1” is_param=1 param_type=2 Key: Name: [17] :storagegroupID_1 paramno=20 name=[17] “:storagegroupID_1” is_param=1 param_type=2 Key: Name: [16] :storagenodeID_1 paramno=21 name=[16] “:storagenodeID_1” is_param=1 param_type=2 Key: Name: [6] :wol_1 paramno=22 name=[6] “:wol_1” is_param=1 param_type=2 Key: Name: [10] :imageID_1 paramno=23 name=[10] “:imageID_1” is_param=1 param_type=2 Key: Name: [11] :shutdown_1 paramno=24 name=[11] “:shutdown_1” is_param=1 param_type=2 Key: Name: [10] :isDebug_1 paramno=25 name=[10] “:isDebug_1” is_param=1 param_type=2 Key: Name: [12] :passreset_1 paramno=26 name=[12] “:passreset_1” is_param=1 param_type=2 Key: Name: [18] :NFSLastMemberID_1 paramno=27 name=[18] “:NFSLastMemberID_1” is_param=1 param_type=2