Failed to parse file /sys/fs/cgroup/cpu,cpuacct/system.slice/memsql.service//cpu.cfs_period_us on line 104

1

I’m getting this error when trying to query the information_schema. Is there any solution for this?

2

The file is there in all the servers: cat /sys/fs/cgroup/cpu,cpuacct/system.slice/memsql.service/cpu.cfs_period_us
100000

3

I’m not familiar with this error, but (1) consider checking the file to make sure it is readable by all users (& use chmod to make it readable otherwise), (2) please post your SingleStore version number here, and if you did any recent upgrades.

4

Can you please let us know your current SingleStore version? please execute select @@memsql_version;

Also, Kindly share the output of SELECT * FROM INFORMATION_SCHEMA.MV_SYSINFO_CPU;

5

@hanson1

memsql version is 7.6.5.

When I try to run this query: sELECT * FROM INFORMATION_SCHEMA.MV_SYSINFO_CPU

it retuns
SQL Error [2390] [HY000]: Leaf Error (memsql-new-01.dive.local:3306): Failed to parse file /sys/fs/cgroup/cpu,cpuacct/system.slice/memsql.service//cpu.cfs_period_us on line 104

(check the double // before CPU. I think that’s why it not founding the file but this changed recently. It was working before)

6

The issue has been fixed latest version of 8.7:

  • Bugfix: Fixed sporadic reading failures from MV_SYSINFO_CPU.

It is soon to be backported to 8.5. But we cannot backport to a lower version because they are already EOL.

1 Like