Comments (7)
Can you please provide the results of traceback()
?
from rmysql.
> dbWriteTable(con, 'mtcars', mtcars)
Error in .local(conn, statement, ...) :
sdbi157472631829' not found (Errcode: 22)
> traceback()
13: .Call(RS_MySQL_exec, conn@Id, as.character(statement))
12: .local(conn, statement, ...)
11: is(object, Cl)
10: is(object, Cl)
9: .valueClassTest(standardGeneric("dbSendQuery"), "DBIResult",
"dbSendQuery")
8: dbSendQuery(conn, statement, ...)
7: dbGetQuery(conn, sql)
6: dbGetQuery(conn, sql)
5: .local(conn, name, value, ...)
4: is(object, Cl)
3: is(object, Cl)
2: .valueClassTest({
standardGeneric("dbWriteTable")
}, "logical", "dbWriteTable")
1: dbWriteTable(con, "mtcars", mtcars)
from rmysql.
Hmmm, I can't recreate this locally. Does "sdbi1ab87df67117" mean anything to you?
from rmysql.
"sdbi1ab87df67117" change every time when i call dbWriteTable
and it means nothing for me
> con
<MySQLConnection:0,0>
> dbWriteTable(con, 'mtcars', mtcars)
Error in .local(conn, statement, ...) :
sdbi15ac41411c1' not found (Errcode: 22)
> dbListTables(con)
[1] "mtcars"
> dbGetQuery(con, 'select * from mtcars')
[1] row_names mpg cyl disp hp drat wt
[8] qsec vs am gear carb
<0 rows> (or 0-length row.names)
from rmysql.
Which operating system are you using for the client/server? Which version of R do you have?
from rmysql.
im using MariaDB on my windows 7 for test, and R is R version 3.1.2 (2014-10-31)
MariaDB [(none)]> status
--------------
F:\MariaDB10\bin\mysql.exe Ver 15.1 Distrib 10.0.15-MariaDB, for Win32 (x86)
Connection id: 11
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server: MariaDB
Server version: 10.0.15-MariaDB mariadb.org binary distribution
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: gbk
Conn. characterset: gbk
TCP port: 3306
Uptime: 49 min 23 sec
Threads: 6 Questions: 95 Slow queries: 0 Opens: 9 Flush tables: 1 Open tabl
es: 69 Queries per second avg: 0.032
> version
_
platform x86_64-w64-mingw32
arch x86_64
os mingw32
system x86_64, mingw32
status
major 3
minor 1.2
year 2014
month 10
day 31
svn rev 66913
language R
version.string R version 3.1.2 (2014-10-31)
nickname Pumpkin Helmet
from rmysql.
I'm closing since I can't reproduce locally, and I'm about to implement a better strategy for inserting data
from rmysql.
Related Issues (20)
- SSL CA fails HOT 1
- Error when installing RMysql on RHEL 7.3 HOT 3
- Query table of many DECIMAL columns causes error in terminal HOT 5
- RMysql encoding utf8 issue
- mysqlHasDefault() broken on Linux? HOT 1
- SSL - check status HOT 1
- Date datetype is written as text
- Document default database name in the RMySQL::mysqlHasDefault() function
- dbWriteTable fails without row_names column HOT 1
- Installing with Homebrew on OS X Sierra; cannot find RMySQL.so file it just created?
- Implement RStudio Connection Contract HOT 1
- Rows missing on inserting data frame with large character field
- RMySQL fails build with mariadb >10.4 HOT 12
- GenomicFeatures and RMySQL HOT 4
- Cannot connect to MySQL 8.0.11 HOT 3
- Can't install
- Failure to use ~/.my.cnf beginning with v0.10.14 HOT 3
- Unable to install RMySQL on macOS 10.13.6 HOT 7
- host not read from .my.cnf HOT 15
- connecting using SSL (client.flag=2048) to a RDS DB freezes forever HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from rmysql.