http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Bug ID: 13606 Summary: Batch modification for records is limited to ~500 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Tools Assignee: gmcharlt@gmail.com Reporter: jonathan.druart@biblibre.com QA Contact: testopia@bugs.koha-community.org Bug 11395 uses the session to store the report sent to the interface (update on biblio XX OK, etc.). If the session is stored in mysql, the max size of the sessions.a_session will be reached easily (TEXT field). I found a first problem: The C4::BackgroundJob module append to the session each job information. Example for 2 jobs launched during the same session: --- _SESSION_ATIME: '1421843399' _SESSION_CTIME: '1421843222' _SESSION_ID: a5ffa813fc694706245cfe51dedc7697 _SESSION_REMOTE_ADDR: 192.168.113.2 branch: NO_LIBRARY_SET branchname: NO_LIBRARY_SET cardnumber: koha emailaddress: koha@exampe.org firstname: koha flags: 1 id: koha ip: 1.2.3.4 job_94357aff68a60dee98819f627c8a7f57: !!perl/hash:C4::BackgroundJob extra_values: messages: - biblionumber: 1 code: biblio_modified type: success - biblionumber: 2 code: biblio_modified type: success - biblionumber: 3 code: biblio_modified type: success - biblionumber: 4 code: biblio_modified type: success - biblionumber: 5 code: biblio_modified type: success report: total_records: 5 total_success: 5 view: report invoker: /cgi-bin/koha/tools/batch_record_modification.pl jobID: 94357aff68a60dee98819f627c8a7f57 name: FIXME progress: 5 results: ~ sessionID: a5ffa813fc694706245cfe51dedc7697 size: 5 status: completed job_98a251e034eec15b87027ea9c5c0a8cd: !!perl/hash:C4::BackgroundJob extra_values: messages: - biblionumber: 6 code: biblio_modified type: success - biblionumber: 7 code: biblio_modified type: success - biblionumber: 8 code: biblio_modified type: success - biblionumber: 9 code: biblio_modified type: success - biblionumber: 10 code: biblio_modified type: success report: total_records: 5 total_success: 5 view: report invoker: /cgi-bin/koha/tools/batch_record_modification.pl jobID: 98a251e034eec15b87027ea9c5c0a8cd name: FIXME progress: 5 results: ~ sessionID: a5ffa813fc694706245cfe51dedc7697 size: 5 status: completed It's useless to keep old job information. To reproduce: 1/ Create a file with 500 biblionumbers: mysql -e "select biblionumber from biblio limit 500;" | tail -n 500 > /tmp/biblionumbers.txt 2/ Define a marc modification template 3/ Load the /tmp/biblionumbers.txt in the batch biblio modification tool 4/ Repeat 3 You will get: Syck parser (line 1534, column 6): syntax error at /usr/lib/i386-linux-gnu/perl5/5.20/YAML/Syck.pm line 75. The sessions.a_session field has reach its maximum size and the yaml stored in it is not complete and not well formed. To fix that I would like to 1/ Remove previous job information on creating a new one 2/ Increase the size of sessions.a_session from TEXT (64kb) to MEDIUMTEXT (32mb) -- You are receiving this mail because: You are watching all bug changes.