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