llvm dev - Aug 2017 - Buildbot can't submit results to LNT server

Hi,

I have recently moved the clang-native-arm-lnt-perf bot from the nt
producer to the test-suite producer. It seems to be working fine but
it doesn't manage to submit the results to
http://lnt.llvm.org/submitRun.

If you scroll down to the bottom of [1], you can see this error message:
2017-08-28 07:06:32: submitting result to
'http://lnt.llvm.org/submitRun'
error: lnt server: internal server error
IntegrityError('(_mysql_exceptions.IntegrityError) (1062, "Duplicate
entry \'SingleSource/Benchmarks/Shootout/Shootout-ackermann\' for key
\'ix_NT_Test_Name\'")',)

We're running with --exec-multisample=3, so I think it should expect
one result for each sample. I managed to submit the corresponding
report.json [2] to a local, default (sqlite-based) LNT server.

Any idea what the problem might be?

Thanks,
Diana

[1]
http://lab.llvm.org:8014/builders/clang-native-arm-lnt-perf/builds/2397/steps/test-suite/logs/stdio
[2]
http://lab.llvm.org:8014/builders/clang-native-arm-lnt-perf/builds/2397/steps/test-suite/logs/report.json

Hi Diana, 

I have seen that issue on some other bots too. I will fix it this week. It is
something about how MySQL treats character encodings differently than Postgres.
We are checking for the value in the table beforehand, and this logic triggers
if the name is not found, but obviously that is not working!

💬 from 📱
> On Aug 28, 2017, at 2:04 AM, Diana Picus <diana.picus at linaro.org>
wrote:
> 
> Hi,
> 
> I have recently moved the clang-native-arm-lnt-perf bot from the nt
> producer to the test-suite producer. It seems to be working fine but
> it doesn't manage to submit the results to
> http://lnt.llvm.org/submitRun.
> 
> If you scroll down to the bottom of [1], you can see this error message:
> 2017-08-28 07:06:32: submitting result to
'http://lnt.llvm.org/submitRun'
> error: lnt server: internal server error
> IntegrityError('(_mysql_exceptions.IntegrityError) (1062,
"Duplicate
> entry \'SingleSource/Benchmarks/Shootout/Shootout-ackermann\' for
key
> \'ix_NT_Test_Name\'")',)
> 
> We're running with --exec-multisample=3, so I think it should expect
> one result for each sample. I managed to submit the corresponding
> report.json [2] to a local, default (sqlite-based) LNT server.
> 
> Any idea what the problem might be?
> 
> Thanks,
> Diana
> 
> [1]
http://lab.llvm.org:8014/builders/clang-native-arm-lnt-perf/builds/2397/steps/test-suite/logs/stdio
> [2]
http://lab.llvm.org:8014/builders/clang-native-arm-lnt-perf/builds/2397/steps/test-suite/logs/report.json

Great, good to know it's not just a problem with our bot. Thanks!

On 28 August 2017 at 16:24, Chris Matthews <cmatthews5 at apple.com>
wrote:
> Hi Diana,
>
> I have seen that issue on some other bots too. I will fix it this week. It
is something about how MySQL treats character encodings differently than
Postgres. We are checking for the value in the table beforehand, and this logic
triggers if the name is not found, but obviously that is not working!
>
> 💬 from 📱
>
>> On Aug 28, 2017, at 2:04 AM, Diana Picus <diana.picus at
linaro.org> wrote:
>>
>> Hi,
>>
>> I have recently moved the clang-native-arm-lnt-perf bot from the nt
>> producer to the test-suite producer. It seems to be working fine but
>> it doesn't manage to submit the results to
>> http://lnt.llvm.org/submitRun.
>>
>> If you scroll down to the bottom of [1], you can see this error
message:
>> 2017-08-28 07:06:32: submitting result to
'http://lnt.llvm.org/submitRun'
>> error: lnt server: internal server error
>> IntegrityError('(_mysql_exceptions.IntegrityError) (1062,
"Duplicate
>> entry \'SingleSource/Benchmarks/Shootout/Shootout-ackermann\'
for key
>> \'ix_NT_Test_Name\'")',)
>>
>> We're running with --exec-multisample=3, so I think it should
expect
>> one result for each sample. I managed to submit the corresponding
>> report.json [2] to a local, default (sqlite-based) LNT server.
>>
>> Any idea what the problem might be?
>>
>> Thanks,
>> Diana
>>
>> [1]
http://lab.llvm.org:8014/builders/clang-native-arm-lnt-perf/builds/2397/steps/test-suite/logs/stdio
>> [2]
http://lab.llvm.org:8014/builders/clang-native-arm-lnt-perf/builds/2397/steps/test-suite/logs/report.json