FC2 - mysql - keeps inserting rows.

Kevin M. Shortt shortt at cgicafe.com
Wed Jun 2 21:34:56 UTC 2004


I have a really wierd problem.

I created a database.
I created a table. (3 to exact)

I created a test perl script to use DBI/DBD to insert a row.

Well, after that was done I ran a select from the mysql prompt
to verify my insertion. I noticed more than one row..then that
number of rows kept growing.

So...I look for processes in perl and mysql.
I installed mytop. I see nothing.

So..I deleted all rows of said table.
Rows keep coming back...in duplicate.

So..I restarted the server. (service mysqld restart)
Rows keep coming back...

So..I stopped then started the server. (service mysqld stop; service
mysqld start)
Rows keep coming back...

Then I dropped the table. (drop table tablename)
I recreated the table. (create table...(used the same name and structure))

Miraculously...rows are still coming back.

Anyone!!!???? have a clue what is happening.??


Any and all comments are appreciated.

Thanks..

-k





More information about the fedora-list mailing list