Re: [Koha] Out of memory

[Mark Tompsett]

Greetings,

If you are not running plack, then you are probably experiencing 1MB per 
query leak with a default apache configuration with 100MB per query used. 
Digital Ocean has a nice 3GB droplet for $15/month.
As someone else also mentioned, MySQL loves to cache which leads to hogging 
memory. If you have implemented the auto-increment fix 
(https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix),
then a weekly reboot isn't a bad idea. Also, use MariaDB over MySQL. :)

We were experiencing problems with our Koha, then I discovered my colleague 
had set up pingdom to check on the status of the OPAC every minute from 
multiple locations (the equivalent of really high use). We changed it to 15 
minutes from one location, implemented the auto increment fix, cleaned up 
the data manually, rebooted on Sundays, and upgraded to 3GB. We have not had 
a problem since with our over 120K items. However, we have a relatively low 
circulation, and small to moderate use compared to the number of items we 
have.

As for how much memory you should have, take a look at 
/var/spool/koha/{instance name} (I think) and see the size of the two files 
for any given day. Take that size and multiply it by at least 3. This will 
leave you room to run a full reindex, have MySQL cache things, and still 
have space for a several page loads per minute. If you have much higher use 
and/or circulation, you'll need to account for that. Imagine 100 students 
simultaneously accessing OPAC (okay, everyone press enter on your search in 
3,2,1... now), you probably want to have 10GB (100MB*100/1024 ~= 9.75GB) in 
addition to amount you calculated before. Imagine 5 librarians cataloguing 
simultaneously (okay, everyone click New Record in 3,2,1... now), you 
probably want another 1GB (100MB*5/1024 ~= 488MB always ceiling round up) in 
addition to amount you calculated before.

Currently, I do not recommend less than 2GB. Though, like Fred, I have had a 
test system hobble with 512MB. That is not recommended at all.

Ideal Size = 2 GB + Backup Size in GB * 3 + (Number of Simultaneous Users * 
100 / 1024) GB. Make sure to ceiling up to nearest GB size available.

That's my attempt at this question. :)

GPML,
Mark Tompsett

-Original Message- 
From: RubenoFernández
Sent: Monday, March 19, 2018 2:12 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Out of memory

Hi all,

How much memory do you need to run Koha?
I run a database with about 22000 records on a virtual server on Digital 
Ocean
with 1GB memory and very low usage, but the server is crashing very often.

With dmesg I find this kind of messages several times a day:

[Sun Mar 18 16:10:10 2018] addbiblio.pl invoked oom-killer:
gfp_mask=0x24201ca, order=0, oom_score_adj=0
[Sun Mar 18 16:10:10 2018] addbiblio.pl cpuset=/ mems_allowed=0
And then MySQL crashes and restarts:
Sun Mar 18 16:10:10 2018] Out of memory: Kill process 6539 (mysqld) score 
222
or sacrifice child
[Sun Mar 18 16:10:10 2018] Killed process 6539 (mysqld) total-vm:1538124kB,
anon-rss:224948kB, file-rss:0kB

From /var/log/syslog:
Mar 18 16:10:11 biblioteko systemd[1]: mysql.service: Main process exited,
code=killed, status=9/KILL
Mar 18 16:10:11 biblioteko systemd[1]: mysql.service: Unit entered failed
state.
Mar 18 16:10:11 biblioteko systemd[1]: mysql.service: Failed with result
'signal'.
Mar 18 16:10:11 biblioteko systemd[1]: mysql.service: Service hold-off time
over, scheduling restart.
Mar 18 16:10:11 biblioteko systemd[1]: Stopped MySQL Community Server.
Mar 18 16:10:11 biblioteko systemd[1]: Starting MySQL Community Server...

Just yesterday the killed process was rebuild_zebra.p, which didn't restart,
and Koha was retrieving no results for searches.

The strange thing is that Digital Ocean's own monitoring tool never reports
such memory spikes: usage is usually high but never more than 80%. Maybe the
spikes are too short? What would you recommend for a more fine-grained
monitoring of memory?

Right now my memory is this:
root@biblioteko:~# free
  totalusedfree  shared  buff/cache
available
Mem:1016056  555304  266328   14936  194424
292164
Swap: 0   0   0

