search

UnifiedViews / Core

UnifiedViews
https://www.poolparty.biz/agile-data-integration
Other
30 stars 7 forks source link

Frontend does not respond #353

Open skodapetr opened 9 years ago

skodapetr commented 9 years ago

Best to my knowledge happened twice so far. Frontend page does not load, there is no error in log only following message:

2015-04-07 08:13:36,165 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (146815)
2015-04-07 08:13:36,165 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (146816)
2015-04-07 08:13:36,165 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (146815) in: 0 ms
2015-04-07 08:13:36,166 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (146816) in: 1 ms
2015-04-07 08:13:36,178 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (146817)
2015-04-07 08:13:36,179 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (146817) in: 1 ms
2015-04-07 08:13:36,196 [http-nio-8080-exec-3] DEBUG org.eclipse.persistence.logging.sql - 2015-04-07 08:13:36.195--ServerSession(541706000)--Connection(1495393060)--SELECT ID AS a1, NAME AS a2, VALUE AS a3 FROM runtime_properties WHERE (NAME = ?) LIMIT ?, ?
        bind => [locale, 0, 1]
2015-04-07 08:13:36,197 [http-nio-8080-exec-3] DEBUG org.eclipse.persistence.logging.sql - 2015-04-07 08:13:36.197--ServerSession(541706000)--SELECT 1
2015-04-07 08:13:36,199 [http-nio-8080-exec-3] INFO  org.eclipse.persistence.logging.default - 2015-04-07 08:13:36.199--UnitOfWork(278307436)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was80932 seconds ago.The last packet sent successfully to the server was 80932 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT ID AS a1, NAME AS a2, VALUE AS a3 FROM runtime_properties WHERE (NAME = ?) LIMIT ?, ?
        bind => [locale, 0, 1]
Query: ReadAllQuery(referenceClass=RuntimeProperty sql="SELECT ID AS a1, NAME AS a2, VALUE AS a3 FROM runtime_properties WHERE (NAME = ?) LIMIT ?, ?").
2015-04-07 08:13:36,200 [http-nio-8080-exec-3] DEBUG org.eclipse.persistence.logging.sql - 2015-04-07 08:13:36.2--ServerSession(541706000)--Connection(1919609224)--SELECT ID AS a1, NAME AS a2, VALUE AS a3 FROM runtime_properties WHERE (NAME = ?) LIMIT ?, ?
        bind => [locale, 0, 1]
2015-04-07 08:13:36,200 [http-nio-8080-exec-3] DEBUG org.eclipse.persistence.logging.sql - 2015-04-07 08:13:36.2--ServerSession(541706000)--SELECT 1
2015-04-07 08:13:36,201 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (146818)
2015-04-07 08:13:36,202 [http-nio-8080-exec-5] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (146819)
2015-04-07 08:13:36,202 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (146818) in: 1 ms
2015-04-07 08:13:36,202 [http-nio-8080-exec-5] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (146819) in: 0 ms
2015-04-07 08:13:36,203 [http-nio-8080-exec-3] INFO  org.eclipse.persistence.logging.default - 2015-04-07 08:13:36.202--UnitOfWork(278307436)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was114434 seconds ago.The last packet sent successfully to the server was 114434 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT ID AS a1, NAME AS a2, VALUE AS a3 FROM runtime_properties WHERE (NAME = ?) LIMIT ?, ?
        bind => [locale, 0, 1]
Query: ReadAllQuery(referenceClass=RuntimeProperty sql="SELECT ID AS a1, NAME AS a2, VALUE AS a3 FROM runtime_properties WHERE (NAME = ?) LIMIT ?, ?").
2015-04-07 08:13:36,244 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (146820)
2015-04-07 08:13:36,245 [http-nio-8080-exec-9] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (146821)
2015-04-07 08:13:36,246 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (146820) in: 2 ms
2015-04-07 08:13:36,246 [http-nio-8080-exec-9] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (146821) in: 1 ms
2015-04-07 08:14:32,204 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (146822)
2015-04-07 08:14:32,205 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (146822) in: 1 ms
2015-04-07 08:14:32,211 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (146823)
2015-04-07 08:14:32,211 [http-nio-8080-exec-1] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
tomas-knap commented 9 years ago

Based on Petr Skoda's feedback, it happens from time to time. Not planned for 2.1 now

