Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

memory error during csv export or count function #5

Open
digitalfox opened this issue Jul 24, 2014 · 0 comments
Open

memory error during csv export or count function #5

digitalfox opened this issue Jul 24, 2014 · 0 comments

Comments

@digitalfox
Copy link
Owner

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 [email protected]

    rocra_ref@rocrasc_taylor 

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant