BiTel

Возникла проблема в пункте 12

Filling contract_module from contract_service..
Filling npay_service_object_<mid> from contract_service..
mid=7
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'nso.sid' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
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 bitel.billing.server.contract.ServiceNormalizer.fillNpayServiceObject(ServiceNormalizer.java:122)
at bitel.billing.server.contract.ServiceNormalizer.<init>(ServiceNormalizer.java:32)
at bitel.billing.server.contract.ServiceNormalizer.main(ServiceNormalizer.java:179)


Пару недель назад обновлялись на другой машине с той же базой, такой проблемы не было.

да непохоже что с той же базой ..может быть вы забыли bg_installer.sh update запустить ? если не поможет , поствитье еще раз npay с ! в конце

Опишу проблему более подробно. Сервер BGB и база данных стоят на разных серверах. На сервере с базой данных сняли дамп:
mysqldump --skip-lock-tables bgbilling > bgbilling28072009_1445.sql

Скопировали полученный файл на другой тестовый сервер БД и развернули там:
mysql bgbilling < bgbilling28072009_1445.sql

Предварительно на тестовом сервере БД выполнили команды из клиента mysql:
drop database bgbilling;
create database bgbilling;

С сервера BGB скопировали папку BGBillingServer, на тестовый сервер BGB. В файле data.properties изменили путь к базе данных. Запустили, проверели - тестовый сервер работает. Далее точно по инструкции пробуем обновить. На 12 пункте инструкции происходит вышеописанная проблема. Все действия выполняли сегодня.

Не выполняли 9-ый пункт инструкции, т.к. в настоящее время файл указанный там не доступен.

Можно лог обновления модулей сервера? Т.е. как отработал bg_installer.sh update.

Сделайте запрос:
SHOW TABLES LIKE 'npay_service_object_%'

И для каждой таблицы:
SHOW COLUMNS FROM <table>

И сюда выложите результаты запросов.

Выкладываю, что Вы просили.

server:/usr/local/BGBillingServer# ./bg_installer.sh update
Update starting..
Update from ftp://bgbilling.ru/pub/bgbilling
Server version is 4.6
Set passive mode..
Changing dir to /pub/bgbilling/4.6
Checking updates for rscm..
Found update for rscm build 90 packet rscm_4.6_153.zip updating to build 153
Checking updates for bill..
Found update for bill build 156 packet bill_4.6_204.zip updating to build 204
Checking updates for card..
Found update for card build 89 packet card_4.6_165.zip updating to build 165
Checking updates for dialup..
Found update for dialup build 111 packet dialup_4.6_189.zip updating to build 189
Checking updates for email..
Found update for email build 92 packet email_4.6_165.zip updating to build 165
Checking updates for npay..
Found update for npay build 96 packet npay_4.6_166.zip updating to build 166
Checking updates for phone..
Found update for phone build 132 packet phone_4.6_197.zip updating to build 197
Checking updates for trayinfo..
Found update for trayinfo build 81 packet trayinfo_4.6_145.zip updating to build 145
Checking updates for voiceip..
Found update for voiceip build 93 packet voiceip_4.6_156.zip updating to build 156
Checking updates for wm..
Found update for wm build 78 packet wm_4.6_143.zip updating to build 143
Checking updates for reports..
Found update for reports build 104 packet reports_4.6_167.zip updating to build 167
Checking updates for ipn..
Found update for ipn build 123 packet ipn_4.6_191.zip updating to build 191
Checking updates for ru.bitel.bgbilling.plugins.crm..
Found update for crm build 108 packet crm_4.6_174.zip updating to build 174
Checking updates for ru.bitel.bgbilling.plugins.documents..
Found update for documents build 52 packet documents_4.6_117.zip updating to build 117
Checking updates for ru.bitel.bgbilling.plugins.cashcheck..
Found update for cashcheck build 15 packet cashcheck_4.6_84.zip updating to build 84
Checking updates for server..
Checking updates for client..
Install 15 updates (y/n):
y
Downloading rscm_4.6_153.zip OK!
Downloading bill_4.6_204.zip OK!
Downloading card_4.6_165.zip OK!
Downloading dialup_4.6_189.zip OK!
Downloading email_4.6_165.zip OK!
Downloading npay_4.6_166.zip OK!
Downloading phone_4.6_197.zip OK!
Downloading trayinfo_4.6_145.zip OK!
Downloading voiceip_4.6_156.zip OK!
Downloading wm_4.6_143.zip OK!
Downloading reports_4.6_167.zip OK!
Downloading ipn_4.6_191.zip OK!
Downloading crm_4.6_174.zip OK!
Downloading documents_4.6_117.zip OK!
Downloading cashcheck_4.6_84.zip OK!
Start installing..
Module: rscm already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 8
Module Instance init => OK
Executing call AddSchedulerTasks; param: rscm.sc
Scheduled class bitel.billing.server.rscm.Calculator already exists!
Result => true
Executing call PutFile; param: rscm.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module rscm was successfull installed!
Please, restart BGBilling server.
Module: bill already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 5
Module Instance init => OK
Executing call PutFile; param: bill.xml:actions
Result => true
Executing call PutFile; param: pdfdoc.gif:webroot
Result => true
Executing call PutFile; param: stamp.gif:webroot
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module bill was successfull installed!
Please, restart BGBilling server.
Module: card already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 2
Module Instance init => OK
Executing call PutFile; param: id:webroot
Result => true
Executing call PutFile; param: card.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module card was successfull installed!
Please, restart BGBilling server.
Module: dialup already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 3
Module Instance init => OK
Executing call AddSchedulerTasks; param: dialup.sc
Scheduled class bitel.billing.server.dialup.MaxCalculator already exists!
Result => true
Executing call PutFile; param: dialup.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module dialup was successfull installed!
Please, restart BGBilling server.
Module: email already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 6
Module Instance init => OK
Executing call AddSchedulerTasks; param: email.sc
Scheduled class bitel.billing.server.email.Locker already exists!
Result => true
Executing call PutFile; param: email.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module email was successfull installed!
Please, restart BGBilling server.
Module: npay already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 7
Module Instance init => OK
Executing call AddSchedulerTasks; param: pay.sc
Scheduled class bitel.billing.server.npay.Calculator already exists!
Result => true
Executing call PutFile; param: npay.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module npay was successfull installed!
Please, restart BGBilling server.
Module: phone already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 14
Module Instance init => OK
Executing call AddSchedulerTasks; param: phone.sc
Scheduled class bitel.billing.server.phone.BalanceSetter already exists!
Result => true
Executing call PutFile; param: phone.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module phone was successfull installed!
Please, restart BGBilling server.
Module: trayinfo already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 12
Module Instance init => OK
Executing call PutFile; param: trayinfo.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module trayinfo was successfull installed!
Please, restart BGBilling server.
Module: voiceip already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
Module Instance init => OK
Executing call PutFile; param: voiceip.xml:actions
Result => true
Executing call AddSchedulerTasks; param: voiceip.sc
Scheduled class bitel.billing.server.voiceip.BalanceSetter already exists!
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module voiceip was successfull installed!
Please, restart BGBilling server.
Module: wm already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 13
Module Instance init => OK
Executing call PutFile; param: wm.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module wm was successfull installed!
Please, restart BGBilling server.
Module: reports already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 11
Module Instance init => OK
Executing call ExecuteSQL; param: reports.sql
Executing database update...OK
Result => true
Executing call PutFile; param: reports:.
Result => true
Executing call PutFile; param: reports.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module reports was successfull installed!
Please, restart BGBilling server.
Module: ipn already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 1
Module Instance init => OK
Executing call AddSchedulerTasks; param: ipn.sc
Scheduled class bitel.billing.server.ipn.LogCalculator already exists!
Scheduled class bitel.billing.server.ipn.IPNTestGates already exists!
Scheduled class bitel.billing.server.ipn.MaxCalculator already exists!
Result => true
Executing call PutFile; param: ipn.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module ipn was successfull installed!
Please, restart BGBilling server.
Module: ru.bitel.bgbilling.plugins.crm already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit plugin id=16
Module Instance init => OK
Executing call PutFile; param: ru.bitel.bgbilling.plugins.crm.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module ru.bitel.bgbilling.plugins.crm was successfull installed!
Please, restart BGBilling server.
Module: ru.bitel.bgbilling.plugins.documents already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit plugin id=17
Module Instance init => OK
Executing call PutFile; param: ru.bitel.bgbilling.plugins.documents.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module ru.bitel.bgbilling.plugins.documents was successfull installed!
Please, restart BGBilling server.
Module: ru.bitel.bgbilling.plugins.cashcheck already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit plugin id=18
Module Instance init => OK
Executing call PutFile; param: ru.bitel.bgbilling.plugins.cashcheck.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module ru.bitel.bgbilling.plugins.cashcheck was successfull installed!
Please, restart BGBilling server.
REPLACED FILES:
/usr/local/BGBillingServer/webroot/xsl/rscm.xsl
/usr/local/BGBillingServer/webroot/stamp.gif
/usr/local/BGBillingServer/webroot/xsl/bill.xsl
/usr/local/BGBillingServer/webroot/xsl/bill_pdf.xsl
/usr/local/BGBillingServer/webroot/id/idealer.js
/usr/local/BGBillingServer/webroot/id/config.html
/usr/local/BGBillingServer/webroot/id/idealer.html
/usr/local/BGBillingServer/webroot/id/index.html
/usr/local/BGBillingServer/webroot/id/idealer.xsl
/usr/local/BGBillingServer/webroot/xsl/card.xsl
/usr/local/BGBillingServer/webroot/xsl/card_action_pdf.xsl
/usr/local/BGBillingServer/webroot/xsl/card_create_contract.xsl
/usr/local/BGBillingServer/actions/dialup.xml
/usr/local/BGBillingServer/webroot/xsl/dialup.xsl
/usr/local/BGBillingServer/webroot/xsl/email.xsl
/usr/local/BGBillingServer/actions/phone.xml
/usr/local/BGBillingServer/webroot/xsl/phone.xsl
/usr/local/BGBillingServer/webroot/xsl/trayinfo.xsl
/usr/local/BGBillingServer/actions/voiceip.xml
/usr/local/BGBillingServer/webroot/xsl/voiceip.xsl
/usr/local/BGBillingServer/webroot/xsl/voiceip_login_amount.xsl
/usr/local/BGBillingServer/webroot/xsl/voiceip_login_direct.xsl
/usr/local/BGBillingServer/webroot/xsl/voiceip_create_contract.xsl
/usr/local/BGBillingServer/webroot/xsl/wm.xsl
/usr/local/BGBillingServer/./reports/contract_tariff.jrxml
/usr/local/BGBillingServer/./reports/dialup_shturman_1.jrxml
/usr/local/BGBillingServer/./reports/kernel_contract_debtor.jrxml
/usr/local/BGBillingServer/actions/reports.xml
/usr/local/BGBillingServer/actions/ipn.xml
/usr/local/BGBillingServer/webroot/xsl/ipn.xsl
/usr/local/BGBillingServer/webroot/xsl/register_problems.xsl
/usr/local/BGBillingServer/webroot/xsl/ru.bitel.bgbilling.plugins.documents.xsl





