[Johannes Reimchen]

Hallo zusammen,

wir haben bereits zum zweiten mal das Problem dass offensichtlich zu viele Verbindungen aufgemacht werden und mit OTOBO(10.0.13) nicht gearbeitet werden kann (Sanduhr im Browser).

Eingestellter Wert: max_connections=100

Es sieht so aus als würde irgendein Hintergrundprozess die Verbindungen nicht schließen.

Ist dieses Problem bereits bekannt?

 

Als erste Fehleranalyse würde ich beim nächste Fall die Verbindungen mit [select * from pg_stat_activity;] prüfen, evtl. ergibt sich etwas…

Hier noch ein Paar Log Ausgaben:

[Mon Nov 8 08:09:24 2021][Error][Kernel::System::Web::InterfaceAgent::Run][206] FATAL: remaining connection slots are reserved for non-replication superuser connections

2021-11-08 08:09:23.948 CET [202791] otobo@otobo FATAL: sorry, too many clients already
2021-11-08 08:09:23.946 CET [202804] otobo@otobo FATAL: remaining connection slots are reserved for non-replication superuser connections

[Mon Nov 08 08:09:10.247773 2021] [mpm_prefork:error] [pid 934] AH00161: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting
[Mon Nov 8 08:09:24 2021] -e: DBI connect(‘dbname=otobo;host=127.0.0.1′,’otobo’,…) failed: FATAL: remaining connection slots are reserved for non-replication superuser connections at /opt/otobo/Kernel/System/DB.pm line 332.

[Stefan Rother]

Hallo Johannes,

ich hoffe es geht Dir gut!

Nein, das ist kein bekanntes Problem. Eigentlich denke ich, dass einfach zu viele Sessions offen sind. Kannst Du das bitte mal unter Admin-> Sessions überprüfen?

 

Was mich aber wundert ist, dass der Apache auch zu viele offene Worker hat: “server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting”.

Kannst Du noch ein paar mehr Infos posten bitte zu Eurem Setup. Anzahl der Kunden und Agenten, etc.?

Danke,

Stefan

Team OTOBO

[Johannes Reimchen]

Guten Morgen Stefan,

hätte nicht gedacht dass ich so schnell eine Antwort bekomme, sonst hätte ich hier schon früher nachgesehen :-) 

Heute hatten wir leider erneut das gleiche Problem. Die SPU Last der VM geht auf Maximum und der Admin Bereich lässt sich gar nicht öffnen (Sanduhr), das System hängt sich praktisch auf.

Das Kundenportal wird nicht genutzt und Agenten haben wir auch < 100.

Support Paket habe ich an euch gesendet, ich es funktioniert so…

Mit dem [select * from pg_stat_activity;] konnte ich heute zumindest ein Paar Daten abgreifen. Dabei fällt mir auf, dass zu oft der Query [/n SELECT id, data_key, data_value, serialized/n FROM sessions/n WHERE session_id = $1/n ORDER BY id ASC] durchgeführt wird.

Leider weiß ich nicht wie ich den Export als Datei hier anhängen kann, hier ein Paar Zeilen:

<hr />

