]]>
]]>

You are here

Feed aggregator

Which vision is to merge art and poetr

Lastest Forum Posts - December 16, 2014 - 9:00am
http://www.invisionpower.ro/topic/49...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/

Backup fails with InnoDB: Operating system error number 0

Lastest Forum Posts - December 16, 2014 - 3:19am
Hi,

I was just trying to take hot backup with innobackupex but I get a read error whilst innobackupex is trying to scan the logfiles - strangely though the failure is an Error 0 which is reported as a success:

: xtrabackup_55 version 1.6.3 for Percona Server 5.5.9 Linux (x86_64) (revision id: undefined) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: Target instance is assumed as followings. xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 5242880 141216 10:59:08 InnoDB: Using Linux native AIO 141216 10:59:08 InnoDB: Warning: allocated tablespace 53, old maximum was 9 >> log scanned up to (1221137553871) [01] Copying ./ibdata1 to /home/nick/2014-12-16_10-59-04/ibdata1 >> log scanned up to (1221137615178) >> log scanned up to (1221137624351) >> log scanned up to (1221137650292) InnoDB: Error: tried to read 1048576 bytes at offset 0 534773760. InnoDB: Was only able to read 40960. 141216 11:00:15 InnoDB: Operating system error number 0 in a file operation. InnoDB: Error number 0 means 'Success'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html InnoDB: File operation call: 'read'. InnoDB: Cannot continue operation. innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 336. Can anyone shed any light on what causes this? MySQL is using this Inno DB normally without any apparent errors, and starts up and shuts down normally when required, so I was assuming that the integrity of the data files + logs was ok, but perhaps not? Is this a known issue with xtrabackup? Is there a workaround or some way to get more information on this issue?

Thanks,

Nick

Recovering / Restoring a single database with Xtrabackup

Lastest Forum Posts - December 15, 2014 - 11:23pm
Hi ,

Is it possible to recovery / restore a single database using xtrabackup ?

Thanks & Regards
Raghupradeep

Recovering / Restoring a single database with Xtrabackup

Lastest Forum Posts - December 15, 2014 - 11:18pm
Hi ,

Is it possible to recovery / restore a single database using xtrabackup ?

Thanks & Regards
Raghupradeep

Can not build cluster

Lastest Forum Posts - December 15, 2014 - 10:49am
Hi
I have two nodes on Ubuntu 12.04 Server 64 bit

When i bootstrap first node, in error log i can see

[Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory)

but it is start

When i start second node

