Dans mon cas, j'ai trouvé exactement l'origine de mon problème d'hibernation .
Context
J'ai une application personnelle ( batch) qui envoie des journaux ( IETF ) au serveur syslog tous les jours à 00h00.
Analyse
J'ai remarqué une anomalie dans les journaux du serveur syslog dans le fichier /var/log/syslog.log
Nov 18 19:48:02 DiskStation syslog-ng[30955]: Error establishing SQL connection; type='sqlite3', host='', port='', username='syslog-ng', database='/volume1/homes/admin/log/${HOST}/SYNOSYSLOGDB_${HOST}.DB', error='-3: libdbi could not establish a connection'
Nov 18 19:48:02 DiskStation syslog-ng[30955]: Error running SQL query; type='sqlite3', host='', port='', user='syslog-ng', database='/volume1/homes/admin/log/${HOST}/SYNOSYSLOGDB_${HOST}.DB', error='-3: libdbi could not establish a connection', query='CREATE TABLE logs (id integer primary key, host text default NULL, ip text default NULL, fac text default NULL, prio text default NULL, llevel text default NULL, tag text default NULL, utcsec int default NULL, r_utcsec int default NULL, tzoffset text default NULL, ldate date default CURRENT_DATE, ltime time default CURRENT_TIME, prog text default NULL, msg text default NULL)'
Nov 18 19:48:02 DiskStation syslog-ng[30955]: Error creating table, giving up; table='logs'
Nov 18 19:48:02 DiskStation syslog-ng[30955]: Error checking table, disconnecting from database, trying again shortly; time_reopen='10'
Nov 18 19:48:02 DiskStation syslog-ng[30955]: g_string_free: assertion 'string != NULL' failed
Nov 18 19:48:02 DiskStation syslog-ng[30955]: Error, no SQL connection after failed query attempt; type='sqlite3', host='', port='', username='syslog-ng', database='/volume1/homes/admin/log/${HOST}/SYNOSYSLOGDB_${HOST}.DB', error='-3: libdbi could not establish a connection'
Nov 18 19:48:12 DiskStation syslog-ng[30955]: Error establishing SQL connection; type='sqlite3', host='', port='', username='syslog-ng', database='/volume1/homes/admin/log/${HOST}/SYNOSYSLOGDB_${HOST}.DB', error='-3: libdbi could not establish a connection'
Nov 18 19:48:12 DiskStation syslog-ng[30955]: Error running SQL query; type='sqlite3', host='', port='', user='syslog-ng', database='/volume1/homes/admin/log/${HOST}/SYNOSYSLOGDB_${HOST}.DB', error='-3: libdbi could not establish a connection', query='CREATE TABLE logs (id integer primary key, host text default NULL, ip text default NULL, fac text default NULL, prio text default NULL, llevel text default NULL, tag text default NULL, utcsec int default NULL, r_utcsec int default NULL, tzoffset text default NULL, ldate date default CURRENT_DATE, ltime time default CURRENT_TIME, prog text default NULL, msg text default NULL)'
Nov 18 19:48:12 DiskStation syslog-ng[30955]: Error creating table, giving up; table='logs'
Nov 18 19:48:12 DiskStation syslog-ng[30955]: Error checking table, disconnecting from database, trying again shortly; time_reopen='10'
Nov 18 19:48:12 DiskStation syslog-ng[30955]: g_string_free: assertion 'string != NULL' failed
Nov 18 19:48:12 DiskStation syslog-ng[30955]: Error, no SQL connection after failed query attempt; type='sqlite3', host='', port='', username='syslog-ng', database='/volume1/homes/admin/log/${HOST}/SYNOSYSLOGDB_${HOST}.DB', error='-3: libdbi could not establish a connection'
Nov 18 19:48:22 DiskStation syslog-ng[30955]: Error establishing SQL connection; type='sqlite3', host='', port='', username='syslog-ng', database='/volume1/homes/admin/log/${HOST}/SYNOSYSLOGDB_${HOST}.DB', error='-3: libdbi could not establish a connection'
Nov 18 19:48:22 DiskStation syslog-ng[30955]: Error running SQL query; type='sqlite3', host='', port='', user='syslog-ng', database='/volume1/homes/admin/log/${HOST}/SYNOSYSLOGDB_${HOST}.DB', error='-3: libdbi could not establish a connection', query='CREATE TABLE logs (id integer primary key, host text default NULL, ip text default NULL, fac text default NULL, prio text default NULL, llevel text default NULL, tag text default NULL, utcsec int default NULL, r_utcsec int default NULL, tzoffset text default NULL, ldate date default CURRENT_DATE, ltime time default CURRENT_TIME, prog text default NULL, msg text default NULL)'
Nov 18 19:48:22 DiskStation syslog-ng[30955]: Error creating table, giving up; table='logs'
Nov 18 19:48:22 DiskStation syslog-ng[30955]: Error checking table, disconnecting from database, trying again shortly; time_reopen='10'
Nov 18 19:48:22 DiskStation syslog-ng[30955]: g_string_free: assertion 'string != NULL' failed
Nov 18 19:48:22 DiskStation syslog-ng[30955]: Error, no SQL connection after failed query attempt; type='sqlite3', host='', port='', username='syslog-ng', database='/volume1/homes/admin/log/${HOST}/SYNOSYSLOGDB_${HOST}.DB', error='-3: libdbi could not establish a connection'
Dès que mon batch tente d'envoyer les journaux au serveur syslog , syslog toutes les dix secondes essaye d'accéder à un fichier qui n'existe pas dans une boucle infinie qui empêche mon NAS pour entrer en hibernation .
Voici la configuration qui génère le problème :
Solution temporaire :
J'ai soumis ce problème à synology.