Afanasy Statistics

Installation and configuration.
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Afanasy Statistics

Post by timurhai »

Also,
Job is pushed to DB on deletion.
Task on finish.
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
vdobrv
Posts: 18
Joined: Thu May 03, 2018 2:28 pm

Re: Afanasy Statistics

Post by vdobrv »

Hi
I do not understand what he wants from me
Attachments
Annotation 2020-02-05 151700.jpg
Annotation 2020-02-05 151700.jpg (142.94 KiB) Viewed 57576 times
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Afanasy Statistics

Post 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).
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
vdobrv
Posts: 18
Joined: Thu May 03, 2018 2:28 pm

Re: Afanasy Statistics

Post by vdobrv »

Hi

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

But now something does not like Afonasy
Attachments
Annotation 2020-02-11 1638191.jpg
Annotation 2020-02-11 1638191.jpg (97.75 KiB) Viewed 57524 times
Annotation 2020-02-11 163819.jpg
Annotation 2020-02-11 163819.jpg (149.91 KiB) Viewed 57524 times
vdobrv
Posts: 18
Joined: Thu May 03, 2018 2:28 pm

Re: Afanasy Statistics

Post 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
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Afanasy Statistics

Post by timurhai »

May be afserver has not enough rights to write DB?
Try to google error that PostgreSQL module writes in afserver log.
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
vdobrv
Posts: 18
Joined: Thu May 03, 2018 2:28 pm

Re: Afanasy Statistics

Post by vdobrv »

And you can tell what is said in AfError?
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Afanasy Statistics

Post 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.
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
vdobrv
Posts: 18
Joined: Thu May 03, 2018 2:28 pm

Re: Afanasy Statistics

Post 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
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Afanasy Statistics

Post 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
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
Post Reply