Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Message from discussion State transfer failed: -125(Operation canceled)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Alex Yurchenko  
View profile  
 More options Oct 12 2012, 6:59 am
From: Alex Yurchenko <alexey.yurche...@codership.com>
Date: Fri, 12 Oct 2012 13:59:19 +0300
Local: Fri, Oct 12 2012 6:59 am
Subject: Re: [codership-team] State transfer failed: -125(Operation canceled)
On 2012-10-12 11:34, Lee Henson wrote:

>> What does SELECT @@wsrep_provider_options\G say?

> mysql> SELECT @@wsrep_provider_options\G
> *************************** 1. row ***************************
> @@wsrep_provider_options: base_port = 4567; evs.debug_log_mask = 0x1;
> evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S;
> evs.info_log_mask = 0; evs.install_timeout = PT15S;
> evs.join_retrans_period
> = PT0.3S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 1;
> evs.send_window = 4; evs.stats_report_period = PT1M;
> evs.suspect_timeout =
> PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version
> = 0;
> evs.view_forget_timeout = PT5M; gcache.dir = /var/lib/mysql/;
> gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name =
> /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size =
> 128M;
> gcs.fc_debug = 0; gcs.fc_factor = 0.5; gcs.fc_limit = 16;
> gcs.fc_master_slave = NO; gcs.max_packet_size = 64500;
> gcs.max_throttle =
> 0.25; gcs.recv_q_hard_limit = 9223372036854775807;
> gcs.recv_q_soft_limit =
> 0.25; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ;
> gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.time_wait =
> PT5S;
> gmcast.version = 0; ist.recv_addr = 173.45.237.153; pc.checksum =
> true;
> pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT2S;
> pc.npvo =
> false; pc.version = 0; protonet.backend = asio; protonet.version = 0;
> replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
> 1 row in set (0.00 sec)

Hm, 77 million of 128Mb pages... something is not right there, but I
have no idea yet.

> Could you post more of the preceding log? especially the line about
>> creation of gcache.page?

> Whoops, I totally forgot to backup that log and it's been logrotated
> out.
> Sorry!

> Which Galera version are you using?

> dpkg -s galera:

> Package: galera
> Status: install ok installed
> Maintainer: Codership Oy
> Architecture: amd64
> Version: 23.2.0
> Replaces: galera
> Provides: wsrep, galera
> Depends: libc6 (>= 2.4), libstdc++6 (>= 4.1.1), libgcc1 (>= 4.1.1),
> libssl0.9.8
> Conffiles:
>  /etc/default/garb b50555bd995e118d2f944b64cab0ecab
> Description: Galera Replication Framework
>  Copyright: 2007-2011 by Codership Oy, All Rights Reserved
>  Replication framework for transactional applications. Implements
> wsrep
> interface.

> dpkg -s mysql-server-wsrep:

> Package: mysql-server-wsrep
> Status: install ok installed
> Maintainer: Codership Oy
> Architecture: amd64
> Version: 5.5.20-23.4
> Replaces: mysql-server-core (<= 5.5.20), mysql-server-core-5.0 (<=
> 5.5.20),
> mysql-server-core-5.1 (<= 5.5.20), mysql-server (<= 5.5.20),
> mysql-server-5.0 (<= 5.5.20), mysql-server-5.1 (<= 5.5.20),
> mysql-server-core-5.5 (<= 5.5.20), mysql-server-5.5 (<= 5.5.20)
> Provides: mysql-server-core, mysql-server, mysql-server-core-5.5,
> mysql-server-5.5
> Depends: psmisc, debianutils (>= 1.6), libc6 (>= 2.4), libdbi-perl,
> libdbd-mysql-perl (>= 1.2202), libgcc1 (>= 4.1.1), libncurses5 (>=
> 5.6),
> libstdc++6 (>= 4.1.1), libwrap0 (>= 7.6), perl, zlib1g (>= 1.1.4),
> libaio1,
> mysql-client
> Conffiles:
>  /etc/mysql/conf.d/wsrep.cnf 66200619107be141d9796223ce719884
> Description: wsrep-enabled MySQL server
>  Copyright: MySQL AB, Codership Oy, All Rights Reserved
>  MySQL server + wsrep patch (https://launchpad.net/codership-mysql)

> Yes, something like that.

>  Ok, we'll tweak that.

There have been no related changes in gcache since 2.0, but upgrading
to the latest release is a right thing to do - quite a number of bugs
were fixed.

Increase gcache.size and keep an eye on gcache "paging" - it should not
happen during normal operation.

Regards,
Alex
--
Alexey Yurchenko,
Codership Oy, www.codership.com
Skype: alexey.yurchenko, Phone: +358-400-516-011


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.