[
http://mifosforge.jira.com/browse/MIFOS-4351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=63087#action_63087
]
Udai Gupta edited comment on MIFOS-4351 at 12/21/10 6:22 AM:
-------------------------------------------------------------
Final conclusion:
Use in mysql configuration.
\[mysqld\]
\# 25 hours, batch job run once in 24 hours
wait_timeout = 90000
read more
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_wait_timeout
we should not use autoReconnect JDBC property,
"Should the driver try to re-establish stale and/or dead connections? If
enabled the driver will throw an exception for a queries issued on a stale or
dead connection, which belong to the current transaction, but will attempt
reconnect before the next query issued on the connection in a new transaction.
The use of this feature is not recommended, because it has side effects related
to session state and data consistency when applications don't handle
SQLExceptions properly, and is only designed to be used when you are unable to
configure your application to handle SQLExceptions resulting from dead and
stale connections properly. Alternatively, investigate setting the MySQL server
variable "wait_timeout" to some high value rather than the default of 8 hours."
from
http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html
was (Author: ugupta):
Final conclusion:
Use in mysql configuration.
\[mysqld\]
# 25 hours
wait_timeout = 90000
read more
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_wait_timeout
we should not use autoReconnect JDBC property,
"Should the driver try to re-establish stale and/or dead connections? If
enabled the driver will throw an exception for a queries issued on a stale or
dead connection, which belong to the current transaction, but will attempt
reconnect before the next query issued on the connection in a new transaction.
The use of this feature is not recommended, because it has side effects related
to session state and data consistency when applications don't handle
SQLExceptions properly, and is only designed to be used when you are unable to
configure your application to handle SQLExceptions resulting from dead and
stale connections properly. Alternatively, investigate setting the MySQL server
variable "wait_timeout" to some high value rather than the default of 8 hours."
from
http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html
> Test servers batch jobs all failing
> -----------------------------------
>
> Key: MIFOS-4351
> URL: http://mifosforge.jira.com/browse/MIFOS-4351
> Project: mifos
> Issue Type: Bug
> Components: Batch jobs, Build and Testing
> Environment: http://ci.mifos.org:8116/mifos,
> http://ci.mifos.org:8085/mifos
> Reporter: jbrewster
> Assignee: Udai Gupta
> Fix For: Elsie F
>
>
> All batch jobs on 2.0 and head-master test servers are failing. View details
> by going to Admin-Batch Jobs and clicking on Details link for each batch job.
> For example,
> GenerateMeetingsForCustomerAndSavingsTaskJob Fail Details
> org.mifos.framework.exceptions.PersistenceException:
> org.hibernate.exception.JDBCConnectionException: could not execute query
> OR
> ApplyHolidayChangesTaskJob Fail Details
> org.mifos.core.MifosRuntimeException:
> org.hibernate.exception.JDBCConnectionException: could not execute query at
> org.mifos.accounts.savings.persistence.GenericDaoHibernate.executeNamedQuery(GenericDaoHibernate.java:78)
> at
> org.mifos.application.holiday.persistence.HolidayDaoHibernate.getUnAppliedHolidays(HolidayDaoHibernate.java:117)
> at
> org.mifos.framework.components.batchjobs.helpers.ApplyHolidayChangesHelper.initializeTaskGlobalParameters(ApplyHolidayChangesHelper.java:287)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
