for note (to everyone) the error is a genaric MySQL error related to the size of the partition where /tmp is located and the temporary file being generated by the mysql server in conjunction with the xml document generation... (which should be solved by either increasing the partition's size or utilizing the offsets feature to pull X amount of records per page and by using the sitemap index feature)
