clpong
1 Nickel

gpcheckos : platform.hostname mismatch

Hi,

I encountered some platform.hostname mismatch error while running gpcheckos command.

Here is the command with error:

[gpadmin@dev1-sdw1 install]$ gpcheckos -f /tmp/segment_hosts
/usr/local/greenplum-db/./bin/gpcheckos:19: DeprecationWarning: The popen2 module is deprecated.  Use the subprocess module.
  import getopt, popen2, pickle, time
checking: postgres.md5 = a24ec66d78315b7b6d90a9c7a2a3c274
checking: postgres.version = postgres (Greenplum Database) 8.2.15
checking: sync.time between (2012-05-29 19:20:12.149202, 2012-05-29 19:20:32.149202)
checking: platform.hostname
   ERROR: on hitw-gc-dev1-sdw2-1 - platform.hostname mismatch (value dev1-sdw2 should == hitw-gc-dev1-sdw2-1)
   ERROR: on hitw-gc-dev1-mdw-1 - platform.hostname mismatch (value dev1-sdw1 should == hitw-gc-dev1-mdw-1)
checking: platform.memory
checking: platform.memory = 33739792384
checking: platform.system = linux or sunos
checking: platform.system = linux
checking: platform.release = 2.6.18-308.4.1.el5
checking: sysctl.kernel.shmall = 4000000000
checking: sysctl.net.ipv4.tcp_max_syn_backlog = 4096
checking: sysctl.vm.overcommit_memory = 2
checking: sysctl.net.core.netdev_max_backlog = 10000
checking: ulimit.nofile >= 65536
checking: sysctl.kernel.sem = 250 64000 100 512
checking: sysctl.kernel.shmmax >= 500000000
checking: ulimit.nproc >= 131072
checking: sysctl.kernel.shmmni >= 4096
checking: sysctl.net.ipv4.ip_local_port_range = 1025 65535
checking: sysctl.net.ipv4.tcp_tw_recycle = 1


[FIX hitw-gc-dev1-mdw-1] please validate the OS configuration
check hostname = hitw-gc-dev1-mdw-1

[FIX hitw-gc-dev1-sdw2-1] please validate the OS configuration
check hostname = hitw-gc-dev1-sdw2-1

segment_hosts:

hitw-gc-dev1-mdw-1

hitw-gc-dev1-mdw-2

hitw-gc-dev1-mdw-3

hitw-gc-dev1-mdw-4

hitw-gc-dev1-sdw1-1

hitw-gc-dev1-sdw1-2

hitw-gc-dev1-sdw1-3

hitw-gc-dev1-sdw1-4

hitw-gc-dev1-sdw2-1

hitw-gc-dev1-sdw2-2

hitw-gc-dev1-sdw2-3

hitw-gc-dev1-sdw2-4

Here is the command without error:

[gpadmin@dev1-sdw1 install]$ gpcheckos -f /tmp/segment_hosts

/usr/local/greenplum-db/./bin/gpcheckos:19: DeprecationWarning: The popen2 module is deprecated.  Use the subprocess module.

  import getopt, popen2, pickle, time

checking: postgres.md5 = a24ec66d78315b7b6d90a9c7a2a3c274

checking: postgres.version = postgres (Greenplum Database) 8.2.15

checking: sync.time between (2012-05-29 19:25:34.405676, 2012-05-29 19:25:54.405676)

checking: platform.hostname

checking: platform.memory

checking: platform.memory = 33739792384

checking: platform.system = linux or sunos

checking: platform.system = linux

checking: platform.release = 2.6.18-308.4.1.el5

checking: sysctl.kernel.shmall = 4000000000

checking: sysctl.net.ipv4.tcp_max_syn_backlog = 4096

checking: sysctl.vm.overcommit_memory = 2

checking: sysctl.net.core.netdev_max_backlog = 10000

checking: ulimit.nofile >= 65536

checking: sysctl.kernel.sem = 250 64000 100 512

checking: sysctl.kernel.shmmax >= 500000000

checking: ulimit.nproc >= 131072

checking: sysctl.kernel.shmmni >= 4096

checking: sysctl.net.ipv4.ip_local_port_range = 1025 65535

checking: sysctl.net.ipv4.tcp_tw_recycle = 1

segment_hosts:

hitw-gc-dev1-mdw-1

hitw-gc-dev1-mdw-2

hitw-gc-dev1-mdw-3

hitw-gc-dev1-mdw-4

dev1-sdw1

