List:General Discussion« Previous MessageNext Message »
From:Hal Vaughan Date:January 26 2011 9:14pm
Subject:Data in Table Is Different When Seen From Different Sources
View as plain text  
I'm having the strangest issue.  I am using a Perl program to test out some other Perl
programs and all the Perl connections with MySQL are "normal", as in I use the standard
interface.  But in the test program I'm just using this:

$out = `mysql --table -e"SELECT * FROM search.Status"`;
print "$out\n";

as a quick and dirty way to check on the data tables while I'm working.  This test program
gives this output:

+--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+
| Source | Search | Stage | Status    | Resource | TotalItems | CurrentItem | CheckIn     
    | PID   |
+--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+
| alpha  | one    |     3 | waiting   |        1 |         -1 |          -1 |
2011-0126-160720 |     0 | 
| alpha  | two    |     1 | searching |      201 |         -1 |          -1 |
2011-0126-160115 | 12331 | 
+--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+

I have two items in the first row that are my concern, the first is in the column Status,
the 2nd is in the column PID.  These are updated.  Also, this program is a loop and after
it displayed this table, I locked the screen with "ctrl-q" (in a BASH shell using Konsole
on OS X with MacPorts).  (Also, this system is a VM, under parallels, on another Mac and
I'm using ssh to connect to that system to run all these commands.)

But when I go to the console where I've logged into MySQL and display this table, I get:

mysql> SELECT * FROM search.Status;
+--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+
| Source | Search | Stage | Status    | Resource | TotalItems | CurrentItem | CheckIn     
    | PID   |
+--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+
| alpha  | one    |     3 | searching |        1 |         -1 |          -1 |
2011-0126-160120 | 12336 | 
| alpha  | two    |     1 | searching |      201 |         -1 |          -1 |
2011-0126-160115 | 12331 | 
+--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+
2 rows in set (0.00 sec)

When I go to a command line and cut and paste the command from in the program, I get this:

hal@tnet-search:threshNet]$ mysql --table -e"SELECT * FROM search.Status"
+--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+
| Source | Search | Stage | Status    | Resource | TotalItems | CurrentItem | CheckIn     
    | PID   |
+--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+
| alpha  | one    |     3 | searching |        1 |         -1 |          -1 |
2011-0126-155546 | 12294 | 
| alpha  | two    |     1 | searching |      201 |         -1 |          -1 |
2011-0126-155545 | 12289 | 
+--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+


So I'm checking this data table from THREE sources, from within MySQL, from the command
line, and from within the Perl program.  How can I get different values in two cells in
the table?

Is there some kind of buffering along the way that could effect the output to the Perl
program?


Thanks for any ideas on this!



Hal
Thread
Data in Table Is Different When Seen From Different SourcesHal Vaughan26 Jan
Re: Data in Table Is Different When Seen From Different Sourcesmisiaq26 Jan
  • Re: Data in Table Is Different When Seen From Different SourcesHal Vaughan27 Jan