https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20664
--- Comment #51 from David Cook <[email protected]> --- (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/ch13s13.html). -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] 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/
