Server status job

SUSE Product Topics SLES Updates
1

Had some storage issues on the LUN where my SMT box lives, and now my
status jobs I have in my cron job don’t all work. I get this back when
I try to run some of them:

DBD::mysql::db do failed: Table ‘./smt/JobQueue’ is marked as crashed
and should be repaired at /usr/lib/perl5/vendor_perl/5.10.0/SMT/Job.pm
line 579.

Job is this:

/usr/sbin/smt-job --create -t patchstatus -g

Any suggestions?

–
Stevo

2

On 09/02/17 14:07, Stevo wrote:
[color=blue]

Had some storage issues on the LUN where my SMT box lives, and now my
status jobs I have in my cron job don’t all work. I get this back when
I try to run some of them:

DBD::mysql::db do failed: Table ‘./smt/JobQueue’ is marked as crashed
and should be repaired at /usr/lib/perl5/vendor_perl/5.10.0/SMT/Job.pm
line 579.

Job is this:

/usr/sbin/smt-job --create -t patchstatus -g

Any suggestions?[/color]

I wonder if this is related to
https://forums.suse.com/showthread.php?8951 … ?

HTH.

Simon
SUSE Knowledge Partner

If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below. Thanks.

3

Simon Flood sounds like they ‘said’:
[color=blue]

I wonder if this is related to
https://forums.suse.com/showthread.php?8951 … ?

HTH.[/color]
So my response to Simon’s comment is…

My SMT box is sles11sp4

–
Stevo

4

Hi Stevo,

a classical case of “database maintenance needed”. The MYSQL database operating in the back of the SMT server expects a “repair” operation for the referenced table (database “smt”, table “JobQueue”). Lilkely other tables are affected as well.

mysqlcheck -uroot -p<mysql-root-user-password> --auto-repair --check --optimize --all-databases

https://www.suse.com/support/kb/doc/?id=7004986 lists the steps you may have taken to create up-to-date backups and how to perform disaster recovery.

Regards,
J

5

jmozdzen sounds like they ‘said’:
[color=blue]

Hi Stevo,

a classical case of “database maintenance needed”. The MYSQL database
operating in the back of the SMT server expects a “repair” operation
for the referenced table (database “smt”, table “JobQueue”). Lilkely
other tables are affected as well.

Code:

mysqlcheck -uroot -p<mysql-root-user-password> --auto-repair

–check --optimize --all-databases --------------------
[/color]

So my response to jmozdzen’s comment is…

Thanks a ton! That fixed it!

–
Stevo