View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
18479Bug reports_ Unknownpublic2022-11-09 13:04
ReporterDenisChenu Assigned To 
PrioritynoneSeveritypartial_block 
Status newResolutionopen 
Product Version5.4.x 
Summary18479: Unable to import big survey without debug
Description

When try to import big survey in5/X : receive a memory issue after a long time.
It work on near same server with less memory

Steps To Reproduce

Steps to reproduce

Specific server (?)
Import https://github.com/LimeSurvey/LimeSurvey/blob/master/docs/demosurveys/ls3_sample_survey_multilingual_fr_de_en_it.lss

Expected result

Survey is imported

Actual result

White page after 2.73 min
it's OK on near same after 40s (but time to upload can be more on 3.X)

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)5.4.9
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionMSSQL 15.00.4198 / msodbcsql18 18.00.0001
Server OS (if known)windows
Webserver software & version (if known)IIS
PHP Version7.4

Users monitoring this issue

User List There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2022-11-09 12:57

developer  

5X_timeImport.png (28,049 bytes)   
5X_timeImport.png (28,049 bytes)   
3X_timeImport.png (53,373 bytes)   
3X_timeImport.png (53,373 bytes)   
DenisChenu

DenisChenu

2022-11-09 12:58

developer   ~72677

memory_limit set by config

5.X : 1024Mo
3.X: 512Mo

DenisChenu

DenisChenu

2022-11-09 12:59

developer   ~72678

Debug + debugSQL
Get : Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 20480 bytes) in E:\WebSite\limesurvey\application\models\services\QuestionAttributeHelper.php on line 35 Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 81920 bytes) in E:\WebSite\limesurvey\third_party\yiisoft\yii\framework\logging\CLogger.php on line 15

DenisChenu

DenisChenu

2022-11-09 13:01

developer   ~72679

Last edited: 2022-11-09 13:02

Import locally (big workstation) with debian + nginx+7.4+ local mariadb

SQL log :

