My Oracle Support Banner

8.0.19+ ERROR 1022 (23000): Can't Write; Duplicate Key In Table Or ERROR 1062 (23000): Duplicate entry 'NULL' for key (Doc ID 2729447.1)

Last updated on NOVEMBER 24, 2020

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

Certain queries fail with error:

ERROR 1022 (23000): Can't write; duplicate key in table '/tmp/#sql3356b_8_2'

or

ERROR 1062 (23000): Duplicate entry 'NULL' for key '/tmp/#sql3356b_8_4.<group_key>'

Changes

 Queries were working fine before 8.0.19,  after which they started giving the error.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.