BiTel

# ./server_status.sh
BGBillingServer v 5.2 build 1496 from 13.05.2013 19:34:01
Started: 18.03.2014 21:20:50    Uptime: 1 d 18:44:41
Memory total: 1 798 766 592; max: 1 908 932 608; free: 1 338 031 800
Memory pools:
  Non-heap memory[Code Cache]: max: 50 331 648; used: 20 461 440; peek: 20 476 096
  Heap memory[PS Eden Space]: max: 557 514 752; used: 194 303 760; peek: 538 443 776
  Heap memory[PS Survivor Space]: max: 75 759 616; used: 62 286 032; peek: 74 927 976
  Heap memory[PS Old Gen]: max: 1 431 699 456; used: 204 145 000; peek: 1 145 524 032
  Non-heap memory[PS Perm Gen]: max: 536 870 912; used: 92 496 504; peek: 92 986 128
Thread count: 55
Connections pool to Master status Idle: 0; Active: 300; maxActive: 300; maxIdle: 50

mq 03-20/15:48:46 ERROR [event-proc-p-2-t-1] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:54:10 ERROR ["http-bio-/0.0.0.0-8080"-exec-10] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:54:10 ERROR ["http-bio-/0.0.0.0-8080"-exec-3] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:54:10 ERROR ["http-bio-/0.0.0.0-8443"-exec-7] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:54:44 ERROR ["http-bio-/0.0.0.0-8080"-exec-10] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:56:02 ERROR ["http-bio-/0.0.0.0-8080"-exec-1] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:56:02 ERROR ["http-bio-/0.0.0.0-8080"-exec-1] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:56:02 ERROR ["http-bio-/0.0.0.0-8080"-exec-1] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:58:12 ERROR ["http-bio-/0.0.0.0-8080"-exec-1] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:58:19 ERROR ["http-bio-/0.0.0.0-8443"-exec-10] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:58:25 ERROR ["http-bio-/0.0.0.0-8080"-exec-5] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:58:30 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:58:32 ERROR ["http-bio-/0.0.0.0-8080"-exec-6] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:58:33 ERROR ["http-bio-/0.0.0.0-8080"-exec-4] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:58:34 ERROR ["http-bio-/0.0.0.0-8080"-exec-3] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:58:41 ERROR ["http-bio-/0.0.0.0-8080"-exec-7] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:58:49 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:58:57 ERROR ["http-bio-/0.0.0.0-8080"-exec-10] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/15:59:05 ERROR ["http-bio-/0.0.0.0-8080"-exec-8] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
mq 03-20/16:00:07 ERROR [event-proc-p-2-t-1] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/16:03:56 ERROR ["http-bio-/0.0.0.0-8443"-exec-8] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!
server 03-20/16:04:26 ERROR ["http-bio-/0.0.0.0-8443"-exec-7] DefaultServerSetup - Pool [data.data]: Connections limit is over!!!!!

db.trace=1

   
   Connection con = this.setup.getDBConnectionFromPool();

Connection con = null;
try
{
               con = this.setup.getDBConnectionFromPool();
               ......
}
finally
{
     ServerUtils.closeConnection( con );
}

06-05/13:44:04 ERROR [pool-2-thread-4] DispatchWorker - ?????? ????????????? ???????????? ?????????!
ru.bitel.bgbilling.common.BGMessageException: ?????? ????????????? ???????????? ?????????!
        at ru.bitel.bgbilling.plugins.dispatch.server.DispatchServiceImpl.updateMessage(DispatchServiceImpl.java:118)
        at ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker.executeTask(DispatchWorker.java:113)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:76)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)

locale
LANG=ru_RU.UTF-8
LANGUAGE=
LC_CTYPE="ru_RU.UTF-8"
LC_NUMERIC="ru_RU.UTF-8"
LC_TIME="ru_RU.UTF-8"
LC_COLLATE="ru_RU.UTF-8"
LC_MONETARY="ru_RU.UTF-8"
LC_MESSAGES="ru_RU.UTF-8"
LC_PAPER="ru_RU.UTF-8"
LC_NAME="ru_RU.UTF-8"
LC_ADDRESS="ru_RU.UTF-8"
LC_TELEPHONE="ru_RU.UTF-8"
LC_MEASUREMENT="ru_RU.UTF-8"
LC_IDENTIFICATION="ru_RU.UTF-8"

