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 '%'.

But here's the really screwy part ::

If I add a record via the script 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 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-thread2007@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.

Re: phantom records

Thanks for your input. I'll try that suggertion.
I know that there's bound to beissues with local/remote server stuf but
thethingthat really gets me is that the
records are not it in the actual table but theremote script sees them fust
fine as if they were.

I was wondering if there is some kind of queue or something that remote
requests get put in that would cause the remote script to see records it
added but that havn't actually been put in the table yet.

Is there anything like that?

I'll see if I can't norrow it down and try script with just the code that is
acting oddly.
And go form there.



> It would be helpful to see a snippet of your code. I have had
> cross-server problems in the past and mostly they were related to
> environmental issues (time zone, user authorization, etc) but it is not
> a fixed rule.
>
> What I can suggest is to isolate the problem.
>
> Make a test script with the minimum code that reproduces the problem
> using a freshly made test database with a newly defined user.
> If this does not give you a clue on where the problem lies, then publish
> your test code with the test database info (either at msql-mysql-modules
> or in www.perlmonks.org and I recommend the latter) so that somebody can
> reproduce your problem and give you a hint.
>
> Good luck
>
> gmax
>
>
>
>
>
>


------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2009@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.

Re: phantom records

Thanks for your input. I'll try that suggertion.
I know that there's bound to beissues with local/remote server stuf but
thethingthat really gets me is that the
records are not it in the actual table but theremote script sees them fust
fine as if they were.

I was wondering if there is some kind of queue or something that remote
requests get put in that would cause the remote script to see records it
added but that havn't actually been put in the table yet.

Is there anything like that?

I'll see if I can't norrow it down and try script with just the code that is
acting oddly.
And go form there.



> It would be helpful to see a snippet of your code. I have had
> cross-server problems in the past and mostly they were related to
> environmental issues (time zone, user authorization, etc) but it is not
> a fixed rule.
>
> What I can suggest is to isolate the problem.
>
> Make a test script with the minimum code that reproduces the problem
> using a freshly made test database with a newly defined user.
> If this does not give you a clue on where the problem lies, then publish
> your test code with the test database info (either at msql-mysql-modules
> or in www.perlmonks.org and I recommend the latter) so that somebody can
> reproduce your problem and give you a hint.
>
> Good luck
>
> gmax
>
>
>
>
>
>


------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2009@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.