[Koha] Cataloging Record Uploading Process Stalls -- Possible Solution

2021-04-07 Thread Charles Kelley
Hi, all!

About three months ago, my library moved its Koha ILS to a new server.
The transition was not ideal but it was smooth enough.

We still catalog a bit on the old laptop and last week we extracted and
uploaded a bunch of records to the new server. The upload process stalled.

After days of pulling out my hair -- and I'm bald -- in trying to find
out why the uploading process would stall, I noticed that the 952 subfiled
7 in a few records was miscoded as a 952 subfield 9 instead. Once I
reverted the 952 subfield 9 to 952 subfield 7, all was well.

This also happened when a transfer record had a 999 field. If the
record number in 999 subfield c and 999 subfield d did not exist, the
uploading processing would stall. So I deleted the 999 fields or corrected
them to what was in the other copy of the ILS; and again all was well.

I have been reading online about this phenomenon and I haven't found a
reason or solution to the stall. Mind you, other operations continue to
run: the editing of existing records and the entry of new records;
circulation; calendar changes, etc. It's just the automatic record
uploading that stalls.

Well, here are two possible solutions: check for 952 subfield 9 fields
and 999 fields. They may be the source of stall. Their presence may not be
the only source, mind you, but their presence is a possibility.

P. S. It would be nice if instead of stalling, the uploader would write
the MARC record to some sort of upload log with a reason; and then try
uploading the next record.

Shall I file a feature request?

-- 

気を付けて。 /ki wo tukete/ = Take care.

-- Charles.

Charles Kelley, MLS
PSC 704 Box 1029
APO AP 96338

Charles Kelley
Tsukimino 1-Chome 5-2
Tsukimino Gaadenia #210
Yamato-shi, Kanagawa-ken
〒242-0002 JAPAN

+1-301-741-7122 [US cell]
+81-80-4356-2178 [JPN cell]

mnogoja...@aol.com [h]
cmkelley...@gmail.com [p]

linkedin.com/in/cmkelleymls 
Meeting Your Information Needs. Virtually.
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] [Koha-devel] Upgrading bugzilla server

2021-04-07 Thread Joonas Kylmälä
To reproduce the problem you can try open
. It
gives me right now Internal Server Error 500. The attachment upload via
git-bz gave 504.

Joonas

On 07/04/2021 10:46, Chris Cormack wrote:
> Interesting, bugzilla hasn't changed at all. It was an OS upgrade from
> xenial to bionic.
> 
> I suspect its bots hammering the site again I'll go block some ips
> 
> Chris 
> 
> On Wed, 7 Apr 2021, 7:40 pm Joonas Kylmälä,  > wrote:
> 
> Hi Chris,
> 
> thanks. The attachment viewing and adding new attachments stopped
> working. It gives 504 internal server error.
> 
> Joonas
> 
> On 07/04/2021 00:29, Chris Cormack wrote:
> > And it's finished.
> >
> > Please let me know if you spot anything weird
> >
> > Chris
> >
> > On Wed, 7 Apr 2021 at 09:10, Chris Cormack
> mailto:ch...@bigballofwax.co.nz>> wrote:
> >>
> >> Hi all
> >>
> >> I am upgrading the OS on the bugzilla server, so things might go up
> >> and down a bit
> >>
> >> I'll update when its all good to go again
> >>
> >> Chris
> > ___
> > Koha-devel mailing list
> > koha-de...@lists.koha-community.org
> 
> > https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> > website : https://www.koha-community.org/
> > git : https://git.koha-community.org/
> > bugs : https://bugs.koha-community.org/
> >
> 
> -- 
> Joonas Kylmälä
> Tietojärjestelmäasiantuntija
> 
> Kansalliskirjasto
> Kirjastoverkkopalvelut
> PL 15 (Unioninkatu 36)
> 00014 Helsingin yliopisto
> 

-- 
Joonas Kylmälä
Tietojärjestelmäasiantuntija

