BiTel

08-13/11:50:39 ERROR [Thread-0] dataloader - Table 'bgbilling.log_session_7_200908' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.log_session_7_200908' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
        at bitel.billing.server.phone.DataProcess.initItemZoneTraffic(DataProcess.java:1014)
        at bitel.billing.server.phone.DataProcess.proccessImpl(DataProcess.java:214)
        at bitel.billing.server.phone.DataProcess.proccess(DataProcess.java:145)
        at bitel.billing.server.DataLoader.processData(DataLoader.java:430)
        at bitel.billing.server.DataLoader.run(DataLoader.java:230)
08-13/11:50:39  INFO [Thread-0] dataloader - Create new item finder..
08-13/11:50:39  INFO [Thread-0] dataloader - Item loaded By num: 0; by port: 0; rules: 0
08-13/11:50:39  INFO [Thread-0] dataloader - proccess [13-08-2009 11:00:00; mid => 7; param => 15] ; records => 0; cl_ses => 0; in_ses => 0; op_ses => 0; time => 158/108 ms.
08-13/11:50:39 ERROR [pool-1-thread-1] dataloader - Table 'log_session_7_200908' was not locked with LOCK TABLES
java.sql.SQLException: Table 'log_session_7_200908' was not locked with LOCK TABLES
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at bitel.billing.server.phone.DataProcess$Inserter.run(DataProcess.java:352)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)
08-13/11:50:39 ERROR [pool-1-thread-1] dataloader - org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.JDBC4PreparedStatement@d3e837: statement has been closed, no further internal information available" is closed.
java.sql.SQLException: org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.JDBC4PreparedStatement@d3e837: statement has been closed, no further internal information available" is closed.
        at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at bitel.billing.server.phone.DataProcess$Inserter.run(DataProcess.java:371)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)
08-13/11:50:39  INFO [pool-1-thread-1] dataloader - proccess [13-08-2009 11:00:00; mid => 7; param => 15]  session inserted => 34 ms.
08-13/11:52:30  INFO [Thread-277] dataloader - 36414 Load data from: /tftp/billing2009/08/13_11.zip
08-13/11:52:30  INFO [Thread-277] dataloader - 36414 no need load..
08-13/11:52:30  INFO [Thread-0] dataloader - 36414 End task => 0/0 sec. [0]
08-13/11:52:34  INFO [Thread-0] dataloader - tariff.only.month=false store.incoming.calls=true
08-13/11:52:34  INFO [Thread-0] dataloader - Use zone traffic cache..
08-13/11:52:34  INFO [Thread-0] dataloader - Use item cache..
08-13/11:52:34  INFO [Thread-0] dataloader - Item loaded By num: 0; by port: 0; rules: 0
08-13/11:52:34  INFO [Thread-0] dataloader - proccess [13-08-2009 11:00:00; mid => 7; param => 15] ; records => 0; cl_ses => 0; in_ses => 0; op_ses => 0; time => 85/0 ms.
08-13/11:52:34 ERROR [pool-1-thread-2] dataloader - Table 'log_session_7_200908' was not locked with LOCK TABLES
java.sql.SQLException: Table 'log_session_7_200908' was not locked with LOCK TABLES
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at bitel.billing.server.phone.DataProcess$Inserter.run(DataProcess.java:352)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)
08-13/11:52:34 ERROR [pool-1-thread-2] dataloader - org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.JDBC4PreparedStatement@7fe9b1: statement has been closed, no further internal information available" is closed.
java.sql.SQLException: org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.JDBC4PreparedStatement@7fe9b1: statement has been closed, no further internal information available" is closed.
        at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at bitel.billing.server.phone.DataProcess$Inserter.run(DataProcess.java:371)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)
08-13/11:52:34  INFO [pool-1-thread-2] dataloader - proccess [13-08-2009 11:00:00; mid => 7; param => 15]  session inserted => 22 ms.
08-13/11:53:09  INFO [Thread-278] dataloader - 36415 Load data from: /tftp/billing2009/08/13_11.zip
08-13/11:53:09  INFO [Thread-278] dataloader - 36415 no need load..
08-13/11:53:09  INFO [Thread-0] dataloader - 36415 End task => 0/0 sec. [0]
08-13/11:53:13  INFO [Thread-0] dataloader - tariff.only.month=false store.incoming.calls=true
08-13/11:53:13  INFO [Thread-0] dataloader - Use zone traffic cache..
08-13/11:53:13  INFO [Thread-0] dataloader - Use item cache..
08-13/11:53:13  INFO [Thread-0] dataloader - Item loaded By num: 0; by port: 0; rules: 0
08-13/11:53:13  INFO [Thread-0] dataloader - proccess [13-08-2009 11:00:00; mid => 7; param => 15] ; records => 0; cl_ses => 0; in_ses => 0; op_ses => 0; time => 7/0 ms.
08-13/11:53:13 ERROR [pool-1-thread-3] dataloader - Table 'log_session_7_200908' was not locked with LOCK TABLES
java.sql.SQLException: Table 'log_session_7_200908' was not locked with LOCK TABLES
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at bitel.billing.server.phone.DataProcess$Inserter.run(DataProcess.java:352)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)
08-13/11:53:13 ERROR [pool-1-thread-3] dataloader - org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.PreparedStatement@1da882e: statement has been closed, no further internal information available" is closed.
java.sql.SQLException: org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.PreparedStatement@1da882e: statement has been closed, no further internal information available" is closed.
        at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at bitel.billing.server.phone.DataProcess$Inserter.run(DataProcess.java:371)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)
08-13/11:53:13  INFO [pool-1-thread-3] dataloader - proccess [13-08-2009 11:00:00; mid => 7; param => 15]  session inserted => 6 ms.
08-13/11:54:26  INFO [Thread-279] dataloader - 36416 Load data from: /tftp/billing2009/08/13_11.zip
08-13/11:54:26  INFO [Thread-279] dataloader - 36416 no need load..
08-13/11:54:26  INFO [Thread-0] dataloader - 36416 End task => 0/0 sec. [0]
08-13/11:54:30  INFO [Thread-0] dataloader - tariff.only.month=false store.incoming.calls=true
08-13/11:54:30  INFO [Thread-0] dataloader - Use zone traffic cache..
08-13/11:54:30  INFO [Thread-0] dataloader - Use item cache..
08-13/11:54:30  INFO [Thread-0] dataloader - Item loaded By num: 0; by port: 0; rules: 0
08-13/11:54:30  INFO [Thread-0] dataloader - proccess [13-08-2009 11:00:00; mid => 7; param => 15] ; records => 0; cl_ses => 0; in_ses => 0; op_ses => 0; time => 69/0 ms.
08-13/11:54:30 ERROR [pool-1-thread-4] dataloader - Table 'log_session_7_200908' was not locked with LOCK TABLES
java.sql.SQLException: Table 'log_session_7_200908' was not locked with LOCK TABLES
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at bitel.billing.server.phone.DataProcess$Inserter.run(DataProcess.java:352)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)
08-13/11:54:30 ERROR [pool-1-thread-4] dataloader - org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.PreparedStatement@4c230: statement has been closed, no further internal information available" is closed.
java.sql.SQLException: org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.PreparedStatement@4c230: statement has been closed, no further internal information available" is closed.
        at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at bitel.billing.server.phone.DataProcess$Inserter.run(DataProcess.java:371)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)