The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Why is this create table statement failing?

Hi:

When I tried to create a table:

CREATE TABLE pt_lang ( meddra_version_no VARCHAR(6) NOT NULL, pt_id BIGINT NOT NULL, language_code VARCHAR(100) NOT NULL, pt VARCHAR(200) NOT NULL, update_user_id VARCHAR(100) NOT NULL, update_timestamp TIMESTAMP NOT NULL DEFAULT now(), CONSTRAINT xpkpt_lang PRIMARY KEY (meddra_version_no,language_code,pt_id), CONSTRAINT R_54 FOREIGN KEY (meddra_version_no, language_code) REFERENCES meddra_version_lang (meddra_version_no, language_code), CONSTRAINT R_55 FOREIGN KEY (meddra_version_no, pt_id) REFERENCES pt (meddra_version_no, pt_id) )

I get the following error message.

[ma-3.1.3][10.4.6-MariaDB]Can't create table `meddra`.`pt_lang` (errno: 121 "Duplicate key on write or update") Execution Failed!

Can someone tell me what I am doing wrong?

Answer Answered by Ian Gilfillan in this comment.

What is the definition of the other tables you're referencing?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.