Stored Data Information

General discussions and questions.
Post Reply
baytree
Posts: 1
Joined: Fri Feb 10, 2017 6:32 am

Stored Data Information

Post by baytree »

Hi,

I have few questions about how AFANASY stores data in Database and how can we extract information for analysis -
  • Where does AFANASY store data of job submitted
  • How can we access the data and logs for analysis?
  • We need to find unique job ID and sub-job ID for each job submitted
  • We are planning to build a wrapper server around this so we can consolidate data like -
    1. Which user fire the render
    2. What is the render time taken by individual nodes and highlight problem nodes which are taking more time
    3. How many free and working nodes are there
    This are some of the early questions and would appreciate your guidance.

    Thanks in Advance.

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

Re: Stored Data Information

Post by timurhai »

Hi.

Afanasy serve stores state (current jobs, renders, users) in a local JSON files.
Default store folder location on linux is /var/tmp/afanasy.
Also it stores some data if deleted jobs in SQL database for statistics.
Job id is not unique, new job can take the same id as previously deleted job.
ID is unique only for current jobs on server.
Use job serial as an unique number for all the time.

Before each task start, afernder instance its service Python class (cgru/afanasy/python/services).
You can create some custom service and override its member function.
At the beginning, to test what data this class takes, you can simple print its arguments.

Free/working nodes you can see in a GUI window title.
Also you can use json protocol to get all renders info.
( examples: cgru/examples/json, aslo you can see gui logs for exchanging data format )
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
Post Reply