Dev - sendGenericNotificationEmail ERROR
Locked
 
|
Hi there,
I found these ERROR message all over my log files and my log files' size increse very quick to reach several gig easily. I understand that was because I did not set the right SMTP server for out going mail, but is there a way under my development stage to stop this repeating thing, so, I can easily see some more useful information in the log file? Thanks in advance. Lei _______________________________________________ Dev mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/dev |
Re: Dev - sendGenericNotificationEmail ERROR
|
|
Which revision of OFBiz are you using? It sounds like it may be an older one... -David Lei Gao wrote: > Hi there, > > I found these ERROR message all over my log files and my log files' size > increse very quick to reach several gig easily. I understand that was > because I did not set the right SMTP server for out going mail, but is > there a way under my development stage to stop this repeating thing, so, > I can easily see some more useful information in the log file? > > Thanks in advance. > Lei > > > ------------------------------------------------------------------------ > > > _______________________________________________ > Dev mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/dev _______________________________________________ Dev mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/dev |
|
|
Yes David,
It is an older version, I stopped sync the code with SVN, and I have to do that because I did some customized change for the customer. What I want to do is just try to diable the mail notification feature. I looked at the general.properties, and it says mail.notifications.enabled=N So, whereelse I need to check to disable this scheduled mail notification? Thanks Lei On 3/15/06,
David E. Jones <[hidden email]> wrote:
_______________________________________________ Dev mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/dev |
Re: Dev - sendGenericNotificationEmail ERROR
|
|
In reply to this post by Lei Gao-2
On Wed, 15 Mar 2006, Lei Gao wrote:
> Hi there, > > I found these ERROR message all over my log files and my log files' size > increse very quick to reach several gig easily. I understand that was > because I did not set the right SMTP server for out going mail, but is there > a way under my development stage to stop this repeating thing, so, I can > easily see some more useful information in the log file? What errors did you see? I see no paste from you. _______________________________________________ Dev mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/dev |
Re: Dev - sendGenericNotificationEmail ERROR
|
|
In reply to this post by Lei Gao-2
If you have failed services queued up in an order version of OFBiz they have to be killed manually either in the WebTools webapp, or in the JobSandbox entity's table directly in the database. There was a discussion on this a little while back, I believe in the users mailing list (which is where this should really go as it concerns use of OFBiz and not development of OFBiz). The person requesting help for the issue was not very friendly, but there were some good replies with detailed information anyway. -David Lei Gao wrote: > Yes David, > > It is an older version, I stopped sync the code with SVN, and I have to > do that because I did some customized change for the customer. > > What I want to do is just try to diable the mail notification feature. I > looked at the general.properties, and it says > mail.notifications.enabled=N > > So, whereelse I need to check to disable this scheduled mail notification? > > Thanks > Lei > > > > > On 3/15/06, *David E. Jones* <[hidden email] > <mailto:[hidden email]>> wrote: > > > Which revision of OFBiz are you using? It sounds like it may be an > older one... > > -David > > > Lei Gao wrote: > > Hi there, > > > > I found these ERROR message all over my log files and my log > files' size > > increse very quick to reach several gig easily. I understand that was > > because I did not set the right SMTP server for out going mail, > but is > > there a way under my development stage to stop this repeating > thing, so, > > I can easily see some more useful information in the log file? > > > > Thanks in advance. > > Lei > > > > > > > ------------------------------------------------------------------------ > > > > > > _______________________________________________ > > Dev mailing list > > [hidden email] <mailto:[hidden email]> > > http://lists.ofbiz.org/mailman/listinfo/dev > > _______________________________________________ > Dev mailing list > [hidden email] <mailto:[hidden email]> > http://lists.ofbiz.org/mailman/listinfo/dev > > > > ------------------------------------------------------------------------ > > > _______________________________________________ > Dev mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/dev _______________________________________________ Dev mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/dev |
|
|
Hi Adam/David
Here is part of my log files, in case you know a quick answer for this issue. I will do a search in the mailing list first and try to see if I could find my answer in the mailing list. The database I am using is MySQL 5.0. Thanks very much. Lei ------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---- exception report ---------------------------------------------------------- Unable to remove job : [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2006-02-10 22:39:03.0(java.sql.Timestamp)][createdTxStamp,2006-02-10 22:39:03.0(java.sql.Timestamp)][finishDateTime,2006-02-10 22:42: 05.0(java.sql.Timestamp)][jobId,10919(java.lang.String)][jobName,1139573146297(java.lang.String)][lastUpdatedStamp,2006-02-10 22:42:05.0(java.sql.Timestamp)][lastUpdatedTxStamp,2006-02-10 22:42:05.0(java.sql.Timestamp)][loaderName,order( java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,10030(java.lang.String)][poolId,pool(java.lang.String)][previousJobId,10916(java.lang.String)][recurrenceInfoId,null()][runAsUser,null()][runByInstanceId,ofbiz1( java.lang.String)][runTime,2006-02-10 22:42:03.0(java.sql.Timestamp)][runtimeDataId,10011(java.lang.String)][serviceName,sendOrderDeliveryScheduleNotification(java.lang.String)][startDateTime,2006-02-10 22:42:05.0(java.sql.Timestamp )][statusId,SERVICE_FAILED(java.lang.String)]; org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in removeValue operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Exception while deleting the following entity: [GenericEntity:JobSandbox][jobId,10006(java.lang.String)] (SQL Exception while executing the following:DELETE FROM JOB_SANDBOX WHERE JOB_ID=? (Lock wait timeout exceeded; try restarting transaction)). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Exception while deleting the following entity: [GenericEntity:JobSandbox][jobId,10006(java.lang.String)] (SQL Exception while executing the following:DELETE FROM JOB_SANDBOX WHERE JOB_ID=? (Lock wait timeout exceeded; try restarting transaction)) (Exception while deleting the following entity: [GenericEntity:JobSandbox][jobId,10006( java.lang.String)] (SQL Exception while executing the following:DELETE FROM JOB_SANDBOX WHERE JOB_ID=? (Lock wait timeout exceeded; try restarting transaction))) Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in removeValue operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException : Exception while deleting the following entity: [GenericEntity:JobSandbox][jobId,10006(java.lang.String)] (SQL Exception while executing the following:DELETE FROM JOB_SANDBOX WHERE JOB_ID=? (Lock wait timeout exceeded; try restarting transaction)). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Exception while deleting the following entity: [GenericEntity:JobSandbox][jobId,10006(java.lang.String)] (SQL Exception while executing the following:DELETE FROM JOB_SANDBOX WHERE JOB_ID=? (Lock wait timeout exceeded; try restarting transaction)) (Exception while deleting the following entity: [GenericEntity:JobSandbox][jobId,10006( java.lang.String)] (SQL Exception while executing the following:DELETE FROM JOB_SANDBOX WHERE JOB_ID=? (Lock wait timeout exceeded; try restarting transaction))) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in removeValue operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Exception while deleting the following entity: [GenericEntity:JobSandbox][jobId,10006(java.lang.String)] (SQL Exception while executing the following:DELETE FROM JOB_SANDBOX WHERE JOB_ID=? (Lock wait timeout exceeded; try restarting transaction)). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Exception while deleting the following entity: [GenericEntity:JobSandbox][jobId,10006(java.lang.String)] (SQL Exception while executing the following:DELETE FROM JOB_SANDBOX WHERE JOB_ID=? (Lock wait timeout exceeded; try restarting transaction)) (Exception while deleting the following entity: [GenericEntity:JobSandbox][jobId,10006( java.lang.String)] (SQL Exception while executing the following:DELETE FROM JOB_SANDBOX WHERE JOB_ID=? (Lock wait timeout exceeded; try restarting transaction))) org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java :85) org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:57) org.ofbiz.entity.GenericDelegator.removeValue(GenericDelegator.java:754) org.ofbiz.entity.GenericDelegator.removeValue(GenericDelegator.java :741) org.ofbiz.entity.GenericValue.remove(GenericValue.java:129) org.ofbiz.service.ServiceUtil.purgeOldJobs(ServiceUtil.java:372) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:324) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker (StandardJavaEngine.java:101) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:339) org.ofbiz.service.ServiceDispatcher.runSync (ServiceDispatcher.java:213) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) org.ofbiz.service.job.JobInvoker.run(JobInvoker.java :226) java.lang.Thread.run(Thread.java:534) org.ofbiz.entity.GenericDataSourceException: Exception while deleting the following entity: [GenericEntity:JobSandbox][jobId,10006(java.lang.String)] (SQL Exception while executing the following:DELETE FROM JOB_SANDBOX WHERE JOB_ID=? (Lock wait timeout exceeded; try restarting transaction)) org.ofbiz.entity.datasource.GenericDAO.delete(GenericDAO.java:1041) org.ofbiz.entity.datasource.GenericHelperDAO.removeByPrimaryKey(GenericHelperDAO.java:137) org.ofbiz.entity.GenericDelegator.removeValue(GenericDelegator.java :768) org.ofbiz.entity.GenericDelegator.removeValue(GenericDelegator.java:741) org.ofbiz.entity.GenericValue.remove(GenericValue.java:129) org.ofbiz.service.ServiceUtil.purgeOldJobs(ServiceUtil.java:372) sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke( Method.java:324) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) org.ofbiz.service.ServiceDispatcher.runSync (ServiceDispatcher.java:339) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110) org.ofbiz.service.job.GenericServiceJob.exec (GenericServiceJob.java:80) org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) java.lang.Thread.run(Thread.java:534) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:DELETE FROM JOB_SANDBOX WHERE JOB_ID=? (Lock wait timeout exceeded; try restarting transaction) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:439) org.ofbiz.entity.datasource.GenericDAO.delete(GenericDAO.java:1063) org.ofbiz.entity.datasource.GenericDAO.delete(GenericDAO.java:1038) org.ofbiz.entity.datasource.GenericHelperDAO.removeByPrimaryKey(GenericHelperDAO.java:137) org.ofbiz.entity.GenericDelegator.removeValue(GenericDelegator.java:768) org.ofbiz.entity.GenericDelegator.removeValue(GenericDelegator.java :741) org.ofbiz.entity.GenericValue.remove(GenericValue.java:129) org.ofbiz.service.ServiceUtil.purgeOldJobs(ServiceUtil.java:372) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:324) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker (StandardJavaEngine.java:101) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:339) org.ofbiz.service.ServiceDispatcher.runSync (ServiceDispatcher.java:213) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) org.ofbiz.service.job.JobInvoker.run(JobInvoker.java :226) java.lang.Thread.run(Thread.java:534) java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1571) com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124) com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676) com.mysql.jdbc.PreparedStatement.executeUpdate (PreparedStatement.java:1166) com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082) com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067) org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate (PreparedStatementInPool.java:82) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:436) org.ofbiz.entity.datasource.GenericDAO.delete(GenericDAO.java:1063) org.ofbiz.entity.datasource.GenericDAO.delete (GenericDAO.java:1038) org.ofbiz.entity.datasource.GenericHelperDAO.removeByPrimaryKey(GenericHelperDAO.java:137) org.ofbiz.entity.GenericDelegator.removeValue(GenericDelegator.java:768) org.ofbiz.entity.GenericDelegator.removeValue (GenericDelegator.java:741) org.ofbiz.entity.GenericValue.remove(GenericValue.java:129) org.ofbiz.service.ServiceUtil.purgeOldJobs(ServiceUtil.java:372) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:324) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) org.ofbiz.service.ServiceDispatcher.runSync (ServiceDispatcher.java:339) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110) org.ofbiz.service.job.GenericServiceJob.exec (GenericServiceJob.java:80) org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) java.lang.Thread.run(Thread.java:534) -------------------------------------------------------------------------------- On 3/15/06, David E. Jones <[hidden email]> wrote:
_______________________________________________ Dev mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/dev |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |