Not the answer you need?
Register and ask your own question!

setting one 'evs' variable in 'wsrep_provider_options' results in 'Numerical result out of range'

split-brainsplit-brain EntrantCurrent User Role Supporter
I was googling it around, but couldn't find any clue. I want to set wsrep_provider_options="evs.suspect_timeout=PT1S", but PXC (8.0.19-10) won't start and its complaining about another variable having out of range value. All my 'evs' variables have default values.
Can you please help me to solve this issue?
2020-08-25T13:00:16.494140Z 0 [ERROR] [MY-000000] [Galera] failed to open gcomm backend connection: 34: parameter 'evs.keepalive_period' value PT1S is out of range [PT0.1S,PT0.333333S): 34 (Numerical result out of range)
     at gcomm/src/gcomm/conf.hpp:check_range():564
2020-08-25T13:00:16.494163Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_core.cpp:gcs_core_open():220: Failed to open backend connection: -34 (Numerical result out of range)
2020-08-25T13:00:16.494248Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs.cpp:gcs_open():1700: Failed to open channel 'pxc-avv' at 'gcomm://10.2.1.25,10.2.2.230,10.2.3.182': -34 (Numerical result out of range)
2020-08-25T13:00:16.494271Z 0 [ERROR] [MY-000000] [Galera] gcs connect failed: Numerical result out of range
2020-08-25T13:00:16.494287Z 0 [ERROR] [MY-000000] [WSREP] Provider/Node (gcomm://10.2.1.25,10.2.2.230,10.2.3.182) failed to establish connection with cluster (reason: 7)
2020-08-25T13:00:16.494324Z 0 [ERROR] [MY-010119] [Server] Aborting





Answers

  • matthewbmatthewb Senior [email protected] Percona Staff Role
    If you remove that parameter, does PXC start correctly?
  • split-brainsplit-brain Entrant Current User Role Supporter
    edited August 27
    Yes it does. Also when I follow this statement in error log: "'evs.keepalive_period' value PT1S is out of range [PT0.1S,PT0.333333S)" and set evs.suspect_timeout=PT1S AND evs.keepalive_period=PT0.3S it works.

    I just wonder, why there is such dependency among these variables? I would prefer to set just those I need and leave the others with their default values.

    Next thing: setting evs.inactive_timeout=PT3S results in that error again, but the statement in error log is requiring even narrower range:
    2020-08-27T08:22:39.785924Z 0 [ERROR] [MY-000000] [Galera] failed to open gcomm backend connection: 34: parameter 'evs.keepalive_period' value P is out of range [PT0.1S,PT0.333333S): 34 (Numerical result out of range)
         at gcomm/src/gcomm/conf.hpp:check_range():564
    2020-08-27T08:22:39.785948Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_core.cpp:gcs_core_open():220: Failed to open backend connection: -34 (Numerical result out of range)
    2020-08-27T08:22:39.786012Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs.cpp:gcs_open():1700: Failed to open channel 'pxc-avv' at 'gcomm://10.2.1.25,10.2.2.230,10.2.3.182': -34 (Numerical result out of range)
    2020-08-27T08:22:39.786027Z 0 [ERROR] [MY-000000] [Galera] gcs connect failed: Numerical result out of range
    2020-08-27T08:22:39.786045Z 0 [ERROR] [MY-000000] [WSREP] Provider/Node (gcomm://10.2.1.25,10.2.2.230,10.2.3.182) failed to establish connection with cluster (reason: 7)
    2020-08-27T08:22:39.786083Z 0 [ERROR] [MY-010119] [Server] Aborting




  • matthewbmatthewb Senior [email protected] Percona Staff Role
    Not sure why there's a link between those variables. WSREP variables come from the Galera library. You might consider opening a https://jira.percona.com/ bug so our developers can take a look.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.