11.2.1.10 Asynchronous Task Limitations

• Asynchronous tasks run as MySQL Events on the server. Therefore, only those specific SQL operations that are supported inside events are supported for creating asynchronous tasks.

• Any SQL operation that depends on the return value of the SESSION_USER() or USER() function might behave differently when run asynchronously. This is because MySQL Events are executed by a reserved internal user called event_scheduler, and the SESSION_USER() and USER() functions return the value event_scheduler instead of the actual session user name.

• When an asynchronous task attempts to obtain a lock on a database resource, but it unable to get it as another transaction holds a conflicting lock, an error is generated and the following message is displayed: Cannot acquire lock. Try again later.