RE: [EXTERNAL] Re: SQLSTATE Error not showing up in mclient Aug2018 version (Aug2018 (11.31.7))

Thanks Panos. I could see both same versions. However, was suspecting if it's tied to older mapi libraries as I do see it's in code base but don't print when concurrency occur. Regards, Sreejith -----Original Message----- From: users-list On Behalf Of Panagiotis Koutsourakis Sent: Monday, October 22, 2018 4:51 PM To: Communication channel for MonetDB users Subject: [EXTERNAL] Re: SQLSTATE Error not showing up in mclient Aug2018 version (Aug2018 (11.31.7)) Hello Sreejith, I am not sure that this is a compilation issue. In any case, when you are compiling MonetDB using the instructions at https://clicktime.symantec.com/a/1/fzNMSApcnjZUtV-5YS85FHvA_iJuEOBi2QIqDIPPSUg=?d=C1XFJ__yHnNkxlkaCF7JW8IKAd1wrcRTdVn6dLy8Q6j7aOrchD__F8SfnrDV5OLugnc7T8M6QYvHUmuPHl8NTa1J11RFDyzwQUuzqCiBSTfMwpWeXo0EuOiSaQZpLw-L7UOEd2P_foISWOzoC7LOObG2GPHyu6-zhKhwmlXIoVKzijQ2xhOQqZf2Emr7v2LHlJpRrbs7g7hEYOxwORIGf2DYnrAg1rqApA8KUQ72YTOTyODWwXXHaH_2iWURRqQIG1gTRcvISwKPZoq0H_IJwJ9wckctcdOW38jhM9e_KnvS48JLpDvCljqRum1ms86dvoqhLcnoEVLl7_tt2nLxikaKnsRfC9kVrQn8NEVCy9eXs6U3uDP6AE01ULOZVpP904iNLtt3uMc4qmG4vY7wWaVM1kYBLckXNNM_te0hIaxNGsnEhsGyw3e129p_9JjdUZgckBtybYcypxrUgvoYtL018g%3D%3D&u=https%3A%2F%2Fwww.monetdb.org%2FDevelopers%2FSourceCompile (bootstrap.sh && configure && make && make install) you will compile mclient as well. You can verify that everything is the same version by executing: $ mserver5 --version MonetDB 5 server v11.31.9 "Aug2018-SP1" (64-bit, 128-bit integers) Copyright (c) 1993 - July 2008 CWI Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved Visit https://clicktime.symantec.com/a/1/0nzoqjwCwQ0lyJVmhwyjQU4xhtw0l-KkmOWwS6s1vNA=?d=C1XFJ__yHnNkxlkaCF7JW8IKAd1wrcRTdVn6dLy8Q6j7aOrchD__F8SfnrDV5OLugnc7T8M6QYvHUmuPHl8NTa1J11RFDyzwQUuzqCiBSTfMwpWeXo0EuOiSaQZpLw-L7UOEd2P_foISWOzoC7LOObG2GPHyu6-zhKhwmlXIoVKzijQ2xhOQqZf2Emr7v2LHlJpRrbs7g7hEYOxwORIGf2DYnrAg1rqApA8KUQ72YTOTyODWwXXHaH_2iWURRqQIG1gTRcvISwKPZoq0H_IJwJ9wckctcdOW38jhM9e_KnvS48JLpDvCljqRum1ms86dvoqhLcnoEVLl7_tt2nLxikaKnsRfC9kVrQn8NEVCy9eXs6U3uDP6AE01ULOZVpP904iNLtt3uMc4qmG4vY7wWaVM1kYBLckXNNM_te0hIaxNGsnEhsGyw3e129p_9JjdUZgckBtybYcypxrUgvoYtL018g%3D%3D&u=https%3A%2F%2Fwww.monetdb.org%2F for further information Found 2264.9GiB available memory, 144 available cpu cores Libraries: libpcre: 8.32 2012-11-30 (compiled with 8.32) openssl: OpenSSL 1.0.2k 26 Jan 2017 (compiled with OpenSSL 1.0.2k-fips 26 Jan 2017) libxml2: 2.9.1 (compiled with 2.9.1) Compiled by: user@machine (OS version) Compilation: gcc -std=gnu99 -O3 -fomit-frame-pointer -pipe -D_FORTIFY_SOURCE=2 Linking : /bin/ld -m elf_x86_64 -Wl,-Bsymbolic-functions $ mclient --version mclient, the MonetDB interactive terminal (Aug2018-SP1) support for command-line editing compiled-in character encoding: UTF-8 The output of both these commands include the string "Aug2018-SP1", so they are both the same version. Best regards, Panos. Sharma, Sreejith @ 2018-10-21 18:50 CEST:

Is this tied anything to mapi_result_errorcode

libtool: compile: gcc -c -I/usr/include/monetdb test.c -fPIC -DPIC -o.libs/test.o

Should this need any compilation as above?

Looking for a response.

Regards, Sreejith

From: Sharma, Sreejith Sent: Thursday, October 18, 2018 7:27 PM To: Communication channel for MonetDB users Subject: SQLSTATE Error not showing up in mclient Aug2018 version (Aug2018 (11.31.7))

All,

Do we have a way to compile mclient along with server source code?

We are not able to see SQLSTATE error code on concurrency with Aug2018 (11.31.7) server version along with mclient Aug2018. Would like to see if we need to specifically compile client too?

ERROR = !COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead CODE: 40000

Regards, Sreejith _______________________________________________ users-list mailing list users-list@monetdb.org https://clicktime.symantec.com/a/1/i3MJ83gZMQ42JoOceGag1Yk01k6EpM7S9IL eUgZU8zg=?d=C1XFJ__yHnNkxlkaCF7JW8IKAd1wrcRTdVn6dLy8Q6j7aOrchD__F8Sfnr DV5OLugnc7T8M6QYvHUmuPHl8NTa1J11RFDyzwQUuzqCiBSTfMwpWeXo0EuOiSaQZpLw-L 7UOEd2P_foISWOzoC7LOObG2GPHyu6-zhKhwmlXIoVKzijQ2xhOQqZf2Emr7v2LHlJpRrb s7g7hEYOxwORIGf2DYnrAg1rqApA8KUQ72YTOTyODWwXXHaH_2iWURRqQIG1gTRcvISwKP Zoq0H_IJwJ9wckctcdOW38jhM9e_KnvS48JLpDvCljqRum1ms86dvoqhLcnoEVLl7_tt2n LxikaKnsRfC9kVrQn8NEVCy9eXs6U3uDP6AE01ULOZVpP904iNLtt3uMc4qmG4vY7wWaVM 1kYBLckXNNM_te0hIaxNGsnEhsGyw3e129p_9JjdUZgckBtybYcypxrUgvoYtL018g%3D% 3D&u=https%3A%2F%2Fwww.monetdb.org%2Fmailman%2Flistinfo%2Fusers-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://clicktime.symantec.com/a/1/i3MJ83gZMQ42JoOceGag1Yk01k6EpM7S9ILeUgZU8zg=?d=C1XFJ__yHnNkxlkaCF7JW8IKAd1wrcRTdVn6dLy8Q6j7aOrchD__F8SfnrDV5OLugnc7T8M6QYvHUmuPHl8NTa1J11RFDyzwQUuzqCiBSTfMwpWeXo0EuOiSaQZpLw-L7UOEd2P_foISWOzoC7LOObG2GPHyu6-zhKhwmlXIoVKzijQ2xhOQqZf2Emr7v2LHlJpRrbs7g7hEYOxwORIGf2DYnrAg1rqApA8KUQ72YTOTyODWwXXHaH_2iWURRqQIG1gTRcvISwKPZoq0H_IJwJ9wckctcdOW38jhM9e_KnvS48JLpDvCljqRum1ms86dvoqhLcnoEVLl7_tt2nLxikaKnsRfC9kVrQn8NEVCy9eXs6U3uDP6AE01ULOZVpP904iNLtt3uMc4qmG4vY7wWaVM1kYBLckXNNM_te0hIaxNGsnEhsGyw3e129p_9JjdUZgckBtybYcypxrUgvoYtL018g%3D%3D&u=https%3A%2F%2Fwww.monetdb.org%2Fmailman%2Flistinfo%2Fusers-list