Skip to Content
avatar image
Former Member

Failed to Convert to Multiplex

I am running IQ 16 SP08 on Windows server 2008 64bit. I just tried to add secondary node using SCC and got following error. It says "failed to run Dbbackup command". Details of the log is below.

When I try again, now I get a different error which I attached as an image file

2016-04-17 21:31:32,439 Connected to agent host=dwiq6;port=9999;user=uafadmin INFO client.IQAgentConnectionManager scc-ui-13717 2016-04-17 21:31:32,441 Looking for versions of plug-in com.sybase.ua.plugins.iqap... INFO validator.IQAgentValidator scc-ui-13717 2016-04-17 21:31:32,458 Found 1 IQAP versions: [3.3.0] INFO validator.IQAgentValidator scc-ui-13717 2016-04-17 21:31:32,459 Looking for instance numbers of plug-in com.sybase.ua.plugins.iqap/3.3.0... INFO validator.IQAgentValidator scc-ui-13717 2016-04-17 21:31:32,459 Found 1 instances of com.sybase.ua.plugins.iqap/3.3.0 INFO validator.IQAgentValidator scc-ui-13717 2016-04-17 21:31:32,707 Connected to agent host=dwiq6;port=9999;user=uafadmin INFO client.IQAgentConnectionManager scc-ui-13717 2016-04-17 21:32:26,825 Disconnected SCC agent host=localhost;port=9999;user=uafadmin. INFO client.IQAgentConnectionManager scc-ui-13744 2016-04-17 21:32:26,825 Reconnecting to agent host=localhost;port=9999;user=uafadmin INFO client.IQAgentConnectionManager scc-ui-13744 2016-04-17 21:32:27,059 Connected to agent host=localhost;port=9999;user=uafadmin INFO client.IQAgentConnectionManager scc-ui-13744 2016-04-17 21:32:27,059 Successfully reconnected to agent host=localhost;port=9999;user=uafadmin INFO client.IQAgentConnectionManager scc-ui-13744 2016-04-17 21:32:27,072 {encryptionKey=null, port=2660, host=localhost, cset=, login=DBA, hostPortPairs=localhost:2660, language=, serverName=null, password=sql, database=c:\iqdatabase\iqprod.db} INFO util.IQAPUtils scc-ui-13744 2016-04-17 21:32:27,094 Adding node dwiqprod6 (dwiq6:2661)... INFO iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:32:27,094 Connecting to coordinator localhost:2660... INFO iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:32:27,461 Connected to coordinator server localhost:2660. INFO iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:32:27,659 Is coordinator simplex? true INFO iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:32:27,659 Executing create multiplex server DDL... INFO iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:32:28,750 Adding a secondary node to a simplex server automatically converts the simplex to a multiplex coordinator, then shuts down the new multiplex coordinator. INFO iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:32:28,751 Waiting for coordinator localhost:2660's port to be released before restarting it. This may take a while... INFO iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:32:44,137 Connected to agent host=localhost;port=9999;user=uafadmin INFO client.IQAgentConnectionManager RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:32:44,140 Starting up coordinator localhost:2660... INFO iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:32:44,167 Waiting for port 2660 to be available... INFO iqap.IQCmdLineHelper RMI TCP Connection(182518)-127.0.0.1 2016-04-17 21:34:08,559 Coordinator localhost:2660 restarted. INFO iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:36:08,565 Running dbbackup on secondary node dwiq6:2661... INFO iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:36:08,916 Connected to agent host=dwiq6;port=9999;user=uafadmin INFO client.IQAgentConnectionManager RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:36:15,988 Failed to run dbbackup on secondary node dwiq6:2661. Command exit value: 9. ERROR iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:36:15,989 Failed to add 1 nodes. WARN iqap.IQAgentPlugin RMI TCP Connection(182513)-127.0.0.1 2016-04-17 21:49:26,132 Connected to agent host=dwiq6;port=9999;user=uafadmin INFO client.IQAgentConnectionManager scc-ui-13732 2016-04-17 21:49:26,132 Looking for versions of plug-in com.sybase.ua.plugins.iqap... INFO validator.IQAgentValidator scc-ui-13732 2016-04-17 21:49:26,148 Found 1 IQAP versions: [3.3.0] INFO validator.IQAgentValidator scc-ui-13732 2016-04-17 21:49:26,148 Looking for instance numbers of plug-in com.sybase.ua.plugins.iqap/3.3.0... INFO validator.IQAgentValidator scc-ui-13732 2016-04-17 21:49:26,148 Found 1 instances of com.sybase.ua.plugins.iqap/3.3.0 INFO validator.IQAgentValidator scc-ui-13732 2016-04-17 21:54:01,416 Connected to agent host=dwiq6;port=9999;user=uafadmin INFO client.IQAgentConnectionManager

scc-ui-13727

node_error.png (27.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 19, 2016 at 02:19 AM

    Hi,

    The server shuts down to re-initialize the server as a multiplex coordinator. (As a normal part of this shutdown, when the first secondary node is created, Interactive SQL may return a disconnected (-308) error that requires no corrective action.)

    SyBooks Online

    So you make sure that coordinator is running.

    Are there any error logs in agent log file?

    Here is a way to create multiplex with command.

    http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01839.1604/doc/html/san1278444337748.html

    ---

    Gi-Sung Jang

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Mark Mumy

      Yes Mark. I can ping each other just fine with IP or DNS Names. I can also telnet to agent port successfully. As you can see from Agent Log, coordinator node is able to communicate with secondary node just fine and fails at dbbackup command.

      It looks like multiplex was created but not working properly.

      Below is the output of 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,rlvstore

      1,'iqprod05',host=10.14.7.129:2660,C:\\IQDatabase\\iqprod.db,'coordinator','included','coordinator','N/A','dwiqprod6',0,,,'active','active','disabled'

      2,'dwiqprod6',host=dwiq6:2661,c:\\iqdatabase\\iqprod.db,'writer','included','unknown','timed out','dwiqprod6',0,,,'not responding','not responding','disabled'