fineract-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ed Cable <edca...@mifos.org>
Subject Re: [Mifos-developer] Transactions executed multiple times
Date Thu, 15 Sep 2016 22:45:44 GMT
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 <arvind@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-developer@lists.sourceforge.net
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>



-- 
*Ed Cable*
Director of Community Programs, Mifos Initiative
edcable@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>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message