The mandrel of the rivet has been completely pulled out. Is it qualified to leave a penetrating hole in the rivet body after riveting?

Unqualified, it belongs to the failure of riveting. As described above, the rivet at this time has no function of rivet, but only acts as a pin.