[Bugs] [Bug 1540376] Tiered volume performance degrades badly after a volume stop /start or system restart.

[bugzilla at redhat.com]

https://bugzilla.redhat.com/show_bug.cgi?id=1540376



--- Comment #2 from Jeff Byers <jbyers at stonefly.com> ---
The problem was simple, the sqlite3 DB connection parameters
were only being set on a newly created DB, not when there was
an existing DB. Apparently the sqlite3 DB default parameters
are not ideal.

diff -up glusterfs-3.7.18/libglusterfs/src/gfdb/gfdb_sqlite3.c-orig
glusterfs-3.7.18/libglusterfs/src/gfdb/gfdb_sqlite3.c
--- glusterfs-3.7.18/libglusterfs/src/gfdb/gfdb_sqlite3.c-orig  2018-02-01
13:14:19.000000000 -0800
+++ glusterfs-3.7.18/libglusterfs/src/gfdb/gfdb_sqlite3.c   2018-02-01
13:31:24.000000000 -0800
@@ -449,9 +449,11 @@ gf_sqlite3_init (dict_t *args, void **db

-        /* If the file exist we skip the config part
-         * and creation of the schema */
-        if (is_dbfile_exist)
-                goto db_exists;
-

         /*Apply sqlite3 params to database*/
         ret = apply_sql_params_db (sql_conn, args);
@@ -462,6 +464,12 @@ gf_sqlite3_init (dict_t *args, void **db
                 goto out;
         }

+        /* If the file exist we skip the config part
+         * and creation of the schema */
+        if (is_dbfile_exist)
+               goto db_exists;
+
         /*Create the schema if NOT present*/
         ret = create_filetable (sql_conn->sqlite3_db_conn);
         if (ret) {

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are on the CC list for the bug.
You are the assignee for the bug.