I can see that errors in log
[Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory)
[Warning] WSREP: (5b571936, 'tcp://0.0.0.0:4567') address 'tcp://10.1.1.13:4567' points to own listening address, blacklisting
[Warning] WSREP: Gap in state sequence. Need state transfer.
[Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (2f13e6f3-845d-11e4-a92a-1353578a748d): 1 (Operation not permitted)
[Warning] WSREP: 1.0 (xtradb1): State transfer to 0.0 (xtradb2) failed: -22 (Invalid argument)
[ERROR] WSREP: gcs/src/gcs_group.cpp:int gcs_group_handle_join_msg(gcs_group_t*, const gcs_recv_msg_t*)():722: Will never receive state. Need to abort.
[ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '10.1.1.13' --auth 'sstuser:s3cretPass' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '20901' '' : 1 (Operation not permitted)
[ERROR] WSREP: Failed to read uuid:seqno from joiner script.
[ERROR] WSREP: SST failed: 1 (Operation not permitted)
[ERROR] Aborting




Percona Xtradb Cluster version is 5.6.21-25.8-938.precise on two nodes

Config on first node
skip-name-resolve

explicit_defaults_for_timestamp=TRUE
wsrep_provider=/usr/lib/libgalera_smm.so
wsrep_provider_options = 'socket.checksum = 1;'
#wsrep_cluster_address=gcomm://10.1.1.12,10.1.1.13
wsrep_cluster_address=gcomm://
wsrep_slave_threads = 96
binlog_format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_node_address=10.1.1.12
wsrep_node_name=xtradb1
wsrep_sst_method=xtrabackup-v2
wsrep_cluster_name=stalker_db_cluster
wsrep_sst_auth="sstuser:s3cretPass"




Config on second node

skip-name-resolve

explicit_defaults_for_timestamp=TRUE
wsrep_provider=/usr/lib/libgalera_smm.so
wsrep_provider_options = 'socket.checksum = 1;'
wsrep_cluster_address=gcomm://10.1.1.12,10.1.1.13
#wsrep_cluster_address=gcomm://
wsrep_slave_threads = 96
binlog_format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_node_address=10.1.1.13
wsrep_node_name=xtradb2
wsrep_sst_method=xtrabackup-v2
wsrep_cluster_name=stalker_db_cluster
wsrep_sst_auth="sstuser:s3cretPass"




What is WRONG ?

I alredy have 3 working well clusters on previos version of percona cluster ?
What is wrong with new one ?

Can someone help ?

Strange behaviour on partitioned table (Percona Server 5.5.36)

Lastest Forum Posts - December 15, 2014 - 5:34am
This one's really got me. Maybe it's a bug. Ideas anyone? See below...

We have a table with the following partition scheme (example names and values):

: PARTITION BY LIST COLUMNS(`owner`) SUBPARTITION BY HASH(CASE WHEN (`foo`+`bar`) < 1 THEN 0 ELSE 1 END) SUBPARTITIONS 2 ( PARTITION p0 VALUES IN('A','B','C','D','E','F','G'), PARTITION p1 VALUES IN('H'), PARTITION p2 VALUES IN('I','J'), PARTITION p3 VALUES IN('K') ); N.B. the A,B,C, etc. values above are only examples. The real table has strings that represent the owner of the row. There are over 3m rows.

We should end up with a partition that has all the foo+bar = 0 values owned by A through G as the first subpartition of partition p0.

We get the following output from SELECT owner,COUNT(*) FROM maintable GROUP BY owner;:

: +----------+----------+ | owner | COUNT(*) | +----------+----------+ | H | 2077675 | | B | 138243 | | I | 13333 | | C | 26507 | | A | 806889 | | K | 134 | | E | 38165 | | D | 14118 | +----------+----------+ There are no values for F, G or J.

Now when I run SELECT COUNT(*) FROM maintable WHERE owner = 'A';, I get zero.

If I change the list to IN('A','B','C','D','E','F','G') then I get the expected result. If I omit G, I get the correct result. If I omit F and G from the list, it goes back to zero. Whaaaaat?

I've tested this on 5.6 on another server with a subset of the data, and it is fine, with the additional feature of selecting directly from p0, etc.

Anyone ever seen anything like this? Am I missing something? Let me know if you want to know any variables.

--
Sam

MySQL Tutorials: A time to learn at Percona Live 2015

Latest MySQL Performance Blog posts - December 15, 2014 - 12:00am

The many hours of intensive tutorials, led by some of the top minds in MySQL, have always been a major draw each year to the Percona Live MySQL Conference and Expo. And 2015’s event will be no exception.

Percona Live 2015 runs April 13-16 in Santa Clara, Calif. and the first day is dedicated to the classroom – so bring your laptops for the combined 45 hours of learning. MySQL tutorials are included with the full-conference pass but a “tutorial-only pass” is also available. Super-saver registration discounts have been extended until Dec. 19. Here’s a look at this year’s tutorials lineup. (There will be a couple more announced in January).

And that’s just on Monday! There will be much more over the four days of the Percona Live MySQL Conference and Expo 2015. Percona conference director Kortney Runyan shared a sneak peek at the full schedule a few days ago. And remember, super-saver registration discounts have been extended until Dec. 19 so register now – and don’t forgot your laptop (and power cord)!

The post MySQL Tutorials: A time to learn at Percona Live 2015 appeared first on MySQL Performance Blog.

Can't join second node (rsync)

Lastest Forum Posts - December 14, 2014 - 6:33pm
After bootstrapping nodeA, nodeB fails to start because it can't SST
Using rsync
Tried 5.6.21 and reverted to 5.6.20 with dsame result

2014-12-14 21:41:40 9277 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 1)
2014-12-14 21:41:40 9277 [Note] WSREP: State transfer required:
Group state: cc13f472-83fa-11e4-8ea3-138a7ef719a7:1
Local state: 00000000-0000-0000-0000-000000000000:-1
2014-12-14 21:41:40 9277 [Note] WSREP: New cluster view: global state: cc13f472-83fa-11e4-8ea3-138a7ef719a7:1, view# 4: Primary, number of nodes: 2, my index: 1, protocol version 3
2014-12-14 21:41:40 9277 [Warning] WSREP: Gap in state sequence. Need state transfer.
2014-12-14 21:41:40 9277 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '10.10.1.62' --auth '' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '9277' '' '
2014-12-14 21:41:40 9277 [Note] WSREP: Prepared SST request: rsync|10.10.1.62:4444/rsync_sst
2014-12-14 21:41:40 9277 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2014-12-14 21:41:40 9277 [Note] WSREP: REPL Protocols: 6 (3, 2)
2014-12-14 21:41:40 9277 [Note] WSREP: Service thread queue flushed.
2014-12-14 21:41:40 9277 [Note] WSREP: Assign initial position for certification: 1, protocol version: 3
2014-12-14 21:41:40 9277 [Note] WSREP: Service thread queue flushed.
2014-12-14 21:41:40 9277 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (cc13f472-83fa-11e4-8ea3-138a7ef719a7): 1 (Operation not permitted)
at galera/src/replicator_str.cpprepare_for_IST():456. IST will be unavailable.
2014-12-14 21:41:40 9277 [Note] WSREP: Member 1.0 (nodeB) requested state transfer from '*any*'. Selected 0.0 (nodeA)(SYNCED) as donor.
2014-12-14 21:41:40 9277 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 1)
2014-12-14 21:41:40 9277 [Note] WSREP: Requesting state transfer: success, donor: 0
2014-12-14 21:41:40 9277 [Warning] WSREP: 0.0 (nodeA): State transfer to 1.0 (nodeB) failed: -255 (Unknown error 255)
2014-12-14 21:41:40 9277 [ERROR] WSREP: gcs/src/gcs_group.cpp:int gcs_group_handle_join_msg(gcs_group_t*, const gcs_recv_msg_t*)():722: Will never receive state. Need to abort.
2014-12-14 21:41:40 9277 [Note] WSREP: gcomm: terminating thread
2014-12-14 21:41:40 9277 [Note] WSREP: gcomm: joining thread
2014-12-14 21:41:40 9277 [Note] WSREP: gcomm: closing backend
2014-12-14 21:41:41 9277 [Note] WSREP: view(view_id(NON_PRIM,dcb11fa5,4) memb {
e50b4be3,0
} joined {
} left {
} partitioned {
dcb11fa5,0
})
2014-12-14 21:41:41 9277 [Note] WSREP: view((empty))
2014-12-14 21:41:41 9277 [Note] WSREP: gcomm: closed
2014-12-14 21:41:41 9277 [Note] WSREP: /usr/sbin/mysqld: Terminated.
141214 21:41:41 mysqld_safe mysqld from pid file /var/lib/mysql/mysqlb.pid ended
WSREP_SST: [ERROR] Parent mysqld process (PID:9277) terminated unexpectedly. (20141214 21:41:42.237)
WSREP_SST: [INFO] Joiner cleanup. (20141214 21:41:42.239)
WSREP_SST: [INFO] Joiner cleanup done. (20141214 21:41:42.746)

