forum.bitel.ru http://forum.bitel.ru/ |
|
Ошибка при загрузке логов со станции http://forum.bitel.ru/viewtopic.php?f=10&t=2730 |
Страница 1 из 1 |
Автор: | max [ 13 авг 2009, 12:22 ] |
Заголовок сообщения: | Ошибка при загрузке логов со станции |
При загрузке лога станции вылазит вот такая ошибка: Код: 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) сначала сказала то вообще таблицы нет...., а после нескольких повторных попыток загрузки лога, таблицу всётаки создала но ругаться стала по другому.... Таблица на которую ругается в базе есть... |
Автор: | max [ 13 авг 2009, 13:44 ] |
Заголовок сообщения: | |
проблема полностью идентична http://www.bgbilling.ru/forum/viewtopic.php?t=2729 и пропадает если из конфигурации модуля поставить store.incoming.calls=0 |
Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |