Skip to content

memory error during csv export or count function #5

@digitalfox

Description

@digitalfox

Dears
I like pysql is a good software, however :

we have a this error runnin a export a big table , this table contain a 2716729 records for now

    rocra_ref@rocrasc_taylor csv  salida2 select  * from  VIC_CONCIFIN_COTEL; 
    -Traceback (most recent call last):
    \  File "/home/himer/.local/lib/python2.7/site-packages/pysql/pysqlshell.py", line 139, in onecmd
        return cmd.Cmd.onecmd(self, line)
      File "/usr/lib/python2.7/cmd.py", line 221, in onecmd
        return func(arg)
      File "/home/himer/.local/lib/python2.7/site-packages/pysql/pysqlshell.py", line 1405, in do_csv
        self.__executeSQL(sql, output="csv", fileName=fileName)
      File "/home/himer/.local/lib/python2.7/site-packages/pysql/pysqlshell.py", line 2053, in __executeSQL
        (result, moreRows) = self.db.execute(sql, fetch=False)
      File "/home/himer/.local/lib/python2.7/site-packages/pysql/pysqldb.py", line 154, in execute
        return (self.decodeData(self.cursor.fetchall()), False)
      File "/home/himer/.local/lib/python2.7/site-packages/pysql/pysqldb.py", line 310, in decodeData
        return [self.decodeData(i) for i in data]
      File "/home/himer/.local/lib/python2.7/site-packages/pysql/pysqldb.py", line 310, in decodeData
        return [self.decodeData(i) for i in data]
    MemoryError

    ==> Unhandled error. Sorry <==
    ------------------8<-------------------------------------
    ------------------8<-------------------------------------
    Pysql release: unknown
    cx Oracle release: 5.1.3
    Python release: 2.7.5+ (default, Feb 27 2014, 19:39:55)  [GCC 4.8.1]

    Please, send the text above to pysql@digitalfox.org

    rocra_ref@rocrasc_taylor 

and try a running a count of records for a table
and get this other error in the same session .

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions