List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:March 21 1999 6:35pm
Subject:Problems with LONGTEXT/BSDI 4.0
View as plain text  
Len Rose writes:
 > -----BEGIN PGP SIGNED MESSAGE-----
 > 
 > 
 > I've created a test database, added some records with (1) LONGTEXT field..
 > Inserted several 16k entries in the text field.. 90% of the time accessing them
 > will cause mysql to die.. (3.22.14b-gamma)
 > 
 > i.e. 
 > 
 > mysql> select * from data
 >     -> \g
 > ERROR 2013: Segmentation faultLost connection to MySQL server during query
 >  - core dumpedmysql> 
 > mysqld restarted on  Sat Mar 20 21:02:41 EST 1999
 > 
 > Database: test1  Table: testdata  Rows: 1
 > +-----------+--------------+------+-----+---------+----------------+
 > | Field     | Type         | Null | Key | Default | Extra          |
 > +-----------+--------------+------+-----+---------+----------------+
 > | Num       | varchar(5)   | YES  |     |         |                |
 > | Title     | varchar(254) | YES  |     |         |                |
 > | Author    | varchar(254) | YES  |     |         |                |
 > | Text      | longtext     | YES  |     |         |                |
 > | RecordID  | int(11)      |      | PRI | 0       | auto_increment |
 > +-----------+--------------+------+-----+---------+----------------+
 > 
 > 
 > If I access any other field things are fine.. any ideas on solving this?
 > 
 > Thanks
 > 
 > Len
 > 
 > len@stripped
 > http://www.netsys.com
 > 
 > -----BEGIN PGP SIGNATURE-----
 > Version: 2.6.1
 > 
 > iQCVAwUBNvRUi4ef0OvUNu5PAQGS+wQAl5mCVMXYoUPgMMWbIbyGiTl54zmwJd7K
 > AGhMd2WHcrWgAxN7QiUlJ3haDzBWjUyB5TthHOXkYtefQEuGtUH8posO5TvYIBCd
 > 0gjJoZHKhmTl4Cj1aB5wHyIgWGWRqUFF4S7uzQYW5wAA1NRC1NqVRYlbWcxVOfjq
 > zs2W/Od/apY=
 > =NiIp
 > -----END PGP SIGNATURE-----

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

+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___        ==  mysql@stripped        |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|        Sinisa Milivojevic      |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|        mailto:sinisa@stripped |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|        Belgrade                |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____   Serbia                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+
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