Reviewed: https://reviews.mahara.org/3269 Committed: http://gitorious.org/mahara/mahara/commit/02a60fb4cbb01c9c8dc6670bb54780226726e768 Submitter: Son Nguyen (son.ngu...@catalyst.net.nz) Branch: master
commit 02a60fb4cbb01c9c8dc6670bb54780226726e768 Author: Robert Lyon <robe...@catalyst.net.nz> Date: Tue Apr 22 12:07:36 2014 +1200 Problem with oversized sql IN() clause (Bug #1308792) Currently institution data daily cronjob fails if the number of items wanted to be prepared for the IN() clause exceeds 46,000. This causes adodb to hit memory limit and fail out. Have taken the three sql commands from various places that make up the call and made them nested to avoid overly long prepared statement. Change-Id: I5e38c01194f7b2c3f3899c1573a69411ac273c18 Signed-off-by: Robert Lyon <robe...@catalyst.net.nz> -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1308792 Title: institution data daily cron failing Status in Mahara ePortfolio: In Progress Bug description: It looks like the cron_institution_data_daily may be failing to create the pie graph due to the sql IN statement needing to deal with a too large sql statement. On mahara.org it tries to create a sql statement with an IN clause containing 46000+ ids. There should be a better way of handling this rather than doing such a great big sql statement. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1308792/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