2006 MySQL server has gone away

Lastest Forum Posts - December 14, 2014 - 1:53pm
Hi,
In the last couple of weeks we have been experiencing a 2006 MySQL server has gone away error intermittently on our servers, to allow connections again we run "FLUSH TABLES". (we have this running on a cron to maintain stability at the moment)

We have upgraded to from MySQL 5.6.5 to MySQL 5.6.22 and switched now to Percona 5.6.21-70.

Server Mac Mini Core i7 16GB RAM 512GB Enterprise SSD.


ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 16384
pipe size (512 bytes, -p) 1
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 512
virtual memory (kbytes, -v) unlimited

uptime
8:45 up 1 day, 15:55, 2 users, load averages: 0.49 0.32 0.31

NB - This config has been tinkered with by many people over the years - My hunch is the problem lays within here...
This is used in MM Replication environment.











Cluster dos not synchronized

Lastest Forum Posts - December 14, 2014 - 9:44am
Hi
I have two nodes with version 5.6.21-25.8-938.precise

| wsrep_local_state | 4 |
| wsrep_local_state_comment | Synced |
| wsrep_cert_index_size | 91 |
| wsrep_causal_reads | 0 |
| wsrep_cert_interval | 0.000022 |
| wsrep_incoming_addresses | 10.1.1.12:3306,10.1.1.13:3306 |
| wsrep_evs_delayed | |
| wsrep_evs_evict_list | |
| wsrep_evs_repl_latency | 0/0/0/0/0 |
| wsrep_evs_state | OPERATIONAL |
| wsrep_gcomm_uuid | 87ae0011-83ab-11e4-9fc0-d65c844c8cea |
| wsrep_cluster_conf_id | 30 |
| wsrep_cluster_size | 2 |
| wsrep_cluster_state_uuid | 1abb2b3e-82ff-11e4-824a-a24ee1e11d16 |
| wsrep_cluster_status | Primary |
| wsrep_connected | ON |
| wsrep_local_bf_aborts | 0 |
| wsrep_local_index | 0 |
| wsrep_provider_name | Galera |
| wsrep_provider_vendor | Codership Oy <info@codership.com> |
| wsrep_provider_version | 3.8(rf6147dd) |
| wsrep_ready | ON |



clustercheck says

clustercheck root pass
HTTP/1.1 200 OK
Content-Type: text/plain
Connection: close
Content-Length: 40

Percona XtraDB Cluster Node is synced.



But second node dos not have one table in database

and in error log i see

2014-12-14 18:35:44 53445 [Warning] InnoDB: Cannot open table test_db/all_cities from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/...eshooting.html for how you can resolve the problem.


also that
[Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory)


from config:

explicit_defaults_for_timestamp=TRUE
wsrep_provider=/usr/lib/libgalera_smm.so
#wsrep_provider_options = 'pc.ignore_sb = true'
#wsrep_provider_options = 'socket.checksum = 1;'
wsrep_cluster_address=gcomm://10.1.1.12,10.1.1.13
#wsrep_cluster_address=gcomm://
wsrep_slave_threads = 128
binlog_format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_node_address=10.1.1.12
wsrep_node_name=xtradb1
wsrep_sst_method=xtrabackup-v2
wsrep_cluster_name=test_db_cluster
wsrep_sst_auth="sstuser:s3cretPass"




