No, with the default transaction isolation level, REPEATABLE READ,
that's how it is supposed to work. You've started a transaction in
Window B, so Window B is immune to changes made in Window A until you
finish the transaction in Window B. See the manual for details
David Griffiths wrote:
No, with the default transaction isolation level, REPEATABLE READ,
that's how it is supposed to work. You've started a transaction in
Window B, so Window B is immune to changes made in Window A until you
finish the transaction in Window B. See the manual for details
I believe you - I'm just a but surprised. I guess I had a singular view
of how a session should work based on Oracle. I would have expected that
until you execute SQL that requires a commit or a rollback, you wouldn't
be in a transaction. Unfortunately, if you have connections that are
read
If you are NOT in autocommit mode, your connection (or the server, it
doesn't matter which) starts a transaction *when you issue your first
command*. Every command you issue on that connection is in that initial
transaction until you EXPLICITLY commit or rollback (or do something else
that
Yah, I tested in SQL*Plus - one window could see inserts, updates and
deletes that had been committed in another window (in which a commit or
rollback had not been issued). I ran the test again - delete data from a
table in one window and commit the change, and a select in the other
window
I just discovered some weird behaviour with MySQL 4.0 (4.0.24 and
4.0.18) using InnoDB.
If you have two connections to mysql (I use the mysql client), one of
which has autocommit turned on, an the other turned off, a row deleted
from the client with autocommit turned on still shows up in the
David Griffiths wrote:
I just discovered some weird behaviour with MySQL 4.0 (4.0.24 and
4.0.18) using InnoDB.
If you have two connections to mysql (I use the mysql client), one of
which has autocommit turned on, an the other turned off, a row deleted
from the client with autocommit turned
On Wed, Aug 31, 2005 at 11:18:40PM -0400, Michael Stassen wrote:
No, with the default transaction isolation level, REPEATABLE READ, that's
how it is supposed to work. You've started a transaction in Window B, so
Window B is immune to changes made in Window A until you finish the
Geoffrey, Chris,
- Original Message -
From: Chris [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, May 01, 2005 5:26 AM
Subject: Re: Disappearing .frm files ?
Geoffrey R. Thompson wrote:
...
Things have been fine until recently, when the .frm files for these tables
I posted a few days ago, but didn't get any responses. I'm hopeful someone
has seen this, and can offer advice.
We recently converted some tables from MyISAM to InnoDB because the need had
arisen for transactional support.
Things have been fine until recently, when the .frm files for
Geoffrey R. Thompson wrote:
...
Things have been fine until recently, when the .frm files for these tables
mysteriously disappeared from the mysql data directory (even though the
underlying data for the tables was still intact in the separate InnoDB data
file).
...
As far as I'm aware InnoDB
file), so we
copied the .frm files from that database's data directory over, and once we
did this, the tables re-appeared, complete with the correct data that had
been originally loaded into these tables prior to their disappearing. So,
it appears that while the data file was fine, the .frm files
not, and I should be. It not the cause of my data disappearing problem
because my test data was safe, but I shouldn't assume that customer-entered
data will be safe. Thanks for the reminder.
A nasty is case sensitivity. Some MYSQl vers. (esp. unix vers.) install
with case sensivity turned on - so
-Original Message-
From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED]
Sent: maandag 31 januari 2005 14:44
To: 'leegold'; mysql@lists.mysql.com
Subject: RE: disappearing data - please help!
Par down the PHP or what ever script you're using to the minimum
ie. make
Sheryl Canter wrote:
I've got a weird problem that's driving me nuts. I'm updating a set of
scripts for a customer database that supports sending out software
registration codes in real time. I've had this working for some time now,
but I'm having the most frustrating problem. Data I've inserted
I've got a weird problem that's driving me nuts. I'm updating a set of
scripts for a customer database that supports sending out software
registration codes in real time. I've had this working for some time now,
but I'm having the most frustrating problem. Data I've inserted simply
VANISHES.
I've got a weird problem that's driving me nuts. I'm updating a set of
scripts for a customer database that supports sending out software
registration codes in real time. I've had this working for some time now,
but I'm having the most frustrating problem. Data I've inserted simply
VANISHES.
I've
On Sun, Jan 30, 2005 at 03:28:56PM -0500, Sheryl (Permutations Software) wrote:
but I'm having the most frustrating problem. Data I've inserted simply
VANISHES.
What is the setting for AutoCommit? If it is 0, are you sure
that commit is being called before the session ends?
-Jason Martin
--
-
From: Jason Martin [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 30, 2005 3:38 PM
To: mysql@lists.mysql.com
Subject: Re: disappearing data - please help!
On Sun, Jan 30, 2005 at 03:28:56PM -0500, Sheryl (Permutations Software)
wrote:
but I'm having the most frustrating problem. Data I've
On Sun, Jan 30, 2005 at 04:03:37PM -0500, Sheryl (Permutations Software) wrote:
transactions. It's just the default. I don't know where I'd check AutoCommit
settings (or it they even apply to the default database type). It doesn't
refer to this in phpinfo.php.
Try doing this immediately after
-Original Message-
From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED]
Sent: zondag 30 januari 2005 21:31
To: mysql@lists.mysql.com
Subject: disappearing data - please help!
What makes this all the more mysterious is that it happens
intermittently. Sometimes when
From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED]
Sent: zondag 30 januari 2005 21:31
To: mysql@lists.mysql.com
Subject: disappearing data - please help!
What makes this all the more mysterious is that it happens
intermittently. Sometimes when the script completes
Hi, I have a strange problem with priviledges.
They just stop working. The tables have the data in them. But they don't work.
So I do another GRANT
And then they work fine, until the next day (not sure about the timing) when
they have to be GRANT'ed all over again.
There doesn't seem to
I have a mysql table that I refer to a lot and needs to be quick. I set
it as a HEAP table because of the speed (and HEAP tales ARE fast. zip
baaannn). Anyway, whenever I restart the server the contents of
the heap tables disappear! What the hell? But I read the manual and it
seems
Store it in another table and have a start up script that creates a heap
once the server is started ?
Jerry
- Original Message -
From: Steve Quezadas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 7:41 PM
Subject: heap tables keep on disappearing!
I have
Subject: heap tables keep on disappearing!
I have a mysql table that I refer to a lot and needs to be quick. I set
it as a HEAP table because of the speed (and HEAP tales ARE fast. zip
baaannn). Anyway, whenever I restart the server the contents of
the heap tables disappear! What
At 11:41 -0800 3/6/03, Steve Quezadas wrote:
I have a mysql table that I refer to a lot and needs to be quick. I
set it as a HEAP table because of the speed (and HEAP tales ARE
fast. zip baaannn). Anyway, whenever I restart the server
the contents of the heap tables disappear! What the
Hello,
I have a problem that I could use some help with. We're running a
mysql/php intranet site for time sheets (home grown solution). However
from time to time a user will tell me hours from the previous week are
just gone. I go to look and sure enough, no hours have been entered. I
have not
In the last episode (Nov 18), Greg Macek said:
Hello,
I have a problem that I could use some help with. We're running a
mysql/php intranet site for time sheets (home grown solution). However
from time to time a user will tell me hours from the previous week are
just gone. I go to look and
That's the weird part of it. Last week in reviewing the system, making
sure reports were working I can personally verify his stuff was in there
(not even logged on as him). This week: nothing. Is there any record of
3.23.49 ever having random data loss issues? Related to something else
on the
In the last episode (Nov 18), Greg Macek said:
That's the weird part of it. Last week in reviewing the system,
making sure reports were working I can personally verify his stuff
was in there (not even logged on as him). This week: nothing. Is
there any record of 3.23.49 ever having random data
I'll look into the code on the PHP side (since I wrote that too). Maybe
it is something I did. :)
I may avoid repairing the tables for now, since the missing records have
already been re-entered and I don't want to risk anything being
duplicated at this point. Perhaps I'll drop all the indexes
Greg Macek said..
---
I have a problem that I could use some help with. We're running a
mysql/php intranet site for time sheets (home grown solution). However from
time to time a user will tell me hours from the previous week are just
gone. I go to look and sure
Greg Macek wrote:
That's the weird part of it. Last week in reviewing the system, making
sure reports were working I can personally verify his stuff was in there
(not even logged on as him). This week: nothing. Is there any record of
3.23.49 ever having random data loss issues? Related to
To: [EMAIL PROTECTED]
Subject: HELP - MYSQL databases disappearing!
Importance: High
Does anyone know why a MYSQL database would just disappear and how I might
prevent it from happening in the future? I run it on win2k advanced server.
Much obliged,
Mike Taffi
Hi Everyone,
I am in kind of a jam, and I could use some help. Hopefully someone out
there has encountered something similar to this. I have a MySQL database,
and I am using Java to make the connection to the database. At one point in
the execution of my app, I need to issue an ALTER TABLE
At 23:05 -0500 3/14/02, Chris Stark wrote:
Hi Everyone,
I am in kind of a jam, and I could use some help. Hopefully someone out
there has encountered something similar to this. I have a MySQL database,
and I am using Java to make the connection to the database. At one point in
the execution
Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 11:49 PM
To: Chris Stark; [EMAIL PROTECTED]
Subject: Re: Disappearing of New Inserts to MyISAM table
At 23:05 -0500 3/14/02, Chris Stark wrote:
Hi Everyone,
I am in kind of a jam, and I could use some help
Hi,
I'm having a very annoying and elusive problem. You probably won't be able
to help me, but any guess or pointer would be appreciated nonetheless.
The main table in the db contains some 50 fields, mostly of type varchar
and tinyint. This table is updated through php.
Now the problem is:
Hi
On Monday 09 April 2001 05:34, Jack A. Tinsley Jr. wrote:
First, things, first - I am a newbie to MySQL but I have it up and running
quite well. The only thing I haven't been able to figure out is why I'm
losing "\" (back slashes) in my stored data. I have a application I'm
considering
u're using PHP (http://php.net), or looking at some regular expressions
for perl in order to format strings for database insertion.
Ben
-Original Message-
From: John Dean [mailto:[EMAIL PROTECTED]]
Sent: 09 April 2001 08:25
To: Jack A. Tinsley Jr.; [EMAIL PROTECTED]
Subject: Re: Disappearing &q
First, things, first - I am a newbie to MySQL but I have it up and running quite well.
The only thing I haven't been able to figure out is why I'm losing "\" (back slashes)
in my stored data. I have a application I'm considering MySQL for and one table must
have a column containing a UNC
On Sun, Apr 08, 2001 at 10:34:17PM -0600, Jack A. Tinsley Jr. wrote:
First, things, first - I am a newbie to MySQL but I have it up and
running quite well. The only thing I haven't been able to figure
out is why I'm losing "\" (back slashes) in my stored data. I have
a application I'm
You need to escape it with another "\". Look up the manual about escaping
special chars.
- Original Message -
From: "Jack A. Tinsley Jr." [EMAIL PROTECTED]
To: "[EMAIL PROTECTED]" [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 12:34
Subject: Disappearing &
On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote:
I couldn't fine this mentioned in the archives, so I hope someone has seen
this before:
I'm running into a situation wherein /tmp/mysql.sock keeps disspearing.
There is still server process (sleeping), and there is still a
I couldn't fine this mentioned in the archives, so I hope someone has seen
this before:
I'm running into a situation wherein /tmp/mysql.sock keeps disspearing.
There is still server process (sleeping), and there is still a pidfile.
This can happen after ten or fifteen minutes of queries.
I
On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote:
I couldn't fine this mentioned in the archives, so I hope someone has seen
this before:
I'm running into a situation wherein /tmp/mysql.sock keeps disspearing.
There is still server process (sleeping), and there is still a
On Tue, Feb 13, 2001 at 08:35:44PM +0100, Fred van Engen wrote:
I've seen it after installing two versions of MySQL on one server.
I forgot to set another location for the second MySQL process
before starting it with /bin/safe_mysqld. The result was that the
socket was removed by the second
On Wed, Feb 14, 2001 at 09:03:16AM +0800, Rolf Hopkins wrote:
Do you have a cron job that's cleaning up your socket file along with
whatever other garbage it's cleaning up?
Nope. As I said in my original mail:
I don't have a cronjob, or any other external process that scrubs /tmp.
I'm
49 matches
Mail list logo