11:19 a.m.
Jess Sightler created AS7-5714:
----------------------------------
Summary: JPA "Session Open Count" statistic appears to be bogus
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Scott Marlow
Priority: Minor
After running a small sample app, Session Open Count in the admin console displays 900006.
Session close count is 1 (as expected). Memory usage does not significantly increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:21 a.m.
[
https://issues.jboss.org/browse/AS7-5714?page=com.atlassian.jira.plugin.s...
]
Jess Sightler updated AS7-5714:
-------------------------------
Attachment: CDIHelloWorld.zip
Extremely small sample app demonstrating the issue. Uses ExampleDS for simplicity.
JPA "Session Open Count" statistic appears to be bogus
------------------------------------------------------
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Scott Marlow
Priority: Minor
Attachments: CDIHelloWorld.zip
After running a small sample app, Session Open Count in the admin console displays
900006. Session close count is 1 (as expected). Memory usage does not significantly
increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:32 p.m.
[
https://issues.jboss.org/browse/AS7-5714?page=com.atlassian.jira.plugin.s...
]
SBS JIRA Integration updated AS7-5714:
--------------------------------------
Forum Reference: https://community.jboss.org/message/757629#757629
JPA "Session Open Count" statistic appears to be bogus
------------------------------------------------------
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Scott Marlow
Priority: Minor
Attachments: CDIHelloWorld.zip
After running a small sample app, Session Open Count in the admin console displays
900006. Session close count is 1 (as expected). Memory usage does not significantly
increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:02 p.m.
[
https://issues.jboss.org/browse/AS7-5714?page=com.atlassian.jira.plugin.s...
]
Scott Marlow commented on AS7-5714:
-----------------------------------
Can you also attach the already built test app
JPA "Session Open Count" statistic appears to be bogus
------------------------------------------------------
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Scott Marlow
Priority: Minor
Attachments: CDIHelloWorld.zip
After running a small sample app, Session Open Count in the admin console displays
900006. Session close count is 1 (as expected). Memory usage does not significantly
increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:47 a.m.
[
https://issues.jboss.org/browse/AS7-5714?page=com.atlassian.jira.plugin.s...
]
Jess Sightler updated AS7-5714:
-------------------------------
Attachment: CDIHelloWorld.war
JPA "Session Open Count" statistic appears to be bogus
------------------------------------------------------
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Scott Marlow
Priority: Minor
Attachments: CDIHelloWorld.war, CDIHelloWorld.zip
After running a small sample app, Session Open Count in the admin console displays
900006. Session close count is 1 (as expected). Memory usage does not significantly
increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:49 a.m.
[
https://issues.jboss.org/browse/AS7-5714?page=com.atlassian.jira.plugin.s...
]
Jess Sightler commented on AS7-5714:
------------------------------------
Hit:
http://localhost:8080/CDIHelloWorld/resources/hello
to test. It will take a minute or so due to the large number of iterations.
JPA "Session Open Count" statistic appears to be bogus
------------------------------------------------------
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Scott Marlow
Priority: Minor
Attachments: CDIHelloWorld.war, CDIHelloWorld.zip
After running a small sample app, Session Open Count in the admin console displays
900006. Session close count is 1 (as expected). Memory usage does not significantly
increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:08 a.m.
[
https://issues.jboss.org/browse/AS7-5714?page=com.atlassian.jira.plugin.s...
]
Scott Marlow commented on AS7-5714:
-----------------------------------
I just ran the test app and am using jboss-cli.sh
{quote}
./jboss-cli.sh
connect
cd
/deployment=CDIHelloWorld.war/subsystem=jpa/hibernate-persistence-unit=CDIHelloWorld.war#CDIHelloWorld
ls
{quote}
Output of the "ls" command is:
{quote}
cd CDIHelloWorld.war#CDIHelloWorld
[standalone@localhost:9999 hibernate-persistence-unit=CDIHelloWorld.war#CDIHelloWorld] ls
collection entity-update-count=0
entity flush-count=1
entity-cache optimistic-failure-count=0
query-cache prepared-statement-count=900006
close-statement-count=0 query-cache-hit-count=0
collection-fetch-count=0 query-cache-miss-count=0
collection-load-count=0 query-cache-put-count=0
collection-recreated-count=0 query-execution-count=900004
collection-remove-count=0 query-execution-max-time=17
collection-update-count=0
query-execution-max-time-query-string=select c from Car c
completed-transaction-count=1
scoped-unit-name=CDIHelloWorld.war#CDIHelloWorld
connect-count=900006 second-level-cache-hit-count=0
enabled=true second-level-cache-miss-count=0
entity-delete-count=0 second-level-cache-put-count=0
entity-fetch-count=0 session-close-count=1
entity-insert-count=2 session-open-count=1
entity-load-count=0 successful-transaction-count=1
{quote}
It looks like the admin console is showing the connection count incorrectly. As a
workaround, use the jboss-cli.sh to get the proper statistics.
The admin console should show { connect-count=900006, session-close-count=1,
session-open-count=1}, but instead shows { Session Open Count 900006, Session Close Count
1, Connection Count 1}
JPA "Session Open Count" statistic appears to be bogus
------------------------------------------------------
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Scott Marlow
Priority: Minor
Attachments: CDIHelloWorld.war, CDIHelloWorld.zip
After running a small sample app, Session Open Count in the admin console displays
900006. Session close count is 1 (as expected). Memory usage does not significantly
increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:12 a.m.
[
https://issues.jboss.org/browse/AS7-5714?page=com.atlassian.jira.plugin.s...
]
Scott Marlow reassigned AS7-5714:
---------------------------------
Assignee: Heiko Braun (was: Scott Marlow)
Heiko, I can recreate this locally with the test case that Jess attached (see above
comments).
JPA "Session Open Count" statistic appears to be bogus
------------------------------------------------------
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Heiko Braun
Priority: Minor
Attachments: CDIHelloWorld.war, CDIHelloWorld.zip
After running a small sample app, Session Open Count in the admin console displays
900006. Session close count is 1 (as expected). Memory usage does not significantly
increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:12 a.m.
[
https://issues.jboss.org/browse/AS7-5714?page=com.atlassian.jira.plugin.s...
]
Scott Marlow updated AS7-5714:
------------------------------
Component/s: Console
Forum Reference: https://community.jboss.org/message/757629#757629 (was:
https://community.jboss.org/message/757629#757629)
JPA "Session Open Count" statistic appears to be bogus
------------------------------------------------------
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: Console, JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Heiko Braun
Priority: Minor
Attachments: CDIHelloWorld.war, CDIHelloWorld.zip
After running a small sample app, Session Open Count in the admin console displays
900006. Session close count is 1 (as expected). Memory usage does not significantly
increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:24 a.m.
[
https://issues.jboss.org/browse/AS7-5714?page=com.atlassian.jira.plugin.s...
]
Heiko Braun updated AS7-5714:
-----------------------------
Fix Version/s: 7.2.0.CR1
Forum Reference: https://community.jboss.org/message/757629#757629 (was:
https://community.jboss.org/message/757629#757629)
JPA "Session Open Count" statistic appears to be bogus
------------------------------------------------------
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: Console, JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Heiko Braun
Priority: Minor
Fix For: 7.2.0.CR1
Attachments: CDIHelloWorld.war, CDIHelloWorld.zip
After running a small sample app, Session Open Count in the admin console displays
900006. Session close count is 1 (as expected). Memory usage does not significantly
increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:24 a.m.
[
https://issues.jboss.org/browse/AS7-5714?page=com.atlassian.jira.plugin.s...
]
Heiko Braun commented on AS7-5714:
----------------------------------
I'll have a look. It's probably something trivial.
JPA "Session Open Count" statistic appears to be bogus
------------------------------------------------------
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: Console, JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Heiko Braun
Priority: Minor
Fix For: 7.2.0.CR1
Attachments: CDIHelloWorld.war, CDIHelloWorld.zip
After running a small sample app, Session Open Count in the admin console displays
900006. Session close count is 1 (as expected). Memory usage does not significantly
increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:45 a.m.
[
https://issues.jboss.org/browse/AS7-5714?page=com.atlassian.jira.plugin.s...
]
Heiko Braun resolved AS7-5714.
------------------------------
Fix Version/s: 7.2.0.Alpha1
(was: 7.2.0.CR1)
Resolution: Done
JPA "Session Open Count" statistic appears to be bogus
------------------------------------------------------
Key: AS7-5714
URL: https://issues.jboss.org/browse/AS7-5714
Project: Application Server 7
Issue Type: Bug
Components: Console, JPA / Hibernate
Affects Versions: 7.1.2.Final (EAP)
Reporter: Jess Sightler
Assignee: Heiko Braun
Priority: Minor
Fix For: 7.2.0.Alpha1
Attachments: CDIHelloWorld.war, CDIHelloWorld.zip
After running a small sample app, Session Open Count in the admin console displays
900006. Session close count is 1 (as expected). Memory usage does not significantly
increase.
The sample app exposes an EntityManager like this:
@Produces
public EntityManager getEntityManager() {
System.out.println("Getting entity manager!");
return entityManager;
}
A JAX-RS service then injects the entity manager, and performs a few simple queries:
@Inject
private EntityManager entityManager;
@GET()
@Produces("text/plain")
public String sayHello() {
try {
userTransaction.begin();
Car car = new Car();
car.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car);
Car car2 = new Car();
car2.setCarName("Name: " + System.currentTimeMillis());
entityManager.persist(car2);
for (int i = 0; i < 900000; i++) {
Query q = entityManager.createQuery("select c from Car c");
List<Car> resultList = q.getResultList();
for (Car c : resultList) {
System.out.println("Car: " + c);
}
}
return "stub";
}
I don't see any way that this could actually be opening this many sessions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4257
days inactive
4287
days old
11 comments
4 participants
participants (4)
-
Heiko Braun (JIRA) -
Jess Sightler (JIRA)
-
SBS JIRA Integration (JIRA)
-
Scott Marlow (JIRA)