Description of problem: SQL query failed during tiering rebalancer and write/read frequency thresolds not work Version-Release number of selected component (if applicable): How reproducible: gluster volume <volumename > tier rebalancer [2015-03-27 17:25:42.078335] E [gfdb_sqlite3.c:864:gf_sqlite3_find_recently_changed_files_freq] 0-sqlite3: Failed preparing statment select GF_FILE_TB.GF_ID, (select group_concat( GF_PID || ',' || FNAME || ',' || FPATH || ',' || W_DEL_FLAG ||',' || LINK_UPDATE , '::') from GF_FLINK_TB where GF_FILE_TB.GF_ID = GF_FLINK_TB.GF_ID) from GF_FILE_TB where ( ((GF_FILE_TB.W_SEC * 1000000 + GF_FILE_TB.W_MSEC) >= ? ) AND (GF_FILE_TB.WRITE_FREQ_CNTR > = ? ) ) OR ( ((GF_FILE_TB.W_READ_SEC * 1000000 + GF_FILE_TB.W_READ_MSEC) <= ?) AND (GF_FILE_TB.READ_FREQ_CNTR > = ? ) ) : near "=": syntax error gluster volume set cluster.write-freq-threshold 0; failed! gluster volume set cluster.read-freq-threshold 0; failed! Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
REVIEW: http://review.gluster.org/10050 (Gfdb Query Fix and Volume option fix) posted (#2) for review on master by Joseph Fernandes (josferna)
COMMIT: http://review.gluster.org/10050 committed in master by Niels de Vos (ndevos) ------ commit 3feaf1648528ff39e23748ac9004a77595460c9d Author: Joseph Fernandes <josferna> Date: Mon Mar 30 17:23:29 2015 +0530 Gfdb Query Fix and Volume option fix 1) Query fix in find_changed_with_freq() 2) Volume option typo fix for write_freq_threshold and read_freq_threshold Change-Id: I38e154818178aab412b2d7b2914cd29acef66ffb BUG: 1207343 Signed-off-by: Joseph Fernandes <josferna> Reviewed-on: http://review.gluster.org/10050 Reviewed-by: Dan Lambright <dlambrig> Tested-by: Gluster Build System <jenkins.com> Reviewed-by: Niels de Vos <ndevos>
This bug is getting closed because a release has been made available that should address the reported issue. In case the problem is still not fixed with glusterfs-3.7.0, please open a new bug report. glusterfs-3.7.0 has been announced on the Gluster mailinglists [1], packages for several distributions should become available in the near future. Keep an eye on the Gluster Users mailinglist [2] and the update infrastructure for your distribution. [1] http://thread.gmane.org/gmane.comp.file-systems.gluster.devel/10939 [2] http://thread.gmane.org/gmane.comp.file-systems.gluster.user