I have now working well other cluster with 10 nodes
There is version 5.6.20-25.7-886.precise

What is different betwen new version and previos ?
Something changed in config ?

How can i install previos worked version ?

Thank you

Which vision is to merge art and poetr

Lastest Forum Posts - December 14, 2014 - 7:39am
http://www.rup.co.il/wnthdprntthe-le...tch-li-ne-720p
http://www.rup.co.il/wnthdprnthawaii...tch-li-ne-720p
http://www.rup.co.il/wnthdprntblue-b...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-x-...tch-li-ne-720p
http://www.rup.co.il/wnthdprntcasual...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-ul...tch-li-ne-720p
http://www.rup.co.il/wnthdprntsaturd...tch-li-ne-720p
http://www.rup.co.il/wnthdprntone-pi...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-x-...tch-li-ne-720p
http://www.rup.co.il/wnthdprntbobs-b...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-li...tch-li-ne-720p
http://www.rup.co.il/wnthdprntonce-u...tch-li-ne-720p
http://www.rup.co.il/wnthdprntbrookl...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-ne...tch-li-ne-720p
http://www.rup.co.il/wnthdprnthomela...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-me...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-af...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-co...tch-li-ne-720p
http://www.rup.co.il/wnthdprntlost-g...tch-li-ne-720p
http://www.rup.co.il/wnthdprntcsi-se...tch-li-ne-720p
http://www.rup.co.il/wnthdprntgettin...tch-li-ne-720p
http://www.rup.co.il/wnthdprnt4-oclo...tch-li-ne-720p
http://www.rup.co.il/wnthdprnthollyo...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-bo...tch-li-ne-720p
http://www.rup.co.il/wnthdprntgenera...tch-li-ne-720p
http://www.rup.co.il/wnthdprnteasten...tch-li-ne-720p
http://www.rup.co.il/wnthdprntcorona...tch-li-ne-720p
http://www.rup.co.il/wnthdprntcorona...tch-li-ne-720p
http://www.rup.co.il/wnthdprntsome-g...tch-li-ne-720p
http://www.rup.co.il/wnthdprntnever-...tch-li-ne-720p

http://www.rup.co.il/wnthdprntno-goo...tch-li-ne-720p
http://www.rup.co.il/wnthdprntpengui...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-th...tch-li-ne-720p
http://www.rup.co.il/wnthdprntbirdman-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntget-sa...tch-li-ne-720p
http://www.rup.co.il/wnthdprntblack-...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-py...tch-li-ne-720p
http://www.rup.co.il/wnthdprntst-vin...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-gr...tch-li-ne-720p
http://www.rup.co.il/wnthdprntaction...tch-li-ne-720p
http://www.rup.co.il/wnthdprntmea-cu...tch-li-ne-720p
http://www.rup.co.il/wnthdprntopen-b...tch-li-ne-720p
http://www.rup.co.il/wnthdprntwild-2...tch-li-ne-720p
http://www.rup.co.il/wnthdprntzero-m...tch-li-ne-720p
http://www.rup.co.il/wnthdprntpioneer-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntcomet-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntlife-p...tch-li-ne-720p
http://www.rup.co.il/wnthdprntshes-b...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-hu...tch-li-ne-720p
http://www.rup.co.il/wnthdprntimitat...tch-li-ne-720p
http://www.rup.co.il/wnthdprntnativi...tch-li-ne-720p
http://www.rup.co.il/wnthdprnt2001-s...tch-li-ne-720p
http://www.rup.co.il/wnthdprnthorrib...tch-li-ne-720p
http://www.rup.co.il/wnthdprnti-am-a...tch-li-ne-720p
http://www.rup.co.il/wnthdprntpaddin...tch-li-ne-720p
http://www.rup.co.il/wnthdprntfrozen-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntfoxcat...tch-li-ne-720p
http://www.rup.co.il/wnthdprntdumb-a...tch-li-ne-720p
http://www.rup.co.il/wnthdprntinters...tch-li-ne-720p
http://www.rup.co.il/wnthdprntbig-he...tch-li-ne-720p
http://www.rup.co.il/wnthdprntjessab...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-be...tch-li-ne-720p
http://www.rup.co.il/wnthdprntnation...tch-li-ne-720p
http://www.rup.co.il/wnthdprntnightc...tch-li-ne-720p
http://www.rup.co.il/wnthdprntouija-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntjohn-w...tch-li-ne-720p
http://www.rup.co.il/wnthdprntfury-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-be...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-bo...tch-li-ne-720p
http://www.rup.co.il/wnthdprntdracul...tch-li-ne-720p
http://www.rup.co.il/wnthdprntgone-g...tch-li-ne-720p
http://www.rup.co.il/wnthdprntno-goo...h-li-ne-720p-0

