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