I have an SQL command that insert data into a table by joining data from several tables. The command started working at 13:25:05 on 2018-01-14. And now, 15:56 on 2018-01-15, it's still not yet finished. I checked if there are any change with the database file but my database file production.db and the journal file production.db-journal have no update since yesterday as below

4608 Jan 14 13:25 production.db-journal

135711874048 Jan 14 17:41 production.db

Similar SQL statement was done before with the same target table but different number of joined tables. Last time, it took around 3 hours for the operation. And this time I expected it to take around 4 hours. But now, it's almost a day.

Does anyone know how to see if SQLite is still working or it's already crash?

  • Does it use any CPU or I/O? – CL. Jan 18 '18 at 19:21
  • How to monitor this? – Jessada Thutkawkorapin Jan 31 '18 at 12:12
  • top – CL. Jan 31 '18 at 12:13
  • The whole process had been done in a remote HPC server. The only output I could monitored are the database file, the -journal file, the standard output, and the standard error. There was nothing in the standard output and no SQLite error/warning in the standard error. Another thing I could see is that HPC still said that the process was still alive. – Jessada Thutkawkorapin Jan 31 '18 at 12:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.