RMySQL，获取错误-RS-DBI驱动程序警告:(获取行时出错) [英] RMySQL, fetch errors - RS-DBI driver warning: (error while fetching rows)

问题描述

我正在使用RMySQL从数据表中获取一些行(该表很大，因此我无法在此处发布它，但基本上包含一堆数字.总共10列和大约12,000行).运行fetch(con, n=-1)时出现以下错误: RS-DBI driver warning: (error while fetching rows)，服务器仅返回1713行.

I am using RMySQL to fetch some rows from a data table (the table is large so I cannot post it here but basically contains a bunch of numbers.. a total of 10 columns and about 12,000 rows). I get the following error when I run fetch(con, n=-1): RS-DBI driver warning: (error while fetching rows) and the server returns only 1713 rows.

如果我摆脱了某些正在获取的列，那么这似乎可以正常工作.有谁知道这可能与什么有关?我什至不知道从哪里开始调试.这可能是服务器端设置吗?我的R会话有足够的内存(20个演出).

If I get rid of some of the columns being fetched then this seems to work fine. Does anyone know what this can be related to? I don't even know where to start debugging. Could this be a server-side setting? My R session has more than enough memory (20 gigs).

推荐答案

每列是数字还是数字列表?也就是说，每一列有多少字节?

Is each column a number, or a list of numbers? That is, how many bytes are in each column?

我以前遇到过这个问题，当我遇到它时，是因为我试图过快地提取太多数据.我发现在这种情况下，有时可以使用n的较小值进行多次调用.再说一遍，我遇到麻烦的数据库中的行很大

I've run into this problem before, and when I've hit it, it was because I was trying to pull too much data too fast. I've found that in those cases, making multiple calls with smaller values of n can sometimes work. Then again, the rows in the databases I've had trouble with have been huge

这篇关于RMySQL，获取错误-RS-DBI驱动程序警告:(获取行时出错)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！