Hi, On Rasa X, when I try to create intents using interactive mode I get an exception in the console .I get below error when I interact on the interactive learning tab to test the base model . Could not save event of type ‘action’ with timestamp. Please help on resolving this issue. The detailed stack trace is WARNING:rasax.community.services.event_consumers.event_consumer:Could not save event of type ‘action’ with timestamp '1584943030.4710948 for conversation ID ‘c2963f1fda6c4fbaaeb35445bfc5c774’ because it already exists. WARNING:rasax.community.services.event_consumers.event_consumer:Could not save event due to unknown error: ‘This Session’s transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.IntegrityError) UNIQUE constraint failed: conversation_event.conversation_id, conversation_event.timestamp, conversation_event.type_name [SQL: INSERT INTO conversation_event (conversation_id, type_name, timestamp, intent_name, action_name, slot_name, slot_value, policy, is_flagged, data, evaluation, rasa_environment) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: (‘c2963f1fda6c4fbaaeb35445bfc5c774’, ‘action’, 1584943030.4710948, None, ‘action_listen’, None, None, None, 0, ‘{“sender_id”: “c2963f1fda6c4fbaaeb35445bfc5c774”, “event”: “action”, “timestamp”: 1584943030.4710948, “name”: “action_listen”, “policy”: null, “confidence”: null}’, None, ‘production’)] (Background on this error at: http://sqlalche.me/e/gkpj ) (Background on this error at: http://sqlalche.me/e/7s2a )’ WARNING:rasax.community.services.event_consumers.event_consumer:Could not save event due to unknown error: ‘This Session’s transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.IntegrityError) UNIQUE constraint failed: conversation_event.conversation_id, conversation_event.timestamp, conversation_event.type_name [SQL: INSERT INTO conversation_event (conversation_id, type_name, timestamp, intent_name, action_name, slot_name, slot_value, policy, is_flagged, data, evaluation, rasa_environment) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: (‘c2963f1fda6c4fbaaeb35445bfc5c774’, ‘action’, 1584943030.4710948, None, ‘action_listen’, None, None, None, 0, ‘{“sender_id”: “c2963f1fda6c4fbaaeb35445bfc5c774”, “event”: “action”, “timestamp”: 1584943030.4710948, “name”: “action_listen”, “policy”: null, “confidence”: null}’, None, ‘production’)] (Background on this error at: http://sqlalche.me/e/gkpj ) (Background on this error at: http://sqlalche.me/e/7s2a )’ Thanks, Nivedita

Hi I created a new virtual environment and I installed the rasa x. Error messages appear: ERROR: mysql-connector-python 8.0.19 has requirement protobuf==3.6.1, but you’ll have protobuf 3.11.3 which is incompatible. ERROR: rasa 1.9.5 has requirement prompt-toolkit<3.0,>=2.0, but you’ll have prompt-toolkit 3.0.5 which is incompatible. For the 2nd error message I replaced the prompt-toolkit with the command : pip install prompt-toolkit==2.0.10 I couldn’t handle the first message. I deleted all finds ending with db , db-shm or db-wal and previous models from my bot. After that I face the same issue.

Hello @Tobias_Wochinger @hello-code @niveditapdixit @PantelisAntoniadis I have exactly the same issue as described by @PantelisAntoniadis . I was using rasa x and rasa shell in previous version as 0.23.1 and 1.4.5 respectively. recently i upgraded my rasa on global and i started facing these issues. Then i followed the steps of installing rasa in a virtual env using this YouTube link. Rasa shell worked perfectly fine but when i tried using rasa x it said rasa x module not found. so i installed rasa x using pip3 install rasa-x --extra-index-url https://pypi.rasa.com/simple then rasa x started but i had the same issues afterwards i had the same issue as @PantelisAntoniadis . As per your solution @Tobias_Wochinger to remove db , db-shm or db-wal files. I figured that whenever i run rasa x command it is automatically created db , db-shm or db-wal files in the virtual environment. Microsoft Visual C++ is already installed. Help us deal with it.

Hello @PantelisAntoniadis @hello-code @Tobias_Wochinger @niveditapdixit i still dont know why rasa 1.9.5 and rasa-x 0.27.4 are not working but here are the few steps that i did to revert to my previous versions i.e rasa 1.4.5 and rasa-x 0.23.1 which used to work fine. I uninstalled rasa and rasa-x using pip : pip uninstall rasa pip uninstall rasa-x after installing i installed a previous version of rasa using : pip install rasa==1.4.5 then i went to Pypicloud and downloaded a version older i.e 0.23.1 i.e rasa-x-0.23.1.tar and saved it to my root directory of anaconda prompt when open (in windows it is C:\Windows\System32) then i run following command : pip install rasa-x-0.23.1.tar and it install rasa -x 0.23.1 also in my system. and everything returned to normal. But the question why i didnt worked with rasa-x version 0.27.1 and how to remove file like db , db-shm or db-wal. Because the issue is of it. i reinstalled my ananconda env and also tried virtual env. @Tobias_Wochinger please look into this issue for windows 10. python = 3.7.7 pip = 20.2.2 rasa = latest 1.9.5 rasa x = latest 0.27.4

Hi @Tobias_Wochinger , Tried below, getting the same error of Could not save event of type ‘action’ with timestamp ‘’ for conversation ID ‘’. Please help. Move / delete all finds ending with db , db-shm or db-wal Move / delete the models directory and train a new model from scratch The exception trace is WARNING:rasax.community.services.event_consumers.event_consumer:Could not save event of type ‘action’ with timestamp '1586759347.1013398 for conversation ID ‘8bd333f852184aada1f56116ab429b59’ because it already exists. WARNING:rasax.community.services.event_consumers.event_consumer:Could not save event due to unknown error: ‘This Session’s transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.IntegrityError) UNIQUE constraint failed: conversation_event.conversation_id, conversation_event.timestamp, conversation_event.type_name [SQL: INSERT INTO conversation_event (conversation_id, type_name, timestamp, intent_name, action_name, slot_name, slot_value, policy, is_flagged, data, evaluation, rasa_environment) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: (‘8bd333f852184aada1f56116ab429b59’, ‘action’, 1586759347.1013398, None, ‘action_listen’, None, None, None, 0, ‘{“sender_id”: “8bd333f852184aada1f56116ab429b59”, “event”: “action”, “timestamp”: 1586759347.1013398, “name”: “action_listen”, “policy”: null, “confidence”: null}’, None, ‘production’)] (Background on this error at: http://sqlalche.me/e/gkpj ) (Background on this error at: http://sqlalche.me/e/7s2a )’ WARNING:rasax.community.services.event_consumers.event_consumer:Could not save event due to unknown error: ‘This Session’s transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.IntegrityError) UNIQUE constraint failed: conversation_event.conversation_id, conversation_event.timestamp, conversation_event.type_name [SQL: INSERT INTO conversation_event (conversation_id, type_name, timestamp, intent_name, action_name, slot_name, slot_value, policy, is_flagged, data, evaluation, rasa_environment) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: (‘8bd333f852184aada1f56116ab429b59’, ‘action’, 1586759347.1013398, None, ‘action_listen’, None, None, None, 0, ‘{“sender_id”: “8bd333f852184aada1f56116ab429b59”, “event”: “action”, “timestamp”: 1586759347.1013398, “name”: “action_listen”, “policy”: null, “confidence”: null}’, None, ‘production’)] (Background on this error at: http://sqlalche.me/e/gkpj ) (Background on this error at: http://sqlalche.me/e/7s2a )’ Thanks, Nivedita

[image] niveditapdixit: Session.rollback(). Original exception was: (sqlite3.IntegrityError) I think its a issue still not solved: [image] Chatbot does not function in Rasa X [Deprecated] Rasa X Community Edition Hello, since the update to Rasa X 0.26.1, when starting Rasa X all intents are shown to be unknown, though they are listed in the domain file and no errors occur during training or when running the bot via command line. [grafik] Additionally the errors in white occur when talking to the bot either via “Talking with your bot” or “Share with guest tester”. Anything I can do besides rolling back to an older Rasa version? No changes have been made to the bot itself, which worked without issues…

[image] niveditapdixit: WARNING:rasax.community.services.event_consumers.event_consumer:Could not save event of type ‘action’ with timestamp '1586759347.1013398 for conversation ID ‘8bd333f852184aada1f56116ab429b59’ because it already exists. mhm, this error seems weird. Any idea how there can be duplicate conversation events?

Hi Tobias, I am also facing the same issue as @niveditapdixit . I am running rasa X in my local windows 10 machine. I updated rasa X to the latest version 0.27.6 but still facing the same issue. Is there a workaround for this? Regards, Anand

hi @anandtest94 , welcome to the community! Do you see anything interesting in the logs? Did you use rasa export or any idea if there could have been duplicate conversation events?

@PantelisAntoniadis @anandtest94 @Tobias_Wochinger hello, I am also facing the same issue in Rasa X [image] please let me know how to solve this issue. Rasa = 1.9.5 rasa x=0.27.4 Thank you. Akhil

Could not save event of type 'action' with timestamp

[Deprecated] Rasa X Community Edition

athenasaurav (Athenasaurav) April 13, 2020, 6:42am 10

I think its a issue still not solved:

Topic		Replies	Views
Saving event failed due to integrity error [Deprecated] Rasa X Community Edition	48	2586	December 31, 2021
Rasa X: the bot is hanging, 'listening', instead of answering [Deprecated] Rasa X Community Edition	15	1414	June 10, 2020
rasax.community.services.event_consumers.event_consumer:Saving event failed due to an 'IntegrityError' [Deprecated] Rasa X Community Edition	6	1752	May 30, 2021
'IntegrityError', My bot on Rasa X doesn't respond [Deprecated] Rasa X Community Edition	5	1775	September 14, 2020
Rasa x Integrity error rasa version 1.10.12 and rasa-x 0.32.2 Rasa Open Source	2	633	September 21, 2020

Could not save event of type 'action' with timestamp

Related topics