Hey Arvind, I won't be of any help but i'm going to cross-post this to the fineract developer's list as that should be the go-to place for any conversations like this. I think you might have specifically joined the mifos-developer list to start this conversation so sorry to point it away.
Members of our core team and some of the other partners in our community should be able to respond in the next 6 to 8 hours as they come online for the day. Ed On Thu, Sep 15, 2016 at 2:54 PM, Arvind Sujeeth <arv...@mines.io> wrote: > Hi all, > > I'm trying a load test where, as part of setup, I insert 100k clients > using the Batch API. This seems to be working (slowly), but there are a lot > of messages like this in the server logs: > > > [http-bio-8443-exec-132] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - > Duplicate entry '0000000031213' for key 'account_no_UNIQUE' > > [http-bio-8443-exec-132] WARN o.h.e.jdbc.spi.SqlExceptionHelper - SQL > Error: 1062, SQLState: 23000 > > [http-bio-8443-exec-132] WARN o.a.t.j.p.i.SlowQueryReport - Failed > Query Report SQL=insert into m_client (account_no, activatedon_userid, > activation_date, client_classification_cv_id, client_type_cv_id, > closedon_userid, closedon_date, closure_reason_cv_id, date_of_birth, > display_name, external_id, firstname, fullname, gender_cv_id, image_id, > lastname, legal_form_enum, middlename, mobile_no, office_id, > office_joining_date, reactivated_on_date, reactivated_on_userid, > rejectedon_userid, rejectedon_date, reject_reason_cv_id, > default_savings_account, default_savings_product, staff_id, status_enum, > sub_status, submittedon_userid, submittedon_date, transfer_to_office_id, > updated_by, updated_on, withdrawn_on_date, withdraw_reason_cv_id, > withdraw_on_userid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); > time=9 ms; > > [http-bio-8443-exec-98] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - > Duplicate entry '0000000031213' for key 'account_no_UNIQUE' > > [http-bio-8443-exec-127] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - > Duplicate entry '0000000031213' for key 'account_no_UNIQUE' > > for different account numbers (each of the 100k client's has a unique > account no). I only have one create client request per client in the batch, > but it appears a single request is being executed multiple times. Anyone > have any idea what is causing this behavior? > > thanks, > Arvind > > ------------------------------------------------------------ > ------------------ > Mifos-developer mailing list > mifos-develo...@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > -- *Ed Cable* Director of Community Programs, Mifos Initiative edca...@mifos.org | Skype: edcable | Mobile: +1.484.477.8649 *Collectively Creating a World of 3 Billion Maries | *http://mifos.org <http://facebook.com/mifos> <http://www.twitter.com/mifos>
