phantom records

Hello list,

I have a very strange problem. I've looked everywhere I can think of for a
reference to this and have failed.

Here's what I have :

A perl script that uses DBI to interact with a table.
It has a menu to select records that gets generated dynamically each time
the script is loaded.

If the script and database are on the same server it works perfect. ( on
both servers involved in this deal )

If the script and database are on different servers, ( one linux //one
freebsd // both perl 5.)
it will not update the table.

DBI errstr gets printed to the screen if there's a problem but it runs
through no problem as if all is well.

The only thing I've changed is the host from 'localhost' to the ip address
of the remote server.
The user has privilges on 'localhost' and '%'.

There is no database or user of the same name on the servers.

But here's the really screwy part ::

If I add a record via the script (on server2) it shows up in the menu ( the
one that gets
generated from all of the records on the table )
But it is not in the table if I ssh to the server (server 1) and check.

On the server itself the last record's id stops at 115. That's when I moved
the script to a different server.
On the menu that is on the remote script it has all of those plus 116 - 119
( 119 is where I noticed there were no new records in the table )
as if the new ones were in the table but they are not.

What could I have done/missed that would cause the table to not actaully
have records 116-119 ( select ID from supp_site_tickets; 1-115)
but have them show up in a menu generated by another SELECT statement, and a
more complex one at that (select ID form supp _site_tickets WHERE...)?

It's been about two hours since I added those records and they still havn't
shown up if that helps diagnos any problems.

Thanks for your input I appreciate it so much.

Thanks,

Dan



------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2008@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.