1.5.0 RC9 - Scheduled tasks view "disables" the web UI

[Sebastian Roth]

@Taspharel Hmmm, nothing in the error logs anymore?! Well then we need to see what you have in the database. Open a terminal window on your FOG server (find the password in /var/www/html/fog/lib/fog/config.class.php

shell> mysql -u root -p
Enter password:
Welcome to...
...
mysql> use fog;
mysql> SELECT * FROM scheduledTasks\G
...
mysql> quit

Post what you see here in the forum either as text or picture.

[Taspharel]

Okay, here we go.

Doing this first thing in the morning yields:

MariaDB [fog]> SELECT * FROM scheduledTasks\G
*************************** 1. row ***************************
stID: 1
stName: Deploy Task
stDesc:
stType: C
stTaskTypeID: 1
stMinute: 50
stHour: 16
stDOM: 13
stMonth: 9
stDOW:
stIsGroup:
stGroupHostID: 2
stImageID: 0
stShutDown:
stOther1:
stOther2: -1
stOther3: fogadmin
stOther4: 1
stOther5:
stDateTime: 0
stActive: 1
*************************** 2. row ***************************
stID: 2
stName: Hardware Inventory Task
stDesc:
stType: C
stTaskTypeID: 10
stMinute: 10
stHour: 10
stDOM: 1
stMonth: 11
stDOW: 0
stIsGroup:
stGroupHostID: 82
stImageID: 0
stShutDown:
stOther1:
stOther2: -1
stOther3: fogadmin
stOther4:
stOther5:
stDateTime: 0
stActive: 1
2 rows in set (0.00 sec)

After that I scheduled a task, went to tasks view and waited for the freeze, after it shows the additional task:

*************************** 3. row ***************************
stID: 3
stName: Memtest86+ Task
stDesc:
stType: C
stTaskTypeID: 4
stMinute: 1
stHour: 1
stDOM: 1
stMonth: 1
stDOW: 1
stIsGroup:
stGroupHostID: 80
stImageID: 0
stShutDown:
stOther1:
stOther2: -1
stOther3: fogadmin
stOther4:
stOther5:
stDateTime: 0
stActive: 1
3 rows in set (0.00 sec)

[Tom Elliott]

@taspharel This only happens on scheduled tasks?

[Taspharel]

Just checked: Yes, all the other menu points in the tasks menu open correctly.

[Tom Elliott]

Do you do a lot of scheduled tasks? It sounds almost as if there’s a lot of delayed/cron jobs in the queue, based on what I’m hearing.

[Taspharel]

No, was the first time I tried it.

And according to the mysql thing there should only be 3 active scheduled tasks?

I just ran the mysql cleanup commands from the fog-wiki … problem remains.

[Tom Elliott]

I’m still unable to replicate this issue, would you be willing to install Working branch and see if it’s fixed in there for you? It may have been a Javascript thing that I fixed later in working.

[Tom Elliott]

This still really feels like something just isn’t jiving properly. I’m going to mark this solved as 3 weeks without any more word is a long time, I know I only responded yesterday and all. I’m unable to replicate, and I’m not sure that all people are seeing the problem. If this is still a problem, please let us know.

I’d also recommend jumping on working branch just to see if there’s something I’ve fixed and didn’t realize it.

[Taspharel]

Updated to working branch, same error still appears.

I don’t need the scheduled tasks urgently in any way, so just forget it if its working for everybody else

Thanks for your help!

[turtledillpickle]

I know this is quite an old topic, but we ran across this on the latest version of fog and I wanted to share my solution.

What ended up working for me was to get into the database console with mysql -u root

I then selected the fog database use fog;

Then I listed out the tasks SELECT * FROM scheduledTasks;

In my case the most recent record had an stID of 13, so I dropped that row, which fixed the issue DELETE FROM scheduledTasks where stID = 13;. After that the scheduled tasks menu loads fine.