On file /etc/mysql/mysql.conf.d/mysqld.cnf the value of
"innodb_buffer_pool_size" is 385M, if that's of any help.

Do I really need more physical memory on my server?
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha 

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

Re: [Koha] Zebra stops every day

[Tomas Cohen Arazi]

Maybe we could backport this one into 17.11, you could try changing the
file manually on your server:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19610


El mié., 4 de abr. de 2018 6:35 p. m., Mark Alexander 
escribió:

> Excerpts from Javed Sahil's message of 2018-04-04 17:44:23 +:
> > I am using Koha17.11, I moved my old DB which was working fine in
> koha16.11,
> >
> > But now my zebra server stops daily or after two or three days,  actually
> > i have not noted exact duration.
>
> It might be this problem:
>
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16885
>
> If so, this is the solution that worked for me:
>
> https://lists.katipo.co.nz/pipermail/koha/2016-September/046167.html
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Zebra stops every day

[Mark Alexander]

Excerpts from Javed Sahil's message of 2018-04-04 17:44:23 +:
> I am using Koha17.11, I moved my old DB which was working fine in koha16.11,
> 
> But now my zebra server stops daily or after two or three days,  actually
> i have not noted exact duration.

It might be this problem:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16885

If so, this is the solution that worked for me:

https://lists.katipo.co.nz/pipermail/koha/2016-September/046167.html
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Zebra stops every day

[Javed Sahil]

Hi All,

I am using Koha17.11, I moved my old DB which was working fine in koha16.11,

But now my zebra server stops daily or after two or three days,  actually
i have not noted exact duration.

I come to know this error when I see no results in opac search and in About
Koha page there is an Error Message saying,

"Zebra server seems not to be available, is it started? "

Then I issue command,

Koha-restart-zebra library

And it works fine.

But why should i issue the command again  and again.

Any solutions?

Regards,

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

Re: [Koha] [Koha-devel] RFC for MARC holdings record support

[Nick Clemens]

There was some discussion of this at the IRC meeting today, forwarding on
to the general list as well for librarian input/feedback

On Tue, Apr 3, 2018 at 3:33 AM Ere Maijala  wrote:

> Hi Katrin,
>
> Thanks for the comments. I'll try to clarify the RFC.
>
> --Ere
>
> Katrin Fischer kirjoitti 1.4.2018 klo 17.32:
> > Hi Ere,
> >
> > thx for your work on that! I've added some comments and questions at the
> > bottom of the RFC page. I think key is to break the big development down
> > into multiple steps that can be easily tested.
> >
> > Katrin
> >
> >
> > On 26.03.2018 12:58, Ere Maijala wrote:
> >> Hi Everyone,
> >>
> >> I've written an RFC for adding support for MARC holdings records,
> >> available here:
> >> . I'd
> >> be grateful for any feedback on this. I know there have been some
> >> initiatives to add (back) holdings records, but this proposal is a bit
> >> different in that it relies on the MARC format and I already have it
> >> working in a local custom branch apart from OPAC support.
> >>
> >> Regards,
> >> Ere
> >>
> >
> > ___
> > Koha-devel mailing list
> > koha-de...@lists.koha-community.org
> > http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> > website : http://www.koha-community.org/
> > git : http://git.koha-community.org/
> > bugs : http://bugs.koha-community.org/
>
> --
> Ere Maijala
> Kansalliskirjasto / The National Library of Finland
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
>
-- 
Nick Clemens
Sonic Screwdriver (Development Support)
ByWater Solutions
IRC: kidclamp
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 18.05 release dates

[Jonathan Druart]

I'd say it depends on the patchset/area and test coverage.
And also on the time I will be able to dedicate to code review.

On Tue, 3 Apr 2018 at 10:20 Tomas Cohen Arazi  wrote:

> Will you consider REST endpoints 'high-risk'?
>
> El mar., 3 abr. 2018 a las 10:04, Jonathan Druart (<
> jonathan.dru...@bugs.koha-community.org>) escribió:
>
>> Hello everybody,
>>
>> Here is the timeline I plan to follow for the 18.05 release:
>>
>> * April 20 - "Soft" feature freeze, nothing big or with high risk of
>> side-effects will be included into the final release if not marked as
>> Passed QA (and the converse is false).
>> * April 27 - "Hard" feature freeze, nothing considered as an enhancement
>> will be pushed if not marked as Passed QA (exception will be made for
>> tests).
>> * May 4 - String freeze, draft of release notes published
>> * May 11 - Only bugfixes considered as major, critical or blocker will be
>> pushed
>> * May 22 - Final Release
>>
>> Any comments or change requests?
>>
>> Regards,
>> Jonathan
>>
> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> --
> Tomás Cohen Arazi
> Theke Solutions (https://theke.io )
> ✆ +54 9351 3513384 <+54%209%20351%20351-3384>
> GPG: B2F3C15F
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Local thumbnail at MARC21

[Tomas Cohen Arazi]

Please open the official manual in your browser

https://koha-community.org/manual/17.11/es/html/

I'm pretty sure you will find most of the things with the page search from
your browser!


El mié., 4 de abr. de 2018 5:44 a. m., Narcis Garcia 
escribió:

> I have these 2 system preferences already set:
> LocalCoverImages == Display
> OPACLocalCoverImages == Display
>
> When I'm creating a new book with MARC21 framework, how can I make use
> of this feature and upload an image? Can this image be linked from 856.u
> or 352.6 ?
>
>
> El 04/04/18 a les 10:28, Katrin Fischer ha escrit:
> > Hi,
> >
> > 352 is not the correct field, take a look at 856$u $y etc. There is a
> system preference that allows for images to display directly:
> *Display856uAsImage
> > But Koha also has a nice separate feature for uploading local book
> covers that is independent from fields in the MARC record. Search for
> localcover in the system preferences.
> >
> > Hope this helps,
> >
> > Katrin
> >
> >
> > Gesendet: Mittwoch, 04. April 2018 um 10:05 Uhr
> > Von: "Narcis Garcia" 
> > An: koha@lists.katipo.co.nz
> > Betreff: [Koha] Local thumbnail at MARC21
> > In my MARC21 custom framework, I've included 352.6 subfield to allow
> > cover upload or link.
> >
> > How can I make use of this (or another way) to OPAC shows book covers?
> >
> > Thanks.
> > ___
> > Koha mailing list http://koha-community.org
> > Koha@lists.katipo.co.nz
> >
> https://lists.katipo.co.nz/mailman/listinfo/koha[https://lists.katipo.co.nz/mailman/listinfo/koha]
> >
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] No cart-related features

[Narcis Garcia]

Yes, its effect seemd good enough, also with anonymous visitors.
Thank you.


El 04/04/18 a les 12:10, Tomas Cohen Arazi ha escrit:
> Look at the opacbookbag syspref.
> 
> El mié., 4 de abr. de 2018 5:39 a. m., Narcis Garcia
> > escribió:
> 
> I'm using Koha 17.11
> 
> Is there a way to configure Koha to not show cart features at all in
> OPAC?
> 
> Thanks.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz 
> https://lists.katipo.co.nz/mailman/listinfo/koha
> 
> -- 
> Tomás Cohen Arazi
> Theke Solutions (https://theke.io )
> ✆ +54 9351 3513384
> GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] No cart-related features

[Tomas Cohen Arazi]

Look at the opacbookbag syspref.

El mié., 4 de abr. de 2018 5:39 a. m., Narcis Garcia 
escribió:

> I'm using Koha 17.11
>
> Is there a way to configure Koha to not show cart features at all in OPAC?
>
> Thanks.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] GDPR IRC meeting vol. 2

[Josef Moravec]

Hi Narcis,

last time, I used framadate, but it was a bit painful to setup poll
there... I haven't known the other alternatives, thank! I'll try them next
time and see ;)

Josef

st 4. 4. 2018 v 11:16 odesílatel Narcis Garcia 
napsal:

> Please, support and make us of open source services:
> https://dudle.inf.tu-dresden.de/
> https://dudle.lamardebits.org/
>
> Or alternatives:
> https://framadate.org/
> https://nuages.domainepublic.net/
>
>
> El 04/04/18 a les 11:06, Josef Moravec ha escrit:
> > Hello all interesteed in GDPR,
> >
> > we would like to have another meeting on this topic, but time and date is
> > not set yet. So please fill this poll if you are interested. Thanks.
> >
> > https://doodle.com/poll/q7s88vqnc5xtf9ev
> >
> > Josef
> > ___
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] GDPR IRC meeting vol. 2

