"Lost Connection to MySQL Server During Query"

[Michael Berkowitz]

I'm not managing to connect to a MySQL server (v4.0.21) running on a
Debian Linux machine. I'm using MyODBC v3.51 on Windows XP and '98.

I get the error message listed in the Subject, plus the following text
in the 'myodbc.log' file:

-----------------------------------------------------------

| | : ----------------------------------------------------------
| | : -- MySQL ODBC 3.51 Driver, VERSION: 03.51.06 --
| | : -- --
| | : -- DEBUG LOGGING --
| | : -- --
| | : -- TIMESTAMP: 041027 9:09:08 --
| | : ----------------------------------------------------------


| | >mysql_option
| | | enter: option: 0
| | <mysql_option
| | info: option_flag: 655367 client_flag: 66


| <get_client_flag
| >mysql_real_connect
| | enter: host: etzion.org.il db: Main user: mberkowitz
| | info: Server name: 'etzion.org.il'. TCP sock: 3306
| | >vio_new
| | | enter: sd=1452
| | | >_mymalloc
| | | | enter: Size: 84
| | | | exit: ptr: 93a2878
| | | <_mymalloc
| | <vio_new
| | >_mymalloc
| | | enter: Size: 8192
| | | exit: ptr: 1e27190
| | <_mymalloc
| | >vio_fastsend
| | | exit: 0
| | <vio_fastsend
| | >vio_keepalive
| | | enter: sd=1452 set_keep_alive=1
| | <vio_keepalive
| | >vio_is_blocking
| | | exit: 1
| | <vio_is_blocking
| | >vio_read
| | | enter: sd=1452 size=4
| | | exit: 0
| | <vio_read
| | info: vio_read returned 0, errno: 0
| | error: Couldn't read packet: remain: 4 errno: 0 length: 0
alarmed: 0
| | error: Wrong connection or packet. fd: TCP/IP (1452) len: -1
| | >end_server
| | | info: Net: TCP/IP (1452)
| | | >vio_close
| | | <vio_close
| | | >_myfree
| | | | enter: ptr: 93a2878
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 1e27190
| | | <_myfree
| | | >free_old_query
| | | <free_old_query
| | <end_server
| | error: message: 2013 (Lost connection to MySQL server during
query)
| | >end_server
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >free_old_query
| | | <free_old_query
| | <end_server
| | >mysql_close
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | <mysql_close
| <mysql_real_connect
| info: Connect string out: DSN=Main;DESC=MySQL ODBC 3.51 Driver
DSN;DATABASE=Main;SERVER=etzion.org.il;UID=mberkowitz;PASSWORD=TNIaWoT;PORT=3306;OPTION=655367;STMT=;
| >get_client_flag
| | >mysql_option
| | | enter: option: 0
| | <mysql_option
| | info: option_flag: 655367 client_flag: 66


| <get_client_flag
| >mysql_real_connect
| | enter: host: etzion.org.il db: Main user: mberkowitz
| | info: Server name: 'etzion.org.il'. TCP sock: 3306
| | >vio_new
| | | enter: sd=548
| | | >_mymalloc
| | | | enter: Size: 84
| | | | exit: ptr: 93a2878
| | | <_mymalloc
| | <vio_new
| | >_mymalloc
| | | enter: Size: 8192
| | | exit: ptr: 1e27190
| | <_mymalloc
| | >vio_fastsend
| | | exit: 0
| | <vio_fastsend
| | >vio_keepalive
| | | enter: sd=548 set_keep_alive=1
| | <vio_keepalive
| | >vio_is_blocking
| | | exit: 1
| | <vio_is_blocking
| | >vio_read
| | | enter: sd=548 size=4
| | | exit: 0
| | <vio_read
| | info: vio_read returned 0, errno: 0
| | error: Couldn't read packet: remain: 4 errno: 0 length: 0
alarmed: 0
| | error: Wrong connection or packet. fd: TCP/IP (548) len: -1
| | >end_server
| | | info: Net: TCP/IP (548)
| | | >vio_close
| | | <vio_close
| | | >_myfree
| | | | enter: ptr: 93a2878
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 1e27190
| | | <_myfree
| | | >free_old_query
| | | <free_old_query
| | <end_server
| | error: message: 2013 (Lost connection to MySQL server during
query)
| | >end_server
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >free_old_query
| | | <free_old_query
| | <end_server
| | >mysql_close
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | <mysql_close
| <mysql_real_connect
| >copy_error
| | error: code :2013, state: S1000, err :Lost connection to MySQL
server during query
| | exit : SQL_ERROR
| <copy_error
| exit : SQL_ERROR
<SQLDriverConnect
>SQLGetDiagRec
| values: 2,0x22a748,1,0x13b100,0x0,0x0,0,0x13b178
<SQLGetDiagRec
>SQLGetDiagRec
| values: 2,0x22a748,1,0x13b100,0x13b160,0x7e228c8,71,0x13b178
<SQLGetDiagRec
>SQLGetDiagField
| values: 2,0x22a748,1,8,0x7e22968,256,0x13b14c
| exit : SQL_SUCCESS
<SQLGetDiagField
>SQLGetDiagField
| values: 2,0x22a748,1,9,0x7e22968,256,0x13b14c
| exit : SQL_SUCCESS
<SQLGetDiagField
>SQLGetDiagField
| values: 2,0x22a748,1,10,0x7e22968,256,0x13b14c
| exit : SQL_SUCCESS
<SQLGetDiagField
>SQLGetDiagField
| values: 2,0x22a748,1,11,0x7e22968,256,0x13b14c
| exit : SQL_SUCCESS
<SQLGetDiagField
>SQLGetDiagRec
| values: 2,0x22a748,2,0x13b100,0x0,0x0,0,0x13b178
| exit : SQL_NO_DATA_FOUND
<SQLGetDiagRec
>SQLFreeConnect
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
| exit : SQL_SUCCESS
<SQLFreeConnect
>_myfree
| enter: ptr: 93a2eb8
<_myfree
>_myfree
| enter: ptr: 93a2fe8
<_myfree
>_myfree
| enter: ptr: 93a2e68
<_myfree
>TERMINATE
| safe: Maximum memory usage: 8282 bytes (9k)
<TERMINATE

----------------------------------------------------------

The error response is immediate, so it can't be a timeout problem, and
the mysql logs indicate that the server didn't crash.

Any ideas?

TIA

Michael Berkowitz