[Koha] link biblio to authorities error

[Arayik Manukyan]

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.


||