06-05/15:19:00  INFO [Thread-3] TaskExecuter - Starting periodic task #10: ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker
06-05/15:19:01 ERROR [pool-2-thread-16] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[22] - SELECT * FROM dispatch_message WHERE dispatch_id=1 ORDER BY id
com.mysql.jdbc.ServerPreparedStatement[25] - SELECT * FROM contract WHERE id=243
com.mysql.jdbc.ServerPreparedStatement[28] - SELECT * FROM contract WHERE id=243
com.mysql.jdbc.ServerPreparedStatement[29] - SELECT * FROM contract WHERE id=161
com.mysql.jdbc.ServerPreparedStatement[30] - SELECT * FROM contract WHERE id=161
com.mysql.jdbc.ServerPreparedStatement[31] - SELECT * FROM contract WHERE id=179
com.mysql.jdbc.ServerPreparedStatement[32] - SELECT * FROM contract WHERE id=179
com.mysql.jdbc.ServerPreparedStatement[33] - SELECT * FROM contract WHERE id=62
com.mysql.jdbc.ServerPreparedStatement[34] - SELECT * FROM contract WHERE id=62
com.mysql.jdbc.ServerPreparedStatement[35] - SELECT * FROM contract WHERE id=65
com.mysql.jdbc.ServerPreparedStatement[36] - SELECT * FROM contract WHERE id=65
com.mysql.jdbc.ServerPreparedStatement[37] - SELECT * FROM contract WHERE id=66
com.mysql.jdbc.ServerPreparedStatement[38] - SELECT * FROM contract WHERE id=66
com.mysql.jdbc.ServerPreparedStatement[39] - SELECT * FROM contract WHERE id=70
com.mysql.jdbc.ServerPreparedStatement[40] - SELECT * FROM contract WHERE id=70
com.mysql.jdbc.ServerPreparedStatement[41] - SELECT * FROM contract WHERE id=71
com.mysql.jdbc.ServerPreparedStatement[42] - SELECT * FROM contract WHERE id=71
com.mysql.jdbc.ServerPreparedStatement[43] - SELECT * FROM contract WHERE id=73

...

com.mysql.jdbc.ServerPreparedStatement[120] - SELECT * FROM contract WHERE id=74
com.mysql.jdbc.ServerPreparedStatement[121] - SELECT * FROM contract WHERE id=74
com.mysql.jdbc.ServerPreparedStatement[122] - SELECT * FROM contract WHERE id=174
com.mysql.jdbc.ServerPreparedStatement[123] - SELECT * FROM contract WHERE id=172
com.mysql.jdbc.ServerPreparedStatement[124] - SELECT * FROM contract WHERE id=172
com.mysql.jdbc.ServerPreparedStatement[125] - SELECT * FROM contract WHERE id=171

java.lang.RuntimeException
        at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:417)
        at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
        at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272)
        at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37)
        at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:406)
        at ru.bitel.common.worker.ThreadContext.pop(ThreadContext.java:54)
        at ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker.executeTask(DispatchWorker.java:140)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:76)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
06-05/15:19:01  INFO [pool-2-thread-16] DispatchWorker - Task finished time=1392 ms.
06-05/15:20:00  INFO [Thread-3] TaskExecuter - Starting periodic task #10: ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker
06-05/15:20:00  INFO [pool-2-thread-17] DispatchWorker - Task finished time=5 ms.

package ru.my.scripts;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.*;
import java.io.*;
import java.util.List;
import java.util.Calendar;
import javax.activation.DataSource;
import ru.bitel.bgbilling.common.BGException;
import ru.bitel.bgbilling.plugins.dispatch.common.bean.Contact;
import ru.bitel.bgbilling.plugins.dispatch.server.sender.Sender;

public class sms
   implements Sender
{
   @Override
   public void send( Contact contact1, String string2, String string3, List<DataSource> list4 )
   throws BGException
   {
            
      try{   
            String queryStr =string3;
            String timeStamp = new SimpleDateFormat("yyyyMMdd_HHmmss").format(Calendar.getInstance().getTime());
            String filePath = "/path/to/save/" + contact1.getValue() + "_" + timeStamp + "_" +Integer.toString(contact1.getContractId());
            PrintWriter out = null;
         
      try
         {   
            out = new PrintWriter(new File(filePath).getAbsoluteFile(), "UTF-8");
         }
      catch(FileNotFoundException e) { throw new RuntimeException(e);   }

                   out.print(queryStr);
                   out.close();
   }
   catch (UnsupportedEncodingException e) {   throw new AssertionError("UTF-8 not supported");}

   }

}

locale
LANG=ru_RU.UTF-8
LANGUAGE=
LC_CTYPE="ru_RU.UTF-8"
LC_NUMERIC="ru_RU.UTF-8"
LC_TIME="ru_RU.UTF-8"
LC_COLLATE="ru_RU.UTF-8"
LC_MONETARY="ru_RU.UTF-8"
LC_MESSAGES="ru_RU.UTF-8"
LC_PAPER="ru_RU.UTF-8"
LC_NAME="ru_RU.UTF-8"
LC_ADDRESS="ru_RU.UTF-8"
LC_TELEPHONE="ru_RU.UTF-8"
LC_MEASUREMENT="ru_RU.UTF-8"
LC_IDENTIFICATION="ru_RU.UTF-8"
LC_ALL=

