[Sqlrelay-discussion] Weird connection problem
Brought to you by:
mused
Menu
▾
▴
[Sqlrelay-discussion] Weird connection problem
|
From: Freako F. F. <fr...@dr...> - 2011-10-25 14:10:34
|
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font face="serif">I just installed the latest sqlrelay version but
i'm now facing a strange issue when using it.<br>
<br>
I start the sqlr stack normaly trough the init script (ubuntu
server).<br>
<br>
I can then connect through sqlrsh ... no problems yet.<br>
running ping, dbversion, clientversion works normally.<br>
<br>
running serverversion segfaults. <br>
<br>
but the strangest thing is when running a query ...it freezes the
shell, however uppon inspecting the connection's debug file i see
that query gets executed <br>
<br>
any ideas on where to start looking for misconfiguration or bug ?<br>
<br>
DB is Oracle 11g<br>
<br>
pasting a part of connection's debug log<br>
<br>
10/25/2011 16:05:23 CEST connection [28218] : new query<br>
10/25/2011 16:05:23 CEST connection [28218] : handling
query...<br>
10/25/2011 16:05:23 CEST connection [28218] : getting
query...<br>
10/25/2011 16:05:23 CEST connection [28218] :
querylength:<br>
18<br>
10/25/2011 16:05:23 CEST connection [28218] : query:<br>
10/25/2011 16:05:23 CEST connection [28218] : select 1 from dual<br>
10/25/2011 16:05:23 CEST connection [28218] : getting
query succeeded<br>
10/25/2011 16:05:23 CEST connection [28218] : getting
input binds...<br>
10/25/2011 16:05:23 CEST connection [28218] : done getting
input binds<br>
10/25/2011 16:05:23 CEST connection [28218] : getting
output binds...<br>
10/25/2011 16:05:23 CEST connection [28218] : done getting
output binds<br>
10/25/2011 16:05:23 CEST connection [28218] : getting send
column info...<br>
10/25/2011 16:05:23 CEST connection [28218] : send
column info<br>
10/25/2011 16:05:23 CEST connection [28218] : done getting
send column info...<br>
10/25/2011 16:05:23 CEST connection [28218] : processing
query...<br>
10/25/2011 16:05:23 CEST connection [28218] :
preparing/executing...<br>
10/25/2011 16:05:23 CEST connection [28218] : commit or
rollback check...<br>
10/25/2011 16:05:23 CEST connection [28218] : done with
commit or rollback check<br>
10/25/2011 16:05:23 CEST connection [28218] : processing
query succeeded<br>
10/25/2011 16:05:23 CEST connection [28218] : done
processing query<br>
10/25/2011 16:05:23 CEST connection [28218] : returning
result set header...<br>
10/25/2011 16:05:23 CEST connection [28218] :
returning row counts...<br>
10/25/2011 16:05:23 CEST connection [28218] : sending row
counts...<br>
10/25/2011 16:05:23 CEST connection [28218] : actual
rows unknown<br>
10/25/2011 16:05:23 CEST connection [28218] : affected
rows: 0<br>
10/25/2011 16:05:23 CEST connection [28218] : done sending
row counts<br>
10/25/2011 16:05:23 CEST connection [28218] : done
returning row counts<br>
10/25/2011 16:05:23 CEST connection [28218] : column
info will be sent<br>
10/25/2011 16:05:23 CEST connection [28218] :
returning column counts...<br>
10/25/2011 16:05:23 CEST connection [28218] : done
returning column counts<br>
10/25/2011 16:05:23 CEST connection [28218] : sending
column type format...<br>
10/25/2011 16:05:23 CEST connection [28218] : id's<br>
10/25/2011 16:05:23 CEST connection [28218] : done sending
column type format<br>
10/25/2011 16:05:23 CEST connection [28218] :
returning column info...<br>
10/25/2011 16:05:23 CEST connection [28218] : 1:48:2
(0,129) <br>
10/25/2011 16:05:23 CEST connection [28218] : done
returning column info<br>
10/25/2011 16:05:23 CEST connection [28218] : returning
output bind values<br>
0<br>
10/25/2011 16:05:23 CEST connection [28218] : done
returning output bind values<br>
10/25/2011 16:05:23 CEST connection [28218] : done
returning result set header<br>
10/25/2011 16:05:23 CEST connection [28218] : handle query
succeeded<br>
10/25/2011 16:05:23 CEST connection [28218] : returning
result set data...<br>
10/25/2011 16:05:23 CEST connection [28218] : skipping 0
rows...<br>
10/25/2011 16:05:23 CEST connection [28218] : done
skipping rows<br>
10/25/2011 16:05:23 CEST connection [28218] : fetching 100
rows...<br>
<br>
</font>
</body>
</html>
|
