NetXMS Support Forum

I was able to reproduce this problem on my machine. Please replace file src/server/core/userdb_objects.cpp and recompile server - problem should be fixed.

Best regards,
Victor

Just tested on my Ubuntu machine with PostgreSQL - I got failed SQL query, but no crash. Could you please run netxmsd under gdb and when it crashes get stack trace with bt command?

To run under gdb:

# gdb netxmsd
(gdb) run

when crashes
(gdb) bt

Best regards,
Victor

Hi!

Yes, it's a bug - there should be

DELETE FROM user_groups WHERE id=%d

However, failed SQL query should not cause server to crash anyway. Could you try to replace groups to user_groups in this query, recompile server and try delete group again?

Best regards,
Victor

Vilozil obnovlennij User Manual, tam dobavleno opisanie monitoringa sysloga.

Dlja sysloga znavhenija severity sledujuschie:

1   Emergency
2   Alert
4   Critical
8   Error
16 Warning
32 Notice
64 Informational
128 Debug

T.e. dlja fil'tracii informational, notice, and warning nado pisat' <level>112</level>

Please direct netxmsd output to file by replacing

LogFile = {syslog}

to

LogFile = some_file_name

in netxmsd.conf, then to start it from command line in debug mode:

netxmsd -D 9

and post debug output here or send it to [email protected].

Best regards,
Victor

Hello all!

NetXMS version 0.2.30 released. It fixes upgrade problems discovered in 0.2.29, mostly related to installations with MS SQL or Oracle as backend database. If you are already upgraded to 0.2.29 and does not experience any problems, upgrade to 0.2.30 is not necessary.

Best regards,
Victor

Please try to replace nxdbmgr.exe with attached one and run upgrade process again.

Best regards,
Victor

Spasibo, ispravil.

Hello all!

NetXMS version 0.2.29 released. It fixes important upgrade problems discovered in 0.2.28. If you are already upgraded to 0.2.28 and does not experience any problems, upgrade to 0.2.29 is not necessary.

Best regards,
Victor

Да, это вторая проблема с этим релизом Я сейчас готовлю исправленный дистрибутив, инсталлер агента уже готов - https://www.netxms.org/download/agent_packages/nxagent-0.2.29.exe. Можно пробовать.

Hi all!

There are reports about some problems when upgrading NetXMS to version 0.2.28. Please do not upgrade right now, we are working on a fix.

Best regards,
Victor

Quote from: Ethril on October 06, 2009, 03:03:41 PM
У меня похожие проблемы при апгрейде с 0.2.27 на 0.2.28.
DB Upgrade долго работает, но в итоге не отрабатывает. Как автоматический из инсталлятора, так и ручной из командной строки.

Похоже что upgrade валится на больших логах. Если это не критично, попробуйте очистить логи:

DELETE FROM event_log
DELETE FROM audit_log
DELETE FROM syslog
DELETE FROM snmp_trap_log

После этого апгрейд должен пройти.

Альтернативный вариант - логи не трогать, и просто выполнить query

UPDATE metadata SET var_value='98' WHERE var_name='SchemaVersion'

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

Quote from: Akira on October 06, 2009, 02:20:07 PM
Не апгрейдит  

nxdbmgr.exe check
NetXMS Database Manager Version 0.2.28

Configuration file OK
Checking database:
Your database has format version 95, this tool is compiled for version 98.
Use "upgrade" command to upgrade your database first.
Database check aborted

nxdbmgr.exe upgrade
NetXMS Database Manager Version 0.2.28

Configuration file OK
Upgrading database...
Upgrading from version 95 to 96
SQL query failed (General SQL Server error: Check messages from the SQL Server.):
UPDATE object_properties SET comments=N''+nchar(-48)+N''+nchar(-96)+N'' ............. WHERE object_id=407
Rolling back last stage due to upgrade errors...
Database upgrade failed

Откатился пока обратно...

Попробуйте заменить mssql.ddr на файл из аттачмента и провести апгрейд еще раз.

Hi!

Attached are missing files. I'll fix that in next release.

Best regards,
Victor