Re: [otrs] DATA Corruption

On 08/19/2011 02:37 PM, Mik Rose wrote:

Its a postgresdb. Is there a similar method for postgres?

Mik Rose | Director, IT - Support Services | *PowerSoft Development Corp* 1 (250) 642-0295 x23 http://www.power-soft.com http://www.power-soft.com/ Live Support https://secure.logmeinrescue.com/Customer/Download.aspx?EntryID=15095831

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

On 2011-08-19, at 11:36 AM, Carlos Andrés Gallego Arboleda wrote:

...

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 mailto: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.

You would be better off posting this to the postgresql-users list.

-- Stephen Clark *NetWolves* Sr. Software Engineer III Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.clark@netwolves.com http://www.netwolves.com