JZ006: Caught IOException: java.net.SocketException: Broken pipe

[Cristi]

Hi everybody.
I am using one of the latest version of JConnect (but i guess the problem is
in ASE)

After about 100 consecutive inserts I get an IOException:
java.net.SocketException: Broken pipe.

PLEASE take time to read the following and give me a hint.

10x a lot. Cristi

================================================================
This is the the stack trace from my java application:

java.sql.SQLException: JZ006: Caught IOException: java.net.SocketException:
Broken pipe: Broken pipe
at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
at com.sybase.tds.Tds.nextResult(Tds.java)
at com.sybase.tds.Tds.getCancel(Tds.java)
at com.sybase.tds.Tds.cancel(Tds.java)
at com.sybase.jdbc.SybStatement.doCancel(SybStatement.java)
at com.sybase.jdbc.SybStatement.updateLoop(SybStatement.java)
at com.sybase.jdbc.SybStatement.executeUpdate(SybStatement.java)
at
com.sybase.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java
)
at MyClass.insertData(Myclass.java:400)

And ASE log shows:

00:00000:00016:2000/11/23 12:20:59.45 server Error: 2628, Severity: 21,
State: 1
00:00000:00016:2000/11/23 12:20:59.45 server In database 'db1', page 2443
is linked forward to page 2444, but that page is linked backward to page
2444. Please report this internal error to Sybase Technical Support.
00:00000:00016:2000/11/23 12:20:59.45 kernel
************************************
00:00000:00016:2000/11/23 12:20:59.45 kernel SQL causing error : xQ6Tjx
XBaSW4cIOm90y1fxjf/AhSAJTabd1m4yQ6PVMzpXqqyAouvuymkFhIYnsxGoeNXf5MGW')ģ
00:00000:00016:2000/11/23 12:20:59.45 kernel
************************************
00:00000:00016:2000/11/23 12:20:59.45 server SQL Text: xQ6Tjx
XBaSW4cIOm90y1fxjf/AhSAJTabd1m4yQ6PVMzpXqqyAouvuymkFhIYnsxGoeNXf5MGW')ģ
00:00000:00016:2000/11/23 12:20:59.45 kernel curdb = 5 pstat = 0x10100
lasterror = 2628
00:00000:00016:2000/11/23 12:20:59.45 kernel preverror = 0 transtate = 0
00:00000:00016:2000/11/23 12:20:59.45 kernel curcmd = 195 program =
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x8428543
ucbacktrace+0x67(0x0,0x1,0x86d035c,0x15,0x1c)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x80afac5
terminate_process+0x7b5(0x0,0xffffffff,0x86d035c,0x410b7cb4,0x80e2c9a)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x80e2ce5
close_network+0x19(0x86d035c,0x4100e840,0x1a,0x410b7d28,0x8293881)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x80e2c9a
hdl_default+0x4a(0x1a,0x1c,0x15,0x1,0x410b7d6c)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x8293881
s_handle+0xc79(0x1a,0x1c,0x15,0x1,0x410b7d6c)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x80e2ad1
ex_raise+0x299(0x1a,0x1c,0x15,0x1,0x2)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x819dba9
gcc2_compiled.+0x15d(0x410b83ec,0x86d035c,0x410b8550,0x414a4ec0,0x0)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x81bca99
gcc2_compiled.+0x1f5(0x410b8490,0x86d035c,0x410b898c,0x410b90a8,0x800)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x81d22ac
gcc2_compiled.+0x440(0x410b8944,0x410b90a8,0x410b898c,0x410b90a8,0x41b8dfc8)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x81bed4c
insert_index_row+0x114(0x414a4ec0,0xc,0x410b935c,0x410b90a8,0x41b8dfc8)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x81bf53d
ncupdate+0x235(0x414a4ec0,0x4253af58,0x410b935c,0x41b8dfc8,0x21)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x81be4c8
insert+0x2c0(0x414a4ec0,0x41b8dfc8,0x21,0x86d035c,0x0)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x81be1fe
gcc2_compiled.+0xba(0x4,0x41bb2418,0x414a4ec0,0x41b8dfc8,0x21)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x8336de2
gcc2_compiled.+0x571a(0x41bb2418,0x41bf2438,0x86d035c,0x1,0x41bb2688)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x830fea6
exec_eop+0xe8a(0x41bb2418,0x41bf2438,0x410bb3f8,0x86d035c,0x41bb2418)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x830f5bb
exec_eop+0x59f(0x41bb2418,0x41bb2688,0x410bb3f8,0x41bb2418,0x0)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x830ec29
gcc2_compiled.+0x795(0x41bb23a0,0x41bb2418,0xc3,0x410bb3f8,0x86d035c)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x8104233
ex_cleanup(0x86d035c,0x0,0x416319d0,0x0,0x1)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x8290d1d
gcc2_compiled.+0xba1(0x41bef800,0x86d035c,0x0,0x21,0x418c1d59)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x8104233
ex_cleanup(0x1,0x0,0x0,0x0,0x0)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x80ce1b4
conn_hdlr+0x20d4(0x8,0x410bb6fc,0xd285ed31,0x0,0x5374616b)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0x8104233
ex_cleanup(0x0,0x5374616b,0x0,0x0,0x0)
00:00000:00016:2000/11/23 12:20:59.45 kernel pc 0xd285ed31
gcc2_compiled.+0xca317319(0x0,0x0,0x0,0x0,0x0)
00:00000:00016:2000/11/23 12:20:59.45 kernel end of stack trace, spid 16,
kpid 136183818, suid 1

[Cristi]

I guess that there can be more causes for that 'Broken pipe' problem.

But (maybe this helps somebody) I got rid of it after I reindexed the table
in which the problem appeared,
and it seems to be OK now. ( I knew the table, because the problem appeared
just when trying to insert in that table).

Cristi

Cristi <bcr...@innovative.west.ro> wrote in message
news:mI3cpUT...@forums.sybase.com...

> XBaSW4cIOm90y1fxjf/AhSAJTabd1m4yQ6PVMzpXqqyAouvuymkFhIYnsxGoeNXf5MGW')ě

> 00:00000:00016:2000/11/23 12:20:59.45 kernel
> ************************************
> 00:00000:00016:2000/11/23 12:20:59.45 server SQL Text: xQ6Tjx

> XBaSW4cIOm90y1fxjf/AhSAJTabd1m4yQ6PVMzpXqqyAouvuymkFhIYnsxGoeNXf5MGW')ě

[Lance.A...@sun.com]

YOur issue is due to database corruption. Go to a backup
or work with Sybase Tech Support to address your issue.

Regards,
Lance