Hi,
11.11.2009 21:24, Alan Brown wrote:
> On Mon, 9 Nov 2009, Alan Brown wrote:
>
>> Nor can I. 20 billion rows dumped when there should only be only 400
>> million in there and 3 billion ever written in.
>>
>> Arrgh...
>
> Arrgh indeed.
>
> To summarise: The file table was corrupt (innodb) and mysqldump was
> jumping back about 50 million entries every time it reached the highest
> FileId.
Sounds like a database bug to me.
> To fix it, I set mysqldump to produce INSERT IGNORE statements and just
> watched the output then aborted when it started looping, cleaned up the
> last line and manually added a mysqldump closing stanza.
>
> Mysql repeatedly segfaulted when trying to drop the table, so in the end I
> simply deleted the whole (all mysql files), reinstalled the server, reran
> the make_msyql_* files and then imported all the tables again.
>
> It's all going now, but I'm not happy with what happened an am considering
> options (including replication to a slave)
I suppose that replicating might simply replicate the original
problem, but worse - I imagine the master server starting to push the
data, cycling through it infinitely... I guess that on the slave
server you'll end up with an infinitely growing database. Well, I
recall that you've got lots of disk space in your organization ;-)
> Does anyone have stats on Postgres performance vs MySQL Innodb? Dan?
I'm not Dan, but look here:
http://sourceforge.net/apps/wordpress/bacula/category/performance/
at least a bit of an overview.
Arno
> AB
>
>
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
--
Arno Lehmann
IT-Service Lehmann
Sandstr. 6, 49080 Osnabrück
www.its-lehmann.de
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|