locale
LANG=ru_RU.UTF-8
LANGUAGE=
LC_CTYPE="ru_RU.UTF-8"
LC_NUMERIC="ru_RU.UTF-8"
LC_TIME="ru_RU.UTF-8"
LC_COLLATE="ru_RU.UTF-8"
LC_MONETARY="ru_RU.UTF-8"
LC_MESSAGES="ru_RU.UTF-8"
LC_PAPER="ru_RU.UTF-8"
LC_NAME="ru_RU.UTF-8"
LC_ADDRESS="ru_RU.UTF-8"
LC_TELEPHONE="ru_RU.UTF-8"
LC_MEASUREMENT="ru_RU.UTF-8"
LC_IDENTIFICATION="ru_RU.UTF-8"
LC_ALL=ru_RU.UTF-8

PARAMS="-Duser.language=ru -Duser.country=RU -Dfile.encoding=utf-8

06-09/16:45:03  INFO [Thread-3] TaskExecuter - Starting periodic task #10: ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker
06-09/16:45:04 ERROR [pool-2-thread-6] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[7] - SELECT * FROM dispatch_message WHERE dispatch_id=1 ORDER BY id
com.mysql.jdbc.ServerPreparedStatement[339] - SELECT * FROM contract WHERE id=243
com.mysql.jdbc.ServerPreparedStatement[516] - SELECT * FROM contract WHERE id=243
com.mysql.jdbc.ServerPreparedStatement[517] - SELECT * FROM contract WHERE id=161
com.mysql.jdbc.ServerPreparedStatement[518] - SELECT * FROM contract WHERE id=161
com.mysql.jdbc.ServerPreparedStatement[519] - SELECT * FROM contract WHERE id=179
com.mysql.jdbc.ServerPreparedStatement[520] - SELECT * FROM contract WHERE id=179
com.mysql.jdbc.ServerPreparedStatement[521] - SELECT * FROM contract WHERE id=62
com.mysql.jdbc.ServerPreparedStatement[522] - SELECT * FROM contract WHERE id=62
com.mysql.jdbc.ServerPreparedStatement[523] - SELECT * FROM contract WHERE id=65
com.mysql.jdbc.ServerPreparedStatement[524] - SELECT * FROM contract WHERE id=65
com.mysql.jdbc.ServerPreparedStatement[525] - SELECT * FROM contract WHERE id=66
com.mysql.jdbc.ServerPreparedStatement[526] - SELECT * FROM contract WHERE id=66
com.mysql.jdbc.ServerPreparedStatement[527] - SELECT * FROM contract WHERE id=70
com.mysql.jdbc.ServerPreparedStatement[528] - SELECT * FROM contract WHERE id=70
com.mysql.jdbc.ServerPreparedStatement[529] - SELECT * FROM contract WHERE id=71
com.mysql.jdbc.ServerPreparedStatement[530] - SELECT * FROM contract WHERE id=71

...

om.mysql.jdbc.ServerPreparedStatement[601] - SELECT * FROM contract WHERE id=138
com.mysql.jdbc.ServerPreparedStatement[602] - SELECT * FROM contract WHERE id=138
com.mysql.jdbc.ServerPreparedStatement[603] - SELECT * FROM contract WHERE id=156
com.mysql.jdbc.ServerPreparedStatement[604] - SELECT * FROM contract WHERE id=156
com.mysql.jdbc.ServerPreparedStatement[605] - SELECT * FROM contract WHERE id=158
com.mysql.jdbc.ServerPreparedStatement[606] - SELECT * FROM contract WHERE id=288
com.mysql.jdbc.ServerPreparedStatement[607] - SELECT * FROM contract WHERE id=288
com.mysql.jdbc.ServerPreparedStatement[608] - SELECT * FROM contract WHERE id=74
com.mysql.jdbc.ServerPreparedStatement[609] - SELECT * FROM contract WHERE id=74
com.mysql.jdbc.ServerPreparedStatement[610] - SELECT * FROM contract WHERE id=174
com.mysql.jdbc.ServerPreparedStatement[611] - SELECT * FROM contract WHERE id=172
com.mysql.jdbc.ServerPreparedStatement[612] - SELECT * FROM contract WHERE id=172
com.mysql.jdbc.ServerPreparedStatement[613] - SELECT * FROM contract WHERE id=171

java.lang.RuntimeException
        at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:417)
        at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
        at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272)
        at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37)
        at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:406)
        at ru.bitel.common.worker.ThreadContext.pop(ThreadContext.java:54)
        at ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker.executeTask(DispatchWorker.java:140)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:76)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
06-09/16:45:04  INFO [pool-2-thread-6] DispatchWorker - Task finished time=1078 ms.