0003774: Mysql too many connections

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0003774

[Quercus]

minor

always

11-19-09 12:10

11-20-09 06:17

Reporter

nam

View Status

public

Assigned To

Priority

normal

Resolution

open

Platform

Status

new

Projection

none

OS Version

ETA

none

Fixed in Version

Product Version

4.0.0

Product Build

Summary

0003774: Mysql too many connections

Description

(rep by juancho_h)

http://forum.caucho.com/showthread.php?t=2290 [^]

I have a little problem currently i'm using resin 3.1.9 and don't have any problem. But when i move the same site to resin 4.0.1 I've an error "Mysql too many connections".

Steps To Reproduce

Additional Information

Attached Files

Relationships

Notes
(0004308) juancho_h 11-20-09 06:17	I found what was happening. I'm migrating this site from Apache/Php to quercus, i found that when i check if i'm connected to mysql i'm using a "instaceof mysqli" but on this version this don't works, and for every query i'm connecting again to mysql, on a cicle I connect to db every time. This is my mistake, but in file web.xml I was configured max-connection to db to 10 and in mysql server I have max connections to 200. I'm setting anything wrong on the web.xml or realy it's a bug?

Issue History
Date Modified	Username	Field	Change
11-19-09 12:10	nam	New Issue
11-20-09 06:17	juancho_h	Note Added: 0004308
11-20-09 06:17	juancho_h	Issue Monitored: juancho_h

Mantis 1.0.0rc3[^]

30 total queries executed.
26 unique queries executed.