insert_batch() not working completely

That's expected.

Check the MySQL documentation, you can define columns only once.

Code:

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);