Loomio
Mon 24 Jan 2022 7:17PM

Loomio DB errors

T Trav Public Seen by 51

Hi. We're running Loomio 2.11.11 via Co-op Cloud with authentication provided by Keycloak. It was running fine but our import of some loomio.org groups failed so we blew away the db and started fresh. Now when a new user creates an account via SAML or when someone tries to create a group we get errors.

No groups are showing in `/admin` ("There are no Groups yet) yet when I try to create the group I want through the regular interface it says the group already exists. If I try to create the group via the admin interface I get

Internal Server Error

We're sorry, but something went wrong. We've been notified about this issue and we'll take a look at it shortly.

If I try to access the group directly I just get a page that says "You do not have permission to do this." (even though I'm an admin).

If I try to create a new group I see the same Internal Server Error in the browser and the following comes up in the Loomio logs

�2022-01-24T19:15:44.653904000Z method=POST path=/admin/groups format=html controller=Admin::GroupsController action=create status=500 error='ActionView::MissingTemplate: Missing template admin/groups/create, active_admin/resource/create, active_admin/base/create, inherited_resources/base/create, application/create with {:locale=>[:en], :formats=>[:html], :variants=>[], :handlers=>[:raw, :erb, :html, :builder, :ruby, :arb, :md, :coffee, :haml]}. Searched in:
72022-01-24T19:15:44.654166000Z   * "/loomio/app/views"
S2022-01-24T19:15:44.654292000Z   * "/usr/local/bundle/gems/blazer-2.5.0/app/views"
X2022-01-24T19:15:44.654402000Z   * "/usr/local/bundle/gems/activeadmin-2.9.0/app/views"
Z2022-01-24T19:15:44.654506000Z   * "/usr/local/bundle/gems/kaminari-core-1.2.1/app/views"
Y2022-01-24T19:15:44.654584000Z   * "/usr/local/bundle/gems/devise-i18n-1.10.1/app/views"
S2022-01-24T19:15:44.654673000Z   * "/usr/local/bundle/gems/devise-4.8.1/app/views"
Y2022-01-24T19:15:44.654888000Z   * "/usr/local/bundle/gems/actiontext-6.1.4.4/app/views"
\2022-01-24T19:15:44.654980000Z   * "/usr/local/bundle/gems/actionmailbox-6.1.4.4/app/views"
C2022-01-24T19:15:44.655068000Z ' duration=73.88 view=0.00 db=14.30
"2022-01-24T19:15:44.655638000Z   
`2022-01-24T19:15:44.655934000Z ActionView::MissingTemplate (Missing template admin/groups/create, active_admin/resource/create, active_admin/base/create, inherited_resources/base/create, application/create with {:locale=>[:en], :formats=>[:html], :variants=>[], :handlers=>[:raw, :erb, :html, :builder, :ruby, :arb, :md, :coffee, :haml]}. Searched in:
72022-01-24T19:15:44.656096000Z   * "/loomio/app/views"
S2022-01-24T19:15:44.656304000Z   * "/usr/local/bundle/gems/blazer-2.5.0/app/views"
X2022-01-24T19:15:44.656430000Z   * "/usr/local/bundle/gems/activeadmin-2.9.0/app/views"
Z2022-01-24T19:15:44.656614000Z   * "/usr/local/bundle/gems/kaminari-core-1.2.1/app/views"
Y2022-01-24T19:15:44.656754000Z   * "/usr/local/bundle/gems/devise-i18n-1.10.1/app/views"
S2022-01-24T19:15:44.656871000Z   * "/usr/local/bundle/gems/devise-4.8.1/app/views"
Y2022-01-24T19:15:44.657430000Z   * "/usr/local/bundle/gems/actiontext-6.1.4.4/app/views"
\2022-01-24T19:15:44.657589000Z   * "/usr/local/bundle/gems/actionmailbox-6.1.4.4/app/views"
"2022-01-24T19:15:44.657725000Z ):
"2022-01-24T19:15:44.657837000Z   
Y2022-01-24T19:15:44.657937000Z app/helpers/locales_helper.rb:8:in `use_preferred_locale'
V2022-01-24T19:15:44.660234000Z app/helpers/locales_helper.rb:3:in `process_time_zone'
�2022-01-24T19:15:44.668657000Z source=rack-timeout id=8b0a4f81-f9f6-4e12-80a7-82c293251ca2 timeout=15000ms service=95ms state=completed
w2022-01-24T19:15:44.922912000Z source=rack-timeout id=fa6042c0-5a00-4cc6-a83f-137617fcb973 timeout=15000ms state=ready
"2022-01-24T19:15:44.938021000Z   
�2022-01-24T19:15:44.938580000Z ActionController::RoutingError (No route matches [GET] "/assets/ahoy.self-655c5d58ea67a6f301610082eb641ea403bda9d8eed11d0ab90d9f09bcb6de7d.js"):
"2022-01-24T19:15:44.939129000Z   
w2022-01-24T19:15:44.942488000Z source=rack-timeout id=3b09aa4e-749e-4472-8849-8c5227d4c1e9 timeout=15000ms state=ready
"2022-01-24T19:15:44.947275000Z   
�2022-01-24T19:15:44.947769000Z ActionController::RoutingError (No route matches [GET] "/assets/angular_ahoy.self-7b70a106c4c0722e4f9db6ee0d9b9b1ae7252c3863e96b327c9674072fd58dad.js"):
"2022-01-24T19:15:44.948161000Z   
�2022-01-24T19:15:44.948509000Z source=rack-timeout id=3b09aa4e-749e-4472-8849-8c5227d4c1e9 timeout=15000ms service=6ms state=completed
�2022-01-24T19:15:44.949220000Z source=rack-timeout id=fa6042c0-5a00-4cc6-a83f-137617fcb973 timeout=15000ms service=27ms state=completed
w2022-01-24T19:15:44.988650000Z source=rack-timeout id=bf599b5d-165c-48b0-bac6-1ca7c1cf49bd timeout=15000ms state=ready
w2022-01-24T19:15:44.989981000Z source=rack-timeout id=1f4f333e-8ab8-4c11-94a2-4196738874e4 timeout=15000ms state=ready
"2022-01-24T19:15:44.993105000Z   
�2022-01-24T19:15:44.993303000Z ActionController::RoutingError (No route matches [GET] "/fonts/roboto-v18-latin-regular.woff2"):
"2022-01-24T19:15:44.993548000Z   
"2022-01-24T19:15:44.997255000Z   
|2022-01-24T19:15:44.997467000Z ActionController::RoutingError (No route matches [GET] "/fonts/roboto-v18-latin-700.woff2"):
"2022-01-24T19:15:44.997661000Z   
�2022-01-24T19:15:44.998609000Z source=rack-timeout id=1f4f333e-8ab8-4c11-94a2-4196738874e4 timeout=15000ms service=9ms state=completed
�2022-01-24T19:15:44.999530000Z source=rack-timeout id=bf599b5d-165c-48b0-bac6-1ca7c1cf49bd timeout=15000ms service=11ms state=completed

thoughts? Thanks v much.

RG

Robert Guthrie Tue 25 Jan 2022 7:17AM

Hi @Trav,

I'm a bit confused about this.

Did you want to start with a completely blank database, or are you trying to import your group data from loomio.org?

If you wanted a blank database, what commands did you run to clear the database?

If you want to import your old database, let me know, I might have to make some SQL to reset the sequences of your tables after the database has been imported.

Let me know :)

T

Trav Sun 15 May 2022 10:57AM

thanks for the reply. We gave up trying to import the data from loomio.org and started fresh.

RG

Robert Guthrie Tue 17 May 2022 8:04AM

Hi Trav. I've since rewritten the db import stuff, so if you wanted to import old data into your group you can now, it should just sit in behind your new stuff.

I hope you're still using and enjoying Loomio.