ASSP Version 2.0.1.0.5.1.6 and mysql

View: New views
3 Messages — Rating Filter:   Alert me  

ASSP Version 2.0.1.0.5.1.6 and mysql

by admin-327 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

Re: ASSP Version 2.0.1.0.5.1.6 and mysql

by Маллиндайн Стивен (Steve Mallindine) :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Ralf,

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

by Thomas Eckardt/eck :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

>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