Results of the MySQL DQ2 tests:
[umfs02:~]# su - dq2
[umfs02:~]$ cd /opt/dq2
You have new mail in /var/spool/mail/dq2
[umfs02:dq2]$ source config/AGLT2/environment.sh 
[umfs02:dq2]$ mysql -udq2user -pdqpwd -h `hostname -f`
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 69095 to server version: 4.0.27-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+------------------------+
| Database               |
+------------------------+
| content                |
| localreplicas          |
| location               |
| mysql                  |
| queued_transfers_AGLT2 |
| repository             |
| subscription           |
| test                   |
+------------------------+
8 rows in set (0.04 sec)

mysql> use localreplicas;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-------------------------+
| Tables_in_localreplicas |
+-------------------------+
| t_lfn                   |
| t_meta                  |
| t_metaspec              |
| t_pfn                   |
+-------------------------+
4 rows in set (0.00 sec)

mysql> select * from t_lfn;
+--------------------------------------------------------------------------------------+--------------------------------------+
| lfname                                                                               | guid                                 |
+--------------------------------------------------------------------------------------+--------------------------------------+
| lib.0109724d-0c7d-4f1a-ae0c-d3ebf3a2e85b.tgz                                         | 374b02a6-2b58-448f-8fab-f4310d63c7e6 |
| 5f7d8ad6-a141-4060-8c68-84d37d727a5f.log.tgz                                         | 36acc9bc-62d1-4ee9-ab50-257e5171bf83 |
| lib.5f7d8ad6-a141-4060-8c68-84d37d727a5f.tgz                                         | 9ac893d8-f856-4dcc-8a2c-b86a0c5f30ec |
| csc11.005036.Jimmy_jetsJ7.digit.RDO.v11004205._00384.pool.root.1                     | E847803C-0B17-DB11-8116-00304873B97C |
| csc11.005036.Jimmy_jetsJ7.digit.RDO.v11004205._00475.pool.root.1                     | 56B7EEAC-1217-DB11-991F-00123F209DE1 |
| mc11.007204.singlepart_mu4.evgen.EVNT.v11000302._00037.pool.root.1                   | D2A7BF8D-EE81-DA11-9BD3-00123F20CE29 |
| mc11.007204.singlepart_mu4.evgen.EVNT.v11000302._00038.pool.root.1                   | EED603D6-CB81-DA11-8732-000D604EA582 |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00009.pool.root.1                 | CA449080-847F-DA11-9E9D-00123F20BD10 |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00058.pool.root.1                 | 80E15117-757F-DA11-893C-00123F209EB6 |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00056.pool.root.1                 | FC100E10-837F-DA11-96F3-00123F20CE2C |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00004.pool.root.1                 | 12F2475E-B37F-DA11-9C9B-00123F20B8F6 |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00055.pool.root.1                 | 10411DB4-727F-DA11-9278-00123F20CCF1 |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00002.pool.root.1                 | 5C8DBD55-7A7F-DA11-9879-00123F20A93F |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00010.pool.root.1                 | B667C1F1-8C7F-DA11-965A-00123F20A1A4 |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00003.pool.root.1                 | F819284C-7D7F-DA11-87AE-00123F20CD57 |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00006.pool.root.1                 | 6AB47F6C-857F-DA11-8B20-00123F20A114 |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00007.pool.root.1                 | 56AFCC78-817F-DA11-9426-00123F20BA91 |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00001.pool.root.1                 | 5CB33EB2-807F-DA11-9B5E-00123F20CEC8 |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00057.pool.root.1                 | C4501C4B-877F-DA11-9E30-00123F20A807 |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00008.pool.root.1                 | D6093FFE-8B7F-DA11-9BF8-00123F20A17D |
| mc11.005311.PythiaZH120gamgam.digit.RDO.v11000303._00005.pool.root.1                 | 2A2A135C-7C7F-DA11-9133-00123F20CE7A |
| csc11.005923.McAtNlo0310_JIMMY_WpWm_enutaunu.digit.RDO.v11004205._00006.pool.root.2  | 98B53499-EC0B-DB11-82F6-000D604EA4F4 |
| csc11.005923.McAtNlo0310_JIMMY_WpWm_enutaunu.digit.RDO.v11004205._00005.pool.root.2  | 5A787A9D-E60B-DB11-8126-00096BB560F4 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000018.pool.root                                | a2a92dcb-ae2c-4aa9-a565-7d4a2aac9050 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000009.pool.root                                | 2b264db8-d106-4270-9598-578c18a3e831 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000004.pool.root                                | c53181e4-cd25-4323-9b8f-0e0f4bca5fe4 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000023.pool.root                                | 50cb1188-d402-4f6a-8804-3cb41945678d |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000032.pool.root                                | 7c4e7404-e611-4439-8307-97608f8a5398 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000028.pool.root                                | 69acf5ec-4de7-4c64-9ee8-7d3a82bf84f1 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000021.pool.root                                | 34efe567-5c58-4383-bec1-4025eb27b5dd |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000008.pool.root                                | 3a53b830-f93d-48bb-9096-68bd0e69a781 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000017.pool.root                                | 2f5b330a-8d1c-4f8f-bb75-a4ea391727e9 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000026.pool.root                                | 271aae14-7abb-4918-8961-8a5669ce3165 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000019.pool.root                                | 56ef7533-e418-4d39-8b57-77c79912f510 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000034.pool.root                                | e90987d4-77f9-4aa6-9635-49c1faf65052 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000035.pool.root                                | 96c0abff-73f4-4bdc-8271-dd401ae48cbc |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000010.pool.root                                | 394c1ff4-4ce9-41dc-84d2-d3531e4ff864 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000016.pool.root                                | 27e25b43-7fab-4350-9607-f3d08674c71b |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000014.pool.root                              | fa531ab1-cbcc-4e63-9e5a-68b4dcde8775 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000019.pool.root                              | d94c272a-38b3-479e-91be-a67f952d5757 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000034.pool.root                              | a1e5e883-3728-4873-ab37-aec556cc243b |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000031.pool.root                              | 73f1a49e-59f9-4178-85e4-58fee246dbda |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000030.pool.root                              | 762fcfa9-58db-405d-9aa0-0ab7baf3bfe7 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000029.pool.root                                | a9ef30c9-a52f-4bdd-bb2a-bc83499254d1 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000030.pool.root                                | 1dd62959-2c3d-4a26-b345-c99761e4126e |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000007.pool.root                                | 61807dac-259e-4698-a040-21a195977f77 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000011.pool.root                              | d9c95480-7562-407b-a02d-2e58faaa042c |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000006.pool.root                                | 23d74009-ed20-487f-98e4-17d6f173281a |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000033.pool.root                                | f52a36b2-e6dd-49f3-8b4e-79f4e5ebcc1c |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000040.pool.root                                | f15c9241-5e68-4fbb-a3c7-3e0b225f6a71 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000042.pool.root                                | 1ddb8a77-3dc2-4754-9b8c-b38931594014 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000011.pool.root                                | 668e9c73-b312-4866-9d42-453cedcd20c8 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000038.pool.root                                | 001bddd2-d664-4bca-8155-bbfcbb7d7896 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000002.pool.root                                | 573bc754-3c84-4bff-b3d0-7bda1a78dcab |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000001.pool.root                                | 9172ab8f-d363-4152-b6a4-b1fc7568a1cf |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000025.pool.root                                | a17b2e8b-9e3c-43e2-84fb-d5284ab116d7 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000013.pool.root                                | 4bfc7493-7b11-4e2c-b8d2-b50570748bf9 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000027.pool.root                                | 384bdd65-8620-449e-85ab-2609c241eb1c |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000003.pool.root                                | 984bb89f-5bc0-4ee1-b42f-c45c4f644a5b |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000037.pool.root                                | b6a7e1bc-28fb-4a1f-85f7-d9175289e77a |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000045.pool.root                                | 4291e36f-6b66-4575-a57d-610c1d988cda |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000036.pool.root                                | 0d7d9386-8ed8-47fa-8e64-b4bd3f8bc2ce |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000023.pool.root                              | 0b899298-7f81-4663-b737-18956cbf8a5c |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000017.pool.root                              | e284f393-8e7d-42e5-a6bc-22cb58ec7770 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000026.pool.root                              | 87a991ac-ff0f-483f-91ab-dbd0b2d8383e |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000037.pool.root                              | f1780eac-1369-4f90-92c6-ec535e794929 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000007.pool.root                              | 4cc8f458-ee5f-49bf-a491-695a3e4c62ac |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000027.pool.root                              | c6fbe9f9-82c9-4e3c-b7f6-09967915527e |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000039.pool.root                              | 5066259b-47f5-436c-ae2e-e9cef2d03ba7 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000038.pool.root                              | 6a4df522-bffd-4a22-8d04-fa339f262e47 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000020.pool.root                                | 16c725aa-e62e-41ad-ab8e-4ffb63215c47 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000012.pool.root                                | de441b94-586e-42c1-881e-a4de9dc609b1 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000024.pool.root                                | 19540f11-ab60-4897-8235-4a8fc484e1f0 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000031.pool.root                                | 4ae1dc9b-348d-47c9-938c-87b09075b5d2 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000005.pool.root                                | 21cb88f6-34be-41fe-bce2-a0752fca7252 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000014.pool.root                                | 8fbae4b9-1ec1-48e2-8e89-cab9f341ad6b |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000015.pool.root                                | e570a082-25eb-4eea-8f3c-58d6f8b51973 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000025.pool.root                              | 17f4e839-941c-46e4-b942-45c7308eca24 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000041.pool.root                              | 9a1177ff-729c-4890-ae47-7f75e3f295ba |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000028.pool.root                              | 03e4ea01-6a92-4eaa-a3db-cb031f4bcd75 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000024.pool.root                              | c7103786-ef79-4735-9b79-b6ecd3d64a49 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000004.pool.root                              | e16c2ae1-2231-4946-bf04-a92d5bbb2c83 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000033.pool.root                              | 1a265373-a319-4dd7-a883-b2bb04ebf766 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000040.pool.root                              | 69ca30e4-16bc-4d60-a640-99a826def12c |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000022.pool.root                              | f6e30134-0803-44f3-8821-5716f499707e |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000001.pool.root                              | 4582923e-3b39-4f7a-85b1-e4643d9fea21 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000002.pool.root                              | 93e354e0-29de-4b01-a7e6-f7ce840e5277 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000010.pool.root                              | 01769a6f-3163-4f4e-ae56-eb9d6c65fc5b |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000013.pool.root                              | ebc904a4-6309-4769-9c7f-c1c83532fdd1 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000035.pool.root                              | f89ba6a7-5393-442a-89a4-5093c4f06d9e |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000036.pool.root                              | a7dca1f1-11cc-4aa4-9da9-014af1260f62 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000029.pool.root                              | 9b0b23c6-de5e-4fa2-b1f4-42817113d096 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000003.pool.root                              | 4e1f4838-f420-40d2-8bbe-15fae1ed88c9 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000016.pool.root                              | 3e77df5b-85dd-4aac-91c5-c5ebf8e53729 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000020.pool.root                              | 87d7f916-aa91-4cab-bd8e-122b9e7a9eb4 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000005.pool.root                              | a0b51d55-22df-42dc-9af0-21fea7bd5619 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000008.pool.root                              | c649ade2-ca1b-438a-bea5-1b8f6b89f5ad |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000022.pool.root                                | 9e3041c3-0d0b-458c-8b73-f52a1fcf4aba |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000039.pool.root                                | 4747f863-7a4b-4a3a-ac7e-675696e44d30 |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000044.pool.root                                | e949af81-64ff-44ad-a544-71ce78f6784d |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000043.pool.root                                | 150ea20b-2e7c-4d5b-9b63-91652102e9bc |
| ddmf1.001002.BNL.GLT2.Step1.v000211._000041.pool.root                                | e933e768-d373-4ea9-867a-6a9acca38721 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000006.pool.root                              | 59290b27-0c35-4d84-8fff-3278dbbe471b |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000032.pool.root                              | 102ea109-73a8-4457-987c-5ec1f6be7b21 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000015.pool.root                              | f21a364b-5009-4ed7-9bd1-95ac8f78d773 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000018.pool.root                              | 1191f970-b046-4d32-a511-4884a7fb9d0b |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000012.pool.root                              | d748bd39-86ae-42af-8b34-0b3945c08670 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000009.pool.root                              | fcc56932-6e51-4929-9021-dfa84fadeca0 |
| ddmf1.001001.BNL.GLOBAL.Step1.v000211._000021.pool.root                              | 0a42e0c3-7994-46cc-998e-d40f3c8a4991 |
| ddmf1.001099.Argon.global.ESD.v000211._000004.pool.root                              | 721d6477-39e0-40c8-be6d-7c34f86922e6 |
| ddmf1.001099.Argon.global.ESD.v000211._000000.pool.root                              | cc106677-dc93-4693-b4ce-b4022902147c |
| ddmf1.001099.Argon.global.ESD.v000211._000001.pool.root                              | a4faef1d-1eeb-48de-af84-03f2d81d9a1c |
| ddmf1.001099.Argon.global.ESD.v000211._000007.pool.root                              | ddcc6c60-18f9-49dc-8d16-fe9bfde9b3e7 |
| ddmf1.001099.Argon.global.ESD.v000211._000005.pool.root                              | 6990102f-ba24-4ddb-ab00-7632f21429e3 |
| ddmf1.001099.Argon.global.ESD.v000211._000003.pool.root                              | d8d1adc9-6890-4184-837e-a0ea4ec778a2 |
| ddmf1.001099.Argon.global.ESD.v000211._000006.pool.root                              | 416fd6b7-6ae9-4db7-b042-b8e57937c26b |
| ddmf1.001099.Argon.global.ESD.v000211._000002.pool.root                              | 4c27fbfa-09aa-4b7b-ba54-3fca690b9cfb |
| e387303f-a1be-420e-88f2-f1dfbc36ab16_0.job.log.tgz                                   | 124815b7-2b4e-4c9e-9ecc-46dd9731844b |
| c38fe284-37dd-4ef5-8a2b-bfc3ea8dfe74_1.job.log.tgz                                   | 0154b481-4a60-4ad4-81d5-135ccb73336f |
| 5effd090-0da6-4582-9862-ea3e1d4660e0_2.job.log.tgz                                   | 11d2506d-b595-4d90-9e05-130034069413 |
| 6e8619a5-0bd5-475d-bd87-336c0dd5c14c_3.job.log.tgz                                   | c2bc1ec5-eddd-4d91-a3da-ba6d918e8c2e |
| eebc5278-9170-485a-8e8f-b03a346f2750_0.evgen.pool.root                               | EC5B7EEE-F289-DB11-BEC5-00504501068B |
| eebc5278-9170-485a-8e8f-b03a346f2750_0.job.log.tgz                                   | 7931c3e5-6fcf-440b-b95f-248a52f38047 |
| mc12.008097.PythiaPhotonJet3_FIXED.evgen.EVNT.v12003104_tid004135._00033.pool.root.1 | B2CBACF0-4D73-DB11-A8AE-000E0C07BDAB |
| mc12.008072.JimmyPhotonJet1.evgen.EVNT.v12000302_tid003544._00014.pool.root.2        | 7E3F3D6E-465F-DB11-95F3-00A0D1E4F805 |
| mc12.008099.PythiaPhotonJet5_FIXED.evgen.EVNT.v12003102_tid003690._00019.pool.root.1 | 2453EE1F-2E65-DB11-9EE2-00A0D1E4686D |
| mc12.008072.JimmyPhotonJet1.evgen.EVNT.v12000302_tid003544._00013.pool.root.2        | 3C5CC46B-465F-DB11-BEEA-00123F20CCAF |
| DBRelease-2.8.tar.gz                                                                 | 54b81ff9-0735-4ba8-895b-c8bf06e6652f |
| mc12.008099.PythiaPhotonJet5_FIXED.evgen.EVNT.v12003102_tid003690._00020.pool.root.1 | 7A86CE1F-2E65-DB11-98D4-00A0D1E50375 |
+--------------------------------------------------------------------------------------+--------------------------------------+
129 rows in set (0.02 sec)

mysql> quit;
Bye
[umfs02:dq2]$ 

-- ShawnMcKee - 13 Dec 2006
Topic revision: r1 - 13 Dec 2006, ShawnMcKee
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback