summaryrefslogtreecommitdiffstats
path: root/adei/check_adei.sh
diff options
context:
space:
mode:
authorSuren A. Chilingaryan <csa@suren.me>2019-12-11 21:14:03 +0100
committerSuren A. Chilingaryan <csa@suren.me>2019-12-11 21:14:03 +0100
commit2760dba480083977d179f095f47f28ec1913b9ec (patch)
tree569481702d6fa58845fc5e4c04f72993520f9492 /adei/check_adei.sh
parent2df6c231a41cae525f77a46e98ddf805f667ce5b (diff)
downloadconky-2760dba480083977d179f095f47f28ec1913b9ec.tar.gz
conky-2760dba480083977d179f095f47f28ec1913b9ec.tar.bz2
conky-2760dba480083977d179f095f47f28ec1913b9ec.tar.xz
conky-2760dba480083977d179f095f47f28ec1913b9ec.zip
Properly detect MySQL/slave desynchronization
Diffstat (limited to 'adei/check_adei.sh')
-rwxr-xr-xadei/check_adei.sh6
1 files changed, 3 insertions, 3 deletions
diff --git a/adei/check_adei.sh b/adei/check_adei.sh
index 58ce49c..06047b6 100755
--- a/adei/check_adei.sh
+++ b/adei/check_adei.sh
@@ -40,9 +40,9 @@ fi
# Verify offset (for selected database)
if [ -n "$adei10" -a $healthy -ne 0 -a -n "$adei_source" ]; then
now=$(date +%s)
- sdate="$(adei_text_query "getdata.php?db_mask=0&format=csv&window=-1&rt=1&cache=1&time_format=U&mysql=slave")"; err_slave=$?
+ sdate="$(adei_text_query "getdata.php?db_mask=0&format=csv&window=-1&rt=1&cache=1&time_format=U" slave)"; err_slave=$?
[ $err_slave -eq 0 ] && sdate="$(echo "$sdate" | cut -d ',' -f 1 | cut -d '.' -f 1)"
- mdate="$(adei_text_query "getdata.php?db_mask=0&format=csv&window=-1&rt=1&cache=1&time_format=U&mysql=master")"; err_master=$?
+ mdate="$(adei_text_query "getdata.php?db_mask=0&format=csv&window=-1&rt=1&cache=1&time_format=U" master)"; err_master=$?
[ $err_master -eq 0 ] && mdate="$(echo "$mdate" | cut -d ',' -f 1 | cut -d '.' -f 1)"
src="$adei_source"
@@ -62,7 +62,7 @@ if [ -n "$adei10" -a $healthy -ne 0 -a -n "$adei_source" ]; then
slave_offset=$(($mdate - $sdate))
if [ $master_offset -gt $MAX_SOURCE_OFFSET ]; then
- rdate=$(adei_text_query "getdata.php?db_mask=0&format=csv&window=-1&rt=1&time_format=U&mysql=master"); err=$?
+ rdate=$(adei_text_query "getdata.php?db_mask=0&format=csv&window=-1&rt=1&time_format=U" master); err=$?
if [ $err -eq 0 ]; then
rdate="$(echo "$rdate" | cut -d ',' -f 1 | cut -d '.' -f 1)"
cache_offset=$(($rdate - $mdate))