OpenVZ Forum


Home » Mailing lists » Users » Hardware reboot and database connection problems
Re: Hardware reboot and database connection problems [message #9961 is a reply to message #9870] Wed, 31 January 2007 16:23 Go to previous message
dev is currently offline  dev
Messages: 1693
Registered: September 2005
Location: Moscow
Senior Member

Paul,

make sure your VE doesn't expirience resource shortages
(check failcnt column in /proc/user_beancounters).

next, check that mysql is shutdown gracefully in VE.
For this you can check whether manual mysql and/or VE stop
before node reboot helps.

Thanks,
Kirill

> Hi Guys,
>
> I have a serious problem occurring on my VPS when there is a hardware
> reboot (as opposed to individual VPS reboot).
>
> My java application runs under Tomcat and connects to MySQL.
>
> I have installed MySQL 5 and use this. Both tomcat and mysql are
> installed under /usr/local/
>
> When the hardware reboots, there are connectivity issues with my
> database, the application seems unable to connect to MySQL under certain
> circumstances, however the background thread that runs in my app CAN
> connect, which leads to database synchronisation issues.
>
> As a result I have to login via SSH and reboot the VE once the node has
> booted.
>
> What could be the root cause of this and what can be done to help.
>
> Many Thanks
> Paul
 
Read Message
Read Message
Previous Topic: vzctl start id "VE start in progress", vzctl status "VEID exist mounted down",
Next Topic: DNS not resolving
Goto Forum:
  


Current Time: Sun Sep 29 01:17:10 GMT 2024

Total time taken to generate the page: 0.05596 seconds