我们在MariaDB中有一个存储过程，它在服务器上运行良好，但是当我们从客户端使用JDBC运行它时，我们得到了第一行，但后来它总是失败：

unexpected end of stream, read 0 bytes from 4 (socket was closed by server)

表loan_balances2不是太大，大约600 K行。这是存储过程，您看到任何问题了吗？谢谢！

CREATE PROCEDURE `get_loan_balances_sample`()

BEGIN

drop table if exists all_loan_ids;
drop table if exists random_loan_ids;

create table all_loan_ids as select distinct loan_id from loan_balances2;
create table random_loan_ids as select * from all_loan_ids order by RAND() limit 50;

SELECT * FROM loan_balances2
where loan_id in (select Loan_ID from random_loan_ids)
order by Loan_ID, balance_date;

END