failed connect to node
198 views
Skip to first unread message
Gorazio
Aug 22, 2011, 2:43:48 AM8/22/11
to codership
Currently using version 0.7.6. Decided to try the new version, but the
following problem: pick up one node. when trying to connect a second
in the log writes
110822 10:07:02 [Warning] Changed limits: max_open_files: 1024
max_connections: 886 table_cache: 64
110822 10:07:02 [Note] WSREP: wsrep_load(): loading provider library '/
home/cluster/mysql-5.1.57-galera-0.8.1-x86_64/galera/lib/
libgalera_smm.so'
110822 10:07:02 [Note] WSREP: wsrep_load(): Galera 0.8.1(r57) by
Codership Oy <in...@codership.com> loaded succesfully.
110822 10:07:02 [Note] WSREP: Passing config to GCS: 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:4568; replicator.commit_order
= 3
110822 10:07:02 [Note] WSREP: wsrep_sst_grab()
110822 10:07:02 [Note] WSREP: Start replication
110822 10:07:02 [Warning] WSREP: state file not found: grastate.dat
110822 10:07:02 [Note] WSREP: Assign initial position for
certification: -1, protocol version: 1
110822 10:07:02 [Note] WSREP: Setting initial position to
00000000-0000-0000-0000-000000000000:-1
110822 10:07:02 [Note] WSREP: protonet asio version 0
110822 10:07:02 [Note] WSREP: backend: asio
110822 10:07:02 [Note] WSREP: GMCast version 0
110822 10:07:02 [Note] WSREP: (f3e133e1-cc84-11e0-0800-fec26362fe6e,
'tcp://0.0.0.0:4568') listening at tcp://0.0.0.0:4568
110822 10:07:02 [Note] WSREP: (f3e133e1-cc84-11e0-0800-fec26362fe6e,
'tcp://0.0.0.0:4568') multicast: , ttl: 1
110822 10:07:02 [Note] WSREP: EVS version 0
110822 10:07:02 [Note] WSREP: PC version 0
110822 10:07:02 [Note] WSREP: gcomm: connecting to group 'ucwork',
peer '95.211.xx.xxx:'
110822 10:07:02 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:03 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:05 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:06 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:08 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:09 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:11 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:12 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:14 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:15 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:17 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:19 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:20 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:22 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:23 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:25 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:26 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:27 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:29 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:31 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:32 [Note] WSREP: GMCast::handle_stable_view:
view((empty))
110822 10:07:32 [ERROR] WSREP: failed to open gcomm backend
connection: 110: failed to join group: 110 (Connection timed out)
at gcomm/src/pc.cpp:connect():132
110822 10:07:32 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():180:
Failed to open backend connection: -110 (Connection timed out)
110822 10:07:32 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1215: Failed
to open channel 'ucwork' at 'gcomm://95.211.xx.xxx': -110 (Connection
timed out)
110822 10:07:32 [ERROR] WSREP: gcs connect failed: Connection timed
out
110822 10:07:32 [ERROR] WSREP: wsrep::connect() failed: 6
110822 10:07:32 [ERROR] Aborting
110822 10:07:32 [Note] WSREP: Service disconnected.
110822 10:07:33 [Note] WSREP: Some threads may fail to exit.
110822 10:07:33 [Note] /home/cluster/mysql-5.1.57-galera-0.8.1-x86_64/
mysql/libexec/mysqld: Shutdown complete
the only change in the configuration files it gmcast.listen_addr =
tcp: / / 0.0.0.0:4568, because the port was already occupied by the
older server
following problem: pick up one node. when trying to connect a second
in the log writes
110822 10:07:02 [Warning] Changed limits: max_open_files: 1024
max_connections: 886 table_cache: 64
110822 10:07:02 [Note] WSREP: wsrep_load(): loading provider library '/
home/cluster/mysql-5.1.57-galera-0.8.1-x86_64/galera/lib/
libgalera_smm.so'
110822 10:07:02 [Note] WSREP: wsrep_load(): Galera 0.8.1(r57) by
Codership Oy <in...@codership.com> loaded succesfully.
110822 10:07:02 [Note] WSREP: Passing config to GCS: 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:4568; replicator.commit_order
= 3
110822 10:07:02 [Note] WSREP: wsrep_sst_grab()
110822 10:07:02 [Note] WSREP: Start replication
110822 10:07:02 [Warning] WSREP: state file not found: grastate.dat
110822 10:07:02 [Note] WSREP: Assign initial position for
certification: -1, protocol version: 1
110822 10:07:02 [Note] WSREP: Setting initial position to
00000000-0000-0000-0000-000000000000:-1
110822 10:07:02 [Note] WSREP: protonet asio version 0
110822 10:07:02 [Note] WSREP: backend: asio
110822 10:07:02 [Note] WSREP: GMCast version 0
110822 10:07:02 [Note] WSREP: (f3e133e1-cc84-11e0-0800-fec26362fe6e,
'tcp://0.0.0.0:4568') listening at tcp://0.0.0.0:4568
110822 10:07:02 [Note] WSREP: (f3e133e1-cc84-11e0-0800-fec26362fe6e,
'tcp://0.0.0.0:4568') multicast: , ttl: 1
110822 10:07:02 [Note] WSREP: EVS version 0
110822 10:07:02 [Note] WSREP: PC version 0
110822 10:07:02 [Note] WSREP: gcomm: connecting to group 'ucwork',
peer '95.211.xx.xxx:'
110822 10:07:02 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:03 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:05 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:06 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:08 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:09 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:11 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:12 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:14 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:15 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:17 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:19 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:20 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:22 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:23 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:25 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:26 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:27 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:29 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:31 [Warning] WSREP: checksum failed, hdr: len=36
has_crc32=0 crc32=1048832
110822 10:07:32 [Note] WSREP: GMCast::handle_stable_view:
view((empty))
110822 10:07:32 [ERROR] WSREP: failed to open gcomm backend
connection: 110: failed to join group: 110 (Connection timed out)
at gcomm/src/pc.cpp:connect():132
110822 10:07:32 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():180:
Failed to open backend connection: -110 (Connection timed out)
110822 10:07:32 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1215: Failed
to open channel 'ucwork' at 'gcomm://95.211.xx.xxx': -110 (Connection
timed out)
110822 10:07:32 [ERROR] WSREP: gcs connect failed: Connection timed
out
110822 10:07:32 [ERROR] WSREP: wsrep::connect() failed: 6
110822 10:07:32 [ERROR] Aborting
110822 10:07:32 [Note] WSREP: Service disconnected.
110822 10:07:33 [Note] WSREP: Some threads may fail to exit.
110822 10:07:33 [Note] /home/cluster/mysql-5.1.57-galera-0.8.1-x86_64/
mysql/libexec/mysqld: Shutdown complete
the only change in the configuration files it gmcast.listen_addr =
tcp: / / 0.0.0.0:4568, because the port was already occupied by the
older server
alexey.yurchenko
Aug 22, 2011, 4:11:43 AM8/22/11
to Gorazio, codership
0.8 series is protocol-incompatible with 0.7, sorry.
Gorazio <stepano...@gmail.com> wrote:
>--
>You received this message because you are subscribed to the Google Groups "codership" group.
>To post to this group, send email to codersh...@googlegroups.com.
>To unsubscribe from this group, send email to codership-tea...@googlegroups.com.
>For more options, visit this group at http://groups.google.com/group/codership-team?hl=en.
>
Gorazio
Aug 22, 2011, 4:14:31 AM8/22/11
to codership
im not trying to connect 0.8 to 0.7. i try launch it on different port
On Aug 22, 12:11 pm, "alexey.yurchenko"
On Aug 22, 12:11 pm, "alexey.yurchenko"
<alexey.yurche...@codership.com> wrote:
> 0.8 series is protocol-incompatible with 0.7, sorry.
>
>
>
>
>
>
>
> Gorazio <stepanov.mih...@gmail.com> wrote:
> >Currently using version 0.7.6. Decided to try the new version, but the
> >following problem: pick up one node. when trying to connect a second
> >in the log writes
>
> >110822 10:07:02 [Warning] Changed limits: max_open_files: 1024
> >max_connections: 886 table_cache: 64
> >110822 10:07:02 [Note] WSREP: wsrep_load(): loading provider library '/
> >home/cluster/mysql-5.1.57-galera-0.8.1-x86_64/galera/lib/
> >libgalera_smm.so'
> >110822 10:07:02 [Note] WSREP: wsrep_load(): Galera 0.8.1(r57) by
> >Codership Oy <i...@codership.com> loaded succesfully.
> 0.8 series is protocol-incompatible with 0.7, sorry.
>
>
>
>
>
>
>
> Gorazio <stepanov.mih...@gmail.com> wrote:
> >Currently using version 0.7.6. Decided to try the new version, but the
> >following problem: pick up one node. when trying to connect a second
> >in the log writes
>
> >110822 10:07:02 [Warning] Changed limits: max_open_files: 1024
> >max_connections: 886 table_cache: 64
> >110822 10:07:02 [Note] WSREP: wsrep_load(): loading provider library '/
> >home/cluster/mysql-5.1.57-galera-0.8.1-x86_64/galera/lib/
> >libgalera_smm.so'
> >110822 10:07:02 [Note] WSREP: wsrep_load(): Galera 0.8.1(r57) by
Gorazio
Aug 22, 2011, 4:43:02 AM8/22/11
to codership
i found problem, it was my mistake
alex
May 23, 2012, 4:03:18 PM5/23/12
to codersh...@googlegroups.com
i have the same problem and I cannot find a solution..can you please tell me what have you done to solve it? thanks
Alexey Yurchenko
May 25, 2012, 2:06:06 PM5/25/12
to codersh...@googlegroups.com
Use the latest release (MySQL 5.5.23, Galera 2.1), post the logs.
alex
May 28, 2012, 11:35:14 AM5/28/12
to codersh...@googlegroups.com
I solved this by setting the wsrep_cluster_address="gcomm://<ip. adr>" without the port number. It's working now without any problems.
Reply all
Reply to author
Forward
0 new messages