[Rd] R crashes on new laptop
The problem is that R crashes with an exception "R for Windows GUI front-end
has encountered a problem and needs to close..." It doesn't always crash,
but almost always does.
Thanks for any help (fixes, workarounds, or diagnostics) you can provide!
Doug
Specs:
PC: HP 2710p
Graphics HW: Mobile Intel 965 Express Chipset Family / Graphics Media
Accelerator X3100
Graphics Driver: 6.14.10.4964 / 6/27/2008 / Intel Corporation
R version: 2.7.1
OS: WinXP Tablet PC 2005
The R script which produces it is very simple (requires package rgl):
open3d()
x <- sort(rnorm(1000))
y <- rnorm(1000)
z <- rnorm(1000) + atan2(x,y)
plot3d(x, y, z, col=rainbow(1000), size=2)
Error details dialog:
http://www.nabble.com/file/p18713928/Error.jpg
The module ig4icd32.dll is part of the graphics driver.
Unfortunately, the hex dump data can't be copied/pasted from the error
details dialog, nor can I get the .dmp file ("file is in use").
Some error information is saved in an xml file:
--
View this message in context:
http://www.nabble.com/R-crashes-on-new-laptop-tp18713928p18713928.html
Sent from the R devel mailing list archive at Nabble.com.
__
R-devel@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel
Re: [Rd] R crashes on new laptop
Found a fix (hack actually, but hey), so I thought I'd pass it on.
I was desperately googling for a solution to this, and on a game website
found a report from someone experiencing OpenGL problems on a machine with
the Intel 965 chipset. They figured out (God only knows how) that by
downloading from the Intel website the zip file of the 965 Vista drivers
(this is on XP), extracting the file ig4dev32.dll, and dropping it into the
directory of the app that was crashing, the problem went away.
So I downloaded the same DLL, dropped it into R/bin, and voila, no more
crash!
Here's the link to the Intel Vista drivers:
http://downloadmirror.intel.com/15884/a08/winvista_159.zip
Enjoy!
Doug
Logickle wrote:
>
> The problem is that R crashes with an exception "R for Windows GUI
> front-end has encountered a problem and needs to close..." It doesn't
> always crash, but almost always does.
>
> Thanks for any help (fixes, workarounds, or diagnostics) you can provide!
>
> Doug
>
> Specs:
> PC: HP 2710p
> Graphics HW: Mobile Intel 965 Express Chipset Family / Graphics Media
> Accelerator X3100
> Graphics Driver: 6.14.10.4964 / 6/27/2008 / Intel Corporation
> R version: 2.7.1
> OS: WinXP Tablet PC 2005
>
> The R script which produces it is very simple (requires package rgl):
>
> open3d()
> x <- sort(rnorm(1000))
> y <- rnorm(1000)
> z <- rnorm(1000) + atan2(x,y)
> plot3d(x, y, z, col=rainbow(1000), size=2)
>
> Error details dialog:
>
> http://www.nabble.com/file/p18713928/Error.jpg
>
> The module ig4icd32.dll is part of the graphics driver.
>
> Unfortunately, the hex dump data can't be copied/pasted from the error
> details dialog, nor can I get the .dmp file ("file is in use").
>
> Some error information is saved in an xml file:
>
>
>
>
> MODULE_TYPE="WIN32" PE_CHECKSUM="0xE13B8" LINKER_VERSION="0x1"
> LINK_DATE="02/29/2008 09:10:55" UPTO_LINK_DATE="02/29/2008 09:10:55" />
> BIN_FILE_VERSION="2.71.45970.0" BIN_PRODUCT_VERSION="3.0.0.0"
> FILE_DESCRIPTION="R for Windows files checker" FILE_VERSION="2.7.1
> (2008-06-23)" LEGAL_COPYRIGHT="R Development Core Team 1995-2008"
> VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x1"
> MODULE_TYPE="WIN32" PE_CHECKSUM="0xC07D" LINKER_VERSION="0x1"
> UPTO_BIN_FILE_VERSION="2.71.45970.0" UPTO_BIN_PRODUCT_VERSION="3.0.0.0"
> LINK_DATE="06/23/2008 12:07:36" UPTO_LINK_DATE="06/23/2008 12:07:36"
> VER_LANGUAGE="English (United States) [0x409]" />
> BIN_FILE_VERSION="2.71.45970.0" BIN_PRODUCT_VERSION="3.0.0.0"
> FILE_DESCRIPTION="R for Windows DLL" FILE_VERSION="2.7.1(2008-06-23)"
> LEGAL_COPYRIGHT="R Development Core Team 1995-2008" VERFILEDATEHI="0x0"
> VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x2" MODULE_TYPE="WIN32"
> PE_CHECKSUM="0x2B1E89" LINKER_VERSION="0x1"
> UPTO_BIN_FILE_VERSION="2.71.45970.0" UPTO_BIN_PRODUCT_VERSION="3.0.0.0"
> LINK_DATE="06/23/2008 12:07:16" UPTO_LINK_DATE="06/23/2008 12:07:16"
> VER_LANGUAGE="English (United States) [0x409]" />
> BIN_FILE_VERSION="2.71.45970.0" BIN_PRODUCT_VERSION="3.0.0.0"
> FILE_DESCRIPTION="R for Windows front-end" FILE_VERSION="2.7.1
> (2008-06-23)" LEGAL_COPYRIGHT="R Development Core Team 1995-2008"
> VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x1"
> MODULE_TYPE="WIN32" PE_CHECKSUM="0x14952" LINKER_VERSION="0x1"
> UPTO_BIN_FILE_VERSION="2.71.45970.0" UPTO_BIN_PRODUCT_VERSION="3.0.0.0"
> LINK_DATE="06/23/2008 12:07:36" UPTO_LINK_DATE="06/23/2008 12:07:36"
> VER_LANGUAGE="English (United States) [0x409]" />
> BIN_FILE_VERSION="2.71.45970.0" BIN_PRODUCT_VERSION="3.0.0.0"
> FILE_DESCRIPTION="R for Windows DLL" FILE_VERSION="2.7.1(2008-06-23)"
> LEGAL_COPYRIGHT="R Development Core Team 1995-2008" VERFILEDATEHI="0x0"
> VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x2" MODULE_TYPE="WIN32"
> PE_CHECKSUM="0x33F83" LINKER_VERSION="0x1"
> UPTO_BIN_FILE_VERSION="2.71.45970.0" UPTO_BIN_PRODUCT_VERSION="3.0.0.0"
> LINK_DATE="06/23/
[Rd] Excessive query time running R-RODBC against SQL Server
Hi, all. I'm using RODBC to query a SQL Server 2005 database, and am
experiencing terribly slow performance. I assume I'm doing something wrong,
but I'm not doing anything fancy, so I'm stumped.
My setup:
Core 2 Duo 2GHz, Win XP, 2GB RAM
R 2.7.1
RODBC (latest from CRAN, not sure the version - how to tell?)
SQL Server 2005
MS Access 2003
SQL Native Client ODBC driver (DSN = "HIM")
SQL Server ODBC driver (DSN = "HIMs")
MS Access ODBC driver (DSN = "HIMa")
Table (T304) being queried has ~290K rows, of which the query being run
should return ~78K.
Table being queried has 142 columns, of which all but 5 are type float. The
other 5 are nvarchar(255)
No indices or keys - one flat table
No UPDATEs, INSERTs, just SELECT
R code looks like this:
him <- odbcConnect("HIM", "CDCS", "")
FAC <- sqlQuery(him, "Select * from T304 where f133=1")
If the DSN used points to SQL Server, the query seems to hang, though I
could see in Task Manager that the R process grows, and uses most of one
CPU. I killed R after 5 minutes of waiting. (If I use sqlFetch() instead and
specify max records as 1000, this does return but only after 1-2 minutes.)
In SQL Server itself, the same query completes after ~6 seconds.
The same data resides in an Access database, from which it was imported into
SQL Server 2005 in fact. If I use the Access DSN in my R code above, the
query takes 12-15s.
How could a query against SQL Server be *so* much slower than against
Access, or than SQL Server by itself?
Thanks,
Doug
--
View this message in context:
http://www.nabble.com/Excessive-query-time-running-R-RODBC-against-SQL-Server-tp20026479p20026479.html
Sent from the R devel mailing list archive at Nabble.com.
__
R-devel@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel
