calloc error issued by sqlQuery
Ok. I just solved it by re-installing RODBC package. The problem was that while RODBC was installed, I replaced the ODBC linux driver, and upgraded the driver manager 'unixODBC'. Therefore, RODBC had to be Removed and installed again. Thanks Idit -----Original Message----- From: Seth Falcon [mailto:seth at userprimary.net] Sent: Sunday, June 03, 2012 6:33 PM To: Dirk Eddelbuettel Cc: Idit Buch; r-sig-db at r-project.org Subject: Re: [R-sig-DB] calloc error issued by sqlQuery
On Sun, Jun 3, 2012 at 6:54 AM, Dirk Eddelbuettel <edd at debian.org> wrote:
On 3 June 2012 at 12:04, Idit Buch wrote: | Hi, | | I'm using R version 2.14.1 on Linux (Centos) and trying to issue a "select * from ..." query using sqlQuery(...). | I then receive the following error: | Error in odbcQuery(channel, query, rows_at_time) : | ? Calloc could not allocate memory (18446744073709551616 of 22816 | bytes) [...] | Any idea ? Yes. Your query appears to generate a result set which would be ? ? 18446744073709551616 bytes large. ?So I suggest you change your query with suitable 'where ...' or 'limit N' clauses.
That's a rather unlikely root cause as it suggests that answering the query requires an allocation of 16,384 petabytes. It seems more likely to me that something has triggered an allocation with uninitialized memory. Running the query with R under gdb should help. -- Seth Falcon | @sfalcon | http://userprimary.net/