Could this be because of a MySql default behaviour?
One behaviour I have noticed: If my table has an auto-increment primary key,
and if there is a unique key constraint on one of the other columns of the
table:
Then if I try to insert a row with a duplicate value for this
field with unique key constraint, then MySQL throws an error.
But, when I try to insert another row with unique values, then
I have seen that MySQL “skips” a value on the auto-increment primary key.
>From this thread:
http://stackoverflow.com/questions/2787910/why-does-mysql-autoincrement-increase-on-failed-inserts
It looks like this is the way MySQL was designed to improve concurrency and
there may not be anything we can do to correct this situation.
This does not cause any negative impact on Mifos functionality though. So, my
thought is to ignore the “skipping” of IDs – unless this causes issues for
business.
Hi Sreenivas,
Does this cause any operational issues for you? I just think that it may be a
technical issue that is difficult to correct and correcting it could impact
performance of Mifos.
Thanks
Binny
From: Nayan Ambali [mailto:[email protected]]
Sent: 26 September 2014 17:33
To: A good place to start for users or folks new to Mifos.
Subject: Re: [Mifos-users] [Mifos-developer] M_client Auto Increment
Srini,
That is amazing catch!! But it is not really a functional bug, yes it needs to
be fixed.
@Subbu, can please reproduce and log to jira.
Thanks
Nayan Ambali
Thanks and Regards,
Nayan Ambali
+91 9591996042
skype: nayangambali
On Fri, Sep 26, 2014 at 5:17 PM, srinivasa Rao Yedida <[email protected]>
wrote:
HI Sughosh
I found issue because of the maker and checker Enabled? Yes. Now I Made "NO"
and auto increment client account number is generating order by sequence
numbers.
@ Santosh can your test same from you end fix in next release.
Thanks
Srinivasa Rao Yedida
On Thu, Sep 25, 2014 at 11:17 AM, Santosh Math
<[email protected]> wrote:
Hi Srinivasa,
Can you come on Skype call so that you can share the screen, now? I also
tested in my machine and client ids are continuous in number, unless I delete
any client(who is not yet activated) in between. I need to see what's wrong.
Regards
Santosh
On Thu, Sep 25, 2014 at 11:12 AM, srinivasa Rao Yedida <[email protected]>
wrote:
Hi Sughosh
Thanks, not deleted any clients still it is generating similar (may possible to
delete one client not every time)
On Thu, Sep 25, 2014 at 11:04 AM, Sughosh Bharadwaj
<[email protected]> wrote:
Hello Srinivas,
For example, you create a client whose id is 100 and you delete this client.
The id for the next client created will be 101.
This is not an issue. (Normal behaviour in MySQL)
Regards.
Sughosh
On Thu, Sep 25, 2014 at 10:39 AM, srinivasa Rao Yedida <[email protected]>
wrote:
Hi
PFA M_loan table, auto increment Customer account number order is missing one
account number
Ex:
Created customer Id with - Id provided 000007099
created another customer ID generating -000007101
missing always this customer Id - 000007100
Please help me in above issue
Thanks
Srinviasarao Yedida
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311
<http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk>
&iu=/4140/ostg.clktrk
Mifos-developer mailing list
[email protected]
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311
<http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk>
&iu=/4140/ostg.clktrk
Mifos-developer mailing list
[email protected]
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311
<http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk>
&iu=/4140/ostg.clktrk
Mifos-developer mailing list
[email protected]
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer
--
Thanks & Regards
Santosh Math
Mifos Trainer
Conflux Technologies Pvt Ltd
Skype Id: mifos.support
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311
<http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk>
&iu=/4140/ostg.clktrk
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users