PDA

View Full Version : Server status job



Stevo
09-Feb-2017, 15:07
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 <server id string>

Any suggestions?

--
Stevo

smflood
10-Feb-2017, 12:54
On 09/02/17 14:07, Stevo wrote:

> 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 <server id string>
>
> Any suggestions?

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.
------------------------------------------------------------------------

Stevo
10-Feb-2017, 21:14
Simon Flood sounds like they 'said':

> I wonder if this is related to
> https://forums.suse.com/showthread.php?8951 ... ?
>
> HTH.
So my response to Simon's comment is...

My SMT box is sles11sp4

--
Stevo

jmozdzen
14-Feb-2017, 17:48
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

Stevo
14-Feb-2017, 22:32
jmozdzen sounds like they 'said':

>
> 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 --------------------
>

So my response to jmozdzen's comment is...

Thanks a ton! That fixed it!

--
Stevo