News:

We really need your input in this questionnaire

Main Menu

nxdbmgr dumps core files

Started by Marcin, July 30, 2014, 11:53:35 AM

Previous topic - Next topic

Marcin

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

Victor Kirhenshtein

Hi!

Can you please provide your netxmsd.conf? It looks like nxdbmgr crashes on configuration file parsing.

Best regards,
Victor

Marcin

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

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

Victor Kirhenshtein

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

Marcin

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