List:General Discussion« Previous MessageNext Message »
From:Len Rose Date:March 21 1999 2:08am
Subject:Problems with LONGTEXT/BSDI 4.0
View as plain text  
-----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-----
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