[InterMine Dev] tomcat restart deletes query templates

Joe Carlson jwcarlson at lbl.gov
Fri Aug 7 18:01:18 BST 2015

Hi Sergio,

I’m running tomcat 7.0.62 and postgres server 9.4.1 and 9.4.2. I’ve seen the behavior on two different installs.

I know I have a couple of old templates in the db that do not work anymore. These appear with red lines through them with I become superuser and look at the templates. I was assuming (or maybe just hoping) that this could be ignored. Whether or not this is related, I’m also seeing NotSerializableException from org.intermine.api.template.ApiTemplate in the log files. I’m starting to look into that.

This morning I’ll try some experiments to see if loosing the templates is reproducible. And if cleaning up the templates helps. Unfortunately I don’t have access to the postgres log files so I cannot track the db activity too closely. (but…I’m begging)

It is strange since we used to have a problem with tomcat restarts quite often. And did not see the templates disappear then. As I recall, there were bogus template queries at that time.


On Aug 7, 2015, at 4:25 AM, sergio contrino <sergio at modencode.org> wrote:

> dear Joe,
> we have not experienced the issue of the disappearance of saved tamplates and it should not be linked to the tomcat restart.
> could you send us the postgres and tomcat versions, and anything else that seems relevant to you? i can try to replicate it here.
> thanks
> sergio
> On 06/08/15 17:42, Joe Carlson wrote:
>> Hi Julie and others,
>> I've seen a problem the past couple weeks. I'm just starting to figure
>> out what is going on here. What I'm seeing is that a tomcat restart
>> causes most of the saved templates to disappear. The savedtemplatequery
>> table in the userprofile db is almost cleaned out - it looks like there
>> are still some user-created queries, but only 1 template created by the
>> superuser. Of course they do not show up on the front page.
>> I think - but I'm not even sure about this - is that it happens with a
>> tomcat restart.
>> Most curious. Have you ever seen this behavior? I have a backup that I
>> can restore so it's not a catastrophe but annoying.
>> Thanks,
>> Joe
>> _______________________________________________
>> dev mailing list
>> dev at intermine.org
>> http://mail.intermine.org/cgi-bin/mailman/listinfo/dev
> -- 
> sergio contrino                  InterMine, University of Cambridge
> https://sergiocontrino.github.io           http://www.intermine.org

More information about the dev mailing list