Silverpeas » Silverpeas Components » JDBC Connector

Bonjour,

Une requête est régulièrement bloquée dans la table d'activité de Postgres:

 datid |       datname        |  pid  | usesysid | usename  | application_name | client_addr | client_hostname | client_port |         backend_start         |          xact_start           |          query_start          |         state_change          | waiting |        state        |                                                                                                                                                                                                                    query                                                                                                                                                                                                                    
-------+----------------------+-------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+---------+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 16387 | SilverpeasProduction |  9770 |    16385 | spuser   |                  | 127.0.0.1   |                 |       49016 | 2016-09-15 10:34:38.052313+02 |                               | 2016-09-15 10:34:38.116701+02 | 2016-09-15 10:34:38.164741+02 | f       | idle                | select \r                                                                                                                                                                                                                                                                                                                                                                                                                                  +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | sc_resources_reservation.id,\r                                                                                                                                                                                                                                                                                                                                                                                                             +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | sc_resources_resource.name AS RESSOURCE, st_user.firstname AS PRENOM,\r                                                                                                                                                                                                                                                                                                                                                                    +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | st_user.lastname AS NOM,\r                                                                                                                                                                                                                                                                                                                                                                                                                 +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | evenement AS OBJET, \r                                                                                                                                                                                                                                                                                                                                                                                                                     +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | TIMESTAMP 'epoch' + (to_number(begindate, '9999999999999')+3600000+3600000) * INTERVAL '0.001 second' AS DATEDEBUT,\r                                                                                                                                                                                                                                                                                                                      +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | TIMESTAMP 'epoch' + (to_number(enddate, '9999999999999')+3600000+3600000) * INTERVAL '0.001 second' AS DATEFIN,\r                                                                                                                                                                                                                                                                                                                          +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | reason AS DESCRIPTION,\r                                                                                                                                                                                                                                                                                                                                                                                                                   +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | place AS LIEU \r                                                                                                                                                                                                                                                                                                                                                                                                                           +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | \r                                                                                                                                                                                                                                                                                                                                                                                                                                         +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | from sc_resources_reservation,\r                                                                                                                                                                                                                                                                                                                                                                                                           +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | st_user,\r                                                                                                                                                                                                                                                                                                                                                                                                                                 +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | sc_resources_resource,\r                                                                                                                                                                                                                                                                                                                                                                                                                   +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | sc_resources_reservedresource\r                                                                                                                                                                                                                                                                                                                                                                                                            +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | where \r                                                                                                                                                                                                                                                                                                                                                                                                                                   +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | \r                                                                                                                                                                                                                                                                                                                                                                                                                                         +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | sc_resources_reservation.instanceid='resourcesManager3137'\r                                                                                                                                                                                                                                                                                                                                                                               +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | and sc_resources_resource.id=sc_resources_reservedresource.resourceid\r                                                                                                                                                                                                                                                                                                                                                                    +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | and sc_resources_reservation.id=sc_resources_reservedresource.reservationid\r                                                                                                                                                                                                                                                                                                                                                              +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | and st_user.id=sc_resources_reservation.userid \r                                                                                                                                                                                                                                                                                                                                                                                          +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | and TIMESTAMP 'epoch' + (to_number(begindate, '9999999999999')+3600000) * INTERVAL '0.001 second' > (CURRENT_TIMESTAMP - interval '2 days')\r                                                                                                                                                                                                                                                                                              +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | \r                                                                                                                                                                                                                                                                                                                                                                                                                                         +
       |                      |       |          |          |                  |             |                 |             |                               |                               |                               |                               |         |                     | ORDER BY DATEDEBUT asc

Elle apparait souvent très peu de temps après un redémarrage du portail, sans doute dès la première consultation d'une ressource, et reste bloquée indéfiniment, jusqu'à ce qu'on ai besoin de redémarrer le portail.

Le portail semble bien fonctionner, même avec cette requête de bloquée, mais elle peut-être la cause de dysfonctionnement déjà ou pas encore déclaré.

Cordialement.