Hi,
I'd really appreciate help with reading this db deadlock notice.
Essentially, I'd like to understand:
-what holds the lock that TX2 is waiting on index `token` of table
`eviltwin/user_sessions`? I thought it'd be TX1 (hence deadlock ?), yet
it appears that TX1 holds no locks
Nikita Tovstoles [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Do both of your SELECT statements use the same index (`token`) when setting
locks on the rows? My guess is that the situation is as follows.
TX2: SELECT ... WHERE id = ... FOR UPDATE
TX2 sets an exclusive lock for a row
unscubcribe
-
Scanned for virus and spam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi. This is the qmail-send program at lists.mysql.com.
I'm afraid I wasn't able to deliver your message to the following
addresses.
This is a permanent error; I've given up. Sorry it didn't work out.
[EMAIL PROTECTED]:
Sorry, no mailbox here by that name. (#5.1.1)
--- Below this line is a copy
If anyone is having problems with corrupted files on Windows machines with
drives 137GB, the culprit is likely a copy of the Intel Accelerator
software if you happen to have it installed. The Intel Accelerator will
corrupt files when it writes to sectors beyond 137gb. Intel has an update
out
procs memoryswap io system
cpu
r b w swpd free buff cache si sobibo incs us
sy id
0 1 0 5232 93140 26732 3736888 0 0 157510 388 343 11
1 88
0 1 0 5232 88552 26748 3741348 0 0 892 6 327 269
That looks like a PHP problem to me. Have you tried mysql_fetch_assoc()? I
believe mysql_fetch_row() gets you an array with a numeric index (in which
case lastname would be in $line[0]).
Notice: Undefined index: lastname in E:\IIS Webs\index.php on line 29
?
PRINT HTML;
PRINT HEAD
dont forget mysql_fetch_object()
then you will have $line-lastname;
Maureen Roihl wrote:
That looks like a PHP problem to me. Have you tried mysql_fetch_assoc()? I
believe mysql_fetch_row() gets you an array with a numeric index (in which
case lastname would be in $line[0]).
Notice
);
}
else
{
...
}
-Original Message-
From: Maureen Roihl [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 7:49 AM
To: 'C. Reeve'; MySQL List
Subject: RE: Notice: Undefined index:
That looks like a PHP problem to me. Have you tried
Roihl'; 'C. Reeve'; MySQL List
Subject: RE: Notice: Undefined index:
It that does not work. You could try the following snippet:
if ($result = mysql_query ($query);)
{
while ($row = mysql_fetch_array ($result
Hi,
Anyone know why I would be receiving this error in Windows. I have a small
PHP script that accesses a MySQL database and prints out a couple lines.
This works fine in LinuxI have searched google and found many users with
the same problem, but not one solution.
TIA
Notice: Undefined
Could someone tell me where I could post/announce this question?
I am an ISP being in busniness for 7 years.
I support MySQL on my server and would welcome those of you who want
to host their database on our system.
--
contact:
Dave Yadallee NetKnow The Internet Knowledge Company
[EMAIL
PROTECTED]]
Sent: Monday, March 11, 2002 7:42 PM
To: [EMAIL PROTECTED]
Subject: Where do I place a notice that my server hosts mysql databases?
Could someone tell me where I could post/announce this question?
I am an ISP being in busniness for 7 years.
I support MySQL on my server and would welcome
Date: 29 Jan 2002 22:01:18 -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: failure notice
Hi. This is the qmail-send program at web.mysql.com.
I'm afraid I wasn't able to deliver your message to the following addresses.
This is a permanent error; I've given up. Sorry it didn't
(This is third attempt to post. always failed in some reason)
I would like to make your attention on bug which was introduced tonight
and can affect some people who are using (var)char field to store
timestamp data.
It is not worst security bug. It affects only people who already had bug
in
At 06:44 07.09.01, you wrote:
here is my sql query
SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER BY
count DESC
what I would like to do is list say just the hosts that have greater then 10
in the left column
use the HAVING statement as in:
SELECT COUNT(*) as
Sorry I am new to SQL and any help would be greatly appreciated
Here is my table
CREATE TABLE host_list (
number mediumint(9) NOT NULL auto_increment,
date datetime NOT NULL default '-00-00 00:00:00',
hostname varchar(75) NOT NULL default '',
PRIMARY KEY (number)
) TYPE=MyISAM;
This email is being sent to you on behalf of your current webspace provider.
This message is not a spam or junk email, your email address was supplied to
WebHosting.com
You will not receive any more messages from WebHosting.com this is a one time special
offer notice.
WebHosting.com
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: failure notice
Date: 11 Jun 2001 04:51:01 -
Hi. This is the qmail-send program at web.mysql.com.
I'm afraid I wasn't able to deliver your message to the following
addresses.
This is a permanent error; I've given up. Sorry it didn't
HI PEOPLE:
WHAT CAN I DO TO NOTE WHEN A NEW REGISTER IS INSERTED
INTO A TABLE.
THANKS , SEE YOU LATER.
=
there are too many more mindS to free
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
20 matches
Mail list logo