Перелез на резервном сервере с 6.0 на 7.0. Клиент подключался к биллингу. На резервном версии 7.0 привёл базу в актуальное состояние с помощью mysql-zrm из бекапа с рабочего биллинга от предыдущей ночи.
Теперь клиент не подключается к биллингу. Ошибка:
user@ilinav ~/BGBillingClient7.0 $ cat log
GraphicsDevice: :0.0 (default)
DisplayMode: 1920x1080x-1x60
ScreenInsets: top=25,left=0,bottom=0,right=0
GraphicsDevice: :0.1
DisplayMode: 1920x1080x-1x0
ScreenInsets: top=0,left=0,bottom=0,right=0
ScreenInsets(def): top=25,left=0,bottom=0,right=0
http://172.16.222.212:8080/bgbilling/ex ... ndToolBar&[ length = 102 ] xml = <?xml version="1.0" encoding="UTF-8"?><data status="error">Column 'opids' not found. [S0022, 0]</data>
На сервере в логах:
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - ru.bitel.bgbilling.common.BGException: Column 'opids' not found. [S0022, 0]
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at ru.bitel.common.dao.AbstractDao.processException(AbstractDao.java:89)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at ru.bitel.common.dao.AbstractDao.get(AbstractDao.java:378)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at ru.bitel.bgbilling.kernel.module.server.bean.UserManager.getUserByLogin(UserManager.java:266)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at bitel.billing.server.admin.bgsecure.bean.UserLoginModule.login(UserLoginModule.java:200)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at java.lang.reflect.Method.invoke(Method.java:497)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at javax.security.auth.login.LoginContext.invoke(LoginContext.java:755)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at javax.security.auth.login.LoginContext.access$000(LoginContext.java:195)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at javax.security.auth.login.LoginContext$4.run(LoginContext.java:682)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at javax.security.auth.login.LoginContext$4.run(LoginContext.java:680)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at java.security.AccessController.doPrivileged(Native Method)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at javax.security.auth.login.LoginContext.login(LoginContext.java:587)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at bitel.billing.server.admin.bgsecure.bean.UserLoginModule.auth(UserLoginModule.java:43)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at bitel.billing.server.Executer.checkUser(SourceFile:421)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at bitel.billing.server.Executer.doPost(SourceFile:186)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at java.lang.Thread.run(Thread.java:745)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - Caused by: java.sql.SQLException: Column 'opids' not found.
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1076)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5206)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at ru.bitel.bgbilling.kernel.module.server.bean.UserManager.getFromRS(UserManager.java:108)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at ru.bitel.bgbilling.kernel.module.server.bean.UserManager.getFromRS(UserManager.java:21)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - at ru.bitel.common.dao.AbstractDao.get(AbstractDao.java:365)
server 11-29/14:24:40 ERROR [http-bio-0.0.0.0-8080-exec-7] LoggingPrintStream - ... 38 more
Как с этим жить?