По результатам отработки скрипта рассылки sms-оповещений, появляется ошибка:
Код:
scheduler 07-30/14:30:05 ERROR [pool-2-thread-16] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[29] - SELECT * FROM dispatch_message WHERE dispatch_id=1 ORDER BY id
com.mysql.jdbc.ServerPreparedStatement[8] - SELECT * FROM contract WHERE id=73
com.mysql.jdbc.ServerPreparedStatement[33] - SELECT * FROM contract WHERE id=78
com.mysql.jdbc.ServerPreparedStatement[34] - SELECT * FROM contract WHERE id=88
com.mysql.jdbc.ServerPreparedStatement[35] - SELECT * FROM contract WHERE id=75
com.mysql.jdbc.ServerPreparedStatement[36] - SELECT * FROM contract WHERE id=89
com.mysql.jdbc.ServerPreparedStatement[37] - SELECT * FROM contract WHERE id=91
com.mysql.jdbc.ServerPreparedStatement[38] - SELECT * FROM contract WHERE id=92
com.mysql.jdbc.ServerPreparedStatement[39] - SELECT * FROM contract WHERE id=86
com.mysql.jdbc.ServerPreparedStatement[40] - SELECT * FROM contract WHERE id=87
com.mysql.jdbc.ServerPreparedStatement[41] - SELECT * FROM contract WHERE id=101
com.mysql.jdbc.ServerPreparedStatement[43] - SELECT * FROM contract WHERE id=110
com.mysql.jdbc.ServerPreparedStatement[44] - SELECT * FROM contract WHERE id=362
com.mysql.jdbc.ServerPreparedStatement[45] - SELECT * FROM contract WHERE id=124
com.mysql.jdbc.ServerPreparedStatement[46] - SELECT * FROM contract WHERE id=136
com.mysql.jdbc.ServerPreparedStatement[47] - SELECT * FROM contract WHERE id=137
com.mysql.jdbc.ServerPreparedStatement[48] - SELECT * FROM contract WHERE id=139
com.mysql.jdbc.ServerPreparedStatement[49] - SELECT * FROM contract WHERE id=155
com.mysql.jdbc.ServerPreparedStatement[50] - SELECT * FROM contract WHERE id=74
com.mysql.jdbc.ServerPreparedStatement[51] - SELECT * FROM contract WHERE id=169
com.mysql.jdbc.ServerPreparedStatement[52] - SELECT * FROM contract WHERE id=177
...
com.mysql.jdbc.ServerPreparedStatement[100] - SELECT * FROM contract WHERE id=487
com.mysql.jdbc.ServerPreparedStatement[101] - SELECT * FROM contract WHERE id=488
com.mysql.jdbc.ServerPreparedStatement[102] - SELECT * FROM contract WHERE id=527
com.mysql.jdbc.ServerPreparedStatement[103] - SELECT * FROM contract WHERE id=531
com.mysql.jdbc.ServerPreparedStatement[104] - SELECT * FROM contract WHERE id=534
com.mysql.jdbc.ServerPreparedStatement[105] - SELECT * FROM contract WHERE id=541
com.mysql.jdbc.ServerPreparedStatement[106] - SELECT * FROM contract WHERE id=547
com.mysql.jdbc.ServerPreparedStatement[107] - SELECT * FROM contract WHERE id=574
com.mysql.jdbc.ServerPreparedStatement[108] - SELECT * FROM contract WHERE id=592
com.mysql.jdbc.ServerPreparedStatement[109] - SELECT * FROM contract WHERE id=594
com.mysql.jdbc.ServerPreparedStatement[110] - SELECT * FROM contract WHERE id=598
com.mysql.jdbc.ServerPreparedStatement[111] - SELECT * FROM contract WHERE id=608
com.mysql.jdbc.ServerPreparedStatement[112] - SELECT * FROM contract WHERE id=615
com.mysql.jdbc.ServerPreparedStatement[113] - SELECT * FROM dispatch_message WHERE id=1
java.lang.RuntimeException
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:480)
at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47)
at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:261)
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.bgbilling.plugins.dispatch.server.DispatchWorker.executeTask(DispatchWorker.java:120)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:74)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Скрипт (а в скриптах я не силён) рассылки к БД самостоятельно не обращается, сохраняет sms-сообщение на шаре:
Код:
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/for/save/file/" + 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");}
}
}
Версия биллинга:
Клиент: вер. 6.0 сборка 1199 от 13.06.2013 16:43:20
os: Linux; java: Java HotSpot(TM) Server VM, v.1.6.0_35
Сервер: вер. 6.0 сборка 1523 от 13.06.2013 16:43:27
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.6.0_35
assist вер. 6.0 сборка 102 от 31.05.2013 13:55:15
bill вер. 6.0 сборка 323 от 31.05.2013 13:55:16
card вер. 6.0 сборка 215 от 11.06.2013 17:28:33
dba вер. 6.0 сборка 162 от 31.05.2013 13:55:38
enaza вер. 6.0 сборка 60 от 31.05.2013 13:55:47
gorod вер. 6.0 сборка 167 от 31.05.2013 13:55:47
inet вер. 6.0 сборка 1191 от 13.06.2013 17:24:27
mps вер. 6.0 сборка 182 от 31.05.2013 13:56:51
npay вер. 6.0 сборка 215 от 31.05.2013 13:56:58
ВНИМАНИЕ: клиентская версия: 5.2 сборка 203 от 27.05.2013 16:59:08
paylinks вер. 6.0 сборка 31 от 31.05.2013 13:56:59
qiwi вер. 6.0 сборка 36 от 31.05.2013 13:57:12
rentsoft вер. 6.0 сборка 57 от 31.05.2013 13:57:33
reports вер. 6.0 сборка 204 от 31.05.2013 13:57:34
rscm вер. 6.0 сборка 184 от 31.05.2013 13:57:36
ru.bitel.bgbilling.plugins.cladr вер. 6.0 сборка 120 от 31.05.2013 13:57:05
ru.bitel.bgbilling.plugins.dispatch вер. 6.0 сборка 81 от 06.06.2013 19:33:33
trayinfo вер. 6.0 сборка 174 от 31.05.2013 13:57:39
wellpay вер. 6.0 сборка 34 от 31.05.2013 13:58:21
wm вер. 6.0 сборка 188 от 31.05.2013 13:58:41
yamoney вер. 6.0 сборка 58 от 31.05.2013 13:58:42
Прошу подсказать, в чем может быть проблема?