[MCOL-879] With querystats enabled, mysqld crashes when process a query Created: 2017-08-16  Updated: 2017-09-05  Resolved: 2017-09-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.1.0
Fix Version/s: 1.1.0

Type: Bug Priority: Critical
Reporter: Daniel Lee (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2017-16, 2017-17, 2017-18

 Description   

Build tested: Github source 1.1.0

/root/columnstore/mariadb-columnstore-server
commit 6ed33d194819aaa5f2521c888639f44546fb7ce2
Merge: 97284ea 770537e
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Thu Aug 3 20:54:13 2017 +0100

Merge pull request #66 from mariadb-corporation/MCOL-684

MCOL-684 call fix_fields for parameters in PREPARED statements

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit d9233bde4932bd8d621888e33a38f34c181445b4
Author: David Hill <david.hill@mariadb.com>
Date: Tue Aug 15 20:41:26 2017 +0000

moved CONFIGURE option to bottom of list

diff --git a/oam/oamcpp/liboamcpp.h b/oam/oamcpp/liboamcpp.h
index 6b24a30..8c0e3ed 100644
— a/oam/oamcpp/liboamcpp.h
+++ b/oam/oamcpp/liboamcpp.h
@@ -558,7 +558,6 @@ namespace oam
HEARTBEAT_SEND,
PROCBUILDSYSTEMTABLES,
LOCALHEARTBEAT,

  • CONFIGURE,
    RECONFIGURE,
    PROCESSRESTART,
    GETSOFTWAREINFO,
    @@ -580,7 +579,8 @@ namespace oam
    MASTERDIST,
    DISABLEREP,
    PROCGLUSTERASSIGN,
  • PROCGLUSTERUNASSIGN
    + PROCGLUSTERUNASSIGN,
    + CONFIGURE
    };

This issue was identified when testing MCOL-400.

To reproduce the issue, just enable cross-engine-join and querystats in Columnstore.xml

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2017-08-16 ]

This is due to me forgetting to apply MCOL-574 to query stats as well as cross engine. Workaround is to set cross engine to 127.0.0.1 instead of 'localhost'

Comment by Andrew Hutchings (Inactive) [ 2017-08-17 ]

In addition to that problem (which just causes an error) we have a name conflict on my_charset_latin1_general_ci between the server and libmysql. This is what is triggering the crash.

Comment by Andrew Hutchings (Inactive) [ 2017-08-18 ]

The fix is rather complex due to linking issues. I've tried to explain it in the commit message but let me know if you need more details.

Comment by Daniel Lee (Inactive) [ 2017-09-05 ]

Build verified: 1.1.0 Github source

/root/columnstore/mariadb-columnstore-server
commit 6ed33d194819aaa5f2521c888639f44546fb7ce2
Merge: 97284ea 770537e
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Thu Aug 3 20:54:13 2017 +0100

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 90353b9b908e1c9ee241c4a156a2a377c53cc807
Author: david hill <david.hill@mariadb.com>
Date: Fri Sep 1 14:46:07 2017 -0500

Generated at Thu Feb 08 02:24:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.