Re: [Rd] Segmentation fault using gentoo linux and mysql (PR#7919)

From: <ripley_at_stats.ox.ac.uk>
Date: Mon 06 Jun 2005 - 14:17:30 GMT


This is most likely a problem with the package RMySQL and not with R.

On Mon, 6 Jun 2005 dubravko.dolic@komdat.com wrote:

> Full_Name: Dubravko Dolic
> Version: 2.1.0
> OS: Linux
> Submission from: (NULL) (212.18.9.161)
>
>
> I posted this mail to the HELP list earlier. Meanwhile we are quite shure that
> there must be a bug. Not nessecarily in R. But maybe we can get some hints how
> to track the problem using R. Currently we are trying something with the ATLAS
> lib according to Bug Report 7718 on this Repository.
>
> Now my problem again:
>
> We have a data server with some amounts of data which we try to analyze using R.
> Now having some MySQL databases with MySQL Ver 12.22 Distrib 4.0.24 and R 2.1.0
> compiled from sources on this machine:
>
> Fujitsu Siemens CELSIUS V810
> 4 GB RAM
> Dual AMD Opteron Processor 246
> Harddisk via SAN.
>
> (see user details:)
> sysname "Linux" <- gentoo linux
> release "2.6.11-hardened-r13" version "#1 SMP Fri
> May 27 15:25:55 CEST 2005" machine "x86_64"
>
> Editor: Emacs with ESS 5.2.3
>
>
> While I can connect R to the database (RMySQL/DBI) and retrieve basic
> information (e.g. SHOW TABLE, DESCRIBE) it is not possible to send SQL Queries.
> The moment I try to do: res <- dbSendQuery(con, "select * from table") or any
> other SELECT statement R terminates and I receive a Segmentation Fault.

Please use gdb to trace where the fault is occurring: my guess is in RMySQL.so, in which case this is best discussed with the package maintainer (see the R FAQ, section on BUGS).

-- 
Brian D. Ripley,                  ripley@stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________
R-devel@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel
Received on Tue Jun 07 01:11:34 2005

This archive was generated by hypermail 2.1.8 : Mon 24 Oct 2005 - 22:26:57 GMT