Re: [SR-Users] ACCDB insert issues

Hi, Thanks. when i changed to myisam engine (after reading a little) the error stoped even on a very high number of CAPS. i will try to use the db_insert_mode = 1 to increase the speed of the transaction. BR, Uri Hi I've also seen this error "ERROR: acc [acc.c:405]: failed to insert into database ". This seem to happen when cdrs_procedure runs at the same time of acc table insert. Can also be reliably reproduced by locking the acc table, make a call (about 20 seconds or more), end the call, wait for a short while, unlock acc table. This causes this error, and Kamailio inserts duplicated INIVTE / BYE entries into acc table. The number of duplicated entries depends on how long you've locked the table for. So I think this acc insert error may have been to do with table locking when cdrs_procedure is run. When there are duplicated entries in acc table, cdrs_procedure takes the first INVITE/BYE entires and updated the cdrs table correctly. But threw an error when it hits the next duplicated entry and stop. So for us it didn't seem to cause any trouble for cdrs records so I didn't chase it further. But would be nice if we could stop/handle the duplicated entries some how. Not a fix at at all, just some clues that might help. Yufei On Wed, Mar 21, 2012 at 8:28 PM, Uri Shacked <ushacked(a)gmail.com> wrote: