sh.addShard

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

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

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

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.

HI, I think I managed to get it run to some extent.... Some observations and questions. (1) mongodb shell response, mongos> sh.addShard("leslie-dat:9171") { "ok" : 1, "name" : "g_ncdcopsjson_tcp" } mongos> The above output is Success, correct ? (2) Online log of both local and remote sites, Local log, 15:25:43 ER checkpoint logid:6 logpos:0x10c785b4 15:25:43 DDR Log Snooping - Snooping started in log 6 15:25:58 RESYNC: Setting Replicate 32792 to Normal mode 15:25:58 CDR Grouper: Grouper evaluation blocked 15:25:58 CDR Grouper: Grouper evaluation unblocked 15:26:16 ER task ifx_sync_g_ncdcopsjson_tcp successfully completed cdr check replicateset ifx_internal_set 15:26:26 SMX thread is exiting 15:30:56 Checkpoint Completed: duration was 0 seconds. Remote log, 15:25:49 ER checkpoint logid:7 logpos:0xeec8018 15:25:49 DDR Log Snooping - Snooping started in log 7 15:25:53 CDR GC: synchronization complete 15:25:58 RESYNC: Setting Replicate 32792 to Normal mode 15:25:58 CDR Grouper: Grouper evaluation blocked 15:25:58 CDR Grouper: Grouper evaluation unblocked 15:26:23 SMX thread is exiting because it received a CLOSE message from a remote server 15:31:12 Checkpoint Completed: duration was 0 seconds. The log info told me success or some warning or errors ? (3) About sqlhosts files Apparently, it will do massive shuffled of your existing sqlhosts ( could be modified in unexpected ways.... careful ) It only prefers a minimal or bare line of host definition ( exiting defined working lines could be messed up) I am also very curious, it could stripe the port service column, e.g, from "online9171" to "9171" . The following is a example, The modified sqlhosts files, nsofopsjson onipcshm maggie-dat serviceopsjson g_nsofopsjson_tcp group - - i=1 nsofopsjson_tcp onsoctcp maggie-dat online9171 g=g_nsofopsjson_tcp g_ncdcopsjson_tcp group - - i=2 ncdcopsjson_tcp onsoctcp leslie-dat 9171 g=g_ncdcopsjson_tcp The last line actually was , ncdcopsjson_tcp onsoctcp leslie-dat online9171 g=g_ncdcopsjson_tcp (4) cdr list server outputs of local and remote node, [informix@maggie etc]$ cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- g_ncdcopsjson_tcp 2 Active Connected 0 Mar 20 15:25:52 g_nsofopsjson_tcp 1 Active Local 0 [informix@leslie etc]$ cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- g_ncdcopsjson_tcp 2 Active Local 0 g_nsofopsjson_tcp 1 Active Connected 0 Mar 20 15:25:51 So, based on above overall info, the shard is created successful or not ? Thanks frank On Thu, Mar 19, 2015 at 8:49 PM, Nagaraju Inturi <nagaraju@us.ibm.com> wrote: > 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 i

Hi Frank, mongos> sh.addShard("leslie-dat:9171") { "ok" : 1, "name" : "g_ncdcopsjson_tcp" } This does indicate success. {ok: 1} means success. {ok: 0} would indicate a failure and would be accompanied by a errmsg field in the response document. The sh.addShard command adds the server specified to the sharded env. The next step would be to run sh.shardCollection to actually shard your various collections/tables. If you need more info on sh.shardCollection, here's a link to that topic in the Informix Knowledge Center. http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.json.doc/ids _json_036.htm?lang=en Thanks, Erika

OK. I tried to create a collection, mongos> db.createCollection("my_collection_1"); { "code" : null, "ok" : 0, "errmsg" : "Unable to create table 'my_collection_1' for namespace 'noaa.my_collection_1' | Table (informix.my_collection_1) already exists in database. (SQL Code: -310, SQL State: S0001)" } mongos> -310 Table table-name already exists in database. 310 error is confusing...., it was a brand new name!! Log of Json listener is attached. Seems it actually complained: no such DB space (-212 Cannot add index.) , for index creation . I also attached the onstat -d output . No sure what need to fix, what db space I need add ? Thanks Frank ========================== log of Json listener 2015-03-20 20:45:27 [JsonListener-1-thread-6] ERROR Session-6 - SQLCODE: -212 Cannot add index. 2015-03-20 20:45:27 [JsonListener-1-thread-6] ERROR Session-6 - Unable to create index _id_ for namespace noaa.my_collection_1 on table my_collection_1 with specification { "v" : 1 , "key" : { "_id" : [ 1 ,"$string" ] } , "ns" : "noaa.my_collection_1" , "name" : "_id_" , "unique" : true , "index" : "my_collection_1__id_" } | Cannot add index. (SQL Code: -212, SQL State: IX000) | ISAM error: no such DBspace (SQL Code: -130, SQL State: IX000) java.sql.SQLException: Cannot add index. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408) at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3132) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3412) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2325) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2250) at com.informix.jdbc.IfxSqli.sendStatementExecute(IfxSqli.java:1321) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2180) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2133) at com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:363) at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1144) at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1120) at com.informix.jdbc.IfxStatement.executeBody(IfxStatement.java:866) at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:784) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createIndex(InformixColl ectionUtils.java:1306) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createIndexOnIdField(Inf ormixCollectionUtils.java:1173) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createCollection(Informi xCollectionUtils.java:153) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createCollection(Informi xCollectionUtils.java:107) at com.ibm.nosql.informix.internal.command.administration.CreateCommand.process(Cre ateCommand.java:39) at com.ibm.nosql.informix.internal.command.CommandRegistry.process(CommandRegistry. java:214) at com.ibm.nosql.informix.internal.request.InformixRequestHandler.processCommand(In formixRequestHandler.java:498) at com.ibm.nosql.informix.internal.request.InformixRequestHandler.processQuery(Info rmixRequestHandler.java:478) at com.ibm.nosql.informix.internal.request.QueryRequest.process(QueryRequest.java:2 50) at com.ibm.nosql.informix.server.mongo.MongoListenerMessageHandler.handleMessage(Mo ngoListenerMessageHandler.java:305) at com.ibm.nosql.informix.server.mongo.MongoListenerMessageHandler.run(MongoListene rMessageHandler.java:128) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:744) Caused by: java.sql.SQLException: ISAM error: no such DBspace at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3417) ... 24 more 2015-03-20 20:45:27 [JsonListener-1-thread-6] ERROR Session-6 - SQLCODE: -212 Cannot add index. 2015-03-20 20:45:27 [JsonListener-1-thread-6] ERROR Session-6 - Unable to create table 'my_collection_1' for namespace 'noaa.my_collection_1' java.sql.SQLException: Table (informix.my_collection_1) already exists in database. at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3130) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3412) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2325) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2250) at com.informix.jdbc.IfxSqli.sendStatementExecute(IfxSqli.java:1321) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2180) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2133) at com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:363) at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1144) at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1120) at com.informix.jdbc.IfxStatement.executeBody(IfxStatement.java:866) at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:784) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createTableForCollection (InformixCollectionUtils.java:531) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createTableForCollection (InformixCollectionUtils.java:308) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createCollection(Informi xCollectionUtils.java:134) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createCollection(Informi xCollectionUtils.java:113) at com.ibm.nosql.informix.internal.command.administration.CreateCommand.process(Cre ateCommand.java:39) at com.ibm.nosql.informix.internal.command.CommandRegistry.process(CommandRegistry. java:214) at com.ibm.nosql.informix.internal.request.InformixRequestHandler.processCommand(In formixRequestHandler.java:498) at com.ibm.nosql.informix.internal.request.InformixRequestHandler.processQuery(Info rmixRequestHandler.java:478) at com.ibm.nosql.informix.internal.request.QueryRequest.process(QueryRequest.java:2 50) at com.ibm.nosql.informix.server.mongo.MongoListenerMessageHandler.handleMessage(Mo ngoListenerMessageHandler.java:305) at com.ibm.nosql.informix.server.mongo.MongoListenerMessageHandler.run(MongoListene rMessageHandler.java:128) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:744) Caused by: java.sql.SQLException at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3417) ... 24 more 2015-03-20 20:45:27 [JsonListener-1-thread-6] ERROR Session-6 - Error creating collection com.ibm.nosql.informix.json.api.MongoExcep

