[App Server] Table Error

Anvil Q&A
1

Hello,

I am running the Anvil app server on an Amazon instance, and running into several problems:

i) Git cloned some of the demo apps - and it appears that one that do not require the User login etc. work fine. But any app with a User Login gives me the following error:

[ERROR anvil.app-server.run] Error report from client code:
Table Error:This table cannot be written or searched by this app

The app works fine on Anvil - any idea what could be causing this error >

Thanks for any help,

Arun

2

Since data is not transferred, user details is none unless it is created again.

Do the tables originally from another app?

3

Thanks. The app was git cloned from Anvil - where the user table was created.

So here is my question : How does one create the User table on the standalone app server? Are there instructions anywhere on how to do this?

4

Hi @frontpointsystems, please see my reply here:

5

Hi @frontpointsystems,

Do you get any warnings when launching the App Server? It sounds as though your tables aren’t being configured correctly.

There’s more information in the App Server documentation on configuring the Data Tables service. Please check that your anvil.yaml file contains a db_schema configuration - without this, the table won’t be created.

6

Thanks for the response - I did see a missing db-schema error message.
When I ran the app with the --auto-migrate option it seemed to fix the problem.

Another question though:
Noticed that when I start the app server it displays the message:
"Found Anvil App Server JAR in package directory "
but then takes several minutes before it displays the next msg before initializing the application. Is this normal? I am running the app server on an Amazon Lightsail instance with 512MB RAM.

Thanks,

7

Hi @frontpointsystems,

Glad to hear auto-migrate did the trick.

The loading time is just down to the size of your machine - I’d suggest you try something a little more powerful.