https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20664 --- Comment #51 from David Cook <dcook@prosentient.com.au> --- (In reply to Ere Maijala from comment #50)
Unfortunately cached prepared statements don't work well with Plack where the process can outlive the MySQL connection. We found that reconnection to MySQL would leave the prepared statements holding on to the previous connection leading to "MySQL server has gone away" errors. All this could be overcome with additional logic, but that'd be another effort.
That's an interesting point, although I was thinking of just caching (actually, re-using is probably a more accurate word than caching here) the prepared statement in the scope of the batch operation. I wouldn't cache it at the level of the Plack web server. I actually had to deal with that reconnection issue on a separate project recently (see "validate-on-match" and "background-validation" at https://docs.jboss.org/jbossas/docs/Server_Configuration_Guide/beta500/html/...). -- You are receiving this mail because: You are watching all bug changes.