-----BEGIN PGP SIGNED MESSAGE-----
The application is myql itself.. I've tested this on Solaris and BSDI 4.0.. it
only fails on BSDI 4.0.. isamchk -o output doesn't indicate anything wrong..
# limit
coredumpsize unlimited
cputime unlimited
datasize 262144 kbytes
filesize unlimited
maxproc 4116
memorylocked unlimited
memoryuse unlimited
openfiles 13196
stacksize 131360 kbytes
#
# mysql test1
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.22.14b-gamma
Type 'help' for help.
mysql> select * from data
-> \g
ERROR 2013: Lost connection to MySQL server during query
mysql> \q
Bye
# mysqladmin variables
+----------------------+---------------------------------+
| Variable_name | Value |
+----------------------+---------------------------------+
| back_log | 5 |
| connect_timeout | 5 |
| basedir | /usr/local/ |
| datadir | /usr/local/var/ |
| join_buffer | 131072 |
| key_buffer | 1048568 |
| language | /usr/local/share/mysql/english/ |
| log | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| max_allowed_packet | 1048576 |
| max_connections | 90 |
| max_connect_errors | 10 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| net_buffer_length | 16384 |
| port | 3306 |
| record_buffer | 131072 |
| skip_locking | OFF |
| socket | /tmp/mysql.sock |
| sort_buffer | 2097144 |
| table_cache | 64 |
| thread_stack | 65536 |
| tmp_table_size | 1048576 |
| tmpdir | /var/tmp/ |
| update_log | OFF |
| wait_timeout | 28800 |
+----------------------+---------------------------------+
According to gdb it seems it was trying to do a memset at the time of failure..
I'm going to upgrade mysql to the latest version within 24 hours..
Thanks
Len
On 21-Mar-99 sinisa@stripped wrote:
> Hi!
>
> Try to run isamchk -o on the table.
>
> You can also check your application. It is possible that if you are
> using local variables that stack overflow occurs because of large size
> of sime TEXT/BLOB fields.
>
> Sinisa
>
len@stripped
http://www.netsys.com
-----BEGIN PGP SIGNATURE-----
Version: 2.6.1
iQCVAwUBNvWf7Ief0OvUNu5PAQF3twP/ajnyVByL/aReAnljmZNRyjlP8TN8N7Sb
3bODLeVlS3jkdwYIClPSTdu2SU1FLVJh2xcAKdwrVBu4RNB5pSOdGM0Sl/00wYDa
pTdYtDi4+gChk+oZjK0RYC4aQ4PbJl0S19+dqoRIgwjYsTYrMF9C1QmLtVk9mHpo
FPSQfhH3KzE=
=nvZi
-----END PGP SIGNATURE-----