[rt-devel] rt3 crashin with connections in RT.pm

[Joseph W. Breu]

can you send the output of 'mysqladmin variables' as well?

Specificaly, I am looking for max_connections.


> Hello Joseph,
> Enter password:
> +------+---------+-----------+-----+---------+------+-------+------------------+
> | Id   | User    | Host      | db  | Command | Time | State | Info
>     |
> +------+---------+-----------+-----+---------+------+-------+------------------+
> | 966  | rt_user | localhost | rt3 | Sleep   | 3767 |       |
>     |
> | 967  | rt_user | localhost | rt3 | Sleep   | 3767 |       |
>     |
> | 989  | rt_user | localhost | rt3 | Sleep   | 3387 |       |
>     |
> | 991  | rt_user | localhost | rt3 | Sleep   | 3387 |       |
>     |
> | 992  | rt_user | localhost | rt3 | Sleep   | 3387 |       |
>     |
> | 994  | rt_user | localhost | rt3 | Sleep   | 3192 |       |
>     |
> | 1001 | rt_user | localhost | rt3 | Sleep   | 1991 |       |
>     |
> | 1003 | rt_user | localhost | rt3 | Sleep   | 1991 |       |
>     |
> | 1011 | rt_user | localhost | rt3 | Sleep   | 351  |       |
>     |
> | 1013 | rt_user | localhost | rt3 | Sleep   | 350  |       |
>     |
> | 1014 | rt_user | localhost | rt3 | Sleep   | 350  |       |
>     |
> | 1016 | rt_user | localhost | rt3 | Sleep   | 215  |       |
>     |
> | 1020 | rt_user | localhost | rt3 | Sleep   | 61   |       |
>     |
> | 1021 | rt_user | localhost | rt3 | Sleep   | 61   |       |
>     |
> | 1023 | rt_user | localhost | rt3 | Sleep   | 60   |       |
>     |
> | 1024 | rt_user | localhost | rt3 | Sleep   | 59   |       |
>     |
> | 1025 | rt_user | localhost | rt3 | Sleep   | 56   |       |
>     |
> | 1026 | rt_user | localhost | rt3 | Sleep   | 56   |       |
>     |
> | 1027 | rt_user | localhost | rt3 | Sleep   | 54   |       |
>     |
> | 1028 | rt_user | localhost | rt3 | Sleep   | 54   |       |
>     |
> | 1029 | rt_user | localhost | rt3 | Sleep   | 54   |       |
>     |
> | 1030 | rt_user | localhost | rt3 | Sleep   | 54   |       |
>     |
> | 1034 | root    | localhost |     | Query   | 0    |       | show
> processlist |
> +------+---------+-----------+-----+---------+------+-------+------------------+
>
> is possible to set up more conections ? or let them die after amount
> time ?
> thnx for help
>
>
> JWB> Is this a mysql problem?  How many open connections are present when
> you
> JWB> do a 'mysqladmin processlist' ?
>
>
>>> Dobry den, rt-devel,
>>>
>>>   Hi, I have still problem with this from error.log in apache
>>> Mon Mar 31 13:26:38 2003] [notice] Apache/1.3.27 (Unix)
>>> (Red-Hat/Linux)
>>> mod_ssl/2.8.12 OpenSSL/0.9.6b DAV/1.0.3
>>>  PHP/4.3.0 mod_perl/1.26 configured -- resuming normal operations
>>> [Mon Mar 31 13:26:38 2003] [notice] suEXEC mechanism enabled (wrapper:
>>> /usr/sbin/suexec)
>>> [Mon Mar 31 13:26:38 2003] [notice] Accept mutex: sysvsem (Default:
>>> sysvsem)
>>> [Mon Mar 31 13:38:00 2003] [error] Connect Failed Too many connections
>>>  at /opt/rt3/lib/RT.pm line 124
>>>
>>>  I have rt3 with imported tickets from rt2, all is working but stil in
>>>  some circumstancies i get this error. Im not sure where is problem
>>>  coz connections is from RT.pm, also its small site , maybe 2-3 people
>>>  working on it, server is 2xXEON1.8GHz / 1GB RAM / SCSI18GB, nothing
>>>  else is runing on mysql, just this. I tried it with clean install and
>>>  empty database , still same behavior.
>>>  Maybe its something with install Apache::DBI but what, how to find
>>>  out, i found only error in log from apache.
>>>
>>>  here is httpd.conf part, i can send all conf if there is some trash
>>>  to kickout.
>>>  >>>>>>>>>>>>
>>> <VirtualHost 149.204.1.15>
>>>   DocumentRoot /opt/rt3/share/html
>>>   ServerName rt.alcatel.sk
>>>         PerlFreshRestart On
>>>         SetHandler perl-script
>>>         PerlHandler Apache::DBI
>>>         PerlRequire /opt/rt3/bin/webmux.pl
>>>   <Location />
>>>     SetHandler perl-script
>>>     PerlHandler RT::Mason
>>>   </Location>
>>> </VirtualHost>
>>> -----------------------------------
>>> thnx for nay help
>>>
>>>
>>> --
>>> S pozdravom
>>>  Peter                          mailto:mikeska at alcatel.sk
>>>
>>> _______________________________________________
>>> rt-devel mailing list
>>> rt-devel at lists.fsck.com
>>> http://lists.fsck.com/mailman/listinfo/rt-devel
>>>
>
> JWB> _______________________________________________
> JWB> rt-devel mailing list
> JWB> rt-devel at lists.fsck.com
> JWB> http://lists.fsck.com/mailman/listinfo/rt-devel
>
>
>
> --
> Best regards,
>  Peter                            mailto:mikeska at alcatel.sk
>
>