Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

segmentation violation

3 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-07-30 21:58:48.0Z
Tuananh Nguyen Posted on 1997-06-12 15:03:03.0Z
Message-ID: <33A00FA7.524@MCI.Com>
Date: Thu, 12 Jun 1997 11:03:03 -0400
From: Tuananh Nguyen <Tuananh.Nguyen@MCI.Com>
Organization: CN Consulting, Inc.
X-Mailer: Mozilla 3.01Gold (Win95; I)
MIME-Version: 1.0
CC: Tuananh.Nguyen@MCI.Com
Subject: segmentation violation
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 282
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:698
Article PK: 252450

While testing I inserted the same record twice and I got a segmentation
violation and my program die.... death.... this is not good... Can
anyone help me!

Regards,
t.a.
-----------------------------------------------------------------
Tel: 919-572-3324
Fax: 919-572-3666
Pager: http://ipass.net/~cnci/Page-TA.html or 1680838@skymail.com
-----------------------------------------------------------------

------- start of messages -------------
Starting on port ==> 6700
Accessing DB ==> AP
Sybase jConnect (TM) for JDBC (TM) 2.1 Development and Unsupported
Version
It is an unsupported product and is not intended for deployment. It
does not include free technical support. You can purchase technical
support on an annual or pay-per-issue basis. Discussion Newsgroup is
available on www.sybase.com. For additional information on services or
run-time license, please check Sybase website or call 1-800-8-SYBASE or
+1-510-922-3500 outside of the USA and Canada.

