Download Bot Libre Desktop, your own personal bot for your PC or Mac
Bugs and Features

Can't delete Memory knowledge

by Gandolfos posted Mar 2 2014, 1:16

when i delete memory, than the number is count up. why?

Warning like this:
2014-03-02 01:17:44.67 - WARNING -- DatabaseMemory(active(0), long(0)):javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20130919-377691b): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "rl_meta_indx2" already exists
Error Code: 0
Call: create index RL_META_INDX2 on RELATIONSHIP (META_ID)
Query: DataModifyQuery(sql="create index RL_META_INDX2 on RELATIONSHIP (META_ID)")


by admin posted Mar 2 2014, 7:56
Hello Gandolfos,
  What bot are you trying to erase? Give me the name, and I will take a look at it. Do you want me to erase its entire memory?

Note, when you erase a bot's memory it will rebootstrap, so its memory will not be left a 0, but it should not go up, that would mean the erase failed, possibly due to database locks. The error above is normal and not the issue (it is just checking that an index was created).

Updated: Mar 2 2014, 7:57
Thumbs up: 0, thumbs down: 0, stars: 0.0
Views: 4364, today: 1, week: 4, month: 34

by Gandolfos posted Mar 2 2014, 22:22
Hi,

its ok, i want to delete the complete bot. "TravelrBot"

there are some other problems with rss. cant delete rss feed permanently. next day it is back!

but now i have problems to delete the complete bot, here the error message:

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20130919-377691b): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: update or delete on table "pandorainstance" violates foreign key constraint "fk_chatchannel_bot_id" on table "chatchannel"
  Detail: Key (id)=(12263) is still referenced from table "chatchannel".
Error Code: 0
Call: DELETE FROM PANDORAINSTANCE WHERE (ID = ?)
bind => [12263]
Query: DeleteObjectQuery(PandoraInstance(TravelrBot))

please delete this bot.

cheers Gandolfos

Thumbs up: 0, thumbs down: 0, stars: 0.0
Views: 5148, today: 0, week: 8, month: 59

by admin posted Mar 3 2014, 4:27
The issue was that there was a live chat room still pointing to your bot, so it could not be deleted until its reference from the chat room was removed. I have deleted your bot, and fixed the issue to automatically remove bot references on delete.

Thank you for reporting the Twitter feed issue, I have fixed it, and should update the website sometime this week. For now you can just put a single invalid feed in your RSS so it will not post anything.

Thumbs up: 0, thumbs down: 0, stars: 0.0
Views: 4439, today: 0, week: 3, month: 41

Id: 12376
Tags: memory twitter
Posted: Mar 2 2014, 1:16
Updated: Mar 2 2014, 1:19
Replies: 1
Views: 3237, today: 1, week: 4, month: 31
0 0 0.0/5