Heroku deployment and tests are OK, but error in live

[Atila Abdulkadiroglu]

Hi all,

I would like my students play a few games in my class. I devopped the games, tested them locally, deployed it on Heroku, tested it there with 4 players by creating a room and sending individual links, did the demo, everthing went fine. But when I went live in the classroom, it gave error for some students. I don't know if I can trace the errors at the Heroku deoployment site, but here is what I did:

- a room with 64 players, the participant_labels.txt has 64 players with Player<i>, i=1,2,...,64  (the class is about 60, attendance was probably around 50)

- I emailed each student in the class with an individual link. 

- two players in each group

- some groups formed, some students kept waiting for other students (that is surprising, because I thought there would be at most one student waiting as matching is supposed to done just in time at arrival).

- I had to abort the game

- on Heroku, I have professional dynos,  standard 0 Heroku Postgress and and premium 1 Heroku Redis

Looks like it is giving a lot of Throughput 5XX errors. I have been trying to find about it online. If you have any suggestions, I would really appreciate it, as I am trying to run it again in the classroom in two days.

Thanks!

[Chris @ oTree]

Look in Sentry to get the error details. You can enable it through oTree Hub.  

Sent from my phone

On Sep 28, 2021, at 5:49 PM, Atila Abdulkadiroglu <atila.abdu...@gmail.com> wrote:

Hi all,

Thanks!

<errors.jpg>

--
You received this message because you are subscribed to the Google Groups "oTree help & discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to otree+un...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/otree/9ee1baff-8ec2-488d-b866-e04bf0304c2an%40googlegroups.com.

<errors.jpg>

[Atila Abdulkadiroglu]

Thanks Chris, that response was super fast, I really appreciate it! I'll try to figure out what Sentry is. I have been deploying it manually via GitHub.

in the meantime, this is what I got on Heroku logs:

2021-09-28T16:48:59.000000+00:00 app[postgres.26711]: [JADE] [9-1]  sql_error_code = 28000 FATAL:  no pg_hba.conf entry for host "45.146.164.110", user "postgres", database "bbbbbbb", SSL off

2021-09-28T17:09:39.000000+00:00 app[postgres.28939]: [JADE] [9-1]  sql_error_code = 08P01 LOG:  could not accept SSL connection: unsupported protocol

2021-09-28T17:09:39.000000+00:00 app[postgres.28939]: [JADE] [9-2]  sql_error_code = 08P01 HINT:  This may indicate that the client does not support any SSL protocol version between TLSv1.2 and TLSv1.3.

[Atila Abdulkadiroglu]

Tring to do my due diligence, nit sure if I am looking in the right place. But, looks like all Heroku database connections require SSL as of Feb 2021. They tell how to set up "SSL required" for clients on their website:

https://devcenter.heroku.com/articles/heroku-postgresql#connecting-in-python

do I have to insert that code in the settings.py, or do I need to insert the Django version just below it?

thanks!