Actions
Bug #484
closedwarden-server-2.0.0 - Chyba pri volani SELECTU s placeholderem prepare_cached
Start date:
06/06/2012
Due date:
% Done:
0%
Estimated time:
Description
Pri volani jakehokoliv databazoveho SELECTu s pouzitym placeholderem prepared_cached se v error.log Apache objevuji chybove hlasky statement handle DBI still Active zpusobene pouzitim tohoto prikazu. Ukazky hlasek z logu:
prepare_cached(SELECT count(*) FROM events WHERE hostname = ? AND service = ?;) statement handle DBI::st=HASH(0x7fc50c651348) still Active at /opt/warden-server/lib/Warden.pm line 633
prepare_cached(SELECT hostname, ip_net_client FROM clients WHERE hostname IN ('afrodita.civ.zcu.cz','afrodita.civ.zcu.cz') AND service = ? AND client_type = ? LIMIT 1;) statement handle DBI::st=HASH(0x7fc50d840898) still Active at /opt/warden-server/lib/Warden.pm line 162
prepare_cached(SELECT max(received) FROM events WHERE hostname = ? AND service = ?;) statement handle DBI::st=HASH(0x7fc50db54288) still Active at /opt/warden-server/lib/Warden.pm line 639
Updated by Tomáš Plesník over 12 years ago
- Subject changed from Chyba pri volani SELECTU s placeholderem prepare_cached to warden-server-2.0.0 - Chyba pri volani SELECTU s placeholderem prepare_cached
- Status changed from New to Closed
Opraveno zmenou placeholderu z prepared_cached na standardni prepare. Puvodni motivace pro pouziti prepare_cached byla nasledujici:
In order to benefit from this newfound efficiency, you'll have to modify your code slightly. The best way to do this is to use the prepare_cached method instead of prepare. prepare_cached does the same thing as prepare, but first looks to see if the statement has already been compiled; if it has, it returns the compiled version.
Actions