[Koha] link biblio to authorities error

Arayik Manukyan araik at flib.sci.am
Thu Feb 23 22:10:37 NZDT 2017


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.


||







More information about the Koha mailing list