Коннекты растут
Код:
# ./scheduler_status.sh
Sending 'status' on 127.0.0.1:9066
Result: TaskExecuter working
Started: 22.07.2014 17:36:22 Uptime: 0 d 21:58:04
Memory total: 1 387 921 408; max: 1 908 932 608; free: 884 104 392
Memory pools:
Non-heap memory[Code Cache]: max: 50 331 648; used: 11 667 584; peek: 11 677 312
Heap memory[PS Eden Space]: max: 606 011 392; used: 391 926 720; peek: 650 117 120
Heap memory[PS Survivor Space]: max: 56 754 176; used: 14 502 968; peek: 89 063 424
Heap memory[PS Old Gen]: max: 1 431 699 456; used: 97 387 328; peek: 831 815 280
Non-heap memory[PS Perm Gen]: max: 85 983 232; used: 36 128 672; peek: 36 128 672
Thread count: 72
Trees in cache: 98
Periodic tasks executed: 2739; active: 0
Urgent tasks executed: 4; active: 0
Connections pool to Master status Idle: 19; Active: 22; maxActive: 300; maxIdle: 20
Код:
# ./scheduler.sh -econpool
Sending 'conpool' on 127.0.0.1:9066
Result: jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true&connectTimeout=1000, UserName=bill@127.0.0.1, MySQL-AB JDBC Driver
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true&connectTimeout=1000, UserName=bill@127.0.0.1, MySQL-AB JDBC Driver
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true&connectTimeout=1000, UserName=bill@127.0.0.1, MySQL-AB JDBC Driver
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@dd37992
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@3fe3d4f8
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true&connectTimeout=1000, UserName=bill@127.0.0.1, MySQL-AB JDBC Driver
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@3c8cf62c
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@646d20d4
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true&connectTimeout=1000, UserName=bill@127.0.0.1, MySQL-AB JDBC Driver
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@6df5a6f9
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@25b08fb0
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@43dec7c8
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@652c98b5
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@57b95f5d
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@3639a7e3
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@2dc0ddab
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true&connectTimeout=1000, UserName=bill@127.0.0.1, MySQL-AB JDBC Driver
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true&connectTimeout=1000, UserName=bill@127.0.0.1, MySQL-AB JDBC Driver
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@509259ae
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@5ee306f6
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
ru.bitel.bgbilling.server.util.DefaultServerSetup
2
1@127cacb6
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)
jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true&connectTimeout=1000, UserName=bill@127.0.0.1, MySQL-AB JDBC Driver
at ru.bitel.bgbilling.server.util.DefaultServerSetup
1.borrowObject(DefaultServerSetup.java:1)
at ru.bitel.bgbilling.server.util.DatabaseConnectionPool
1.getConnection(DatabaseConnectionPool.java:30)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:572)
at ru.bitel.bgbilling.plugins.bonus.server.task.CalculationBonus.initTask(CalculationBonus.java:29)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.initTask(TaskBase.java:52)
at ru.bitel.bgbilling.kernel.task.server.TaskData.initTask(TaskData.java:70)
at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:209)