> -----Original Message----- > From: Marcus Bointon [mailto:[EMAIL PROTECTED] > Sent: den 18 februari 2005 14:47 > To: mysql@lists.mysql.com > Subject: log-warnings > > I'm migrating a MySQL 3.23 db to 4.1.10 (on Linux x86) and > I'm getting some infrequent warnings when importing data > dumps created with mysqldump, but I can't seem to find out > what the warnings are. > > I'm typically importing around 100,000 records at a time, so > using 'SHOW WARNINGS' manually is no use - and I can't yet > nail down a query that actually generates a warning anyway. > > I can start the mysql client using -v, but as even at the > lowest level or verbosity it always displays the query, and > since my inserts are often 30k per record, it's just not > practical to scan the output, plus it makes it go very slowly. > > I've got log-warnings in my my.cnf file, and mysqld is > definitely picking it up (adding it made log-warnings appear > as set to 2, though I can't find any reference in the docs > for what the values mean), but mysql is not logging any > warnings at all. > > I have log-error=/var/lib/mysql/mysql.err set in my.cnf, and > again it's definitely being picked up by the server. > > If it makes a difference, I'm using all InnoDB tables. > > All I need is for warnings to be logged along with the query > that caused it without having to log everything and trawl > through it - what have I missed?!
I would approach this problem by isolating the where the problem occurs. I.e. Remove, comment out, half of you insert queries and see if the problem still exists. If it does, then remove yet another half of the remaining part leaving only 1/4 of the original problem to solve. This would give the solution in approximately log(n) times where n is number of parts you can remove. I.e. If you have 100 different inserts, you would find the correct one in about 5 tries. This is of course the brute method you always fall back to when you don't even know where the problem exists. Having 100 000 different inserts would increase the number of tries to 11 or 12. /Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
