Repeated Delete Fails

Bug #1067443 reported by Carl Leitner
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
I2CE
Fix Committed
High
Luke Duncan

Bug Description

Repeated deletion of forms fails due to too many prepared statements. See for example the following error code from the 4.0 series

I2CE: I2CE->pearError (/Users/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/FormStorage/modules/FormStorageEntry/lib/I2CE_FormStorage_entry.php:844)
I2CE_FormStorage_entry->delete (/Users/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1467)
I2CE_FormStorage->delete
call_user_func_array (/Users/litlfred/rocket_cats/dev/I2CE/lib/I2CE_Fuzzy.php:57)
I2CE_Fuzzy->__call (/Users/litlfred/Dropbox/work/botswana/bzr_branches/4_0_Aug_2012_production_backup/tools/delete_bad_person_ids.php:106)
iHRIS_PersonID->delete (/Users/litlfred/Dropbox/work/botswana/bzr_branches/4_0_Aug_2012_production_backup/tools/delete_bad_person_ids.php:106):
 Invalid delete form statement from record::
 MDB2 Error: unknown error
 _doQuery: [Error message: Could not execute statement]
 [Last executed query: PREPARE MDB2_STATEMENT_mysql_6592282edab44679851c9fb772f6f94b FROM 'DELETE FROM record WHERE id = ?']
 [Native code: 1461]
 [Native message: Can't create more than max_prepared_stmt_count statements (current value: 16382)]

Revision history for this message
Luke Duncan (lduncan) wrote :

I've fixed this by adding reusable prepared statements for the delete method. This has been fixed in 4.1-dev revision 3049. Does this need to be back ported to 4.0?

Changed in i2ce:
assignee: nobody → Luke Duncan (lduncan)
importance: Undecided → High
status: New → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.