[MCOL-1877] getactivesqlstatements returns 'file open error' Created: 2018-11-12  Updated: 2023-10-26  Resolved: 2018-11-16

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 1.2.1
Fix Version/s: 1.2.2

Type: Bug Priority: Major
Reporter: Patrick LeBlanc (Inactive) Assignee: David Hill (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

Centos 7 vms, DBS-like installation



 Description   

Running as not-root with no sudo access, 'getactivesqlstatements' returns the following when there are no active sql statements.

mcsadmin> getactivesqlstatements
getactivesqlstatements Mon Nov 12 10:44:02 2018

Get List of Active SQL Statements
=================================

Failed to get List of Active SQL Statements: API Failure return in getActiveSQLStatements API:
File Open error from getActiveSQLStatements API



 Comments   
Comment by David Hill (Inactive) [ 2018-11-16 ]

test with um logging working and no queries

mcsadmin> getActiveSQLStatements
getactivesqlstatements Fri Nov 16 20:36:43 2018

Get List of Active SQL Statements
=================================

No Active SQL Statements at this time

mcsadmin>

tested by added this at the bottom of a debug log on um1

Nov 16 20:36:10 ip-172-31-21-125 ExeMgr[16528]: 10.594050 |18|0|0| D 16 CAL0042: End SQL statement
Nov 16 20:36:10 ip-172-31-21-125 ExeMgr[16528]: 10.864730 |18|0|0| D 16 CAL0041: Start SQL statement: select * from tmp; |david|
Nov 16 20:36:10 ip-172-31-21-125 ExeMgr[16528]: 10.870934 |18|0|0| D 16 CAL0042: End SQL statement
Nov 16 20:36:10 ip-172-31-21-125 ExeMgr[16528]: 10.864730 |18|0|0| D 16 CAL0041: Start SQL statement: select * from tmp; |david|

getActiveSQLStatements
getactivesqlstatements Fri Nov 16 20:37:50 2018

Get List of Active SQL Statements
=================================

Start Time Time (hh:mm:ss) Session ID SQL Statement
---------------- ---------------- -------------------- ------------------------------------------------------------
Nov 16 20:36:10 00:01:40 18 select * from tmp; |david|

mcsadmin>

I moved debug.log on um1 and got this error

mcsadmin> getActiveSQLStatements
getactivesqlstatements Fri Nov 16 20:39:03 2018

Get List of Active SQL Statements
=================================

Failed to get List of Active SQL Statements: API Failure return in getActiveSQLStatements API:
File Open error from getActiveSQLStatements API

mcsadmin>

So I think there was no logging happening when this was tested. So couldnt reproduce when system has logging.

Comment by David Hill (Inactive) [ 2018-11-16 ]

testing with the DBS 1.1.6 to 1.2.1 upgrade path

after 1.1.6 is installed

mcsadmin> getActiveSQLStatements
getactivesqlstatements Fri Nov 16 20:58:19 2018

Get List of Active SQL Statements
=================================

No Active SQL Statements at this time

mcsadmin>

after upgrade to 1.2.1

mcsadmin> getActiveSQLStatements
getactivesqlstatements Fri Nov 16 21:09:20 2018

Get List of Active SQL Statements
=================================

No Active SQL Statements at this time

mcsadmin>

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