db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert S. Sfeir" <rob...@codepuccino.com>
Subject Lock Failure on Postgresql
Date Tue, 22 Jun 2004 00:06:17 GMT
Looks like postgres is exhibiting the same symptoms as Oracle.  It looks
like the test thinks someone else modified an object and can't get a lock
and the test fails, either that or there is serious thread locking going on
here.

[BOOT] INFO: PersistencebrokerFactory class instantiated:
org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl@44daf
[org.apache.ojb.odmg.ObjectEnvelopeTable] ERROR: Commit on object level
failed for tx org.apache.ojb.odmg.TransactionImpl@f35d1
Object has been modified by someone else
[org.apache.ojb.odmg.TransactionImpl] ERROR: Could not prepare for commit:
Object has been modified by someone else
[org.apache.ojb.odmg.TransactionImpl] ERROR: Locking obj
org.apache.ojb.odmg.LockingMultithreadedTest$LockObject@dac8a5 with lock
mode 4 failed
Can not lock 
org.apache.ojb.odmg.LockingMultithreadedTest$LockObjectRef@2fcbd8 for WRITE
[DEFAULT] WARN: ### thread 3 waits 71 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 72 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 71 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 73 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 72 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 74 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 73 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 75 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 74 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 76 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 75 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 77 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 76 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 78 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 77 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 79 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 78 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 80 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 79 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 81 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 80 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 82 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 81 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 83 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 82 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 84 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 83 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 85 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 84 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 86 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 85 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 87 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 86 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 88 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 5 waits 87 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 89 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 90 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 91 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 92 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 93 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 94 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 95 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 96 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 97 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 98 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 99 times. Maximal attempts are 100
[DEFAULT] WARN: ### thread 3 waits 100 times. Maximal attempts are 100
[DEFAULT] ERROR: * Can't lock given object, will throw exception for thread
number 3 *
*** Result of multithreaded lock test ***
mod by thread: 
0-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-5-5-5-5-5-5-5-
5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5
mod by thread: 
0-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-5-5-5-5-5-5-5-
5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5
[org.apache.ojb.odmg.DatabaseImpl] ERROR: Database cannot be closed,
associated Tx is still open. Transaction status is 'STATUS_ACTIVE'. Used
PBKey was org.apache.ojb.broker.PBKey: jcdAlias=default, user=ojb,
password=*****
# [Skip test in org.apache.ojb.odmg.ODMGRollbackTest] Will skip a known
issue #
# [Skip test in org.apache.ojb.odmg.ODMGRollbackTest] Will skip a known
issue #
[org.apache.ojb.odmg.ObjectEnvelopeTable] ERROR: Commit on object level
failed for tx org.apache.ojb.odmg.TransactionImpl@a0ff27
SQL failure while insert object data for class org.apache.ojb.odmg.Site, PK
of the given object is [ id=22], object was org.apache.ojb.odmg.Site@fbe75,
exception message is [ERROR: duplicate key violates unique constraint
"name_unique"
]
[org.apache.ojb.odmg.TransactionImpl] ERROR: Could not prepare for commit:
null
locked for write: org.apache.ojb.odmg.PersonImpl@2d2e33[
  id=26
  firstname=&lt;null&gt;
  lastname=&lt;null&gt;
  motherId=0
  mother=&lt;null&gt;
  fatherId=0
  father=&lt;null&gt;
]
retrieved: org.apache.ojb.odmg.PersonImpl@2d2e33[
  id=26
  firstname=&lt;null&gt;
  lastname=&lt;null&gt;
  motherId=0
  mother=&lt;null&gt;
  fatherId=0
  father=&lt;null&gt;
]
# [Skip test in org.apache.ojb.odmg.CollectionsTest] Will skip a known issue
#
# [Skip test in org.apache.ojb.odmg.M2NTest] Will skip a known issue #
# [Skip test in org.apache.ojb.odmg.M2NTest] Will skip a known issue #
# [Skip test in org.apache.ojb.odmg.M2NTest] Will skip a known issue #
# [Skip test in org.apache.ojb.odmg.M2NTest] Will skip a known issue #
# [Skip test in org.apache.ojb.odmg.M2NTest] Will skip a known issue #
# [Skip test in org.apache.ojb.odmg.M2NTest] Will skip a known issue #


Can not lock org.apache.ojb.odmg.LockingMultithreadedTest$LockObject@680525
for WRITE

org.odmg.LockNotGrantedException: Can not lock
org.apache.ojb.odmg.LockingMultithreadedTest$LockObject@680525 for WRITE at
org.apache.ojb.odmg.TransactionImpl.lock(TransactionImpl.java:249) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:148) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Locking
MultithreadedTest.java:161) at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.runTestCase(LockingM
ultithreadedTest.java:135) at
org.apache.ojb.junit.JUnitExtensions$MultiThreadedTestCase$TestCaseRunnable.
run(JUnitExtensions.java:186) at java.lang.Thread.run(Thread.java:552)sleep
interrupted

(lots more)

R



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message