[eclipselink-users] Query returning stale results existing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-users] Query returning stale results existing
From: cowwoc <cowwoc@xxxxxxxxxxxxxxxx>
Date: Tue, 18 Nov 2008 05:40:30 -0800 (PST)
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/listinfo/eclipselink-users>, <mailto:eclipselink-users-request@eclipse.org?subject=unsubscribe>
Hi,

I am issuing the same query in subsequent HTTP queries and getting back
stale results (cached from the first request). As far as I can tell I am
using the Session-Per-HTTP-Request paradigm so this shouldn't be happening.
I need your help to interpret the EclipseLink logs (included at the end of
this email).

1) Does "client released" mean EntityManager.close() has been issued?
2) What would cause queries to cache results across EntityManagers?

I will now include my log. The first line is issued in request #1, the
subsequent lines are issued by subsequent requests. The lines that caught my
eyes were the ones reading "Register the existing object"... I believe
EclipseLink isn't actually contacting the database.

One warning: media_version.version is *not* the optimistic-locking
versioning field. It is used purely for business logic.


-------------log----------------------
[EL Finer]: 2008.11.18
08:25:22.872--ClientSession(58019908)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client
released
[EL Finer]: 2008.11.18
08:26:25.538--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client
acquired
[EL Finest]: 2008.11.18
08:26:25.539--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute
query ReadAllQuery(adcaster.server.domain.Media)
[EL Finest]: 2008.11.18
08:26:25.540--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--reconnecting
to external connection pool
[EL Fine]: 2008.11.18
08:26:25.540--ServerSession(290077830)--Connection(405818770)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT
ID, VERSION FROM MEDIA
[EL Finest]: 2008.11.18
08:26:25.542--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:25.543--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.543--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.544--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume
unit of work
[EL Finer]: 2008.11.18
08:26:25.544--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--release
unit of work
[EL Finer]: 2008.11.18
08:26:25.545--ClientSession(2110771332)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client
released
[EL Finer]: 2008.11.18
08:26:25.565--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client
acquired
[EL Finest]: 2008.11.18
08:26:25.565--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
query ReadObjectQuery(adcaster.server.domain.Media)
[EL Finer]: 2008.11.18
08:26:25.566--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.566--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.567--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
unit of work
[EL Finest]: 2008.11.18
08:26:25.567--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:25.568--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--reconnecting
to external connection pool
[EL Fine]: 2008.11.18
08:26:25.568--ServerSession(290077830)--Connection(814711173)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE (MEDIA_ID = ?)
ORDER BY VERSION ASC
        bind => [101]
[EL Finest]: 2008.11.18
08:26:25.571--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=151,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=0, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.572--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.572--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=201,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=1, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.573--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.574--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=251,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=2, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.574--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.575--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=301,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=3, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.575--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.576--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=351,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=4, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.576--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.577--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=401,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=5, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.578--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.578--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=451,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=6, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.579--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.580--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=501,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=7, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.580--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.581--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=502,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=8, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.581--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.582--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=551,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=9, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.583--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:25.583--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.584--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.584--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
unit of work
[EL Finer]: 2008.11.18
08:26:27.351--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--release
unit of work
[EL Finer]: 2008.11.18
08:26:27.352--ClientSession(1319818785)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client
released
[EL Finer]: 2008.11.18
08:26:27.549--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client
acquired
[EL Finest]: 2008.11.18
08:26:27.550--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute
query ReadObjectQuery(adcaster.server.domain.Media)
[EL Finer]: 2008.11.18
08:26:27.550--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.550--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.551--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume
unit of work
[EL Finest]: 2008.11.18
08:26:27.551--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.552--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--reconnecting
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.552--ServerSession(290077830)--Connection(577145991)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID = ?)
AND (VERSION = ?))
        bind => [101, 9]
[EL Finest]: 2008.11.18
08:26:27.553--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=551,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=9, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:27.554--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:27.554--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.554--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.555--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume
unit of work
[EL Finest]: 2008.11.18
08:26:27.556--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.556--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--reconnecting
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.556--ServerSession(290077830)--Connection(1249576400)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID = ?)
AND (VERSION = ?))
        bind => [101, 10]
[EL Finer]: 2008.11.18
08:26:27.557--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.558--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.558--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume
unit of work
[EL Finest]: 2008.11.18
08:26:27.558--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.558--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--reconnecting
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.559--ServerSession(290077830)--Connection(1521339340)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID = ?)
AND (VERSION = ?))
        bind => [101, 8]
[EL Finest]: 2008.11.18
08:26:27.560--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=502,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=8, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:27.560--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:27.561--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.561--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.561--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume
unit of work
[EL Finer]: 2008.11.18
08:26:27.562--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--release
unit of work
[EL Finer]: 2008.11.18
08:26:27.563--ClientSession(2128871984)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client
released
[EL Finer]: 2008.11.18
08:26:27.614--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client
acquired
[EL Finest]: 2008.11.18
08:26:27.614--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
query ReadObjectQuery(adcaster.server.domain.Media)
[EL Finer]: 2008.11.18
08:26:27.615--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.615--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.615--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
unit of work
[EL Finest]: 2008.11.18
08:26:27.616--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.617--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--reconnecting
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.617--ServerSession(290077830)--Connection(1545852605)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID = ?)
AND (VERSION = ?))
        bind => [101, 9]
[EL Finest]: 2008.11.18
08:26:27.619--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=551,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=9, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:27.619--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:27.619--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.620--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.620--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
unit of work
[EL Finest]: 2008.11.18
08:26:27.621--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.622--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--reconnecting
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.622--ServerSession(290077830)--Connection(1232567244)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID = ?)
AND (VERSION = ?))
        bind => [101, 10]
[EL Finer]: 2008.11.18
08:26:27.623--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.624--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.624--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
unit of work
[EL Finest]: 2008.11.18
08:26:27.625--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.625--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--reconnecting
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.625--ServerSession(290077830)--Connection(139849089)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID = ?)
AND (VERSION = ?))
        bind => [101, 8]
[EL Finest]: 2008.11.18
08:26:27.627--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
id=502,
media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101, version=1], version=8, data=[46, 46, 46, 99, 111, 110, 116, 101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105, 102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:27.627--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:27.627--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.628--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.628--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
unit of work
[EL Finer]: 2008.11.18
08:26:27.629--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--release
unit of work
[EL Finer]: 2008.11.18
08:26:27.629--ClientSession(256032021)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client
released
----------------------------------------

Thanks,
Gili
-- 
View this message in context: http://www.nabble.com/Query-returning-stale-results-existing-tp20559804p20559804.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.
Follow-Ups:
- Re: [eclipselink-users] Query returning stale results existing
  - From: Tim Hollosy
Prev by Date: Re: [eclipselink-users] programmatic customization of mapping meta-data at runtime
Next by Date: Re: [eclipselink-users] Query returning stale results existing
Previous by thread: [eclipselink-users] SQL arrays and EclipseLink
Next by thread: Re: [eclipselink-users] Query returning stale results existing
Index(es):
- Date
- Thread
Breadcrumbs