Not possible for JOINER TO join the Cluster

Lastest Forum Posts - December 12, 2014 - 9:30am
Folks, how are you all? I need some help here, the story is as follows...

Some time ago I implemented a XtraDB Cluster using the packages on version 5.6.20-68.0-56-log. This cluster's version has four nodes and it's in production, running very well with no problems at all. I've got another one running version 5.5.39 with the same configuration files on all the four nodes and no problems to implement the cluster (considering out some variables presented below for 5.6).

On both scenarios, the setup sequence was the same: to get the Percona Repository installed on CentOS 6.5 machines, install the Percona-XtraDB-Cluster-56 and xtrabackup as well (just for a double check).

[wb@textenv-node01 ~]$ sudo yum -y install Percona-XtraDB-Cluster-56 percona-xtrabackup
[wb@textenv-node02 ~]$ sudo yum -y install Percona-XtraDB-Cluster-56 percona-xtrabackup
[wb@textenv-node03 ~]$ sudo yum -y install Percona-XtraDB-Cluster-56 percona-xtrabackup

Configuration files were created with the following basic configs:

#
#: arquivo configuração, nó # 1
#
[mysqld]
user=mysql
server_id=1
datadir=/var/lib/mysql
log_bin=node01-bin
binlog_format=ROW
log_slave_updates=true
enforce_gtid_consistency=true
default_storage_engine=innodb
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_log_group_home_dir=/var/lib/mysql
innodb_log_files_in_group=2
innodb_log_file_size=2G
#: wsrep variables
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_name=mycluster
wsrep_node_address=192.168.0.101
wsrep_node_name=node01
wsrep_cluster_address=gcomm://192.168.0.101:4567,192.168.0.102:4567,192.168.0.10 3:4567, 192.168.0.104:4567
wsrep_slave_threads=2
wsrep_sst_method=xtrabackup
wsrep_sst_auth=sst:123

#
#: arquivo configuração, nó # 2
#
[mysqld]
user=mysql
server_id=2
datadir=/var/lib/mysql
log_bin=node02-bin
binlog_format=ROW
log_slave_updates=true
enforce_gtid_consistency=true
default_storage_engine=innodb
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_log_group_home_dir=/var/lib/mysql
innodb_log_files_in_group=2
innodb_log_file_size=2G
#: wsrep variables
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_name=mycluster
wsrep_node_address=192.168.0.102
wsrep_node_name=node02
wsrep_cluster_address=gcomm://192.168.0.101:4567,192.168.0.102:4567,192.168.0.10 3:4567, 192.168.0.104:4567
wsrep_slave_threads=2
wsrep_sst_method=xtrabackup
wsrep_sst_auth=sst:123

#
#: arquivo configuração, nó # 3
#
[mysqld]
user=mysql
server_id=3
datadir=/var/lib/mysql
log_bin=node03-bin
binlog_format=ROW
default_storage_engine=innodb
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_log_group_home_dir=/var/lib/mysql
innodb_log_files_in_group=2
innodb_log_file_size=2G
#: wsrep variables
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_name=mycluster
wsrep_node_address=192.168.0.103
wsrep_node_name=node03
wsrep_cluster_address=gcomm://192.168.0.101:4567,192.168.0.102:4567,192.168.0.10 3:4567, 192.168.0.104:4567
wsrep_slave_threads=2
wsrep_sst_method=xtrabackup
wsrep_sst_auth=sst:123

#
#: arquivo de configuração, nó # 4
#
[mysqld]
user=mysql
datadir=/var/lib/mysql
server_id=4
log_bin=node04-bin
binlog_format=ROW
log_slave_updates
default_storage_engine=innodb
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_log_group_home_dir=/var/lib/mysql
innodb_log_files_in_group=2
innodb_log_file_size=2G
#: wsrep variables
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.0.101:4567,192.168.0.102:4567,192.168.0.10 3:4567, 192.168.0.104:4567
wsrep_cluster_name=mycluster
wsrep_node_name=node04
wsrep_node_address=192.168.0.104
wsrep_sst_method=xtrabackup
wsrep_sst_auth=sst:123

The cluster is running as I said...

[root@node01 ~]$ mysql -u root -pxxxxxxx -e "show status like 'wsrep_cluster_size'"
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| wsrep_cluster_size | 4 |
+--------------------+-------+

So, with those configuration files, I started a new project, but now to test the version Ver 5.6.21-70.1-56. I simple copied all the configuration I have currently running very well as showed previously. The new version I'm testing is:

[root@testenv-node01 ~]$ mysqld --version
mysqld Ver 5.6.21-70.1-56 for Linux on x86_64 (Percona XtraDB Cluster (GPL), Release rel70.1, Revision 938, WSREP version 25.8, wsrep_25.8.r4150)

