Data in Table Is Different When Seen From Different Sources
am 26.01.2011 22:14:46 von Hal VaughanI'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 =3D `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 |=20
| alpha | two | 1 | searching | 201 | -1 | =
-1 | 2011-0126-160115 | 12331 |=20
=
+--------+--------+-------+-----------+----------+---------- --+-----------=
--+------------------+-------+
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 |=20
| alpha | two | 1 | searching | 201 | -1 | =
-1 | 2011-0126-160115 | 12331 |=20
=
+--------+--------+-------+-----------+----------+---------- --+-----------=
--+------------------+-------+
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 |=20
| alpha | two | 1 | searching | 201 | -1 | =
-1 | 2011-0126-155545 | 12289 |=20
=
+--------+--------+-------+-----------+----------+---------- --+-----------=
--+------------------+-------+
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=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg