#4098: Gratia v0.34.9b available with fix for MySQL 5.0.67

#

Thu Oct 02 13:14:14 2008

grid-accounting@fnal.gov - Ticket created

CC:	Tim Cartwright <cat@cs.wisc.edu>
Subject:	Bug fix - Gratia v0.34.9b available with fix for mysql client 5.0.67
Date:	Thu, 02 Oct 2008 13:04:07 -0500
To:	vdt-support <vdt-support@OPENSCIENCEGRID.ORG>
From:	John Weigand <weigand@fnal.gov>

Download (untitled) / with headers
text/plain 525b

Tim,

The new Gratia 0.34.9b is available here:
http://gratia.fnal.gov/Files/gratia_services_v0.34.9b.tar
http://gratia.fnal.gov/Files/gratia_reporting_v0.34.9b.tar

It contains the fixes for the comment lines in the sql files:
./gratia/build-summary-view.sql
./gratia/build-trigger.sql

As we discussed earlier, it appears that MySql is now enforcing the
comment rules whereby a comment line must be two dashes followed by
whitespace or a control character with the 5.0.67 version of the client.

John Weigand

#	Thu Oct 02 13:47:08 2008	cat - Subject changed from 'Bug fix - Gratia v0.34.9b available with fix for mysql client 5.0.67' to 'Gratia v0.34.9b available with fix for MySQL 5.0.67'

#	Thu Oct 02 13:47:09 2008	cat - Priority changed from (no value) to '4'

#	Thu Oct 02 13:47:10 2008	cat - Status changed from 'new' to 'open'

#	Thu Oct 02 13:47:12 2008	cat - Given to cat

#	Thu Oct 02 13:47:17 2008	cat - Fix scheduled CUR added

#

Thu Oct 02 13:54:12 2008

weigand@fnal.gov - Correspondence added

[Reply]

