Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
2021-1, 2021-2, 2021-3, 2021-4
Description
ColumnStore logs are located in /tmp, /var/lib/columnstore/data/bulk/log, /var/log/mariadb/columnstore, etc. cmapi doesn't even have a log file. You have to use the journalctl utility. Can this be simplified and standardized into one location for all processes.
Additionally, when using cpimport the .bad file does not get written to any folder. It instead throws a 'permissions' error into the job log.
WORKAROUND FOR MISSING .bad FILES:
set the variable "WorkingDIrectory" in /usr/lib/systemd/system/mcs-writeengineserver.service
[Service]
Type=forking
WorkingDirectory=/home/mysql/
make sure the user running the writeengineserver process (mysql default) has write access to this directory
this is just going to have a file temporarily while cpimport.bin creates and sends the data for the bad file to cpimport on PM1
after updating the file restart WES process with
systemctl daemon-reload
systemctl restart mcs-writeengineserver.service