DBI has logging facilities; you could try to set up the log level and see if anything suspicious comes up.

Update: I really meant DBI's tracing facilities, not the ones from DBIx::Class

Oh, and I remember something where I similar weird database problems when I had an autoincrementing column in postgres and manually inserted some values into it without telling it rebuild whatever it needs to rebuild.