Hello all,
i am experiencing the odd problem of 'lost connection
to MySQL server during query'. This is happening because my
mysqld server (for some reason) restarts while i am accesing it.
I am using 2 SQL queries to reproduce the problem i have and decouple
it from my C++ application. I have the queries in ascii files and try
to upload them using the mysql client.
I think one important hint is that i can upload queries 1 and 2
(or 2 and 1) if i have them in separate files and issue the
commands
mysql -u uploader -p < query1.sql
mysql -u uploader -p < query2.sql
but it fails if i have both queries in a single file and issue
mysql -u uploader -p < query1and2.sql
!!!
Please also notice that in the hostname.err file (listed below) the
SQL query that causes the problem is half-written (I do not know
that it means, if anything. I do know however that my original query is
correct).
-------------------------------------------------
I am using a RehHat LINUX 7.2, kernel 2.4.7-10.
I have installed MySQL 3.23.47 RPMs from MySQL site
Below, you can find :
-- the output of the mysqladmin variables command
-- an example of my *.err file
Also,
-- the ascii file with the 2 queries i use to upload some data
can be found at http://www.cc.uoa.gr/~candreop/SQLmin2.sql
*** Any help will be very deeply appreciated ***,
Costas Andreopoulos <[EMAIL PROTECTED]>
PS. I hope i supplied enough input / i am not a dbase expert.
-------------------------------------------------------------------------
The output of mysqladmin variables:
-------------------------------------------------------------------------
+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value
|
| |
+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50
| basedir | /
| binlog_cache_size | 32768
| character_set | latin1
| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis620
|ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251
|estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
| concurrent_insert | ON
| connect_timeout | 5
| datadir | /var/lib/mysql/
| delay_key_write | ON
| delayed_insert_limit | 100
| delayed_insert_timeout | 300
| delayed_queue_size | 1000
| flush | OFF
| flush_time | 0
| have_bdb | NO
| have_gemini | NO
| have_innodb | NO
| have_isam | YES
| have_raid | NO
| have_openssl | NO
| init_file |
| interactive_timeout | 28800
| join_buffer_size | 131072
| key_buffer_size | 8388600
| language | /usr/share/mysql/english/
| large_files_support | ON
| locked_in_memory | OFF
| log | OFF
| log_update | OFF
| log_bin | OFF
| log_slave_updates | OFF
| log_long_queries | OFF
| long_query_time | 10
| low_priority_updates | OFF
| lower_case_table_names | 0
| max_allowed_packet | 1048576
| max_binlog_cache_size | 4294967295
| max_binlog_size | 1073741824
| max_connections | 100
| max_connect_errors | 10
| max_delayed_threads | 20
| max_heap_table_size | 16777216
| max_join_size | 4294967295
| max_sort_length | 1024
| max_user_connections | 0
| max_tmp_tables | 32
| max_write_lock_count | 4294967295
| myisam_max_extra_sort_file_size | 256
| myisam_max_sort_file_size | 2047
| myisam_recover_options | 0
| myisam_sort_buffer_size | 8388608
| net_buffer_length | 16384
| net_read_timeout | 30
| net_retry_count | 10
| net_write_timeout | 60
| open_files_limit | 0
| pid_file | /var/lib/mysql/daedalus.phys.uoa.gr.pid
| port | 3306
| protocol_version | 10
| record_buffer | 131072
| record_rnd_buffer | 131072
| query_buffer_size | 0
| safe_show_database | OFF
| server_id | 0
| slave_net_timeout | 3600
| skip_locking | ON
| skip_networking | OFF
| skip_show_database | OFF
| slow_launch_time | 2
| socket | /var/lib/mysql/mysql.sock
| sort_buffer | 2097144
| sql_mode | 0
| table_cache | 64
| table_type | MYISAM
| thread_cache_size | 0
| thread_stack | 65536
| transaction_isolation | READ-COMMITTED
| timezone | EET
| tmp_table_size | 33554432
| tmpdir | /tmp/
| version | 3.23.47
| wait_timeout | 28800
-------------------------------------------------------------------------
My hostname.err file:
-------------------------------------------------------------------------
Number of processes running now: 0
020204 17:48:46 mysqld restarted
/usr/sbin/mysqld: ready for connections
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked agaist is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail
key_buffer_size=8388600
record_buffer=131072
sort_buffer=2097144
max_used_connections=1
max_connections=100
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x807ba8f
0x812c82a
0x815105a
0x81507d4
0x8116158
0x811662f
0x8096ce1
0x80938e2
0x8092f3a
0x8093c8b
0x80a7726
0x808330b
0x8086006
0x808153d
0x8080a0c
Stack trace seems successful - bottom reached
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x825c960 = insert into MODE3_MU0_2 values ('ka0248', '6012', '1', '
1.1816', ' -2.4038', ' -1.8516', ' -1.6357', ' 4.958', '
-0.4521', ' -1.7407', ' -0.6626', ' 306.772', ' 0
.707', ' -0.5371', ' -0.2832', ' 3.6709', ' 0.2046', '
-0.1631', ' 0', ' 0.9414', ' -1.9912', ' -1.5215', '
-1.6436', ' 5.8628', ' 0.4277', ' -1.3296', ' -0.535
6', ' 341.04', ' 2.1333', ' -0.1797', ' 0.062', '
3.8442', ' 0.4702', ' -0.1865', ' 0.5078', ' 1.2178', '
-1.7856', ' -1.5625', ' -1.1484', ' 5.6738', ' 1.9653',
' -0.957', ' -0.2603', ' 269.646', ' 8.9102', '
0.2881', ' -0.3809', ' 4.2637', ' 1.5884', ' 0.5234', '
1.0522', ' 1.2944', ' -1.9585', ' -1.3188', ' -0.7979', '
2.542', ' 0.124
thd->thread_id=3
Successfully dumped variables, if you ran with --log, take a look at the
details of what thread 3 did to cause the crash. In some cases of really
bad corruption, the values shown above may be invalid
The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
information that should help you find out what is causing the crash
Number of processes running now: 0
020204 17:50:13 mysqld restarted
/usr/sbin/mysqld: ready for connections
-`
( '< ''~''
/ ) ) ( o o )
-------------------------------------/|''-----o000--(_)--000o-------
Constantinos Andreopoulos - [EMAIL PROTECTED] - www.uoa.gr/~candreop
University of Athens - Physics Dept.
Division of Nuclear & Particle Physics Off. Tel. +301-727-6742
HEP & Application Lab., Office: Ib-14 Cell.Tel. +3-0972771680
Panepistimioupoli Zografou, 15771 Athens Off. Fax +301-727-6987
send e-mail (short mesg) to my cellular .oooO
[EMAIL PROTECTED] ( ) Oooo.
-------------------------------------------------\ (----( )-------
Don't look back, the lemmings are gaining on you \_) ) /
(_/
---------------------------------------------------------------------
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
