📋

Description

This error indicates that you attempted to rename a MariaDB event using the `ALTER EVENT ... RENAME TO` statement, but specified the exact same name for both the existing event and the new event. MariaDB requires the old and new event names to be distinct when performing a rename operation.

💬

Error Message

Same old and new event name

🔍

Known Causes

3 known causes

⚠️

Accidental Duplicate Name

You inadvertently provided the current event's name as the target name in the `RENAME TO` clause, attempting to rename an event to itself.

⚠️

Misunderstanding RENAME TO Syntax

The `ALTER EVENT ... RENAME TO` statement was used without realizing that the new event name must be different from the event's current name.

⚠️

Copy-Paste Error

When modifying an existing SQL script, the `RENAME TO` clause was copied but the new event name was not updated to be distinct from the original.

🛠️

Solutions

2 solutions available

1. Verify and Correct the Event Name easy

Ensure the new event name is different from the old one.

1

Review the `ALTER EVENT` statement you are trying to execute. The error message 'Same old and new event name' indicates that the specified new name for the event is identical to its current name.

2

Identify the event you are attempting to modify and its current name. You can list all events using the following command:

SHOW EVENTS;

3

If the event exists and you intended to rename it, provide a *different* name in your `ALTER EVENT` statement. For example, if the event is currently named `old_event_name` and you want to rename it to `new_event_name`, the statement should look like this:

ALTER EVENT old_event_name RENAME TO new_event_name;

4

If you did not intend to rename the event but to alter its definition, use the `ALTER EVENT` statement without the `RENAME TO` clause and specify the desired changes. For instance, to change the schedule:

ALTER EVENT event_name ON SCHEDULE EVERY 1 HOUR STARTS CURRENT_TIMESTAMP + INTERVAL 5 MINUTE;

2. Drop and Recreate the Event medium

Remove the existing event and create it again with the desired name and definition.

1

Identify the name of the event you are trying to alter. You can list all events using:

SHOW EVENTS;

2

If the event name is indeed the same as intended, and you are facing this error due to a misunderstanding or a script issue, the safest approach is to drop the event and recreate it with the correct name and definition. First, get the `CREATE EVENT` statement for the existing event. You can often find this in your historical scripts or by examining the event's definition.

3

Execute the `DROP EVENT` statement for the event.

DROP EVENT IF EXISTS event_name;

4

Recreate the event using the `CREATE EVENT` syntax, ensuring the new name is different and the definition is as desired.

CREATE EVENT new_event_name
ON SCHEDULE EVERY 1 DAY
STARTS CURRENT_TIMESTAMP + INTERVAL 1 HOUR
DO
  -- Your SQL statement(s) here
  SELECT 1;

🔗

Related Errors

5 related errors

MariaDB Error 1551: Altering Event Name Conflict