List:General Discussion« Previous MessageNext Message »
From:Patrick Verdon Date:September 5 1999 1:34pm
Subject:Segmentation fault on SPARC Solaris 2.6 with 3.22.25
View as plain text  
Hi guys,

Having a problem when doing a pretty simple query.
Looks like a similar problem was reported:

 Subject: Core dump on simple query
    Date: Thu, 2 Sep 1999 06:52:22 -0700 (PDT)
   From:  roy@stripped
     To:  mysql@stripped

>Description:

Segmentation fault produced by the following - it 
looks like the 'where (expiry_date >= current_date())'
is causing the problem. Note that the problem doesn't 
seem to happen on Solaris x86 2.6 with exactly the same 
set-up.

mysql> describe kan_discussion_demo_announcements;
+--------------+-------------+------+-----+---------+----------------+
| Field        | Type        | Null | Key | Default | Extra          |
+--------------+-------------+------+-----+---------+----------------+
| id           | int(11)     |      | PRI | 0       | auto_increment |
| thread_id    | int(11)     | YES  |     | NULL    |                |
| thread_num   | int(11)     | YES  |     | NULL    |                |
| thread_total | int(11)     | YES  |     | NULL    |                |
| name         | varchar(32) | YES  |     | NULL    |                |
| subject      | varchar(90) | YES  |     | NULL    |                |
| message      | text        | YES  |     | NULL    |                |
| date         | date        | YES  |     | NULL    |                |
| time         | time        | YES  |     | NULL    |                |
| expiry_date  | date        | YES  |     | NULL    |                |
+--------------+-------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

mysql> SELECT id, thread_id, thread_num, thread_total, subject, name, date, time,
> expiry_date from kan_discussion_demo_announcements where (expiry_date >=
> current_date()); 
ERROR 2013: Lost connection to MySQL server during query
mysql> 

>Submitter-Id:  <submitter ID>
>Originator:    Patrick Verdon
>Organization: KAN Design & Publishing Ltd
>MySQL support: none
>Synopsis:      Query with date produces segmentation fault
>Severity:      serious
>Priority:      high
>Category:      mysql
>Class:         sw-bug
>Release:       mysql-3.22.25 (Source distribution)
>Server: mysqladmin  Ver 7.11 Distrib 3.22.25, for sun-solaris2.6 on sparc
TCX Datakonsult AB, by Monty

Server version          3.22.25
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /tmp/mysql.sock
Uptime:                 14 min 47 sec

Threads: 1  Questions: 7  Slow queries: 1  Opens: 12  Flush tables: 1  Open tables: 8
>Environment:
        <machine, os, target, libraries (multiple lines)>
System: SunOS kandinsky 5.6 Generic_105181-06 sun4u sparc SUNW,Ultra-5_10
Architecture: sun4

Some paths:  /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc
/usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95/specs
gcc version 2.95 19990728 (release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS=''  LDFLAGS=''
Configure command: ./configure  --with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes
Perl: This is perl, version 5.005_02 built for sun4-solaris

-- 

#===============================#
\  KAN Design & Publishing Ltd  /
/  T: +44 (0)1223 511134        \
\  F: +44 (0)1223 571968        /
/  E: mailto:patrick@stripped  \ 
\  W: http://www.kan.co.uk      /
#===============================#
Thread
Segmentation fault on SPARC Solaris 2.6 with 3.22.25Patrick Verdon5 Sep
  • Re: Segmentation fault on SPARC Solaris 2.6 with 3.22.25sinisa6 Sep
  • Re: Segmentation fault on SPARC Solaris 2.6 with 3.22.25Patrick Verdon6 Sep
    • Re: Segmentation fault on SPARC Solaris 2.6 with 3.22.25sinisa6 Sep
  • Re: Segmentation fault on SPARC Solaris 2.6 with 3.22.25Patrick Verdon6 Sep
    • Re: Segmentation fault on SPARC Solaris 2.6 with 3.22.25sinisa7 Sep
    • Re: Segmentation fault on SPARC Solaris 2.6 with 3.22.25David Axmark13 Sep
  • Re: Segmentation fault on SPARC Solaris 2.6 with 3.22.25Patrick Verdon7 Sep