AV

Allineer's profile image Allineer posted 12 years ago in General Permalink
date/time         : 2012-03-29, 11:28:06, 35ms
computer name     : GRIMM
user name         : Администратор <admin>
registered owner  : Максим
operating system  : Windows 7 x64 Service Pack 1 build 7601
system language   : Russian
system up time    : 1 hour 4 minutes
program up time   : 1 hour 1 minute
processor         : Intel(R) Core(TM)2 Solo CPU U3500 @ 1.40GHz
physical memory   : 2961/4063 MB (free/total)
free disk space   : (C:) 8,42 GB (Z:) 94,15 GB
display mode      : 1366x768, 32 bit
process id        : $744
allocated memory  : 54,28 MB
executable        : heidisql.exe
exec. date/time   : 2012-03-28 10:01
version           : 7.0.0.4112
compiled with     : Delphi XE
madExcept version : 3.0m beta 1
callstack crc     : $5e54538a, $168cf91d, $168cf91d
exception number  : 1
exception class   : EAccessViolation
exception message : Access violation at address 7160DC47 in module 'libmysql.dll'. Read of address 00000380.
thread $9c0 (TQueryThread):
7160dc47 libmysql.dll                       mysql_next_result
0070d93b heidisql.exe dbconnection 1374 +56 TMySQLConnection.Query
0067c900 heidisql.exe helpers      2655 +41 TQueryThread.Execute
004605af heidisql.exe madExcept             HookedTThreadExecute
004a8d4e heidisql.exe Classes               ThreadProc
00407358 heidisql.exe System        549  +0 ThreadWrapper
00460491 heidisql.exe madExcept             CallThreadProcSafe
004604fb heidisql.exe madExcept             ThreadExceptFrame
75fa3398 kernel32.dll                       BaseThreadInitThunk
>> created by main thread ($80c) at:
0067c636 heidisql.exe helpers      2589  +1 TQueryThread.Create
main thread ($80c):
00000000 heidisql.exe madStackTrace +0 StackAddrToStr
>> stack will be calculated soon


date/time         : 2012-03-29, 11:32:01, 266ms
computer name     : GRIMM
user name         : Администратор <admin>
registered owner  : Максим
operating system  : Windows 7 x64 Service Pack 1 build 7601
system language   : Russian
system up time    : 1 hour 8 minutes
program up time   : 3 minutes 15 seconds
processor         : Intel(R) Core(TM)2 Solo CPU U3500 @ 1.40GHz
physical memory   : 2950/4063 MB (free/total)
free disk space   : (C:) 8,42 GB (Z:) 94,15 GB
display mode      : 1366x768, 32 bit
process id        : $b44
allocated memory  : 53,82 MB
executable        : heidisql.exe
exec. date/time   : 2012-03-28 10:01
version           : 7.0.0.4112
compiled with     : Delphi XE
madExcept version : 3.0m beta 1
callstack crc     : $5e54538a, $168cf91d, $168cf91d
exception number  : 1
exception class   : EAccessViolation
exception message : Access violation at address 7160DC47 in module 'libmysql.dll'. Read of address 00000380.
thread $b00 (TQueryThread):
7160dc47 libmysql.dll                       mysql_next_result
0070d93b heidisql.exe dbconnection 1374 +56 TMySQLConnection.Query
0067c900 heidisql.exe helpers      2655 +41 TQueryThread.Execute
004605af heidisql.exe madExcept             HookedTThreadExecute
004a8d4e heidisql.exe Classes               ThreadProc
00407358 heidisql.exe System        549  +0 ThreadWrapper
00460491 heidisql.exe madExcept             CallThreadProcSafe
004604fb heidisql.exe madExcept             ThreadExceptFrame
75fa3398 kernel32.dll                       BaseThreadInitThunk
>> created by main thread ($ad8) at:
0067c636 heidisql.exe helpers      2589  +1 TQueryThread.Create
main thread ($ad8):
00000000 heidisql.exe madStackTrace +0 StackAddrToStr
>> stack will be calculated soon


date/time         : 2012-03-29, 11:35:49, 402ms
computer name     : GRIMM
user name         : Администратор <admin>
registered owner  : Максим
operating system  : Windows 7 x64 Service Pack 1 build 7601
system language   : Russian
system up time    : 1 hour 12 minutes
program up time   : 3 minutes 37 seconds
processor         : Intel(R) Core(TM)2 Solo CPU U3500 @ 1.40GHz
physical memory   : 2933/4063 MB (free/total)
free disk space   : (C:) 8,42 GB (Z:) 94,15 GB
display mode      : 1366x768, 32 bit
process id        : $12c
allocated memory  : 53,79 MB
executable        : heidisql.exe
exec. date/time   : 2012-03-28 10:01
version           : 7.0.0.4112
compiled with     : Delphi XE
madExcept version : 3.0m beta 1
callstack crc     : $5e54538a, $168cf91d, $168cf91d
exception number  : 1
exception class   : EAccessViolation
exception message : Access violation at address 6E3EDC47 in module 'libmysql.dll'. Read of address 00000380.
thread $1e8 (TQueryThread):
6e3edc47 libmysql.dll                       mysql_next_result
0070d93b heidisql.exe dbconnection 1374 +56 TMySQLConnection.Query
0067c900 heidisql.exe helpers      2655 +41 TQueryThread.Execute
004605af heidisql.exe madExcept             HookedTThreadExecute
004a8d4e heidisql.exe Classes               ThreadProc
00407358 heidisql.exe System        549  +0 ThreadWrapper
00460491 heidisql.exe madExcept             CallThreadProcSafe
004604fb heidisql.exe madExcept             ThreadExceptFrame
75fa3398 kernel32.dll                       BaseThreadInitThunk
>> created by main thread ($bd4) at:
0067c636 heidisql.exe helpers      2589  +1 TQueryThread.Create
main thread ($bd4):
00000000 heidisql.exe madStackTrace +0 StackAddrToStr
>> stack will be calculated soon


