Re: [hibernate-dev] in.relation.to error when posting a new blog entry

From: "Sanne Grinovero" <sanne(a)hibernate.org&gt; To: "Gail Badner" <gbadner(a)redhat.com&gt;, "Davide D'Alto" <davide(a)hibernate.org&gt; Cc: "hibernate-dev" <hibernate-dev(a)lists.jboss.org&gt;, "Sanne Grinovero" <sanne(a)hibernate.org&gt; Sent: Wednesday, February 11, 2015 10:57:55 PM Subject: Re: [hibernate-dev] in.relation.to error when posting a new blog entry Hi, sorry I forgot about this and I'm currently away so if someone could look at it that would be great. I suspect it's a broken foreign key on MySQL, hopefully the error message will have some details? Some table maintenance should do the trick. You'll have to ssh into in.relation.to and from there connect to the MySQL console. The connection details are in the datasource description deployed in the AS (I don't remember them but that's a good place to read the hostname and access credentials to the db). The firewall on the db server will not allow you to connect from your own place, so make sure you use the MySQL console from the in.relation.to server. An alternative might be to use the AWS dashboard, maybe it has some tools for db maintenance? I usually use the terminal myself. Thanks Sanne On Thu, 12 Feb 2015 02:36 Gail Badner <gbadner(a)redhat.com&gt; wrote: > I ran into the same thing a couple of weeks ago when I deleted some spam > comments before trying to create new weblog. I asked Sanne about this and > he mentioned that he's seen this happen after deleting spam comments. He > said it would require some clean up, but he didn't have time. > > Sanne, I know you're very busy. Can you point one of us in the right > direction to clean up what is necessary? > > Thanks, > Gail > ----- Original Message ----- > > From: "Davide D'Alto" <davide(a)hibernate.org&gt; > > To: "hibernate-dev" <hibernate-dev(a)lists.jboss.org&gt; > > Sent: Wednesday, February 11, 2015 7:42:52 AM > > Subject: [hibernate-dev] in.relation.to error when posting a new blog > entry > > > > Hi, > > I'm trying to create a new blog entry on in.relation.to > > but an exception occurs about the violation of an integrity constraint. > > > > Any idea on how to solve the issue? > > > > Thanks, > > Davide > > > > _______________________________________________ > > hibernate-dev mailing list > > hibernate-dev(a)lists.jboss.org > > https://lists.jboss.org/mailman/listinfo/hibernate-dev >