Error: Explicit or implicit commit is not allowed in stored function or trigger.

Problem:
The problem is that there is a implicit commit happening somewhere .

In my case it was due to
I used "Truncate table table_name" in a function.

or

it is due to "create index idx_name on table_name(column_name);"

Solution:
Instead TRUNCATE use "delete from table_name".

or

use this
"Create table table_name (column_name [data_type] ,
                         index [index_name] (column_name));"