Giter VIP home page Giter VIP logo

Comments (7)

hadley avatar hadley commented on July 26, 2024

Can you please provide the results of traceback()?

from rmysql.

13kay avatar 13kay commented on July 26, 2024
> 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.

hadley avatar hadley commented on July 26, 2024

Hmmm, I can't recreate this locally. Does "sdbi1ab87df67117" mean anything to you?

from rmysql.

13kay avatar 13kay commented on July 26, 2024

"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.

jeroen avatar jeroen commented on July 26, 2024

Which operating system are you using for the client/server? Which version of R do you have?

from rmysql.

13kay avatar 13kay commented on July 26, 2024

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.

hadley avatar hadley commented on July 26, 2024

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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.