FOG ubuntu image fails to update database

Tom Elliott

@mashina Are you sure it’s giving ftp_login error?

Tom Elliott

@JGeear your FOG Storage Node -> username/password is where the ftp_login information comes from.

@mashina Similarly for you, but I call out about the “same message” becasue working-1.6 is using ssh unless you’re on an older (1 year or so ago) version of working-1.6?

mashina

@Tom-Elliott Hi Tom, Sorry, my bad. I don’t get Login incorrect message. Mine is saying, No active task found for Host <Hostname>. But the error is the same, could not Update database. Also, I am using the latest working-1.6.

I don’t know if these errors are relevant, but my Multicast was around 12:30.

masih@fog:~$ sudo tail -n 200 /var/log/apache2/error.log
[Fri Mar 06 00:00:03.749336 2026] [mpm_prefork:notice] [pid 119135] AH00163: Apache/2.4.52 (Ubuntu) OpenSSL/3.0.2 configured -- resuming normal operations
[Fri Mar 06 00:00:03.749408 2026] [core:notice] [pid 119135] AH00094: Command line: '/usr/sbin/apache2'
[Fri Mar 06 09:45:22.809081 2026] [proxy_fcgi:error] [pid 188212] [client 172.28.172.92:11308] AH01071: Got error 'PHP message: PHP Warning:  Undefined array key "hostID" in /var/www/html/fog/lib/router/route.class.php on line 2733PHP message: PHP Warning:  Undefined array key "msaID" in /var/www/html/fog/lib/router/route.class.php on line 2515PHP message: PHP Warning:  Undefined array key "hostID" in /var/www/html/fog/lib/router/route.class.php on line 2733PHP message: PHP Warning:  Undefined variable $stat in /var/www/html/fog/lib/fog/group.class.php on line 772', referer: http://fog/fog/management/index.php?node=group&sub=edit&id=42
[Fri Mar 06 10:11:51.346904 2026] [proxy_fcgi:error] [pid 148942] [client 172.28.1.83:58320] AH01071: Got error 'PHP message: PHP Warning:  Undefined array key "hostID" in /var/www/html/fog/lib/router/route.class.php on line 2733PHP message: PHP Warning:  Undefined array key "msaID" in /var/www/html/fog/lib/router/route.class.php on line 2515PHP message: PHP Warning:  Undefined array key "hostID" in /var/www/html/fog/lib/router/route.class.php on line 2733PHP message: PHP Warning:  Undefined variable $stat in /var/www/html/fog/lib/fog/group.class.php on line 772'
[Fri Mar 06 11:00:16.168016 2026] [mpm_prefork:notice] [pid 119135] AH00170: caught SIGWINCH, shutting down gracefully
[Fri Mar 06 11:00:55.671950 2026] [mpm_prefork:notice] [pid 845] AH00163: Apache/2.4.52 (Ubuntu) OpenSSL/3.0.2 configured -- resuming normal operations
[Fri Mar 06 11:00:55.675999 2026] [core:notice] [pid 845] AH00094: Command line: '/usr/sbin/apache2'
[Fri Mar 06 11:27:39.854967 2026] [proxy_fcgi:error] [pid 895] [client 172.28.172.92:43525] AH01067: Failed to read FastCGI header, referer: http://fog/fog/management/index.php?node=task&sub=activescheduled
[Fri Mar 06 11:27:39.855265 2026] [proxy_fcgi:error] [pid 895] (104)Connection reset by peer: [client 172.28.172.92:43525] AH01075: Error dispatching request to : , referer: http://fog/fog/management/index.php?node=task&sub=activescheduled
[Fri Mar 06 11:27:39.907972 2026] [mpm_prefork:notice] [pid 845] AH00170: caught SIGWINCH, shutting down gracefully
[Fri Mar 06 11:27:49.405096 2026] [mpm_prefork:notice] [pid 4373] AH00163: Apache/2.4.52 (Ubuntu) OpenSSL/3.0.2 configured -- resuming normal operations
[Fri Mar 06 11:27:49.405283 2026] [core:notice] [pid 4373] AH00094: Command line: '/usr/sbin/apache2'
[Fri Mar 06 11:39:00.840026 2026] [mpm_prefork:notice] [pid 4373] AH00170: caught SIGWINCH, shutting down gracefully
[Fri Mar 06 11:39:35.371742 2026] [mpm_prefork:notice] [pid 840] AH00163: Apache/2.4.52 (Ubuntu) OpenSSL/3.0.2 configured -- resuming normal operations
[Fri Mar 06 11:39:35.372374 2026] [core:notice] [pid 840] AH00094: Command line: '/usr/sbin/apache2'
[Fri Mar 06 12:39:59.781079 2026] [proxy_fcgi:error] [pid 1514] [client 172.28.171.193:43267] AH01071: Got error 'PHP message: PHP Warning:  Undefined array key "hostID" in /var/www/html/fog/lib/router/route.class.php on line 2733PHP message: PHP Warning:  Undefined array key "msaID" in /var/www/html/fog/lib/router/route.class.php on line 2515PHP message: PHP Warning:  Undefined array key "hostID" in /var/www/html/fog/lib/router/route.class.php on line 2733PHP message: PHP Warning:  Undefined variable $stat in /var/www/html/fog/lib/fog/group.class.php on line 772', referer: http://fog/fog/management/index.php?node=group&sub=edit&id=42```

