Unable To See Full List Of Errors + Warnings, Sqlyog.err Is Empty

[peterlaursen]

Have you tried simply to execute “SHOW WARNINGS;” from the editor after import?  Does this also truncate?  

[peterlaursen]

You may also execute “SHOW VARIABLES LIKE ‘warning_count’;” after the import. (refer https://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_warning_count).

 

The purpose of all this is to check how many warnings the server records and sends.  

[miguelexplorer]

Hi Peter,

 

Thanks for the speedy reply.

 

I was not aware of the “SHOW WARNINGS;” command – I’m clearly a SQL newbie here haha

Unfortunately the command result was also truncated, I checked and it was truncated at the exact same row as the “Show warnings” button and corresponding GUI display as shown in the screenshot earlier.

After executing the “SHOW WARNINGS;” command, from the “Messages” tab, I saw that “64 row(s)” were affected, a very suspicious binary number.

 

Curiously, running the “SHOW VARIABLES LIKE ‘warning_count’;” command returned a value of zero.

I re-imported again producing the same number of warnings and errors and ran the command again, still zero.

[peterlaursen]

1) If SHOW WARNING truncates it seems like it is the server that does. It probably has a fixed length buffer. We wll check this

 

2) I also noticed yesterday that ‘warning_count’ always seems to return “0”. I posted to bugs.mysql.com about this already http://bugs.mysql.com/bug.php?id=77883

[peterlaursen]

I now also posted this http://bugs.mysql.com/bug.php?id=77902

[peterlaursen]

Already had a reply in the last bug report.

 

Please see https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_error_count

 

.. and execute “SHOW  VARIABLES LIKE ‘max_error_count’;”. What does this return? 

[miguelexplorer]

Wow Peter, thank you for going the extra mile with all that legwork, I am grateful.

 

“SHOW  VARIABLES LIKE ‘max_error_count’;” returns 64 for me.

 

 

For the benefit of other SQL newbies who might be following:

If you wish to increase the “max_error_count” system variable, execute “SET max_error_count=x;” (acceptable values range from 0 – 65535)

Documentation: https://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_max_error_count

 

This will help to minimise any truncation of future warning reports.

 

 

My immediate issue of viewing the full warning log is now resolved. However, my error dump file is still always zero kb. Is this perhaps related to “warning_count”?

[peterlaursen]

I have already told that the sqlyog.err file records internal SQLyog errors only and not MySQL/server errors. Teherver logs its errors 8and optionally warnings) in its own error log – refer https://dev.mysql.com/doc/refman/5.6/en/error-log.html 

[Author]

Posts