jobqueue after migration.

i've been using isp_copy to move servers to vps's to another datacentre.. and going from ubuntu 22.04 to 24.04 at the same time..
thread about this: https://forum.howtoforge.com/threads/quick-questions-about-ispcopy.93203/

last night, i switch over from our old mailserver to our new one.

the actual switchover, and run of ispconfig_update.sh was fine.

there seems to be an issue with the default repo rspamd on 24.04. i believe it's rspamd 3.8.1..
it doesn't update the gui. if i switch beween eg status, throughput or history, it appends it to the browser url, eg adds #status, but doesn't reload the page, i have to manually reload the whole page.. adding the rspamd.com repo and updating to 3.10.2 fixes the issue..
not a big problem, just mentioning it so people are aware of the fix..

but after running the ispconfig update, i then run a re-sync of the mailserver.
since then, the ispconfig gui keeps saying there's 78 jobs still to run.. but the jobqueue is empty..

i've run:

Code:

SELECT COUNT( * ) AS cnt, sys_datalog.server_id
    ->                 FROM sys_datalog, server
    ->                 WHERE (server.server_id = sys_datalog.server_id or sys_datalog.server_id = 0) AND sys_datalog.datalog_id > server.updated;

and that returns:
+-----+-----------+
| cnt | server_id |
+-----+-----------+
| 78 | 0 |
+-----+-----------+

now, server_id 0 is obviously the master server, but i was only running a resync on the mailserver, so i don't see how any thing for the master server should have been changed.

so now i'm unsure of the best way to resolve this..

 

ah. ok.. that clears that part up then.

and of course.. server_id 1 is the master...
and it's all rather obvious now.. had a slave test server that was powered off.. just turned that back on and the outstanding items got synced.
well. i feel rather stupid now.. in my defence, it's been a long night and day..
starting migrations just after midnight is great for not inconveniencing clients.. but it's not good for rational thought.