Well, I managed to change the machine setup to single processor, and the problems persists.
So I installed mySQL on the client machine, and used it instead of the one on the Linux machine on the network. It works fine - no problems - just like the system at home. So it isn't a dual-core or memory issue after all, but a network issue. Talked to the guy that looks after the network, and he mentioned that he too had been having a problem backing up files from one Linux machine to another - the target machine being the same one the mySQL server is on. It turns out that this machine is on the other side of a LinkSys router - he suspects that may be my problem. He is going to replace the router when he gets a chance. Oh well ... At 10:23 AM 2007-02-17 -0500, you wrote: >I've a problem I THINK might be a dual-core issue. I've read the "buffer >overrun" threads. > >Environment: A new dual-core 2 gig machine at a client site. Runs Win2K >SP4, and VFP9 SP1. > >I converted an application from VFP tables to mySQL, and have a VFP utility >that loads the mySQL tables from the VFP tables to get things started. Uses >SQL passthough. Uses the mySQL ODBC 3.51 driver. > >I have no problems at all on my development machine; there are no problems >if I run the upload on another machine on the network at the client site. > >However, on the dual-core machine, the SQL INSERTs that I use to load the >tables fail sometimes with SQL SYNTAX errors. mySQL complains about there >being an error in the SQL statement, and the error message it sends back >shows a corrupted INSERT statement. It does not happen on the same record >each time - it is random. And if I simply re-issue the INSERT, it works. I >modified the program to do retries, and I can upload the tables this way. >On a 15000 record table, I might get 30 errors that work when retried. > >I did some other tests - I created a remote view, and then updated the >table this way - no problems - perhaps VFP is doing retries. > >I am limiting memory via SYS(3050) to around 24 meg, just as a test. > >On ONE occasion I got the dreaded "Buffer overrun" message from the C >library. I also got this message once on my home machine. However, both >machines are running SP1, which supposedly fixes this error. > >Any thoughts? Is it possible to disable part of a dual-core machine via the >BIOS? (This is an ACER machine, which I think uses an AMD chip set). That >would be the proof. > >Thoughts, anyone? I have no idea on how to solve this one. > >Many thanks > >Larry Bradley >Orleans (Ottawa), Ontario, CANADA > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
