7.0.2 issues / Geocrawler

Well, I took Thomas' advice and upgraded to 7.0.2 from source.tar.gz.

For some reason, I cannot create the following index:

db_geocrawler=# DROP INDEX idx_mail_archive_list_subject;
ERROR: index "idx_mail_archive_list_subject" nonexistent

db_geocrawler=# CREATE INDEX "idx_mail_archive_list_subject" on
"tbl_mail_archive" using btree ( "fld_mail_
list" "int4_ops", "fld_mail_subject" "text_ops" );
ERROR: cannot create idx_mail_archive_list_subject

[root(at)geocrawler db_geocrawler]# rm -f idx_mail_archive_list_subject

That removes the physical file on disk, so I can then try to create it
again. If I then issue the SQL command, postgres accepts it and it runs
forever, never creating more than an 8192 byte file.

If you watch your process list:

[root(at)geocrawler db_geocrawler]# ps ax
PID TTY STAT TIME COMMAND
457 ? SW 0:00 [postmaster]
1419 ? R 1:34 [postmaster]

Eventually, the psql connection disappears from the process list and I
get strange postmaster processes running (see above).

After that, I get this error from psql:

ERROR: btree: index item size 2820 exceeds maximum 2717

Any way to tell where that item is at?

From the pgserver.log file:

DEBUG: Data Base System is starting up at Tue Jul 11 16:59:33 2000
DEBUG: Data Base System was interrupted being in production at Tue Jul
11 15:47:04 2000
DEBUG: Data Base System is in production state at Tue Jul 11 16:59:33
2000

...Doesn't give me much to go on.

I'm really at wits end - I've spent over two days trying to rebuild
Geocrawler.

Next step is reformatting the hard disk and reinstalling postgres 6.4.2.

Tim

--
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723