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!

:speech_balloon: from :iphone:

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

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!

Cool, thanks Chris!