Project

General

Profile

action #55313

long running (minutes) postgres SELECT calls on osd

Added by okurz about 2 years ago. Updated about 2 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
Category:
Concrete Bugs
Target version:
-
Start date:
2019-07-31
Due date:
% Done:

0%

Estimated time:
Difficulty:

Description

Observation

# ps auxf | grep 'postgres.*SELECT'
postgres 28455 33.2  0.9 224312 156928 ?       Rs   14:47   2:30  \_ postgres: geekotest openqa [local] SELECT

and

sudo -u geekotest psql -q openqa -c 'select * from pg_stat_activity where pid=28455;'
 datid | datname |  pid  | usesysid |  usename  | application_name | client_addr | client_hostname | client_port |         backend_start         |          x
act_start           |          query_start          |         state_change          | wait_event_type | wait_event | state  | backend_xid | backend_xmin |



                       query



-------+---------+-------+----------+-----------+------------------+-------------+-----------------+-------------+-------------------------------+-----------
--------------------+-------------------------------+-------------------------------+-----------------+------------+--------+-------------+--------------+---
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------
 16385 | openqa  | 28455 |    16384 | geekotest |                  |             |                 |          -1 | 2019-08-09 14:47:47.154343+02 | 2019-08-09
 14:55:38.438059+02 | 2019-08-09 14:55:38.439053+02 | 2019-08-09 14:55:38.439057+02 |                 |            | active |             |   2079545223 | SE
LECT me.id, me.filename, me.t_created FROM screenshots me LEFT OUTER JOIN screenshot_links links_outer ON links_outer.screenshot_id = me.id WHERE ( id IN ( $
1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $3
4, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65,
 $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $
97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123,
 $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149 )
 ) GROUP BY me.id HAVING COUNT(links_outer.job_id) = 0
(1 row)

Related issues

Copied from openQA Project - action #54902: openQA on osd fails at "incomplete" status when uploading, "502 response: Proxy Error"Resolved2019-07-31

Copied to openQA Infrastructure - action #55316: monitoring alerts for too long running database queriesNew2019-07-31

History

#1 Updated by okurz about 2 years ago

  • Copied from action #54902: openQA on osd fails at "incomplete" status when uploading, "502 response: Proxy Error" added

#2 Updated by okurz about 2 years ago

  • Copied to action #55316: monitoring alerts for too long running database queries added

#3 Updated by coolo about 2 years ago

  • Status changed from New to Rejected

rejecting in favor of more specific issue

Also available in: Atom PDF