Показано с 1 по 4 из 4

Тема: Не удалось выполнить запрос к базе данных.

  1. #1
    Member
    Регистрация
    16.11.2012
    Сообщений
    56

    По умолчанию Не удалось выполнить запрос к базе данных.

    Переносил VEmanager, 3 таблицы залил вручную
    users, vm, ip.

    При удалении\добавлении адреса на сервер, получаю ошибку "Не удалось выполнить запрос к базе данных."

    Nov 12 00:24:09 [851536:21] client EXTINFO Query('&func=vm.param&ctid=1481&param=getip')
    Nov 12 00:24:09 [851536:21] db EXTINFO Query: 'SELECT domain FROM ip WHERE ip='176.31.83.11' AND owner=1481'
    Nov 12 00:24:09 [851536:21] db DEBUG libdb_mysql.cpp:641 Query OK, 0 row(s) affected
    Nov 12 00:24:09 [851536:21] db DEBUG libdb_mysql.cpp:647 column[0]: 'domain'
    Nov 12 00:24:09 [851536:21] db EXTINFO Query: 'SELECT MAX(changedate) FROM history_vm WHERE reference = '1481''
    Nov 12 00:24:09 [851536:21] db DEBUG libdb_mysql.cpp:641 Query OK, 1 row(s) affected
    Nov 12 00:24:09 [851536:21] db DEBUG libdb_mysql.cpp:647 column[0]: 'MAX(changedate)'
    Nov 12 00:24:09 [851536:21] db EXTINFO Query: 'UPDATE vm SET ip_history='151.*.*.*' WHERE id='1481''
    Nov 12 00:24:09 [851536:21] db ERROR query error: Unknown column 'ip_history' in 'field list'
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO mgr_db::Fail::Fail(std::string const&, std::string const&, std::string const&) (lib/libmgrdb.so.5.43.1 + 0x4d) [*0x7f742dc7ea30]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO ??? (lib/libmysql.so.5.43.1 + 0x0) [*0x7f742dc7eb8c]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO ??? (lib/libmysql.so.5.43.1 + 0x0) [*0x7f743599c230]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO mgr_db::Connection::Query(std::string const&) (lib/libmgrdb.so.5.43.1 + 0xb0) [*0x7f743599f52b]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO mgr_db::Cache::Query(std::string const&) (lib/libmgrdb.so.5.43.1 + 0x3b) [*0x7f74359ab017]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO mgr_db::CustomTable::Post() (lib/libmgrdb.so.5.43.1 + 0x10d7) [*0x7f74361ca877]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO ve_utils::CheckMainIp(std::shared_ptr<VmTable>&) (lib/vemgr.so + 0x347) [*0x7f743616c1f2]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO ??? (lib/vemgr.so + 0x0) [*0x7f743494fb4d]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO isp_api::Action::Run(isp_api::Session&) const (lib/libispapi.so.5.43.1 + 0x9d) [*0x7f743495035b]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO isp_api::InternalCall(isp_api::BaseConnection const&, isp_api::Authen const&, isp_api::Action const&) (lib/libispapi.so.5.43.1 + 0x46b) [*0x7f7435c3e5cc]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO ispcore::ProcessRequest:perator()() (lib/libbase.so.5.43.1 + 0x4bc) [*0x7f7435c415e5]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO mgr_thread::List::Impl<ispcore::ProcessRequest>:perator()() (lib/libbase.so.5.43.1 + 0x45) [*0x7f74356927a7]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO ??? (lib/libmgr.so.5.43.1 + 0x0) [*0x7f7436a91b50]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO ??? (/lib/x86_64-linux-gnu/libpthread.so.0 + 0x0) [*0x7f74367db95d]
    Nov 12 00:24:09 [851536:21] backtrace EXTINFO ??? (/lib/x86_64-linux-gnu/libc.so.6 + 0x6d) [*(nil)]
    Nov 12 00:24:09 [851536:21] err ERROR Error: Type: 'db' Object: 'query' Value: ''
    Nov 12 00:24:09 [851536:21] action EXTINFO Get message for error in action 'iplist.edit' for level 29
    Nov 12 00:24:09 [851536:21] action EXTINFO Get message for error in action 'mgrerror_db' for level 29
    Nov 12 00:24:09 [851536:21] db TRACE Find index = 1, key = 'id='1'', cache size = 0
    Nov 12 00:24:09 [851536:21] db TRACE Find m_parent->m_table_cache.size() = 16
    Nov 12 00:24:09 [851536:21] ssh EXTINFO id=cc1a79 execute
    Nov 12 00:24:09 [851536:21] ssh EXTINFO id=cc1a79 Remote hostkey:
    AAAAB3NzaC1yc2EAAA=
    Nov 12 00:24:09 [851536:21] ssh EXTINFO id=cc1a79 Hostkey verified
    Nov 12 00:24:09 [851536:21] ssh EXTINFO user = 'root', public = '/usr/local/mgr5/etc/ssh_id_rsa.pub', private = '/usr/local/mgr5/etc/ssh_id_rsa'
    Nov 12 00:24:09 [851536:21] ssh INFO id=cc1a79 Run ssh command 'echo' on root@149.*.*.*
    Nov 12 00:24:09 [851536:21] ssh INFO id=cc1a79 Ssh command finished with status 0
    Nov 12 00:24:09 [851536:21] ssh EXTINFO id=9f69d9 execute
    Nov 12 00:24:09 [851536:21] ssh EXTINFO user = 'root', public = '/usr/local/mgr5/etc/ssh_id_rsa.pub', private = '/usr/local/mgr5/etc/ssh_id_rsa'
    Nov 12 00:24:09 [851536:21] ssh INFO id=9f69d9 Run ssh command 'ls /tmp/check-local.yiWMdD' on root@149.*.*.*
    Nov 12 00:24:09 [851536:21] ssh INFO id=9f69d9 Ssh command finished with status 0
    Nov 12 00:24:09 [851536:21] client EXTINFO Query('&func=vm.param&ctid=1481&param=ipdel&value= 151.*.*.*')
    Nov 12 00:24:09 [851536:21] db EXT Exec: ROLLBACK
    Nov 12 00:24:09 [851536:21] db EXTINFO rollback transaction
    Nov 12 00:24:09 [851536:21] action EXTINFO Get message for error in action 'msgerror' for level 29
    Nov 12 00:24:09 [851536:21] core WARNING 0x7f742800d310 Restart request
    Nov 12 00:24:09 [851536:21] thread EXTINFO Start thread 
    Nov 12 00:24:09 [851536:22] core TRACE void ispcore::ProcessRequest:perator()()
    Nov 12 00:24:09 [851536:22] journal EXTINFO Internal [][] 'func=authenticate.vemgrauth&username=admin'
    Nov 12 00:24:09 [851536:22] db TRACE mgr_db::Cache::Revision* mgr_db::Cache::GetRevision()
    Nov 12 00:24:09 [851536:22] db EXTINFO begin transaction
    Nov 12 00:24:09 [851536:22] db EXTINFO Query: 'SELECT * FROM users WHERE name='admin''
    Nov 12 00:24:09 [851536:22] db DEBUG libdb_mysql.cpp:641 Query OK, 1 row(s) affected
    Nov 12 00:24:09 [851536:21] thread EXTINFO Thread 19269e01f3dee51d finished
    Nov 12 00:24:09 [851536:22] db DEBUG libdb_mysql.cpp:647 column[0]: 'id'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb_mysql.cpp:647 column[1]: 'name'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb_mysql.cpp:647 column[2]: 'password'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb_mysql.cpp:647 column[3]: 'level'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb_mysql.cpp:647 column[4]: 'enabled'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb_mysql.cpp:647 column[5]: 'snapshot_limit'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb_mysql.cpp:647 column[6]: 'note'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb.cpp:1419 Field[enabled] = 'on'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb.cpp:1419 Field[level] = '29'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb.cpp:1419 Field[password] = '$1$mYDnTJl8$JO3y2XpWy4QFU3lQ519ea/'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb.cpp:1419 Field[name] = 'admin'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb.cpp:1419 Field[id] = '1'
    Nov 12 00:24:09 [851536:22] db TRACE Add 0x79f7b0:0 'id='1''
    Nov 12 00:24:09 [851536:22] progress EXTINFO Register progress 'a0b36dddfce9:false_1447277046503'
    Nov 12 00:24:09 [851536:22] journal INFO Request [159.224.*.*][admin] 'clicked_button=ok&domain=fsafd.ru&family=ipv4&fun c=iplist.edit&ip=&iptype=public&operafake=14472770 46504&plid=1481&progressid=false%5F1447277046503&s from=ajax'
    Nov 12 00:24:09 [851536:22] proc EXTINFO Run '/bin/sh -c cat\ /proc/uptime' pid 883128
    Nov 12 00:24:09 [851536:22] proc EXTINFO Process 883128 finished with status 0
    Nov 12 00:24:09 [851536:22] db TRACE Find index = 2, key = 'id='1481'', cache size = 0
    Nov 12 00:24:09 [851536:22] db TRACE Find m_parent->m_table_cache.size() = 16
    Nov 12 00:24:09 [851536:22] db TRACE Find index = 2, key = 'id='1481'', cache size = 0
    Nov 12 00:24:09 [851536:22] db TRACE Find m_parent->m_table_cache.size() = 16
    Nov 12 00:24:09 [851536:22] db TRACE Find index = 1, key = 'id='1'', cache size = 0
    Nov 12 00:24:09 [851536:22] db TRACE Find m_parent->m_table_cache.size() = 16
    Nov 12 00:24:09 [851536:22] db TRACE mgr_db::Cache::Revision* mgr_db::Cache::GetRevision()
    Nov 12 00:24:09 [851536:22] db EXT Exec: BEGIN TRANSACTION
    Nov 12 00:24:09 [851536:22] db EXTINFO Query: 'SELECT ranges.name AS name, ranges.type AS type FROM ranges LEFT JOIN ips ON ranges.id=ips.ranges WHERE ips.domain='' GROUP BY ranges.name, ranges.type'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb.cpp:1937 Merge table '0'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb.cpp:1941 Merge 'id='1''
    Nov 12 00:24:09 [851536:22] db TRACE Add 0x719f40:0 'id='1''
    Nov 12 00:24:09 [851536:22] db DEBUG libdb.cpp:2042 Version id='1' 21, 20
    Nov 12 00:24:09 [851536:22] db DEBUG libdb.cpp:1937 Merge table '1'
    Nov 12 00:24:09 [851536:22] db DEBUG libdb.cpp:1937 Merge table '2'
    Nov 12 00:24:09 [851536:22] db EXTINFO commit transaction
    Nov 12 00:24:09 [851536:22] db EXT Exec: COMMIT
    Nov 12 00:24:09 [851536:22] thread EXTINFO Thread 713f084c0fad1bbe finished

  2. #2
    ISPsystem team Аватар для Fly
    Регистрация
    14.08.2010
    Сообщений
    4,765

    По умолчанию

    Nov 12 00:24:09 [851536:21] db EXTINFO Query: 'UPDATE vm SET ip_history='151.*.*.*' WHERE id='1481''
    Nov 12 00:24:09 [851536:21] db ERROR query error: Unknown column 'ip_history' in 'field list'

    В таблице vm не хватает поля ip_history.

  3. #3
    Member
    Регистрация
    16.11.2012
    Сообщений
    56

    По умолчанию

    про vm я еще понял, т.к я заливал с старой базы.
    но потом еще не хватало аналогичных полей в vm_history хотя я её вообще не трогал.
    как так, свежая установленная панель их не создала?

  4. #4
    ISPsystem team Аватар для usaafko
    Регистрация
    06.10.2013
    Сообщений
    2,384

    По умолчанию

    Такие вещи могут создаваться при добавлении узла. После установки панель работала нормально?
    Проблемы начались, когда вы залили таблицы с другого сервера?

Ваши права

  • Вы не можете создавать новые темы
  • Вы не можете отвечать в темах
  • Вы не можете прикреплять вложения
  • Вы не можете редактировать свои сообщения
  •