Re: [R-sig-DB] RMySQL cannot allocate a new connection

[Dirk Eddelbuettel]

Paul,

I also bit me recently; can't quite recall the circumstances but it was
somehow related to an error.  What binds here, as far as a I know, is the
'open files' constraint from the OS and shell, not so much R's.

I do not know a way to increase it on a running session. Sorry.

Hth, Dirk

-- 
Dirk Eddelbuettel | e...@debian.org | http://dirk.eddelbuettel.com

___
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db

Re: [R-sig-DB] RMySQL cannot allocate a new connection

[Paul Gilbert]

But I cannot think why it would have just started. I've been running 
this code for years. I'm suspicious of the warning about pending rows, I 
have not seen that before either.  Do you know if the size of returned 
chunks is controlled at the client or server side, or both?


Thanks,
Paul

On 13-04-05 02:09 PM, Dirk Eddelbuettel wrote:


Paul,

I also bit me recently; can't quite recall the circumstances but it was
somehow related to an error.  What binds here, as far as a I know, is the
'open files' constraint from the OS and shell, not so much R's.

I do not know a way to increase it on a running session. Sorry.

Hth, Dirk



___
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db