The bootstrap was OK, but the second node is not joining the cluster even having the SST completing with an OK message at the end (gotten from the innobackup.backup.log).

[root@testenv-node01 ~]$ sudo tail -f /var/lib/mysql/innobackup.backup.log
xtrabackup: Transaction log of lsn (1627264) to (1627264) was copied.
141212 16:48:55 innobackupex: Executing UNLOCK BINLOG
141212 16:48:55 innobackupex: Executing UNLOCK TABLES
141212 16:48:55 innobackupex: All tables unlocked

innobackupex: Backup created in directory '/tmp'
innobackupex: MySQL binlog position: filename 'node01-bin.000002', position 120
141212 16:48:55 innobackupex: Connection to database server closed
innobackupex: You must use -i (--ignore-zeros) option for extraction of the tar stream.
141212 16:48:55 innobackupex: completed OK!

The mysql error log on the second node says that the SST completed with errors:

2014-12-12 16:49:47 5698 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (d4022a87-820a-11e4-bcf4-5793c1c5841f): 1 (Operation not permitted)
at galera/src/replicator_str.cpprepare_for_IST():456. IST will be unavailable.
2014-12-12 16:49:47 5698 [Note] WSREP: Member 1.0 (node02) requested state transfer from '*any*'. Selected 0.0 (node01)(SYNCED) as donor.
2014-12-12 16:49:47 5698 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 5)
2014-12-12 16:49:47 5698 [Note] WSREP: Requesting state transfer: success, donor: 0
2014-12-12 16:49:47 5698 [Note] WSREP: (dff2f8f7, 'tcp://0.0.0.0:4567') turning message relay requesting off
2014-12-12 16:49:57 5698 [Note] WSREP: 0.0 (node01): State transfer to 1.0 (node02) complete.
WSREP_SST: [ERROR] xtrabackup process ended without creating '/var/lib/mysql//xtrabackup_galera_info' (20141212 16:49:57.174)
[...]
WSREP_SST: [ERROR] Cleanup after exit with status:32 (20141212 16:49:57.297)
WSREP_SST: [INFO] Removing the sst_in_progress file (20141212 16:49:57.326)
2014-12-12 16:49:57 5698 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address '192.168.0.102' --auth 'sst:123' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '5698' '' : 32 (Broken pipe)
2014-12-12 16:49:57 5698 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.
2014-12-12 16:49:57 5698 [ERROR] WSREP: SST failed: 32 (Broken pipe)
2014-12-12 16:49:57 5698 [ERROR] Aborting

Just to get you guys aware, I've got the user sst with 123 as its password well created on MySQL:

[root@testenv-node01 ~]$ mysql -u root -e "show grants for sst@localhost\G"
*************************** 1. row ***************************
Grants for sst@localhost: GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sst'@'localhost' IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257'

Trying to test manually the xtrabackup command as per the documentation to check if it's doing the right thing, I've got the following:

[root@textenv-node01 ~]$ innobackupex --user=sst --password=123 /tmp/

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

141212 17:17:36 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'sst' (using password: YES).
141212 17:17:36 innobackupex: Connected to MySQL server
141212 17:17:36 innobackupex: Executing a version check against the server...
Can't use an undefined value as an ARRAY reference at /usr/bin/innobackupex line 1069.

The Xtrabackup packages I've got installed on these new machines:

[root@testenv-node01 ~]$ xtrabackup --version
xtrabackup version 2.2.7 based on MySQL server 5.6.21 Linux (x86_64) (revision id: )

Any lights in here? Any advice?

How to contribute a patch

Lastest Forum Posts - December 12, 2014 - 9:10am
Where are the notes telling me the steps/requirements for contributing a bug-fix patch?

I have tracked down a bug to the API C lib that impacts (perl, python, ...) API users relying on the secure_auth param.
I have a one-line patch which I've successfully tested. I've downloaded the 5.6 source via bzr.

The easiest thing would be for me to upload the patch to github and then reference that in my bug report. But I'm sure there are more comprehensive steps I could follow.

thanks,
Nic

Percona Monitoring Plugins - missing in CentOS 7 repo

Lastest Forum Posts - December 12, 2014 - 4:28am
Hi,

