distal-attribute
distal-attribute
distal-attribute
distal-attribute

AV

Allineer posted 3 years ago in General

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 posted 3 years ago
query:

SELECT COUNT(id)
FROM api_csvs
WHERE content IS NULL

ansgar posted 3 years ago
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 posted 3 years ago
5.2.10-MariaDB

I do not update libmysql.dll manually - only use updater.
Allineer posted 3 years ago
I can give you RO-access to the table if you need.
ansgar posted 3 years ago
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 posted 3 years ago
Error occurs very often when I run the query with "SELECT COUNT(id)
FROM api_csvs
WHERE ..." to this table.
Allineer posted 3 years ago
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 posted 3 years ago
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 posted 3 years ago
last AV:

http://s1.hostingkartinok.com/uploads/images/2012/03/c8855fa83e4311149426ecef2dfe375e.png
http://s1.hostingkartinok.com/uploads/images/2012/03/f01362028d42b9a32d149ae62e7c4436.png
Allineer posted 3 years ago
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 posted 3 years ago
Well? I just said the error is in libmysql.dll, not in Heidi.
Allineer posted 3 years ago
Ok. Sorry for bothering.

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