[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Jonathan Druart changed: What|Removed |Added Assignee|gmcha...@gmail.com |jonathan.dru...@biblibre.co ||m Status|NEW |ASSIGNED -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Jonathan Druart changed: What|Removed |Added Depends on||11395 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 --- Comment #2 from Jonathan Druart --- Created attachment 35445 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=35445&action=edit Bug 13606: Upgrade sessions.a_session to MEDIUMTEXT The previous patch fixed partially the problem. If you try to update more that 1000 records, you will get the same error. This patch change the type of sessions.a_session from TEXT (64kb) MEDIUMTEXT (32mb). Test plan: 1/ Try to modify a huge amount of records (1000 should be enough) 2/ Confirm it worked! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606
--- Comment #1 from Jonathan Druart ---
Created attachment 35444
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=35444&action=edit
Bug 13606: Remove previous job data from the session
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).
To reproduce:
0/ Set SessionStorage to 'mysql'
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 (something like "delete field 99$9" is
nice)
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.
None Koha page is reachable.
It comes from get_template_and_user > checkauth > get_session >
l.1595 $session = new CGI::Session("driver:MySQL;serializer:yaml;id:md5",
$sessionID, {Handle=>$dbh});
5/ Get your sessionID contained in your CGISESSID cookie
Have a look at the value a_session in the sessions table:
mysql> select a_session from sessions where id="YOUR_SESSIONID";
You should see that the yaml is not correctly ended.
The size of the DB field has been reached and the yaml is truncated.
Test plan:
0/ Delete your CGISESSID cookie
1/ Try to reproduce the previous issue
2/ After the second batch, have a look at the sessions table and confirm
that only one job_$JOB_ID exist in the yaml
--
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Jonathan Druart changed: What|Removed |Added Status|ASSIGNED|Needs Signoff -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Jonathan Druart changed: What|Removed |Added See Also||http://bugs.koha-community. ||org/bugzilla3/show_bug.cgi? ||id=10601 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 --- Comment #11 from Jonathan Druart --- The first patch should be improved to only delete data from finished jobs. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606
Frédéric Demians changed:
What|Removed |Added
Attachment #35444|0 |1
is obsolete||
--- Comment #4 from Frédéric Demians ---
Created attachment 37597
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=37597&action=edit
[SIGNED-OFF] Bug 13606: Remove previous job data from the session
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).
To reproduce:
0/ Set SessionStorage to 'mysql'
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 (something like "delete field 99$9" is
nice)
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.
None Koha page is reachable.
It comes from get_template_and_user > checkauth > get_session >
l.1595 $session = new CGI::Session("driver:MySQL;serializer:yaml;id:md5",
$sessionID, {Handle=>$dbh});
5/ Get your sessionID contained in your CGISESSID cookie
Have a look at the value a_session in the sessions table:
mysql> select a_session from sessions where id="YOUR_SESSIONID";
You should see that the yaml is not correctly ended.
The size of the DB field has been reached and the yaml is truncated.
Test plan:
0/ Delete your CGISESSID cookie
1/ Try to reproduce the previous issue
2/ After the second batch, have a look at the sessions table and confirm
that only one job_$JOB_ID exist in the yaml
Signed-off-by: Frederic Demians
I can reproduce de bug. I can see also the useless C4::BackgroundJob session
data. I confirm that modifying two consecutive 500 records batches broke
entirely the session YAML representation deserialization. And finally I
confirm that this patch fixes all those issues.
--
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Jonathan Druart changed: What|Removed |Added Attachment #35445|0 |1 is obsolete|| --- Comment #5 from Jonathan Druart --- Created attachment 37601 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=37601&action=edit Bug 13606: Upgrade sessions.a_session to MEDIUMTEXT The previous patch fixed partially the problem. If you try to update more that 1000 records, you will get the same error. This patch change the type of sessions.a_session from TEXT (64kb) MEDIUMTEXT (32mb). Test plan: 1/ Try to modify a huge amount of records (1000 should be enough) 2/ Confirm it worked! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 --- Comment #10 from Jonathan Druart --- (In reply to Frédéric Demians from comment #9) > (In reply to Jonathan Druart from comment #7) > > Actually I am wondering what happens if 2 jobs are launched simultaneously > > :-/ > > Good question! Above ~1000 records, the processing time is long, and the UI > feedback is not that good. So users could be tempted to refresh the page. It > may be advisable to limit processing to let say 1000 records. I would be tempt to only keep the DB changes, not the first patch. I did not try, but if several jobs are launched (any jobs using the BackgroundJob module), the last one will erase data from previous ones. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Frédéric Demians changed: What|Removed |Added Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Frédéric Demians changed: What|Removed |Added Attachment #37601|0 |1 is obsolete|| --- Comment #8 from Frédéric Demians --- Created attachment 37621 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=37621&action=edit Bug 13606: Upgrade sessions.a_session to MEDIUMTEXT The previous patch fixed partially the problem. If you try to update more that 1000 records, you will get the same error. This patch change the type of sessions.a_session from TEXT (64kb) MEDIUMTEXT (32mb). Test plan: 1/ Try to modify a huge amount of records (1000 should be enough) 2/ Confirm it worked! Signed-off-by: Frederic Demians I confirm that with more than 1000 records the session object is truncated, and then can't be anymore be desirialized, blocking completely Koha. Fixed with this patch. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Jonathan Druart changed: What|Removed |Added Severity|normal |major --- Comment #6 from Jonathan Druart --- I am raising the priority of this one, it should absolutely be present in 3.20. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 --- Comment #13 from Jonathan Druart --- (In reply to Jonathan Druart from comment #11) > The first patch should be improved to only delete data from finished jobs. Frederic, I rewrote my first patch. The job entries in the session are now deleted when a new job is created. It looks better like that and we should not get issue with simultaneous jobs. Could you confirm the progress bar is broken, even on the items modification tool? I tried with an old version of the code, and same issue. Not sure if it comes from me or if it's an issue... -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 --- Comment #7 from Jonathan Druart --- Actually I am wondering what happens if 2 jobs are launched simultaneously :-/ -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 --- Comment #15 from M. Tompsett --- Also, perhaps a 'LastTouched: 2015-04-09 15:07:00' type entry would be useful too. If it isn't touched in 30 minutes, is it even running? -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Jonathan Druart changed: What|Removed |Added Attachment #37597|0 |1 is obsolete|| --- Comment #12 from Jonathan Druart --- Created attachment 37627 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=37627&action=edit Bug 13606: Remove previous job data from the session -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Jonathan Druart changed: What|Removed |Added Status|Signed Off |Needs Signoff -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 M. Tompsett changed: What|Removed |Added CC||mtomp...@hotmail.com --- Comment #14 from M. Tompsett --- Why is there no "Started: 2015-04-09 12:58:00" type value in the job session information? You could easily also delete anything that is more than 24 hours old, if there was a way to determine it. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Frédéric Demians changed: What|Removed |Added CC||frede...@tamil.fr --- Comment #3 from Frédéric Demians --- The second patch doesn't apply: fatal: sha1 information is lacking or useless (installer/data/mysql/updatedatabase.pl). Le dépôt n'a pas les blobs nécessaires pour un retour à une fusion à 3 points. Impossible de retourner à une fusion à 3 points. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 --- Comment #9 from Frédéric Demians --- (In reply to Jonathan Druart from comment #7) > Actually I am wondering what happens if 2 jobs are launched simultaneously > :-/ Good question! Above ~1000 records, the processing time is long, and the UI feedback is not that good. So users could be tempted to refresh the page. It may be advisable to limit processing to let say 1000 records. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606
--- Comment #41 from Kyle M Hall ---
Created attachment 38060
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=38060&action=edit
[PASSED QA] Bug 13606 Clear job data in session when the job is completed
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).
To reproduce:
0/ Set SessionStorage to 'mysql'
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 (something like "delete field 99$9" is
nice)
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.
None Koha page is reachable.
It comes from get_template_and_user > checkauth > get_session >
l.1595 $session = new CGI::Session("driver:MySQL;serializer:yaml;id:md5",
$sessionID, {Handle=>$dbh});
5/ Get your sessionID contained in your CGISESSID cookie
Have a look at the value a_session in the sessions table:
mysql> select a_session from sessions where id="YOUR_SESSIONID";
You should see that the yaml is not correctly ended.
The size of the DB field has been reached and the yaml is truncated.
Test plan:
0/ Delete your CGISESSID cookie
1/ Try to reproduce the previous issue
2/ After the second batch, have a look at the sessions table and confirm
that only one job_$JOB_ID exist in the yaml
Signed-off-by: Jonathan Druart
NOTE: Nicely clears batch job session information.
(2) is incorrect. This cleans up after a full run.
Signed-off-by: Mark Tompsett
Signed-off-by: Kyle M Hall
--
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 --- Comment #42 from Kyle M Hall --- Created attachment 38061 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=38061&action=edit [PASSED QA] Bug 13606: Add tests and fix existing ones Some tests were wrong and not executed in a transaction. Lot of sessions were created in DB because the session was never flushed. TEST PLAN - $ mysql ... > delete from sessions; ^Z $ prove -v t/db_dependent/BackgroundJob.t ... $ fg > select id from sessions; -- There will be lots of ids (10, if I recall) ^Z $ git bz apply 13606 ... $ prove -v t/db_dependent/BackgroundJob.t ... $ fg > select * from sessions; -- there should only be the one orphaned job. You can tell it is correct by the "making new job". > quit Run the koha-qa test tools. Signed-off-by: Mark Tompsett Signed-off-by: Kyle M Hall -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Kyle M Hall changed: What|Removed |Added Attachment #38058|0 |1 is obsolete|| --- Comment #40 from Kyle M Hall --- Created attachment 38059 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=38059&action=edit [PASSED QA] Bug 13606: Upgrade sessions.a_session to MEDIUMTEXT The previous patch fixed partially the problem. If you try to update more that 1000 records, you will get the same error. This patch change the type of sessions.a_session from TEXT (64kb) MEDIUMTEXT (32mb). Test plan: 1/ Try to modify a huge amount of records (1000 should be enough) 2/ Confirm it worked! Signed-off-by: Frederic Demians I confirm that with more than 1000 records the session object is truncated, and then can't be anymore be desirialized, blocking completely Koha. Fixed with this patch. Signed-off-by: Mark Tompsett This only pushes off the problem expontentially (64KB vs. 16MB), but this is a good start. Signed-off-by: Kyle M Hall -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Kyle M Hall changed: What|Removed |Added Attachment #37662|0 |1 is obsolete|| Attachment #37663|0 |1 is obsolete|| Attachment #37664|0 |1 is obsolete|| --- Comment #39 from Kyle M Hall --- Created attachment 38058 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=38058&action=edit [PASSED QA] Bug 13606: Upgrade sessions.a_session to MEDIUMTEXT The previous patch fixed partially the problem. If you try to update more that 1000 records, you will get the same error. This patch change the type of sessions.a_session from TEXT (64kb) MEDIUMTEXT (32mb). Test plan: 1/ Try to modify a huge amount of records (1000 should be enough) 2/ Confirm it worked! Signed-off-by: Frederic Demians I confirm that with more than 1000 records the session object is truncated, and then can't be anymore be desirialized, blocking completely Koha. Fixed with this patch. Signed-off-by: Mark Tompsett This only pushes off the problem expontentially (64KB vs. 16MB), but this is a good start. Signed-off-by: Kyle M Hall -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Kyle M Hall changed: What|Removed |Added Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 --- Comment #43 from Tomás Cohen Arazi --- Created attachment 38431 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=38431&action=edit Bug 13606: (RM followup) DBIx updates Signed-off-by: Tomas Cohen Arazi -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Tomás Cohen Arazi changed: What|Removed |Added Status|Passed QA |Pushed to Master CC||tomasco...@gmail.com --- Comment #44 from Tomás Cohen Arazi --- Patches pushed to master. Thanks Jonathan and Frederic! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Chris Cormack changed: What|Removed |Added CC||ch...@bigballofwax.co.nz --- Comment #45 from Chris Cormack --- Doesn't apply and I think is not needed on 3.18.x -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 Jonathan Druart changed: What|Removed |Added CC||claire.hernandez@biblibre.c ||om -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 13606] Batch modification for records is limited to ~500
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13606 --- Comment #46 from Jonathan Druart --- (In reply to Chris Cormack from comment #45) > Doesn't apply and I think is not needed on 3.18.x No it's not, bug 11395 will be in 3.20 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
