SQLTrackerStore

Hello!

I configured my project Rasa 1.0.6 to use SQLTrackerStore. It is a database in Oracle.

However, when I run rasa shell, it starts succesfully but does answer the messages. It seens that it is freezed.

Your input -> oi 2019-06-12 17:28:45 DEBUG rasa.core.agent - Created a new lock for conversation ‘default’ 2019-06-12 17:28:45 DEBUG rasa.core.tracker_store - Can’t retrieve tracker matchingsender id ‘default’ from SQL storage. Returning None instead. 2019-06-12 17:28:45 DEBUG rasa.core.agent - Deleted lock for conversation ‘default’ (unused)

Nothing happens after the user message. If I wait, I receive a timeout error. If I turn off the SQLTrackerStore, it works gracefully.

Help?

Can you post the full log? Can you see the database logs? What’s the content of your endpoints.yml?

The full log is this:

2019-06-19 08:36:59 DEBUG rasa.model - Extracted model to ‘C:\Users\ALESSA~1\AppData\Local\Temp\tmp5e_03nmv’.

2019-06-19 08:36:59 DEBUG rasa.cli.utils - Parameter ‘endpoints’ not set. Using default location ‘endpoints.yml’ instead.

2019-06-19 08:36:59 DEBUG rasa.cli.utils - Parameter ‘credentials’ not set. Using default location ‘credentials.yml’ instead.

2019-06-19 08:37:02 DEBUG rasa.model - Extracted model to ‘C:\Users\ALESSA~1\AppData\Local\Temp\tmp619o1kvw’.

2019-06-19 08:37:02 DEBUG sanic.root - CORS: Configuring CORS with resources: {’/’: {‘origins’: [’’], ‘methods’: ‘DELETE, GET, HEAD, OPTIONS, PATCH, POST, PUT’, ‘allow_headers’: [’.’], ‘expose_headers’: None, ‘supports_credentials’: False, ‘max_age’: None, ‘send_wildcard’: False, ‘automatic_options’: True, ‘vary_header’: True, ‘resources’: {’/*’: {‘origins’: ‘’}}, ‘intercept_exceptions’: True, ‘always_send’: True}}

2019-06-19 08:37:02 DEBUG rasa.core.utils - Available web server routes: /webhooks/rest GET custom_webhook_CmdlineInput.health /webhooks/rest/webhook POST custom_webhook_CmdlineInput.receive

2019-06-19 08:37:02 INFO root - Starting Rasa Core server on http://localhost:5005

2019-06-19 08:37:02 INFO root - Enabling coroutine debugging. Loop id 2418197510856.

2019-06-19 08:37:03 DEBUG rasa.model - Extracted model to ‘C:\Users\ALESSA~1\AppData\Local\Temp\tmpgiumkqi8’.

2019-06-19 08:37:03 DEBUG rasa.core.tracker_store - Attempting to connect to database via "oracle://CHATBOT:@10.1.1.216:1521/dese"*

2019-06-19 08:37:04 DEBUG rasa.core.tracker_store - Connection to SQL database ‘dese’ successful

2019-06-19 08:37:04 DEBUG rasa.model - Extracted model to ‘C:\Users\ALESSA~1\AppData\Local\Temp\tmpqqgs6ta7’. Bot loaded. Type a message and press enter (use ‘/stop’ to exit):

Your input -> oi!

2019-06-19 08:49:06 DEBUG rasa.core.agent - Created a new lock for conversation 'default’

2019-06-19 08:49:06 DEBUG rasa.core.tracker_store - Can’t retrieve tracker matchingsender id ‘default’ from SQL storage. Returning None instead.

2019-06-19 08:49:06 DEBUG rasa.core.agent - Deleted lock for conversation ‘default’ (unused)

It stops at this points and do not continue. It is not saving anything in the database. When I turn off SQLTracker, then it works correctly.

The difficulty is that nothing happens, just freezes.

My endpoints.yml is like this:

action_endpoint: url: ‘http://localhost:5055/webhook

tracker_store: type: SQL dialect: “oracle” # the dialect used to interact with the db url: “10.1.1.216” # (optional) host of the sql db port: “1521” db: “dese” # path to your db username: “CHATBOT” # username used for authentication password: “teste” # password used for authentication

The problem was solved. When using rasa shell, the error is not shown. When I turned to use rasa run, the error was shown and it was related to autoincrement key in the database.

Now everything is working fine. :wink:

1 Like

Hi @alessandrarequena

I was looking for messages about Oracle TrackerStore problems, and only find your messages.

My error is different:

“Error happened when trying to save conversation tracker to ‘SQLTrackerStore’. Falling back to use the ‘InMemoryTrackerStore’. Please investigate the following error: (cx_Oracle.DatabaseError) ORA-00942: table or view does not exist”.

I do not have direct access to servers, configs, etc. I asked help from the responsibles for that, but I wonder if you had the same error while you’re working on you TrackerStore, so I can give more information to help them solve the problem… Did you face an error like that?