Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

access violation by corrupted table

Mitchell Lee's profile image Mitchell Lee posted 4 weeks ago in General Permalink

when click the corrupted table name on treeview, it happened.

SELECT * FROM information_schema.VIEWS WHERE TABLE_SCHEMA='ssssssssss' AND TABLE_NAME='ssssssssssssssssssssssssssssssssssssssssss';
/* Result #1 fetched. */
/* Detected column type for TABLE_CATALOG: VARCHAR */
/* Detected column type for TABLE_SCHEMA: VARCHAR */
/* Detected column type for TABLE_NAME: VARCHAR */
/* Detected column type for VIEW_DEFINITION: TEXT */
/* Detected column type for CHECK_OPTION: VARCHAR */
/* Detected column type for IS_UPDATABLE: VARCHAR */
/* Detected column type for DEFINER: VARCHAR */
/* Detected column type for SECURITY_TYPE: VARCHAR */
/* Detected column type for CHARACTER_SET_CLIENT: VARCHAR */
/* Detected column type for COLLATION_CONNECTION: VARCHAR */
/* Detected column type for ALGORITHM: VARCHAR */
/* Access violation at address 0000000000CF5EA0 in module 'heidisql.exe'. Read of address 0000000000000030 */
ansgar's profile image ansgar posted 4 weeks ago Permalink

Is that error shown in a dialog, or just in the log panel? If it's just in the log panel please ignore this.

ansgar's profile image ansgar posted 4 weeks ago Permalink

You should also disable debug logging, in Tools > Preferences > Logging.

Mitchell Lee's profile image Mitchell Lee posted 4 weeks ago Permalink

Er, the reason why user click the table name that already corrupted is to use 'DROP' context menu. but any of command of context menu are not working. thats why report to you. Any improvement will be welcome.

Mitchell Lee's profile image Mitchell Lee posted 4 weeks ago Permalink

To reproduce the symptom under normal condition mysql/mariadb would be..... shutdown db > go to data folder > and go into any of folder that database > find any of file that you want to make corrupt which have '*ibd' extension > edit bytes or truncate contents > restart db

ansgar's profile image ansgar posted 4 weeks ago Permalink

Please report that in the issue tracker.

Mitchell Lee's profile image Mitchell Lee posted 4 weeks ago Permalink

as #1570

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.