skodapetr commented 9 years ago

Happened again:


2015-04-18 15:25:09,752 [http-nio-8080-exec-8] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (74849)
2015-04-18 15:25:09,753 [http-nio-8080-exec-8] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (74849) in: 1 ms
2015-04-18 15:25:09,760 [http-nio-8080-exec-10] DEBUG org.eclipse.persistence.logging.sql - 2015-04-18 15:25:09.759--ServerSession(541706000)--Connection(540520008)--SELECT ID AS a1, NAME AS a2, VALUE AS a3 FROM runtime_properties WHERE (NAME = ?) LIMIT ?, ?
        bind => [locale, 0, 1]
2015-04-18 15:25:09,761 [http-nio-8080-exec-10] DEBUG org.eclipse.persistence.logging.sql - 2015-04-18 15:25:09.761--ServerSession(541706000)--SELECT 1
2015-04-18 15:25:09,763 [http-nio-8080-exec-10] INFO  org.eclipse.persistence.logging.default - 2015-04-18 15:25:09.762--UnitOfWork(1755111621)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was73679 seconds ago.The last packet sent successfully to the server was 73679 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT ID AS a1, NAME AS a2, VALUE AS a3 FROM runtime_properties WHERE (NAME = ?) LIMIT ?, ?
        bind => [locale, 0, 1]
Query: ReadAllQuery(referenceClass=RuntimeProperty sql="SELECT ID AS a1, NAME AS a2, VALUE AS a3 FROM runtime_properties WHERE (NAME = ?) LIMIT ?, ?").
skodapetr commented 9 years ago 
2015-05-12 07:43:00,183 [http-nio-8080-exec-36] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: PipelineListPresenterImpl for url: PipelineList
2015-05-12 07:43:00,189 [http-nio-8080-exec-36] DEBUG org.eclipse.persistence.logging.sql - 2015-05-12 07:43:00.189--ServerSession(711381977)--Connection(1082898106)--SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
2015-05-12 07:43:00,190 [http-nio-8080-exec-36] DEBUG org.eclipse.persistence.logging.sql - 2015-05-12 07:43:00.19--ServerSession(711381977)--SELECT 1
2015-05-12 07:43:00,193 [http-nio-8080-exec-36] INFO  org.eclipse.persistence.logging.default - 2015-05-12 07:43:00.192--UnitOfWork(717052274)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was52878 seconds ago.The last packet sent successfully to the server was 52878 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
Query: ReadAllQuery(referenceClass=User sql="SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?").
skodapetr commented 9 years ago 
2015-05-25 08:16:47,237 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (83168) in: 135 ms
2015-05-25 08:16:47,843 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (83173)
2015-05-25 08:16:47,844 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (83173) in: 1 ms
2015-05-25 08:16:47,864 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (83174)
2015-05-25 08:16:47,865 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (83174) in: 1 ms
2015-05-25 08:16:50,823 [http-nio-8080-exec-3] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (83175)
2015-05-25 08:16:50,826 [http-nio-8080-exec-3] DEBUG org.eclipse.persistence.logging.sql - 2015-05-25 08:16:50.826--ServerSession(950568986)--Connection(2049729485)--SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
2015-05-25 08:16:50,828 [http-nio-8080-exec-3] DEBUG org.eclipse.persistence.logging.sql - 2015-05-25 08:16:50.828--ServerSession(950568986)--SELECT 1
2015-05-25 08:16:50,830 [http-nio-8080-exec-3] INFO  org.eclipse.persistence.logging.default - 2015-05-25 08:16:50.83--UnitOfWork(1809363643)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was48840 seconds ago.The last packet sent successfully to the server was 48840 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
Query: ReadAllQuery(referenceClass=User sql="SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?").
skodapetr commented 9 years ago 

