Correct, the ColumnStore Product doesn't do the transactional logs that was done on the older Product of InfiniDB. The script still remain, but the functionality was disabled.

Customer reported that the cron job is still being setup on his pm2 server.

There is 1 spot in the code that needs to be removed or commented out since this functionality is degraded

/home/dhill/mariadb-columnstore-server/mariadb-columnstore-engine/procmon/processmonitor.cpp

case OAMPARENTACTIVE: line 1648

setTransactionLog(true); line 1656

Customers comments:

Hi, I noticed the the bit about the transactionLogArchiver.sh script, MCOL-871, that was very old and is not used on columnstore. However, for some reason this script has been running as a cron every 10 minutes since our initial install, but ONLY on 1 of our 4 servers, PM2. We are not really sure how this cron would have been installed and running this whole time? We only noticed through emails from root.

Mail to root:
Subject: Cron <root@usfit-scdb7> /usr/local/mariadb/columnstore/bin/transactionLogArchiver.sh

Installation error: /var/log/mariadb/columnstore/data/archive is not a directory.

Output from the /etc/cron.d:

[root@usfit-scdb7 cron.d]# cat transactionLog
#

1. Calpont version with Daily running at midnight
   #

SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/

1. Translation Log Archiver, default to every 10 minutes
   */10 * * * * root /usr/local/mariadb/columnstore/bin/transactionLogArchiver.sh

This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket.