Tags: 2004gt, command, csm, database, err, error, followinggt, informix, listener-thread, log, mgt, muthana, mysql, online, onstat, oracle, shell, sql, thu, type, wrotegt

listener-thread: err = -408 (What is CSM?)

On Database » Informix

3,562 words with 0 Comments; publish: Sun, 25 May 2008 08:23:00 GMT; (25046.88, « »)

Muthana wrote:

> I found error in online.log when i type in shell command the following

> onstat m

> Thu May 27 08:06:29 2004

> 08:06:29 listener-thread: err = -408: oserr = 0: errstr = : Invalid

> message type received from the sqlexec process.

> Then I use the finderr to get more information about the error

> ----

--

> -408 Invalid message type received from the sqlexec process.

> This internal error indicates a problem in the communication

> between the database server and the library functions that call it.

> Make sure that your program software is compatible with the

> database engine in use.

> This error can also occur if the CSM option is enabled on the

> database server side but not on the client application side, or

> vice versa. If you want to use a CSM, make sure that the CSM option

> is set in the sqlhosts file for both the database server and client

> application.

> This error can also occur if the confidentiality option of the CSM

> is enabled on the database server side but not on the client

> application side, or vice versa. If you want to use the

> confidentiality option of the CSM, make sure that the

> confidentiality option is set for both the database server and

> client application. Check your sqlhosts file and CSS configuration

> file. If the error recurs, note all circumstances and contact

> Informix Technical Support.

> ----

--

> The followings are my circumstances

> IBM INFORMIX-SQL Version 7.31.UC3

> IBM INFORMIX-4GL Version 7.31.UC3

> IBM INFORMIX-4GL Version 9.30.UC3

Cut'n'paste is dangerous. There is no I4GL 9.30.UC3; there is an IDS

9.30.UC3 (and you should aim to upgrade to 9.30.UC7 or later).

> And in my sqlhosts the following is there:

> tuhhsrvpascal onsoctcp tuhhsrvpascal tuhhsrvpascal

> #demo_on onipcshm on_hostname on_servername

> #demo_se seipcpip se_hostname sqlexec

> My question what is the CSM and how can I fix the problem?

CSM is the Communication Services Module. It's the way of adding

extra goodies to the communication system between client and server.

Specifically, it is used to add encrypted communications in IDS 9.40,

but it also exists in earlier versions.

Given the one line entry in your sqlhosts file - CSM should not be

part of the issue.

In the ancient past, -408 was a serious problem; it meant that the

sqlexec or sqlturbo (from SE or OnLine - not IDS) had crashed.

Nowadays, it would mean that the server thread has died - not good,

but not common, either. You should look at the online message log to

see what's going on -- an ironic observation since that's what 'onstat

-m' is attempting to do anyway. However, you should do it by the

long-hand method - determine the file name and review what it says

with 'more' or 'less' or 'vim' or whatever.

[PS: Given your question is partly about 'what is CSM', you should

have included it in your subject line. Maybe 'How does CSM cause

error -408?']

Jonathan Leffler #include <disclaimer.h>

Email: jleffler.informix.questionfor.info.earthlink.net, jleffler.informix.questionfor.info.us.ibm.com

Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

All Comments

Leave a comment...

  • 0 Comments