Alfonso,
I would use the C interface in slurmdb.h rather than directly accessing
the mysql backend.
Basically, because it is available, and has abstractions to deal with
the slurmdb model directly, rather than trying to reverse engineer the
database schema.
Also, depending on physical architecture, some people may not have a
mysql database deployed, for their accounting records. I believe their
are additional implementations of a plain text file and a PostgreSQL in
addition to mySQL....
Perhaps you want your tool to be portable, across other slurm
deployments / configurations? In which case having a dependency on the
Slurmdb C interface may be a better solution.
But if you want to deal with the mysql database backend directly, these
numbers in the mySQL database may map to this C enum in the slurmdb.h,
where the first entry is 0.
enum job_states {
JOB_PENDING, /* queued waiting for initiation */
JOB_RUNNING, /* allocated resources and executing */
JOB_SUSPENDED, /* allocated resources, execution suspended */
JOB_COMPLETE, /* completed execution successfully */
JOB_CANCELLED, /* cancelled by user */
JOB_FAILED, /* completed execution unsuccessfully */
JOB_TIMEOUT, /* terminated on reaching time limit */
JOB_NODE_FAIL, /* terminated on node failure */
JOB_PREEMPTED, /* terminated due to preemption */
JOB_END /* not a real state, last entry in table */
};
Of course you can double check by doing a:
/select state,id_job from cluster_job_table where state=0;/
/select state,id_job from cluster_job_table where state=1;
//select state,id_job from cluster_job_table where state=2;
....
//and then sacct -j id_job in the command line and it will translate a
job for you as a string to see the translation/
///
Andrew.
/On 11/12/12 15:36, Alfonso Pardo wrote:
Hello,
We are developing a graphical stadistics tool. For this tool we need
obtain the jobs states from Slurm data base (mysql).
Could you say me the description of the diferents numerical jobs status?
This is the numerical job status:
/mysql> select distinct state from cluster_job_table;/
/+-------+/
/| state |/
/+-------+/
/| 3 |/
/| 4 |/
/| 5 |/
/| 7 |/
/| 6 |/
/+-------+/
/Alfonso Pardo Díaz/
*/Researcher / System Administrator at CETA-Ciemat /*
/c/ Sola nº 1; 10200 Trujillo, ESPAÑA/
/Tel: +34 927 65 93 17 Fax: +34 927 32 32 37/
CETA-Ciemat logo <http://www.ceta-ciemat.es/>
---------------------------- Confidencialidad: Este mensaje y sus
ficheros adjuntos se dirige exclusivamente a su destinatario y puede
contener información privilegiada o confidencial. Si no es vd. el
destinatario indicado, queda notificado de que la utilización,
divulgación y/o copia sin autorización está prohibida en virtud de la
legislación vigente. Si ha recibido este mensaje por error, le rogamos
que nos lo comunique inmediatamente respondiendo al mensaje y proceda
a su destrucción. Disclaimer: This message and its attached files is
intended exclusively for its recipients and may contain confidential
information. If you received this e-mail in error you are hereby
notified that any dissemination, copy or disclosure of this
communication is strictly prohibited and may be unlawful. In this
case, please notify us by a reply and delete this email and its
contents immediately. ----------------------------