2015-06-01 09:29:07,225 [http-nio-8080-exec-5] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: PipelineEdit for url: PipelineEdit
2015-06-01 09:29:07,226 [http-nio-8080-exec-5] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Settings for url: Administrator
2015-06-01 09:29:07,226 [http-nio-8080-exec-5] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Login for url: Login
2015-06-01 09:29:07,226 [http-nio-8080-exec-5] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Initial for url:
2015-06-01 09:29:07,226 [http-nio-8080-exec-5] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Scheduler for url: Scheduler
2015-06-01 09:29:07,314 [http-nio-8080-exec-5] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: DPUPresenterImpl for url: DPURecord
2015-06-01 09:29:07,315 [http-nio-8080-exec-5] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: ExecutionListPresenterImpl for url: ExecutionList
2015-06-01 09:29:07,315 [http-nio-8080-exec-5] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: PipelineListPresenterImpl for url: PipelineList
2015-06-01 09:29:07,321 [http-nio-8080-exec-5] DEBUG org.eclipse.persistence.logging.sql - 2015-06-01 09:29:07.32--ServerSession(950568986)--Connection(454112542)--SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
2015-06-01 09:29:07,323 [http-nio-8080-exec-5] DEBUG org.eclipse.persistence.logging.sql - 2015-06-01 09:29:07.322--ServerSession(950568986)--SELECT 1
2015-06-01 09:29:07,325 [http-nio-8080-exec-5] INFO  org.eclipse.persistence.logging.default - 2015-06-01 09:29:07.325--UnitOfWork(1076187372)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was54231 seconds ago.The last packet sent successfully to the server was 54231 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
Query: ReadAllQuery(referenceClass=User sql="SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?").
2015-06-01 09:29:07,326 [http-nio-8080-exec-5] DEBUG org.eclipse.persistence.logging.sql - 2015-06-01 09:29:07.325--ServerSession(950568986)--Connection(1325165606)--SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
2015-06-01 09:29:07,326 [http-nio-8080-exec-5] DEBUG org.eclipse.persistence.logging.sql - 2015-06-01 09:29:07.326--ServerSession(950568986)--SELECT 1
2015-06-01 09:29:07,328 [http-nio-8080-exec-5] INFO  org.eclipse.persistence.logging.default - 2015-06-01 09:29:07.328--UnitOfWork(1076187372)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was55722 seconds ago.The last packet sent successfully to the server was 55722 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
Query: ReadAllQuery(referenceClass=User sql="SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?").
2015-06-01 09:29:53,460 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (98451)
skodapetr commented 9 years ago 
2015-06-27 14:28:40,728 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78742)
2015-06-27 14:28:40,730 [http-nio-8080-exec-10] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 14:28:40,731 [http-nio-8080-exec-10] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 14:28:40,733 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78742) in: 5 ms
2015-06-27 15:50:16,553 [http-nio-8080-exec-9] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78743)
2015-06-27 15:50:16,553 [http-nio-8080-exec-9] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78743) in: 0 ms
2015-06-27 15:50:16,585 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78744)
2015-06-27 15:50:16,586 [http-nio-8080-exec-1] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:50:16,586 [http-nio-8080-exec-1] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:50:16,587 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78744) in: 2 ms
2015-06-27 15:50:16,760 [http-nio-8080-exec-8] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78745)
2015-06-27 15:50:16,761 [http-nio-8080-exec-8] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78745) in: 1 ms
2015-06-27 15:50:16,807 [http-nio-8080-exec-3] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78746)
2015-06-27 15:50:16,808 [http-nio-8080-exec-3] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78746) in: 1 ms
2015-06-27 15:50:16,834 [http-nio-8080-exec-5] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78747)
2015-06-27 15:50:16,834 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78748)
2015-06-27 15:50:16,834 [http-nio-8080-exec-5] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78747) in: 0 ms
2015-06-27 15:50:16,834 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78748) in: 0 ms
2015-06-27 15:50:16,850 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78749)
2015-06-27 15:50:16,850 [http-nio-8080-exec-2] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:50:16,850 [http-nio-8080-exec-2] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:50:16,850 [http-nio-8080-exec-2] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:50:16,925 [http-nio-8080-exec-2] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: PipelineEdit for url: PipelineEdit
2015-06-27 15:50:16,925 [http-nio-8080-exec-2] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Settings for url: Administrator
2015-06-27 15:50:16,925 [http-nio-8080-exec-2] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Login for url: Login
2015-06-27 15:50:16,925 [http-nio-8080-exec-2] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Initial for url:
2015-06-27 15:50:16,925 [http-nio-8080-exec-2] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Scheduler for url: Scheduler
2015-06-27 15:50:16,972 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78750)
2015-06-27 15:50:16,972 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78750) in: 0 ms
2015-06-27 15:50:16,984 [http-nio-8080-exec-2] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: DPUPresenterImpl for url: DPURecord
2015-06-27 15:50:16,984 [http-nio-8080-exec-2] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: ExecutionListPresenterImpl for url: ExecutionList
2015-06-27 15:50:16,984 [http-nio-8080-exec-2] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: PipelineListPresenterImpl for url: PipelineList
2015-06-27 15:50:16,986 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78751)
2015-06-27 15:50:16,987 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78751) in: 1 ms
2015-06-27 15:50:16,988 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78749) in: 138 ms
2015-06-27 15:50:17,017 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78752)
2015-06-27 15:50:17,018 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78752) in: 1 ms
2015-06-27 15:50:18,078 [http-nio-8080-exec-9] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78753)
2015-06-27 15:50:18,079 [http-nio-8080-exec-9] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78753) in: 1 ms
2015-06-27 15:50:18,109 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78754)
2015-06-27 15:50:18,110 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78754) in: 1 ms
2015-06-27 15:50:21,157 [http-nio-8080-exec-8] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78755)
2015-06-27 15:50:21,159 [http-nio-8080-exec-8] DEBUG org.eclipse.persistence.logging.sql - 2015-06-27 15:50:21.159--ServerSession(972812358)--Connection(1693263100)--SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
2015-06-27 15:50:21,160 [http-nio-8080-exec-8] DEBUG org.eclipse.persistence.logging.sql - 2015-06-27 15:50:21.16--ServerSession(972812358)--SELECT 1
2015-06-27 15:50:21,162 [http-nio-8080-exec-8] INFO  org.eclipse.persistence.logging.default - 2015-06-27 15:50:21.161--UnitOfWork(996793351)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was62329 seconds ago.The last packet sent successfully to the server was 62329 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
Query: ReadAllQuery(referenceClass=User sql="SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?").
2015-06-27 15:50:21,162 [http-nio-8080-exec-8] DEBUG org.eclipse.persistence.logging.sql - 2015-06-27 15:50:21.162--ServerSession(972812358)--Connection(210867938)--SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
2015-06-27 15:50:21,163 [http-nio-8080-exec-8] DEBUG org.eclipse.persistence.logging.sql - 2015-06-27 15:50:21.163--ServerSession(972812358)--SELECT 1
2015-06-27 15:50:21,164 [http-nio-8080-exec-8] INFO  org.eclipse.persistence.logging.default - 2015-06-27 15:50:21.164--UnitOfWork(996793351)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was83684 seconds ago.The last packet sent successfully to the server was 83684 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
Query: ReadAllQuery(referenceClass=User sql="SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?").
2015-06-27 15:50:22,658 [http-nio-8080-exec-3] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78756)
2015-06-27 15:50:22,659 [http-nio-8080-exec-3] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78756) in: 1 ms
2015-06-27 15:50:26,219 [http-nio-8080-exec-5] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78757)
2015-06-27 15:50:26,220 [http-nio-8080-exec-5] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78757) in: 1 ms
2015-06-27 15:50:47,685 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78758)
2015-06-27 15:50:47,686 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78758) in: 1 ms
2015-06-27 15:52:00,238 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78759)
2015-06-27 15:52:00,238 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78759) in: 0 ms
2015-06-27 15:52:00,287 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78760)
2015-06-27 15:52:00,288 [http-nio-8080-exec-7] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:52:00,288 [http-nio-8080-exec-7] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:52:00,289 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78760) in: 2 ms
2015-06-27 15:52:00,353 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78761)
2015-06-27 15:52:00,354 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78761) in: 1 ms
2015-06-27 15:52:00,363 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78762)
2015-06-27 15:52:00,363 [http-nio-8080-exec-10] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:52:00,363 [http-nio-8080-exec-10] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:52:00,364 [http-nio-8080-exec-10] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:52:00,420 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: PipelineEdit for url: PipelineEdit
2015-06-27 15:52:00,420 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Settings for url: Administrator
2015-06-27 15:52:00,420 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Login for url: Login
2015-06-27 15:52:00,420 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Initial for url:
2015-06-27 15:52:00,420 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Scheduler for url: Scheduler
2015-06-27 15:52:00,470 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: DPUPresenterImpl for url: DPURecord
2015-06-27 15:52:00,470 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: ExecutionListPresenterImpl for url: ExecutionList
2015-06-27 15:52:00,470 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: PipelineListPresenterImpl for url: PipelineList
2015-06-27 15:52:00,473 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78762) in: 110 ms
2015-06-27 15:52:03,688 [http-nio-8080-exec-9] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78763)
2015-06-27 15:52:10,751 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78764)
2015-06-27 15:52:10,752 [http-nio-8080-exec-1] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:52:10,752 [http-nio-8080-exec-1] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:52:10,753 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78764) in: 2 ms
2015-06-27 15:54:03,808 [http-nio-8080-exec-3] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78765)
2015-06-27 15:56:04,536 [http-nio-8080-exec-5] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78766)
2015-06-27 15:56:43,899 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78767)
2015-06-27 15:56:43,899 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78767) in: 0 ms
2015-06-27 15:56:43,983 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78768)
2015-06-27 15:56:43,983 [http-nio-8080-exec-6] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:56:43,983 [http-nio-8080-exec-6] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:56:43,984 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78768) in: 1 ms
2015-06-27 15:56:44,900 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78769)
2015-06-27 15:56:44,900 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78769) in: 0 ms
2015-06-27 15:56:44,910 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78770)
2015-06-27 15:56:44,911 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78770) in: 1 ms
2015-06-27 15:56:44,925 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78771)
2015-06-27 15:56:44,926 [http-nio-8080-exec-10] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:56:44,926 [http-nio-8080-exec-10] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:56:44,926 [http-nio-8080-exec-10] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:56:44,983 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: PipelineEdit for url: PipelineEdit
2015-06-27 15:56:44,983 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Settings for url: Administrator
2015-06-27 15:56:44,983 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Login for url: Login
2015-06-27 15:56:44,983 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Initial for url:
2015-06-27 15:56:44,983 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding view: Scheduler for url: Scheduler
2015-06-27 15:56:45,032 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: DPUPresenterImpl for url: DPURecord
2015-06-27 15:56:45,032 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: ExecutionListPresenterImpl for url: ExecutionList
2015-06-27 15:56:45,032 [http-nio-8080-exec-10] DEBUG c.c.m.x.o.frontend.navigation.ClassNavigatorImpl - Adding presenter: PipelineListPresenterImpl for url: PipelineList
2015-06-27 15:56:45,034 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78771) in: 109 ms
2015-06-27 15:56:48,240 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78772)
2015-06-27 15:57:38,028 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78773)
2015-06-27 15:57:38,028 [http-nio-8080-exec-4] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:57:38,028 [http-nio-8080-exec-4] DEBUG ru.xpoft.vaadin.SpringUIProvider - found BEAN_NAME_PARAMETER: ui
2015-06-27 15:57:38,030 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78773) in: 2 ms
2015-06-27 15:57:38,066 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78774)
2015-06-27 15:57:38,067 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78774) in: 1 ms
2015-06-27 15:57:38,137 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78775)
2015-06-27 15:57:38,137 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78776)
2015-06-27 15:57:38,137 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78775) in: 0 ms
2015-06-27 15:57:38,137 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (78776) in: 0 ms
2015-06-27 15:57:38,145 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (78777)
skrchnavy commented 9 years ago

@skodape please provide info about versions you have used when error occurred (or commit numbers if using code not from master - tagged version)

skodapetr commented 9 years ago 
2015-07-24 08:02:11,965 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (103147)
2015-07-24 08:02:11,965 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (103147) in: 0 ms
2015-07-24 08:02:16,948 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (103148)
2015-07-24 08:02:16,948 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (103148) in: 0 ms
2015-07-24 08:02:21,970 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (103149)
2015-07-24 08:02:21,971 [http-nio-8080-exec-4] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (103149) in: 1 ms
2015-07-24 08:02:26,966 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (103150)
2015-07-24 08:02:26,967 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (103150) in: 1 ms
2015-07-24 08:02:31,947 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (103151)
2015-07-24 08:02:31,947 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (103151) in: 0 ms
2015-07-24 08:02:36,947 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (103152)
2015-07-24 08:02:36,948 [http-nio-8080-exec-2] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (103152) in: 1 ms
2015-07-24 08:02:40,746 [http-nio-8080-exec-9] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (103153)
2015-07-24 08:02:40,749 [http-nio-8080-exec-9] DEBUG org.eclipse.persistence.logging.sql - 2015-07-24 08:02:40.748--ServerSession(468779550)--Connection(693933608)--SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
2015-07-24 08:02:40,750 [http-nio-8080-exec-9] DEBUG org.eclipse.persistence.logging.sql - 2015-07-24 08:02:40.75--ServerSession(468779550)--SELECT 1
2015-07-24 08:02:40,752 [http-nio-8080-exec-9] INFO  org.eclipse.persistence.logging.default - 2015-07-24 08:02:40.752--UnitOfWork(1227420504)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was44697 seconds ago.The last packet sent successfully to the server was 44697 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
Query: ReadAllQuery(referenceClass=User sql="SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?").
2015-07-24 08:02:42,318 [http-nio-8080-exec-3] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (103154)
2015-07-24 08:02:42,320 [http-nio-8080-exec-3] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (103154) in: 2 ms
2015-07-24 08:02:45,747 [http-nio-8080-exec-8] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (103155)
2015-07-24 08:02:45,749 [http-nio-8080-exec-8] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (103155) in: 2 ms
2015-07-24 08:03:06,047 [http-nio-8080-exec-5] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (103156)
2015-07-24 08:03:06,789 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (103157)
2015-07-24 08:03:06,791 [http-nio-8080-exec-10] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (103157) in: 2 ms
skodapetr commented 9 years ago