CC:	grid-accounting@fnal.gov
Subject:	Re: [vdt-support #4098] AutoReply: Bug fix - Gratia v0.34.9b available with fix for mysql client 5.0.67
Date:	Thu, 02 Oct 2008 13:50:36 -0500
To:	vdt-support@OPENSCIENCEGRID.ORG
From:	John Weigand <weigand@fnal.gov>

Download (untitled) / with headers
text/plain 156b

Tim,

I have 2 nodes with VDT installations of the collector. If you want me
to test this with the new mysql version, let me know the cache

John Weigand

#

Thu Oct 02 14:20:52 2008

greenc@fnal.gov - Correspondence added

[Reply]

CC:	GRID-ACCOUNTING@listserv.fnal.gov
Subject:	Re: [GRID-ACCOUNTING] [vdt-support #4098] AutoReply: Bug fix - Gratia v0.34.9b available with fix for mysql client 5.0.67
Date:	Thu, 02 Oct 2008 14:17:36 -0500
To:	vdt-support@OPENSCIENCEGRID.ORG
From:	Chris Green <greenc@fnal.gov>

Download (untitled) / with headers
text/html 2.9k

weigand@fnal.gov via RT wrote:

Tim,

I have 2 nodes with VDT installations of the collector.  If you want me 
to test this with the new mysql version, let me know the cache

John Weigand

Hi Tim,

[greenc@gratia01] ~/gratia-test $ cvs -q diff -u -rv0-34-9 -rv0-34-9b | grep -e '^--- '
--- collector/gratia-servlets/net/sf/gratia/servlets/RMIHandlerServlet.java     24 Apr 2008 19:39:44 -0000      1.8
--- common/configuration/build-summary-view.sql 30 May 2008 17:04:57 -0000      1.3

[greenc@gratia01] ~/gratia-test $ cvs log -N -rv0-34-9::v0-34-9b collector/gratia-servlets/net/sf/gratia/servlets/RMIHandlerServlet.java common/configuration/build-summary-view.sql

RCS file: /cvsroot/gratia/gratia/collector/gratia-servlets/net/sf/gratia/servlets/RMIHandlerServlet.java,v
Working file: collector/gratia-servlets/net/sf/gratia/servlets/RMIHandlerServlet.java
head: 1.18
branch:
locks: strict
access list:
keyword substitution: kv
total revisions: 19;    selected revisions: 1
description:
----------------------------
revision 1.8.4.1
date: 2008/06/24 23:03:23;  author: greenc;  state: Exp;  lines: +136 -89
Improvements to record handling for large, buggy records. Also improve logging and diagnostics
=============================================================================

RCS file: /cvsroot/gratia/gratia/common/configuration/build-summary-view.sql,v
Working file: common/configuration/build-summary-view.sql
head: 1.4
branch:
locks: strict
access list:
keyword substitution: kv
total revisions: 6;     selected revisions: 1
description:
----------------------------
revision 1.3.4.1
date: 2008/10/02 16:52:28;  author: greenc;  state: Exp;  lines: +10 -10
Fix comments for picky MySQL client v5.0.67
=============================================================================

Let me know if you need anything else.

Thanks,
Chris.

-- 
Chris Green <greenc@fnal.gov>, FNAL CD/SCF/GRID; 'phone (630) 840-2167.
IRC: greenc@jabber.fnal.gov, ChrisGreen@jabber.dsd.lbl.gov;
chissgreen (AIM, Yahoo); chissg@hotmail.com (MSNM);
chris.h.green (Google Talk).

Download smime.p7s
application/x-pkcs7-signature 3.9k

#

Thu Oct 02 14:41:47 2008

cat - Comments added

[Reply]

Subject:	[vdt-support #4098] SVN commit, rev 8146
To:	vdt-support@cs.wisc.edu
From:	cat@cs.wisc.edu

Download (untitled) / with headers
text/plain 426b

Commit comment:
Update to Gratia Services and Reporting 0.34.9b to fix SQL comment errors that
are now caught in MySQL 5.0.67. Also made repackaging scripts use the download
subdirectory.

Changed files:
U vdt/branches/vdt-1.10.1/Gratia-Reporting/make-tarball.pl
U vdt/branches/vdt-1.10.1/Gratia-Services/make-tarballs.pl
U vdt/branches/vdt-1.10.1/defs

To generate a diff:
svn diff -c 8146 file:///p/vdt/workspace/svn

#

Thu Oct 02 14:49:12 2008

cat - Correspondence added

[Reply]

Subject:	[vdt-support #4098] Test cache available with changes
Date:	Thu, 02 Oct 2008 14:48:47 -0500
To:	vdt-support@OPENSCIENCEGRID.ORG
From:	Tim Cartwright <cat@cs.wisc.edu>

Download (untitled) / with headers
text/plain 485b

Thanks to John and Chris, I have updated Gratia services and reporting
to 0.34.9b in our VDT prerelease test cache. This is the cache that
we are testing nightly and that will become the VDT 1.10.1k update on
Monday (unless things go poorly).

You can access the cache using the following URL:

http://vdt.cs.wisc.edu/vdt_11099_cache

Be forewarned that this cache contains numerous differences over VDT
1.10.1j and that it is still under development. Caveat emptor!

-- Tim

#

Thu Oct 02 15:14:14 2008

greenc@fnal.gov - Correspondence added

[Reply]

CC:	GRID-ACCOUNTING@listserv.fnal.gov
Subject:	Re: [GRID-ACCOUNTING] [vdt-support #4098] Test cache available with changes
Date:	Thu, 02 Oct 2008 15:11:22 -0500
To:	vdt-support@OPENSCIENCEGRID.ORG
From:	Chris Green <greenc@fnal.gov>

Download (untitled) / with headers
text/plain 947b

Tim Cartwright via RT wrote:

> Thanks to John and Chris, I have updated Gratia services and reporting
> to 0.34.9b in our VDT prerelease test cache. This is the cache that
> we are testing nightly and that will become the VDT 1.10.1k update on
> Monday (unless things go poorly).
>
> You can access the cache using the following URL:
>
> http://vdt.cs.wisc.edu/vdt_11099_cache
>
> Be forewarned that this cache contains numerous differences over VDT
> 1.10.1j and that it is still under development. Caveat emptor!
>
> -- Tim
>

Tim, how much more work needs to go into the VDT packaging of the 0.38
services? Is there a compelling reason why 0.38.4 isn't the thing to go
out with 1.10.1k?

Thanks,
Chris.

>
>

--
Chris Green <greenc@fnal.gov>, FNAL CD/SCF/GRID; 'phone (630) 840-2167.
IRC: greenc@jabber.fnal.gov, ChrisGreen@jabber.dsd.lbl.gov;
chissgreen (AIM, Yahoo); chissg@hotmail.com (MSNM);
chris.h.green (Google Talk).

Download smime.p7s
application/x-pkcs7-signature 3.9k

#

Thu Oct 02 15:25:51 2008

cat - Correspondence added

[Reply]

Subject:	Re: [vdt-support #4098] Test cache available with changes
Date:	Thu, 02 Oct 2008 15:19:46 -0500
To:	vdt-support@OPENSCIENCEGRID.ORG
From:	Tim Cartwright <cat@cs.wisc.edu>

Download (untitled) / with headers
text/plain 1.2k

Chris:

A lot of work remains, therefore we're sticking with 0.34 for now.
We'll get back to you on 0.38 soon.

-- Tim

On 2 Oct 2008, at 15:14, greenc@fnal.gov via RT wrote:

> Tim Cartwright via RT wrote:

>> Thanks to John and Chris, I have updated Gratia services and
>> reporting
>> to 0.34.9b in our VDT prerelease test cache. This is the cache that
>> we are testing nightly and that will become the VDT 1.10.1k update on
>> Monday (unless things go poorly).
>>
>> You can access the cache using the following URL:
>>
>> http://vdt.cs.wisc.edu/vdt_11099_cache
>>
>> Be forewarned that this cache contains numerous differences over VDT
>> 1.10.1j and that it is still under development. Caveat emptor!
>>
>> -- Tim
>>

> Tim, how much more work needs to go into the VDT packaging of the 0.38
> services? Is there a compelling reason why 0.38.4 isn't the thing to
> go
> out with 1.10.1k?
>
> Thanks,
> Chris.

>>
>>

>
>
> --
> Chris Green <greenc@fnal.gov>, FNAL CD/SCF/GRID; 'phone (630)
> 840-2167.
> IRC: greenc@jabber.fnal.gov, ChrisGreen@jabber.dsd.lbl.gov;
> chissgreen (AIM, Yahoo); chissg@hotmail.com (MSNM);
> chris.h.green (Google Talk).
>
>
>
> --
> View ticket at <http://crt.cs.wisc.edu/Ticket/Display.html?user=guest&pass=guest&id=4098

> >

> VDT Support: vdt-support@opensciencegrid.org<smime.p7s>

#

Thu Oct 02 15:35:51 2008

weigand@fnal.gov - Correspondence added

[Reply]

CC:	grid-accounting@fnal.gov
Subject:	Re: [vdt-support #4098] AutoReply: Bug fix - Gratia v0.34.9b available with fix for mysql client 5.0.67
Date:	Thu, 02 Oct 2008 15:34:41 -0500
To:	vdt-support@OPENSCIENCEGRID.ORG
From:	John Weigand <weigand@fnal.gov>

Download (untitled) / with headers
text/plain 139b

The test install I did from the http://vdt.cs.wisc.edu/vdt_11099_cache

was successful. No problems with v0.34.9b.

THanks

John Weigand

#

Fri Oct 03 09:24:27 2008

cat - Correspondence added

[Reply]

Subject:	Re: [vdt-support #4098] Gratia v0.34.9b
Date:	Fri, 03 Oct 2008 09:19:17 -0500
To:	vdt-support@OPENSCIENCEGRID.ORG
From:	Tim Cartwright <cat@cs.wisc.edu>

Download (untitled) / with headers
text/plain 514b

Hey, thank YOU, John! If it weren't for you, we would have shipped
MySQL 5.0.67 without fixing Gratia first, and that would have been
unfortunate.

On 2 Oct 2008, at 15:36, weigand@fnal.gov via RT wrote:

> The test install I did from the http://vdt.cs.wisc.edu/vdt_11099_cache
>
> was successful. No problems with v0.34.9b.
>
>
> THanks
>
> John Weigand
>
>
> --
> View ticket at <http://crt.cs.wisc.edu/Ticket/Display.html?user=guest&pass=guest&id=4098

> >

> VDT Support: vdt-support@opensciencegrid.org

#	Fri Oct 03 11:02:03 2008	cat - Priority changed from '4' to '3'

#	Fri Oct 03 11:02:04 2008	cat - Status changed from 'open' to 'resolved'

#	Fri Oct 03 11:02:05 2008	cat - Fixed in 1.10.1k added

#	Fri Oct 03 11:41:28 2008	cat - Reference by ticket #4106 added