1467 Failed to read auto-increment value from storage engine, query was: INSERT INTO `catalog_category_product

When adding a new product through product import from admin then getting below error-

SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine, query was: INSERT INTO catalog_category_product (product_id,category_id,position) VALUES (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?) ON DUPLICATE KEY UPDATE product_id = VALUES(product_id), category_id = VALUES(category_id)