I am trying to upgrade a 1.9 to 2.2.1. And while I can get so far I get stuck on the following upgrade sql statement:
update mdl_question_sessions set manualcommentformat = $1[array(0=>'1'),]
I know it is still running even though I see no activity at the command prompt after getting here as I looked in the pg_stat_activity table and see the active/open database session.
The mdl_question_sessions table for my site has over 12 million rows in.The upgrade has been cranking away on this part for over 4 hours now.
I am using the command line. I have increased the values for php's max execution time and max upload etc.I have removed the server/load balancer, etc from the equation, for the upgrade, by doing this all locally on my Windows machine.
Any help or suggestions would be apprecaited.