MariaDB - Unable to select the specified database: xxxx - after running a stored routine -
i'm using mariadb 10.1.21 installed on ubuntu 16.4.0 , apache2 installed on same machine.
my problem while, after run procedure makes many inserts, error unable select specified database: xxxx
we changed both hdd ssd, eliminate suspicions latency. however, if server's speed has been increased, .. still mariadb error.
i mention error persists seconds. after that, web application running ok , error may reapers time time until restart mysql server.
the procedure body looks here: mysql insert table select another_table, inside procedure
any sugestion?
wherever possible, avoid using cursors
. sql designed things in bulk, not 1 row @ time.
study constructs like
insert ... select ...; create table ... select ...;
Comments
Post a Comment