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
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
