Server-side Java Problems and Solutions

Using rsync to deploy from staging server to production

2012-01-25T12:21:00.001-08:00

cat rsync_a_to_b.sh
# script that synchronizes files from location A to location B via a local temp directory
USER_A=ec2-user
HOST_A="$1"
PATH_A="$2"
USER_B=ec2-user
HOST_B="$3"
PATH_B="$4"

if [ -z $HOST_A ]; then # -n tests to see if the argument is non empty
echo "Missing source host argument, usage: [cmd] sourceHost sourcePath targetHost targetPath"
exit 1
fi

if [ -z $PATH_A ]; then # -n tests to see if the argument is non empty
echo "Missing source path argument, usage: [cmd] sourceHost sourcePath targetHost targetPath"
exit 1
fi

if [ -z $HOST_B ]; then # -n tests to see if the argument is non empty
echo "Missing target host argument, usage: [cmd] sourceHost sourcePath targetHost targetPath"
exit 1
fi

if [ -z $PATH_B ]; then # -n tests to see if the argument is non empty
echo "Missing target path argument, usage: [cmd] sourceHost sourcePath targetHost targetPath"
exit 1
fi

LOCAL_DIR=/tmp/rsync/${HOST_A}${PATH_A}

echo STEP 1: Syncing from ${HOST_A}:${PATH_A} to localhost:${LOCAL_DIR}..
mkdir -p ${LOCAL_DIR}

rsync -e ssh -rcav --delete-after \
${USER_A}@${HOST_A}:${PATH_A} \
--exclude '.svn/**' \
${LOCAL_DIR}

echo STEP 2: Syncing from localhost:${LOCAL_DIR} to ${HOST_B}:${PATH_B}..

