Project

General

Profile

Bug #18996

SQL query written as empty file

Added by Dave F almost 3 years ago. Updated almost 3 years ago.

Status:
Closed: Duplicate
Priority:
Nice to have
Assignee:
Josh Paetzel
Category:
Middleware
Target version:
Seen in:
Severity:
New
Reason for Closing:
Reason for Blocked:
Needs QA:
Yes
Needs Doc:
Yes
Needs Merging:
Yes
Needs Automation:
No
Support Suite Ticket:
n/a
Hardware Configuration:

Xeon(R) CPU E3-1220 v3 @ 3.10GHz
16GB ECC
5xWD RED 2TB
2xWD BLUE SSD 250GB
LSI 9211 IT mode

ChangeLog Required:
No

Description

Bit of an odd one. Seems there is a SQL query being written to the root file system with the file name "SELECT tun_var, tun_value FROM system_tunable WHERE tun_enabled = 1 AND tun_type = 'sysctl' ORDER BY id".

I've deleted it previously but it comes back.

Example:

[root@tardis] /# ls -l
total 77
drwxr-xr-x  20 root    wheel     26 Nov 17 11:16 ./
drwxr-xr-x  20 root    wheel     26 Nov 17 11:16 ../
-r--r--r--   1 root    wheel   6142 Oct  6 21:31 COPYRIGHT
-rw-r--r--   1 root    wheel      0 Nov 17 11:16 SELECT tun_var, tun_value FROM system_tunable WHERE tun_enabled = 1 AND tun_type = 'sysctl' ORDER BY id
drwxr-xr-x   2 root    wheel     47 Nov 10 21:23 bin/
drwxr-xr-x  10 root    wheel     56 Nov 10 21:24 boot/
drwxr-xr-x   3 root    wheel      3 Apr  9  2016 compat/

Related issues

Related to FreeNAS - Bug #18903: consolidate the ix-* rc.d scriptsResolved2016-11-14

History

#1 Updated by Dave F almost 3 years ago

File appears to be created when creating or modifying a tunable in the GUI.

#2 Updated by Josh Paetzel almost 3 years ago

  • Status changed from Unscreened to Investigation
  • Assignee set to Josh Paetzel
  • Priority changed from No priority to Nice to have

#3 Updated by Josh Paetzel almost 3 years ago

  • Related to Bug #18903: consolidate the ix-* rc.d scripts added

#4 Updated by Josh Paetzel almost 3 years ago

  • Status changed from Investigation to Closed: Duplicate
  • Target version set to 9.10.2

I saw that and fixed it the other day. Thanks for the report, it will be in the next FreeNAS release.

Also available in: Atom PDF