I install memsql into Linux VM RH7 with version 7.3.7.
I run into problem in creating database - It will complaint
Available disk space is below the value of ‘minimal_disk_space’ global variable (100 MB). This query cannot be executed.
I am sure that my space on /var/lib/memsql is more than enough
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/rootvg-memsqlvol 5.0G 141M 4.9G 3% /var/lib/memsql
select @@datadir ;
/var/lib/memsql/6c00b88b-122f-49b0-86d9-c0d361791b45/data
Tracelog show the below
1801202593 2021-04-20 16:54:32.356 ERROR: Thread 114996: CreateFileAndAllocateSpace: Failed to allocate space for file logs/nex_19_staging
: 28 (No space left on device).
Does anyone run into similar issue?
hanson
April 20, 2021, 9:46pm
2
This post says to check the paths for tracelogs and plan cache as well:
ERROR 1772 ER_DISTRIBUTED_PARTITION_MOVE_FAILED: CREATE PARTITION DATABASE for operation CREATE DATABASE failed with error 1883:Leaf Error (172.31.46.158:3306): Available disk space is below the value of ‘minimal_disk_space’ global variable (100 MB). This query cannot be executed.
I have 13GB free on each node (5).
/opt/memsql-server-7.1.8-43a12901be$ df -kh
Filesystem Size Used Avail Use% Mounted on
udev 7.9G 0 7.9G 0% /dev
tmpfs 1.6G 784K 1.6G 1% /run …
Do those have enough space?
All those 3 paths are under /var/lib/memsql. Should have more than enough space.
/var/lib/memsql/6c00b88b-122f-49b0-86d9-c0d361791b45/data
/var/lib/memsql/6c00b88b-122f-49b0-86d9-c0d361791b45/plancache
/var/lib/memsql/6c00b88b-122f-49b0-86d9-c0d361791b45/tracelogs
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/rootvg-memsqlvol 5.0G 141M 4.9G 3% /var/lib/memsql
nhoran
April 21, 2021, 10:24pm
4
As this is a VM, what type of disk allocation are you using?
Thin provisioning might be causing this problem.
This is thick provision disk. I am sure datastore level has more than enough space.