Hey Ken, Do you get this issue right from the start or did it pop up later? Did you also try the solution offered by the log itself? I recall having to do that once before to circumvent MySQL connectivity issues.
On Wed, May 16, 2012 at 7:25 PM, Ken Ernst <[email protected]> wrote: > Hi, > Running oozie client build version: 2.3.2-cdh3u3 w/ MySQL as the store – > version 5.0.95. I am getting the below error. > > Exception, org.apache.oozie.store.StoreException: E0600: Could not get > connection, The last packet successfully received from the server was > 70,900,302 milliseconds ago. The last packet sent successfully to the server > was 70,900,302 milliseconds ago. is longer than the server configured value > of 'wait_timeout'. You should consider either expiring and/or testing > connection validity before use in your application, increasing the server > configured values for client timeouts, or using the Connector/J connection > property 'autoReconnect=true' to avoid this problem. > org.apache.oozie.store.StoreException: E0600: Could not get connection, The > last packet successfully received from the server was 70,900,302 milliseconds > ago. The last packet sent successfully to the server was 70,900,302 > milliseconds ago. is longer than the server configured value of > 'wait_timeout'. You should consider either expiring and/or testing connection > validity before use in your application, increasing the server configured > values for client timeouts, or using the Connector/J connection property > 'autoReconnect=true' to avoid this problem. > > My job does a bunch of imports from SQL using sqoop and starts out like this: > <fork name="fork"> > <path start="import-table1"/> > <path start="import-table2"/> > <path start="import-table3"/> > <path start="import-table4"/> > </fork> > > <action name="import-table1"> > <sub-workflow> > > <app-path>${nameNode}/user/${wf:user()}/${appRoot}/sqoop-import-table</app-path> > <propagate-configuration/> > <configuration> > <property> > <name>tableName</name> > <value> table1</value> > </property> > </configuration> > </sub-workflow> > <ok to="join"/> > <error to="email-sqoop-failure"/> > </action> > > <etc…> > > Thanks. > > Ken -- Harsh J
