Пару обновлений назад перестал обновляться справочник адресов. В логе планировщика биллинга вот такие ошибки:
Код:
scheduler 11-23/01:11:03 ERROR [AddressUpdater-p-5-t-18] WorkerThread -
java.lang.NullPointerException
at com.mysql.jdbc.ServerPreparedStatement.getBinding(ServerPreparedStatement.java:909)
at com.mysql.jdbc.ServerPreparedStatement.setString(ServerPreparedStatement.java:2152)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)
at bitel.billing.server.admin.bean.AddressUtils$6.run(AddressUtils.java:618)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)
scheduler 11-23/01:11:03 ERROR [AddressUpdater-p-5-t-19] WorkerThread -
java.lang.NullPointerException
at com.mysql.jdbc.ServerPreparedStatement.getBinding(ServerPreparedStatement.java:909)
at com.mysql.jdbc.ServerPreparedStatement.setString(ServerPreparedStatement.java:2152)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)
at bitel.billing.server.admin.bean.AddressUtils$6.run(AddressUtils.java:618)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)
scheduler 11-23/01:11:03 ERROR [AddressUpdater-p-5-t-20] WorkerThread -
java.lang.NullPointerException
at com.mysql.jdbc.ServerPreparedStatement.getBinding(ServerPreparedStatement.java:909)
at com.mysql.jdbc.ServerPreparedStatement.setString(ServerPreparedStatement.java:2152)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)
at bitel.billing.server.admin.bean.AddressUtils$6.run(AddressUtils.java:618)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)
scheduler 11-23/01:11:03 ERROR [AddressUpdater-p-5-t-21] WorkerThread -
java.lang.NullPointerException
at com.mysql.jdbc.ServerPreparedStatement.getBinding(ServerPreparedStatement.java:909)
at com.mysql.jdbc.ServerPreparedStatement.setString(ServerPreparedStatement.java:2152)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)
at bitel.billing.server.admin.bean.AddressUtils$6.run(AddressUtils.java:618)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)
scheduler 11-23/01:11:03 ERROR [AddressUpdater-p-5-t-22] WorkerThread -
java.lang.NullPointerException
at com.mysql.jdbc.ServerPreparedStatement.getBinding(ServerPreparedStatement.java:909)
at com.mysql.jdbc.ServerPreparedStatement.setString(ServerPreparedStatement.java:2152)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)
at bitel.billing.server.admin.bean.AddressUtils$6.run(AddressUtils.java:618)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)
scheduler 11-23/01:11:03 ERROR [AddressUpdater-p-5-t-23] WorkerThread -
java.lang.NullPointerException
at com.mysql.jdbc.ServerPreparedStatement.getBinding(ServerPreparedStatement.java:909)
at com.mysql.jdbc.ServerPreparedStatement.setString(ServerPreparedStatement.java:2152)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)
at bitel.billing.server.admin.bean.AddressUtils$6.run(AddressUtils.java:618)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)
scheduler 11-23/01:11:03 ERROR [pool-1-thread-5] TaskUpdateAddressDirectory - Duplicate entry '17-16-' for key 'HouseU'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '17-16-' for key 'HouseU'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1363)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:829)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at ru.bitel.bgbilling.kernel.directory.address.AddressDirectoryManager.updateHouse(AddressDirectoryManager.java:421)
at ru.bitel.bgbilling.kernel.task.server.task.TaskUpdateAddressDirectory.updateAddressHouse(TaskUpdateAddressDirectory.java:269)
at ru.bitel.bgbilling.kernel.task.server.task.TaskUpdateAddressDirectory.executeTask(TaskUpdateAddressDirectory.java:96)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:76)
at ru.bitel.bgbilling.kernel.task.server.TaskBase.startTask(TaskBase.java:137)
at bitel.billing.server.task.TaskBaseRunner.executeTask(TaskBaseRunner.java:76)
at bitel.billing.server.task.bean.RunTask.run(RunTask.java:41)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Если я правильно понимаю дублируются дома.