Copyright 1997 Sybase, Inc.
All Rights Reserved
[APConnection@ee701a58, APConnection@ee703a78, APConnection@ee704368,
APConnection@ee704c58, APConnection@ee700d48]
Debug lpServer.accept( tid = null, transportable =
srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0],
connection = lpConnection@ee700d40 )
Debug lpServer.acceptTransaction( transaction =
srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0],
connection = lpConnection@ee700d40 )
Debug lpServer.transport( transaction =
LogTxClt[dst=LPLOG;src=AP;tid=null] )
Debug lpServer.activate( tRun =
lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]],
table = {} )
Debug lpServer.startTransaction( tRun =
lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]],
table = {} )
ERROR(lpRouter.route): unknown destination: LPLOG
Debug lpServer.transport: don't have a connection.
Debug lpServer.accept: activating new transaction -- tid =
DatabaseTestClient0
Debug lpServer.activate( tRun =
lpTransactionRunner[transaction=srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0];Q=[]],
table = {} )
Connection set APConnection@ee701a58
Debug lpServer.startTransaction( tRun =
lpTransactionRunner[transaction=srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0];Q=[]],
table = {} )
Debug lpServer.accept( tid = DatabaseTestClient0, transportable =
lpTransactionData[event=3;state=2], connection = lpConnection@ee700d40 )
Debug lpServer.acceptData( data = lpTransactionData[event=3;state=2],
tid = DatabaseTestClient0 )
---> NEWPVC 159.24.17.76,16,159.24.17.78,18,9922,2X2,tuananh,1,0,TA-Test
Data!,
---> DELPVC 159.24.17.76,16,159.24.17.78,18,9922,tuananh,null
---> update VCID set tuple_end_date = datediff(second, "Jan 1 1970
0:0:0", getdate()), data_source = "tuananh", data_source_date =
datediff(second, "Jan 1 1970 0:0:0", getdate()) where source_ip =
"159.24.17.76" and source_dlci = 16 and destination_ip = "159.24.17.78"
and destination_dlci = 18 and pvc_id = 9922
---> rowCount=0
---> deletePVC=false
---> insert into VCID values("159.24.17.76", 16, "159.24.17.78", 18,
datediff(second, "Jan 1 1970 0:0:0", getdate()), 2145830400, null, null,
null, 9922, "2X2", 1, 0, "tuananh", datediff(second, "Jan 1 1970 0:0:0",
getdate()), null, null, null)
---> rowcount=1
Debug lpServer.transport( transportable =
lpTransactionData[event=-5;state=-2], transaction =
srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0]
)
Debug lpServer.transport: sending lpTransactionData[event=-5;state=-2]
on tid:DatabaseTestClient0 to DatabaseTestClient
Debug lpServer.transport( transaction =
LogTxClt[dst=LPLOG;src=AP;tid=null] )
Debug lpServer.activate( tRun =
lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP1];Q=[]],
table =
{AP0=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]]}
)
Debug lpServer.startTransaction( tRun =
lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP1];Q=[]],
table =
{AP0=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]]}
)
ERROR(lpRouter.route): unknown destination: LPLOG
Debug lpServer.transport: don't have a connection.
Debug lpServer.kill( tid = DatabaseTestClient0 )
Debug lpServer.activateWaitingTransaction( queue = [], table = {} )
Debug lpServer.accept( tid = null, transportable =
srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0],
connection = lpConnection@ee701278 )
Debug lpServer.acceptTransaction( transaction =
srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0],
connection = lpConnection@ee701278 )
Debug lpServer.transport( transaction =
LogTxClt[dst=LPLOG;src=AP;tid=null] )
Debug lpServer.activate( tRun =
lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP2];Q=[]],
table =
{AP1=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP1];Q=[]],
AP0=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]]}
)
Debug lpServer.startTransaction( tRun =
lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP2];Q=[]],
table =
{AP1=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP1];Q=[]],
AP0=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]]}
)
ERROR(lpRouter.route): unknown destination: LPLOG
Debug lpServer.transport: don't have a connection.
Debug lpServer.accept: activating new transaction -- tid =
DatabaseTestClient0
Debug lpServer.activate( tRun =
lpTransactionRunner[transaction=srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0];Q=[]],
table = {} )
Connection set APConnection@ee701a58
Debug lpServer.startTransaction( tRun =
lpTransactionRunner[transaction=srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0];Q=[]],
table = {} )
Debug lpServer.accept( tid = DatabaseTestClient0, transportable =
lpTransactionData[event=3;state=2], connection = lpConnection@ee701278 )
Debug lpServer.acceptData( data = lpTransactionData[event=3;state=2],
tid = DatabaseTestClient0 )
---> NEWPVC 159.24.17.76,16,159.24.17.78,18,9922,2X2,tuananh,1,0,TA-Test
Data!,
---> DELPVC 159.24.17.76,16,159.24.17.78,18,9922,tuananh,null
---> update VCID set tuple_end_date = datediff(second, "Jan 1 1970
0:0:0", getdate()), data_source = "tuananh", data_source_date =
datediff(second, "Jan 1 1970 0:0:0", getdate()) where source_ip =
"159.24.17.76" and source_dlci = 16 and destination_ip = "159.24.17.78"
and destination_dlci = 18 and pvc_id = 9922
---> rowCount=1
---> deletePVC=true
---> insert into VCID values("159.24.17.76", 16, "159.24.17.78", 18,
datediff(second, "Jan 1 1970 0:0:0", getdate()), 2145830400, null, null,
null, 9922, "2X2", 1, 0, "tuananh", datediff(second, "Jan 1 1970 0:0:0",
getdate()), null, null, null)
jdbc.sql.SQLException: Attempt to overlap 'tuple_start_date -
tuple_end_date' interval for existing tuple: source_ip = 159.24.17.76
source_dlci = 16 destination_ip = 159.24.17.78 destination_dlci = 18.
Command has been aborted.
SIGSEGV 11* segmentation violation
si_signo [11]: SIGSEGV 11* segmentation violation
si_errno [0]: Error 0
si_code [1]: SEGV_ACCERR [addr: 0x0]

stackbase=EE2D2000, stackpointer=EE2D0DD0

Full thread dump:
"Thread-13" (TID:0xee702e48, sys_thread_t:0xee2d1de0) prio=5
*current thread*
java.lang.Throwable.printStackTrace(Throwable.java)
srvUpdateBilling.notifyEvent(srvUpdateBilling.java:128)
lpTransaction.dispatch(lpTransaction.java:247)
lpTransactionRunner.run(lpTransactionRunner.java:59)
java.lang.Thread.run(Thread.java)
"Thread-12" (TID:0xee704d40, sys_thread_t:0xee331de0) prio=5
java.lang.Object.wait(Object.java)
lpTransactionRunner.dequeueData(lpTransactionRunner.java:85)
lpTransactionRunner.run(lpTransactionRunner.java:56)
java.lang.Thread.run(Thread.java)
"Thread-11" (TID:0xee701b70, sys_thread_t:0xee391de0) prio=5
java.net.SocketInputStream.read(SocketInputStream.java:89)
java.net.SocketInputStream.read(SocketInputStream.java:105)
java.io.DataInputStream.readUnsignedShort(DataInputStream.java)
java.io.DataInputStream.readUTF(DataInputStream.java)
java.io.DataInputStream.readUTF(DataInputStream.java)
lpPacket.streamIn(lpPacket.java:65)
lpPacket.<init>(lpPacket.java:53)
lpConnection.processPacket(lpConnection.java:118)
lpConnection.run(lpConnection.java:84)
java.lang.Thread.run(Thread.java)
"Thread-9" (TID:0xee704990, sys_thread_t:0xee301de0) prio=5
java.lang.Object.wait(Object.java)
lpTransactionRunner.dequeueData(lpTransactionRunner.java:85)
lpTransactionRunner.run(lpTransactionRunner.java:56)
java.lang.Thread.run(Thread.java)
"Thread-7" (TID:0xee7049e0, sys_thread_t:0xee361de0) prio=5
java.lang.Object.wait(Object.java)
lpTransactionRunner.dequeueData(lpTransactionRunner.java:85)
lpTransactionRunner.run(lpTransactionRunner.java:56)
java.lang.Thread.run(Thread.java)
"Thread-4" (TID:0xee701298, sys_thread_t:0xee3c1de0) prio=5
java.net.PlainSocketImpl.accept(PlainSocketImpl.java:320)
java.net.ServerSocket.accept(ServerSocket.java:109)
lpRouter.listen(lpRouter.java:119)
lpRouter.run(lpRouter.java:172)
java.lang.Thread.run(Thread.java)
"Finalizer thread" (TID:0xee7003b0, sys_thread_t:0xee3f1de0) prio=1
"Async Garbage Collector" (TID:0xee700368, sys_thread_t:0xef441de0)
prio=1
"Idle thread" (TID:0xee700320, sys_thread_t:0xef471de0) prio=0
"clock handler" (TID:0xee7001f8, sys_thread_t:0xef551de0) prio=11
"main" (TID:0xee7000a0, sys_thread_t:0x83aa8) prio=5
Monitor Cache Dump:
unknown key (key=0xef441de0): unowned
Waiting to be notified:
"Async Garbage Collector"
srvUpdateBilling@EE700AE0/EE745F48 (key=0xee700ae0): monitor
owner: "Thread-13"
lpConnection@EE701278/EE745D80 (key=0xee701278): monitor owner:
"Thread-11"
lpTransactionRunner@EE7044A0/EE743C08 (key=0xee7044a0): unowned
Waiting to be notified:
"Thread-7"
lpTransactionRunner@EE704308/EE746E48 (key=0xee704308): unowned
Waiting to be notified:
"Thread-12"
java.net.PlainSocketImpl@EE702210/EE73D2C8 (key=0xee702210):
monitor owner: "Thread-4"
lpTransactionRunner@EE704158/EE745A20 (key=0xee704158): unowned
Waiting to be notified:
"Thread-9"
Registered Monitor Dump:
Finalize me queue lock: unowned
Waiting to be notified:
"Finalizer thread"
Thread queue lock: unowned
Waiting to be notified:
"main"
Class lock: unowned
Java stack lock: unowned
Code rewrite lock: unowned
Heap lock: unowned
Has finalization queue lock: unowned
Monitor IO lock: unowned
Child death monitor: unowned
Event monitor: unowned
I/O monitor: unowned
Alarm monitor: unowned
Waiting to be notified:
"clock handler"
Sbrk lock: unowned
Monitor cache lock: unowned
Monitor registry: monitor owner: "Thread-13"
Thread Alarm Q:
sys_thread_t 0xef441de0 [Timeout in 869 ms]
--------------- end of messages --------------


David Clegg Posted on 1997-07-30 21:58:48.0Z
Message-ID: <33DFB918.6F736918@sybase.com>
Date: Wed, 30 Jul 1997 14:58:48 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 3.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Tuananh Nguyen <Tuananh.Nguyen@MCI.Com>
Subject: Re: segmentation violation
References: <33A00FA7.524@MCI.Com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 21
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:426
Article PK: 252178

Some Java VM's choke on the names in the stackTrace from some
of the SQLExceptions which are thrown from the "obfuscated" Tds
package classes.

If this is the problem...
I don't know what to recommend except to get a new version of the
VM that doesn't fail in this way, or avoid using
SQLException.printStackTrace().

dave

Tuananh Nguyen wrote:
>
> While testing I inserted the same record twice and I got a segmentation
> violation and my program die.... death.... this is not good... Can
> anyone help me!
>
> Regards,
> t.a.
> -----------------------------------------------------------------
> Tel: 919-572-3324
> Fax: 919-572-3666
> Pager: http://ipass.net/~cnci/Page-TA.html or 1680838@skymail.com
> -----------------------------------------------------------------


Lance Andersen Posted on 1997-06-18 14:54:26.0Z
Message-ID: <33A7F6A2.187C@sybase.com>
Date: Wed, 18 Jun 1997 10:54:26 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Tuananh Nguyen <Tuananh.Nguyen@MCI.Com>
Subject: Re: segmentation violation
References: <33A00FA7.524@MCI.Com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 318
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:663
Article PK: 252415

If you can provide a simple test program demonstrating the
problem against pubs2 or have your application directly create
the table in question. that would be create.

thanks..

Tuananh Nguyen wrote:
>
> While testing I inserted the same record twice and I got a segmentation
> violation and my program die.... death.... this is not good... Can
> anyone help me!
>
> Regards,
> t.a.
> -----------------------------------------------------------------
> Tel: 919-572-3324
> Fax: 919-572-3666
> Pager: http://ipass.net/~cnci/Page-TA.html or 1680838@skymail.com
> -----------------------------------------------------------------
>
> ------- start of messages -------------
> Starting on port ==> 6700
> Accessing DB ==> AP
> Sybase jConnect (TM) for JDBC (TM) 2.1 Development and Unsupported
> Version
> It is an unsupported product and is not intended for deployment. It
> does not include free technical support. You can purchase technical
> support on an annual or pay-per-issue basis. Discussion Newsgroup is
> available on www.sybase.com. For additional information on services or
> run-time license, please check Sybase website or call 1-800-8-SYBASE or
> +1-510-922-3500 outside of the USA and Canada.
>
> Copyright 1997 Sybase, Inc.
> All Rights Reserved
> [APConnection@ee701a58, APConnection@ee703a78, APConnection@ee704368,
> APConnection@ee704c58, APConnection@ee700d48]
> Debug lpServer.accept( tid = null, transportable =
> srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0],
> connection = lpConnection@ee700d40 )
> Debug lpServer.acceptTransaction( transaction =
> srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0],
> connection = lpConnection@ee700d40 )
> Debug lpServer.transport( transaction =
> LogTxClt[dst=LPLOG;src=AP;tid=null] )
> Debug lpServer.activate( tRun =
> lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]],
> table = {} )
> Debug lpServer.startTransaction( tRun =
> lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]],
> table = {} )
> ERROR(lpRouter.route): unknown destination: LPLOG
> Debug lpServer.transport: don't have a connection.
> Debug lpServer.accept: activating new transaction -- tid =
> DatabaseTestClient0
> Debug lpServer.activate( tRun =
> lpTransactionRunner[transaction=srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0];Q=[]],
> table = {} )
> Connection set APConnection@ee701a58
> Debug lpServer.startTransaction( tRun =
> lpTransactionRunner[transaction=srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0];Q=[]],
> table = {} )
> Debug lpServer.accept( tid = DatabaseTestClient0, transportable =
> lpTransactionData[event=3;state=2], connection = lpConnection@ee700d40 )
> Debug lpServer.acceptData( data = lpTransactionData[event=3;state=2],
> tid = DatabaseTestClient0 )
> ---> NEWPVC 159.24.17.76,16,159.24.17.78,18,9922,2X2,tuananh,1,0,TA-Test
> Data!,
> ---> DELPVC 159.24.17.76,16,159.24.17.78,18,9922,tuananh,null
> ---> update VCID set tuple_end_date = datediff(second, "Jan 1 1970
> 0:0:0", getdate()), data_source = "tuananh", data_source_date =
> datediff(second, "Jan 1 1970 0:0:0", getdate()) where source_ip =
> "159.24.17.76" and source_dlci = 16 and destination_ip = "159.24.17.78"
> and destination_dlci = 18 and pvc_id = 9922
> ---> rowCount=0
> ---> deletePVC=false
> ---> insert into VCID values("159.24.17.76", 16, "159.24.17.78", 18,
> datediff(second, "Jan 1 1970 0:0:0", getdate()), 2145830400, null, null,
> null, 9922, "2X2", 1, 0, "tuananh", datediff(second, "Jan 1 1970 0:0:0",
> getdate()), null, null, null)
> ---> rowcount=1
> Debug lpServer.transport( transportable =
> lpTransactionData[event=-5;state=-2], transaction =
> srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0]
> )
> Debug lpServer.transport: sending lpTransactionData[event=-5;state=-2]
> on tid:DatabaseTestClient0 to DatabaseTestClient
> Debug lpServer.transport( transaction =
> LogTxClt[dst=LPLOG;src=AP;tid=null] )
> Debug lpServer.activate( tRun =
> lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP1];Q=[]],
> table =
> {AP0=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]]}
> )
> Debug lpServer.startTransaction( tRun =
> lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP1];Q=[]],
> table =
> {AP0=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]]}
> )
> ERROR(lpRouter.route): unknown destination: LPLOG
> Debug lpServer.transport: don't have a connection.
> Debug lpServer.kill( tid = DatabaseTestClient0 )
> Debug lpServer.activateWaitingTransaction( queue = [], table = {} )
> Debug lpServer.accept( tid = null, transportable =
> srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0],
> connection = lpConnection@ee701278 )
> Debug lpServer.acceptTransaction( transaction =
> srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0],
> connection = lpConnection@ee701278 )
> Debug lpServer.transport( transaction =
> LogTxClt[dst=LPLOG;src=AP;tid=null] )
> Debug lpServer.activate( tRun =
> lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP2];Q=[]],
> table =
> {AP1=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP1];Q=[]],
> AP0=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]]}
> )
> Debug lpServer.startTransaction( tRun =
> lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP2];Q=[]],
> table =
> {AP1=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP1];Q=[]],
> AP0=lpTransactionRunner[transaction=LogTxClt[dst=LPLOG;src=AP;tid=AP0];Q=[]]}
> )
> ERROR(lpRouter.route): unknown destination: LPLOG
> Debug lpServer.transport: don't have a connection.
> Debug lpServer.accept: activating new transaction -- tid =
> DatabaseTestClient0
> Debug lpServer.activate( tRun =
> lpTransactionRunner[transaction=srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0];Q=[]],
> table = {} )
> Connection set APConnection@ee701a58
> Debug lpServer.startTransaction( tRun =
> lpTransactionRunner[transaction=srvUpdateBilling[dst=DatabaseTestClient;src=AP;tid=DatabaseTestClient0];Q=[]],
> table = {} )
> Debug lpServer.accept( tid = DatabaseTestClient0, transportable =
> lpTransactionData[event=3;state=2], connection = lpConnection@ee701278 )
> Debug lpServer.acceptData( data = lpTransactionData[event=3;state=2],
> tid = DatabaseTestClient0 )
> ---> NEWPVC 159.24.17.76,16,159.24.17.78,18,9922,2X2,tuananh,1,0,TA-Test
> Data!,
> ---> DELPVC 159.24.17.76,16,159.24.17.78,18,9922,tuananh,null
> ---> update VCID set tuple_end_date = datediff(second, "Jan 1 1970
> 0:0:0", getdate()), data_source = "tuananh", data_source_date =
> datediff(second, "Jan 1 1970 0:0:0", getdate()) where source_ip =
> "159.24.17.76" and source_dlci = 16 and destination_ip = "159.24.17.78"
> and destination_dlci = 18 and pvc_id = 9922
> ---> rowCount=1
> ---> deletePVC=true
> ---> insert into VCID values("159.24.17.76", 16, "159.24.17.78", 18,
> datediff(second, "Jan 1 1970 0:0:0", getdate()), 2145830400, null, null,
> null, 9922, "2X2", 1, 0, "tuananh", datediff(second, "Jan 1 1970 0:0:0",
> getdate()), null, null, null)
> jdbc.sql.SQLException: Attempt to overlap 'tuple_start_date -
> tuple_end_date' interval for existing tuple: source_ip = 159.24.17.76
> source_dlci = 16 destination_ip = 159.24.17.78 destination_dlci = 18.
> Command has been aborted.
> SIGSEGV 11* segmentation violation
> si_signo [11]: SIGSEGV 11* segmentation violation
> si_errno [0]: Error 0
> si_code [1]: SEGV_ACCERR [addr: 0x0]
>
> stackbase=EE2D2000, stackpointer=EE2D0DD0
>
> Full thread dump:
> "Thread-13" (TID:0xee702e48, sys_thread_t:0xee2d1de0) prio=5
> *current thread*
> java.lang.Throwable.printStackTrace(Throwable.java)
> srvUpdateBilling.notifyEvent(srvUpdateBilling.java:128)
> lpTransaction.dispatch(lpTransaction.java:247)
> lpTransactionRunner.run(lpTransactionRunner.java:59)
> java.lang.Thread.run(Thread.java)
> "Thread-12" (TID:0xee704d40, sys_thread_t:0xee331de0) prio=5
> java.lang.Object.wait(Object.java)
> lpTransactionRunner.dequeueData(lpTransactionRunner.java:85)
> lpTransactionRunner.run(lpTransactionRunner.java:56)
> java.lang.Thread.run(Thread.java)
> "Thread-11" (TID:0xee701b70, sys_thread_t:0xee391de0) prio=5
> java.net.SocketInputStream.read(SocketInputStream.java:89)
> java.net.SocketInputStream.read(SocketInputStream.java:105)
> java.io.DataInputStream.readUnsignedShort(DataInputStream.java)
> java.io.DataInputStream.readUTF(DataInputStream.java)
> java.io.DataInputStream.readUTF(DataInputStream.java)
> lpPacket.streamIn(lpPacket.java:65)
> lpPacket.<init>(lpPacket.java:53)
> lpConnection.processPacket(lpConnection.java:118)
> lpConnection.run(lpConnection.java:84)
> java.lang.Thread.run(Thread.java)
> "Thread-9" (TID:0xee704990, sys_thread_t:0xee301de0) prio=5
> java.lang.Object.wait(Object.java)
> lpTransactionRunner.dequeueData(lpTransactionRunner.java:85)
> lpTransactionRunner.run(lpTransactionRunner.java:56)
> java.lang.Thread.run(Thread.java)
> "Thread-7" (TID:0xee7049e0, sys_thread_t:0xee361de0) prio=5
> java.lang.Object.wait(Object.java)
> lpTransactionRunner.dequeueData(lpTransactionRunner.java:85)
> lpTransactionRunner.run(lpTransactionRunner.java:56)
> java.lang.Thread.run(Thread.java)
> "Thread-4" (TID:0xee701298, sys_thread_t:0xee3c1de0) prio=5
> java.net.PlainSocketImpl.accept(PlainSocketImpl.java:320)
> java.net.ServerSocket.accept(ServerSocket.java:109)
> lpRouter.listen(lpRouter.java:119)
> lpRouter.run(lpRouter.java:172)
> java.lang.Thread.run(Thread.java)
> "Finalizer thread" (TID:0xee7003b0, sys_thread_t:0xee3f1de0) prio=1
> "Async Garbage Collector" (TID:0xee700368, sys_thread_t:0xef441de0)
> prio=1
> "Idle thread" (TID:0xee700320, sys_thread_t:0xef471de0) prio=0
> "clock handler" (TID:0xee7001f8, sys_thread_t:0xef551de0) prio=11
> "main" (TID:0xee7000a0, sys_thread_t:0x83aa8) prio=5
> Monitor Cache Dump:
> unknown key (key=0xef441de0): unowned
> Waiting to be notified:
> "Async Garbage Collector"
> srvUpdateBilling@EE700AE0/EE745F48 (key=0xee700ae0): monitor
> owner: "Thread-13"
> lpConnection@EE701278/EE745D80 (key=0xee701278): monitor owner:
> "Thread-11"
> lpTransactionRunner@EE7044A0/EE743C08 (key=0xee7044a0): unowned
> Waiting to be notified:
> "Thread-7"
> lpTransactionRunner@EE704308/EE746E48 (key=0xee704308): unowned
> Waiting to be notified:
> "Thread-12"
> java.net.PlainSocketImpl@EE702210/EE73D2C8 (key=0xee702210):
> monitor owner: "Thread-4"
> lpTransactionRunner@EE704158/EE745A20 (key=0xee704158): unowned
> Waiting to be notified:
> "Thread-9"
> Registered Monitor Dump:
> Finalize me queue lock: unowned
> Waiting to be notified:
> "Finalizer thread"
> Thread queue lock: unowned
> Waiting to be notified:
> "main"
> Class lock: unowned
> Java stack lock: unowned
> Code rewrite lock: unowned
> Heap lock: unowned
> Has finalization queue lock: unowned
> Monitor IO lock: unowned
> Child death monitor: unowned
> Event monitor: unowned
> I/O monitor: unowned
> Alarm monitor: unowned
> Waiting to be notified:
> "clock handler"
> Sbrk lock: unowned
> Monitor cache lock: unowned
> Monitor registry: monitor owner: "Thread-13"
> Thread Alarm Q:
> sys_thread_t 0xef441de0 [Timeout in 869 ms]
> --------------- end of messages --------------

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Technical Support Phone:(617) 564-6336
77 South Bedford Street Fax: (617) 564-6148
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================