MySql issues?

[Ajeh]

Sounds like a lack of memory for your server ... but I am not a hosting guru ...

I have on my server:
PHP Version: 5.2.4 (Zend: 2.2.0) PHP Memory Limit: 64M

[yellow1912]

I believe the new version has some bugs related to GC, check it here:
http://www.zen-cart.com/forum/showthread.php?t=82619

[disciple]

Sounds like a lack of memory for your server ... but I am not a hosting guru ...

I have on my server:
PHP Version: 5.2.4 (Zend: 2.2.0) PHP Memory Limit: 64M

It would appear I allot more memory to php and I did not have this issue before the upgrade to 1.3.8

I have on my server:
PHP Version: 5.2.5 (Zend: 2.2.0) PHP Memory Limit: 256M

I believe the new version has some bugs related to GC, check it here:

The portion that speaks to gift voucher is concerned with tax calculation and I had already made that fix.

Any other ideas? It does not make sense to me that I can do ANY other function with the customer database except mail a gift certificate.

Thanks

Rick

[Ajeh]

Gads I am getting old ... or I just need new glasses again ...

[disciple]

I just had my tables lock up again but this time I used the developer tool kit to find something.

There has to be a reason that this is happening. Is there anyone who is knowledgeable with zen cart and mysql that can try and nail this down for me.

Thanks

Rick

[DrByte]

According to your posted logfile, it seems to be getting stuck when creating a temporary table (usually done for sorting results from a query) ... and then all the pending queries were getting held up waiting for that process to complete.
But, locks like that usually only happen when a table is opened for writing (ie: an "update" or "insert" statement).

I'd be interested in knowing whether the same database has the same problems if run from a different db server.

I'm sure you've already tried it, but one thing I'd be doing in such a case is a full database repair (ie: on all tables).

[disciple]

I'd be interested in knowing whether the same database has the same problems if run from a different db server.

I do not have another server in which to test that theory so I don't know. However, I have not had any problem before the upgrade.

I'm sure you've already tried it, but one thing I'd be doing in such a case is a full database repair (ie: on all tables).

Yes, I have repaired all tables.

[DrByte]

Does this sound similar enough to your symptoms? http://bugs.mysql.com/bug.php?id=7166