system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1)    931     0.23036     0.00025     0.00013     0.00059
system.db.CDbCommand.query(SELECT `t`.`gsid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`adminemail` AS `t0_c3`, `t`.`anonymized` AS `t0_c4`, `t`.`format` AS `t0_c5`, `t`.`savetimings` AS `t0_c6`, `t`.`template` AS `t0_c7`, `t`.`datestamp` AS `t0_c8`, `t`.`usecookie` AS `t0_c9`, `t`.`allowregister` AS `t0_c10`, `t`.`allowsave` AS `t0_c11`, `t`.`autonumber_start` AS `t0_c12`, `t`.`autoredirect` AS `t0_c13`, `t`.`allowprev` AS `t0_c14`, `t`.`printanswers` AS `t0_c15`, `t`.`ipaddr` AS `t0_c16`, `t`.`ipanonymize` AS `t0_c17`, `t`.`refurl` AS `t0_c18`, `t`.`showsurveypolicynotice` AS `t0_c19`, `t`.`publicstatistics` AS `t0_c20`, `t`.`publicgraphs` AS `t0_c21`, `t`.`listpublic` AS `t0_c22`, `t`.`htmlemail` AS `t0_c23`, `t`.`sendconfirmation` AS `t0_c24`, `t`.`tokenanswerspersistence` AS `t0_c25`, `t`.`assessments` AS `t0_c26`, `t`.`usecaptcha` AS `t0_c27`, `t`.`bounce_email` AS `t0_c28`, `t`.`attributedescriptions` AS `t0_c29`, `t`.`emailresponseto` AS `t0_c30`, `t`.`emailnotificationto` AS `t0_c31`, `t`.`tokenlength` AS `t0_c32`, `t`.`showxquestions` AS `t0_c33`, `t`.`showgroupinfo` AS `t0_c34`, `t`.`shownoanswer` AS `t0_c35`, `t`.`showqnumcode` AS `t0_c36`, `t`.`showwelcome` AS `t0_c37`, `t`.`showprogress` AS `t0_c38`, `t`.`questionindex` AS `t0_c39`, `t`.`navigationdelay` AS `t0_c40`, `t`.`nokeyboard` AS `t0_c41`, `t`.`alloweditaftercompletion` AS `t0_c42`, `SurveysGroups`.`gsid` AS `t1_c0`, `SurveysGroups`.`name` AS `t1_c1`, `SurveysGroups`.`title` AS `t1_c2`, `SurveysGroups`.`template` AS `t1_c3`, `SurveysGroups`.`description` AS `t1_c4`, `SurveysGroups`.`sortorder` AS `t1_c5`, `SurveysGroups`.`owner_id` AS `t1_c6`, `SurveysGroups`.`parent_id` AS `t1_c7`, `SurveysGroups`.`alwaysavailable` AS `t1_c8`, `SurveysGroups`.`created` AS `t1_c9`, `SurveysGroups`.`modified` AS `t1_c10`, `SurveysGroups`.`created_by` AS `t1_c11` FROM `lime_surveys_groupsettings` `t` LEFT OUTER JOIN `lime_surveys_groups` `SurveysGroups` ON (`SurveysGroups`.`gsid`=`t`.`gsid`) WHERE (`t`.`gsid`=1))    465     0.18179     0.00039     0.00027     0.00121
system.db.CDbCommand.query(SELECT `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`, `survey`.`gsid` AS `t1_c2`, `survey`.`admin` AS `t1_c3`, `survey`.`active` AS `t1_c4`, `survey`.`expires` AS `t1_c5`, `survey`.`startdate` AS `t1_c6`, `survey`.`adminemail` AS `t1_c7`, `survey`.`anonymized` AS `t1_c8`, `survey`.`faxto` AS `t1_c9`, `survey`.`format` AS `t1_c10`, `survey`.`savetimings` AS `t1_c11`, `survey`.`template` AS `t1_c12`, `survey`.`language` AS `t1_c13`, `survey`.`additional_languages` AS `t1_c14`, `survey`.`datestamp` AS `t1_c15`, `survey`.`usecookie` AS `t1_c16`, `survey`.`allowregister` AS `t1_c17`, `survey`.`allowsave` AS `t1_c18`, `survey`.`autonumber_start` AS `t1_c19`, `survey`.`autoredirect` AS `t1_c20`, `survey`.`allowprev` AS `t1_c21`, `survey`.`printanswers` AS `t1_c22`, `survey`.`ipaddr` AS `t1_c23`, `survey`.`ipanonymize` AS `t1_c24`, `survey`.`refurl` AS `t1_c25`, `survey`.`datecreated` AS `t1_c26`, `survey`.`showsurveypolicynotice` AS `t1_c27`, `survey`.`publicstatistics` AS `t1_c28`, `survey`.`publicgraphs` AS `t1_c29`, `survey`.`listpublic` AS `t1_c30`, `survey`.`htmlemail` AS `t1_c31`, `survey`.`sendconfirmation` AS `t1_c32`, `survey`.`tokenanswerspersistence` AS `t1_c33`, `survey`.`assessments` AS `t1_c34`, `survey`.`usecaptcha` AS `t1_c35`, `survey`.`usetokens` AS `t1_c36`, `survey`.`bounce_email` AS `t1_c37`, `survey`.`attributedescriptions` AS `t1_c38`, `survey`.`emailresponseto` AS `t1_c39`, `survey`.`emailnotificationto` AS `t1_c40`, `survey`.`tokenlength` AS `t1_c41`, `survey`.`showxquestions` AS `t1_c42`, `survey`.`showgroupinfo` AS `t1_c43`, `survey`.`shownoanswer` AS `t1_c44`, `survey`.`showqnumcode` AS `t1_c45`, `survey`.`bouncetime` AS `t1_c46`, `survey`.`bounceprocessing` AS `t1_c47`, `survey`.`bounceaccounttype` AS `t1_c48`, `survey`.`bounceaccounthost` AS `t1_c49`, `survey`.`bounceaccountpass` AS `t1_c50`, `survey`.`bounceaccountencryption` AS `t1_c51`, `survey`.`bounceaccountuser` AS `t1_c52`, `survey`.`showwelcome` AS `t1_c53`, `survey`.`showprogress` AS `t1_c54`, `survey`.`questionindex` AS `t1_c55`, `survey`.`navigationdelay` AS `t1_c56`, `survey`.`nokeyboard` AS `t1_c57`, `survey`.`alloweditaftercompletion` AS `t1_c58`, `survey`.`googleanalyticsstyle` AS `t1_c59`, `survey`.`googleanalyticsapikey` AS `t1_c60`, `survey`.`tokenencryptionoptions` AS `t1_c61` FROM `lime_surveys` `survey` WHERE (`survey`.`sid`=:ypl0). Bound with :ypl0='379676')   406     0.15690     0.00039     0.00028     0.00060
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1)   465     0.13426     0.00029     0.00017     0.00056
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='boilerplate', :extends='X')    77  0.02456     0.00032     0.00018     0.00051
system.db.CDbCommand.execute(INSERT INTO `lime_question_l10ns` (`question`, `help`, `language`, `qid`) VALUES (:yp0, :yp1, :yp2, :yp3). Bound with :yp0='LimeSurvey is best than ', :yp1='', :yp2='en', :yp3=10508)     1   0.02247     0.02247     0.02247     0.02247
system.db.CDbCommand.query(SELECT `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`, `survey`.`gsid` AS `t1_c2`, `survey`.`admin` AS `t1_c3`, `survey`.`active` AS `t1_c4`, `survey`.`expires` AS `t1_c5`, `survey`.`startdate` AS `t1_c6`, `survey`.`adminemail` AS `t1_c7`, `survey`.`anonymized` AS `t1_c8`, `survey`.`faxto` AS `t1_c9`, `survey`.`format` AS `t1_c10`, `survey`.`savetimings` AS `t1_c11`, `survey`.`template` AS `t1_c12`, `survey`.`language` AS `t1_c13`, `survey`.`additional_languages` AS `t1_c14`, `survey`.`datestamp` AS `t1_c15`, `survey`.`usecookie` AS `t1_c16`, `survey`.`allowregister` AS `t1_c17`, `survey`.`allowsave` AS `t1_c18`, `survey`.`autonumber_start` AS `t1_c19`, `survey`.`autoredirect` AS `t1_c20`, `survey`.`allowprev` AS `t1_c21`, `survey`.`printanswers` AS `t1_c22`, `survey`.`ipaddr` AS `t1_c23`, `survey`.`ipanonymize` AS `t1_c24`, `survey`.`refurl` AS `t1_c25`, `survey`.`datecreated` AS `t1_c26`, `survey`.`showsurveypolicynotice` AS `t1_c27`, `survey`.`publicstatistics` AS `t1_c28`, `survey`.`publicgraphs` AS `t1_c29`, `survey`.`listpublic` AS `t1_c30`, `survey`.`htmlemail` AS `t1_c31`, `survey`.`sendconfirmation` AS `t1_c32`, `survey`.`tokenanswerspersistence` AS `t1_c33`, `survey`.`assessments` AS `t1_c34`, `survey`.`usecaptcha` AS `t1_c35`, `survey`.`usetokens` AS `t1_c36`, `survey`.`bounce_email` AS `t1_c37`, `survey`.`attributedescriptions` AS `t1_c38`, `survey`.`emailresponseto` AS `t1_c39`, `survey`.`emailnotificationto` AS `t1_c40`, `survey`.`tokenlength` AS `t1_c41`, `survey`.`showxquestions` AS `t1_c42`, `survey`.`showgroupinfo` AS `t1_c43`, `survey`.`shownoanswer` AS `t1_c44`, `survey`.`showqnumcode` AS `t1_c45`, `survey`.`bouncetime` AS `t1_c46`, `survey`.`bounceprocessing` AS `t1_c47`, `survey`.`bounceaccounttype` AS `t1_c48`, `survey`.`bounceaccounthost` AS `t1_c49`, `survey`.`bounceaccountpass` AS `t1_c50`, `survey`.`bounceaccountencryption` AS `t1_c51`, `survey`.`bounceaccountuser` AS `t1_c52`, `survey`.`showwelcome` AS `t1_c53`, `survey`.`showprogress` AS `t1_c54`, `survey`.`questionindex` AS `t1_c55`, `survey`.`navigationdelay` AS `t1_c56`, `survey`.`nokeyboard` AS `t1_c57`, `survey`.`alloweditaftercompletion` AS `t1_c58`, `survey`.`googleanalyticsstyle` AS `t1_c59`, `survey`.`googleanalyticsapikey` AS `t1_c60`, `survey`.`tokenencryptionoptions` AS `t1_c61` FROM `lime_surveys` `survey` WHERE (`survey`.`sid`=:ypl0). Bound with :ypl0=379676)
DenisChenu

DenisChenu

2022-11-09 13:04

developer   ~72680

CompletImportSQLLog.txt (1,160,765 bytes)

Issue History

Date Modified Username Field Change
2022-11-09 12:57 DenisChenu New Issue
2022-11-09 12:57 DenisChenu File Added: 5X_timeImport.png
2022-11-09 12:57 DenisChenu File Added: 3X_timeImport.png
2022-11-09 12:58 DenisChenu Note Added: 72677
2022-11-09 12:58 DenisChenu Bug heat 0 => 2
2022-11-09 12:59 DenisChenu Note Added: 72678
2022-11-09 13:01 DenisChenu Note Added: 72679
2022-11-09 13:02 DenisChenu Note Edited: 72679
2022-11-09 13:04 DenisChenu Note Added: 72680
2022-11-09 13:04 DenisChenu File Added: CompletImportSQLLog.txt