[R] Segmentation fault using gentoo linux and mysql

From: Dubravko Dolic <Dubravko.Dolic_at_komdat.com>
Date: Fri 03 Jun 2005 - 20:54:52 EST


Dear Listmembers

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.

Is anyone out there having similar problems in this environment. Any hints welcome.

Regards

Dubravko Dolic
Statistical Analyst
Tel:      +49 (0)89-55 27 44 - 4630
Fax:     +49 (0)89-55 27 44 - 2463
Email: dubravko.dolic@komdat.com
Komdat GmbH
Nymphenburger Straße 86
80636 München



ONLINE MARKETING THAT WORKS

This electronic message contains information from Komdat Gmb...{{dropped}}

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Fri Jun 03 20:58:00 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:32:22 EST