Re: [eclipselink-users] Deadlock or ignored id-validation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]

Re: [eclipselink-users] Deadlock or ignored id-validation - I've trouble

From: Edson Richter <edsonrichter@xxxxxxxxxxx>
Date: Fri, 31 May 2013 13:28:13 -0300
Delivered-to: eclipselink-users@xxxxxxxxxxx
List-archive: <https://dev.eclipse.org/mailman/private/eclipselink-users>
List-help: <mailto:eclipselink-users-request@eclipse.org?subject=help>
List-subscribe: <https://dev.eclipse.org/mailman/listinfo/eclipselink-users>, <mailto:eclipselink-users-request@eclipse.org?subject=subscribe>
List-unsubscribe: <https://dev.eclipse.org/mailman/options/eclipselink-users>, <mailto:eclipselink-users-request@eclipse.org?subject=unsubscribe>
Organization: Simkorp Informática Ltda
User-agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130328 Thunderbird/17.0.5

Em 31/05/2013 12:30, Andrei Ilitchev escreveu:

Sequencing has nothing to do with shared cache mode, should work withany mode.
By default id validation is set to ZERO for simple primary key andNULL for compound primary key.


Yes.

If you set id validation to NULL for a simple primary key, then allthe values except NULL will be accepted as a legitimate pk value andwon't be overridden by sequencing.
For example:
public class Employee {
@Id
@GeneratedValue(strategy=TABLE, generator="EMPLOYEE_TABLE_GENERATOR")
@TableGenerator(
    name="EMPLOYEE_TABLE_GENERATOR",
    pkColumnValue="EMPLOYEE_SEQ",
)
int id
...
}
When an Employee object is persisted and it's id=0, if id validationis ZERO, then sequencing fetches a value from sequence table that'sassigned to the Employee.
However with id validation set to null:
@PrimaryKey(validation=IdValidation.NULL)
public class Employee {
...
}
the Employee object is inserted in the db with id=0.

If this doesn't help please explain what are you trying to do,
may be provide a simple example.

That's what I expected. I've put in persistence.xml the value"eclipselink.id-validation = 'NULL'", and I expect that Eclipselinkhonor that. But when I have shared cache "ENABLE_SELECTIVE", then itdoesn't honor sequencing for many side of one-to-many relationship.If I put shared cache as "ALL", then it honor sequencing for many side,but then I get deadlock if multiple users are working with objects ofsame kind.

I've captured the two threads that are frozen when using shared cacheALL, and the threads are frozen here (two thread dumps):


Stack Trace
   java.lang.Thread.sleep line: not available [native method]

org.eclipse.persistence.internal.helper.ConcurrencyManager.releaseDeferredLockline: 466org.eclipse.persistence.internal.identitymaps.CacheKey.releaseDeferredLockline: 385org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectline: 861org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildWorkingCopyCloneNormallyline: 719org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectInUnitOfWorkline: 672org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectline: 605org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectline: 564org.eclipse.persistence.queries.ObjectLevelReadQuery.buildObjectline: 777org.eclipse.persistence.queries.ReadObjectQuery.registerResultInUnitOfWorkline: 787org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQueryline: 460org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery line:1150

   org.eclipse.persistence.queries.DatabaseQuery.execute line: 852
   org.eclipse.persistence.queries.ObjectLevelReadQuery.execute line: 1109
   org.eclipse.persistence.queries.ReadObjectQuery.execute line: 421

org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWorkline: 1197org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQueryline: 2875org.eclipse.persistence.internal.sessions.AbstractSession.executeQueryline: 1602org.eclipse.persistence.internal.sessions.AbstractSession.executeQueryline: 1584org.eclipse.persistence.internal.sessions.AbstractSession.executeQueryline: 1535org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQueryline: 838org.eclipse.persistence.internal.jpa.EntityManagerImpl.findInternalline: 778

   org.eclipse.persistence.internal.jpa.EntityManagerImpl.find line: 671
   org.eclipse.persistence.internal.jpa.EntityManagerImpl.find line: 543
   br.com.simfreteV1.broker.TabelaBroker.getTabelasDestino line: 1782
   ...

and the other thread that is blocked:

Stack Trace
http-nio-8088-exec-34 [190] (WAITING)
   java.lang.Object.wait line: not available [native method]
   java.lang.Object.wait line: 485
org.eclipse.persistence.internal.helper.ConcurrencyManager.acquire line: 94

org.eclipse.persistence.internal.identitymaps.CacheKey.acquire line:132org.eclipse.persistence.internal.identitymaps.AbstractIdentityMap.acquireLockline: 122org.eclipse.persistence.internal.identitymaps.IdentityMapManager.acquireLockline: 150org.eclipse.persistence.internal.sessions.IdentityMapAccessor.acquireLock line:93org.eclipse.persistence.internal.sessions.IdentityMapAccessor.acquireLock line:84org.eclipse.persistence.internal.sessions.AbstractSession.retrieveCacheKeyline: 4803org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectline: 777org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectline: 607org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectline: 564org.eclipse.persistence.queries.ObjectLevelReadQuery.buildObjectline: 777org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQueryline: 462org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery line:1150

   org.eclipse.persistence.queries.DatabaseQuery.execute line: 852
   org.eclipse.persistence.queries.ObjectLevelReadQuery.execute line: 1109
   org.eclipse.persistence.queries.ReadObjectQuery.execute line: 421

org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQueryline: 2946org.eclipse.persistence.internal.sessions.AbstractSession.executeQueryline: 1602org.eclipse.persistence.internal.sessions.AbstractSession.executeQueryline: 1584org.eclipse.persistence.internal.indirection.NoIndirectionPolicy.valueFromQueryline: 323org.eclipse.persistence.mappings.ForeignReferenceMapping.valueFromRowInternalline: 2135org.eclipse.persistence.mappings.OneToOneMapping.valueFromRowInternalline: 1716org.eclipse.persistence.mappings.ForeignReferenceMapping.valueFromRowline: 2024org.eclipse.persistence.mappings.ForeignReferenceMapping.readFromRowIntoObjectline: 1369org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildAttributesIntoObjectline: 448org.eclipse.persistence.internal.descriptors.ObjectBuilder.refreshObjectIfRequiredline: 3673org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectline: 831org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildWorkingCopyCloneNormallyline: 719org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectInUnitOfWorkline: 672org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectline: 605org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectline: 564org.eclipse.persistence.queries.ObjectLevelReadQuery.buildObjectline: 777org.eclipse.persistence.queries.ReadObjectQuery.registerResultInUnitOfWorkline: 787org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQueryline: 460org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery line:1150

   org.eclipse.persistence.queries.DatabaseQuery.execute line: 852
   org.eclipse.persistence.queries.ObjectLevelReadQuery.execute line: 1109
   org.eclipse.persistence.queries.ReadObjectQuery.execute line: 421

org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWorkline: 1197org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQueryline: 2875org.eclipse.persistence.internal.sessions.AbstractSession.executeQueryline: 1602org.eclipse.persistence.internal.sessions.AbstractSession.executeQueryline: 1584org.eclipse.persistence.internal.sessions.AbstractSession.executeQueryline: 1549org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQueryline: 231

   org.eclipse.persistence.internal.jpa.QueryImpl.getResultList line: 403

br.com.simfreteV1.broker.DocumentoTransporteBroker.getDocumentoTransporte line:457

   ...



Edson

Follow-Ups:
- Re: [eclipselink-users] Deadlock or ignored id-validation - I've trouble
  - From: Andrei Ilitchev

References:
- [eclipselink-users] Deadlock or ignored id-validation - I've trouble
  - From: Edson Richter
- Re: [eclipselink-users] Deadlock or ignored id-validation - I've trouble
  - From: Andrei Ilitchev

Prev by Date: Re: [eclipselink-users] Deadlock or ignored id-validation - I've trouble
Next by Date: Re: [eclipselink-users] Zero Fetched Subobjects (with MongoDB+XML Mappings)
Previous by thread: Re: [eclipselink-users] Deadlock or ignored id-validation - I've trouble
Next by thread: Re: [eclipselink-users] Deadlock or ignored id-validation - I've trouble
Index(es):
- Date
- Thread

Breadcrumbs