AW: select fails to find updates of from other connections

AW: select fails to find updates of from other connections

am 16.11.2009 21:32:55 von Gisbert.Selke

Hi Bob --

> -----Ursprüngliche Nachricht-----
> Von: Bob McGowan [mailto:bob_mcgowan@symantec.com]=20
> Gesendet: Samstag, 14. November 2009 01:04
> I'm having trouble with retrieving data from mySQL, where the=20
> update or create was done by another application connection=20
> and happened while my Perl DBI/DBD connection was active.
>=20
> If I disconnect/reconnect to the server, I can see the changes.
>=20
> Is this expected behavior? Or is there some parameter that=20
> I'm missing? Neither the standard 'mysql' client nor the=20
> Bugzilla GUI seem to have this problem.
I'm not sure whether this answers your question, since you just said you =
have trouble (but not, which trouble): have you tried to fiddle with the =
connection parameter mysql_use_result (as per the DBD::mysql docs)? If =
set to false (the default), the result set for some select that you do =
may just be buffered locally.=20
Alternatively, are you connecting to a transactional table, and may the =
transaction still be in progress? Are you doing your select in a loop =
for contunuous updating, or how do you control whether the external =
table update is somewhere between your selects? Given the current lot of =
information, it is hard to tell.

\Gisbert

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org