Hello,
My primary issue is the supervisor does not see or accept new jobs, when new jobs are submitted.
I've had to restore my xserve back to an older backup from a time macine backup, because of a serious crash. First I backed up the job list in /var/spool/qube/job to a server. I restored the HD to an older version. I copied back the job folder to /var/spool/qube/, and I actually rsynced all the mysql folders from yesterday, before the crash, to the new restore. So I rsynced ;
/usr/local/mysql-standard-4.1.22-apple-darwin8.5.1-i386
/usr/mysql
/usr/share/mysql
/private/var/mysql
. . . to the corresponding locations in the new restored xserve HD
I start the mysqld with ;
/Library/StartupItems/MySQLCOM/MySQLCOM start
I start the qube supervisor with ;
/Library/StartupItems/supervisor/supervisor start
and I refresh all the workers ;
/Applications/pfx/qube/sbin/qbadmin worker --refresh
. . . and I restarted all the workers on our servers
I did not get any errors starting the daemons ;
But the qube supervisor is not working correctly. I logged into mysql and listed the databases ;
mysql -u root -p
mysql> show databases ;
+----------+
| Database |
+----------+
| 126qube |
| 127qube |
| 128qube |
| 129qube |
| 130qube |
| 131qube |
| 132qube |
| 133qube |
| 134qube |
| 135qube |
| 136qube |
| 137qube |
| 138qube |
| 139qube |
| 140qube |
| 141qube |
| 142qube |
| 143qube |
| 144qube |
| 145qube |
| 146qube |
| 147qube |
| 148qube |
| 149qube |
| 150qube |
| 151qube |
| 152qube |
| 153qube |
| 154qube |
| 155qube |
| 156qube |
| 157qube |
| 158qube |
| 159qube |
| 160qube |
| 161qube |
| 162qube |
| 163qube |
| 164qube |
| 165qube |
| 166qube |
| 167qube |
| 168qube |
| 169qube |
| 170qube |
| mysql |
| qube |
| test |
+----------+
48 rows in set (0.00 sec)
so I tried to repair all of them just in case ;
mysqlcheck -p -r 170qube
mysqlcheck -p -o 170qube
. . . I did this for every database entry, but still the qube supervisor will not even show new jobs. Actually, the gui shows three jobs from over a month ago, which cannot be killed
I tried reinstalling the qube supervisor too, but this did not fix the issue.
What , if anything, can I do to get the supervisor working correctly again.
Please help,
Thanks,
ryjguy7