My database is cleared at 00:00h

[Sergio Iserte]

Hello everyone,

I'm experiencing data loss everynight in my mysql database where slurm
writes its logs.
This is my slurmdbd.conf:

ArchiveEvents=yes

ArchiveJobs=yes
ArchiveSteps=no
ArchiveSuspend=no
AuthType=auth/munge
SlurmUser=slurm
DbdHost=virtualgap
DbdPort=6819
DebugLevel=1
PurgeEventAfter=1month
PurgeJobAfter=1month
PurgeStepAfter=1month
PurgeSuspendAfter=1month
StorageHost=virtualgap
StoragePort=3306
StoragePass=qwerty
StorageType=accounting_storage/mysql
StorageUser=slurm

Any idea about what's happenning?

Best regards,
Sergio.

[Gary Brown]

Your subject indicates data loss at midnight (00:00h) and your
configuration indicates purging events, jobs, steps, etc, after one month.
Is the data you are losing older than one month or are you losing
everything?

Gary

Post by Sergio Iserte
Hello everyone,
I'm experiencing data loss everynight in my mysql database where slurm
writes its logs.
ArchiveEvents=yes

ArchiveJobs=yes
ArchiveSteps=no
ArchiveSuspend=no
AuthType=auth/munge
SlurmUser=slurm
DbdHost=virtualgap
DbdPort=6819
DebugLevel=1
PurgeEventAfter=1month
PurgeJobAfter=1month
PurgeStepAfter=1month
PurgeSuspendAfter=1month
StorageHost=virtualgap
StoragePort=3306
StoragePass=qwerty
StorageType=accounting_storage/mysql
StorageUser=slurm

Any idea about what's happenning?
Best regards,
Sergio.
--
*Sergio Iserte Agut*
*Research Assistant*
*High Performance Computing & Architecture*
*Universitat Jaume I (Castelló de la Plana, Spain)*

[Sergio Iserte]

Hello,
sadly, I'm loosing everything, and I don't know why.

Thank you.

Post by Gary Brown
Your subject indicates data loss at midnight (00:00h) and your
configuration indicates purging events, jobs, steps, etc, after one month.
Is the data you are losing older than one month or are you losing
everything?
Gary

Post by Sergio Iserte
Hello everyone,
I'm experiencing data loss everynight in my mysql database where slurm
writes its logs.
ArchiveEvents=yes

ArchiveJobs=yes
ArchiveSteps=no
ArchiveSuspend=no
AuthType=auth/munge
SlurmUser=slurm
DbdHost=virtualgap
DbdPort=6819
DebugLevel=1
PurgeEventAfter=1month
PurgeJobAfter=1month
PurgeStepAfter=1month
PurgeSuspendAfter=1month
StorageHost=virtualgap
StoragePort=3306
StoragePass=qwerty
StorageType=accounting_storage/mysql
StorageUser=slurm

Any idea about what's happenning?
Best regards,
Sergio.
--
*Sergio Iserte Agut*
*Research Assistant*
*High Performance Computing & Architecture*
*Universitat Jaume I (Castelló de la Plana, Spain)*

[Sergio Iserte]

Hello,
nobody has any idea...

Thank you!

Post by Sergio Iserte
Hello,
sadly, I'm loosing everything, and I don't know why.
Thank you.

Post by Gary Brown
Your subject indicates data loss at midnight (00:00h) and your
configuration indicates purging events, jobs, steps, etc, after one month.
Is the data you are losing older than one month or are you losing
everything?
Gary

Post by Sergio Iserte
Hello everyone,
I'm experiencing data loss everynight in my mysql database where slurm
writes its logs.
ArchiveEvents=yes

ArchiveJobs=yes
ArchiveSteps=no
ArchiveSuspend=no
AuthType=auth/munge
SlurmUser=slurm
DbdHost=virtualgap
DbdPort=6819
DebugLevel=1
PurgeEventAfter=1month
PurgeJobAfter=1month
PurgeStepAfter=1month
PurgeSuspendAfter=1month
StorageHost=virtualgap
StoragePort=3306
StoragePass=qwerty
StorageType=accounting_storage/mysql
StorageUser=slurm

Any idea about what's happenning?
Best regards,
Sergio.
--
*Sergio Iserte Agut*
*Research Assistant*
*High Performance Computing & Architecture*
*Universitat Jaume I (Castelló de la Plana, Spain)*

