8:00 – 4:00 SR

• Normal backups
• I tried making a full backup of the system using the following arguments:
  • mysqldump – u root -pxxxx –all-databases –max_allowed_packet=512M –routines > fullbackup.sql
• That appeared to work fine, creating a file 148,338KB big
• I tried to ingest the file in the new instance on the integration machine using:
  • mysql -u root -pxxxx < fullbackup.sql
• That gave the following error:
  • ERROR 2006 (HY000) at line 4729: MySQL server has gone away
• Line 4729 turns out to be “INSERT INTO `query_logs` VALUES(…), which is *huge*. Not sure what to do about that. I did check to see that the line isn’t truncated, so that’s not the problem. Just to make sure, I ran it again with the same message at the same line
• This post at stackOverflow suggests that it’s a max_packet_size problem. Going to try that. Changed from 1M to 12M as per the suggestion.
• Same error, but new line (6367). Going to try 24M
• Same error, but new line (6373). Going to try 512M, same as the mysqldump command..?
• Yay! That did it.
• Finished generating C/C++ and Flex svn statisitics. Interestingly, in the “lines committed” charts, you can see the difference between mature development and ongoing development:
• 

  Mature profile of server codebase

   

• 

  Ongoing rapid development of GUI

   

• Ok, back to unit tests.

   

8:00 – 4:00 SR

• Wow. It’s May. AND IT’S NOT RAINING!
• Copied over the new xampp to the integration machine and tried the “copy the  data directory” trick. No good. Tomorrow I’ll try doing it the right way. Need to make sure with Dong that the stored procedures are backed up along with everything else in a database.
• More Junit.
• Since reviews are coming up, I figured that I’d show what we’ve been doing. Using statsSVN, I generated a microsite for Java,  Flex and C/C++ development.
  • Note – currently only the Java folder is up. Everything else is still being processed. Apparently  StatsSVN is much faster with Java…

8:00 – 4:30 SR

• Copied over the new xampp, but the data files didn’t track. It lloks like I need to set the root and user passwords, then restore from backups. There may be a way to do that in one fell swoop, so I’m going to research that a bit. Put the old version back up.
• Got the code written in the junit code that should set up a test db for visibility_dev2 and visibility_scripting. Need to verify that it works and then start building up the tests.
• It didn’t work, but I imported and modified Dong’s ScriptRunner. That works just fine.
• Got completely derailed playing with LightTable (setup?). It is very cool, with the capability to run Java directly where it clojure can’t do the job :

  user=> (javax.swing.JOptionPane/showMessageDialog nil "Hello World")

  It also will act as a server to a web page by loading the following script:

  • <script type=’text/javascript’ id=’lt_ws’ src=’http://localhost:58683/socket.io/lighttable/ws.js’></script&gt;

8:00- 3:00 SR

• And I would’ve started at 7:30, but traffic was terrible. Two lanes of 95 shut down. Possibly both sides? 
• Backups
• Updated Java. Still waiting on MySQL
• Adding comments to ScriptFacades.
• A “standard list of metasyntactic variables used in syntax examples” often used in the United States is: foo, bar, baz, qux, quux, corge, grault, garply, waldo, fred, plugh, xyzzy, thud. The word foo occurs in over 330 RFCs and bar occurs in over 290. Wibble, wobble, wubble, Fred and flob are often used in the UK  (wikipedia)
• Done commenting and adding to method list. Testing in Eclipse after lunch.