An embarrasing mistake

I just learned this afternoon that I've done the unthinkable, from a publishing perspective. I submitted a poem to www.redchinamagazine.com that had years before been published in 2River magazine, and I never gave attribution or warning to the editors. It's unthinkable not just because I oppose this practice (including its less appealing form, simultaneous submission), but because it potentially reflects badly on the two magazines and their editors.

This brings up a question for discussion. How do writers, especially poets and particularly those who've published over a lifetime, how do they keep records? I suspect that, as in any other "business," there are keepers of meticulous records and there are sloppy record keepers. I've always prided myself on being the former. Everything that goes out also goes into a folder on my hard drive so that I know what piece went to whom and when. Purists might object, but I think most people would applaud my administrative efforts. Anyway, it's not like I'm prolific or that I submit every day. I should be able to keep track!

I'm curious to know how others manage the minutiae of publishing (assuming that most poets can't afford and don't have literary agents or secretaries to manage for them). I wonder, is there a database one can use to automatically warn against submitting previously published work?