I found a log error after turning on warning running the server manually:
051215 17:32:42 [Warning] Aborted connection 3961 to db: 'db' user:
'user' host: `client' (Got timeout reading communication packets)
Any idea what this error is ? the interfaces show no errors from a
network perspective:
db machine
eth0 Link encap:Ethernet HWaddr 00:30:48:2E:E1:F2
inet addr:10.0.0.10 Bcast:10.0.0.255 Mask:255.255.255.0
inet6 addr: fe80::230:48ff:fe2e:e1f2/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:7973410 errors:0 dropped:0 overruns:0 frame:0
TX packets:9299327 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:746369778 (711.7 Mb) TX bytes:8126772010 (7750.2 Mb)
Base address:0x2000 Memory:da200000-da220000
client machine:
eth1 Link encap:Ethernet HWaddr 00:30:48:55:92:4F
inet addr:10.0.0.1 Bcast:10.0.0.255 Mask:255.255.255.0
inet6 addr: fe80::230:48ff:fe55:924f/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:19720381 errors:0 dropped:0 overruns:0 frame:0
TX packets:16126186 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:16315799815 (15559.9 Mb) TX bytes:1696496582 (1617.9 Mb)
Base address:0xc400 Memory:fc9a0000-fc9c0000
and the query runs fine a second time? so the query isnt malformed
Regards,
Doug
Doug Dalton wrote:
Gleb,
I watched the server during this error, the server continued to
run... it didnt crash... and no warning or logged error?
Regards,
Doug
Doug Dalton wrote:
Gleb Paharenko wrote:
Hello.
Check that MySQL doesn't die during the query. See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
Gleb,
I should mention that I get no log errors and I even have it set to
warn .... does this mean mysql could die and not log the error? I
have gone through this document for the last week rewritten code
based on the suggestions and still get the error.
Regards,
Doug
oug Dalton wrote:
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
select query, I have checked the threads on lost connection and my
connection times as well as making sure my calls are all made from non
forking processes etc... I cannot seem to resolve this error? can
someone point me in the right direction? I notice if I remove the
LIMIT
statement I get fewer errors... but that cannot be the cause of the
problem
[14-Dec-2005 17:32:20] DB_Error Object
(
[error_message_prefix] =>
[mode] => 1
[level] => 1024
[code] => -14
[message] => DB Error: no database selected
[userinfo] => SELECT * FROM buser Where
mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1
[nativecode=2013 **
Lost
connection to MySQL server during query]
[backtrace] => Array
(
[0] => Array
(
[file] => /usr/share/php5/PEAR/DB.php
[line] => 888
[function] => PEAR_Error
[class] => DB_Error
[type] => ->
[args] => Array
(
[0] => DB Error: no database selected
[1] => -14
[2] => 1
[3] => 1024
[4] => SELECT * FROM buser Where
mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativec
ode=2013 ** Lost connection to MySQL server during query]
)
)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