hitw-gc-dev1-sdw1-2

hitw-gc-dev1-sdw1-3

hitw-gc-dev1-sdw1-4

dev1-sdw2

hitw-gc-dev1-sdw2-2

hitw-gc-dev1-sdw2-3

hitw-gc-dev1-sdw2-4

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

My /etc/hosts file for both master, sdw-1 and sdw-2:

172.16.10.254   hitw-gc-dev1-mdw-1      dev1-mdw
172.16.11.254   hitw-gc-dev1-mdw-2
172.16.12.254   hitw-gc-dev1-mdw-3
172.16.13.254   hitw-gc-dev1-mdw-4

172.16.10.1    hitw-gc-dev1-sdw1-1      dev1-sdw1
172.16.11.1    hitw-gc-dev1-sdw1-2
172.16.12.1    hitw-gc-dev1-sdw1-3
172.16.13.1    hitw-gc-dev1-sdw1-4

172.16.10.2    hitw-gc-dev1-sdw2-1      dev1-sdw2
172.16.11.2    hitw-gc-dev1-sdw2-2
172.16.12.2    hitw-gc-dev1-sdw2-3
172.16.13.2    hitw-gc-dev1-sdw2-4

Tags (2)
0 Kudos
4 Replies
clpong
1 Nickel

Re: gpcheckos : platform.hostname mismatch

Hi,

We try with this, and it works ok. It seems that local hostname has to be configured before the local hostname.localdomain. Not sure my understanding is correct or not.

-f segment_hosts:

dev1-mdw

hitw-gc-dev1-mdw-1

hitw-gc-dev1-mdw-2

hitw-gc-dev1-mdw-3

hitw-gc-dev1-mdw-4

dev1-sdw1

hitw-gc-dev1-sdw1-1

hitw-gc-dev1-sdw1-2

hitw-gc-dev1-sdw1-3

hitw-gc-dev1-sdw1-4

dev1-sdw2

hitw-gc-dev1-sdw2-1

hitw-gc-dev1-sdw2-2

hitw-gc-dev1-sdw2-3

hitw-gc-dev1-sdw2-4

0 Kudos
Highlighted
ViadeaZhu
1 Nickel

Re: gpcheckos : platform.hostname mismatch

what is the "hostname" command output on all servers?

They should match the hostfile.

tlingersoll
1 Copper

Re: gpcheckos : platform.hostname mismatch

Here is documentation that you might find helpful -

DNS Configuration

Most customers with an Active Directory Service (ADS) domain have a resident DNS

server and leveraging this server is a typical configuration for SmartConnect.

However, use of the resident DNS server is not required for SmartConnect to work. For

example, if an environment is a closed, secure, private network, a customer may be

looking to limit the number of devices on the network and have no need or not want

to add additional devices such as a DNS server. In those instances, customers can

configure their clients to use SmartConnect as their DNS server and will be able to use

the cluster with the connection balancing features. However, SmartConnect will not

act as a general DNS server, and will not answer requests for anything other than the

Isilon cluster.

A delegation (NS) entry needs to be added for the SmartConnect name, pointing to

the SmartConnect Service IP as the nameserver.

BIND server:

In BIND, a new name server (NS) record needs to be added to the existing

authoritative DNS zone specifying the server of authority for the new sub-zone. For

that, an A record must be added, specified in the NS record that points to the SIP

address of the cluster. For example, if the SmartConnect zone name is

  1. cluster.example.com, the DNS entries would looks like:

>>

  1. cluster.example.com

IN

NS

  1. sip.example.com

>>

  1. sip.example.com

IN

A

{IP

address}

Windows DNS Server:

In the Microsoft DNS wizard, a “New Delegation” record will be added in the forward

lookup zone for the parent domain, which is equivalent to the NS record mentioned

above.

0 Kudos
brianoconnell
1 Nickel

Re: gpcheckos : platform.hostname mismatch

You could also check the /etc/hosts file on all servers and confirm the names in your /tmp/segment_hosts matches the FIRST entry for the servers IP address.

I believe the /tmp/segment_hosts works when you add dev1-mdw, dev1-sdw1.. because these are the names listed in the servers /etc/hosts file first.  gpcheckos will deduplicate the hosts and figure out that dev1-mdw is the same as

hitw-gc-dev1-mdw-1,2,3.

The order in the /etc/hosts file also set the hostname in gp_segment_configuration, so you might want to think about what you want displayed there.

All the best

Brian O'Connell

0 Kudos