ERROR 1210 (HY000): Incorrect arguments to DATA DIRECTORY

[Supriya Mayekar]

I have recently upgraded my database from 5.6 to 5.7 and then on 8.0.22.
On mysql 8,
when I am trying to add column in existing table, I am getting error as below.
ERROR 1210 (HY000): Incorrect arguments to DATA DIRECTORY

Innodb_file_per_table is ON.

Data directory in mysql is set properly.

acknowledges | CREATE TABLE `acknowledges` (
`acknowledgeid` bigint unsigned NOT NULL,
`userid` bigint unsigned NOT NULL,
`eventid` bigint unsigned NOT NULL,
`clock` int NOT NULL DEFAULT '0',
`message` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`acknowledgeid`),
KEY `acknowledges_1` (`userid`),
KEY `acknowledges_2` (`eventid`),
KEY `acknowledges_3` (`clock`),
CONSTRAINT `c_acknowledges_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `c_acknowledges_2` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `userid` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY='/data/mysql/' |


When I try to add additional column to above table, I am getting an error.

mysql> ALTER TABLE acknowledges ADD COLUMN action INT DEFAULT 0;
ERROR 1210 (HY000): Incorrect arguments to DATA DIRECTORY