[Koha] Database increment error returned 23.11

[Katrin Fischer]

Hi,

I didn't realize that it was the same installation/library.

What I was trying to find out with the test was if this was the old
issue or a new one. If the test didn't result in a doubled up
itemnumber, this might be something else.

Maybe someone else has an idea how this could happen. As the itemnumber
is set by the database, I am not sure how it's possible.

Re-adding the mailing list.

Katrin

On 30.05.24 17:00, City & Guilds of London Art School Admin wrote:
> Hi Katrin,
>
> /> in this case I think it would be good to have the exact Koha
> version and the DBMS version.../
>
> I begin my email with that information.
>
> /> resetting the PK counters on MySQL restart might be good.
> /
>
> Do you mean resetting the auto increment count?
>
> /> What you can do.../
>
> Yes, I can test that the documented fix works as you decribe, but
> that's not the concern either Christina or myself have raised. Which
> is more about understanding why the issue has re-occured in an
> installation with that fix applied following an update, and
> understanding if that documented fix is still relevant.
>
> All the best,
>
> Chris
>
>
> On Thu, May 30, 2024 at 1:37 PM Katrin Fischer
> <katrin.fischer.83 at web.de> wrote:
>
>     Hi Chris,
>
>     in this case I think it would be good to have the exact Koha
>     version and the DBMS version to be able to investigate further.
>
>     Also verifying if the script does what it's supposed to -
>     resetting the PK counters on MySQL restart might be good.
>
>     What you can do:
>
>       * Create an item, note the itemnumber
>       * Delete it
>       * Restart MySQL
>       * Create a new item
>       * Verify the itemnumber - if it's the same as the deleted item,
>         something is not right yet.
>
>     Hope that helps,
>
>     Katrin
>
>     On 30.05.24 14:27, City & Guilds of London Art School Admin wrote:
>>     Hi Katrin,
>>
>>     These points are addressed in the email Christina sites:
>>     https://lists.katipo.co.nz/public/koha/2023-December/060411.html
>>
>>     The problem is exactly recurrence of the issue, after the fix
>>     described in the Wiki had been applied, and with a more recent
>>     version of the db.
>>
>>     All the best,
>>
>>     Chris
>>
>>
>>     On Thu, May 30, 2024 at 1:12 PM Katrin Fischer
>>     <katrin.fischer.83 at web.de> wrote:
>>
>>         Hi Christina,
>>
>>         did you see the wiki page about the issue?
>>
>>         https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
>>
>>         It should only appear with certain older versions of DBMS. So
>>         this would
>>         be a first thing to check.
>>
>>         If you happen to use one of the older versions, maybe
>>         consider updating.
>>         Otherwise you will have to implement the script described in
>>         the wiki.
>>
>>         Hope this helps,
>>
>>         Katrin
>>
>>         On 28.05.24 10:00, Fairlamb, Christina wrote:
>>         > Morning,
>>         >
>>         > I just upgraded to 23.11 today and have come across the
>>         same issue as
>>         > another user back in december.
>>         >
>>         > Database discrepancy flagged after Koha upgrade:
>>         >
>>         >
>>         https://lists.katipo.co.nz/public/koha/2023-December/060411.html
>>         >
>>         > I've done the same routine as the last time this cropped up a
>>         > few major versions ago and I've deleted the entries in the
>>         > deletedbiblioitems table, but I'm also worried that this
>>         issue is back.
>>         >
>>         _______________________________________________
>>
>>         Koha mailing list http://koha-community.org
>>         Koha at lists.katipo.co.nz
>>         Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>