Interesting, Even there was error in creating a collection, I tried to go ahead to insert data.... ==== Do it in Mongo Shell mongos> db.my_collection_1.insert({"name":"Anne","age":41}); WriteResult({ "nInserted" : 1 }) mongos> db.my_collection_1.insert({"name":"Anne_2","age":21}); WriteResult({ "nInserted" : 1 }) mongos> ==== Search it in Informix dbaccess select data.name::json, data.age::json from my_collection_1; (expression) {"name":"Anne"} (expression) {"age":41.000000} (expression) {"name":"Anne_2"} (expression) {"age":21.000000} So, it seems the work can be done there ... But the previous error can be ignored ?? Thanks Frank On Fri, Mar 20, 2015 at 5:01 PM, FRANK <yunyaoqu@gmail.com> wrote: > OK. I tried to create a collection, > > mongos> db.createCollection("my_collection_1"); > { > > "code" : null, > > "ok" : 0, > > "errmsg" : "Unable to create table 'my_collection_1' for namespace > 'noaa.my_collection_1' | Table (informix.my_collection_1) already exists in > database. (SQL Code: -310, SQL State: S0001)" > } > mongos> > > -310 Table table-name already exists in database. > > 310 error is confusing...., it was a brand new name!! > > Log of Json listener is attached. Seems it actually complained: no such > DB space (-212 Cannot add index.) , for index creation . > > I also attached the onstat -d output . > > No sure what need to fix, what db space I need add ? > > Thanks > Frank > > ========================== log of Json listener > > 2015-03-20 20:45:27 [JsonListener-1-thread-6] ERROR Session-6 - SQLCODE: > -212 Cannot add index. > 2015-03-20 20:45:27 [JsonListener-1-thread-6] ERROR Session-6 - Unable to > create index _id_ for namespace noaa.my_collection_1 on table > my_collection_1 with specification { "v" : 1 , "key" : { "_id" : [ 1 ,> "$string" ] } , "ns" : "noaa.my_collection_1" , "name" : "_id_" , "unique" > : true , "index" : "my_collection_1__id_" } | Cannot add index. (SQL Code: > -212, SQL State: IX000) | ISAM error: no such DBspace (SQL Code: -130, SQL > State: IX000) > java.sql.SQLException: Cannot add index. > > at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408) > > at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3132) > > at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3412) > > at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2325) > > at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2250) > > at com.informix.jdbc.IfxSqli.sendStatementExecute(IfxSqli.java:1321) > > at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2180) > > at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2133) > > at > com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:363) > > at > com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1144) > > at > com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1120) > > at com.informix.jdbc.IfxStatement.executeBody(IfxStatement.java:866) > > at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:784) > > at > > > com.ibm.nosql.informix.internal.InformixCollectionUtils.createIndex(InformixColl ectionUtils.java:1306) > > at > > > com.ibm.nosql.informix.internal.InformixCollectionUtils.createIndexOnIdField(Inf ormixCollectionUtils.java:1173) > > at > > > com.ibm.nosql.informix.internal.InformixCollectionUtils.createCollection(Informi xCollectionUtils.java:153) > > at > > > com.ibm.nosql.informix.internal.InformixCollectionUtils.createCollection(Informi xCollectionUtils.java:107) > > at > > > com.ibm.nosql.informix.internal.command.administration.CreateCommand.process(Cre ateCommand.java:39) > > at > > > com.ibm.nosql.informix.internal.command.CommandRegistry.process(CommandRegistry. java:214) > > at > > > com.ibm.nosql.informix.internal.request.InformixRequestHandler.processCommand(In formixRequestHandler.java:498) > > at > > > com.ibm.nosql.informix.internal.request.InformixRequestHandler.processQuery(Info rmixRequestHandler.java:478) > > at > > > com.ibm.nosql.informix.internal.request.QueryRequest.process(QueryRequest.java:2 50) > > at > > > com.ibm.nosql.informix.server.mongo.MongoListenerMessageHandler.handleMessage(Mo ngoListenerMessageHandler.java:305) > > at > > > com.ibm.nosql.informix.server.mongo.MongoListenerMessageHandler.run(MongoListene rMessageHandler.java:128) > > at > > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > at > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > > at java.lang.Thread.run(Thread.java:744) > Caused by: java.sql.SQLException: ISAM error: no such DBspace > > at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408) > > at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3417) > > .... 24 more > 2015-03-20 20:45:27 [JsonListener-1-thread-6] ERROR Session-6 - SQLCODE: > -212 Cannot add index. > 2015-03-20 20:45:27 [JsonListener-1-thread-6] ERROR Session-6 - Unable to > create table 'my_collection_1' for namespace 'noaa.my_collection_1' > java.sql.SQLException: Table (informix.my_collection_1) already exists in > database. > > at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3130) > > at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3412) > > at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2325) > > at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2250) > > at com.informix.jdbc.IfxSqli.sendStatementExecute(IfxSqli.java:1321) > > at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2180) > > at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2133) > > at > com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:363) > > at > com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1144) > > at > com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1120) > > at com.informix.jdbc.IfxStatement.executeBody(IfxStatement.java:866) > > at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:784) > > at > > > com.ibm.nosql.informix.internal.InformixCollectionUtils.createTableForCollection (InformixCollectionUtils.java:531) > > at > > > com.ibm.nosql.informix.internal.InformixCollectionUtils.createTableForCollection (InformixCollectionUtils.java:308) > > at > > > com.ibm.nosql.informix.internal.InformixCollectionUtils.createCollection(Informi xCollectionUtils.java:134) > > at > > > com.ibm.nosql.informix.i

