Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #72324 > unrolled thread

Re: Script suddenly stops

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: Script suddenly stops Paul McNett <paul@mcnettware.com> - 2014-05-30 15:03 -0700

#72324 — Re: Script suddenly stops

On 5/29/14, 7:47 PM, Chris wrote:
> I'm trying to read ten 200 MB textfiles into a MySQL MyISAM database
> (Linux, ext4). The script output is suddenly stopping, while the Python
> process is still running (or should I say sleeping?). It's not in top,
> but in ps visible.

Does it stop in the same place every time? How long are you waiting 
before giving up? Is it at all possible that it is the MySQL side that 
is blocking?

> Why is it stopping? Is there a way to make it continue, without calling
> "kill -9", deleting the processed lines and starting it again?

One thing to try (maybe, depending on whether it still fits into your 
requirements for a database transaction) is to increase the number of 
rows inserted before each commit.

> [1] http://pastebin.com/CxHCA9eB

It won't have any bearing, but those globals aren't necessary...


Paul

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web