Thread: pga_schedule_jscmonthdays_size error
I'm getting a weird error when trying to schedule a job in pgAgent
[2024-04-22 11:23:17] [23514] ERROR: new row for relation "pga_schedule" violates check constraint "pga_schedule_jscmonthdays_size"
[2024-04-22 11:23:17] Detail: Failing row contains (29, 26, schedule1, , t, 2024-04-21 18:43:00+00, null, {f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f..., {t,f,f,f,f,f,f,f,f,f,f,f,t,f,f,f,f,f,f,f,f,f,f,f}, {t,t,t,t,t,t,t}, {f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}, {f,f,f,f,f,f,f,f,f,f,f,f}).
[2024-04-22 11:23:17] Detail: Failing row contains (29, 26, schedule1, , t, 2024-04-21 18:43:00+00, null, {f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f..., {t,f,f,f,f,f,f,f,f,f,f,f,t,f,f,f,f,f,f,f,f,f,f,f}, {t,t,t,t,t,t,t}, {f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}, {f,f,f,f,f,f,f,f,f,f,f,f}).
I have the latest pgAgent schema, and using pgAdmin 8.5; Postgres is v13 and running on Ubuntu.
The check it's failing on is: check (array_upper(jscmonthdays, 1) = 32); SQL Insert has only 31 entries and was generated in pgAdmin.
Thanks!
CONFIDENTIALITY NOTE
This electronic message contains privileged information intended only for the use of the individual or entity named above. If the reader of this electronic message is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any forwarding, storing, printing, dissemination or copying of this electronic message is strictly prohibited and may be unlawful. If received in error, please do not disclose the contents to anyone, but notify the sender by return email and delete this email (and any attachments) from your system.
Thank you.
Hi Tek,
This issue is reported and team is working on it - https://github.com/pgadmin-org/pgadmin4/issues/7390
On Mon, Apr 22, 2024 at 9:46 PM Tek Wojenski <twojenski@orca1di.com> wrote:
I'm getting a weird error when trying to schedule a job in pgAgent[2024-04-22 11:23:17] [23514] ERROR: new row for relation "pga_schedule" violates check constraint "pga_schedule_jscmonthdays_size"
[2024-04-22 11:23:17] Detail: Failing row contains (29, 26, schedule1, , t, 2024-04-21 18:43:00+00, null, {f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f..., {t,f,f,f,f,f,f,f,f,f,f,f,t,f,f,f,f,f,f,f,f,f,f,f}, {t,t,t,t,t,t,t}, {f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}, {f,f,f,f,f,f,f,f,f,f,f,f}).I have the latest pgAgent schema, and using pgAdmin 8.5; Postgres is v13 and running on Ubuntu.The check it's failing on is: check (array_upper(jscmonthdays, 1) = 32); SQL Insert has only 31 entries and was generated in pgAdmin.Thanks!
CONFIDENTIALITY NOTE
This electronic message contains privileged information intended only for the use of the individual or entity named above. If the reader of this electronic message is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any forwarding, storing, printing, dissemination or copying of this electronic message is strictly prohibited and may be unlawful. If received in error, please do not disclose the contents to anyone, but notify the sender by return email and delete this email (and any attachments) from your system.Thank you.
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"