MySQL support: none
Synopsis: Server crashes on remote connection
Severity: serious
Priority: high
Category: mysql
Class: Bug / Local Problem?
Release: mysql-3.23.54 (Source distribution)
mysql-server-3.23.54a-4
mysql-3.23.54a-4
mysql-devel-3.23.54a-4
(used rpms from updates.redhatcom)
RedHat 8.0, kernel 2.4.18-19.8.0 i686 i686 i386 GNU/Linux
Architecture: i686
Pentium 4, 1.9 Ghz
512 Mb memory
glibc-2.2.93-5
A second machine also has the same symptoms. It is similar, except the disk
drive setup is completely different.
SYMPTOM
In the log (below) any line beginning "Tcp port: 3306" is an attempt to
connect remotely (using a GUI client, or using command line mysql, or using
a perl program) that fails. That's the only evidence of the attempt.
(Maybe a different logging option would give more info? We used
--debug=d,general,query as suggested in manual.) Queries from localhost all
seem to work.
For example, with perl, Apache log (with specifics edited out) says:
DBI->connect(databasename:hostname.domainname.net:3306) failed: Lost
connection to MySQL server during query at /path/cat_show.pl line 22.
And... and other open connections (localhost) were lost at the same time and
had to reconnect on next query.
Using mysql at command line gives basically the same complaint.
---->>>> The Uptime shows that mysqld has restarted mysql in each case.
Connection attempts are as user martin. User table is:
+-----------+--------+------------------+-------------+
| Host | User | Password | All_priv |
+-----------+--------+------------------+-------------+
| localhost | root | xxxxxxxxxxxxxxxx | Y |
| localhost | martin | xxxxxxxxxxxxxxxx | Y |
| % | martin | xxxxxxxxxxxxxxxx | Y |
+-----------+--------+------------------+-------------+
(All users have all privileges and a password.) ipTables is disabled.
I did a shutdown and ran ISAMCHK on MYI files as suggested in manual.
Any feedback would be appreciated.
Martin Abell
SpeedSpan
============================= LOG ========================
tail -50 sp31.log
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
030122 22:51:47 1 Connect root@localhost on
1 Statistics
1 Quit
/usr/libexec/mysqld, Version: 3.23.54-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
030122 23:05:12 1 Connect root@localhost on
1 Query SHOW VARIABLES LIKE 'pid_file'
1 Shutdown
/usr/libexec/mysqld, Version: 3.23.54-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
030122 23:22:54 1 Connect Access denied for user: 'root@localhost'
(Using password: YES)
030122 23:23:21 2 Connect root@localhost on
030123 9:15:57 3 Connect root@localhost on
030123 9:16:02 3 Init DB mysql
3 Query show databases
3 Query show tables
3 Field List columns_priv
3 Field List db
3 Field List func
3 Field List host
3 Field List tables_priv
3 Field List user
030123 9:16:12 3 Query select * from user
030123 9:17:23 4 Connect root@localhost on
4 Statistics
4 Quit
030123 9:17:51 5 Connect root@localhost on
5 Statistics
5 Quit
/usr/libexec/mysqld, Version: 3.23.54-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
030123 9:17:59 1 Connect root@localhost on
1 Statistics
1 Quit
030123 9:18:46 2 Connect root@localhost on mysql
2 Query show databases
2 Query show tables
2 Field List columns_priv
2 Field List db
2 Field List func
2 Field List host
2 Field List tables_priv
2 Field List user
2 Query show variables
030123 9:27:15 2 Query show variables
============================= VARIABLES ========================
mysql> show variables \G
*************************** 1. row ***************************
Variable_name: back_log
Value: 50
*************************** 2. row ***************************
Variable_name: basedir
Value: /usr/
*************************** 3. row ***************************
Variable_name: bdb_cache_size
Value: 8388600
*************************** 4. row ***************************
Variable_name: bdb_log_buffer_size
Value: 32768
*************************** 5. row ***************************
Variable_name: bdb_home
Value: /var/lib/mysql/
*************************** 6. row ***************************
Variable_name: bdb_max_lock
Value: 10000
*************************** 7. row ***************************
Variable_name: bdb_logdir
Value:
*************************** 8. row ***************************
Variable_name: bdb_shared_data
Value: OFF
*************************** 9. row ***************************
Variable_name: bdb_tmpdir
Value: /tmp/
*************************** 10. row ***************************
Variable_name: bdb_version
Value: Sleepycat Software: Berkeley DB 3.2.9a: (December 5, 2002)
*************************** 11. row ***************************
Variable_name: binlog_cache_size
Value: 32768
*************************** 12. row ***************************
Variable_name: character_set
Value: latin1
*************************** 13. row ***************************
Variable_name: character_sets
Value: latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia
euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2
latin5 swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620
*************************** 14. row ***************************
Variable_name: concurrent_insert
Value: ON
*************************** 15. row ***************************
Variable_name: connect_timeout
Value: 5
*************************** 16. row ***************************
Variable_name: datadir
Value: /var/lib/mysql/
*************************** 17. row ***************************
Variable_name: delay_key_write
Value: ON
*************************** 18. row ***************************
Variable_name: delayed_insert_limit
Value: 100
*************************** 19. row ***************************
Variable_name: delayed_insert_timeout
Value: 300
*************************** 20. row ***************************
Variable_name: delayed_queue_size
Value: 1000
*************************** 21. row ***************************
Variable_name: flush
Value: OFF
*************************** 22. row ***************************
Variable_name: flush_time
Value: 0
*************************** 23. row ***************************
Variable_name: have_bdb
Value: YES
*************************** 24. row ***************************
Variable_name: have_gemini
Value: NO
*************************** 25. row ***************************
Variable_name: have_innodb
Value: DISABLED
*************************** 26. row ***************************
Variable_name: have_isam
Value: YES
*************************** 27. row ***************************
Variable_name: have_raid
Value: NO
*************************** 28. row ***************************
Variable_name: have_openssl
Value: NO
*************************** 29. row ***************************
Variable_name: init_file
Value:
*************************** 30. row ***************************
Variable_name: innodb_additional_mem_pool_size
Value: 1048576
*************************** 31. row ***************************
Variable_name: innodb_buffer_pool_size
Value: 8388608
*************************** 32. row ***************************
Variable_name: innodb_data_file_path
Value:
*************************** 33. row ***************************
Variable_name: innodb_data_home_dir
Value:
*************************** 34. row ***************************
Variable_name: innodb_file_io_threads
Value: 4
*************************** 35. row ***************************
Variable_name: innodb_force_recovery
Value: 0
*************************** 36. row ***************************
Variable_name: innodb_thread_concurrency
Value: 8
*************************** 37. row ***************************
Variable_name: innodb_flush_log_at_trx_commit
Value: 0
*************************** 38. row ***************************
Variable_name: innodb_fast_shutdown
Value: ON
*************************** 39. row ***************************
Variable_name: innodb_flush_method
Value:
*************************** 40. row ***************************
Variable_name: innodb_lock_wait_timeout
Value: 50
*************************** 41. row ***************************
Variable_name: innodb_log_arch_dir
Value:
*************************** 42. row ***************************
Variable_name: innodb_log_archive
Value: OFF
*************************** 43. row ***************************
Variable_name: innodb_log_buffer_size
Value: 1048576
*************************** 44. row ***************************
Variable_name: innodb_log_file_size
Value: 5242880
*************************** 45. row ***************************
Variable_name: innodb_log_files_in_group
Value: 2
*************************** 46. row ***************************
Variable_name: innodb_log_group_home_dir
Value:
*************************** 47. row ***************************
Variable_name: innodb_mirrored_log_groups
Value: 1
*************************** 48. row ***************************
Variable_name: interactive_timeout
Value: 28800
*************************** 49. row ***************************
Variable_name: join_buffer_size
Value: 131072
*************************** 50. row ***************************
Variable_name: key_buffer_size
Value: 8388600
*************************** 51. row ***************************
Variable_name: language
Value: /usr/share/mysql/english/
*************************** 52. row ***************************
Variable_name: large_files_support
Value: ON
*************************** 53. row ***************************
Variable_name: locked_in_memory
Value: OFF
*************************** 54. row ***************************
Variable_name: log
Value: ON
*************************** 55. row ***************************
Variable_name: log_update
Value: OFF
*************************** 56. row ***************************
Variable_name: log_bin
Value: OFF
*************************** 57. row ***************************
Variable_name: log_slave_updates
Value: OFF
*************************** 58. row ***************************
Variable_name: log_long_queries
Value: OFF
*************************** 59. row ***************************
Variable_name: long_query_time
Value: 10
*************************** 60. row ***************************
Variable_name: low_priority_updates
Value: OFF
*************************** 61. row ***************************
Variable_name: lower_case_table_names
Value: 0
*************************** 62. row ***************************
Variable_name: max_allowed_packet
Value: 1048576
*************************** 63. row ***************************
Variable_name: max_binlog_cache_size
Value: 4294967295
*************************** 64. row ***************************
Variable_name: max_binlog_size
Value: 1073741824
*************************** 65. row ***************************
Variable_name: max_connections
Value: 100
*************************** 66. row ***************************
Variable_name: max_connect_errors
Value: 10
*************************** 67. row ***************************
Variable_name: max_delayed_threads
Value: 20
*************************** 68. row ***************************
Variable_name: max_heap_table_size
Value: 16777216
*************************** 69. row ***************************
Variable_name: max_join_size
Value: 4294967295
*************************** 70. row ***************************
Variable_name: max_sort_length
Value: 1024
*************************** 71. row ***************************
Variable_name: max_user_connections
Value: 0
*************************** 72. row ***************************
Variable_name: max_tmp_tables
Value: 32
*************************** 73. row ***************************
Variable_name: max_write_lock_count
Value: 4294967295
*************************** 74. row ***************************
Variable_name: myisam_max_extra_sort_file_size
Value: 256
*************************** 75. row ***************************
Variable_name: myisam_max_sort_file_size
Value: 2047
*************************** 76. row ***************************
Variable_name: myisam_recover_options
Value: 0
*************************** 77. row ***************************
Variable_name: myisam_sort_buffer_size
Value: 8388608
*************************** 78. row ***************************
Variable_name: net_buffer_length
Value: 16384
*************************** 79. row ***************************
Variable_name: net_read_timeout
Value: 30
*************************** 80. row ***************************
Variable_name: net_retry_count
Value: 10
*************************** 81. row ***************************
Variable_name: net_write_timeout
Value: 60
*************************** 82. row ***************************
Variable_name: open_files_limit
Value: 0
*************************** 83. row ***************************
Variable_name: pid_file
Value: /var/run/mysqld/mysqld.pid
*************************** 84. row ***************************
Variable_name: port
Value: 3306
*************************** 85. row ***************************
Variable_name: protocol_version
Value: 10
*************************** 86. row ***************************
Variable_name: record_buffer
Value: 131072
*************************** 87. row ***************************
Variable_name: record_rnd_buffer
Value: 131072
*************************** 88. row ***************************
Variable_name: query_buffer_size
Value: 0
*************************** 89. row ***************************
Variable_name: safe_show_database
Value: OFF
*************************** 90. row ***************************
Variable_name: server_id
Value: 0
*************************** 91. row ***************************
Variable_name: slave_net_timeout
Value: 3600
*************************** 92. row ***************************
Variable_name: skip_locking
Value: ON
*************************** 93. row ***************************
Variable_name: skip_networking
Value: OFF
*************************** 94. row ***************************
Variable_name: skip_show_database
Value: OFF
*************************** 95. row ***************************
Variable_name: slow_launch_time
Value: 2
*************************** 96. row ***************************
Variable_name: socket
Value: /var/lib/mysql/mysql.sock
*************************** 97. row ***************************
Variable_name: sort_buffer
Value: 2097144
*************************** 98. row ***************************
Variable_name: sql_mode
Value: 0
*************************** 99. row ***************************
Variable_name: table_cache
Value: 64
*************************** 100. row ***************************
Variable_name: table_type
Value: MYISAM
*************************** 101. row ***************************
Variable_name: thread_cache_size
Value: 0
*************************** 102. row ***************************
Variable_name: thread_stack
Value: 65536
*************************** 103. row ***************************
Variable_name: transaction_isolation
Value: READ-COMMITTED
*************************** 104. row ***************************
Variable_name: timezone
Value: EST
*************************** 105. row ***************************
Variable_name: tmp_table_size
Value: 33554432
*************************** 106. row ***************************
Variable_name: tmpdir
Value: /tmp/
*************************** 107. row ***************************
Variable_name: version
Value: 3.23.54-log
*************************** 108. row ***************************
Variable_name: wait_timeout
Value: 28800
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--disable-checking --host=i386-redhat-linux --with-system-zlib
--enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='g++' CXXFLAGS='-O2
-march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64
-D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Jan 1 15:49 /lib/libc.so.6 ->
libc-2.2.93.so
-rwxr-xr-x 1 root root 1235468 Sep 5 19:12 /lib/libc-2.2.93.so
-rw-r--r-- 1 root root 2233342 Sep 5 18:59 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 5 18:50 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr'
'--bindir=/usr/bin' '--datadir=/usr/share' '--libdir=/usr/lib'
'--mandir=/usr/share/man' '--infodir=/usr/share/info' '--without-readline'
'--without-debug' '--enable-shared' '--with-extra-charsets=complex'
'--with-bench' '--localstatedir=/var/lib/mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock'
'--with-mysqld-user=mysql' '--with-extra-charsets=all' '--with-innodb'
'--enable-local-infile' '--enable-large-files=yes' '--enable-largefile=yes'
'--with-berkeley-db' '--with-thread-safe-client' 'CFLAGS=-O2 -march=i386
-mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'
'CXXFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64
-D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions'
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
