Hi Adi, Each request in the batch is a create client request with a unique account no, as I said. There should not be any requests with the same account no. Is it possible the batch API is executing requests multiple times for some reason? is there any way for a request to be executed multiple times?
Arvind > On Sep 15, 2016, at 8:57 PM, Adi Raju <adi.r...@confluxtechnologies.com> > wrote: > > Arvind, > > The error is self explanatory. > Your script is violating 'account_no_UNIQUE' unique constraint on the > m_client table. > Please identify if your script itself is inserting duplicate account no. > > Alternatively, it is possible that you have configured "Account Number > Preferences" which is causing this issue. > > Regards, > Adi > > -----Original Message----- > From: Ed Cable [mailto:edca...@mifos.org] > Sent: 16 September 2016 04:16 > To: Mifos software development <mifos-develo...@lists.sourceforge.net>; > dev@fineract.incubator.apache.org > Subject: Re: [Mifos-developer] Transactions executed multiple times > > 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> >
