lots of javax.jcr.ItemNotFoundExceptions in Artifactory 2.0.5 / MySQL after full export/import
------------------------------------------------------------------------------------------------
Key: RTFACT-1688
URL:
http://issues.jfrog.org/jira/browse/RTFACT-1688 Project: Artifactory
Issue Type: Bug
Affects Versions: 2.0.5
Environment: Artifactory 2.0.5
Java 1.6_07
Tomcat 6.0.18
MySQL 5.0.45
RHEL 5
Reporter: Falk Berger
Assignee: Yoav Landman
We have been used Artifactory 2 since version 2.0.2, which still had the data growing bug (look here
http://www.nabble.com/Artifactory-Size-on-MySQL%2C-snapshots-not-deleted-really--td22413548.html#a22413548).
The database size grew up to 40 gigabytes, while the real size is nearly 8 gigabytes. The bug was fixed with version 2.0.3, but the size of the database remained.
So we decided to make a full system export, delete und create a new database und reimport the data. So far so good ... the database size is smaller now, the performance is better.
But everytime I click at the Home-Button thousands of javax.jcr.ItemNotFoundExceptions are written to the logfile and the server performance is going down.
I just counted nearly 1800 exceptions per second.
2009-05-14 13:31:32,947 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 25ee77ba-dd78-466e-924c-c6be71dab891: javax.jcr.ItemNotFoundException: 25ee77ba-dd78-466e-924c-c6be71dab891
2009-05-14 13:31:33,226 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: aafb9140-10f1-4d23-84dd-5453f9fe74a4: javax.jcr.ItemNotFoundException: aafb9140-10f1-4d23-84dd-5453f9fe74a4
2009-05-14 13:31:33,226 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 121452db-66c7-4e4f-a718-32363fc247ec: javax.jcr.ItemNotFoundException: 121452db-66c7-4e4f-a718-32363fc247ec
2009-05-14 13:31:33,227 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 6496dd4a-e206-483e-a4d3-e79124613b5e: javax.jcr.ItemNotFoundException: 6496dd4a-e206-483e-a4d3-e79124613b5e
2009-05-14 13:31:33,227 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: acab74fe-8a6c-4a56-b1b6-67bb68cb0cf4: javax.jcr.ItemNotFoundException: acab74fe-8a6c-4a56-b1b6-67bb68cb0cf4
2009-05-14 13:31:33,227 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 633adbb2-6108-4ee8-8ac9-321a9d91e68f: javax.jcr.ItemNotFoundException: 633adbb2-6108-4ee8-8ac9-321a9d91e68f
2009-05-14 13:31:33,228 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: d0ebb9c8-9ea8-4b6b-be5d-702e8595fd04: javax.jcr.ItemNotFoundException: d0ebb9c8-9ea8-4b6b-be5d-702e8595fd04
2009-05-14 13:31:33,228 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 550c592f-da87-476b-be05-f5eda75970e3: javax.jcr.ItemNotFoundException: 550c592f-da87-476b-be05-f5eda75970e3
2009-05-14 13:31:33,228 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: ba9b3d3f-598c-493a-8cb8-4be6ebbdcf5b: javax.jcr.ItemNotFoundException: ba9b3d3f-598c-493a-8cb8-4be6ebbdcf5b
2009-05-14 13:31:33,229 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 72526b91-fdcb-46c7-8003-93660a342cd1: javax.jcr.ItemNotFoundException: 72526b91-fdcb-46c7-8003-93660a342cd1
2009-05-14 13:31:33,229 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 8f595037-32f4-47ac-889e-047e813987bc: javax.jcr.ItemNotFoundException: 8f595037-32f4-47ac-889e-047e813987bc
2009-05-14 13:31:33,229 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 812d56a5-ccd7-4d7d-8103-8bbba7943b53: javax.jcr.ItemNotFoundException: 812d56a5-ccd7-4d7d-8103-8bbba7943b53
2009-05-14 13:31:33,230 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 7b30f0f2-0d93-4589-a7ce-1934f4dc2094: javax.jcr.ItemNotFoundException: 7b30f0f2-0d93-4589-a7ce-1934f4dc2094
2009-05-14 13:31:33,231 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 68ef4dff-9dbe-4ea6-b2c3-292f2cae7007: javax.jcr.ItemNotFoundException: 68ef4dff-9dbe-4ea6-b2c3-292f2cae7007
2009-05-14 13:31:33,231 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 3a549cb1-8ef0-4815-82f7-ae7b2f316fbb: javax.jcr.ItemNotFoundException: 3a549cb1-8ef0-4815-82f7-ae7b2f316fbb
2009-05-14 13:31:33,231 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 1274b14d-10af-4abe-9b36-85acb2cef94f: javax.jcr.ItemNotFoundException: 1274b14d-10af-4abe-9b36-85acb2cef94f
2009-05-14 13:31:33,232 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: 0472e065-efdb-4580-9c22-c843ca3b88e8: javax.jcr.ItemNotFoundException: 0472e065-efdb-4580-9c22-c843ca3b88e8
2009-05-14 13:31:33,233 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: ae23658e-861c-4145-bea5-58c0fe004101: javax.jcr.ItemNotFoundException: ae23658e-861c-4145-bea5-58c0fe004101
2009-05-14 13:31:33,233 [WARN ] (o.a.j.c.q.l.QueryResultImpl:494) - Exception retrieving Node with UUID: da4db77c-a20e-4f28-b287-ab291e1f137e: javax.jcr.ItemNotFoundException: da4db77c-a20e-4f28-b287-ab291e1f137e
...
...
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.jfrog.org/jira/secure/Administrators.jspa-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled.
http://p.sf.net/sfu/kodak-com_______________________________________________
Artifactory-developers mailing list
Artifactory-developers@...
https://lists.sourceforge.net/lists/listinfo/artifactory-developers
