| Re: USENET sync breaks and goes into endless cycle when it encounters attachment [message #158303 is a reply to message #158302] |
Mon, 16 February 2009 03:18   |
kerryg
Messages: 157
Registered: September 2008
Karma:
|
Senior Member |
|
|
Just an update - nearly 25,000 USENET posts brought across now out of over 45,000 and still working. Once it makes it all the way through, I'm considering deleting the forum and reloading the whole thing from scratch.
I've got it set to import 100 messages at a time. It still chokes on the occasional post (it's happened a few times) and cycles back and duplicates the previous posts. At that point I stop sync, go back, manually clear out any duplicates, set maximum import to 1 post and restart sync. Eventually it chews past the problem post and at that point I boot it back up to 100 (since even at 100 posts per sync it requires constant watching for eight hours to sync the forums, do you think there's a memory setting or a timeout that I can increase that might help it pull this sync off reliably at 100 posts all the way through?)
Here's one of the posts it choked on:
Importing IDEA.EMUEnsoniqPARIS message 189955
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kerrygal/FUDforum/include/theme/default/db.inc on line 27
(/home/kerrygal/FUDforum/include/theme/default/db.inc:72<br />
/home/kerrygal/FUDforum/include/theme/default/db.inc:132<br />
/home/kerrygal/FUDforum/include/scripts_common.inc:15<br />
/home/kerrygal/FUDforum/include/nntp.inc:416<br />
/home/kerrygal/FUDforum/scripts/nntp.php:92<br />
) 2006: MySQL server has gone away<br />
Query: SELECT id FROM fud26_users WHERE email='musurgio(at)otenet(dot)gr'<br />
Server Version: <br />
However - I'd have to say that even having to nursemaid the sync along like this represents an *enormous* step forward for this situation. Way to go, Frank!
[Updated on: Mon, 16 February 2009 03:19] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]