Re: MySQLDB - server has gone on blob insertion...

2010-06-03 Thread durumdara
Hi! No, there is no same program. I got this ref: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html I will try it. Thanks: dd -- http://mail.python.org/mailman/listinfo/python-list

Re: MySQLDB - server has gone on blob insertion...

2010-06-02 Thread Rami Chowdhury
On Tuesday 01 June 2010 12:46:40 John Nagle wrote: > durumdara wrote: > >>> When I tried to start this, I got error: > >>> _mysql_exceptions.OperationalError: (2006, 'MySQL server has gone > >>> away') > > Are you by any chance trying to do this on a HostGator account? > HostGator servers run

Re: MySQLDB - server has gone on blob insertion...

2010-06-01 Thread John Nagle
durumdara wrote: When I tried to start this, I got error: _mysql_exceptions.OperationalError: (2006, 'MySQL server has gone away') Are you by any chance trying to do this on a HostGator account? HostGator servers run a program which kills long MySQL transactions by executing MySQL "KILL" tra

Re: MySQLDB - server has gone on blob insertion...

2010-06-01 Thread durumdara
Hi! > > drop table blobs > create table blobs (whatever definition it had originally) It was a test. In PGSQL, PYSQLite that was: delete from blobs where (file_id in (select file_id from pics where dir_id=?)) So I need to delete only all blobs that processed. > > > > > When I tried to start th

Re: MySQLDB - server has gone on blob insertion...

2010-05-27 Thread John Nagle
Dennis Lee Bieber wrote: On Wed, 26 May 2010 11:30:41 +0200, Durumdara declaimed the following in gmane.comp.python.general: cursor.execute('delete from blobs;') Since that statement will delete EVERY record from the table "blobs", I believe it is common practice to replace it with

MySQLDB - server has gone on blob insertion...

2010-05-26 Thread Durumdara
Hi! I want to test my program that coded into PGSQL, and PySQLite. With these DBs I have problem on many blob deletion (2 hours) and compact/vacuum (1 hours)... So I'm trying to port my program, and before that making a test to check, which time needs to delete 1 GB of blobs. I installed MySQLDb