Hey Brad, So I've dug around and replicated all the requests in the web log you sent (central#default tip -- what revision are you running?), but I'm not seeing any unencoded id queries my sql logs (expected this more or less, w/ all of the requests in your web log being 200 OK's). The next guess is that it has to do with job metrics or metadata. The job itself failed, do you know why that is? What job metrics do you have enabled? And has this been a consistent issue, or you just happened to notice the error this one time?
-Dannon On Tue, Aug 5, 2014 at 5:53 PM, Langhorst, Brad <langho...@neb.com> wrote: > I tried to do some time correlation between galaxy logs and postgres > logs… > > postgres > 2014-08-01 17:15:15.643 EDT > > > handler1.log > galaxy.jobs.output_checker INFO 2014-08-01 17:15:08,875 Job 123681: > Fatal error: Exit code 1 (Interval subtraction error) > galaxy.jobs DEBUG 2014-08-01 17:15:08,948 setting dataset state to ERROR > galaxy.jobs INFO 2014-08-01 17:15:09,196 Collecting job metrics for > <galaxy.model.Job object at 0x7fcbacccbb50> > galaxy.jobs DEBUG 2014-08-01 17:15:09,208 job 123681 ended > galaxy.datatypes.metadata DEBUG 2014-08-01 17:15:09,208 Cleaning up > external metadata files > galaxy.jobs.runners.drmaa DEBUG 2014-08-01 17:17:32,338 (123678/1521440) > state change: job finished normally > > handler0.log > laxy.datatypes.metadata DEBUG 2014-08-01 17:14:40,572 loading metadata > from file for: HistoryDatasetAssociation 192134 > galaxy.jobs INFO 2014-08-01 17:14:40,804 Collecting job metrics for > <galaxy.model.Job object at 0x7f15fc281850> > galaxy.jobs DEBUG 2014-08-01 17:14:40,815 job 123680 ended > galaxy.datatypes.metadata DEBUG 2014-08-01 17:14:40,815 Cleaning up > external metadata files > python path is: > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/kombu-3.0.12-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/anyjson-0.3.3-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/numpy-1.6.0-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/pysam-0.4.2_kanwei_b10f6e722e9a-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/mercurial-2.2.3-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/pycrypto-2.5-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/python_lzo-1.08_2.03_static-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/bx_python-0.7.2-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/amqp-1.4.3-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/pexpect-2.4-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/Babel-1.3-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/pytz-2013.9-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/Mako-0.4.1-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/WebHelpers-1.3-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/MarkupSafe-0.12-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/WebOb-0.8.5-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/Routes-1.12.3-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/Cheetah-2.2.2-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/wchartype-0.1-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/elementtree-1.2.6_20050316-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/docutils-0.7-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/PasteDeploy-1.5.0-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/Paste-1.7.5.1-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/lib, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/site-packages/cutadapt-1.3-py2.7-linux-x86_64.egg, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/site-packages/distribute-0.6.10-py2.7.egg, > /mnt/galaxy/data/galaxy/sw/lib/python27.zip, > /mnt/galaxy/data/galaxy/sw/lib/python2.7, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/plat-linux2, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/lib-tk, /mnt/galaxy/da > > ta/galaxy/sw/lib/python2.7/lib-old, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/lib-dynload, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/site-packages > > web0.log > 172.17.130.113 - - [01/Aug/2014:17:14:58 -0400] "GET > /api/histories/39a249c523d1b262/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chr > ome/36.0.1985.125 Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:15:03 -0400] "GET > /datasets/49b19822485c7897/display/?preview=True HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Ge > cko) Chrome/36.0.1985.125 Safari/537.36" > 172.17.131.223 - - [01/Aug/2014:17:15:03 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0 > .4 Safari/537.76.4" > 172.17.130.113 - - [01/Aug/2014:17:15:04 -0400] "GET > /datasets/49b19822485c7897/display/?preview=True HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Ge > cko) Chrome/36.0.1985.125 Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:15:07 -0400] "GET > /api/histories/39a249c523d1b262/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chr > ome/36.0.1985.125 Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:15:09 -0400] "GET > /datasets/49b19822485c7897/show_params HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrom > e/36.0.1985.125 Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:15:11 -0400] "GET > /api/histories/39a249c523d1b262/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 > Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:15:12 -0400] "GET > /api/histories/39a249c523d1b262/contents/datasets/49b19822485c7897 > HTTP/1.0" 200 - "http://galaxy.neb.com/root/index"; "Mozilla/5.0 > (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) > Chrome/36.0.1985.125 Safari/537.36" > 172.17.131.223 - - [01/Aug/2014:17:15:12 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0.4 Safari/537.76.4" > 172.17.131.223 - - [01/Aug/2014:17:15:20 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0.4 Safari/537.76.4" > 172.17.131.223 - - [01/Aug/2014:17:15:29 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0.4 Safari/537.76.4" > 172.17.131.223 - - [01/Aug/2014:17:15:37 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0.4 Safari/537.76.4" > 172.17.131.223 - - [01/Aug/2014:17:15:46 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0.4 Safari/537.76.4" > python path is: > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/kombu-3.0.12-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/anyjson-0.3.3-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/numpy-1.6.0-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/pysam-0.4.2_kanwei_b10f6e722e9a-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/mercurial-2.2.3-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/pycrypto-2.5-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/python_lzo-1.08_2.03_static-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/bx_python-0.7.2-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/amqp-1.4.3-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/pexpect-2.4-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/Babel-1.3-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/pytz-2013.9-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/Mako-0.4.1-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/WebHelpers-1.3-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/MarkupSafe-0.12-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/WebOb-0.8.5-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/Routes-1.12.3-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/Cheetah-2.2.2-py2.7-linux-x86_64-ucs2.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/wchartype-0.1-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/elementtree-1.2.6_20050316-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/docutils-0.7-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/PasteDeploy-1.5.0-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/eggs/Paste-1.7.5.1-py2.7.egg, > /mnt/galaxy/data/galaxy/galaxy-dist/lib, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/site-packages/cutadapt-1.3-py2.7-linux-x86_64.egg, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/site-packages/distribute-0.6.10-py2.7.egg, > /mnt/galaxy/data/galaxy/sw/lib/python27.zip, > /mnt/galaxy/data/galaxy/sw/lib/python2.7, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/plat-linux2, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/lib-tk, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/lib-old, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/lib-dynload, > /mnt/galaxy/data/galaxy/sw/lib/python2.7/site-packages > tool_shed.tool_shed_registry DEBUG 2014-08-01 17:16:41,474 Loading > references to tool sheds from tool_sheds_conf.xml > > web1.log > > 172.17.130.113 - - [01/Aug/2014:17:14:25 -0400] "GET > /api/histories/39a249c523d1b262/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chr > ome/36.0.1985.125 Safari/537.36" > 172.17.131.223 - - [01/Aug/2014:17:14:25 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0 > .4 Safari/537.76.4" > 172.17.130.113 - - [01/Aug/2014:17:14:29 -0400] "GET > /api/histories/39a249c523d1b262/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chr > ome/36.0.1985.125 Safari/537.36" > 172.17.131.223 - - [01/Aug/2014:17:14:34 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0 > .4 Safari/537.76.4" > 172.17.130.113 - - [01/Aug/2014:17:14:36 -0400] "GET > /datasets/7423d3ce9d139cc4/display/?preview=True HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Ge > cko) Chrome/36.0.1985.125 Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:14:37 -0400] "GET > /api/histories/39a249c523d1b262/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chr > ome/36.0.1985.125 Safari/537.36" > 172.17.131.223 - - [01/Aug/2014:17:14:42 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0 > .4 Safari/537.76.4" > 172.17.130.113 - - [01/Aug/2014:17:14:46 -0400] "GET > /api/histories/39a249c523d1b262/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chr > ome/36.0.1985.125 Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:14:47 -0400] "GET > /datasets/49b19822485c7897/display/?preview=True HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Ge > cko) Chrome/36.0.1985.125 Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:14:50 -0400] "GET > /api/histories/39a249c523d1b262/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chr > ome/36.0.1985.125 Safari/537.36" > 172.17.131.223 - - [01/Aug/2014:17:14:51 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0 > .4 Safari/537.76.4" > 172.17.130.113 - - [01/Aug/2014:17:14:54 -0400] "GET > /datasets/49b19822485c7897/display/?preview=True HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Ge > cko) Chrome/36.0.1985.125 Safari/537.36" > 172.17.131.223 - - [01/Aug/2014:17:14:59 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0 > .4 Safari/537.76.4" > 172.17.130.113 - - [01/Aug/2014:17:15:02 -0400] "GET > /datasets/49b19822485c7897/display/?preview=True HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Ge > cko) Chrome/36.0.1985.125 Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:15:03 -0400] "GET > /api/histories/39a249c523d1b262/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chr > ome/36.0.1985.125 Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:15:04 -0400] "GET > /datasets/49b19822485c7897/show_params HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrom > e/36.0.1985.125 Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:15:07 -0400] "GET > /datasets/49b19822485c7897/display/?preview=True HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 > Safari/537.36" > 172.17.131.223 - - [01/Aug/2014:17:15:08 -0400] "GET > /api/histories/11ff4619ea0fcba9/contents HTTP/1.0" 200 - " > http://galaxy.neb.com/"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) > AppleWebKit/537.76.4 (KHTML, like Gecko) Version/7.0.4 Safari/537.76.4" > 172.17.130.113 - - [01/Aug/2014:17:15:10 -0400] "GET > /datasets/49b19822485c7897/display/?preview=True HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 > Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:15:11 -0400] "GET > /datasets/49b19822485c7897/show_params HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 > Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:15:12 -0400] "GET > /api/histories/39a249c523d1b262 HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 > Safari/537.36" > 172.17.130.113 - - [01/Aug/2014:17:15:15 -0400] "GET > /dataset/errors?id=49b19822485c7897 HTTP/1.0" 200 - " > http://galaxy.neb.com/root/index"; "Mozilla/5.0 (Macintosh; Intel Mac OS X > 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 > Safari/537.36" > -- > Bradley W. Langhorst, Ph.D. > Applications and Product Development Scientist > > On Aug 5, 2014, at 5:18 PM, Dannon Baker <dannon.ba...@gmail.com> wrote: > > Definitely looks like an encoded id is being used in the query when it > should be an unencoded id. I can try to dig through the query and make > guesses as to what's calling it, but do you have any hints at all what's > happening in galaxy at the time of this request? > > -Dannon > > > On Tue, Aug 5, 2014 at 5:13 PM, Langhorst, Brad <langho...@neb.com> wrote: > >> I see this in my database server logs… >> >> SELECT history_dataset_association.id AS >> history_dataset_association_id, history_dataset_association.history_id AS >> history_dataset_association_history_id, >> history_dataset_association.dataset_id AS >> history_dataset_association_dataset_id, >> history_dataset_association.create_time AS >> history_dataset_association_create_time, >> history_dataset_association.update_time AS >> history_dataset_association_update_time, history_dataset_association.state >> AS history_dataset_association_state, >> history_dataset_association.copied_from_history_dataset_association_id AS >> history_dataset_association_copied_from_history_dataset_a_1, >> history_dataset_association.copied_from_library_dataset_dataset_association_id >> AS history_dataset_association_copied_from_library_dataset_d_2, >> history_dataset_association.hid AS history_dataset_association_hid, >> history_dataset_association.name AS history_dataset_association_name, >> history_dataset_association.info AS history_dataset_association_info, >> history_dataset_association.blurb AS history_dataset_association_blurb, >> history_dataset_association.peek AS history_dataset_association_peek, >> history_dataset_association.tool_version AS >> history_dataset_association_tool_version, >> history_dataset_association.extension AS >> history_dataset_association_extension, history_dataset_association.metadata >> AS history_dataset_association_metadata, >> history_dataset_association.parent_id AS >> history_dataset_association_parent_id, >> history_dataset_association.designation AS >> history_dataset_association_designation, >> history_dataset_association.deleted AS history_dataset_association_deleted, >> history_dataset_association.purged AS history_dataset_association_purged, >> history_dataset_association.visible AS history_dataset_association_visible, >> history_dataset_association.hidden_beneath_collection_instance_id AS >> history_dataset_association_hidden_beneath_collection_ins_3, >> history_dataset_association.extended_metadata_id AS >> history_dataset_association_extended_metadata_id, dataset_1.id AS >> dataset_1_id, dataset_1.create_time AS dataset_1_create_time, >> dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS >> dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged >> AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, >> dataset_1.object_store_id AS dataset_1_object_store_id, >> dataset_1.external_filename AS dataset_1_external_filename, >> dataset_1._extra_files_path AS dataset_1__extra_files_path, >> dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS >> dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid >> FROM history_dataset_association LEFT OUTER JOIN dataset AS dataset_1 ON >> dataset_1.id = history_dataset_association.dataset_id >> WHERE history_dataset_association.id = ‘49b19822485c7897' >> >> looks like a simple bug to me. >> >> >> But I don’t know an easy way to track it down. >> >> Any ideas? >> >> Brad >> >> -- >> Bradley W. Langhorst, Ph.D. >> Applications and Product Development Scientist >> >> >> ___________________________________________________________ >> Please keep all replies on the list by using "reply all" >> in your mail client. To manage your subscriptions to this >> and other Galaxy lists, please use the interface at: >> http://lists.bx.psu.edu/ >> >> To search Galaxy mailing lists use the unified search at: >> http://galaxyproject.org/search/mailinglists/ >> > > >
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/ To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
