Anonymous Monk has asked for the
wisdom of the Perl Monks concerning the following question:
I need to tail -f radius accounting files mounted on multiple nfs mounted servers and parse/insert them into a db. I have a script that does one file (I have an instance running for each file) already which, for the most part, works. However, at the end of every hour, I run a reconciliation report and find out that anywhere from 5-30% of the records weren't inserted into the database. I also get a lot of DBI errors while inserting indicating that a duplicate record already exists, meaning that the script proccessed the same line over again. Any ideas?