<null> <null> 934 10 postgres <Other> <null> <null> 2021-11-08 08:13:14.068648 <null> <null> <null> Activity LogicalLauncherMain <null> <null> <null> logical replication launcher
<null> <null> 932 <null> <null> <Other> <null> <null> 2021-11-08 08:13:14.069258 <null> <null> <null> Activity AutoVacuumMain <null> <null> <null> autovacuum launcher
<null> <null> 930 <null> <null> <Other> <null> <null> 2021-11-08 08:13:14.066914 <null> <null> <null> Activity BgWriterMain <null> <null> <null> background writer
<null> <null> 929 <null> <null> <Other> <null> <null> 2021-11-08 08:13:14.067313 <null> <null> <null> Activity CheckpointerMain <null> <null> <null> checkpointer
<null> <null> 931 <null> <null> <Other> <null> <null> 2021-11-08 08:13:14.06951 <null> <null> <null> Activity WalWriterMain <null> <null> <null> walwriter
16385 otobo 626038 16384 otobo <Other> <null> 47976 2021-11-29 08:00:46.468975 <null> 2021-11-29 08:46:23.659508 2021-11-29 08:46:27.815744 Client ClientRead idle <Other> <Other> /* DBD::Pg ping test v3.10.4 */ client backend
16385 otobo 626268 16384 otobo <Other> <null> 48188 2021-11-29 08:10:04.898975 <null> 2021-11-29 08:46:09.346025 2021-11-29 08:46:09.346082 Client ClientRead idle <Other> <Other> /* DBD::Pg ping test v3.10.4 */ client backend
16385 otobo 626602 16384 otobo <Other> <null> 48612 2021-11-29 08:20:52.588541 <null> 2021-11-29 08:46:30.48699 2021-11-29 08:46:30.575967 Client ClientRead idle <Other> <Other> /* DBD::Pg ping test v3.10.4 */ client backend
16385 otobo 627488 16384 otobo <Other> <null> 49364 2021-11-29 08:45:07.579274 <null> 2021-11-29 08:46:41.919512 2021-11-29 08:46:42.009542 <null> <null> idle <Other> <Other> /* DBD::Pg ping test v3.10.4 */ client backend
16385 otobo 627513 16384 otobo <Other> <null> 49414 2021-11-29 08:45:10.155949 <null> 2021-11-29 08:46:39.163111 2021-11-29 08:46:39.164978 <null> <null> active <Other> <Other> /* DBD::Pg ping test v3.10.4 */ client backend
13475 postgres 627585 10 postgres <Other> <null> 59069 2021-11-29 08:45:22.103646 2021-11-29 08:46:28.891294 2021-11-29 08:46:39.160075 2021-11-29 08:46:39.16333 <null> <null> active <Other> <Other> select * from pg_stat_activity client backend
16385 otobo 627382 16384 otobo <Other> <null> 49302 2021-11-29 08:44:55.54941 2021-11-29 08:46:31.211806 2021-11-29 08:46:31.211806 2021-11-29 08:46:31.211813 <null> <null> active <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 1, 4, 6 ) AND ( st.responsible_user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627486 16384 otobo <Other> <null> 49360 2021-11-29 08:45:07.579494 2021-11-29 08:46:31.608709 2021-11-29 08:46:31.608709 2021-11-29 08:46:31.618627 <null> <null> active <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 1, 4, 6 ) AND ( st.responsible_user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627545 16384 otobo <Other> <null> 49454 2021-11-29 08:45:14.377641 2021-11-29 08:46:42.090754 2021-11-29 08:46:42.090754 2021-11-29 08:46:42.090757 <null> <null> active <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 1, 4, 6 ) AND ( st.responsible_user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627388 16384 otobo <Other> <null> 49312 2021-11-29 08:44:55.731164 <null> 2021-11-29 08:46:36.876707 2021-11-29 08:46:37.811886 Client ClientRead idle <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 6 ) AND ( st.responsible_user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND st.ticket_state_id IN (6) AND st.until_time <= 1638171917 AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627383 16384 otobo <Other> <null> 49304 2021-11-29 08:44:55.579771 <null> 2021-11-29 08:45:53.845959 2021-11-29 08:45:53.846487 Client ClientRead idle <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 6 ) AND ( st.ticket_lock_id IN (2, 3) ) AND ( st.user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND st.ticket_state_id IN (6) AND st.until_time <= 1638171893 AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627511 16384 otobo <Other> <null> 49410 2021-11-29 08:45:10.026877 <null> 2021-11-29 08:46:16.746979 2021-11-29 08:46:16.75115 Client ClientRead idle <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 6 ) AND ( st.ticket_lock_id IN (2, 3) ) AND ( st.user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND st.ticket_state_id IN (6) AND st.until_time <= 1638171916 AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627387 16384 otobo <Other> <null> 49310 2021-11-29 08:44:55.718428 <null> 2021-11-29 08:46:21.652897 2021-11-29 08:46:21.740821 Client ClientRead idle <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 6 ) AND ( st.ticket_lock_id IN (2, 3) ) AND ( st.user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND st.ticket_state_id IN (6) AND st.until_time <= 1638171917 AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627492 16384 otobo <Other> <null> 49372 2021-11-29 08:45:07.652013 <null> 2021-11-29 08:46:21.967986 2021-11-29 08:46:21.982396 Client ClientRead idle <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 6 ) AND ( st.ticket_lock_id IN (2, 3) ) AND ( st.user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND st.ticket_state_id IN (6) AND st.until_time <= 1638171921 AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627500 16384 otobo <Other> <null> 49388 2021-11-29 08:45:08.47643 <null> 2021-11-29 08:46:29.585346 2021-11-29 08:46:29.586163 Client ClientRead idle <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 6 ) AND ( st.ticket_lock_id IN (2, 3) ) AND ( st.user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND st.ticket_state_id IN (6) AND st.until_time <= 1638171929 AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627508 16384 otobo <Other> <null> 49404 2021-11-29 08:45:09.797955 <null> 2021-11-29 08:46:30.516537 2021-11-29 08:46:30.583742 Client ClientRead idle <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 6 ) AND ( st.ticket_lock_id IN (2, 3) ) AND ( st.user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND st.ticket_state_id IN (6) AND st.until_time <= 1638171929 AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627525 16384 otobo <Other> <null> 49424 2021-11-29 08:45:10.98772 <null> 2021-11-29 08:46:29.533349 2021-11-29 08:46:29.534507 Client ClientRead idle <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 6 ) AND ( st.ticket_lock_id IN (2, 3) ) AND ( st.user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND st.ticket_state_id IN (6) AND st.until_time <= 1638171929 AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627505 16384 otobo <Other> <null> 49398 2021-11-29 08:45:09.706139 <null> 2021-11-29 08:46:36.142503 2021-11-29 08:46:36.314249 Client ClientRead idle <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN ticket_flag tf1 ON st.id = tf1.ticket_id INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 1, 4, 6 ) AND ( st.responsible_user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND tf1.ticket_key = ‘Seen’ AND tf1.ticket_value = ‘1’ AND tf1.create_by = 31 AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627512 16384 otobo <Other> <null> 49412 2021-11-29 08:45:10.099229 <null> 2021-11-29 08:46:30.888269 2021-11-29 08:46:30.905988 Client ClientRead idle <Other> <Other> SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN ticket_flag tf1 ON st.id = tf1.ticket_id INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( 1, 4, 6 ) AND ( st.responsible_user_id IN (31) ) AND sq.group_id IN (1,10,14,3,9) AND tf1.ticket_key = ‘Seen’ AND tf1.ticket_value = ‘1’ AND tf1.create_by = 31 AND archive_flag = 0 LIMIT 10000 client backend
16385 otobo 627607 16384 otobo <Other> <null> 49560 2021-11-29 08:45:35.743624 <null> 2021-11-29 08:46:03.627938 2021-11-29 08:46:03.669086 Client ClientRead idle <Other> <Other> /n SELECT id, data_key, data_value, serialized/n FROM sessions/n WHERE session_id = $1/n ORDER BY id ASC client backend
16385 otobo 627627 16384 otobo <Other> <null> 49588 2021-11-29 08:46:07.367581 2021-11-29 08:46:42.085679 2021-11-29 08:46:42.085679 2021-11-29 08:46:42.085694 <null> <null> active <Other> <Other> /n SELECT id, data_key, data_value, serialized/n FROM sessions/n WHERE session_id = $1/n ORDER BY id ASC client backend
16385 otobo 627602 16384 otobo <Other> <null> 49552 2021-11-29 08:45:33.718762 <null> 2021-11-29 08:46:30.811629 2021-11-29 08:46:30.853019 Client ClientRead idle <Other> <Other> /n SELECT id, data_key, data_value, serialized/n FROM sessions/n WHERE session_id = $1/n ORDER BY id ASC client backend
16385 otobo 627384 16384 otobo <Other> <null> 49306 2021-11-29 08:44:55.599732 <null> 2021-11-29 08:45:00.01245 2021-11-29 08:45:00.01707 Client ClientRead idle <Other> <Other> /n SELECT id, data_key, data_value, serialized/n FROM sessions/n WHERE session_id = $1/n ORDER BY id ASC client backend
16385 otobo 627389 16384 otobo <Other> <null> 49314 2021-11-29 08:44:55.751184 <null> 2021-11-29 08:45:00.110119 2021-11-29 08:45:00.110354 Client ClientRead idle <Other> <Other> /n SELECT id, data_key, data_value, serialized/n FROM sessions/n WHERE session_id = $1/n ORDER BY id ASC client backend
16385 otobo 627390 16384 otobo <Other> <null> 49316 2021-11-29 08:44:55.762582 <null> 2021-11-29 08:45:00.279291 2021-11-29 08:45:00.279502 Client ClientRead idle <Other> <Other> /n SELECT id, data_key, data_value, serialized/n FROM sessions/n WHERE session_id = $1/n ORDER BY id ASC client backend
16385 otobo 627385 16384 otobo <Other> <null> 49308 2021-11-29 08:44:55.625518 <null> 2021-11-29 08:45:00.070471 2021-11-29 08:45:00.071007 Client ClientRead idle <Other> <Other> /n SELECT id, data_key, data_value, serialized/n FROM sessions/n WHERE session_id = $1/n ORDER BY id ASC client backend
16385 otobo 627453 16384 otobo <Other> <null> 49322 2021-11-29 08:45:01.636765 <null> 2021-11-29 08:45:07.245485 2021-11-29 08:45:07.245717 Client ClientRead idle <Other> <Other> /n SELECT id, data_key, data_value, serialized/n FROM sessions/n WHERE session_id = $1/n ORDER BY id ASC client backend
16385 otobo 627462 16384 otobo <Other> <null> 49328 2021-11-29 08:45:01.883155 <null> 2021-11-29 08:45:07.496958 2021-11-29 08:45:07.49721 Client ClientRead idle <Other> <Other> /n SELECT id, data_key, data_value, serialized/n FROM sessions/n WHERE session_id = $1/n ORDER BY id ASC client backend

[Autor]

Beiträge