Hi Maxwake,
Switching servers changed everything for me. WPallimport and so much else works fantastic now. My old server is very well known and respected (rhymes with ‘fomfast susiness glass’) but simply couldn’t handle wordpress well.
I was having the same problem and it was very frustrating. I received the same error consistently and kept lowering the records (all the way down to “1”). It ran very slowly and would stop and I’d have to rerun it again and again.
I’d cut the csv’s in half over and over and it would take DAYS for one import which meant WEEKS for multiple imports.
Then I switched to a wordpress optimized server – EVERYTHING CHANGED. Imports are a breeze. What took days before takes less than half an hour now – no joke. Unrelated frustrations vanished as well.
I really hope this message will help others experiencing these difficulties.
So, to anyone reading, make sure your server is optimized for wordpress. Things get so much better with the right host, not just wpallimport, so much more.