Kansalliskirjasto
Kirjastoverkkopalvelut
PL 15 (Unioninkatu 36)
00014 Helsingin yliopisto
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] [Koha-devel] Upgrading bugzilla server

2021-04-07 Thread Chris Cormack
Interesting, bugzilla hasn't changed at all. It was an OS upgrade from
xenial to bionic.

I suspect its bots hammering the site again I'll go block some ips

Chris

On Wed, 7 Apr 2021, 7:40 pm Joonas Kylmälä, 
wrote:

> Hi Chris,
>
> thanks. The attachment viewing and adding new attachments stopped
> working. It gives 504 internal server error.
>
> Joonas
>
> On 07/04/2021 00:29, Chris Cormack wrote:
> > And it's finished.
> >
> > Please let me know if you spot anything weird
> >
> > Chris
> >
> > On Wed, 7 Apr 2021 at 09:10, Chris Cormack 
> wrote:
> >>
> >> Hi all
> >>
> >> I am upgrading the OS on the bugzilla server, so things might go up
> >> and down a bit
> >>
> >> I'll update when its all good to go again
> >>
> >> Chris
> > ___
> > Koha-devel mailing list
> > koha-de...@lists.koha-community.org
> > https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> > website : https://www.koha-community.org/
> > git : https://git.koha-community.org/
> > bugs : https://bugs.koha-community.org/
> >
>
> --
> Joonas Kylmälä
> Tietojärjestelmäasiantuntija
>
> Kansalliskirjasto
> Kirjastoverkkopalvelut
> PL 15 (Unioninkatu 36)
> 00014 Helsingin yliopisto
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] [Koha-devel] Upgrading bugzilla server

2021-04-07 Thread Joonas Kylmälä
Hi Chris,

thanks. The attachment viewing and adding new attachments stopped
working. It gives 504 internal server error.

Joonas

On 07/04/2021 00:29, Chris Cormack wrote:
> And it's finished.
> 
> Please let me know if you spot anything weird
> 
> Chris
> 
> On Wed, 7 Apr 2021 at 09:10, Chris Cormack  wrote:
>>
>> Hi all
>>
>> I am upgrading the OS on the bugzilla server, so things might go up
>> and down a bit
>>
>> I'll update when its all good to go again
>>
>> Chris
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
> 

-- 
Joonas Kylmälä
Tietojärjestelmäasiantuntija

Kansalliskirjasto
Kirjastoverkkopalvelut
PL 15 (Unioninkatu 36)
00014 Helsingin yliopisto
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] [Koha-devel] Upgrading bugzilla server

2021-04-07 Thread Renvoize, Martin
Hi Chris,

We seem to be having a few performance issues this morning ( EU morning at
least :P ).

Bugzilla appears to be struggling with attachments (viewing and uploading)
and is generally going a bit slow.

Let me know if there's anything I can do to help,

*Martin Renvoize, MPhys (Hons)*



Head of Development and Community Engagement



*Phone:* +44 (0) 1483 378728

*Mobile:* +44 (0) 7725 985 636

*Email:* martin.renvo...@ptfs-europe.com

www.ptfs-europe.com


*Sign up for our newsletters here  or by scanning
the QR code*



Registered in the United Kingdom No. 06416372   VAT Reg No. 925 7211 30

The information contained in this email message may be privileged,
confidential and protected from disclosure. If you are not the intended
recipient, any dissemination, distribution or copying is strictly
prohibited. If you think that you have received this email message in
error, please email the sender at i...@ptfs-europe.com


On Tue, 6 Apr 2021 at 22:30, Chris Cormack  wrote:

> And it's finished.
>
> Please let me know if you spot anything weird
>
> Chris
>
> On Wed, 7 Apr 2021 at 09:10, Chris Cormack 
> wrote:
> >
> > Hi all
> >
> > I am upgrading the OS on the bugzilla server, so things might go up
> > and down a bit
> >
> > I'll update when its all good to go again
> >
> > Chris
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha