Re: [Koha] Error message shown during web installation

[Katrin Fischer]

Hi Indranil,

I think you have exprienced this error:

*Bug 22919*
 -
Authorities MARC Structure not inserted with SQL strict modes

Hope this helps,

Katrin


On 14.06.19 16:07, Indranil Baruah wrote:

Following error is shown during web installation of Koha 19.05 on Lubuntu
19.04. The installation however completes but the speed of the application
is slow even with Memcached running.

Mandatory data added

 subtag_registry.sql
 auth_val_cat.sql
 message_transport_types.sql
 sample_notices_message_attributes.sql
 sample_notices_message_transports.sql
 auth_values.sql
* authorities_normal_marc21.sql*

*[Fri Jun 14 19:07:09 2019] install.pl :
DBD::mysql::st execute failed: Incorrect integer value: '' for column
'linkid' at row 148 at /usr/share/perl5/DBIx/RunSQL.pm line 278,
<$args{...}> chunk 1.*

 class_sources.sql
 marc21_framework_DEFAULT.sql
 sample_frequencies.sql
 sample_notices.sql
 sample_numberpatterns.sql
___



Virus-free.
www.avg.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
___
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] Error message shown during web installation

[Paul A]

On 2019-06-14 10:07 a.m., Indranil Baruah wrote:

Following error is shown during web installation of Koha 19.05 on Lubuntu
19.04. The installation however completes but the speed of the application
is slow even with Memcached running.


Happy to see you have Koha running. As to speed, here are a few thoughts 
based on many years of Koha (but not specifically 19.05) experience:


	- you mention Lubuntu, which might be a desktop (GUI) implementation. A 
_server_ implementation would probably be more suitable -- ubuntu, 
debian are good choices. Desktops have overheads that use resources 
unnecessary for Koha.


	- you mention memcached. How much memory have you allocated? look in 
your /etc/memcached.conf and increase "-m" from the default 64 to 4096 
(or at least 2048.)


	- you do not mention the hardware that you are using. We have found 
that, as long as you have at least 16 Mbs RAM, the CPU's L2 and L3 cache 
across a large number of cores is the most determining factor. To give 
you an example, on an old box with (inxi reporting) "Quad core Intel 
Core i7-2600 (-HT-MCP-) cache: 8192 KB" needs approx 1.21 secs for a 
Zebra search, whereas a dual motherboard "6 core Intel Core i7-8700K 
(-MT-MCP-) cache: 12288 KB" (i.e. 12 core, with overlapping 2 x 12288 KB 
CPU cache) does exactly the same job in 0.048 seconds. (This for a 
240,000 item db.)


The bottom line is that Koha is a very "big" application, that does an 
awful lot of things for an awful lot of varying libraries and end users. 
The sheer size and complexity of all the improvements that have been 
integrated over the years has inevitably led to to either "hardware 
upgrades" or as you write "the application is slow."


There might well be other reasons that you have found your installation 
to be "slow." Perhaps you would be kind enough to let us know how you 
did your installation (package? tarball?) and the size of your database 
(number of biblios and items?), any log entries that could assist, and 
some idea of your hardware. There are many helpful and knowledgeable 
people on this list who, in my experience, would be most enthusiastic to 
try and help you.


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

[Koha] Error message shown during web installation

[Indranil Baruah]

Following error is shown during web installation of Koha 19.05 on Lubuntu
19.04. The installation however completes but the speed of the application
is slow even with Memcached running.

Mandatory data added

subtag_registry.sql
auth_val_cat.sql
message_transport_types.sql
sample_notices_message_attributes.sql
sample_notices_message_transports.sql
auth_values.sql
   * authorities_normal_marc21.sql*

*[Fri Jun 14 19:07:09 2019] install.pl :
DBD::mysql::st execute failed: Incorrect integer value: '' for column
'linkid' at row 148 at /usr/share/perl5/DBIx/RunSQL.pm line 278,
<$args{...}> chunk 1.*

class_sources.sql
marc21_framework_DEFAULT.sql
sample_frequencies.sql
sample_notices.sql
sample_numberpatterns.sql
___



Virus-free.
www.avg.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha