You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Raghunath <ra...@gmail.com> on 2008/01/27 05:21:27 UTC
Getting NullPointerException after several read and write operations
Hi,
I'm getting following exception after reading and writing several records
on derby db.
Not sure where exactly I'm doing mistake or is this a bug.. please rectify
me...
java -Xmx728m -Dderby.system.home=H:\derby\
work -Dderby.drda.maxThreads=1250 -Dderby.drda.traceAll=true -
Dderby.drda.timeS
lice=1000 -Dderby.drda.traceDirectory=H:\derby\work\trace -jar
%DERBY_HOME%\lib\
derbyrun.jar server start
Security manager installed using the Basic server security policy.
Apache Derby Network Server - 10.3.2.1 - (599110) started and ready to
accept co
nnections on port 1527 at 2008-01-27 03:22:40.750 GMT
null
java.lang.NullPointerException
at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Execution failed because of Permanent Agent Error: SVRCOD = 40; RDBNAM =
jd-exp;
diagnostic msg = null
org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because
of Permanent Agent Error: SVRCOD = 40; RDBNAM = jd-exp; diagnostic msg =
null
at org.apache.derby.impl.drda.DRDAProtocolException.newAgentError(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.sendUnexpectedException(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
null
java.lang.NullPointerException
at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
null
java.lang.NullPointerException
at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection
(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Sou
rce)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Execution failed because of Permanent Agent Error: SVRCOD = 40; RDBNAM =
jd-exp;
diagnostic msg = null
org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because
of Pe
rmanent Agent Error: SVRCOD = 40; RDBNAM = jd-exp; diagnostic msg = null
at org.apache.derby.impl.drda.DRDAProtocolException.newAgentError
(Unknow
n Source)
at org.apache.derby.impl.drda.DRDAConnThread.sendUnexpectedException
(Unk
nown Source)
at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown
Sou
rce)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
null
java.lang.NullPointerException
at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection
(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Sou
rce)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
--
Thanks
Raghunath N
Re: Getting NullPointerException after several read and write
operations
Posted by Raghunath <vi...@gmail.com>.
hi Kristian ,
Thanks for your reply,
I was creating/closing lot of sessions.I observed increase in thread count
in derby(using jconsole). Then I gave option derby.drda.maxThreads=1250,
found good result but still the If the thread count reaches peek point, then
read/write operations became slow.Then I gave option
-Dderby.drda.timeSlice=1000 , got better result but observed the following
exceptions 3 to 4 times for
1000/5 mins session opens/close.
Then I controlled the session count to 50/5 mins , and the system is working
excellent ,no outofmemory, no Nullpointerexceptions
I got good experience with derby .. :)
Thanks a lot
Raghunath N
Kristian Waagan-4 wrote:
>
> Raghunath wrote:
>> Hi,
>> I'm getting following exception after reading and writing several
>> records on derby db.
>> Not sure where exactly I'm doing mistake or is this a bug.. please
>> rectify me...
>
> Hello Raghunath,
>
> This is just a shot in the dark for now, but have you tried running
> without specifying the timeSlice property?
> Do you need it in your environment?
>
> I think there has been problems with it earlier, so my first advice
> would be to disable it and see if you get the same error.
>
>
> If that doesn't help, it would be helpful if you could describe what is
> being run when the error occurs. For instance, how many (active)
> connections are there?
>
>
>
> regards,
> --
> Kristian
>
>>
>> java -Xmx728m -Dderby.system.home=H:\derby\
>> work -Dderby.drda.maxThreads=1250 -Dderby.drda.traceAll=true
>> -Dderby.drda.timeS
>> lice=1000 -Dderby.drda.traceDirectory=H:\derby\work\trace -jar
>> %DERBY_HOME%\lib\
>> derbyrun.jar server start
>>
>> Security manager installed using the Basic server security policy.
>> Apache Derby Network Server - 10.3.2.1 <http://10.3.2.1> - (599110)
>> started and ready to accept co
>> nnections on port 1527 at 2008-01-27 03:22:40.750 GMT
>> null
>> java.lang.NullPointerException
>> at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
>> Source)
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
>> Source)
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
>> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
>> Execution failed because of Permanent Agent Error: SVRCOD = 40; RDBNAM =
>> jd-exp;
>> diagnostic msg = null
>> org.apache.derby.impl.drda.DRDAProtocolException: Execution failed
>> because of Permanent Agent Error: SVRCOD = 40; RDBNAM = jd-exp;
>> diagnostic msg = null
>> at
>> org.apache.derby.impl.drda.DRDAProtocolException.newAgentError(Unknown
>> Source)
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.sendUnexpectedException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown Source)
>> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
>> null
>> java.lang.NullPointerException
>> at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
>> Source)
>>
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
>> Source)
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
>> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
>> null
>> java.lang.NullPointerException
>> at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
>> Source)
>>
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
>> Source)
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Sou
>> rce)
>> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
>> Execution failed because of Permanent Agent Error: SVRCOD = 40; RDBNAM =
>> jd-exp;
>> diagnostic msg = null
>> org.apache.derby.impl.drda.DRDAProtocolException: Execution failed
>> because of Pe
>> rmanent Agent Error: SVRCOD = 40; RDBNAM = jd-exp; diagnostic msg = null
>> at
>> org.apache.derby.impl.drda.DRDAProtocolException.newAgentError(Unknow
>> n Source)
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.sendUnexpectedException(Unk
>> nown Source)
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown Sou
>> rce)
>> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
>> null
>> java.lang.NullPointerException
>> at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
>> Source)
>>
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
>> Source)
>> at
>> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Sou
>> rce)
>> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
>>
>>
>> --
>> Thanks
>> Raghunath N
>>
>
>
>
--
View this message in context: http://www.nabble.com/Getting-NullPointerException-after-several-read-and-write-operations-tp15115839p15158271.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: Getting NullPointerException after several read and write
operations
Posted by Kristian Waagan <Kr...@Sun.COM>.
Raghunath wrote:
> Hi,
> I'm getting following exception after reading and writing several
> records on derby db.
> Not sure where exactly I'm doing mistake or is this a bug.. please
> rectify me...
Hello Raghunath,
This is just a shot in the dark for now, but have you tried running
without specifying the timeSlice property?
Do you need it in your environment?
I think there has been problems with it earlier, so my first advice
would be to disable it and see if you get the same error.
If that doesn't help, it would be helpful if you could describe what is
being run when the error occurs. For instance, how many (active)
connections are there?
regards,
--
Kristian
>
> java -Xmx728m -Dderby.system.home=H:\derby\
> work -Dderby.drda.maxThreads=1250 -Dderby.drda.traceAll=true
> -Dderby.drda.timeS
> lice=1000 -Dderby.drda.traceDirectory=H:\derby\work\trace -jar
> %DERBY_HOME%\lib\
> derbyrun.jar server start
>
> Security manager installed using the Basic server security policy.
> Apache Derby Network Server - 10.3.2.1 <http://10.3.2.1> - (599110)
> started and ready to accept co
> nnections on port 1527 at 2008-01-27 03:22:40.750 GMT
> null
> java.lang.NullPointerException
> at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> Execution failed because of Permanent Agent Error: SVRCOD = 40; RDBNAM =
> jd-exp;
> diagnostic msg = null
> org.apache.derby.impl.drda.DRDAProtocolException: Execution failed
> because of Permanent Agent Error: SVRCOD = 40; RDBNAM = jd-exp;
> diagnostic msg = null
> at
> org.apache.derby.impl.drda.DRDAProtocolException.newAgentError(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.sendUnexpectedException(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> null
> java.lang.NullPointerException
> at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
> Source)
>
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> null
> java.lang.NullPointerException
> at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
> Source)
>
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Sou
> rce)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> Execution failed because of Permanent Agent Error: SVRCOD = 40; RDBNAM =
> jd-exp;
> diagnostic msg = null
> org.apache.derby.impl.drda.DRDAProtocolException: Execution failed
> because of Pe
> rmanent Agent Error: SVRCOD = 40; RDBNAM = jd-exp; diagnostic msg = null
> at
> org.apache.derby.impl.drda.DRDAProtocolException.newAgentError(Unknow
> n Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.sendUnexpectedException(Unk
> nown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown Sou
> rce)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> null
> java.lang.NullPointerException
> at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
> Source)
>
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Sou
> rce)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
>
>
> --
> Thanks
> Raghunath N
>