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

[Sanne Grinovero]

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 at redhat.com> 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 at hibernate.org>
> > To: "hibernate-dev" <hibernate-dev at lists.jboss.org>
> > 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 at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/hibernate-dev
>