|
Deploying a 3 node cluster today 23.02.3 then cpimporting test data in mode 3 on all nodes for about 1 hour, i noticed the .cdf files were created as root:root instead of mysql.
Creating ticket to review if reproducible and if a real bug or fluke.
-rw-r--r--. 1 root root 860160 Sep 12 15:38 /var/lib/columnstore/data1/000.dir/000.dir/011.dir/186.dir/000.dir/FILE001.cdf
|
this results in all future queries to fail because of permissions
Query:
[root@ip-172-31-27-127 dbrm]# mariadb mariadb_actixone_owner -e "select count(*) from LTE_ALL_MESH3_HOURLY;"
|
ERROR 1815 (HY000) at line 1: Internal error: An unexpected condition within the query caused an internal processing error within Columnstore. Please check the log files for more details. Additional Information: error in BatchPrimitivePro
|
Logs:
/var/log/messages
Sep 12 16:48:40 ip-172-31-27-127 PrimProc[75933]: 40.678907 |0|0|0| C 28 CAL0053: PrimProc could not open file for OID 3002; /var/lib/columnstore/data1/000.dir/000.dir/011.dir/186.dir/000.dir/FILE001.cdf:Operation not permitted
|
Sep 12 16:48:40 ip-172-31-27-127 PrimProc[75933]: 40.679253 |0|0|0| C 28 CAL0000: thr_popper: Error opening file for OID 3002; /var/lib/columnstore/data1/000.dir/000.dir/011.dir/186.dir/000.dir/FILE001.cdf; Operation not permitted %%10%%
|
Sep 12 16:48:45 ip-172-31-27-127 env[75933]: PrimProc[75933]: 45.680299 |0|0|0| C 28 CAL0053: PrimProc could not open file for OID 3002; /var/lib/columnstore/data1/000.dir/000.dir/011.dir/186.dir/000.dir/FILE001.cdf:Operation not permitted
|
Sep 12 16:48:45 ip-172-31-27-127 env[75933]: thr_popper: Error opening file for OID 3002; /var/lib/columnstore/data1/000.dir/000.dir/011.dir/186.dir/000.dir/FILE001.cdf; Operation not permitted
|
Work around (run on all nodes):
chown mysql:mysql -R /var/lib/columnstore/
|
After changing ownership, i can query the data fine
|