Tom Elliott

@mashina Can you get select * from history; out of your database?

I’m having a sneaking suspicion the issue is likely part of a rewrite to substaintially make save our save to database functions, that has some repercussions on other things because so much had required things that shouldn’t have bene required.

Similarly, can you provide the exact version?

“Latest working-1.6” is a shifting target. like i’m pretty sure you were not on the latest since I made pushes today so pretty sure the error you are getting is not related to today.

JGeear

@Tom-Elliott Okay what changed? It was working fine until a few weeks ago.

Tom Elliott

@JGeear I don’t know if anything changed, just I wonder if someone was making an edit in the UI and accidentally changed the password in the UI. I’m having you start with where I know the system is getting the information. Make sure the username/password matches what is on that nodes /opt/fog/.fogsettings file. If they are the same, then I’d ask if you can use that same information and an FTP client to ensure at least connection is there. Then we can try to troubleshoot further.

mashina

@Tom-Elliott

FOG version: working-1.6
commit: f61a90d97

The history of the days we noticed the issue. One thing I want to point out is that unicasting doesn’t throw that error.

| 2119 | [2026-03-05 09:22:52] Task ID:  Name: Multiple Snapin -- orig Single has failed to save. Error: Required database field is empty: hostID    | iina     | 2026-03-05 09:22:52 | 10.24.193.157  |
| 2120 | [2026-03-05 09:23:03] Task ID: 3714 NAME: Wake-Up Task - 6037-GOLD 2026-03-05 09:23:03 has been successfully updated.                       | fog      | 2026-03-05 09:23:03 | 172.28.172.92  |
| 2122 | [2026-03-05 09:23:04] Task ID: 3714 NAME: Wake-Up Task - 6037-GOLD 2026-03-05 09:23:03 has been successfully updated.                       | fog      | 2026-03-05 09:23:04 | 172.28.172.92  |
| 2123 | [2026-03-05 09:23:54] Task ID:  Name: Multiple Snapin -- orig Single has failed to save. Error: Required database field is empty: hostID    | iina     | 2026-03-05 09:23:54 | 10.24.193.157  |
| 2124 | [2026-03-05 10:27:19] ScheduledTask ID: 4 NAME: Multi-Cast Task has been successfully updated.                                              | le.do    | 2026-03-05 10:27:19 | 10.24.193.251  |
| 2125 | [2026-03-05 10:34:39] ScheduledTask ID: 5 NAME: Multi-Cast Task has been successfully updated.                                              | le.do    | 2026-03-05 10:34:39 | 10.24.193.251  |
| 2126 | [2026-03-05 14:26:47] Group ID: 42 NAME: sysprep-test-5004 has been successfully updated.                                                   | fog      | 2026-03-05 14:26:47 | 172.28.171.22  |
| 2127 | [2026-03-05 14:27:16] Group ID: 42 NAME: sysprep-test-5004 has been successfully updated.                                                   | fog      | 2026-03-05 14:27:16 | 172.28.171.22  |
| 2128 | [2026-03-05 14:58:43] Group ID: 42 NAME: sysprep-test-5004 has been successfully updated.                                                   | le.do    | 2026-03-05 14:58:43 | 10.24.193.251  |
| 2129 | [2026-03-05 15:04:36] ScheduledTask ID: 10 NAME: Multi-Cast Task has been successfully updated.                                             | le.do    | 2026-03-05 15:04:36 | 10.24.193.251  |
| 2130 | [2026-03-05 15:08:03] Group ID: 42 NAME: sysprep-test-5004 has been successfully updated.                                                   | le.do    | 2026-03-05 15:08:03 | 10.24.193.251  |
| 2131 | [2026-03-05 15:08:39] ScheduledTask ID: 11 NAME: Multi-Cast Task has been successfully updated.                                             | le.do    | 2026-03-05 15:08:39 | 10.24.193.251  |
| 2132 | [2026-03-05 15:13:38] Group ID: 42 NAME: sysprep-test-5004 has been successfully updated.                                                   | le.do    | 2026-03-05 15:13:38 | 10.24.193.251  |
| 2133 | [2026-03-05 15:15:50] ScheduledTask ID: 12 NAME: Multi-Cast Task has been successfully updated.                                             | le.do    | 2026-03-05 15:15:50 | 10.24.193.251  |
| 2134 | [2026-03-05 15:49:11] Group ID: 42 NAME: sysprep-test-5004 has been successfully updated.                                                   | fog      | 2026-03-05 15:49:11 | 172.28.172.92  |
| 2135 | [2026-03-05 16:13:34] Group ID: 42 NAME: sysprep-test-5004 has been successfully updated.                                                   | fog      | 2026-03-05 16:13:34 | 172.28.171.193 |
| 2136 | [2026-03-05 16:13:47] MulticastSession ID: 141 NAME: Multi-Cast Task - sysprep-test-5004 2026-03-05 16:13:46 has been successfully updated. | fog      | 2026-03-05 16:13:47 | 172.28.171.193 |
| 2137 | [2026-03-06 09:15:12] Group ID: 41 NAME: Le.Do (api-test) has been successfully updated.                                                    | le.do    | 2026-03-06 09:15:12 | 10.24.193.251  |
| 2138 | [2026-03-06 09:15:27] ScheduledTask ID: 14 NAME: Multi-Cast Task has been successfully updated.                                             | le.do    | 2026-03-06 09:15:27 | 10.24.193.251  |
| 2139 | [2026-03-06 09:18:47] ScheduledTask ID: 15 NAME: Multi-Cast Task has been successfully updated.                                             | le.do    | 2026-03-06 09:18:47 | 10.24.193.251  |
| 2140 | [2026-03-06 09:45:04] Group ID: 42 NAME: sysprep-test-5004 has been successfully updated.                                                   | fog      | 2026-03-06 09:45:04 | 172.28.172.92  |
| 2141 | [2026-03-06 09:45:21] MulticastSession ID: 142 NAME: Multi-Cast Task - sysprep-test-5004 2026-03-06 09:45:21 has been successfully updated. | fog      | 2026-03-06 09:45:21 | 172.28.172.92  |
| 2142 | [2026-03-06 10:37:18] Group ID: 41 NAME: Le.Do (api-test) has been successfully updated.                                                    | le.do    | 2026-03-06 10:37:18 | 10.24.193.251  |
| 2143 | [2026-03-06 10:37:32] ScheduledTask ID: 16 NAME: Multi-Cast Task has been successfully updated.                                             | le.do    | 2026-03-06 10:37:32 | 10.24.193.251  |
| 2144 | [2026-03-06 11:11:22] ScheduledTask ID: 17 NAME: Multi-Cast Task has been successfully updated.                                             | fog      | 2026-03-06 11:11:22 | 172.28.172.92  |
| 2145 | [2026-03-06 12:10:27] ScheduledTask ID: 18 NAME: Multi-Cast Task has been successfully updated.                                             | fog      | 2026-03-06 12:10:27 | 172.28.172.92  |
| 2146 | [2026-03-06 12:20:58] ScheduledTask ID: 19 NAME: Multi-Cast Task has been successfully updated.                                             | fog      | 2026-03-06 12:20:58 | 172.28.172.92  |
| 2147 | [2026-03-06 12:39:43] Group ID: 42 NAME: sysprep-test-5004 has been successfully updated.                                                   | fog      | 2026-03-06 12:39:43 | 172.28.171.193 |
| 2148 | [2026-03-06 12:39:59] MulticastSession ID: 145 NAME: Multi-Cast Task - sysprep-test-5004 2026-03-06 12:39:58 has been successfully updated. | fog      | 2026-03-06 12:39:59 | 172.28.171.193 |
| 2149 | [2026-03-06 15:50:17] ScheduledTask ID: 20 NAME: Multi-Cast Task has been successfully updated.                                             | le.do    | 2026-03-06 15:50:17 | 10.24.193.251  |
| 2150 | [2026-03-06 16:21:15] ScheduledTask ID: 22 NAME: Multi-Cast Task has been successfully updated.                                             | le.do    | 2026-03-06 16:21:15 | 10.24.193.251  |
| 2151 | [2026-03-09 09:19:06] Task ID:  Name: Multiple Snapin -- orig Single has failed to save. Error: Required database field is empty: hostID    | iina     | 2026-03-09 09:19:06 | 10.24.193.58   |
| 2152 | [2026-03-09 09:19:14] Host ID: 66 NAME: 6037-GOLD has been successfully updated.                                                            | iina     | 2026-03-09 09:19:14 | 10.24.193.58   |
| 2153 | [2026-03-09 09:19:25] Task ID:  Name: Multiple Snapin -- orig Single has failed to save. Error: Required database field is empty: hostID    | iina     | 2026-03-09 09:19:25 | 10.24.193.58   |
+------+---------------------------------------------------------------------------------------------------------------------------------------------+----------+---------------------+----------------+

