Re: MySQL Innodb Crash on 2 concurrent select

2005-11-17 Thread Greg 'groggy' Lehey
On Wednesday, 16 November 2005 at 20:40:35 +0700, Ady Wicaksono wrote: I have MySQL with about 12 billion rows when i try to create 2 process, each select count(*) on the same table after a long time about 30 minutes it crashed :( ANy information? ... InnoDB: We intentionally generate

Re: MySQL Innodb Crash on 2 concurrent select

2005-11-17 Thread Ady Wicaksono
Ok greg, I'll report this bug Thx Greg 'groggy' Lehey wrote: On Wednesday, 16 November 2005 at 20:40:35 +0700, Ady Wicaksono wrote: I have MySQL with about 12 billion rows when i try to create 2 process, each select count(*) on the same table after a long time about 30 minutes it

MySQL Innodb Crash on 2 concurrent select

2005-11-16 Thread Ady Wicaksono
I have MySQL with about 12 billion rows when i try to create 2 process, each select count(*) on the same table after a long time about 30 minutes it crashed :( ANy information? Log file : 051116 20:27:22InnoDB: Assertion failure in thread 2366216768 in file srv0srv.c line 1873 InnoDB:

Re: MySQL Innodb Crash on 2 concurrent select

2005-11-16 Thread Ady Wicaksono
Dear All It happens after these condition InnoDB: ## Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 1103972416 has waited at ../include/btr0btr.ic line 28 for 369.00 seconds the semaphore: S-lock on RW-latch at 0x88cdd6b8 created in