The "Percona Monitoring Plugins" are missing from the CentOS 7 repo.
[I've had puppet complaining about this after I changed a server to CentOS 7]

Is there a timeline?
As far as it goes I've installed the packages from CentOS 6 repo and are working just fine!

Regards!

Repo down?

Lastest Forum Posts - December 12, 2014 - 12:00am
Failed to fetch http://repo.percona.com/apt/pool/mai...cise_amd64.deb Could not connect to repo.percona.com:80 (162.220.4.217). - connect (111: Connection refused)

I have had problems reaching the repo the last couple of days, is it a known problem?

Do I need to install xtrabackup on a remote machine as well ?

Lastest Forum Posts - December 10, 2014 - 7:12pm
Hello ,

I have taken a backup using xtrabackup and want to restore it on a remote MySQL server. I have copied backup files on a remote server.
Now how Can I get MySQL using backup files data an running?
Do I need to install xtrabackup on remote server as well ?

Do I need to install xtrabackup on a remote machine as well ?

Lastest Forum Posts - December 10, 2014 - 7:05pm
Hello ,

I have taken a backup using xtrabackup and want to restore it on a remote MySQL server. I have copied backup files on a remote server.
Now how Can I get MySQL using backup files data an running?
Do I need to install xtrabackup on remote server as well ?

Percona XtraBackup 2.2.7 is now available

Latest MySQL Performance Blog posts - December 10, 2014 - 7:03am

Percona is glad to announce the release of Percona XtraBackup 2.2.7 on December 10, 2014. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups.

Bugs Fixed:

  • Non-default value for innodb_log_block_size variable would cause assertion when preparing the backup. Bug fixed #1391216.
  • When Percona XtraBackup would run FLUSH ENGINE LOGS during the backup process on GTID master, command was recorded to the slave’s binary log as well, which lead to inconsistency between master and slave. Fixed by adding the NO_WRITE_TO_BINLOG clause to FLUSH ENGINE LOGS to avoid interfering with binary log and inconsistency with coordinates. Bug fixed #1394632.
  • Exporting tables was inefficient when backup contained a large (and unrelated) change buffer. Bug fixed #1366065 (Davi Arnaut).
  • innobackupex was printing the GTID even if the GTID mode was disabled which could cause confusion since it wasn’t incrementing. Now it prints only GTID when GITD mode is enabled and when GTID mode is disabled it prints only filename and position. innobackupex still prints GTID, filename and positions if MariaDB server is being backed up. Bug fixed #1391041.

Other bugs fixed: bug #1386157.

Release notes with all the bugfixes for Percona XtraBackup 2.2.7 are available in our online documentation. Bugs can be reported on the launchpad bug tracker. Percona XtraBackup is an open source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases.

The post Percona XtraBackup 2.2.7 is now available appeared first on MySQL Performance Blog.

drop, recreate and restore individual innodb tables leads to corruption

Lastest Forum Posts - December 10, 2014 - 1:37am
Hi,

I do full streaming backups with innobackupex, piped to bzip2 innobackupex --galera-info --stream=tar $dump_to/tmp |bzip2. I also dump each table structure with mysqldump --opt -d $db_table

To transfer periodically some tables on another test server, i uncompress, run innobackupex --apply-log --export.
Then, on a live Percona cluster (only one node), i import my mysqldump which drops and recreates each table with the same structure it had on original server, then do ALTER TABLE $table DISCARD TABLESPACE;, copy the $table.{ibd,exp} files from the backup (as stated from documentation), and issue a ALTER TABLE $table IMPORT TABLESPACE;.

The resulting MySQL starts and stays alive, but after a few queries from our application, it crashes. I can restart it well, but once after few other queries, it crashes again, with these kind of messages.

The source database is not corrupted, the backup is fine because when i try to restore it fully with innobackupex --copy-back, the resulting MySQL works well.

What am i doing wrong ? Do i also need to copy the .frm and .cfg files ?

: (...) 2014-12-06 21:19:22 8806 [Note] WSREP: Member 0 (node1) synced with group. 2014-12-06 21:19:22 8806 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 66213) 2014-12-06 21:19:22 8806 [Note] WSREP: New cluster view: global state: 5fc1d69f-7be8-11e4-80cb-8278baded779:66213, view# 1: Primary , number of nodes: 1, my index: 0, protocol version 2 2014-12-06 21:19:22 8806 [Note] WSREP: SST complete, seqno: 66213 2014-12-06 21:19:22 8806 [Note] Plugin 'FEDERATED' is disabled. 2014-12-06 21:19:22 8806 [Note] InnoDB: The InnoDB memory heap is disabled 2014-12-06 21:19:22 8806 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-12-06 21:19:22 8806 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-12-06 21:19:22 8806 [Note] InnoDB: Using Linux native AIO 2014-12-06 21:19:22 8806 [Note] InnoDB: Using CPU crc32 instructions 2014-12-06 21:19:22 8806 [Note] InnoDB: Initializing buffer pool, size = 512.0M 2014-12-06 21:19:22 8806 [Note] InnoDB: Completed initialization of buffer pool 2014-12-06 21:19:22 8806 [Note] InnoDB: Highest supported file format is Barracuda. 2014-12-06 21:19:22 8806 [Note] InnoDB: 128 rollback segment(s) are active. 2014-12-06 21:19:22 8806 [Note] InnoDB: Waiting for purge to start 2014-12-06 21:19:22 8806 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.15-rel63.0 started; log sequence number 674654 14284 2014-12-06 21:19:22 8806 [Note] RSA private key file not found: /opt/mysql_data//private_key.pem. Some authentication plugins will not work. 2014-12-06 21:19:22 8806 [Note] RSA public key file not found: /opt/mysql_data//public_key.pem. Some authentication plugins will no t work. 2014-12-06 21:19:22 8806 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2014-12-06 21:19:22 8806 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2014-12-06 21:19:22 8806 [Note] Server socket created on IP: '0.0.0.0'. 2014-12-06 21:19:22 8806 [Warning] 'proxies_priv' entry '@ root@bla.bla.bla' ignored in --skip-name-resolve mo de. 2014-12-06 21:19:22 8806 [Note] Event Scheduler: Loaded 0 events 2014-12-06 21:19:22 8806 [Note] WSREP: inited wsrep sidno 2 2014-12-06 21:19:22 8806 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.15-56-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release 25.5, Revision 759 , wsrep_25.5.r4061 2014-12-06 21:19:22 8806 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2014-12-06 21:19:22 8806 [Note] WSREP: Assign initial position for certification: 66213, protocol version: 2 2014-12-06 21:19:22 8806 [Note] WSREP: Synchronized with group, ready for connections 2014-12-06 21:19:22 8806 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. InnoDB: Error: trying to access page number 16777207 in space 92, InnoDB: space name backoffice/stores, InnoDB: which is outside the tablespace bounds. InnoDB: Byte offset 0, len 16384, i/o type 10. InnoDB: If you get this error at mysqld startup, please check that InnoDB: your my.cnf matches the ibdata files that you have in the InnoDB: MySQL server. 2014-12-06 21:19:45 7fa98806d700 InnoDB: Assertion failure in thread 140366108350208 in file fil0fil.cc line 5457 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 21:19:45 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Please help us make Percona XtraDB Cluster better by reporting any bugs at https://bugs.launchpad.net/percona-xtradb-cluster key_buffer_size=33554432 read_buffer_size=4194304 max_used_connections=5 max_threads=502 thread_count=5 connection_count=5 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2224983 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2beb3c0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7fa98806cd38 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x902645] /usr/sbin/mysqld(handle_fatal_signal+0x4c4)[0x6801e4] /lib64/libpthread.so.0[0x3ff280f710] /lib64/libc.so.6(gsignal+0x35)[0x3ff2432925] /lib64/libc.so.6(abort+0x175)[0x3ff2434105] /usr/sbin/mysqld[0xac672e] /usr/sbin/mysqld[0xa9600c] /usr/sbin/mysqld[0xa96ca3] /usr/sbin/mysqld[0xa80a8e] /usr/sbin/mysqld[0xa6d4d2] /usr/sbin/mysqld[0xa11297] /usr/sbin/mysqld[0x967a09] /usr/sbin/mysqld[0x95d0d9] /usr/sbin/mysqld(_ZN7handler14ha_index_firstEPh+0x66)[0x5c0d46] /usr/sbin/mysqld(_Z15join_read_firstP13st_join_table+0x81)[0x6e0a81] /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x15d)[0x6e172d] /usr/sbin/mysqld(_ZN4JOIN4execEv+0x2aa)[0x6e1faa] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x250)[0x728540] /usr/sbin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x187)[0x728dc7] /usr/sbin/mysqld[0x70020d] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3904)[0x704f54] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x608)[0x707908] /usr/sbin/mysqld[0x707a31] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1ad4)[0x709cb4] /usr/sbin/mysqld(_Z10do_commandP3THD+0x1e3)[0x70b083] /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x17f)[0x6d492f] /usr/sbin/mysqld(handle_one_connection+0x47)[0x6d4b07] /usr/sbin/mysqld(pfs_spawn_thread+0x12a)[0xb3c0da] /lib64/libpthread.so.0[0x3ff28079d1] /lib64/libc.so.6(clone+0x6d)[0x3ff24e8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fa91c006d80): is an invalid pointer Connection ID (thread ID): 5 Status: NOT_KILLED You may download the Percona XtraDB Cluster operations manual by visiting http://www.percona.com/software/percona-xtradb-cluster/. You may find information in the manual which will help you identify the cause of the crash.

Cannot join second node

Lastest Forum Posts - December 10, 2014 - 1:14am
I have been trying to set up a new XtraDB Cluster like several times before, following this HOWTO: http://www.percona.com/doc/percona-x...ots_howto.html.

After setting up the first node with an appropriate user for sst, I've now been trying to start the second node for a day. On the donor side, mysql.log and innobackup.backup.log look perfectly fine, but the joiner mysql.log tells me that xtrabackup_galera_info wasn't created, and wsrep_sst_xtrabackup terminates with code 32 (broken pipe). I have searched all archives I could get hold of, but could not find anything appropriate. Most people are pointing to error messages in the innobackup.backup.log, but this really seems to be clean in my case. Does anybody have any idea? I would be really extremely grateful for any hint.

Pages

Subscribe to Percona aggregator
]]>