When you create a collection, a unique index on the _id field is also automatically created. It seems that your collection table was created successfully but the index creation failed. You might want to check what your default sbspace is set to. Otherwise, if you restart the listener with -loglevel debug, it will also print out the actual SQL statement to the listener log. That should tell you where it is trying create the index. Now technically, having a unique index on the _id field is not required in Informix. The listener does it to be Mongo compatible. So if you don't really care about that index, you don't have to recreate it. However, you should still resolve the underlying error because otherwise you'll run into it again. Thanks, Erika

HI, Erika, Thanks for the info. This error was from mongo shell, -310 Table table-name already exists in database. This two errors were from jsonlistener log, -212 Cannot add index. -130 ISAM error: no such dbspace. The above three errors do not make any sense to me. The first error was telling table already exists, NOT true. The second and third error said no such dbspace. What dbspace did it want ? I attached the configuration about SB spaces, also onstat -d ( you can have a check what else needed). The SQL who complained is in the log of jsonlistener ( see log) Thanks Frank ========================== (1) mongo output mongos> db.createCollection("my_collection_4"); { "code" : null, "ok" : 0, "errmsg" : "Unable to create table 'my_collection_4' for namespace 'noaa.my_collection_4' | Table (informix.my_collection_4) already exists in database. (SQL Code: -310, SQL State: S0001)" } mongos> (2) SB spaces configurations SBSPACENAME dwsbdata00 SYSSBSPACENAME dwsbdata00 CDR_QDATA_SBSPACE ifx_qdatasbspace2 (3) output of onstat -d [informix@maggie json]$ onstat -d IBM Informix Dynamic Server Version 12.10.FC4W1XU -- On-Line -- Up 00:11:17 -- 5946620 KbytesDbspaces address number flags fchunk nchunks pgsize flags owner name 4d416028 1 0x70001 1 1 2048 N BA informix rootdbs 4e9aa7c8 2 0x70001 2 1 2048 N BA informix dwphylog 4e9aa9f8 3 0x60001 3 1 2048 N BA informix dwlog1 4e9aac28 4 0x60001 4 1 2048 N BA informix dwlog2 4e9ab028 5 0x60001 5 1 2048 N BA informix dwdata00 4e9ab258 6 0x68001 6 1 2048 N SBA informix dwsbdata00 4e9ab488 7 0x68001 7 1 2048 N SBA informix ifx_qdatasbspace1 4e9ab6b8 8 0x68001 8 1 2048 N SBA informix ifx_qdatasbspace2 4e9ab8e8 9 0x60001 9 1 2048 N BA informix ifx_cdrdbs1 4e9abb18 10 0x42001 10 1 2048 N TBA informix dwtemp1 4e9abd48 11 0x42001 11 1 2048 N TBA informix dwtemp2 4e9ad028 12 0x42001 12 1 2048 N TBA informix dwtemp3 12 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 4d416258 1 1 0 950000 928159 PO-B-- /usr/informix/dev-links/nsofopsdw/dwroot_ops 4e9ad258 2 2 0 2000000 999947 PO-B-- /usr/informix/dev-links/nsofopsdw/dwphylog_ops 4e9ae028 3 3 0 5000000 249947 PO-B-- /usr/informix/dev-links/nsofopsdw/dwlog1_ops 4e9af028 4 4 0 5000000 249947 PO-B-- /usr/informix/dev-links/nsofopsdw/dwlog2_ops 4e9b0028 5 5 0 5000000 4995965 PO-B-- /usr/informix/dev-links/nsofopsdw/dwdata00_ops 4e9b1028 6 6 0 5000000 4663292 4663405 POSB-- /usr/informix/dev-links/nsofopsdw/dwsbdata00_ops Metadata 336542 250429 336542 4e9b2028 7 7 0 7124992 6645376 6645376 POSB-- /dbbackup/dbs-link/jsondb/jsondb1 Metadata 479563 356854 479563 4e9b3028 8 8 0 7124992 6645375 6645376 POSB-- /dbbackup/dbs-link/jsondb/nsofopsjson_tcp_ifx_qdatasbspace2_p_1 Metadata 479563 356854 479563 4e9b4028 9 9 0 102400 96597 PO-BE- /dbbackup/dbs-link/jsondb/nsofopsjson_tcp_ifx_cdrdbs1_p_1 4e9b5028 10 10 0 3000000 2999947 PO-B-- /usr/informix/dev-links/nsofopsdw/dwtemp1_ops 4e9b6028 11 11 0 3000000 2999947 PO-B-- /usr/informix/dev-links/nsofopsdw/dwtemp2_ops 4e9b7028 12 12 0 3000000 2999947 PO-B-- /usr/informix/dev-links/nsofopsdw/dwtemp3_ops 12 active, 32766 maximum NOTE: The values in the "size" and "free" columns for DBspace chunks are displayed in terms of "pgsize" of the DBspace to which they belong. Expanded chunk capacity mode: always (4) log of Jsonlistener [informix@maggie json]$ tail -f jsonlisten.log 2015-03-23 16:53:42 [JsonListener-1] INFO com.ibm.nosql.informix.server.mongo.MongoListener - JSON server listening on port: 9170, 0.0.0.0/0.0.0.0 2015-03-23 16:54:10 [JsonListener-1] INFO com.ibm.nosql.informix.server.mongo.MongoListener - connection accepted from /127.0.0.1:48264 2015-03-23 16:54:10 [JsonListener-1-thread-1] INFO com.ibm.nosql.informix.server.mongo.MongoListenerMessageHandler - connection accepted from: 127.0.0.1:48264 , sessionNumer: 1 , listenerNumber: 8 2015-03-23 16:55:45 [JsonListener-1-thread-1] ERROR Session-1 - SQLCODE: -212 Cannot add index. 2015-03-23 16:55:45 [JsonListener-1-thread-1] ERROR Session-1 - Unable to create index _id_ for namespace noaa.my_collection_4 on table my_collection_4 with specification { "v" : 1 , "key" : { "_id" : [ 1 ,"$string" ] } , "ns" : "noaa.my_collection_4" , "name" : "_id_" , "unique" : true , "index" : "my_collection_4__id_" } | Cannot add index. (SQL Code: -212, SQL State: IX000) | ISAM error: no such DBspace (SQL Code: -130, SQL State: IX000) java.sql.SQLException: Cannot add index. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408) at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3132) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3412) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2325) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2250) at com.informix.jdbc.IfxSqli.sendStatementExecute(IfxSqli.java:1321) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2180) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2133) at com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:363) at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1144) at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1120) at com.informix.jdbc.IfxStatement.executeBody(IfxStatement.java:866) at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:784) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createIndex(InformixColl ectionUtils.java:1306) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createIndexOnIdField(Inf ormixCollectionUtils.java:1173) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createCollection(Informi xCollectionUtils.java:153) at com.ibm.nosql.informix.internal.InformixCollectionUtils.createCollection(Informi xCollectionUtils.java:107) at com.ibm.nosql.informix.internal.command.administration.CreateCommand.process(Cre ateCommand.java:39) at com.ibm.nosql.informix.internal.command.CommandRegistry.process(CommandRegistry. java:214) at com.ibm.nosql.informix.internal.request.InformixRequestHandler.processCommand(In formixRequestHandler.java:498) at com.ibm.nosql.informix.internal.request.InformixRequestHandler.processQuery(Info rmixRequestHandler.java:478) at com.ibm.nosql.informix.internal.request.QueryRequest.process(QueryRequest.java:2 50) at com.ibm.nosql.informix.server.mongo.MongoListenerMessageHandler.handleMessage(Mo ngoListenerMessageHandler.java:305) at com.ibm.nosql.informix.server.mongo.MongoListenerMessageHandler.run(MongoListene rMessageHandler.java:128) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)