--
*Sergio Iserte Agut*
*Research Assistant*
*High Performance Computing & Architecture*
*Universitat Jaume I (Castelló de la Plana, Spain)*

[Henkel, Dr. Andreas]

Hello Sergio,
do you have by any chance a cronjob running that cleans up some folders every night? Or is your system rebooted every night and your log file is located in /tmp?
Andreas

From: Sergio Iserte [mailto:***@uji.es]
Sent: Tuesday, October 7, 2014 9:49 AM
To: slurm-dev
Subject: [slurm-dev] Re: My database is cleared at 00:00h

Hello,
nobody has any idea...

Thank you!

2014-10-03 10:12 GMT+02:00 Sergio Iserte <***@uji.es<mailto:***@uji.es>>:
Hello,
sadly, I'm loosing everything, and I don't know why.

Thank you.

2014-10-01 22:45 GMT+02:00 Gary Brown <***@adaptivecomputing.com<mailto:***@adaptivecomputing.com>>:
Your subject indicates data loss at midnight (00:00h) and your configuration indicates purging events, jobs, steps, etc, after one month. Is the data you are losing older than one month or are you losing everything?

Gary


On Wed, Oct 1, 2014 at 4:52 AM, Sergio Iserte <***@uji.es<mailto:***@uji.es>> wrote:
Hello everyone,

I'm experiencing data loss everynight in my mysql database where slurm writes its logs.
This is my slurmdbd.conf:

ArchiveEvents=yes
ArchiveJobs=yes
ArchiveSteps=no
ArchiveSuspend=no

AuthType=auth/munge
SlurmUser=slurm
DbdHost=virtualgap
DbdPort=6819
DebugLevel=1
PurgeEventAfter=1month
PurgeJobAfter=1month
PurgeStepAfter=1month
PurgeSuspendAfter=1month

StorageHost=virtualgap
StoragePort=3306
StoragePass=qwerty
StorageType=accounting_storage/mysql
StorageUser=slurm

Any idea about what's happenning?

Best regards,
Sergio.
--
Sergio Iserte Agut
Research Assistant
High Performance Computing & Architecture
Universitat Jaume I (Castelló de la Plana, Spain)
--
Sergio Iserte Agut
Research Assistant
High Performance Computing & Architecture
Universitat Jaume I (Castelló de la Plana, Spain)

[Sergio Iserte]

Hello Andreas,
it very weird because there is nothing cleaning anything.
I don't know what to do...

Thank you!

Post by Henkel, Dr. Andreas
Hello Sergio,
do you have by any chance a cronjob running that cleans up some folders
every night? Or is your system rebooted every night and your log file is
located in /tmp?
Andreas
*Sent:* Tuesday, October 7, 2014 9:49 AM
*To:* slurm-dev
*Subject:* [slurm-dev] Re: My database is cleared at 00:00h
Hello,
nobody has any idea...
Thank you!
Hello,
sadly, I'm loosing everything, and I don't know why.
Thank you.
Your subject indicates data loss at midnight (00:00h) and your
configuration indicates purging events, jobs, steps, etc, after one month.
Is the data you are losing older than one month or are you losing
everything?
Gary
Hello everyone,
I'm experiencing data loss everynight in my mysql database where slurm writes its logs.
ArchiveEvents=yes
ArchiveJobs=yes
ArchiveSteps=no
ArchiveSuspend=no
AuthType=auth/munge
SlurmUser=slurm
DbdHost=virtualgap
DbdPort=6819
DebugLevel=1
PurgeEventAfter=1month
PurgeJobAfter=1month
PurgeStepAfter=1month
PurgeSuspendAfter=1month
StorageHost=virtualgap
StoragePort=3306
StoragePass=qwerty
StorageType=accounting_storage/mysql
StorageUser=slurm
Any idea about what's happenning?
Best regards,
Sergio.
--
*Sergio Iserte Agut*
*Research Assistant*
*High Performance Computing & Architecture*
*Universitat Jaume I (Castelló de la Plana, Spain)*
--
*Sergio Iserte Agut*
*Research Assistant*
*High Performance Computing & Architecture*
*Universitat Jaume I (Castelló de la Plana, Spain)*
--
*Sergio Iserte Agut*
*Research Assistant*
*High Performance Computing & Architecture*
*Universitat Jaume I (Castelló de la Plana, Spain)*