Description of problem:

Issue: It is a bug with mysql 5.0.45. http://bugs.mysql.com/bug.php?id=24989

Summary: Two concurrent transactions which update same table, the second
transaction consistently gives the following error
message.

ERROR 1422 (HY000): Explicit or implicit commit is not allowed in stored
function or trigger.

Status: I recreated the issue using the same version of mysql and mysql-server
in a RHEL 5 64 bit machine.

Procedure:

1) #yum install mysql; yum install mysql-server
2) downloaded 24989.tar.gz  from http://bugs.mysql.com/bug.php?id=24989
3) created a database 'rob'
4) #mysql -u root -p rob < schema.sql
5) opened mysql in two terminals (T1 and T2)
6) in T1 mysql> START TRANSACTION;
7) in T1 mysql> INSERT INTO data_staging (sensor_id, timestamp, value) VALUES
(1, NOW() + INTERVAL FLOOR(RAND() * 10000) MINUTE, 1);
8) in t1 mysql> SELECT sleep(10);


9) in T2 mysql> INSERT INTO data_staging (sensor_id, timestamp, value) VALUES
(1, NOW() + INTERVAL FLOOR(RAND() * 10000) MINUTE, 1);

10) in T1 mysql> INSERT INTO data_staging (sensor_id, timestamp, value) VALUES
(1, NOW() + INTERVAL FLOOR(RAND() * 10000) MINUTE, 1);

11) in T2 ERROR 1422 (HY000): Explicit or implicit commit is not allowed in
stored function or trigger.

How reproducible:

Always

Steps to Reproduce:

Check the problem description

Actual results:

ERROR 1422 (HY000): Explicit or implicit commit is not allowed in stored
function or trigger

Expected results:


Additional info:

MySQL server packages

mysql-5.0.45-7.el5
mysql-server-5.0.45-7.el5
mysql-5.0.45-7.el5