After some further troubleshooting I finally found out what was wrong. In fact there was an easy explanation. After migrating the data from mySQL to PostgreSQL, I had forgotten to set the sequences to the proper value. The insert statements then often lead to primary key violations. ALTER SEQUENCE RESTART WITH xxxxxx did the trick.
Regards --Marcel ---original message Hi all Yesterday I migrated a DBMAIL 1.x installation to DBMAIL 2.0.7 w/MySQL, then I converted the database to Postgresql 8.0.3. Everything seemed to work well at first glance. Meanwhile, I filled up the database (about 60'000 messageblks), and now I have problems creating folders or storing the outgoing mails in the INBOX/Sent folder. TRACE_LEVEL=5 in the [IMAP] section reveals the following errors: Oct 11 17:16:05 test dbmail/imap4d[20086]: dbpgsql.c,db_free_result: trying to free a result set that is already NULL! I'm using Squirrelmail 1.4.3a-12.EL4.centos4 running on CentOS 4.1. I have an older installation on RHEL3 with DBMAIL 2.0.1 and PostgreSQL 7.4.6 working without problems. The database structures are identical (except some ON UPDATE CASCADE sentences). Any ideas would very much be appreciated. Regards --Marcel Any ideas?
