- Posts: 8
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Check data integrity after upgrade to 3.x
- gslines
- Topic Author
- Offline
- New Member
Less
More
5 years 8 months ago #172588
by gslines
Check data integrity after upgrade to 3.x was created by gslines
Hello,
After upgrading from 2.73 to 3.x (currently at 3.14.5), the "Check data integrity" option doesn't work anymore in our Limesurvey installation. This is a rather big instance, with more than 3800 surveys. When clicking on "Check data integrity", the spinning wheel goes on for a while and the results page never comes up, finishing with a blank screen and nothing logged on the browser console. It worked fine when we were running 2.73.
Has anyone else experienced this? Is there any non-TTW way to perform this data integrity check?
Thanks!!!
G
After upgrading from 2.73 to 3.x (currently at 3.14.5), the "Check data integrity" option doesn't work anymore in our Limesurvey installation. This is a rather big instance, with more than 3800 surveys. When clicking on "Check data integrity", the spinning wheel goes on for a while and the results page never comes up, finishing with a blank screen and nothing logged on the browser console. It worked fine when we were running 2.73.
Has anyone else experienced this? Is there any non-TTW way to perform this data integrity check?
Thanks!!!
G
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
5 years 8 months ago #172630
by jelo
Please open a bugticket.
As a workaround you might check the php timeout and raise the limit.
I'm not aware of a commandline php controller for such tasks (perhaps a feature request).
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Check data integrity after upgrade to 3.x
I don't think such amount of surveys is used as testcase during development.gslines wrote: This is a rather big instance, with more than 3800 surveys. When clicking on "Check data integrity", the spinning wheel goes on for a while and the results page never comes up, finishing with a blank screen and nothing logged on the browser console.
Please open a bugticket.
As a workaround you might check the php timeout and raise the limit.
I'm not aware of a commandline php controller for such tasks (perhaps a feature request).
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
- gslines
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
5 years 8 months ago #172636
by gslines
Replied by gslines on topic Check data integrity after upgrade to 3.x
Thank you jelo. I will open a bug ticket about it and hopefully it can be reproduced somehow by the developers.
I will also see if raising the php timeout limit gets me through it.
Thanks again!
I will also see if raising the php timeout limit gets me through it.
Thanks again!
The topic has been locked.
- holch
- Away
- LimeSurvey Community Team
Less
More
- Posts: 11657
- Thank you received: 2742
5 years 8 months ago #172637
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Check data integrity after upgrade to 3.x
I am quite sure that the problem lies in the long execution of the pure amount of surveys.
There are a few points in PHP where you might actually get stuck. Execution time most probably, because checking 3800 surveys will take quite a while for the script. Maybe also file size of the session and max vars or something. All things for which you might run into limits set on your server.
And I agree, I don't know the size of the installations of Limesurvey Professional for each server, but 3800 surveys is A LOT.
There are a few points in PHP where you might actually get stuck. Execution time most probably, because checking 3800 surveys will take quite a while for the script. Maybe also file size of the session and max vars or something. All things for which you might run into limits set on your server.
And I agree, I don't know the size of the installations of Limesurvey Professional for each server, but 3800 surveys is A LOT.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
5 years 8 months ago #172642
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Check data integrity after upgrade to 3.x
LimeSurvey is not multitenant. LimeSurvey professional installations are having a database per useraccount. Many small databases instead of one big database.holch wrote: And I agree, I don't know the size of the installations of Limesurvey Professional for each server, but 3800 surveys is A LOT.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
- holch
- Away
- LimeSurvey Community Team
Less
More
- Posts: 11657
- Thank you received: 2742
5 years 8 months ago #172646
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Check data integrity after upgrade to 3.x
So you mean the LS Professional Installations are modified?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
5 years 8 months ago #172649
by jelo
I thought you mentioned it, because of the amount of surveys which can reside on one server.
3800 users (limesurvey.org account, not Surveyusers) with one survey will result in 1 survey per database. The check of data integrity will be quick.
LimeSurvey.org account vs. LimeSurvey user might be the source of confusion.
The LS software on the professional installations is modified in many ways.
But not in terms of database per installation.
When you buy a LS professional installation you're running your own, separate php application with a separate database.
Multitenant software(which is used by many other saas survey systems) is not using one database per useraccount and is running one code for all users.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Check data integrity after upgrade to 3.x
No, but perhaps i didn't understood your remark about the LS professional installations.holch wrote: So you mean the LS Professional Installations are modified?
I thought you mentioned it, because of the amount of surveys which can reside on one server.
3800 users (limesurvey.org account, not Surveyusers) with one survey will result in 1 survey per database. The check of data integrity will be quick.
LimeSurvey.org account vs. LimeSurvey user might be the source of confusion.
The LS software on the professional installations is modified in many ways.
But not in terms of database per installation.
When you buy a LS professional installation you're running your own, separate php application with a separate database.
Multitenant software(which is used by many other saas survey systems) is not using one database per useraccount and is running one code for all users.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
- holch
- Away
- LimeSurvey Community Team
Less
More
- Posts: 11657
- Thank you received: 2742
5 years 8 months ago #172681
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Check data integrity after upgrade to 3.x
I was aware that LS runs one complete LS instance per account, which creates a lot of overhead, I guess.
On the other hand, this also means that the installations are well separated, which has its advantages too. But hey, not my problem anyway.
I now get what you were trying to say. All clear. And yes, taking this into account, even Limesurvey Professional installations probably have not been tested with 3800 survey. But then, who knows?
On the other hand, this also means that the installations are well separated, which has its advantages too. But hey, not my problem anyway.
I now get what you were trying to say. All clear. And yes, taking this into account, even Limesurvey Professional installations probably have not been tested with 3800 survey. But then, who knows?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- LouisGac
- Visitor
5 years 8 months ago #172695
by LouisGac
Replied by LouisGac on topic Check data integrity after upgrade to 3.x
Checking data integrity for 3800 surveys should be ok, just update the PHP configuration of your server.
The topic has been locked.
- gslines
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
5 years 8 months ago #172719
by gslines
Replied by gslines on topic Check data integrity after upgrade to 3.x
@LouisGac: Do you mean raising the php timeout setting? Others?
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
5 years 8 months ago #172720
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Check data integrity after upgrade to 3.x
Yes.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
- gslines
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
5 years 8 months ago #172721
by gslines
Replied by gslines on topic Check data integrity after upgrade to 3.x
OK, I'll give that a try and come back with a followup.
PS: We have more than 700 user accounts on our Limesurvey instance. Having a model of 1 separate LS instance per user is not sustainable for us.
PS: We have more than 700 user accounts on our Limesurvey instance. Having a model of 1 separate LS instance per user is not sustainable for us.
The topic has been locked.