Re: Accounting to db, duplicate entries (again)

Roger Kristiansen <roger.kristiansen@cc.uit.no> wrote:

I'm not at all experienced with databases, but I was thinking I could lock the accounting table while inserting the Start message, so that the query in pnt. 2 could not be performed until the Insert in pnt. 1 is finished. Wouldn't this elminate the problem in pnt. 3?

It would slow the server down considerably. If you're willing to wait for SQL updates, you can use "rlm_sql_log" in the CVS head. It avoids these issues by post-processing the logs, and not running the SQL statements in a live server. Alan DeKok.