[IQUG] Sybase IQ 15.4: many inc_rpcEndpoint::SendRPCResult: Errors

Rey reywang at optonline.net
Tue Sep 16 10:55:26 MST 2014


This shows "not responding" which indicates there is not Private Network 
setup in your MPX.
Are you recently migrated over to Linux 15.4 ESD 4.2 here?

On 09/16/2014 12:29 PM, Michael Keller wrote:
> Hello
>
>
> Do all nodes have same IQ .cfg setup, such network packet setting -p 16000?
> The params.cfg setup are the same, only -iqmc and -iqtc are set for the RAM to each server
>
> -p is default (7000?)
>
> Can you post "select * from sp_iqmpxinfo()"?
>
> server_id,server_name,connection_info,db_path,role,status,mpx_mode,inc_state,coordinator_failover,current_version,active_versions,private_connection_info,mipc_priv_state,mipc_public_state
> 1,'m83u_dev',host=172.19.117.53:2638,epdwh07-i.schlund.de:2638,epdwh07-i:2638,/var/sybase/m83u_dev_b/db/m83u_dev.db,'coordinator','included','coordinator','N/A','mpx03',0,,,'not responding','active'
> 2,'mpx02',host=172.19.117.24:2638,/var/sybase/db/m83u_dev.db,'writer','included','writer','N/A','mpx03',0,,,'not responding','active'
> 3,'mpx01',host=172.19.117.23:2638,/var/sybase/db/m83u_dev.db,'writer','included','writer','active','mpx03',0,,,'active','active'
> 4,'mpx03',host=172.19.117.49:2638,/var/sybase/db/m83u_dev.db,'writer','included','writer','N/A','mpx03',0,,,'not responding','active'
> 6,'mpx05',host=172.19.117.45:2638,/var/sybase/db/m83u_dev.db,'writer','included','writer','N/A','mpx03',0,,,'not responding','active'
> 7,'mpx08',host=172.19.117.166:2638,/var/sybase/db/m83u_dev.db,'writer','included','writer','N/A','mpx03',0,,,'not responding','active'
> 8,'mpx06',host=172.19.117.54:2638,/var/sybase/db/m83u_dev.db,'writer','included','writer','N/A','mpx03',0,,,'not responding','active'
>
> -----Ursprüngliche Nachricht-----
> Von: Rey [mailto:reywang at optonline.net]
> Gesendet: Dienstag, 16. September 2014 17:55
> An: Michael Keller; pari dhanapaul; iqug at iqug.org
> Betreff: Re: [IQUG] Sybase IQ 15.4: many inc_rpcEndpoint::SendRPCResult: Errors
>
> Do all nodes have same IQ .cfg setup, such network packet setting -p 16000?
>
> Can you post "select * from sp_iqmpxinfo()"?
>
>
> On 09/16/2014 11:02 AM, Michael Keller wrote:
>> Hello
>>
>> Hm
>>>> With 5 writers it seems the application is behaving like a transactional system. Its best to avoid using it like this.
>> no, we need to let approx through 4000 ETLs. 4 Writers are just enough with 6 we have buffer for longer queries of our frontends
>>
>> RLV is not helpful for us.
>>
>> Mfg
>> Michael Keller
>>
>>
>> -----Ursprüngliche Nachricht-----
>> Von: pari dhanapaul [mailto:pari2013 at yahoo.com]
>> Gesendet: Dienstag, 16. September 2014 16:54
>> An: iqug at iqug.org; Michael Keller
>> Cc: Michael Keller
>> Betreff: Re: [IQUG] Sybase IQ 15.4: many inc_rpcEndpoint::SendRPCResult: Errors
>>
>> With 5 writers it seems the application is behaving like a transactional system. Its best to avoid using it like this.
>>
>> However you might be able to move to IQ 16.0 and use RLV with multiplexing support if you have such requirements.
>>
>>
>> --------------------------------------------
>> On Tue, 9/16/14, Michael Keller <michael.keller at 1und1.de> wrote:
>>
>>    Subject: [IQUG] Sybase IQ 15.4: many inc_rpcEndpoint::SendRPCResult: Errors
>>    To: "iqug at iqug.org" <iqug at iqug.org>
>>    Cc: "Michael Keller" <michael.keller at 1und1.de>
>>    Date: Tuesday, September 16, 2014, 6:49 AM
>>    
>>    
>>    
>>     
>>     
>>    
>>    
>>    
>>    
>>    Hello
>>       
>>    We have
>>    a IQ 15.4 ESD3 Multiplex with one coordinator and 5 writer  servers.
>>    Now we
>>    get many errors from INC Connect on all my writers and  coordinator.
>>    
>>      
>>    inc_rpcEndpoint::SendRPCResult:
>>    …………….
>>    
>>    I.
>>    09/16 12:25:01. 0000000000 inc_rpcEndpoint::SendRPCResult:
>>    Sending result set failed
>>    I.
>>    09/16 12:25:01. 0000000000 inc_rpcEndpoint::SendRPCResult:
>>    Sending result set failed
>>    I.
>>    09/16 12:25:05. 0000000000 inc_rpcEndpoint::SendRPCResult:
>>    Sending result set failed
>>    I.
>>    09/16 12:25:05. 0000000000 inc_rpcEndpoint::SendRPCResult:
>>    Sending result set failed
>>    I.
>>    09/16 12:25:12. 0000000000 inc_rpcEndpoint::SendRPCResult:
>>    Sending result set failed
>>    I.
>>    09/16 12:25:12. 0000000000 inc_rpcEndpoint::SendRPCResult:
>>    Sending result set failed
>>    I.
>>    09/16 12:25:14. 0000000000 inc_rpcEndpoint::SendRPCResult:
>>    Sending result set failed
>>    …………
>>    
>>      
>>    We can
>>    see this in all iqmsg files on all mpx writers
>>    
>>      
>>    what
>>    this means error?
>>    and how
>>    can you fix this?
>>    
>>      
>>    Regards
>>    Michael
>>    Keller
>>    
>>      
>>    
>>    
>>    
>>    -----Inline Attachment Follows-----
>>    
>>    _______________________________________________
>>    IQUG mailing list
>>    IQUG at iqug.org
>>    http://iqug.org/mailman/listinfo/iqug
>> _______________________________________________
>> IQUG mailing list
>> IQUG at iqug.org
>> http://iqug.org/mailman/listinfo/iqug
> _______________________________________________
> IQUG mailing list
> IQUG at iqug.org
> http://iqug.org/mailman/listinfo/iqug




More information about the IQUG mailing list