Topic: Strange problems with Mysql after power failure

[jameswilson]

Ive been trying to to find this. But also hoping an update would fix it. But its been a few months now and it hasnt fixed itself (i know it was unlikly but it does sometimes)

anyway
on bootup of the machine it keep saying its 'waiting for mysql'

the mysql current log is empty so it the historic ones for some reason

Oct 30 10:23:57 smebox esmith::event[1590]: Running event handler: /etc/e-smith/events/bootstrap-console-save/S40mysql-load-tables
Oct 30 10:23:57 smebox esmith::event[1590]: mysqld is disabled - no tables restored 
Oct 30 10:23:57 smebox esmith::event[1590]: S40mysql-load-tables=action|Event|bootstrap-console-save|Action|S40mysql-load-tables|Start|1319970237 30007|End|1319970237 92315|Elapsed|0.062308
Oct 30 10:23:57 smebox esmith::event[1590]: Running event handler: /etc/e-smith/events/bootstrap-console-save/S50navigation-conf

im assuming this is why its waiting for it to start

If i start mysql manually after a reboot all seems wel but id like to stop the error plus it cant load certain things at boot as mysql isnt started.

Any ideas please?

Thanks

James

[jameswilson]

I also get a lot of

Oct 30 10:27:26 smebox mysqld: Starting MySQL:  succeeded
Oct 30 10:28:05 smebox last message repeated 12 times
Oct 30 10:29:11 smebox last message repeated 6 times
Oct 30 10:30:17 smebox last message repeated 8 times
Oct 30 10:31:33 smebox last message repeated 14 times
Oct 30 10:32:49 smebox last message repeated 5 times
Oct 30 10:34:08 smebox last message repeated 4 times
Oct 30 10:35:19 smebox last message repeated 4 times
Oct 30 10:36:23 smebox last message repeated 4 times
Oct 30 10:37:26 smebox last message repeated 4 times
Oct 30 10:38:32 smebox last message repeated 6 times
Oct 30 10:39:33 smebox last message repeated 5 times
Oct 30 10:40:40 smebox last message repeated 5 times
Oct 30 10:41:51 smebox last message repeated 2 times

which im unsure is an issue or not

[cactus]

What is the output off the following commands:

Code: [Select]

sv s mysqd
mysqlcheck --all-databases

[jameswilson]

sv s mysqld (i assume you meant this)

down: mysqld: 34292s; run: log: (pid 1504) 34292s

mysqlcheck --all-databases

all databases OK (i assume you dont want the list?)

thanks for the reply

[cactus]

sv s mysqld (i assume you meant this)
mysqlcheck --all-databases

Then your databases seem to be OK. When are you experiencing these problems? Only on restarts? Every restart or only specific ones, e.g. after updates and/or configuration changes?

[jameswilson]

After every restart. I have to manually start mysql Im wondering if its no longer in the init but im out of my depth in there

[cactus]

After every restart. I have to manually start mysql Im wondering if its no longer in the init but im out of my depth in there

Did you already look through /var/log/messages* to see what might be the error message that is repeated, there should be some more information in one of them.

[jameswilson]

i copied and pasted it as its in the log. I assumed there would be an error then the 'last message repeated' but that is as it shows

[Stefano]

what's the output of

Code: [Select]

config show mysqld
?

[jameswilson]

mysqld=service
    LocalNetworkingOnly=no
    TCPPort=3306
    access=public
    status=disabled

[cactus]

Code: [Select]

mysqld=service
    LocalNetworkingOnly=no
    TCPPort=3306
    access=public
    status=disabled

Why is it disabled?  Did you do that on purpose? I think this is the reason of your errors, MySQL server is not running at boot time... when trying to access it is not responding triggering the error messages.

To restore the status to enabled execute the following code:

Code: [Select]

db configuration setprop mysqld status enabled
NB Next time, please use the code element for console output, that is easier when quoting as this will make sure that is also in the quote (since only one level of quotes seem to be allowed in the forums).

[jameswilson]

no i havnt disabled it. Well not intentionally

[jameswilson]

how do i enable it?

James

[cactus]

how do i enable it?

James

See my earlier post. I was still modifying it at the time of your reply, so you might have missed it:

To restore the status to enabled execute the following code:

Code: [Select]

db configuration setprop mysqld status enabled

[jameswilson]

Wonderful Wonderful

Many thanks again guys that was all it was.

Thankyou

James