Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL Corruption Problem

 
Ron Patel
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I have a Web Service that uses a MySQL Database as its storage mechanism.

However, I'm seeing some kind of corruption problem with the database. After not sending anything to the database overnight, I cannot seem to get any data out from the database. However, I am able to write as much data as I want to the database. I have to clear the database and restart my app server for the database to work again.

I checked the validity of the connections and they are valid (they haven't expired).

This problem does not surface if I continue to write data to the database overnight.

Any thoughts on what could be the problem?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35266
383
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ron,
Does it work if you open a new connection and try to read from it?
 
Ron Patel
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No. The Control Center freezes too.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35266
383
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ron,
It sounds like the database is running out of resources. You would be better off closing the connection as soon as you are done with it to avoid this sort of problem.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic