Hello,
I did an upgrade of NetXMS from version 1.2.13 to 1.2.15 on Solaris 10. As a consequence I have to upgrade Oracle 11.2.0 database format:
[30-Jul-2014 10:33:53.636] [DEBUG] Successful sync query: "SELECT var_value FROM metadata WHERE var_name='SchemaVersion'" [6 ms]
[30-Jul-2014 10:33:53.636] [ERROR] Your database has format version 307, but server is compiled for version 330
Unfortunately nxdbmgr is not working anymore, it's always dumping core files:
root$ /opt/netxms/bin/nxdbmgr check
NetXMS Database Manager Version 1.2.15 Build 7879
Bus Error (core dumped)
I tried also with version 1.2.14 - error is the same.
Now I reverted back to 1.2.13 and there are no problems:
root$ /opt/netxms/bin/nxdbmgr check
NetXMS Database Manager Version 1.2.13 Build 7863
Checking database (excluding collected data):
* Checking zone objects... [PASSED]
* Checking node objects... [PASSED]
* Checking interface objects... [PASSED]
* Checking network service objects... [PASSED]
* Checking cluster objects... [PASSED]
* Checking template to node mapping... [PASSED]
* Checking object properties... [PASSED]
* Checking event processing policy... [PASSED]
* Checking network map links... [PASSED]
Database doesn't contain any errors
Database check completed
Details of core file:
root$ pstack core
core 'core' of 5109: /opt/netxms/bin/nxdbmgr check
ffffffff7f015808 __1cGConfigNparseTemplate6MpkwpnPNX_CFG_TEMPLATE__b_ (1001c5010, 0, 1001e3bf0, 1001e5db0, ffffffff7f036034, ffffffff7fffb590) + 158
0000000100008e3c main (100000, ffffffff7ffffb08, 100024, 1, 63, 100024000) + a2c
000000010000736c _start (0, 0, 0, 0, 0, 0) + 12c
root$ pmap core
core 'core' of 5109: /opt/netxms/bin/nxdbmgr check
0000000100000000 448K r-x-- /opt/netxms/bin/nxdbmgr
000000010016E000 328K rwx-- /opt/netxms/bin/nxdbmgr
00000001001C0000 168K rwx-- [ heap ]
FFFFFFFF7C400000 688K r-x-- /lib/sparcv9/libnsl.so.1
FFFFFFFF7C5AC000 64K rwx-- /lib/sparcv9/libnsl.so.1
FFFFFFFF7C5BC000 32K rwx-- /lib/sparcv9/libnsl.so.1
FFFFFFFF7C600000 152K r-x-- /lib/sparcv9/libelf.so.1
FFFFFFFF7C726000 16K rwx-- /lib/sparcv9/libelf.so.1
FFFFFFFF7C800000 1272K r-x-- /lib/sparcv9/libc.so.1
FFFFFFFF7CA3E000 72K rwx-- /lib/sparcv9/libc.so.1
FFFFFFFF7CA50000 8K rwx-- /lib/sparcv9/libc.so.1
FFFFFFFF7CB00000 584K r-x-- /lib/sparcv9/libm.so.2
FFFFFFFF7CC00000 64K rwx--
FFFFFFFF7CC90000 32K rwx-- /lib/sparcv9/libm.so.2
FFFFFFFF7CD00000 64K r-x-- /usr/lib/sparcv9/libCrun.so.1
FFFFFFFF7CE0E000 16K rwx-- /usr/lib/sparcv9/libCrun.so.1
FFFFFFFF7CE12000 16K rwx-- /usr/lib/sparcv9/libCrun.so.1
FFFFFFFF7CF00000 1680K r-x-- /usr/lib/sparcv9/libCstd.so.1
FFFFFFFF7D100000 8K r-x-- /platform/sun4u-opl/lib/sparcv9/libc_psr.so.1
FFFFFFFF7D1A2000 64K rwx-- /usr/lib/sparcv9/libCstd.so.1
FFFFFFFF7D200000 1952K r-x-- /opt/netxms/lib/libcrypto.so.1.0.0
FFFFFFFF7D400000 64K rwx--
FFFFFFFF7D4E6000 144K rwx-- /opt/netxms/lib/libcrypto.so.1.0.0
FFFFFFFF7D50A000 16K rwx-- /opt/netxms/lib/libcrypto.so.1.0.0
FFFFFFFF7D600000 56K r-x-- /lib/sparcv9/libsocket.so.1
FFFFFFFF7D700000 24K rwx--
FFFFFFFF7D70E000 16K rwx-- /lib/sparcv9/libsocket.so.1
FFFFFFFF7D800000 8K r-x-- /lib/sparcv9/libdl.so.1
FFFFFFFF7D902000 8K rwx-- /lib/sparcv9/libdl.so.1
FFFFFFFF7DA00000 8K r-x-- /lib/sparcv9/libkstat.so.1
FFFFFFFF7DB02000 8K rwx-- /lib/sparcv9/libkstat.so.1
FFFFFFFF7DC00000 88K r-x-- /usr/lib/sparcv9/libz.so.1
FFFFFFFF7DD00000 8K rwx--
FFFFFFFF7DD14000 8K rwx-- /usr/lib/sparcv9/libz.so.1
FFFFFFFF7DE00000 288K r-x-- /lib/sparcv9/libresolv.so.2
FFFFFFFF7DF00000 8K rwx--
FFFFFFFF7DF48000 24K rwx-- /lib/sparcv9/libresolv.so.2
FFFFFFFF7DF4E000 8K rwx-- /lib/sparcv9/libresolv.so.2
FFFFFFFF7E000000 16K r-x-- /usr/lib/sparcv9/libkvm.so.1
FFFFFFFF7E100000 8K rwx--
FFFFFFFF7E104000 8K rwx-- /usr/lib/sparcv9/libkvm.so.1
FFFFFFFF7E200000 584K r-x-- /opt/netxms/lib/libnxsqlite.so.1.0.0
FFFFFFFF7E300000 8K rwx--
FFFFFFFF7E390000 24K rwx-- /opt/netxms/lib/libnxsqlite.so.1.0.0
FFFFFFFF7E400000 64K r-x-- /opt/netxms/lib/libnxtre.so.5.0.0
FFFFFFFF7E500000 8K rwx--
FFFFFFFF7E50E000 8K rwx-- /opt/netxms/lib/libnxtre.so.5.0.0
FFFFFFFF7E600000 152K r-x-- /opt/netxms/lib/libnxexpat.so.1.0.0
FFFFFFFF7E700000 8K rwx-- /lib/sparcv9/libxnet.so.1
FFFFFFFF7E724000 8K rwx-- /opt/netxms/lib/libnxexpat.so.1.0.0
FFFFFFFF7E800000 64K r-x-- /opt/netxms/lib/libnxsnmp.so.1.0.0
FFFFFFFF7E900000 16K r-x-- /lib/sparcv9/libpthread.so.1
FFFFFFFF7E90E000 16K rwx-- /opt/netxms/lib/libnxsnmp.so.1.0.0
FFFFFFFF7EA00000 136K r-x-- /opt/netxms/lib/libnxsrv.so.1.0.0
FFFFFFFF7EB00000 8K rwx--
FFFFFFFF7EB20000 16K rwx-- /opt/netxms/lib/libnxsrv.so.1.0.0
FFFFFFFF7EC00000 40K r-x-- /opt/netxms/lib/libnxmap.so.1.0.0
FFFFFFFF7ED00000 8K rwx--
FFFFFFFF7ED08000 8K rwx-- /opt/netxms/lib/libnxmap.so.1.0.0
FFFFFFFF7EE00000 56K r-x-- /opt/netxms/lib/libnxdb.so.1.0.0
FFFFFFFF7EF00000 8K rwx--
FFFFFFFF7EF0C000 8K rwx-- /opt/netxms/lib/libnxdb.so.1.0.0
FFFFFFFF7EF0E000 8K rwx-- /opt/netxms/lib/libnxdb.so.1.0.0
FFFFFFFF7F000000 256K r-x-- /opt/netxms/lib/libnetxms.so.1.0.0
FFFFFFFF7F100000 8K rwx--
FFFFFFFF7F13E000 32K rwx-- /opt/netxms/lib/libnetxms.so.1.0.0
FFFFFFFF7F146000 80K rwx-- /opt/netxms/lib/libnetxms.so.1.0.0
FFFFFFFF7F200000 8K rwx--
FFFFFFFF7F300000 8K rw---
FFFFFFFF7F400000 8K rw---
FFFFFFFF7F500000 8K rwx--
FFFFFFFF7F600000 240K r-x-- /lib/sparcv9/ld.so.1
FFFFFFFF7F700000 8K rwx--
FFFFFFFF7F73C000 24K rwx-- /lib/sparcv9/ld.so.1
FFFFFFFF7F792000 8K rwx--
FFFFFFFF7FFF6000 40K rw--- [ stack ]
total 10528K
Could you help me with this problem?
Best regards,
Marcin
Hi!
Can you please provide your netxmsd.conf? It looks like nxdbmgr crashes on configuration file parsing.
Best regards,
Victor
Here is content of netxsmd.conf file. Sensitive data were replaced by XXX (all of the characters were ASCII, no special ones)
DBDriver = /opt/netxms/lib/netxms/dbdrv/oracle.ddr
DBServer = XXX:1525/TDWNDB.world
DBLogin = XXX
DBPassword = XXX
#DBEncryptedPassword = XXX
DBSchema= XXX
LogFailedSQLQueries = yes
LogFile = /var/log/netxmsd
DebugLevel=0
Exactly the same configuration file is OK for nxdbmgr version 1.2.13.
Best regards,
Marcin
Hi,
Through trial and error method I found that problematic line in the configuration file is:
DBSchema = XXX
After commenting this line tool seems to be working:
root$ /opt/netxms/bin/nxdbmgr check
NetXMS Database Manager Version 1.2.15 Build 7879
Checking database (excluding collected data):
Your database has format version 307, this tool is compiled for version 330.
Use "upgrade" command to upgrade your database first.
Database check aborted
I'm not sure if this line is necessary.
Best regards,
Marcin
Hi,
normally it is not necessary. You only need to specify schema if it is not default one for database user.
I've found the bug causing crash. Next release will handle DBSchema parameter correctly.
Best regards,
Victor
Hi,
Without DBSchema it's working correctly.
Probably the same bug was causing problems with DBencryptedPassword:
https://www.netxms.org/forum/configuration/dbencryptedpassword-not-working-with-1-2-15/
Best regards,
Marcin