[Koha] Error while using Acquisition Module vendors search (Koha 18.11.05 on Ubuntu 18.04 LTS)

Roger Grossmann roger.grossmann at lmscloud.de
Mon May 13 20:28:24 NZST 2019 

Dear Ata ur Rehmann,

I have seen this error message in Koha 18.05 as well. 
In our case the problem was solved increasing the "sort_buffer_size" configuration parameter of mysql.

Adding/changing the parameter

sort_buffer_size = 2M

to/in the [mysqld]-section of the mysql-server configuration (typically /etc/mysql/my.cnf) solved the problem.

After the change mysql must be restarted to make use of the parameter change. 

Best regards,
Roger

--
LMSCloud GmbH
Roger Großmann - Geschäftsführer
Konrad-Zuse-Platz 8 - D-81829 München
t +49 (0)89 207042-620  m +49 (0)171-2194775 f +49 (0)89 207042-623
e roger.grossmann at lmscloud.de
w www.lmscloud.de

> Am 12.05.2019 um 13:19 schrieb Ata ur Rehman <ata.rehman at gmail.com>:
> 
> Dear All
> 
> Ref to Bug: 22869
> 
> I got the following error message while searching a vendor (which is
> available) or adding a new vendor:
> 
> Can't use an undefined value as an ARRAY reference at
> /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081.
> 
> I've migrated database from an old version to 18.11.05 (Ubuntu 18.04 LTS).
> Intranet Error log says:
> 
> [Thu May 09 01:31:31.751639 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl: DBD::mysql::st execute failed: Out of sort memory,
> consider increasing server sort buffer size [for Statement ":
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.752809 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:         SELECT aqbasket.basketno, aqbasket.basketname,
> aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber,
> aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid,
> aqbasket.authorisedby, aqbasket.booksellerinvoicenumber,
> aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace,
> aqbasket.branch, aqbasket.is_standing, aqbasket.create_items,:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.753108 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:           SUM(aqorders.quantity) AS total_items,:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.753281 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:           SUM(:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.753555 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:             IF ( aqorders.orderstatus = 'cancelled',
> aqorders.quantity, 0 ):
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.753784 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:           ) AS total_items_cancelled,:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.754027 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:           COUNT(DISTINCT aqorders.biblionumber) AS
> total_biblios,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl,
> referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.754164 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:           SUM(:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.754361 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:             IF(aqorders.datereceived IS NULL:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.754741 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:               AND (aqorders.datecancellationprinted IS
> NULL OR aqorders.datecancellationprinted='0000-00-00'):
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.754920 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:             , aqorders.quantity:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.755064 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:             , 0):
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.755235 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:           ) AS expected_items:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.755404 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:         FROM aqbasket:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.755786 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:           LEFT JOIN aqorders ON aqorders.basketno =
> aqbasket.basketno:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.756914 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:         WHERE booksellerid = ? GROUP BY
> aqbasket.basketno, aqbasket.basketname, aqbasket.note,
> aqbasket.booksellernote, aqbasket.contractnumber,
> aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid,
> aqbasket.authorisedby, aqbasket.booksellerinvoicenumber,
> aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace,
> aqbasket.branch, aqbasket.is_standing, aqbasket.create_items HAVING
> (closedate IS NULL OR (:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.757067 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:           SUM(:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.757268 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:             IF(aqorders.datereceived IS NULL:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.757644 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:               AND (aqorders.datecancellationprinted IS
> NULL OR aqorders.datecancellationprinted='0000-00-00'):
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.757851 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:             , aqorders.quantity:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.757993 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:             , 0):
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.762276 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl:             ) > 0))" with ParamValues: 0=1] at
> /usr/share/koha/lib/C4/Acquisition.pm line 705.:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> [Thu May 09 01:31:31.762667 2019] [cgi:error] [pid 18056] [client
> 192.168.8.104:55296] AH01215: [Thu May  9 01:31:31 2019]
> booksellers.pl: Can't use an undefined value as an ARRAY reference at
> /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081.:
> /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer:
> http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
> 
> Screenshot may please be found at:
> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89479
> 
> Any help/advice would be appreciated, pl.
> 
> Regards,
> 
> Ata ur Rehman
> 
> NCP - Islamabad
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list