mysql> SHOW TABLES LIKE 'npay_service_object_%';
+---------------------------------------------+
| Tables_in_bgbilling (npay_service_object_%) |
+---------------------------------------------+
| npay_service_object_7 |
+---------------------------------------------+
1 row in set (0.00 sec)

mysql> SHOW COLUMNS FROM npay_service_object_7;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| csid | int(11) | NO | MUL | | |
| oid | int(11) | NO | | | |
| col | int(11) | NO | | 1 | |
+-------+---------+------+-----+---------+-------+
3 rows in set (0.00 sec)

Дополнение: в обновлении модуля npay - npay_4.6_166.zip нашел файл init и выполнил команды из него вручную, предварительно заменив $mid на 7. После чего нормалайзер отработал без ошибок.

Почему не изменилась структура этой таблицы автоматически?
Нет ли таких же ошибок в файлах обновления для других модулей?

при обнолвени кэшируются запросы, чтоьбы при следующем обновдлении не вызыать их повторно(повторный вызов - это ничего страшного, просто долго работает очень, так пытается накатить все изменеия на база начиная из покон веков ). Я так понмиаю, что вы одном сервере обнвоились на однйо базе , а потом на этой же базе пытались другой сервер обнвоить(кстати это не нормальтно что 2 сервера на одной - вместе рабоать не будут ), а запросы закешировались и занво не запускались . Чтобы сбросить кеш нужно удалить все из таблицы sql_patches_history, тогда при обновления каждого модуля накатятся все изменения