You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Kelvin Ikome <kv...@gmail.com> on 2023/10/24 07:44:57 UTC
Fineract missing DB ids
Hi devs,
I am experiencing an issue where Fineract generates DB ids which skip
through all even numbers (1, 3, 5, 7...). This is present in all certain DB
tables (like m_loan, m_client). However, it seems to only be present in
certain environments of the deployment but not in all.
Does anyone know what could be causing this or a way to resolve this? Any
help/pointers would be greatly appreciated.
Please note, I'm running Fineract 1.8.3 with mysql v8 DB.
Kind regards,
Kelvin
Re: Fineract missing DB ids
Posted by Kelvin Ikome <kv...@gmail.com>.
Hi Adam,
Thank you for pointing that out. I will make the necessary adjustments.
And thanks to everyone else who responded. Your suggestions have been
helpful.
Kind regards
On Tue, Oct 24, 2023 at 11:06 AM Ádám Sághy <ad...@gmail.com> wrote:
> Hi
>
> Your mysql is configured to increase the auto increment values by 2.
>
> if you dont like this behaviour, you might wanna change it to 1.
>
> Regards,
> Adam
>
> Sent from my iPhone
>
> On Oct 24, 2023, at 12:03, Kelvin Ikome <kv...@gmail.com> wrote:
>
>
> Hi all,
>
> Thanks for your quick response. Please find details to your responses
> below.
>
> @Victor I have not been able to replicate this issue as it worked fine on
> my development environment, together with the UAT environment. I only
> experience this in OAT and PROD.
>
> @Adam, please find the results below.
> [image: image.png]
>
> Kind regards,
> Kelvin
>
> On Tue, Oct 24, 2023 at 9:58 AM Chantilly Muyaya <lu...@gmail.com>
> wrote:
>
>> Hello,
>>
>> In the m_client table, this behavior will occur when you fill in the
>> creation customer form with an existing value in the database for the
>> mobile_no and external_id columns, because these columns are supposed to
>> have unique data. In this case, MySQL will consider this operation despite
>> the exception raised by fineract. When you correct the operation, you will
>> raise the id jump.
>>
>> To resolve this in my case, I authorized the database to have the same
>> phone number or external id more than one time. With this MySQL script,
>>
>> Alter table m_client drop index external_id
>> Alter table m_client drop index mobile_no
>>
>> Regard
>>
>> Chantilly Muyaya
>>
>>
>>
>> Le mar. 24 oct. 2023 à 09:05, VICTOR MANUEL ROMERO RODRIGUEZ <
>> victor.romero@fintecheando.mx> a écrit :
>>
>>> Hello,
>>>
>>> Is there any way to reproduce the issue? Could you please describe the
>>> steps to reproduce this behaviour?
>>>
>>> Regards
>>>
>>> Victor
>>>
>>> El mar, 24 oct 2023 a las 1:45, Kelvin Ikome (<kv...@gmail.com>)
>>> escribió:
>>>
>>>> Hi devs,
>>>>
>>>> I am experiencing an issue where Fineract generates DB ids which skip
>>>> through all even numbers (1, 3, 5, 7...). This is present in all certain DB
>>>> tables (like m_loan, m_client). However, it seems to only be present in
>>>> certain environments of the deployment but not in all.
>>>>
>>>> Does anyone know what could be causing this or a way to resolve this?
>>>> Any help/pointers would be greatly appreciated.
>>>>
>>>> Please note, I'm running Fineract 1.8.3 with mysql v8 DB.
>>>>
>>>> Kind regards,
>>>> Kelvin
>>>>
>>>
Re: Fineract missing DB ids
Posted by Ádám Sághy <ad...@gmail.com>.
Hi
Your mysql is configured to increase the auto increment values by 2.
if you dont like this behaviour, you might wanna change it to 1.
Regards,
Adam
Sent from my iPhone
> On Oct 24, 2023, at 12:03, Kelvin Ikome <kv...@gmail.com> wrote:
>
>
>
>
> Hi all,
>
>
>
>
> Thanks for your quick response. Please find details to your responses below.
>
>
>
>
> @Victor I have not been able to replicate this issue as it worked fine on my
> development environment, together with the UAT environment. I only
> experience this in OAT and PROD.
>
>
>
>
>
> @Adam, please find the results below.
>
>
> 
>
>
>
>
>
> Kind regards,
>
> Kelvin
>
>
>
>
> On Tue, Oct 24, 2023 at 9:58 AM Chantilly Muyaya
> <[lukumubarth@gmail.com](mailto:lukumubarth@gmail.com)> wrote:
>
>
>> Hello,
>
> In the m_client table, this behavior will occur when you fill in the
> creation customer form with an existing value in the database for the
> mobile_no and external_id columns, because these columns are supposed to
> have unique data. In this case, MySQL will consider this operation despite
> the exception raised by fineract. When you correct the operation, you will
> raise the id jump.
>
> To resolve this in my case, I authorized the database to have the same phone
> number or external id more than one time. With this MySQL script,
>
>>
>>
>
>>
>> Alter table m_client drop index external_id
>>
>> Alter table m_client drop index mobile_no
>>
>>
>
>>
>> Regard
>>
>>
>
>>
>> Chantilly Muyaya
>>
>>
>
>>
>>
>
>>
>>
>
>>
>> Le mar. 24 oct. 2023 à 09:05, VICTOR MANUEL ROMERO RODRIGUEZ
<[victor.romero@fintecheando.mx](mailto:victor.romero@fintecheando.mx)> a
écrit :
>
>>
>>> Hello,
>>>
>>>
>
>>>
>>> Is there any way to reproduce the issue? Could you please describe the
steps to reproduce this behaviour?
>>>
>>>
>
>>>
>>> Regards
>>>
>>>
>
>>>
>>> Victor
>>>
>>>
>
>>>
>>> El mar, 24 oct 2023 a las 1:45, Kelvin Ikome
(<[kvnikome@gmail.com](mailto:kvnikome@gmail.com)>) escribió:
>
>>>
>>>> Hi devs,
>>>>
>>>>
>
>>>>
>>>> I am experiencing an issue where Fineract generates DB ids which skip
through all even numbers (1, 3, 5, 7...). This is present in all certain DB
tables (like m_loan, m_client). However, it seems to only be present in
certain environments of the deployment but not in all.
>>>>
>>>>
>
>>>>
>>>> Does anyone know what could be causing this or a way to resolve this? Any
help/pointers would be greatly appreciated.
>>>>
>>>>
>
>>>>
>>>> Please note, I'm running Fineract 1.8.3 with mysql v8 DB.
>>>>
>>>>
>
>>>>
>>>> Kind regards,
>>>>
>>>> Kelvin
Re: Fineract missing DB ids
Posted by Kelvin Ikome <kv...@gmail.com>.
Hi all,
Thanks for your quick response. Please find details to your responses below.
@Victor I have not been able to replicate this issue as it worked fine on
my development environment, together with the UAT environment. I only
experience this in OAT and PROD.
@Adam, please find the results below.
[image: image.png]
Kind regards,
Kelvin
On Tue, Oct 24, 2023 at 9:58 AM Chantilly Muyaya <lu...@gmail.com>
wrote:
> Hello,
>
> In the m_client table, this behavior will occur when you fill in the
> creation customer form with an existing value in the database for the
> mobile_no and external_id columns, because these columns are supposed to
> have unique data. In this case, MySQL will consider this operation despite
> the exception raised by fineract. When you correct the operation, you will
> raise the id jump.
>
> To resolve this in my case, I authorized the database to have the same
> phone number or external id more than one time. With this MySQL script,
>
> Alter table m_client drop index external_id
> Alter table m_client drop index mobile_no
>
> Regard
>
> Chantilly Muyaya
>
>
>
> Le mar. 24 oct. 2023 à 09:05, VICTOR MANUEL ROMERO RODRIGUEZ <
> victor.romero@fintecheando.mx> a écrit :
>
>> Hello,
>>
>> Is there any way to reproduce the issue? Could you please describe the
>> steps to reproduce this behaviour?
>>
>> Regards
>>
>> Victor
>>
>> El mar, 24 oct 2023 a las 1:45, Kelvin Ikome (<kv...@gmail.com>)
>> escribió:
>>
>>> Hi devs,
>>>
>>> I am experiencing an issue where Fineract generates DB ids which skip
>>> through all even numbers (1, 3, 5, 7...). This is present in all certain DB
>>> tables (like m_loan, m_client). However, it seems to only be present in
>>> certain environments of the deployment but not in all.
>>>
>>> Does anyone know what could be causing this or a way to resolve this?
>>> Any help/pointers would be greatly appreciated.
>>>
>>> Please note, I'm running Fineract 1.8.3 with mysql v8 DB.
>>>
>>> Kind regards,
>>> Kelvin
>>>
>>
Re: Fineract missing DB ids
Posted by Chantilly Muyaya <lu...@gmail.com>.
Hello,
In the m_client table, this behavior will occur when you fill in the
creation customer form with an existing value in the database for the
mobile_no and external_id columns, because these columns are supposed to
have unique data. In this case, MySQL will consider this operation despite
the exception raised by fineract. When you correct the operation, you will
raise the id jump.
To resolve this in my case, I authorized the database to have the same
phone number or external id more than one time. With this MySQL script,
Alter table m_client drop index external_id
Alter table m_client drop index mobile_no
Regard
Chantilly Muyaya
Le mar. 24 oct. 2023 à 09:05, VICTOR MANUEL ROMERO RODRIGUEZ <
victor.romero@fintecheando.mx> a écrit :
> Hello,
>
> Is there any way to reproduce the issue? Could you please describe the
> steps to reproduce this behaviour?
>
> Regards
>
> Victor
>
> El mar, 24 oct 2023 a las 1:45, Kelvin Ikome (<kv...@gmail.com>)
> escribió:
>
>> Hi devs,
>>
>> I am experiencing an issue where Fineract generates DB ids which skip
>> through all even numbers (1, 3, 5, 7...). This is present in all certain DB
>> tables (like m_loan, m_client). However, it seems to only be present in
>> certain environments of the deployment but not in all.
>>
>> Does anyone know what could be causing this or a way to resolve this? Any
>> help/pointers would be greatly appreciated.
>>
>> Please note, I'm running Fineract 1.8.3 with mysql v8 DB.
>>
>> Kind regards,
>> Kelvin
>>
>
Re: Fineract missing DB ids
Posted by Ádám Sághy <ad...@gmail.com>.
Please execute the below command and share the results:
SHOW VARIABLES LIKE 'auto_inc%'
Regards,
Adam
> On 24 Oct 2023, at 10:04, VICTOR MANUEL ROMERO RODRIGUEZ <vi...@fintecheando.mx> wrote:
>
> Hello,
>
> Is there any way to reproduce the issue? Could you please describe the steps to reproduce this behaviour?
>
> Regards
>
> Victor
>
> El mar, 24 oct 2023 a las 1:45, Kelvin Ikome (<kvnikome@gmail.com <ma...@gmail.com>>) escribió:
>> Hi devs,
>>
>> I am experiencing an issue where Fineract generates DB ids which skip through all even numbers (1, 3, 5, 7...). This is present in all certain DB tables (like m_loan, m_client). However, it seems to only be present in certain environments of the deployment but not in all.
>>
>> Does anyone know what could be causing this or a way to resolve this? Any help/pointers would be greatly appreciated.
>>
>> Please note, I'm running Fineract 1.8.3 with mysql v8 DB.
>>
>> Kind regards,
>> Kelvin
Re: Fineract missing DB ids
Posted by VICTOR MANUEL ROMERO RODRIGUEZ <vi...@fintecheando.mx>.
Hello,
Is there any way to reproduce the issue? Could you please describe the
steps to reproduce this behaviour?
Regards
Victor
El mar, 24 oct 2023 a las 1:45, Kelvin Ikome (<kv...@gmail.com>)
escribió:
> Hi devs,
>
> I am experiencing an issue where Fineract generates DB ids which skip
> through all even numbers (1, 3, 5, 7...). This is present in all certain DB
> tables (like m_loan, m_client). However, it seems to only be present in
> certain environments of the deployment but not in all.
>
> Does anyone know what could be causing this or a way to resolve this? Any
> help/pointers would be greatly appreciated.
>
> Please note, I'm running Fineract 1.8.3 with mysql v8 DB.
>
> Kind regards,
> Kelvin
>