postgres@myhost:~$ psql -U myuser -h 127.0.0.1 mydb -W < mydb-26Mar2026.sql Password: SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET CREATE SCHEMA ALTER SCHEMA CREATE SCHEMA ALTER SCHEMA CREATE SCHEMA ALTER SCHEMA CREATE SCHEMA ALTER SCHEMA CREATE SCHEMA ALTER SCHEMA CREATE EXTENSION COMMENT CREATE EXTENSION COMMENT CREATE SCHEMA ALTER SCHEMA CREATE SCHEMA ALTER SCHEMA CREATE SCHEMA ALTER SCHEMA CREATE SCHEMA ALTER SCHEMA CREATE SCHEMA ALTER SCHEMA CREATE EXTENSION COMMENT CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE CREATE TYPE ALTER TYPE SET CREATE TABLE ALTER TABLE CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION SET CREATE TABLE ALTER TABLE CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER SEQUENCE ALTER SEQUENCE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 2 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 2 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 6 COPY 0 COPY 2 COPY 900 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 77 COPY 0 COPY 0 COPY 0 COPY 0 COPY 5 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 5 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 0 COPY 4 COPY 2 COPY 0 COPY 0 COPY 0 COPY 0 COPY 4 COPY 2 COPY 0 COPY 0 COPY 0 COPY 0 COPY 4 COPY 3 COPY 1 setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 3201 (1 row) setval -------- 1 (1 row) setval -------- 1618 (1 row) setval -------- 1 (1 row) setval -------- 1618 (1 row) setval -------- 1 (1 row) setval -------- 1618 (1 row) setval -------- 1 (1 row) setval -------- 1618 (1 row) setval -------- 1 (1 row) setval -------- 1618 (1 row) setval -------- 1 (1 row) setval -------- 1618 (1 row) setval -------- 30 (1 row) setval -------- 81 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 16 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 33 (1 row) setval -------- 41 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 33 (1 row) setval -------- 41 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER INDEX ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT REVOKE GRANT GRANT GRANT GRANT GRANT GRANT postgres@myhost:~$ postgres@myhost:~$ postgres@myhost:~$ postgres@myhost:~$ exit logout root@myhost:~# systemctl start pgqd root@myhost:~# systemctl status pgqd ● pgqd.service - PgQ maintenance daemon Loaded: loaded (/lib/systemd/system/pgqd.service; enabled; preset: enabled) Active: active (running) since Thu 2026-03-26 13:41:30 UTC; 5s ago Main PID: 1069548 (pgqd) Tasks: 1 (limit: 2262) Memory: 1.8M CPU: 47ms CGroup: /system.slice/pgqd.service └─1069548 /usr/bin/pgqd /etc/pgqd.ini Mar 26 13:41:30 myhost.mydomain.net pgqd[1069548]: Starting pgqd 3.5 Mar 26 13:41:30 myhost.mydomain.net pgqd[1069548]: 2026-03-26 13:41:30.798 UTC [1069548] LOG [mydb]: pgq version ok: 3.5> Mar 26 13:41:30 myhost.mydomain.net pgqd[1069548]: [mydb]: pgq version ok: 3.5.1 Mar 26 13:41:30 myhost.mydomain.net pgqd[1069548]: 2026-03-26 13:41:30.802 UTC [1069548] ERROR mydb: ERROR: Invalid PgQ> Mar 26 13:41:30 myhost.mydomain.net pgqd[1069548]: CONTEXT: PL/pgSQL function pgq.ticker(text) line 54 at RAISE Mar 26 13:41:30 myhost.mydomain.net pgqd[1069548]: PL/pgSQL function pgq.ticker() line 21 at IF Mar 26 13:41:30 myhost.mydomain.net pgqd[1069548]: mydb: ERROR: Invalid PgQ state: old xmin=5182508, old xmax=5182508, > CONTEXT: PL/pgSQL function pgq.ticker(text) line 54 at RAISE PL/pgSQL function pgq.ticker() line 21 at IF Mar 26 13:41:30 myhost.mydomain.net pgqd[1069548]: 2026-03-26 13:41:30.843 UTC [1069548] ERROR mydb: ERROR: queue async> Mar 26 13:41:30 myhost.mydomain.net pgqd[1069548]: CONTEXT: PL/pgSQL function pgq.maint_rotate_tables_step1(text) > Mar 26 13:41:30 myhost.mydomain.net pgqd[1069548]: mydb: ERROR: queue async_cdr_statistics maint failure: step1=5180399> CONTEXT: PL/pgSQL function pgq.maint_rotate_tables_step1(text) > root@myhost:~# root@myhost:~# root@myhost:~# root@myhost:~# root@myhost:~# root@myhost:~# root@myhost:~# root@myhost:~# tail -200 /var/log/syslog 2026-03-26T13:41:30.756139+00:00 myhost systemd[1]: Started pgqd.service - PgQ maintenance daemon. 2026-03-26T13:41:30.765123+00:00 myhost pgqd[1069548]: 2026-03-26 13:41:30.764 UTC [1069548] LOG Starting pgqd 3.5 2026-03-26T13:41:30.765373+00:00 myhost pgqd[1069548]: Starting pgqd 3.5 2026-03-26T13:41:30.798612+00:00 myhost pgqd[1069548]: 2026-03-26 13:41:30.798 UTC [1069548] LOG [mydb]: pgq version ok: 3.5.1 2026-03-26T13:41:30.798817+00:00 myhost pgqd[1069548]: [mydb]: pgq version ok: 3.5.1 2026-03-26T13:41:30.802522+00:00 myhost pgqd[1069548]: 2026-03-26 13:41:30.802 UTC [1069548] ERROR mydb: ERROR: Invalid PgQ state: old xmin=5182508, old xmax=5182508, cur txid=118288 2026-03-26T13:41:30.802628+00:00 myhost pgqd[1069548]: #011CONTEXT: PL/pgSQL function pgq.ticker(text) line 54 at RAISE 2026-03-26T13:41:30.802663+00:00 myhost pgqd[1069548]: #011PL/pgSQL function pgq.ticker() line 21 at IF 2026-03-26T13:41:30.802792+00:00 myhost pgqd[1069548]: mydb: ERROR: Invalid PgQ state: old xmin=5182508, old xmax=5182508, cur txid=118288#012#011CONTEXT: PL/pgSQL function pgq.ticker(text) line 54 at RAISE#012#011PL/pgSQL function pgq.ticker() line 21 at IF 2026-03-26T13:41:30.844045+00:00 myhost pgqd[1069548]: 2026-03-26 13:41:30.843 UTC [1069548] ERROR mydb: ERROR: queue async_cdr_statistics maint failure: step1=5180399, current=118289 2026-03-26T13:41:30.844142+00:00 myhost pgqd[1069548]: #011CONTEXT: PL/pgSQL function pgq.maint_rotate_tables_step1(text) line 34 at RAISE 2026-03-26T13:41:30.844193+00:00 myhost pgqd[1069548]: mydb: ERROR: queue async_cdr_statistics maint failure: step1=5180399, current=118289#012#011CONTEXT: PL/pgSQL function pgq.maint_rotate_tables_step1(text) line 34 at RAISE 2026-03-26T13:41:40.836900+00:00 myhost pgqd[1069548]: 2026-03-26 13:41:40.836 UTC [1069548] LOG [mydb]: pgq version ok: 3.5.1 2026-03-26T13:41:40.837120+00:00 myhost pgqd[1069548]: [mydb]: pgq version ok: 3.5.1 2026-03-26T13:41:40.840096+00:00 myhost pgqd[1069548]: 2026-03-26 13:41:40.840 UTC [1069548] ERROR mydb: ERROR: Invalid PgQ state: old xmin=5182508, old xmax=5182508, cur txid=118290 2026-03-26T13:41:40.840163+00:00 myhost pgqd[1069548]: #011CONTEXT: PL/pgSQL function pgq.ticker(text) line 54 at RAISE 2026-03-26T13:41:40.840189+00:00 myhost pgqd[1069548]: #011PL/pgSQL function pgq.ticker() line 21 at IF 2026-03-26T13:41:40.840224+00:00 myhost pgqd[1069548]: mydb: ERROR: Invalid PgQ state: old xmin=5182508, old xmax=5182508, cur txid=118290#012#011CONTEXT: PL/pgSQL function pgq.ticker(text) line 54 at RAISE#012#011PL/pgSQL function pgq.ticker() line 21 at IF 2026-03-26T13:41:50.891528+00:00 myhost pgqd[1069548]: 2026-03-26 13:41:50.891 UTC [1069548] LOG [mydb]: pgq version ok: 3.5.1 2026-03-26T13:41:50.891644+00:00 myhost pgqd[1069548]: [mydb]: pgq version ok: 3.5.1 2026-03-26T13:41:50.894511+00:00 myhost pgqd[1069548]: 2026-03-26 13:41:50.892 UTC [1069548] ERROR mydb: ERROR: queue async_cdr_statistics maint failure: step1=5180399, current=118291 2026-03-26T13:41:50.894583+00:00 myhost pgqd[1069548]: #011CONTEXT: PL/pgSQL function pgq.maint_rotate_tables_step1(text) line 34 at RAISE 2026-03-26T13:41:50.894620+00:00 myhost pgqd[1069548]: mydb: ERROR: queue async_cdr_statistics maint failure: step1=5180399, current=118291#012#011CONTEXT: PL/pgSQL function pgq.maint_rotate_tables_step1(text) line 34 at RAISE 2026-03-26T13:41:50.894955+00:00 myhost pgqd[1069548]: 2026-03-26 13:41:50.894 UTC [1069548] ERROR mydb: ERROR: Invalid PgQ state: old xmin=5182508, old xmax=5182508, cur txid=118292 2026-03-26T13:41:50.895011+00:00 myhost pgqd[1069548]: #011CONTEXT: PL/pgSQL function pgq.ticker(text) line 54 at RAISE 2026-03-26T13:41:50.895034+00:00 myhost pgqd[1069548]: #011PL/pgSQL function pgq.ticker() line 21 at IF 2026-03-26T13:41:50.895065+00:00 myhost pgqd[1069548]: mydb: ERROR: Invalid PgQ state: old xmin=5182508, old xmax=5182508, cur txid=118292#012#011CONTEXT: PL/pgSQL function pgq.ticker(text) line 54 at RAISE#012#011PL/pgSQL function pgq.ticker() line 21 at IF 2026-03-26T13:42:00.178551+00:00 myhost pgbouncer[50966]: stats: 0 xacts/s, 0 queries/s, 0 client parses/s, 0 server parses/s, 0 binds/s, in 0 B/s, out 0 B/s, xact 0 us, query 0 us, wait 0 us 2026-03-26T13:42:00.777356+00:00 myhost pgqd[1069548]: 2026-03-26 13:42:00.776 UTC [1069548] LOG {ticks: 0, maint: 0, retry: 0} 2026-03-26T13:42:00.777549+00:00 myhost pgqd[1069548]: {ticks: 0, maint: 0, retry: 0} 2026-03-26T13:42:00.921206+00:00 myhost pgqd[1069548]: 2026-03-26 13:42:00.921 UTC [1069548] LOG [mydb]: pgq version ok: 3.5.1 2026-03-26T13:42:00.921336+00:00 myhost pgqd[1069548]: [mydb]: pgq version ok: 3.5.1 2026-03-26T13:42:00.924364+00:00 myhost pgqd[1069548]: 2026-03-26 13:42:00.924 UTC [1069548] ERROR mydb: ERROR: Invalid PgQ state: old xmin=5182508, old xmax=5182508, cur txid=118293 2026-03-26T13:42:00.924471+00:00 myhost pgqd[1069548]: #011CONTEXT: PL/pgSQL function pgq.ticker(text) line 54 at RAISE 2026-03-26T13:42:00.924499+00:00 myhost pgqd[1069548]: #011PL/pgSQL function pgq.ticker() line 21 at IF 2026-03-26T13:42:00.924551+00:00 myhost pgqd[1069548]: mydb: ERROR: Invalid PgQ state: old xmin=5182508, old xmax=5182508, cur txid=118293#012#011CONTEXT: PL/pgSQL function pgq.ticker(text) line 54 at RAISE#012#011PL/pgSQL function pgq.ticker() line 21 at IF root@myhost:~#