MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:September 6 1999 10:30am
Subject:Re: Segmentation fault on SPARC Solaris 2.6 with 3.22.25
View as plain text  
Patrick Verdon writes:
 > 
 > 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      /
 > #===============================#
 > 

Hi!

Please check two things:

1. Patch level of your Solaris 2.6

2. Try binary available on www.mysql.com FOR 2.6


Otherwise, there are not reports on such problems on Solaris 2.6 with
this version of MySQL.

Sinisa

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