Off the top of my head, is it an SQL locking issue?
If the cron "reader" some how locked an SQL record, would the main app
stall?
just a thought
tc
On Mon, 2010-05-03 at 18:18 -0400, Steve Weigold wrote:
>
>
>
> >
> >
>
> Good Evening Everyone,
>
> I have an application running continuously on a TS-7200 which collects
> data received on /dev/ttyAM1, parses it to a small degree and stores
> it to a MySQL database on the device. I have the communications port
> set up as non-blocking, and just poll the port with "read" to retrieve
> data. Under normal circumstances, everything works fine.
>
> I have another application which is called as a cron job every five
> minutes. That application queries the data from the local database
> and synchronizes it with a database on a remote MySQL server. The
> sync application outputs only to a file and to the remote database.
> It currently has no interaction between the first app, or any of the
> comm ports.
>
> The problem I'm finding is that every five minutes when the cron job
> runs, something is causing the incoming data to essentially stop.
> Nothing appears to recorded by the first application during the time
> that the sync application is busy.
>
> To the best of my ability to search, the comm ports are set correctly,
> and as I said, the data collection application runs fine by itself.
>
> Can anyone make some suggestions on where to go from here? Even if
> the sync application caused the collection app to pause, I would have
> expected the data to accumulate in the serial port buffer and be
> available when the collection app resumed, but it does not. It just
> seems to vanish.
>
> I'd appreciate any suggestions.
>
> Steve
>
>
>
>
>
>
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ts-7000/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ts-7000/join
(Yahoo! ID required)
<*> To change settings via email:
<*> To unsubscribe from this group, send an email to:
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|