Select Git revision
supported_sections.yaml
-
root authored
1) Supported params list deleted, because it's hard to keep it fresh (there was cool parser by davidjb, but it does not take care of underscores and hiphen in options names). Now all parameters considering supported, and all hiphen will be replaced with underscore when salt creates my.cnf. Thats why all default parameters changed to underscore type. 2) Fixed bug with empty config append parameter 3) Fixed bug with empty root password applying
root authored1) Supported params list deleted, because it's hard to keep it fresh (there was cool parser by davidjb, but it does not take care of underscores and hiphen in options names). Now all parameters considering supported, and all hiphen will be replaced with underscore when salt creates my.cnf. Thats why all default parameters changed to underscore type. 2) Fixed bug with empty config append parameter 3) Fixed bug with empty root password applying
monitor_hshinfo 639 B
#!/bin/bash
REMAINING_LIBRARY_IDS=$(sudo -u postgres -- psql -qtAX -d hshinfo -c "select (maximum_value::bigint - (SELECT last_value FROM hshinfo.seq_raw_library_id)) from information_schema.sequences where sequence_schema = 'hshinfo' and sequence_name = 'seq_raw_library_id';")
REMAINING_LUH_IDS=$(sudo -u postgres -- psql -qtAX -d hshinfo -c "select count(*) from hshinfo.username_luh where allocated = false;")
echo "P watch_lib_ids remaining_library_ids=$REMAINING_LIBRARY_IDS;2000:;500: hshinfo.seq_raw_library_ids"
echo "P watch_luh_ids remaining_luh_ids=$REMAINING_LUH_IDS;2000:;500: hshinfo.usernames_luh with allocated = false"