Commit used: https://github.com/UnifiedViews/Core/commit/98a33c426b7ebb00f7a3e1ae9eabb4224c363f11

skodapetr commented 9 years ago 
2015-08-03 10:23:00,788 [http-nio-8080-exec-7] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (86029) in: 2 ms
2015-08-03 10:23:00,891 [http-nio-8080-exec-9] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (86030)
2015-08-03 10:23:00,894 [http-nio-8080-exec-9] DEBUG org.eclipse.persistence.logging.sql - 2015-08-03 10:23:00.894--ServerSession(972812358)--Connection(2060456752)--SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
2015-08-03 10:23:00,896 [http-nio-8080-exec-9] DEBUG org.eclipse.persistence.logging.sql - 2015-08-03 10:23:00.895--ServerSession(972812358)--SELECT 1
2015-08-03 10:23:00,898 [http-nio-8080-exec-9] INFO  org.eclipse.persistence.logging.default - 2015-08-03 10:23:00.897--UnitOfWork(430129354)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was42223 seconds ago.The last packet sent successfully to the server was 42223 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
Query: ReadAllQuery(referenceClass=User sql="SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?").
2015-08-03 10:23:02,397 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (86031)
2015-08-03 10:23:02,398 [http-nio-8080-exec-1] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (86031) in: 1 ms
2015-08-03 10:23:05,897 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - > service (86032)
2015-08-03 10:23:05,911 [http-nio-8080-exec-6] INFO  c.c.mff.xrg.odcs.frontend.ODCSApplicationServlet - < service (86032) in: 14 ms
tomas-knap commented 9 years ago

