[LLVMdev] Perf is dead again... :(

[Renato Golin]

The error on SQLite was:

database is locked u'SELECT "StatusKind"."ID" AS "StatusKind_ID",
"StatusKind"."Name" AS "StatusKind_Name" \nFROM "StatusKind" \nWHERE
"StatusKind"."ID" = ?\n LIMIT ? OFFSET ?'

Which is understandable, since SQLite is not meant for production
environments, and being in a shared machine, swap or high load could
force timeouts and bad applications could not have released locks or
something.

Is this happening again on PostgreSQL? Is it the same error? Are you
sure the web application is indeed connecting to PostgreSQL?

I agree this should be in a separate machine. Do we use some sort of
cloud server for that? Can we get another instance under the LLVM
Foundation's umbrella? I think it's time we focus on the quality of
our services as a whole, and centralised the administration by having
some people access to all boards, so that we can cover each other in
cases like these.

Tanya, do we have plans for something like that?

cheers,
--renato



On 28 November 2014 at 07:13, Tobias Grosser <tobias at grosser.es> wrote:
> On 27.11.2014 22:56, Daniel Dunbar wrote:
>>
>> I realized that we never finalized the switchover to Postgres, instead the
>> default database was still SQLite (which has grown huge) and it was shadow
>> importing into the PostgreSQL database.
>>
>> I have now switch it over to only run against Postgres, which I suspect
>> will eliminate the failures we were seeing. Please let me know if you
>> notice any problems. It seems like the switch already gives a big
>> improvement to the response time of the perf homepage.
>>
>> I'm not sure what to do w.r.t. access to the machine, I think the best
>> solution is to try and move LNT off of llvm.org to a machine we don't need
>> to be as careful with.
>>
>> FYI, I attached the LNT log in case anyone wants to look at the errors and
>> see if we can fix the SQLite implementation to not fail on them.
>
>
> Bad news, I just got an error 500 again. Could you possibly hand out a
> version of the logs, Daniel?
>
>
> Tobias
>
> _______________________________________________
> LLVM Developers mailing list
> LLVMdev at cs.uiuc.edu         http://llvm.cs.uiuc.edu
> http://lists.cs.uiuc.edu/mailman/listinfo/llvmdev