Old multicast sessions not clearing

[forte647]

Hey again. I usually just name my multicast sessions “1” or “q” or whatever to go through my machines as fast as possible. But lately the old sessions have not been clearing. They don’t show up in the active task queue at the bottom of the image management page, but for example if I try to make another session called “1”, it tells me there’s already a session queued by that name, but it’s not in the list.

Any ideas on how to wipe my multicast task queue?

[Quazz]

https://wiki.fogproject.org/wiki/index.php?title=Multicasting#Kill_Multitasking

Although it would be interesting and useful to know why this is happening. Does anything show up in the Apache error log when you create multicast sessions perhaps?

[Wayne Workman]

What version of FOG?

[forte647]

@Wayne-Workman

Running Version 1.3.0-RC-4
SVN Revision: 5941

I ran
mysql -u root <-p password> fog
truncate table multicastSessions;
truncate table multicastSessionsAssoc;
exit;

and it’s asking for more arguments to truncate the tables. "you must specify either ‘–size’ or ‘–reference’

[Wayne Workman]

@forte647 The earlier RCs had some problems with muticast. Your very first order of business here in fixing this problem is updating to RC-7, follow instructions here:
https://wiki.fogproject.org/wiki/index.php?title=Upgrade_to_trunk

[forte647]

@Wayne-Workman

All right i’m at RC-7

[Wayne Workman]

@forte647 said in Old multicast sessions not clearing:

@Wayne-Workman
All right i’m at RC-7

Ok, now follow these steps to clear the tasks, restart the FOGMulticastManager, and afterwards try multicast again the way you were doing it before.
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_Downloading_-_Multicast#Clear_DB_of_non-essential_multicast_data

[forte647]

@Wayne-Workman

All right I got. The lines:

DELETE FROM multicastSessions WHERE 1;
DELETE FROM multicastSessionsAssoc WHERE 1;

returned syntax errors “check your manual”. but truncating the two tables worked.

everything seems to work normally now. thanks, guys.