List:General Discussion« Previous MessageNext Message »
From:Len Rose Date:March 22 1999 1:42am
Subject:RE: Problems with LONGTEXT/BSDI 4.0
View as plain text  
-----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-----
Thread
Problems with LONGTEXT/BSDI 4.0Len Rose21 Mar
  • Problems with LONGTEXT/BSDI 4.0sinisa21 Mar
    • RE: Problems with LONGTEXT/BSDI 4.0Len Rose22 Mar
      • RE: Problems with LONGTEXT/BSDI 4.0Michael Widenius24 Mar
        • RE: Problems with LONGTEXT/BSDI 4.0Vivek Khera24 Mar
          • RE: Problems with LONGTEXT/BSDI 4.0Len Rose24 Mar
        • RE: Problems with LONGTEXT/BSDI 4.0Len Rose24 Mar
          • RE: Problems with LONGTEXT/BSDI 4.0Michael Widenius24 Mar
            • RE: Problems with LONGTEXT/BSDI 4.0Len Rose24 Mar