rsync -e ssh -rcav --delete-after \
$LOCAL_DIR/* \
${USER_B}@${HOST_B}:${PATH_B}

echo DONE.

------------------------------

Then write a script to use the above function for every directory, like this:

cat push_stage_to_prod.sh
BASE=./

SOURCE_HOST=[mystagehost]
TARGET_HOST=[myprodhost]

echo Pushing entire application codebase from ${SOURCE_HOST} to ${TARGET_HOST}...

$BASE/rsync_a_to_b.sh $SOURCE_HOST \
'/my/app/tomcat/webapps/ROOT/WEB-INF/*.xml' \
$TARGET_HOST \
/my/app/tomcat/webapps/ROOT/WEB-INF/

$BASE/rsync_a_to_b.sh $SOURCE_HOST \
'/my/app/tomcat/webapps/ROOT/WEB-INF/classes/*' \
$TARGET_HOST \
/my/app/tomcat/webapps/ROOT/WEB-INF/classes/

$BASE/rsync_a_to_b.sh $SOURCE_HOST \
'/my/app/tomcat/webapps/ROOT/WEB-INF/lib/*' \
$TARGET_HOST \
/my/app/tomcat/webapps/ROOT/WEB-INF/lib/

$BASE/rsync_a_to_b.sh $SOURCE_HOST \
'/my/app/lib/m2reposymlink/*' \
$TARGET_HOST \
/my/app/lib/m2reposymlink/

$BASE/rsync_a_to_b.sh $SOURCE_HOST \
'/my/app/webcode/*' \
$TARGET_HOST \
/my/app/webcode/

File deployment script that uses rsync

2012-01-25T12:19:00.000-08:00

cat function_rsync.sh
LOCAL_SYNC_PATH="$1"
REMOTE_USER="$2"
REMOTE_HOST="$3"
REMOTE_PATH="$4"

echo user=$REMOTE_USER
echo ..syncing directory "$LOCAL_SYNC_PATH" to server ${REMOTE_HOST}..

rsync -e ssh -rcav --delete-after \
$LOCAL_SYNC_PATH \
${REMOTE_USER}@${REMOTE_HOST}:${REMOTE_PATH}

Local subversion backup

2012-01-25T12:16:00.000-08:00

# Settings
LOCALREPO='/root/backup/[myapp]/svn_repo'
REMOTEHOST='[myhost]'
REMOTEREPO='/var/www/svn/repos/[myapp]'
REMOTEUSER='[myuser]'

### WARNING: Danger Will Robinson ###
### DO NOT EDIT BELOW THIS LINE ###

LOCALVER=`/usr/bin/svnlook youngest ${LOCALREPO}`
REMOTEVER=`/usr/bin/ssh ${REMOTEUSER}@${REMOTEHOST} /usr/bin/svnlook youngest ${REMOTEREPO}`

echo "Local version is ${LOCALVER}"
echo "Remote version is ${REMOTEVER}"

if [ "$REMOTEVER" -gt "$LOCALVER" ];
then
echo "Remote version is greater than local version"
START=$(echo "${LOCALVER} + 1" | /usr/bin/bc -l)
/usr/bin/ssh ${REMOTEUSER}@${REMOTEHOST} /usr/bin/svnadmin dump --incremental --deltas --revision ${START}:${REMOTEVER} ${REMOTEREPO} | /usr/bin/svnadmin load --ignore-uuid ${LOCALREPO}
else
echo "Both local and remote version have the same data"
fi

--------
Schedule with this cron file:
cat myapp_svn_backup.cron
#!/bin/bash
cd /root/backup/[myapp]/svn_logs
logfilename="subversion_backup_"`eval date +%Y%m%d`".log"
/root/backup/[myapp]/run_svn_backup.sh > $logfilename

Local mysql backups (one file per table)

2012-01-25T12:13:00.000-08:00

> cat run_mysql_backup.sh
export backupsdir=/root/backup/[myapp]/mysql_backups
export d=`eval date +%Y%m%d`
mkdir -p $backupsdir/$d
for i in `echo "show tables" | mysql -h[host] -u root -p[pass] [dbname]|grep -v Tables_in_`;
do
echo $i; mysqldump --add-drop-table --allow-keywords -q -a -c -h[host] -u root -p[pass] [dbname] $i > $backupsdir/$d/$i.sql
rm -f $backupsdir/$d/$i.sql.gz
gzip $backupsdir/$d/$i.sql
done

Working with Amazon AWS EC2 EBS RAID volumes

2012-01-25T11:59:00.000-08:00

HOW TO MOUNT AN EBS VOLUME
cat /proc/partitions
mke2fs -F -j /dev/sdp
mkdir /[dir]
mount /dev/sdh /[dir]

WORKING WITH MDADM LINUX SOFTWARE RAID
http://www.thatsgeeky.com/2010/09/setting-up-a-raid-on-ec2/
http://hughperkins.com/techblog/2009/12/02/using-mdadm-software-raid-with-ec2-ebs-disks/
cat /etc/mdadm.conf # see config
cat /proc/mdstat # see status
mdadm --detail --scan >> /etc/mdadm.conf # generate new config line
ALT: mdadm --examine --scan [--config=mdadm.conf] >> mdadm.conf # generate new config line
mdadm --assemble --verbose /dev/md0 /dev/sdc1 /dev/sdd1 /dev/sda1 /dev/sdb1 # assemble an array with the listed volumes in order
mdadm --assemble --scan # Don't name the drives as mdadm will scan for the UUID and assemble from the ones that match the array UUID.
mdadm --create --verbose /dev/md0 --level=0 --raid-devices=2 /dev/sdh1 /dev/sdh2 # create a new array

BACKUPS
nohup cp -R /solr_data/ /BACKUP/[dir]/ &

ATTACHING AND DETACHING EC2 VOLUMES
http://alestic.com/2009/06/ec2-ebs-raid
echo solr0
ec2-detach-volume vol-f01b7a99
ec2-attach-volume -d /dev/sdf -i i-dc5c7cb1 vol-f01b7a99

Automated backup of Amazon AWS EBS volumes onto EBS snapshots

2012-01-25T11:51:00.000-08:00

Use an ubuntu server such as Amazon AMI: alestic-git-server-ubuntu-10.10-maverick-i386-20110322 (ami-1250a27b)

Find AWS accedd key id/secret under AWS web interface, My Account, Security Credentials

Create file [app name].sh with contents:
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
ec2-consistent-snapshot \
--aws-access-key-id XXXX \
--aws-secret-access-key XXXX \
--description "[app name] [directory path] $(date +'%Y-%m-%d %H:%M:%S') UTC" \
vol-XXXX

Schedule cron:
crontab -e
0 5 * * * /home/ubuntu/backup-[app name].sh

Reference:
http://alestic.com/2011/02/ec2-consistent-snapshot-sceencast
http://aws.amazon.com/articles/1663
http://serverfault.com/questions/315930/why-cant-xfs-freeze-find-this-directory-when-called-with-ec2-consistent-snapsho

Other ideas here:
http://www.agileweboperations.com/poor-mans-automated-snapshots-for-ec2

Test post

2011-09-06T08:04:00.001-07:00

Testing post

Recursively fetch directory via FTP using WGET

2011-06-03T13:17:00.001-07:00

wget --user=[user] --password=[pass] -r ftp://ftp.somesite.com/dirA/dirB/*

Just add the "-N" option to wget to ignore files older than what you have locally. You could also add the "-nc" to completely skip a file if it already exists, even if the one on FTP is newer.
http://superuser.com/questions/58300/latest-file-from-ftp-server-using-wget-or-some-other-way

bash script for copying and chown-ing contents of /home

2011-06-03T08:59:00.000-07:00


BASE="/home/ec2-user/feeds/transit"

for file in /home/*
do
  if [ "$file" != "/home/ec2-user" ]; then
    echo Copying ${file} to ${BASE}${file}
    mkdir -p ${BASE}${file}
    sudo bash -c "cp -vr ${file}/* ${BASE}${file}"
  fi
done
sudo bash -c "chown -vR ec2-user:ec2-user $BASE/*"

java awt headless fonts not installed on openjdk by default

2011-03-11T13:44:00.000-08:00

On this Linux box:
$ uname -a
Linux ip-10-202-214-140 2.6.34.7-56.40.amzn1.i686 #1 SMP Fri Oct 22 18:48:33 UTC 2010 i686 i686 i386 GNU/Linux

We got this exception on when trying to generate a PDF from a URL using the PDF library from org.zefer.pd4ml:

java.lang.Error: Probable fatal error:No fonts found.
sun.font.FontManager.getDefaultPhysicalFont(FontManager.java:1088)
sun.font.FontManager.initialiseDeferredFont(FontManager.java:960)
sun.font.FontManager.findOtherDeferredFont(FontManager.java:899)
sun.font.FontManager.findDeferredFont(FontManager.java:916)
sun.font.FontManager.findFont2D(FontManager.java:1904)
....
org.zefer.pd4ml.PD4ML.render(Unknown Source)
org.zefer.pd4ml.PD4ML.render(Unknown Source)
com.boathouseinc.project.template.pdf.UrlToPdfServlet.doGet(UrlToPdfServlet.java:84)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

Problem was resolved by installing liberation-fonts thusly:
sudo yum install liberation-fonts

Reference:
https://bugzilla.redhat.com/show_bug.cgi?id=478480

java.lang.NoSuchMethodError: javax.persistence.OneToMany.orphanRemoval()

2011-02-22T14:16:00.000-08:00

For me, this error was caused by a conflict within Eclipse:


org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [spring-data.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [spring-data.xml]: Invocation of init method failed; nested exception is java.lang.NoSuchMethodError: javax.persistence.OneToMany.orphanRemoval()Z
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
 at com.boathouse.autosite.BaseSpringContextAwareTestCase.setUp(BaseSpringContextAwareTestCase.java:30)
 at junit.framework.TestCase.runBare(TestCase.java:125)
 at junit.framework.TestResult$1.protect(TestResult.java:106)
 at junit.framework.TestResult.runProtected(TestResult.java:124)
 at junit.framework.TestResult.run(TestResult.java:109)
 at junit.framework.TestCase.run(TestCase.java:118)
 at junit.framework.TestSuite.runTest(TestSuite.java:208)
 at junit.framework.TestSuite.run(TestSuite.java:203)
 at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
 at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [spring-data.xml]: Invocation of init method failed; nested exception is java.lang.NoSuchMethodError: javax.persistence.OneToMany.orphanRemoval()Z
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
 ... 26 more
Caused by: java.lang.NoSuchMethodError: javax.persistence.OneToMany.orphanRemoval()Z
 at org.hibernate.cfg.AnnotationBinder.processElementAnnotations(AnnotationBinder.java:1912)
 at org.hibernate.cfg.AnnotationBinder.processIdPropertiesIfNotAlready(AnnotationBinder.java:796)
 at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:707)
 at org.hibernate.cfg.Configuration$MetadataSourceQueue.processAnnotatedClassesQueue(Configuration.java:3977)
 at org.hibernate.cfg.Configuration$MetadataSourceQueue.processMetadata(Configuration.java:3931)
 at org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:1368)
 at org.hibernate.cfg.Configuration.buildMappings(Configuration.java:1345)
 at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:717)
 at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
 ... 33 more

UPDATE: Scratch the conclusion above. Turned out that I had a maven dependency on persistence-api-1.0.jar after all. I still don't understand why it didn't show up on eclipse or mvn dependency:tree. Perhaps it was because the sub-component dependency specified <provided>true</provided>. Further info here.

Iterating over Map in Freemarker

2011-01-04T08:28:00.000-08:00

Imagine you have a Map of car dealers and vehicles:


Map<String, List<Vehicle>> vehiclesByDealer = new TreeMap<String, List<Vehicle>>();

Turns out it can be tricky to iterate over such a Map in Freemarker. As a workaround, add the keySet to the Model as a separate String list:


mv.addObject("vehiclesByDealerName", vehiclesByDealer);
mv.addObject("dealerNames", vehiclesByDealer.keySet());

Then iterate like this:


<#list dealerNames as dealerName>
	<#assign vehicles = vehiclesByDealerName[dealerName] />
...
</#list>

A failed attempt to recover a corrupt solr / lucene index with a missing segments_N file

2010-07-08T07:34:00.000-07:00

Basic problem:


SEVERE: Could not start SOLR. Check solr/home property
java.lang.RuntimeException: java.io.FileNotFoundException: /solr_data/data/index/segments_l2b (No such file or directory)
 at org.apache.solr.core.SolrCore.getSearcher(SolrCore.java:1051)
 at org.apache.solr.core.SolrCore.(SolrCore.java:565)
 at org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:130)
 at org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:83)
 at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:275)
 at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:397)
 at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:108)
 at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3800)
 at org.apache.catalina.core.StandardContext.start(StandardContext.java:4450)
 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
 at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)
 at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556)
 at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491)
 at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
 at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
 at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
 at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
 at org.apache.catalina.core.StandardService.start(StandardService.java:516)
 at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.io.FileNotFoundException: /solr_data/data/index/segments_l2b (No such file or directory)
 at java.io.RandomAccessFile.open(Native Method)
 at java.io.RandomAccessFile.(RandomAccessFile.java:212)
 at org.apache.lucene.store.SimpleFSDirectory$SimpleFSIndexInput$Descriptor.(SimpleFSDirectory.java:77)
 at org.apache.lucene.store.SimpleFSDirectory$SimpleFSIndexInput.(SimpleFSDirectory.java:107)
 at org.apache.lucene.store.NIOFSDirectory$NIOFSIndexInput.(NIOFSDirectory.java:93)
 at org.apache.lucene.store.NIOFSDirectory.openInput(NIOFSDirectory.java:69)
 at org.apache.lucene.store.FSDirectory.openInput(FSDirectory.java:671)
 at org.apache.lucene.index.SegmentInfos.read(SegmentInfos.java:236)
 at org.apache.lucene.index.DirectoryReader$1.doBody(DirectoryReader.java:71)
 at org.apache.lucene.index.SegmentInfos$FindSegmentsFile.run(SegmentInfos.java:704)
 at org.apache.lucene.index.DirectoryReader.open(DirectoryReader.java:68)
 at org.apache.lucene.index.IndexReader.open(IndexReader.java:468)
 at org.apache.lucene.index.IndexReader.open(IndexReader.java:309)
 at org.apache.solr.core.StandardIndexReaderFactory.newReader(StandardIndexReaderFactory.java:37)
 at org.apache.solr.core.SolrCore.getSearcher(SolrCore.java:1040)
 ... 30 more

Initial diagnosis:

Initial diagnosis showed that the segments_N file did not exist. The CheckIndex tool would not run, it reported the same problem as above. I had a bunch of index data files with lots of data in them:


-rw-r--r-- 1 root root 8028603002 Jul  3 20:27 _6l0.fdt
-rw-r--r-- 1 root root   14156172 Jul  3 20:27 _6l0.fdx
-rw-r--r-- 1 root root        328 Jul  3 20:21 _6l0.fnm
-rw-r--r-- 1 root root  869412416 Jul  3 20:33 _6l0.frq
-rw-r--r-- 1 root root    7078088 Jul  3 20:33 _6l0.nrm
-rw-r--r-- 1 root root 1749950441 Jul  3 20:33 _6l0.prx
-rw-r--r-- 1 root root    2428589 Jul  3 20:33 _6l0.tii
-rw-r--r-- 1 root root  194919244 Jul  3 20:33 _6l0.tis
-rw-r--r-- 1 root root    6867338 Jul  3 20:34 _6l0.tvd
-rw-r--r-- 1 root root 1516183431 Jul  3 20:34 _6l0.tvf
-rw-r--r-- 1 root root   28312340 Jul  3 20:34 _6l0.tvx
-rw-r--r-- 1 root root       3943 Jul  7 17:00 _6l0_14u.del
-rw-r--r-- 1 root root 3588947105 Jul  4 10:16 _a64.fdt
-rw-r--r-- 1 root root    5950556 Jul  4 10:16 _a64.fdx
-rw-r--r-- 1 root root        328 Jul  4 10:13 _a64.fnm
-rw-r--r-- 1 root root  388042305 Jul  4 10:19 _a64.frq
-rw-r--r-- 1 root root    2975280 Jul  4 10:19 _a64.nrm
-rw-r--r-- 1 root root  786393928 Jul  4 10:19 _a64.prx
-rw-r--r-- 1 root root    1332607 Jul  4 10:19 _a64.tii
-rw-r--r-- 1 root root  106349618 Jul  4 10:19 _a64.tis
-rw-r--r-- 1 root root    2898023 Jul  4 10:21 _a64.tvd
-rw-r--r-- 1 root root  660740410 Jul  4 10:21 _a64.tvf
-rw-r--r-- 1 root root   11901108 Jul  4 10:21 _a64.tvx
-rw-r--r-- 1 root root        427 Jul  7 16:55 _a64_3x.del
-rw-r--r-- 1 root root 4063439055 Jul  5 08:35 _fyc.fdt
-rw-r--r-- 1 root root    6684556 Jul  5 08:35 _fyc.fdx
-rw-r--r-- 1 root root        328 Jul  5 08:30 _fyc.fnm
-rw-r--r-- 1 root root  442166844 Jul  5 08:39 _fyc.frq
-rw-r--r-- 1 root root    3342280 Jul  5 08:39 _fyc.nrm
-rw-r--r-- 1 root root  873120822 Jul  5 08:39 _fyc.prx
-rw-r--r-- 1 root root    1535756 Jul  5 08:39 _fyc.tii
-rw-r--r-- 1 root root  123009510 Jul  5 08:39 _fyc.tis
-rw-r--r-- 1 root root    3171898 Jul  5 08:40 _fyc.tvd
-rw-r--r-- 1 root root  760721721 Jul  5 08:40 _fyc.tvf
-rw-r--r-- 1 root root   13369108 Jul  5 08:40 _fyc.tvx
-rw-r--r-- 1 root root        340 Jul  7 16:55 _fyc_35.del
-rw-r--r-- 1 root root 3774135320 Jul  6 08:30 _lwv.fdt
-rw-r--r-- 1 root root    6003948 Jul  6 08:30 _lwv.fdx
-rw-r--r-- 1 root root        328 Jul  6 08:26 _lwv.fnm
-rw-r--r-- 1 root root  418485969 Jul  6 08:34 _lwv.frq
-rw-r--r-- 1 root root    3001976 Jul  6 08:34 _lwv.nrm
-rw-r--r-- 1 root root  843268283 Jul  6 08:34 _lwv.prx
-rw-r--r-- 1 root root    1385423 Jul  6 08:34 _lwv.tii
-rw-r--r-- 1 root root  111141259 Jul  6 08:34 _lwv.tis
-rw-r--r-- 1 root root    2820840 Jul  6 08:36 _lwv.tvd
-rw-r--r-- 1 root root  717490764 Jul  6 08:36 _lwv.tvf
-rw-r--r-- 1 root root   12007892 Jul  6 08:36 _lwv.tvx
-rw-r--r-- 1 root root         38 Jul  7 16:54 _lwv_8.del
-rw-r--r-- 1 root root  404238685 Jul  6 11:23 _mlu.fdt
-rw-r--r-- 1 root root     208748 Jul  6 11:23 _mlu.fdx
-rw-r--r-- 1 root root        227 Jul  6 11:23 _mlu.fnm
-rw-r--r-- 1 root root   46234520 Jul  6 11:24 _mlu.frq
-rw-r--r-- 1 root root      78283 Jul  6 11:24 _mlu.nrm
-rw-r--r-- 1 root root  106629909 Jul  6 11:24 _mlu.prx
-rw-r--r-- 1 root root     196486 Jul  6 11:24 _mlu.tii
-rw-r--r-- 1 root root   15606446 Jul  6 11:24 _mlu.tis
-rw-r--r-- 1 root root      51755 Jul  6 11:24 _mlu.tvd
-rw-r--r-- 1 root root   78839439 Jul  6 11:24 _mlu.tvf
-rw-r--r-- 1 root root     417492 Jul  6 11:24 _mlu.tvx
-rw-r--r-- 1 root root         15 Jul  6 12:14 _mlu_1.del
-rw-r--r-- 1 root root  309050678 Jul  7 16:13 _n6y.fdt
-rw-r--r-- 1 root root     165844 Jul  7 16:13 _n6y.fdx
-rw-r--r-- 1 root root        227 Jul  7 16:13 _n6y.fnm
-rw-r--r-- 1 root root   36044993 Jul  7 16:14 _n6y.frq
-rw-r--r-- 1 root root      62194 Jul  7 16:14 _n6y.nrm
-rw-r--r-- 1 root root   81168504 Jul  7 16:14 _n6y.prx
-rw-r--r-- 1 root root     161925 Jul  7 16:14 _n6y.tii
-rw-r--r-- 1 root root   12783522 Jul  7 16:14 _n6y.tis
-rw-r--r-- 1 root root      41096 Jul  7 16:14 _n6y.tvd
-rw-r--r-- 1 root root   61007940 Jul  7 16:14 _n6y.tvf
-rw-r--r-- 1 root root     331684 Jul  7 16:14 _n6y.tvx
-rw-r--r-- 1 root root  190234359 Jul  7 16:45 _nbf.fdt
-rw-r--r-- 1 root root     272564 Jul  7 16:45 _nbf.fdx
-rw-r--r-- 1 root root        328 Jul  7 16:45 _nbf.fnm
-rw-r--r-- 1 root root   20098506 Jul  7 16:45 _nbf.frq
-rw-r--r-- 1 root root     136284 Jul  7 16:45 _nbf.nrm
-rw-r--r-- 1 root root   43187014 Jul  7 16:45 _nbf.prx
-rw-r--r-- 1 root root     103893 Jul  7 16:45 _nbf.tii
-rw-r--r-- 1 root root    8123849 Jul  7 16:45 _nbf.tis
-rw-r--r-- 1 root root     126312 Jul  7 16:45 _nbf.tvd
-rw-r--r-- 1 root root   35035417 Jul  7 16:45 _nbf.tvf
-rw-r--r-- 1 root root     545124 Jul  7 16:45 _nbf.tvx
-rw-r--r-- 1 root root   82107318 Jul  7 16:55 _nd8.fdt
-rw-r--r-- 1 root root     136068 Jul  7 16:55 _nd8.fdx
-rw-r--r-- 1 root root        328 Jul  7 16:55 _nd8.fnm
-rw-r--r-- 1 root root    8642891 Jul  7 16:55 _nd8.frq
-rw-r--r-- 1 root root      68036 Jul  7 16:55 _nd8.nrm
-rw-r--r-- 1 root root   17964715 Jul  7 16:55 _nd8.prx
-rw-r--r-- 1 root root      60156 Jul  7 16:55 _nd8.tii
-rw-r--r-- 1 root root    4671427 Jul  7 16:55 _nd8.tis
-rw-r--r-- 1 root root      69422 Jul  7 16:56 _nd8.tvd
-rw-r--r-- 1 root root   15417989 Jul  7 16:56 _nd8.tvf
-rw-r--r-- 1 root root     272132 Jul  7 16:56 _nd8.tvx
-rw-r--r-- 1 root root   46219469 Jul  7 16:58 _ndo.fdt
-rw-r--r-- 1 root root      62964 Jul  7 16:58 _ndo.fdx
-rw-r--r-- 1 root root        328 Jul  7 16:58 _ndo.fnm
-rw-r--r-- 1 root root    4357258 Jul  7 16:58 _ndo.frq
-rw-r--r-- 1 root root      31484 Jul  7 16:58 _ndo.nrm
-rw-r--r-- 1 root root   10196509 Jul  7 16:58 _ndo.prx
-rw-r--r-- 1 root root      33580 Jul  7 16:58 _ndo.tii
-rw-r--r-- 1 root root    2566267 Jul  7 16:58 _ndo.tis
-rw-r--r-- 1 root root      31172 Jul  7 16:58 _ndo.tvd
-rw-r--r-- 1 root root    7756092 Jul  7 16:58 _ndo.tvf
-rw-r--r-- 1 root root     125924 Jul  7 16:58 _ndo.tvx
-rw-r--r-- 1 root root   31234528 Jul  7 17:00 _ndz.fdt
-rw-r--r-- 1 root root      38196 Jul  7 17:00 _ndz.fdx
-rw-r--r-- 1 root root        328 Jul  7 17:00 _ndz.fnm
-rw-r--r-- 1 root root    2689685 Jul  7 17:00 _ndz.frq
-rw-r--r-- 1 root root      19100 Jul  7 17:00 _ndz.nrm
-rw-r--r-- 1 root root    6729134 Jul  7 17:00 _ndz.prx
-rw-r--r-- 1 root root      20814 Jul  7 17:00 _ndz.tii
-rw-r--r-- 1 root root    1572257 Jul  7 17:00 _ndz.tis
-rw-r--r-- 1 root root      18936 Jul  7 17:00 _ndz.tvd
-rw-r--r-- 1 root root    4777281 Jul  7 17:00 _ndz.tvf
-rw-r--r-- 1 root root      76388 Jul  7 17:00 _ndz.tvx
-rw-r--r-- 1 root root         15 Jul  7 17:00 _ndz_1.del
-rw-r--r-- 1 root root    3143760 Jul  7 17:00 _ne0.fdt
-rw-r--r-- 1 root root       1004 Jul  7 17:00 _ne0.fdx
-rw-r--r-- 1 root root        328 Jul  7 17:00 _ne0.fnm
-rw-r--r-- 1 root root     242609 Jul  7 17:00 _ne0.frq
-rw-r--r-- 1 root root        504 Jul  7 17:00 _ne0.nrm
-rw-r--r-- 1 root root     820393 Jul  7 17:00 _ne0.prx
-rw-r--r-- 1 root root       4440 Jul  7 17:00 _ne0.tii
-rw-r--r-- 1 root root     333653 Jul  7 17:00 _ne0.tis
-rw-r--r-- 1 root root        351 Jul  7 17:00 _ne0.tvd
-rw-r--r-- 1 root root     473525 Jul  7 17:00 _ne0.tvf
-rw-r--r-- 1 root root       2004 Jul  7 17:00 _ne0.tvx
-rw-r--r-- 1 root root         24 Jul  7 17:00 _ne0_2.del
-rw-r--r-- 1 root root    2800555 Jul  7 17:00 _ne1.fdt
-rw-r--r-- 1 root root       1148 Jul  7 17:00 _ne1.fdx
-rw-r--r-- 1 root root        328 Jul  7 17:00 _ne1.fnm
-rw-r--r-- 1 root root     222294 Jul  7 17:00 _ne1.frq
-rw-r--r-- 1 root root        576 Jul  7 17:00 _ne1.nrm
-rw-r--r-- 1 root root     749837 Jul  7 17:00 _ne1.prx
-rw-r--r-- 1 root root       4109 Jul  7 17:00 _ne1.tii
-rw-r--r-- 1 root root     294783 Jul  7 17:00 _ne1.tis
-rw-r--r-- 1 root root        448 Jul  7 17:00 _ne1.tvd
-rw-r--r-- 1 root root     421801 Jul  7 17:00 _ne1.tvf
-rw-r--r-- 1 root root       2292 Jul  7 17:00 _ne1.tvx
-rw-r--r-- 1 root root         26 Jul  7 17:00 _ne1_1.del

Steps taken:

Copied over valid segments.gen and segments_N files from another server with a non-corrupt index

Ran the Lucene CheckIndex tool to "fix" the segments files (in /webapp/WEB-INF/lib):

java -cp lucene-core-2.9-dev.jar org.apache.lucene.index.CheckIndex /solr_data/data/index/

Now I had a bunch of data files and empty segments files that did not point to my data files. So I started the solr server and ran
```
/solr/update?optimize=true
```
in the hopes that this would re-create the segments files and keep the data files intact

Results:

Optimize removed the data files so I was left with only segments.gen and segments_bao. This whole step failed and now I'll have to re-create the index (which took 5 days last time). Bummer.

Startup key combinations for Intel-based Macs

2009-11-25T11:42:00.000-08:00

Startup key combinations for Intel-based Macs

Adding a jar to a local file system maven2 repository using deploy:deploy-file

2009-11-13T07:56:00.000-08:00

It seems mvn is extremely picky about the syntax for this. Here's an example on windows that works with both apache-maven-2.0.9 and apache-maven-2.2.1:


C:\temp>mvn deploy:deploy-file -Dfile=gdata-calendar-2.0.jar -Durl=file:C:\m2repo -DgroupId=com.google -DartifactId=gdata-calendar -Dversion=2.0 -Dpackaging=jar

[INFO] Scanning for projects...
[INFO] Searching repository for plugin with prefix: 'deploy'.
[INFO] ------------------------------------------------------------------------
[INFO] Building Maven Default Project
[INFO]    task-segment: [deploy:deploy-file] (aggregator-style)
[INFO] ------------------------------------------------------------------------
[INFO] [deploy:deploy-file]
Uploading: file:C:\m2repo/com/google/gdata-calendar/2.0/gdata-calendar-2.0.jar
48K uploaded
[INFO] Retrieving previous metadata from remote-repository
[INFO] repository metadata for: 'artifact com.google:gdata-calendar' could not b
e found on repository: remote-repository, so will be created
[INFO] Uploading repository metadata for: 'artifact com.google:gdata-calendar'
[INFO] Uploading project information for gdata-calendar 2.0
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 1 second
[INFO] Finished at: Fri Nov 13 11:00:03 EST 2009
[INFO] Final Memory: 2M/5M
[INFO] ------------------------------------------------------------------------

To simplify, you can use this command:


upload gdata-calendar 2.0 com.google

If you first create this batch script:


call mvn deploy:deploy-file -Dfile=%1-%2.jar -Durl=file:C:\m2repo -DgroupId=%3 -DartifactId=%1 -Dversion=%2 -Dpackaging=jar

If you also want to create a simple maven2 entry, add this to the above script (note the Windows Command Interpreter escape character is "^"):


echo   ^<dependency^> >> pom-dependencies.txt
echo    ^<groupId^>%3^</groupId^> >> pom-dependencies.txt
echo    ^<artifactId^>%1^</artifactId^> >> pom-dependencies.txt
echo    ^<version^>%2^</version^> >> pom-dependencies.txt
echo   ^</dependency^> >> pom-dependencies.txt

And finally, this batch scrip will upload all the jars in Google's Java API:


call upload gdata-analytics 2.0 com.google
call upload gdata-analytics-meta 2.0 com.google
call upload gdata-appsforyourdomain 1.0 com.google
call upload gdata-appsforyourdomain-meta 1.0 com.google
call upload gdata-base 1.0 com.google
call upload gdata-blogger 2.0 com.google
call upload gdata-blogger-meta 2.0 com.google
call upload gdata-books 1.0 com.google
call upload gdata-books-meta 1.0 com.google
call upload gdata-calendar 2.0 com.google
call upload gdata-calendar-meta 2.0 com.google
call upload gdata-client 1.0 com.google
call upload gdata-client-meta 1.0 com.google
call upload gdata-codesearch 2.0 com.google
call upload gdata-codesearch-meta 2.0 com.google
call upload gdata-contacts 3.0 com.google
call upload gdata-contacts-meta 3.0 com.google
call upload gdata-core 1.0 com.google
call upload gdata-docs 3.0 com.google
call upload gdata-docs-meta 3.0 com.google
call upload gdata-finance 2.0 com.google
call upload gdata-finance-meta 2.0 com.google
call upload gdata-health 2.0 com.google
call upload gdata-health-meta 2.0 com.google
call upload gdata-maps 2.0 com.google
call upload gdata-maps-meta 2.0 com.google
call upload gdata-media 1.0 com.google
call upload gdata-photos 2.0 com.google
call upload gdata-photos-meta 2.0 com.google
call upload gdata-projecthosting 2.0 com.google
call upload gdata-projecthosting-meta 2.0 com.google
call upload gdata-sidewiki 2.0 com.google
call upload gdata-sidewiki-meta 2.0 com.google
call upload gdata-sites 2.0 com.google
call upload gdata-sites-meta 2.0 com.google
call upload gdata-spreadsheet 3.0 com.google
call upload gdata-spreadsheet-meta 3.0 com.google
call upload gdata-webmastertools 2.0 com.google
call upload gdata-webmastertools-meta 2.0 com.google
call upload gdata-youtube 2.0 com.google
call upload gdata-youtube-meta 2.0 com.google

Note you can also use mvn install:install-file as per this blog post.

Accessing the current request path with Freemarker and Spring MVC

2009-10-01T05:47:00.000-07:00

Use this to get the URI prefix


<#assign lastSlashPos = Request['springMacroRequestContext'].requestUri?last_index_of("/") />
<#assign uriPrefix = Request['springMacroRequestContext'].requestUri?substring(0, lastSlashPos) />

Then construct your link


<a href="${uriPrefix}/myPath.html">click here</a>

Broken pipe

2008-10-07T09:29:00.000-07:00

I got the following stack trace from a MySQL based app (spring, hibernate, c3p0 connection pool) after it had been sitting for a while.

Turns out the MySQL server was timing out connections while the c3p0 connection pool kept them open on the client-side. The solution in my case was to add a connection timeout on the client-side like this:


 <!-- Configuration resources:
   http://www.hibernate.org/214.html
   http://forum.springframework.org/showthread.php?t=13078
   http://www.mchange.com/projects/c3p0/apidocs/com/mchange/v2/c3p0/ComboPooledDataSource.html
 -->
 <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
  <property name="driverClass" value="${db.driverClass}" />
  <property name="jdbcUrl" value="${db.jdbcUrl}" />
  <property name="user" value="${db.user}" />
  <property name="password" value="${db.password}" />
  <!-- 1/2 hr. MySQL server default connection timeout is 43200 (12hrs) -->
  <property name="maxIdleTime" value="1800" />
 </bean>

04:20:53,868 [sor40] ERROR ExceptionResolver Exception reference: WNJMN5FDML
org.hibernate.exception.JDBCConnectionException: could not execute query
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.Loader.doList(Loader.java:2223)
 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
 at org.hibernate.loader.Loader.list(Loader.java:2099)
 at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
 at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
 at com.acme.repository.Repository.findInspectorCompanyByShortName(Repository.java:110)
 at com.acme.webapp.PickInspectionTimeController.handleRequestInternal(PickInspectionTimeController.java:65)
 at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
 at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)
 at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)
 at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)
 at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
 at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
 at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
 at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Broken pipe

STACKTRACE:

java.net.SocketException: Broken pipe
 at java.net.SocketOutputStream.socketWrite0(Native Method)
 at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
 at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
 at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
 at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
 at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692)
 at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
 at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
 at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
 at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
 at org.hibernate.loader.Loader.doQuery(Loader.java:674)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
 at org.hibernate.loader.Loader.doList(Loader.java:2220)
 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
 at org.hibernate.loader.Loader.list(Loader.java:2099)
 at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
 at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
 at com.acme.repository.Repository.findInspectorCompanyByShortName(Repository.java:110)
 at com.acme.webapp.PickInspectionTimeController.handleRequestInternal(PickInspectionTimeController.java:65)
 at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
 at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)
 at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)
 at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)
 at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
 at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
 at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
 at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **



Last packet sent to the server was 2 ms ago.
 at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2710)
 at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
 at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
 at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
 at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
 at org.hibernate.loader.Loader.doQuery(Loader.java:674)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
 at org.hibernate.loader.Loader.doList(Loader.java:2220)
 ... 33 more