[Koha-bugs] [Bug 13606] New: Batch modification for records is limited to ~500

[bugzilla-daemon at bugs.koha-community.org]

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 at gmail.com
          Reporter: jonathan.druart at biblibre.com
        QA Contact: testopia at 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 at 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.