sql_error_code = 0000 on Heroku

[Vic vP]

Hi everyone,

I am running another oTree study using heroku, and I have noticed an error message in the log when I reset my database. Here is an excerpt:

2021-11-16T12:32:14.066395+00:00 heroku[run.1365]: State changed from starting to up

2021-11-16T12:32:13.232547+00:00 heroku[run.1365]: Starting process with command `otree resetdb --noinput`

2021-11-16T12:32:15.063290+00:00 app[run.1365]: Database engine: postgresql

2021-11-16T12:32:15.613703+00:00 app[run.1365]: Created new tables and columns.

2021-11-16T12:32:16.095426+00:00 heroku[run.1365]: State changed from up to complete

2021-11-16T12:32:15.855193+00:00 heroku[run.1365]: Process exited with status 0

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [10-1] sql_error_code = 00000 LOG: statement:

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [10-2] DROP TABLE publictax_player

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [11-1] sql_error_code = 00000 LOG: statement:

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [11-2] DROP TABLE publictax_button_player

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [12-1] sql_error_code = 00000 LOG: statement:

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [12-2] DROP TABLE publictax_group

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [13-1] sql_error_code = 00000 LOG: statement:

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [13-2] DROP TABLE publictax_button_group

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [14-1] sql_error_code = 00000 LOG: statement:

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [14-2] DROP TABLE otree_chatmessage

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [15-1] sql_error_code = 00000 LOG: statement:

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [15-2] DROP TABLE publictax_subsession

2021-11-16T12:32:15.000000+00:00 app[postgres.5836]: [DATABASE] [16-1] sql_error_code = 00000 LOG: statement:

This goes on for a while. After that I see multiple "sql_error_code = 000000" that correspond to table creation for the different oTree apps etc..

The app on heroku does seem to work for now, but it's a little worrying to see this error. I tried changing to database and redeploying everything.

Has anyone seen this error before and knows how to address it?

Thanks in advance for the thoughts.

Best,

Victor

[Vic vP]

Oke, so I just read somewhere that this is just Heroku's way of saying there is no error? So, I guess everything is fine. Great!

What a strange feature to raise a code for when there is "no error"....

[Chris @ oTree]

Yes I think it’s fine, no error…

Sent from my phone

On Nov 16, 2021, at 5:14 AM, Vic vP <victor...@gmail.com> wrote:

Oke, so I just read somewhere that this is just Heroku's way of saying there is no error? So, I guess everything is fine. Great!

--
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/06fea0e5-d1cd-49e4-bb5c-d75c3c79568an%40googlegroups.com.