IDS Forum

Re: sh.addShard

Posted By: Nagaraju Inturi
Date: Thursday, 19 March 2015, at 8:49 p.m.

In Response To: Re: sh.addShard (FRANK)

Hi Frank,

sh.addShard() internally run 'cdr autoconfig server' command.
This command sets up sqlhosts file for group entries. Since you already
have ER group entries defined for local server in your SQLHOSTS files, its
probably causing problem with ER auto configuration. Can you pls. remove
existing group entries in your SQLHOSTS file and rerun sh.addShard()
command ?

Thanks & Regards,
Nagaraju

From: "FRANK" <yunyaoqu@gmail.com>
To: ids@iiug.org,
Date: 03/19/2015 03:16 PM
Subject: Re: sh.addShard [34853]
Sent by: ids-bounces@iiug.org

I found sh.addShard() will cause both local and remote sqlhosts to be
modified.

This is the example,

Original sqlhosts file,
========================
g_ncdcopsjson group - - i=11
ncdcopsjson_tcp onsoctcp leslie-dat online9171
g=g_ncdcopsjson

g_nsofopsjson group - - i=12
nsofopsjson_tcp onsoctcp maggie-dat online9171
g=g_nsofopsjson
nsofopsjson onipcshm maggie-dat serviceopsjson

Modified by Informix after running sh.addShard,
========================
g_ncdcopsjson group - - i=11
nsofopsjson onipcshm maggie-dat serviceopsjson
g_nsofopsjson group - - i=12
g_nsofopsjson_tcp group - - i=13
nsofopsjson_tcp onsoctcp maggie-dat online9171
g=g_nsofopsjson_tcp
g_ncdcopsjson_tcp group - - i=14
ncdcopsjson_tcp onsoctcp leslie-dat 9171
g=g_ncdcopsjson_tcp

Any idea why the sqlhosts need be modified ? Avoidable ?

Thanks
Frank

On Wed, Mar 18, 2015 at 7:55 PM, Art Kagel <art.kagel@gmail.com> wrote:

> cdr finderr 37 says that this error code indicates an attempt to connect
to
> an undefined server. Odd.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions

> and do not reflect on the IIUG, nor any other organization with which I
am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Wed, Mar 18, 2015 at 6:53 PM, FRANK <yunyaoqu@gmail.com> wrote:
>
> > Hello,
> >
> > IDS 12.10 FC4
> > RHEL Linux
> >
> > Used MongoDB shell to create a Shard.
> >
> > Did a bunch of configurations, setup, tests...... Eventually, I am
stuck
> > here,
> >
> > mongos> sh.addShard("leslie-dat:9171")
> > {
> >
> > "code" : null,
> >
> > "ok" : 0,
> >
> > "errmsg" : "command failed -- undefined server (37) "
> > }
> > mongos>
> >
> > I run the above sh.addShard command in mongo shell.
> >
> > Attached are the two log info of both local and remote node.
> >
> > Seems this was the culprit,
> >
> > 22:34:30 CDR GC: operation sync cache define remote server failed
(error
> > 37).
> > 22:34:30 CDR GC: synchronization failed (sync abort, shutting down
CDR)
> >
> > Any idea what I should do?
> >
> > Thanks
> > Frank
> >
> > Local Log :
> >
> > 22:34:21 Building 'syscdr' database ...
> > 22:34:22 'syscdr' database built successfully.
> > 22:34:22 CDR queuer initialization complete
> > 22:34:22 ER checkpoint started
> > 22:34:22 CDR NIF listening on asf://g_nsofopsjson_tcp
> > 22:34:23 Checkpoint Completed: duration was 0 seconds.
> > 22:34:23 Wed Mar 18 - loguniq 6, logpos 0xa84b5b4, timestamp: 0x10bd1c

> > Interval: 115
> > 22:34:23 Maximum server connections 8
> > 22:34:23 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> blocked
> > 0, Plog used 109, Llog used 2671
> > 22:34:23 ER checkpoint logid:6 logpos:0xa84b5b4
> > 22:34:23 DDR Log Snooping - Snooping started in log 6
> > 22:34:33 CDR: Enterprise Replication Auto Configuration aborted. rc=37

> > 22:34:35 SMX thread is exiting
> >
> > Remote (leslie-dat) Log :
> >
> > 22:34:27 Building 'syscdr' database ...
> > 22:34:28 'syscdr' database built successfully.
> > 22:34:30 CDR queuer initialization complete
> > 22:34:30 ER checkpoint started
> > 22:34:30 CDR NIF listening on asf://g_ncdcopsjson_tcp
> > 22:34:30 CDR GC: operation sync cache define remote server failed
(error
> > 37).
> > 22:34:30 CDR GC: synchronization failed (sync abort, shutting down
CDR)
> > 22:34:30 Checkpoint Completed: duration was 0 seconds.
> > 22:34:30 Wed Mar 18 - loguniq 7, logpos 0xa1df018, timestamp: 0x10e384

> > Interval: 211
> > 22:34:30 Maximum server connections 5
> > 22:34:30 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> blocked
> > 0, Plog used 2001, Llog used 2780
> > 22:34:30 ER checkpoint logid:7 logpos:0xa1df018
> > 22:34:30 DDR Log Snooping - Snooping started in log 7
> > 22:34:31 CDR NIF Shutdown: connections all shutdown.
> > 22:34:31 CDR The NIF sub-component has shut down.
> > 22:34:32 DDR Log Snooping - Shutdown
> > 22:34:33 CDR shutdown complete
> > 22:34:33 CDR: Failed to define Enterprise Replication server rc=37,
Error
> > Message=command failed -- undefined server (37)
> > 22:34:33 SMX thread is exiting because it received a CLOSE message
from a
> > remote server
> >
> > --001a11475ce8428201051197f232
> >
> >
> >
> >
>
>
*******************************************************************************

> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a113f94609cd522051198cfb5
>
>
>
>
*******************************************************************************

> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a1139bcd89db6320511a9db93

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• sh.addShard
  FRANK -- Wednesday, 18 March 2015, at 6:53 p.m.
  • Re: sh.addShard
    Art Kagel -- Wednesday, 18 March 2015, at 7:55 p.m.
    • Re: sh.addShard
      FRANK -- Thursday, 19 March 2015, at 4:15 p.m.
      • Re: sh.addShard
        Nagaraju Inturi -- Thursday, 19 March 2015, at 8:49 p.m.
        • Re: sh.addShard
          FRANK -- Friday, 20 March 2015, at 11:51 a.m.
          • Re: sh.addShard
            ERIKA VON BARGEN -- Friday, 20 March 2015, at 1:27 p.m.
            • Re: sh.addShard
              FRANK -- Friday, 20 March 2015, at 5:01 p.m.
              • Re: sh.addShard
                FRANK -- Friday, 20 March 2015, at 5:29 p.m.
                • Re: sh.addShard
                  ERIKA VON BARGEN -- Friday, 20 March 2015, at 6:12 p.m.
                  • Re: sh.addShard
                    FRANK -- Monday, 23 March 2015, at 4:26 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.