[Narcis Garcia]

Please, support and make us of open source services:
https://dudle.inf.tu-dresden.de/
https://dudle.lamardebits.org/

Or alternatives:
https://framadate.org/
https://nuages.domainepublic.net/


El 04/04/18 a les 11:06, Josef Moravec ha escrit:
> Hello all interesteed in GDPR,
> 
> we would like to have another meeting on this topic, but time and date is
> not set yet. So please fill this poll if you are interested. Thanks.
> 
> https://doodle.com/poll/q7s88vqnc5xtf9ev
> 
> Josef
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> 
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] GDPR IRC meeting vol. 2

[Josef Moravec]

Hello all interesteed in GDPR,

we would like to have another meeting on this topic, but time and date is
not set yet. So please fill this poll if you are interested. Thanks.

https://doodle.com/poll/q7s88vqnc5xtf9ev

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

Re: [Koha] Local thumbnail at MARC21

[Narcis Garcia]

I have these 2 system preferences already set:
LocalCoverImages == Display
OPACLocalCoverImages == Display

When I'm creating a new book with MARC21 framework, how can I make use
of this feature and upload an image? Can this image be linked from 856.u
or 352.6 ?


El 04/04/18 a les 10:28, Katrin Fischer ha escrit:
> Hi,
> 
> 352 is not the correct field, take a look at 856$u $y etc. There is a system 
> preference that allows for images to display directly: *Display856uAsImage
> But Koha also has a nice separate feature for uploading local book covers 
> that is independent from fields in the MARC record. Search for localcover in 
> the system preferences.
> 
> Hope this helps,
> 
> Katrin
>  
> 
> Gesendet: Mittwoch, 04. April 2018 um 10:05 Uhr
> Von: "Narcis Garcia" 
> An: koha@lists.katipo.co.nz
> Betreff: [Koha] Local thumbnail at MARC21
> In my MARC21 custom framework, I've included 352.6 subfield to allow
> cover upload or link.
> 
> How can I make use of this (or another way) to OPAC shows book covers?
> 
> Thanks.
> ___
> Koha mailing list http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha[https://lists.katipo.co.nz/mailman/listinfo/koha]
> 
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] No cart-related features

[Narcis Garcia]

I'm using Koha 17.11

Is there a way to configure Koha to not show cart features at all in OPAC?

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

Re: [Koha] Local thumbnail at MARC21

[Katrin Fischer]

Hi,

352 is not the correct field, take a look at 856$u $y etc. There is a system 
preference that allows for images to display directly: *Display856uAsImage
But Koha also has a nice separate feature for uploading local book covers that 
is independent from fields in the MARC record. Search for localcover in the 
system preferences.

Hope this helps,

Katrin
 

Gesendet: Mittwoch, 04. April 2018 um 10:05 Uhr
Von: "Narcis Garcia" 
An: koha@lists.katipo.co.nz
Betreff: [Koha] Local thumbnail at MARC21
In my MARC21 custom framework, I've included 352.6 subfield to allow
cover upload or link.

How can I make use of this (or another way) to OPAC shows book covers?

Thanks.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha[https://lists.katipo.co.nz/mailman/listinfo/koha]
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Local thumbnail at MARC21

[Narcis Garcia]

In my MARC21 custom framework, I've included 352.6 subfield to allow
cover upload or link.

How can I make use of this (or another way) to OPAC shows book covers?

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

Re: [Koha] First catalog, first search failed

[Narcis Garcia]

I've found the cause is "PazPar2" not working.
To disable its usage through system preferences:
OpacGroupResults = Don't use


El 03/04/18 a les 15:07, Narcis Garcia ha escrit:
> MyLibrary-intra.example.net
> Once I've defined a (I hope) final framework to work with, I've
> catalogued a first book. I didn't add any "item".
> 
> Just after this, I've visited OPAC at ~ MyLibrary.example.net and filled
> search textbox with author's name -> [Go]
> The answer is:
> 
> You did not specify any search criteria
> No results found!
> You did not specify any search criteria.
> Error:
> Could not find opac-search.xml in /usr/share/koha/opac/cgi-bin/opac/ at
> /usr/share/koha/lib/C4/Search.pm line 871.
> 
> What have I missed to do for this Koha 17.11 setup?
> 
> Thanks.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> 
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha