# Query Cache Error on boot **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [January 10, 2014, 6:46am UTC](https://forums.percona.com/t/query-cache-error-on-boot/3194 "2014-01-10T06:46:26Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Slithers](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@Slithers](https://forums.percona.com/u/Slithers)\ **Post date:** [January 10, 2014, 6:46am UTC](https://forums.percona.com/t/query-cache-error-on-boot/3194/1 "2014-01-10T06:46:26Z")
Hi Just in the process of attempting an upgrade from percona 5.5.35 server to percona cluster 5.5.34 and it keeps failing on boot. I’m just creating a single node at the moment, with the view of creating 2nd nodes once initial cluster is running. I’m running the init script to start the server and i get the following error in the error log: 140110 11:34:16 mysqld\_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140110 11:43:36 mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql 140110 11:43:36 mysqld\_safe Skipping wsrep-recover for empty datadir: /var/lib/mysql 140110 11:43:36 mysqld\_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep\_start\_position 140110 11:43:36 [ERROR] WSREP: Query cache is not supported (size=16777216 type=0) 140110 11:43:36 [ERROR] Aborting I’ve got the following config in my.cnf: [mysqld] basedir=/usr/local/mysql datadir=/usr/localmysql/data pid-file=/var/run/mysqld/myqsqld.pid log-error=/var/log/mysql/mysqld.err plugin-load=thread\_pool.so thread\_pool\_size=32 innodb\_buffer\_pool\_size=216G innodb\_log\_file\_size=512M innodb\_log\_buffer\_size=16M innodb\_flush\_log\_at\_trx\_commit=2 innodb\_flush\_method=O\_DIRECT innodb\_file\_per\_table transaction-isolation=READ-COMMITTED #Added for cluster #innodb\_data\_home\_dir=/usr/local/mysql/data #innodb\_log\_group\_home\_dir=/usr/local/mysql/data max\_connections=500 log-bin=mysql.bin #Changed from MIXED for cluster binlog-format=ROW server-id=1 #ignore-builtin-innodb #plugin-load=innodb=ha\_innodb\_plugin.so default-storage-engine=InnoDB thread\_cache\_size=24 tmp\_table\_size=32M max\_heap\_table\_size=32M #slow\_query\_log\_file=/storage/logs/mysql/slow-query/sql1.log #slow\_query\_log=1 long\_query\_time=3 #log-slow-admin-statements #log-queries-not-using-indexes expire\_logs\_days=7 net\_read\_timeout=5000 net\_write\_timeout=5000 max\_allowed\_packet=128M group\_concat\_max\_len=32M binlog\_cache\_size=1M table\_open\_cache=4096 table\_definition\_cache=4096 join\_buffer\_size=1M innodb\_lock\_wait\_timeout=700 skip-name-resolve #query\_cache\_size=0 bind\_address=0.0.0.0 thread\_cache\_size=50 #Cluster Variables wsrep\_provider=/usr/local/mysql/lib/libgalera\_smm.so wsrep\_cluster\_address=gcomm:// innodb\_locks\_unsafe\_for\_binlog=1 innodb\_autoinc\_lock\_mode=2 wsrep\_node\_address=192.168.4.101 wsrep\_sst\_method=xtrabackup wsrep\_cluster\_name=test\_cluster wsrep\_sst\_auth=“sstuser:\*\*\*\*\*\*\*\*\*\*\*” As you can see form conf i’ve tried commenting out existing query cache size. From the error its almost like elements of my conf are being skipped as its trying to pick up the data dir from /var/lib/mysql (tried creating this dir and simlinking it over) to correct datadir path but to no avail. I’ve tried adding the basedir and datadir paths directly to mysqld\_safe and /etc/init.d.mysql.server but this doesn’t work either. I’m positive i’ve got a conf issue here but i’m a bit stumped as to exactly what i need to do to rectify it. Thanks in advance Matt Smith ---
**Author:** ![madhusudan](https://avatars.discourse-cdn.com/v4/letter/m/76d3ee/32.png) [@madhusudan](https://forums.percona.com/u/madhusudan)\ **Post date:** [January 10, 2014, 7:36am UTC](https://forums.percona.com/t/query-cache-error-on-boot/3194/2 "2014-01-10T07:36:22Z")
[COLOR=#252C2F]Query Cache is not supported with wsrep, use below in u r my.cnf file. and start again query\_cache\_size=0 query\_cache\_type=0 ---
**Author:** ![Slithers](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@Slithers](https://forums.percona.com/u/Slithers)\ **Post date:** [January 10, 2014, 8:29am UTC](https://forums.percona.com/t/query-cache-error-on-boot/3194/3 "2014-01-10T08:29:53Z")
I’m a idiot, i found a legacy .cnf file in /etc/mysql/ and it looks like cluster was picking that up :o Copied my conf from /etc/ into that file and it started fine. Many many apologies but thanks for the great response madhusudan!, i’m sure i would have needed that bit anyway 😃 ---
**Author:** ![madhusudan](https://avatars.discourse-cdn.com/v4/letter/m/76d3ee/32.png) [@madhusudan](https://forums.percona.com/u/madhusudan)\ **Post date:** [January 13, 2014, 12:08am UTC](https://forums.percona.com/t/query-cache-error-on-boot/3194/4 "2014-01-13T00:08:00Z")
your welcome… :-), u dont have to blame u r self. it happens sometimes… 🙂