Dear List,
We imported more than 1000 000 records in Koha 3.22.13, Ubuntu 3.14. 04,
and Authority record nearly 30 000.
Now when we wanted to link bibs with authority
|sudo perl -I /usr/share/koha/lib
/usr/share/koha/bin/link_bibs_to_authorities.pl|
and have got such error
****************************************************************************************************
DBD::mysql::st execute failed: MySQL client ran out of memory [for
Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE
biblionumber=? " with ParamValues: 0='389843'] at
/usr/share/koha/lib/C4/Biblio.pm line 1287.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for
Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE
biblionumber=? " with ParamValues: 0='389843'] at
/usr/share/koha/lib/C4/Biblio.pm line 1288.
Out of memory (Needed 8164 bytes)
DBD::mysql::st execute failed: MySQL client ran out of memory [for
Statement "SELECT frameworkcode FROM biblio WHERE biblionumber=?" with
ParamValues: 0='389843'] at /usr/share/koha/lib/C4/Biblio.pm line 2233.
DBD::mysql::st fetchrow failed: fetch() without execute() [for Statement
"SELECT frameworkcode FROM biblio WHERE biblionumber=?" with
ParamValues: 0='389843'] at /usr/share/koha/lib/C4/Biblio.pm line 2234.
Could not retrieve bib 389843 from the database - record is corrupt.
Out of memory (Needed 8164 bytes)
DBD::mysql::st execute failed: MySQL client ran out of memory [for
Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE
biblionumber=? " with ParamValues: 0='389844'] at
/usr/share/koha/lib/C4/Biblio.pm line 1287.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for
Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE
biblionumber=? " with ParamValues: 0='389844'] at
/usr/share/koha/lib/C4/Biblio.pm line 1288.
Out of memory (Needed 8164 bytes)
DBD::mysql::st execute failed: MySQL client ran out of memory [for
Statement "SELECT frameworkcode FROM biblio WHERE biblionumber=?" with
ParamValues: 0='389844'] at /usr/share/koha/lib/C4/Biblio.pm line 2233.
DBD::mysql::st fetchrow failed: fetch() without execute() [for Statement
"SELECT frameworkcode FROM biblio WHERE biblionumber=?" with
ParamValues: 0='389844'] at /usr/share/koha/lib/C4/Biblio.pm line 2234.
Could not retrieve bib 389844 from the database - record is corrupt.
Out of memory (Needed 8164 bytes)
DBD::mysql::st execute failed: MySQL client ran out of memory [for
Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE
biblionumber=? " with ParamValues: 0='389845'] at
/usr/share/koha/lib/C4/Biblio.pm line 1287.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for
Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE
biblionumber=? " with ParamValues: 0='389845'] at
/usr/share/koha/lib/C4/Biblio.pm line 1288.
Out of memory (Needed 8164 bytes)
DBD::mysql::st execute failed: MySQL client ran out of memory [for
Statement "SELECT frameworkcode FROM biblio WHERE biblionumber=?" with
ParamValues: 0='389845'] at /usr/share/koha/lib/C4/Biblio.pm line 2233.
DBD::mysql::st fetchrow failed: fetch() without execute() [for Statement
"SELECT frameworkcode FROM biblio WHERE biblionumber=?" with
ParamValues: 0='389845'] at /usr/share/koha/lib/C4/Biblio.pm line 2234.
Could not retrieve bib 389845 from the database - record is corrupt.
Out of memory (Needed 8164 bytes)
DBD::mysql::st execute failed: MySQL client ran out of memory [for
Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE
biblionumber=? " with ParamValues: 0='389846'] at
/usr/share/koha/lib/C4/Biblio.pm line 1287.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for
Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE
biblionumber=? " with ParamValues: 0='389846'] at
/usr/share/koha/lib/C4/Biblio.pm line 1288.
Out of memory!
DBD::mysql::db DESTROY failed: MySQL server has gone away during global
destruction.
**************
And noticed in koha-error.log such error.
************************************
[Thu Feb 23 12:22:54.769719 2017] [cgi:error] [pid 10443] [client
37.26.174.105:2094] AH01215: [Thu Feb 23 12:22:54 2017] additem.pl:
DBIx::Class::Storage::DBI::selec
[Thu Feb 23 12:25:18.418824 2017] [cgi:error] [pid 10512] [client
37.26.174.105:2099] AH01215: [Thu Feb 23 12:25:18 2017] additem.pl:
DBIx::Class::Storage::DBI::selec
[Thu Feb 23 12:26:05.141596 2017] [cgi:error] [pid 10536] [client
37.26.174.105:2102] AH01215: [Thu Feb 23 12:26:05 2017] additem.pl:
DBIx::Class::Storage::DBI::selec
************************************
After that we encrease buffer_size
<https://mariadb.com/kb/en/myisam-system-variables/#key_buffer_size>parameter
in /etc/mysql/my.nf from 16 M to 1G . After that when the command
|(link_bibs_to_authorities.pl|) was running again, we have got the
same error.
||
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha