[erlang-bugs] ODBC and Windows 2003 Anomaly

[Jan Jacobs]

More Feedback:

 

I managed to track down where in the odbc module it hangs.

 

It is in the handle_msg({connect, ODBCCmd, AutoCommitMode, SrollableCursors},  Timeout, State) 

function while doing the following call  gen_tcp:accept(ListenSocketSup, 5000).

 

I can execute odbc:connect as many times as I want and it works. It only hangs when I do an odbc:disconnect and odbc:connect .

 

Unfortunately debugging is a slow process because this is a customer's server. On my test server everything is working.

 

Cheers

Jan Jacobs

 

  ----- Original Message ----- 
  From: Jan Jacobs 
  To: erlang-bugs@REDACTED 
  Sent: Saturday, January 27, 2007 10:14 PM
  Subject: [erlang-bugs] ODBC and Windows 2003 Anomaly


  Hi All,

  I am experiencing an anomaly with erlang running the odbc application.

  Steps:
  I start the odbc application. 
  >application:start(odbc).

  Create a odbc connection to the databse. It works an the queries work.
  >f(Ref),{ok,Ref}=odbc:connect("DSN=example;UID=SYSDBA;PWD=masterkey",[]).

  Disconnect from the databse.
  >odbc:disconnect(Ref).

  Create a new connection. The erlang runtime hangs and the erlang process CPU runs away.
  >f(Ref),{ok,Ref}=odbc:connect("DSN=example;UID=SYSDBA;PWD=masterkey",[]).

  System Description:
  - Microsoft Windows Server 2003, Standard Edition and Service Pack 1.
  - Erlang 5.5.2 

  Summary:
  The weirdest thing I have an application the follows the same steps as above which works every time on Windows XP.
  From 10 Windows 2003 servers I have experience the problem three times already. 

  I am not sure if I am missing something. Any help will be appreciated.

  Thanks
  Jan Jacobs



------------------------------------------------------------------------------


  _______________________________________________
  erlang-bugs mailing list
  erlang-bugs@REDACTED
  http://www.erlang.org/mailman/listinfo/erlang-bugs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-bugs/attachments/20070131/e2ac4b16/attachment.htm>