Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Utiliser les sessions de base de données POSTGRES

  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 9 months ago #120699 by riqcles
Bonjour à tous,
A cause de problème de time out lié au serveur apache utilisé (je n'ai pas la main dessus), j'ai activé la gestion des sessions dans la base de données POSTGRES.
Cela fonctionnait avec une build 205 un peu ancienne (décembre de mémoire), mais plus maintenant.

Le bug suivant a été créé par un autre membre de la communauté : bugs.limesurvey.org/view.php?id=9592

La correction est arrivé hier, j'ai mis la nouvelle version, mais toujours le même constat.

D'autres peuvent revérifier avant que je relance le sujet ?

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 9 months ago #120702 by DenisChenu
Salut,

Ici, Carsten semble avoir shooté : SET bytea_output='escape'; sur une des table, mais pas de l'avoir mis lors de la mise à jour ?

Pas trop le temps de tester tout de suite ....

Mais si tu confirme que cela ne fonctione toujours pas :
- Active le debug = 2 et le debugSQL à 1.
- Regarde le log dans firebug (ou autre console javascript)
- Réouvre en donnant le log qui montre un problème (ou tout le log si tu ne trouve pas).

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 9 months ago #120707 by riqcles
Je suis désolé, je suis pas trop habitué à Firebug (je viens de l'installer) :blush:
J'ai choisi le panneau console puis :
ALL
et la j'ai un log énorme :laugh:

Mais si je choisi erreur, il n'y en a pas.

Je le colle ici pour savoir si c'est ça :

Debut de log

[17:23:17.031][trace][system.db.ar.CActiveRecord] Plugin.findAllByAttributes()
index (ligne 72)
[17:23:17.034][trace][system.db.CDbConnection] Opening DB connection
index (ligne 73)
[17:23:17.067][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0. Bound with :yp0=1
index (ligne 74)
[17:23:17.088][trace][system.db.CDbCommand] Executing SQL: DELETE FROM "lime_sessions" WHERE expire<:expire. Bound with :expire=1432142597
index (ligne 75)

[17:23:17.090][trace][system.db.CDbCommand] Querying SQL: SELECT "data"
FROM "lime_sessions"
WHERE expire>:expire AND id=:id. Bound with :expire=1432142597, :id='d0l99n27fpf9su8pccr8668237'

index (ligne 76)
[17:23:17.100][trace][system.db.ar.CActiveRecord] SettingGlobal.findAll()
index (ligne 77)
[17:23:17.100][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM "lime_settings_global" "t"
index (ligne 78)
[17:23:17.338][trace][system.db.ar.CActiveRecord] Survey.findByPk()
index (ligne 79)
[17:23:17.339][trace][system.db.CDbCommand] Querying SQL: SELECT * FROM "lime_surveys" "t" WHERE "t"."sid"=333673 LIMIT 1
index (ligne 80)
[17:23:17.342][trace][system.db.ar.CActiveRecord] SurveyLanguageSetting.findByPk()
index (ligne 81)

[17:23:17.348][trace][system.db.CDbCommand] Querying SQL: SELECT "t"."surveyls_survey_id" AS "t0_c0", "t"."surveyls_language" AS "t0_c1", "t"."surveyls_title" AS "t0_c2", "t"."surveyls_description" AS "t0_c3", "t"."surveyls_welcometext" AS "t0_c4", "t"."surveyls_endtext" AS "t0_c5", "t"."surveyls_url" AS "t0_c6", "t"."surveyls_urldescription" AS "t0_c7", "t"."surveyls_email_invite_subj" AS "t0_c8", "t"."surveyls_email_invite" AS "t0_c9", "t"."surveyls_email_remind_subj" AS "t0_c10", "t"."surveyls_email_remind" AS "t0_c11", "t"."surveyls_email_register_subj" AS "t0_c12", "t"."surveyls_email_register" AS "t0_c13", "t"."surveyls_email_confirm_subj" AS "t0_c14", "t"."surveyls_email_confirm" AS "t0_c15", "t"."surveyls_dateformat" AS "t0_c16", "t"."surveyls_attributecaptions" AS "t0_c17", "t"."email_admin_notification_subj" AS "t0_c18", "t"."email_admin_notification" AS "t0_c19", "t"."email_admin_responses_subj" AS "t0_c20", "t"."email_admin_responses" AS "t0_c21", "t"."surveyls_numberformat" AS "t0_c22", "t"."attachments" AS "t0_c23", "survey"."sid" AS "t1_c0", "survey"."owner_id" AS "t1_c1", "survey"."admin" AS "t1_c2", "survey"."active" AS "t1_c3", "survey"."expires" AS "t1_c4", "survey"."startdate" AS "t1_c5", "survey"."adminemail" AS "t1_c6", "survey"."anonymized" AS "t1_c7", "survey"."faxto" AS "t1_c8", "survey"."format" AS "t1_c9", "survey"."savetimings" AS "t1_c10", "survey"."template" AS "t1_c11", "survey"."language" AS "t1_c12", "survey"."additional_languages" AS "t1_c13", "survey"."datestamp" AS "t1_c14", "survey"."usecookie" AS "t1_c15", "survey"."allowregister" AS "t1_c16", "survey"."allowsave" AS "t1_c17", "survey"."autonumber_start" AS "t1_c18", "survey"."autoredirect" AS "t1_c19", "survey"."allowprev" AS "t1_c20", "survey"."printanswers" AS "t1_c21", "survey"."ipaddr" AS "t1_c22", "survey"."refurl" AS "t1_c23", "survey"."datecreated" AS "t1_c24", "survey"."publicstatistics" AS "t1_c25", "survey"."publicgraphs" AS "t1_c26", "survey"."listpublic" AS "t1_c27", "survey"."htmlemail" AS "t1_c28", "survey"."sendconfirmation" AS "t1_c29", "survey"."tokenanswerspersistence" AS "t1_c30", "survey"."assessments" AS "t1_c31", "survey"."usecaptcha" AS "t1_c32", "survey"."usetokens" AS "t1_c33", "survey"."bounce_email" AS "t1_c34", "survey"."attributedescriptions" AS "t1_c35", "survey"."emailresponseto" AS "t1_c36", "survey"."emailnotificationto" AS "t1_c37", "survey"."tokenlength" AS "t1_c38", "survey"."showxquestions" AS "t1_c39", "survey"."showgroupinfo" AS "t1_c40", "survey"."shownoanswer" AS "t1_c41", "survey"."showqnumcode" AS "t1_c42", "survey"."bouncetime" AS "t1_c43", "survey"."bounceprocessing" AS "t1_c44", "survey"."bounceaccounttype" AS "t1_c45", "survey"."bounceaccounthost" AS "t1_c46", "survey"."bounceaccountpass" AS "t1_c47", "survey"."bounceaccountencryption" AS "t1_c48", "survey"."bounceaccountuser" AS "t1_c49", "survey"."showwelcome" AS "t1_c50", "survey"."showprogress" AS "t1_c51", "survey"."questionindex" AS "t1_c52", "survey"."navigationdelay" AS "t1_c53", "survey"."nokeyboard" AS "t1_c54", "survey"."alloweditaftercompletion" AS "t1_c55", "survey"."googleanalyticsstyle" AS "t1_c56", "survey"."googleanalyticsapikey" AS "t1_c57" FROM "lime_surveys_languagesettings" "t" LEFT OUTER JOIN "lime_surveys" "survey" ON (t.surveyls_survey_id = survey.sid) WHERE ("t"."surveyls_survey_id"=333673 AND "t"."surveyls_language"='en')


Fin de LOG

Si c'est ok, je créé un nouveau bug avec comme lien l'ancien.

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 9 months ago #120708 by riqcles
En suivant ce lien (vu dans le bugtracker) : github.com/yiisoft/yii/issues/3476

Le premier intervenant indique qu'il a changer de type de données : i changed the bytea into varchar

Si c'est ça, il faudrait modifier le type pour une base active...bon je dis surement des bétises, mais il n'y a que ceux qui en disent pas qui n'en font pas :lol:

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 9 months ago - 8 years 9 months ago #120709 by DenisChenu
Salut,

On a bien les infos de session dans le log:
Code:
[17:23:17.088][trace][system.db.CDbCommand] Executing SQL: DELETE FROM "lime_sessions" WHERE expire<:expire. Bound with :expire=1432142597
index (ligne 75)
 
[17:23:17.090][trace][system.db.CDbCommand] Querying SQL: SELECT "data"
FROM "lime_sessions"
WHERE expire>:expire AND id=:id. Bound with :expire=1432142597, :id='d0l99n27fpf9su8pccr8668237'

Il faudrais regarder si c'est différent avec la prévisualisation ?
Et poster les 2 logs :
Log : visu de question
Log : prévisu de questions.

Tu es bien sur la 150520 , et tu a bien renouveler ta session (fermer le navigateur puis réouvrir).

Denis
PS: tu n'as pas le bouton "reopen" sur le rapport ?
PS2: oui, il semble que il n'y ai pas de update de la BDD si elle a était mise à jour ...

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Last edit: 8 years 9 months ago by DenisChenu.
The following user(s) said Thank You: riqcles
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 9 months ago #120710 by riqcles
Je reprends les messages pour répondre :
Il faudrais regarder si c'est différent avec la prévisualisation ?
Et poster les 2 logs :
Log : visu de question
17:45:45.946][trace][system.db.CDbCommand] Executing SQL: DELETE FROM "lime_sessions" WHERE expire<:expire. Bound with :expire=1432143945
17 (ligne 203)

[17:45:45.948][trace][system.db.CDbCommand] Querying SQL: SELECT "data"
FROM "lime_sessions"
WHERE expire>:expire AND id=:id. Bound with :expire=1432143945, :id='lsl08ohp8d1jujag975mkkjij3'

Log : prévisu de questions.
[17:39:10.736][trace][system.db.CDbCommand] Executing SQL: DELETE FROM "lime_sessions" WHERE expire<:expire. Bound with :expire=1432143550
index (ligne 75)

[17:39:10.738][trace][system.db.CDbCommand] Querying SQL: SELECT "data"
FROM "lime_sessions"
WHERE expire>:expire AND id=:id. Bound with :expire=1432143550, :id='lsl08ohp8d1jujag975mkkjij3


Tu es bien sur la 150520 , et tu a bien renouveler ta session (fermer le navigateur puis réouvrir).
Oui bien sur la 150520 ;)

Denis
PS: tu n'as pas le bouton "reopen" sur le rapport ? non juste modify
PS2: oui, il semble que il n'y ai pas de update de la BDD si elle a était mise à jour ...

Voila chef :laugh:

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 9 months ago #120711 by DenisChenu
Je n'avais pas vu ton poste précédent.
Donc : oui tu peux créer un nouveau bug avec:
- Indiquer child of : le numéro du précédent
- Indiquer que ta BDD semble avoir le mauvais bytea_output (si tu peux le vérifier ou le faire vérifier, ca serait cool, mais dans ce cas ...)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 9 months ago #120712 by riqcles
Voici un apercu avec pgadmin.


LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 9 months ago #120713 by riqcles
Je poste le bug demain... :P je dois rentre plus tot aujourd'hui.

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
8 years 9 months ago #120754 by riqcles

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
Moderators: Nickko

Lime-years ahead

Online-surveys for every purse and purpose