[llvm-dev] Buildbot can't submit results to LNT server

[Chris Matthews via llvm-dev]

I have fixed in r312400.  MySQL uses a case insensitive string compare by default, and the names of some of the tests have changed case recently!

> On Aug 28, 2017, at 7:26 AM, Diana Picus <diana.picus at linaro.org> wrote:
> 
> 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