View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
07007Bug reportsOtherpublic2012-12-03 21:432012-12-11 14:57
Reporterseanrife Assigned Toseanrife  
PriorityurgentSeverityblock 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07007: Fatal error when exporting large survey results to SPSS/R
Description

Getting the following message when trying to export data:

Fatal error: Allowed memory size of 201326592 bytes exhausted (tried to allocate 24 bytes) in /home/sr_lime2/surveys.lyceum.ws/ls/framework/db/CDbDataReader.php on line 122

This occurs when any attempt is made to export results to SPSS or R from a survey with a large number of responses.

Steps To Reproduce
  1. Create a new survey using the enclosed .lss file.
  2. Accumulate 1,400+ responses.
  3. Attempt to export the data as described above.
Additional Information

See also 06952.

TagsNo tags attached.
Attached Files
limesurvey_survey_917871.lss (226,326 bytes)
Bug heat6
Complete LimeSurvey version number (& build)121127
I will donate to the project if issue is resolvedYes
Browser
Database type & versionMySQL 5.1.63
Server OS (if known)Debian 6.0
Webserver software & version (if known)Apache 2.2
PHP Version5.2.17

Users monitoring this issue

There are no users monitoring this issue.

Activities

mdekker

mdekker

2012-12-04 10:23

reporter   ~22838

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10688
mdekker

mdekker

2012-12-04 10:26

reporter   ~22839

@seanrife: Can you test the fix please? Timeout can still occur but this should fix memory problems
seanrife

seanrife

2012-12-04 16:37

reporter   ~22883

Thanks mdekker... yes, it's in good shape now. Just successfully exported 2167 responses in a survey with 800+ questions. Should we think about altering set_time_limit based on the number of records exported in order to avoid a timeout?
mdekker

mdekker

2012-12-04 18:15

reporter   ~22884

I want to make spss/r work like the other exports first and then fix the timeout for all exports at once.
seanrife

seanrife

2012-12-04 21:57

reporter   ~22886

Working now. Creating new issue for making SPSS/R exports work like everything else. Will tackle this next.
c_schmitz

c_schmitz

2012-12-07 09:58

administrator   ~23014

2.00+ build 121207 released.
mdekker

mdekker

2012-12-11 14:57

reporter   ~23135

Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10877

Related Changesets

LimeSurvey: master 17dcfc58

2012-12-04 09:23:15

mdekker

Details Diff 		Fixed 07007: Fatal error when exporting large survey results to SPSS/R
dev: also fixed layout problem on R export		 Affected Issues
07007
mod - application/controllers/admin/export.php Diff File
mod - application/helpers/export_helper.php Diff File
mod - styles/blobblueish/adminstyle.css Diff File
mod - styles/gartergrey/adminstyle.css Diff File
mod - styles/gringegreen/adminstyle.css Diff File

LimeSurvey: 2.1 dbe3fffd

2012-12-11 13:52:07

mdekker

Details Diff 		Fixed 07007: Fatal error when exporting large survey results to SPSS/R
dev: also fixed layout problem on R export		 Affected Issues
07007
mod - application/controllers/admin/export.php Diff File
mod - application/helpers/export_helper.php Diff File
mod - styles/blobblueish/adminstyle.css Diff File
mod - styles/gartergrey/adminstyle.css Diff File
mod - styles/gringegreen/adminstyle.css Diff File

Issue History

Date Modified Username Field Change
2012-12-03 21:43 seanrife New Issue
2012-12-03 21:43 seanrife File Added: limesurvey_survey_917871.lss
2012-12-04 00:12 c_schmitz Assigned To => seanrife
2012-12-04 00:12 c_schmitz Status new => assigned
2012-12-04 10:23 mdekker Changeset attached => LimeSurvey master 17dcfc58
2012-12-04 10:23 mdekker Note Added: 22838
2012-12-04 10:23 mdekker Assigned To seanrife => mdekker
2012-12-04 10:23 mdekker Resolution open => fixed
2012-12-04 10:26 mdekker Note Added: 22839
2012-12-04 11:42 mdekker Assigned To mdekker => seanrife
2012-12-04 11:42 mdekker Status assigned => feedback
2012-12-04 16:37 seanrife Note Added: 22883
2012-12-04 16:37 seanrife Status feedback => assigned
2012-12-04 18:15 mdekker Note Added: 22884
2012-12-04 21:57 seanrife Note Added: 22886
2012-12-04 21:57 seanrife Status assigned => resolved
2012-12-04 21:57 seanrife Fixed in Version => 2.00+
2012-12-07 09:58 c_schmitz Note Added: 23014
2012-12-07 09:58 c_schmitz Status resolved => closed
2012-12-11 14:57 mdekker Changeset attached => LimeSurvey 2.1 dbe3fffd
2012-12-11 14:57 mdekker Note Added: 23135