|
View:
New views
3 Messages
—
Rating Filter:
Alert me
|
|
|
ASSP Version 2.0.1.0.5.1.6 and mysqlHello,
i have some Problems with assp and mysql. It looks like that assp doesn´t use the existing connections und make new connections instead. When I restart ASSP, it works well. If needed, i can send the hole log-File. Here a part from the log: every worker to reconnect thread 2 table BackDNS! Best regards Ralf ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Assp-test mailing list Assp-test@... https://lists.sourceforge.net/lists/listinfo/assp-test |
|
|
Re: ASSP Version 2.0.1.0.5.1.6 and mysqlRalf,
You failed to mention if ASSP and MySQL are on the same server, and the OS of the server(s).. FYI, I've had no problems here...(MySQL cluster and 3 ASSP servers running on ubuntu 9.04 virtual servers) You are aware that ASSP does take up a lot of connections. As far as I remember, each Worker takes 10 connections, and another 10 for Thread 10001.... Steve On 11/11/09 9:09 AM, "admin" <Admin@...> wrote: > Hello, i have some Problems with assp and mysql. It looks like that > assp doesn´t use the existing connections und make new connections instead. > When I restart ASSP, it works well. If needed, i can send the hole > log-File. Here a part from the log: every worker to reconnect thread 2 table > BackDNS! Best > regards Ralf ---------------------------------------------------------------- > -------------- Let Crystal Reports handle the reporting - Free Crystal Reports > 2008 30-Day trial. Simplify your report design, integration and deployment - > and focus on what you do best, core application coding. Discover what's new > with Crystal Reports now. > http://p.sf.net/sfu/bobj-july _______________________________________________ > Assp-test mailing > list Assp-test@... https://lists.sourceforge.net/lists/listi > nfo/assp-test ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Assp-test mailing list Assp-test@... https://lists.sourceforge.net/lists/listinfo/assp-test |
|
|
Antwort: ASSP Version 2.0.1.0.5.1.6 and mysql>i have some Problems with assp and mysql.
What problem? >to reconnect ASSP checks all mysql connections from time to time (~ 120 seconds) in every worker - if a connection is gone for any reason - ASSP tries to reconnect to the failed table. For example : the BackDNS table is only used if a bounce mail is detected - so this table is possibly not used for minutes or hours. MySQL will close this connection if it is not used, or is answering too slow. Thomas "admin" <Admin@...> 11.11.2009 07:11 Bitte antworten an ASSP development mailing list <assp-test@...> An <assp-test@...> Kopie Thema [Assp-test] ASSP Version 2.0.1.0.5.1.6 and mysql Hello, i have some Problems with assp and mysql. It looks like that assp doesn´t use the existing connections und make new connections instead. When I restart ASSP, it works well. If needed, i can send the hole log-File. Here a part from the log: every worker to reconnect thread 2 table BackDNS! Best regards Ralf ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Assp-test mailing list Assp-test@... https://lists.sourceforge.net/lists/listinfo/assp-test DISCLAIMER: ******************************************************* This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the individual to whom it is addressed. This email was multiple times scanned for viruses. There should be no known virus in this email! ******************************************************* ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Assp-test mailing list Assp-test@... https://lists.sourceforge.net/lists/listinfo/assp-test |
| Free embeddable forum powered by Nabble | Forum Help |