NetXMS-1.2.11 Crash on FreeBSD-9.2
-
-
-
Hi!
There was another installation crashing in very similar way, on console connect, but on Windows. There problem was solved by replacing MySQL client library with latest version. Is there any updates for MySQL client?
Best regards,
Victor -
-
-
Yes, please try MySQL 5.5. Also, I'll prepare test update later today - I've found some potentially problematic places in our MySQL driver.
Best regards,
Victor -
Please try this version: https://www.dropbox.com/s/rft98tv0ahnekv6/netxms-1.2.12.tar.gz. Note that it will upgrade your database, you won't be able to go back to 1.2.11, so do backup first.
Best regards,
Victor -
Building it right now..
I'll let you know,
Still on MySQL-5.6 btw.Just in case it's helpfull:
---------------------------------------------------------------------
Configure results
---------------------------------------------------------------------Prefix : /usr/local/netxms
Platform : FreeBSD
Shared library suffix : .so
Build Server : YES
Server libs : -lssl -ltermcap -lreadline
XMPP support : YES
Encryption enabled : YES
Build DB-Drivers : mysql
Build Clients : NO
Build Agent : YES
Subagents list : freebsd netsvc
Build Static Agent : NO
UNICODE build : NO
Use internal libexpat : NO
Use internal libtre : YES
Use internal zlib : NO
Force 32bit build : NO
C compiler : gcc
C++ compiler : g++
CPPFLAGS : -D_THREAD_SAFE -DTRE_WCHAR=1 -I/usr/local/mysql/include -I/usr/include/mysql -I/usr/mysql/include -I/usr/local/include/mysql -I/usr/local/mysql/include/mysql -I/usr/mysql/include/mysql -I/opt/openssl/include -Wformat -I/usr/local/include -DPREFIX=\"${prefix}\" -DDATADIR=\"${pkgdatadir}\" -DBINDIR=\"${bindir}\" -DLIBDIR=\"${libdir}\" -DPKGLIBDIR=\"${pkglibdir}\"
CXXFLAGS : -g -O2 -fno-rtti -fno-exceptions
CFLAGS : -g -O2
LDFLAGS : -L/usr/local/mysql/lib -L/usr/lib64/mysql -L/usr/lib/mysql -L/usr/mysql/lib -L/usr/local/lib/mysql -L/usr/local/mysql/lib/mysql -L/usr/mysql/lib/mysql -L/usr/local/lib -L/opt/openssl/lib -L/usr/local/lib
LIBS : -lkvm -lexpat -lz -pthread -lcrypto -liconv
MySQL libs : -lmysqlclient -
So far so good, normally it would have crashed a few times by now..
Still using the 1.2.11 client btw. I do not have the knowledge and resources to compile the client for windows.
The build error on SQLite is gone too, great job
[Update]
I don't know what you fixed exactly but it did the job! Not a single crash anymore since I installed 1.2.12! -
Nice to hear! This crash was one of the strangest problems I had to debug with NetXMS - different platforms, crashes differently, only one thing in common - MySQL backend...
As for what I've fixed - I add a mutex around calls to mysql_stmt_data_seek and mysql_stmt_fetch. Under some conditions two threads call them on different statements, but same MySQL connection. I was thinking that because I'm using mysql_stmt_store_result to cache statement result locally, they are independent, but seems they are not.Best regards,
Victor
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login