FC2 - mysql - keeps inserting rows.

Patrick Boutilier boutilpj at ednet.ns.ca
Wed Jun 2 22:58:45 UTC 2004



Kevin M. Shortt wrote:
> 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.??


Is your perl script still running and stuck in a loop?


> 
> 
> Any and all comments are appreciated.
> 
> Thanks..
> 
> -k
> 
> 





More information about the fedora-list mailing list