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@lists.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
