Category Archives: Server

Phil 5.3.13

7:30 – 4:00 SR

  • Backups
  • Deployed new FA
  • Customer meeting. Dong has the list of bugs. Actually, things went pretty well. I think we’re on track for alpha deployment next week.
  • Test of DB upgrade on Integration?
    • Error saving a script. Line 589 in ScriptFacades.
  • Status Report for April
  • More Junit.

Phil 5.2.13

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.

     

Phil 5.1.13

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…

Phil 4.30.13

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:

Phil 4.29.13

8:00 – 12:00 OH

  • Class

12:00 – 4:00 SR

  • Test cases for ScriptFacades
  • Updating Java first.
  • I think I want to make the test cases create a “test” database and populate it in the setup, then destroy it at the end of the test. The .sql file can be in the assets. This does mean that the database access methods (_dbHelper? Others? have to know about this DB).

Phil 4.26.13

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.

Phil 4.25.13

7:30 – 3:30 SR

  • Backups
  • Add a “create” button to FA that makes a subproject by copying over all the project information (with “sub_n”) appended to the name/id
  • Change the SOW column to say “MIPR Description”
  • Add “calculate” button for project budget overview so we don’t have to trap lots of editing events
  • Finished and tested the following:
    • getDashTemplateXml()
    • setDashTemplateXml()

Phil 4.24.13

8:00 – 4:00 – SR

  • backups
  • Installed new version of FA
  • table_dash_templates
    • name
    • xml_layout_template
    • xml_variables – gives something to iterate over
  • Nearly done. Finish tomorrow, though I have to build test classes.
  • New version of FA to bring in.

Phil 4.22.13

8:00 – 4:00 SR

  • Backups and some security updates.
  • After my thrill-packed afternoon of setting up my IDE so that I could do some work, it’s back to my regular IDE. Ah well, it’s good to keep everything up to date at home.
  • Downloading and installing the new Cygwin. No, I lied. The download stops about 33% in. Grr.
  • I had an interesting web.xml problem for the last few days that was bothering me:Description Resource Path Location Type 
     The content of element type "web-app" must match 
"(icon?,display-name?,description?,distributable?,context-param*,filter*,
filter-mapping*,listener*,servlet*,servlet-mapping*,session-config?,mime-mapping*,
welcome-file-list?,error-page*,taglib*,resource-env-ref*,
resource-ref*,security-constraint*,login-config?,security-role*,env-entry*,
ejb-ref*,ejb-local-ref*)". web.xml 
/VisibilityScriptingServer/src/main/webapp/WEB-INF line 5 XML Problem
  • What this means is that some of the elements are out of order. If you match the order of the elements in the xml file to the list in the error message, that completely fixes it. In my case, I had the <servlet> and the <servlet-mapping> tags associated, since that helps readability. But no, we don’t get to do that. Moving all the <servlet-mapping> tags to just before the <welcome-file-list> element did the trick. Yay!
  • Finished getUserId() and getRoleId(). Starting on updateVizTable()

Phil 4.19.13

7:30 – 3:30 SR

  • Went home yesterday to find my phone and internet knocked out. Oddly, after a Verizon reset the cable came back. Why that works and the other two don’t I have no idea. Service is scheduled between 1:00 – 5:00 so it’s either work from home or leave.
  • Backups
  • More work on changing the visibility_dev2 db on the fly.
  • Need to contact Jeremy (Shawn?) about a charge number.
  • Downloading everything so that I can work from home without an internet connection
    • Project files (zipped and workspace)
    • new xampp
    • sql db (VSS and VD2)
    • notes
    • Juno
  • Got home and put the old FIOS battery back in and bounced the system. I now have TV and internet. And literally, as I was typing this, the connection dropped out. Correlation without causation. And it’s back now….
    • Ticket: mddq03c37es
    • 12:32 – restored
    • 1:27 – down (could not find host)
    • 1:29 – restored.
    • 2:34 – down
    • 2:36 – up
    • 4:09 – down for two minutes
  • Building environment. Unzipping is really slow. And the workspace I copied over isn’t working, so I have to get my stuff from subversion, which means installing that…
  • But everything is running. And it’s 3:10. I got started around noon. Pity we can’t bill Verizon for this.

Phil 4.18.13

7:30 – 3:30 SR

  • Deployed test version of FA and new versions of PPM, PA and VSS.
  • The “Total” bug in PPM is half fixed.
  • Long discussion about FA. Our job is to determine how to work the FYear column (hopefully) into the existing database.

Phil 4.17.13

8:00 – SR

  • Backups
  • There is a Viztool review set for tomorrow from 7:30 – 9:00. Need to check with Dong about having a deploy. The Version Checker in FlexUtils45 had to be updated to pass namespaces down to the SingletonDataDictionary. Though I’m not sure that I’ve checked that in yet.
  • Is it not possible to open an unfunded project? John Anderson’s GCC project will not open in PA or in the PPM project management screen. However, when the Project->Enter Monthly Status is clicked and the same project is selected in the folowing dialog and opened, it’s possible to access. Lenny just checked, and the project is unfunded. I know that we had some additional info and locks in a previous version. But there is nothing now (March 8 2013 at 6:07 AM).
  • Fixed some bugs in VersionTracker.
  • Started working on what the visibility_dev2 data functions should be:
  • VssNewMethods

Phil 4.16.13

8:00 – 4:00 SR

  • Backups
  • Lenny found a possible math problem with PPM, where sub project allocations are not summing correctly
  • Showed Lenny how to delete incorrect project info using the DB utils
  • Working on getting VSSTestbed up and running.
    • Adding a Web project to a server is easy, though you do have to start (possibly refresh) the server to get the files deployed to the server instance
    • The only place that it seems that you can add projects to be deployed is in the Deployment Assembly dialog in the Properties. Add any jar files or projects here. Note that if you ass a project, that the system builds a jar file for you here and deploys that to the WEB-INF/lib directory. There do not have to be any classes.
    • VSSTestbedConfig

4.15.13

8:00 – 10:00, 2:00 – 4:00 SR

  • Backups,
  • Financial
  • Starting to look at the date rollover script issue.
  • Getting VisibilityScripting to run on the Eclipse server – Looks like I have to create a new Dynamic Web project and can’t retrofit that into VSS. I think this is starting to look like a tomorrow thing…

Phil 4.12.13

8:00 – 3:30 SR

  • Tried out FA and version tracker. VT is not creating tables, but we don’t know why. Need to add some tracking.
  • Found out that the backup of visibility_scripting.sql was corrupted because the packet size was too small. Wound up using the –max_allowed_packet=512M argument as shown here.