Re: Very Strange problem. - TP R Murthy - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlRe: Very Strange problem.

From	Sent On	Attachments
TP R Murthy	02 May 2002 22:34
Jeremy Zawodny	02 May 2002 23:02
TP R Murthy	02 May 2002 23:09

Subject:	Re: Very Strange problem.
From:	TP R Murthy (r.mu...@ceruleaninfotech.com)
Date:	05/02/2002 11:09:10 PM
List:	com.mysql.lists.mysql

Hi,

I do commit alright. This doesn't happen often. i insert into the tables from a java web app. The db and the data in it is fine when i stop and restart the web server(tomcat). sometimes when i restart the machine, data is all intact.

I was using the mysql 4 max before. Same thing happened with that too. i guessed that was because of the alpha version db. so i downgraded to mysql3.23.

regards,

On Thu, 2 May 2002, Jeremy Zawodny wrote:

On Fri, May 03, 2002 at 11:04:29AM +0530, TP R Murthy wrote:

I have created only one database with 18 tables. Only one of these tables is MyIsam table. rest are BDB tables. When the server is up, it works fine. but when i reboot the machine, few of the tables loose all the records they held before the machine was rebooted. This doesn't happen everytime. It happens randomly.

One more thing i noticed is that when i run the 'show table status' it says 10000000 rows in the table that has lost all the records.

This will sound dumb, but are you sure you're committing your transactions?

_________________________________________________________________ Life is a Dream. Dont Wake up.