if you dont stop the mysql during the data copy, maybe the DB is corrupted.

use this command.

mysqlcheck --repair -p otrs 

Regards.

2011/8/19 Mik Rose <mrose@power-soft.com>

Happy Friday people!

I was wondering if anyone had any suggestions on how to resolve this issue...  I am moving otrs to another server and during the backup process I am running into this error

pg_dump: dumping contents of table article_attachment


pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  unexpected chunk number 7 (expected 6) for toast value 77281 in pg_toast_57366

pg_dump: The command was: COPY public.article_attachment (id, article_id, filename, content_size, content_type, content, create_time, create_by, change_time, change_by, content_id, content_alternative) TO stdout;

pg_dump: *** aborted because of error

I have tried a vacuum and reindex with no successes.

Mik Rose 

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs