Re: Accounting to db, duplicate entries (again)

2005-08-02 Thread Alan DeKok
Roger Kristiansen <[EMAIL PROTECTED]> 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 elminat

Accounting to db, duplicate entries (again)

2005-08-02 Thread Roger Kristiansen
Hi, I'm having some problems with Alive messages that follow immediately after Start messages. Sometimes this causes two entries with the same acctuniqeid to be entered into the database, the only thing separating the two being a few hundreds of a second on the acctstarttime field. I find thi