table:

CREATE TABLE `api_csvs` (
`group_id` INT(3) UNSIGNED NOT NULL DEFAULT '0',
`trigger` VARCHAR(50) NOT NULL DEFAULT '',
`id` INT(6) UNSIGNED NOT NULL DEFAULT '0',
`filename` VARCHAR(255) NOT NULL DEFAULT '',
`sizetag` VARCHAR(50) NULL DEFAULT NULL,
`state` INT(1) NOT NULL DEFAULT '0',
`revision` INT(1) NOT NULL DEFAULT '0',
`DT` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`csv_size` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`crc32` VARCHAR(8) NOT NULL DEFAULT '',
`files_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`files_size` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`pics_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`pics_size` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`author` VARCHAR(50) NOT NULL DEFAULT '',
`comment` BLOB NULL,
`content` MEDIUMBLOB NULL,
`content_crc32` VARCHAR(8) NULL DEFAULT NULL,
`content_size` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`downloaded` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`is_old` INT(1) UNSIGNED NOT NULL DEFAULT '0',
`is_deleted` INT(1) UNSIGNED NOT NULL DEFAULT '0',
`DTLM` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`my_csv` INT(1) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`trigger`, `id`),
UNIQUE INDEX `id` (`id`),
INDEX `crc32` (`crc32`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;


91433 rows, size of table as Heidi shows - 2.3Gb

query:
[code][/code]
Allineer's profile image Allineer posted 12 years ago Permalink
query:

SELECT COUNT(id)
FROM api_csvs
WHERE content IS NULL
ansgar's profile image ansgar posted 12 years ago Permalink
Cannot reproduce that here. Did you ever update your libmysql.dll? Could be you're using an old one, as the error happens in that dll. To find out the version of that dll, just hover your mouse over Heidi's status bar panel which tells you the server version (e.g. "MySQL 5.1.2"). In the hint popup you will find a "Client version" - please report back.
Allineer's profile image Allineer posted 12 years ago Permalink
5.2.10-MariaDB

I do not update libmysql.dll manually - only use updater.
Allineer's profile image Allineer posted 12 years ago Permalink
I can give you RO-access to the table if you need.
ansgar's profile image ansgar posted 12 years ago Permalink
Well, that version is ok - it is the one from the latest installer. But however, the above callstack shows the error is within that lib somewhere. The relevant code parts in HeidiSQL look ok to me, nothing extravagant in it. Can you reproduce that exception?
Allineer's profile image Allineer posted 12 years ago Permalink
Error occurs very often when I run the query with "SELECT COUNT(id)
FROM api_csvs
WHERE ..." to this table.
Allineer's profile image Allineer posted 12 years ago Permalink
current table structure is:

CREATE TABLE `api_csvs` (
`group_id` INT(3) UNSIGNED NOT NULL DEFAULT '0',
`trigger` VARCHAR(50) NOT NULL DEFAULT '',
`id` INT(6) UNSIGNED NOT NULL DEFAULT '0',
`filename` VARCHAR(255) NOT NULL DEFAULT '',
`sizetag` VARCHAR(50) NULL DEFAULT NULL,
`state` INT(1) NOT NULL DEFAULT '0',
`revision` INT(1) NOT NULL DEFAULT '0',
`DT` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`csv_size` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`crc32` VARCHAR(8) NOT NULL DEFAULT '',
`files_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`files_size` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`pics_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`pics_size` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`author` VARCHAR(50) NOT NULL DEFAULT '',
`comment` BLOB NULL,
`content` MEDIUMBLOB NULL,
`content_crc32` VARCHAR(8) NULL DEFAULT NULL,
`content_size` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`downloaded` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`is_old` INT(1) UNSIGNED NOT NULL DEFAULT '0',
`is_deleted` INT(1) UNSIGNED NOT NULL DEFAULT '0',
`last_check_DT` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`DTLM` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`trigger`, `id`),
UNIQUE INDEX `id` (`id`),
INDEX `crc32` (`crc32`),
INDEX `last_check_DT` (`last_check_DT`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;


ansgar's profile image ansgar posted 12 years ago Permalink
Ok, "very often" also implies that it's not always crashing. Even more mysterious then. However, libmysql.dll error, not HeidiSQL. Could also be your table is corrupted somehow.
Allineer's profile image Allineer posted 12 years ago Permalink
last AV:

http://s1.hostingkartinok.com/uploads/images/2012/03/c8855fa83e4311149426ecef2dfe375e.png
http://s1.hostingkartinok.com/uploads/images/2012/03/f01362028d42b9a32d149ae62e7c4436.png
Allineer's profile image Allineer posted 12 years ago Permalink
anse , I recreate the table several times. Table physically located on the ZFS-pool and it without errors.

"very often" it means 50%/%50 or so.
ansgar's profile image ansgar posted 12 years ago Permalink
Well? I just said the error is in libmysql.dll, not in Heidi.
Allineer's profile image Allineer posted 12 years ago Permalink
Ok. Sorry for bothering.

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