Warning: mysql_connect(): User phpbuilder already has more than 'max_user_connections' active connections in /www2/phpbuild/php/_Database.inc on line 19
User phpbuilder already has more than 'max_user_connections' active connections PHPBuilder.com, the best resource for PHP tutorials, templates, PHP manuals, content management systems, scripts, classes and more.

Partners & Affiliates














  • No Items Found

[PHPLIB] Bug in phplib/phpslash ???? From: Arne B.Olsen (abolsen <email protected>)
Date: 03/20/00

Hi,
I found out that phplib or phpslash are making my MySQL databaseserver hang ..(?)...
At least I suspect it does.
By running the following command
[router <email protected>]$ mysqladmin -p processlist
Enter password:
+------+--------+-----------+--------+------------+------+-------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+--------+-----------+--------+------------+------+-------------------+------------------------------------------------------------------------------------------------------+
| 611 | router | localhost | router | Killed | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyA=', c |
| 1254 | router | localhost | router | Killed | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhp |
| 1273 | router | localhost | router | Killed | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhp |
| 1275 | router | localhost | router | Sleep | 1229 | | |
| 1319 | router | localhost | router | Query | 535 | Waiting for table | select val from active_sessions where sid = '80fe955af2cbb28bcd77387d9189ac90' and name = 'slashSes |
| 1320 | router | localhost | router | Killed | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhp |
| 1321 | router | localhost | router | Sleep | 1228 | | |
| 1322 | router | localhost | router | Sleep | 1228 | | |
| 1388 | router | localhost | router | Sleep | 1229 | | |
| 1391 | router | localhost | router | Sleep | 1229 | | |
| 1392 | router | localhost | router | Sleep | 1229 | | |
| 1394 | router | localhost | router | Killed | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhp |
| 1441 | router | localhost | router | Killed | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyA=', c |
| 1443 | router | localhost | router | Query | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyA=', c |
| 1444 | router | localhost | router | Query | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyA=', c |
| 1447 | router | localhost | router | Query | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyA=', c |
| 1460 | router | localhost | router | Query | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyA=', c |
| 1484 | router | localhost | router | Query | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhp |
| 1485 | router | localhost | router | Query | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhp |
| 1486 | router | localhost | router | Query | 1229 | Locked | update active_sessions set val='c2xhc2hTZXNzOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhp |
| 1614 | router | localhost | router | Query | 1544 | Sending data | SELECT * FROM active_sessions LIMIT 0, 30 |
| 1616 | router | localhost | router | Query | 1513 | Sending data | SELECT * FROM active_sessions LIMIT 0, 30 |
| 1618 | router | localhost | router | Query | 1479 | Sending data | SELECT * FROM active_sessions LIMIT 0, 30 |
| 1620 | router | localhost | router | Query | 1445 | Sending data | SELECT * FROM active_sessions LIMIT 0, 30 |
| 1631 | router | localhost | router | Query | 1263 | Sending data | SELECT * FROM active_sessions LIMIT 0, 30 |
| 1632 | router | localhost | router | Query | 1230 | Sending data | SELECT * FROM active_sessions LIMIT 0, 30 |
| 1649 | router | localhost | router | Query | 1024 | Locked | select count(*) as num from active_sessions |
| 1651 | router | localhost | router | Query | 987 | Locked | select count(*) as num from active_sessions |
| 1655 | router | localhost | router | Query | 953 | Locked | select count(*) as num from active_sessions |
| 1657 | router | localhost | router | Query | 916 | Locked | select count(*) as num from active_sessions |
| 1662 | router | localhost | router | Query | 838 | Locked | SELECT * FROM active_sessions LIMIT 0, 30 |
| 1664 | router | localhost | router | Query | 801 | Locked | SELECT * FROM active_sessions LIMIT 0, 30 |
| 1665 | router | localhost | router | Query | 770 | Locked | SELECT * FROM active_sessions LIMIT 0, 30 |
| 1668 | router | localhost | router | Query | 739 | Locked | SELECT * FROM active_sessions LIMIT 0, 30 |
| 1669 | router | localhost | router | Query | 714 | Locked | select * from active_sessions |
| 1672 | router | localhost | router | Query | 676 | Waiting for table | delete from active_sessions |
| 1673 | router | localhost | router | Query | 599 | Waiting for table | select val from active_sessions where sid = 'b725acb4535151ffaa321ecf2faa7d0c' and name = 'slashSes |
| 1674 | router | localhost | router | Field List | 555 | Waiting for table | |
| 1675 | router | localhost | router | Query | 534 | Waiting for table | select val from active_sessions where sid = '46499ed41850c4a8c4919379f20b0e46' and name = 'slashSes |
| 1676 | router | localhost | router | Query | 534 | Waiting for table | select val from active_sessions where sid = 'c15a81b2b2b00d3958accece83108b5c' and name = 'slashSes |
| 1677 | router | localhost | router | Query | 519 | Waiting for table | select val from active_sessions where sid = '4c1c9ab73502beb222e313bc9fe72075' and name = 'slashSes |
| 1682 | router | localhost | | Query | 0 | | show processlist |
.

(dont mind the command coloumn saying killed, i just tried to kill some of the processes)
This happens after some usage of the admin page....
Does anyone have a solution to this ?
I think my service provider wont be happy with me if they find out :) since mysql is eating up the cpu :).

Best regards
Arne

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.