Page 2 of 3

Re: Afanasy Statistics

Posted: Tue Feb 04, 2020 7:53 pm
by timurhai
Also,
Job is pushed to DB on deletion.
Task on finish.

Re: Afanasy Statistics

Posted: Wed Feb 05, 2020 12:20 pm
by vdobrv
Hi
I do not understand what he wants from me

Re: Afanasy Statistics

Posted: Wed Feb 05, 2020 1:05 pm
by timurhai
Try to look at afserver logs. Is there any error inserting in DB tables?
Try to delete job(s). Only after job(s) deletion statistics is pushed.
To make web browser logs more readable, you should filter errors only and clear logs before F5 (to look at one session only).

Re: Afanasy Statistics

Posted: Tue Feb 11, 2020 1:52 pm
by vdobrv
Hi

I corrected PSQL
There was no postgresql@10-main.service in the auto start

But now something does not like Afonasy

Re: Afanasy Statistics

Posted: Tue Feb 11, 2020 2:39 pm
by vdobrv
It turns out that the database is running, there is a connection with it, errors on the side of the log are not poured on it, but afserver cannot write data

Re: Afanasy Statistics

Posted: Tue Feb 11, 2020 3:01 pm
by timurhai
May be afserver has not enough rights to write DB?
Try to google error that PostgreSQL module writes in afserver log.

Re: Afanasy Statistics

Posted: Wed Feb 12, 2020 1:38 pm
by vdobrv
And you can tell what is said in AfError?

Re: Afanasy Statistics

Posted: Wed Feb 12, 2020 1:44 pm
by timurhai
You can see it in 100% scale. I see just a screenshot, that was scaled down. I am not a PostgreSQL guru, i can`t explain this error details.

Re: Afanasy Statistics

Posted: Wed Feb 12, 2020 2:05 pm
by vdobrv
AFERROR: readdata: read: Resource temporarily unavailable
AFERROR: af::msgread: can`t read message header, bytes = -1 (< MSG::SizeHeader).

AFERROR: SQL command execution failed:
INSERT INTO jobs (annotation,blockname,capacity,desctiption,folder,jobname,hostmask,service,tasks_done,tasks_quantity,run_time_sum,time_done,time_started,username) VALUES (' ' ,$$max$$,100, '$D:\test$$,$$test.max$$,$$MY_PC$$,$$max$$,1,1,338,1581422655,1581422317,$$USER_NAME$$);

ERROR AfContainerIT::get() : node == NULL : id - 3

Re: Afanasy Statistics

Posted: Wed Feb 12, 2020 3:05 pm
by timurhai
I thought you was asking about PostgreSQL error: "FATAL: ...".

Afserver asked to launch that string to insert into table, but failed:

Code: Select all

AFERROR: SQL command execution failed:
INSERT INTO jobs (annotation,blockname,capacity,desctiption,folder,jobname,hostmask,service,tasks_done,tasks_quantity,run_time_sum,time_done,time_started,username) VALUES (' ' ,$$max$$,100, '$D:\test$$,$$test.max$$,$$MY_PC$$,$$max$$,1,1,338,1581422655,1581422317,$$USER_NAME$$);
PostgreSQL library rejected and outputs some FATAL message.

This are Afanasy client -> server connection errors:

Code: Select all

AFERROR: readdata: read: Resource temporarily unavailable
AFERROR: af::msgread: can`t read message header, bytes = -1 (< MSG::SizeHeader).
ERROR AfContainerIT::get() : node == NULL : id - 3