cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase IQ error "Found server but communication error occurred"

0 Kudos

Hi Everybody,

I had a problem with my IQ server 15.4.0.3046/ESD 5,  When my IQ server is working fine, suddenly no accepts new connections  and shows the follow message:

"Found server but communication error occurred"

And the active connections on the server IQ did not respond anymore

When, I test the conectivity, ping works fine and I be able to connect with ssh to server box. If at the server command prompt when I try to connect with dbisql -c "uid=xxx;pwd=xxx,eng=xxx" -nogui  this command appears like hang and it did not can connect to server.

The iqmsg does not  show any error and the server message log shows only the follow messages:

I. 04/17 10:32:53.

  4695483 records were inserted into 'sa_mi_arm_CircuitResolutionCheck_IC'.

I. 04/17 10:36:33. Connection terminated abnormally; client socket shut down

I. 04/17 10:36:33. Disconnected TCPIP client's AppInfo: IP=172.18.53.3;HOST=SISBER1PUPX07;OSUSER=ejaramillo;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:\Sybase\Shared\Sybase Central 6.0.0\win32\scjview.exe';PID=0x1cac;THREAD=0x198;VERSION=11.0.1.6056;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300

I. 04/17 10:59:02. Disconnecting Client - 2000 seconds since last contact

I. 04/17 10:59:02. Disconnected TCPIP client's AppInfo: IP=172.18.55.3;HOST=SISBER1PMGR07;OSUSER=wiza;OS='Windows 7 Build 7601 Service Pack 1';EXE=C:\Sybase\DBISQL\bin\dbisql.exe;PID=0x1860;THREAD=0x4084;VERSION=11.0.1.6056;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300

I. 04/17 10:59:02. Disconnecting Client - 2000 seconds since last contact

I. 04/17 10:59:02. Disconnected TCPIP client's AppInfo: IP=172.18.81.101;HOST=SISINQ1PSGIF29;OSUSER=magallardoc;OS='Windows 7 Build 7600 ';EXE=C:\Sybase_iq15\DBISQL\bin\dbisql.exe;PID=0x1134;THREAD=0x2644;VERSION=11.0.1.6056;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300

I. 04/17 10:59:35. Connection terminated abnormally

I. 04/17 10:59:35. Disconnected SharedMemory client's AppInfo: IP=172.18.220.33;HOST=uiobddwh01;OSUSER=sybase;OS='SunOS 5.10 Generic_150400-16 ';EXE=/sybase/shared/JRE-6_0_24/bin/sparcv9/java;PID=0x626;THREAD=0x24;VERSION=12.0.1.3046;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300

I. 04/17 11:00:47. Disconnecting Client - 2000 seconds since last contact

Do you have any idea about this issue, what is happened here?

Best regards

Jairo

Accepted Solutions (0)

Answers (1)

Answers (1)

Gisung
Advisor
Advisor
0 Kudos

Hi,

If you specify the -z option in cfg file, you can get the more detail messages.

-z iqsrv15 server option

Displays diagnostic communication messages, and other messages, for troubleshooting purposes.

SyBooks Online

And please check the listener threads in pstack or procstack like below.

If There is no listener thread like "StreamServer::listener()", It means that listener thread died.

==

Gi-Sung Jang