If, Genya, you are talking about problems with the database in general as Vitaliy
reported in his shift summary, and not just the ion polarimeter, I traced the problem
to a lack of the correct permissions for the HVGUI user as needed to query correctly.
Maybe Adrian can address this.
Basically HVGUI does not have select privileges to all the tables needed by the
following queries:
select * from READOUT_CARD NATURAL JOIN WC_HV where HvCrateNbr=3
select * from SC NATURAL JOIN SC_PMT NATURAL JOIN SC_HV where HvCrateNbr = 1
select * from CC NATURAL JOIN CC_PMT NATURAL JOIN CC_HV where HvCrateNbr=4
select * from NC NATURAL JOIN NC_PMT NATURAL JOIN NC_HV where HvCrateNbr=1
etc.
I get errors when done from the mysql gui like
ERROR 1142: select command denied to user: 'HVGUI@dblast07.bates.daq' for table 'SC'
It appears to fail at all those tables who do not end in "_HV".
The user "blast" does have select privileges to these which is why it worked before the
switch over, but this user does not have update privileges. Currently I set the user
back to "blast".
I hope this addresses what you were talking about.
Adam
Genya wrote:
> We had beam from 6 to about 10pm. Then there were some transmitters
> problems beam came back after midnight.
> Also, we do have some software bugs. In particular, it appears to be
> some mess in the database for HV (Adam? We'll talk about it Monday, I
> suppose).
> Other then that, IP worked like a charm. Unfortunately, we were able to
> take data only on ABS (with discharge on and off), and on unpolarized hydrogen.
> No data were taken as yet on deuterium (unpolarized, or through ABS). Hopely,
> Vitalij will finish it this night shift.
> Nevertheless, it appears we have excellent separation of mass 1 and mass 2.
> We do need deuterium data just to confirm our data. Conclusions:
> 1. Problem with unpolarized target is gone (at least with a warm cell).
> 2. Even with unpolarized target there is mass 1 signal (I suppose, it is
> double ionization, or dissociation by the electron beam). The amplitude of the
> signal is of the order of 10% of mass2 signal.
> 3. With a warm cell, the ratio molecules/atoms is about 4. If one recalls that
> there are 2 atoms in every molecule, the ratio becomes 8:1. Half of mass 1 signal
> corresponds to this double-ionization, so the real ratio is probably 16:1. If we'll
> get the same result with a cold cell, it will be clear that the polarization is gone
> due to recombination in the cell.
> I strongly advocate that the cell to be cooled Sunday night/morning. Yuan and me
> have 8-16 shift Sunday, we could measure the data with a cold cell.
> Genya
> PS Please find attached measured mass spectra for hydrogen. I apologize, but it is
> in Excel format...
>
> ------------------------------------------------------------------------
> Name: Masses06-20-03.xls
> Masses06-20-03.xls Type: Microsoft Excel Worksheet (application/vnd.ms-excel)
> Encoding: base64
This archive was generated by hypermail 2.1.2 : Mon Feb 24 2014 - 14:07:29 EST