It seems that there is some transaction, which does not finish within the given timeout. But it is strange that it happens on rather tiny tables. More examination is needed.

skodapetr commented 9 years ago 
2015-08-20 11:46:26,863 [http-nio-8080-exec-7] DEBUG org.eclipse.persistence.logging.sql - 2015-08-20 11:46:26.863--ServerSession(1308180928)--Connection(1038477646)--SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
2015-08-20 11:46:26,864 [http-nio-8080-exec-7] DEBUG org.eclipse.persistence.logging.sql - 2015-08-20 11:46:26.864--ServerSession(1308180928)--SELECT 1
2015-08-20 11:46:26,867 [http-nio-8080-exec-7] INFO  org.eclipse.persistence.logging.default - 2015-08-20 11:46:26.865--UnitOfWork(4077001)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was73306 seconds ago.The last packet sent successfully to the server was 73306 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Error Code: 0
Call: SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?
        bind => [xrg, 0, 1]
Query: ReadAllQuery(referenceClass=User sql="SELECT t0.ID AS a1, t1.id_usr AS a2, t1.id_extuser AS a3, t0.full_name AS a4, t0.u_password AS a5, t0.table_rows AS a6, t0.USERNAME AS a7, t0.email_id AS a8 FROM usr_user t0, usr_extuser t1 WHERE ((t0.USERNAME = ?) AND (t1.id_usr = t0.ID)) LIMIT ?, ?").```