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 |
+---------------------------------------------------------------------+