Tom Elliott

@mashina The history table issue’s I’m seeing appear to be legitimate:

You wouldn’t be able to deploy snapins to a host if the snapin isn’t associated to a host. That said, I don’t know exactly what deploy type, nor what actual “version”

while I can checkout the commit hash, it’s just a hash and not somethign I readily memorize.

your exact version of FOG would show on the bottom right of the UI when you login.

I believe your commit hash relates to working-1.6-beta.2273 or something like that.

That’s within 2 of the actual “current” but also notably it is within the save function rewrite. Which we definitely see in the history writing.

It appears like you’re trying to do a Multiple Snapin Task and this is failing?

mashina

This post is deleted!

mashina

@Tom-Elliott

FOG version: 1.6.0-beta.2273

Let’s ignore the Snapin errors for now. The error is thrown at the end of the Multicasting image.

Tom Elliott

@mashina Okay so just so I fully understand:

The database is successfully updating, but for some reason it’s not returning the exit code correctly.

I don’t know why (I do want to fix the error you’re seeing but it doesn’t appear to be causing a true “problem” just causes the machine to appear like there is a problem when after the reboot actually occurs), however all is perfectly fine just it might take a minute or 2 longer to actually get into a bootable/workable system?

So your issue is not at all related though the messaging is similar (Failed to update database) but its failing because it believes the task no longer exists (which indeed is true although only in the context that it is successfully completing the task, but not sending the expected code FOS is waiting for.)

(I know I’m seeming to ramble, just trying to get my thoughts out and help steer the issue toward whats actually wrong so we know where to look to hopefully fix it.)

The database is updated, but because FOS doesn’t get the code it expects, it thinks it needs to retry. The retry has nothing to associate to any more (Hence the no active task.)

Tom Elliott

@mashina I have made an update after being able to replicate the problem you described.

Issue it seems was an error 500 occuring on line 329 of the taskingelement.class.php element because it couldn’t find a relevant imaging log.

I’ve added code that seems to be able to address this though not sure what is actually wrong otherwise. WIth the patch I made things seem to complete okay so I think it’d work good for uni and multicast tasks if you’d be willing to update and test?

JGeear

@Tom-Elliott Hi Tom, The passwords in the UI and fogsettings file match and work via ftp.! However the passwords in the config.class.php file do not.( image url)

FOG ubuntu image fails to update database

121

12.6k

17.5k

156.3k