alter table OFFENDING_TABLE engine=InnoDb; alter table OFFENDING_TABLE engine=MyIsam;
I was then able to recreate my indexes w/o a hitch. According to the MySQL web site there was ONE version of the 4.x branch which had this BUG which did this. I think that the bug introduced an error in the table. Converting it from one type to another then back seems to have eliminated my problem.
Unfortunately my Dir is still hanging. :( Please see following from ./btraceback
===============================================================================
Using host libthread_db library "/lib/libthread_db.so.1".
[Thread debugging using libthread_db enabled]
[New Thread 16384 (LWP 28103)]
[New Thread 32769 (LWP 28104)]
[Thread debugging using libthread_db enabled]
[New Thread 16384 (LWP 28103)]
[New Thread 32769 (LWP 28104)]
[Thread debugging using libthread_db enabled]
[New Thread 16384 (LWP 28103)]
[New Thread 32769 (LWP 28104)]
Error while reading shared library symbols:
Cannot find new threads: generic error
0x40078f74 in __pthread_sigsuspend () from /lib/i686/libpthread.so.0
$1 = "ewc01-dir", '\0' <repeats 20 times>
$2 = 0x80c3230 "bacula-dir"
$3 = 0x80c3790 "/usr/sbin/"
$4 = "MySQL"
$5 = 0x80b3980 "1.36.2 (28 February 2005)"
$6 = 0x80ac716 "i686-suse-linux-gnu"
$7 = 0x80ac711 "suse"
$8 = 0x80ac70d "9.2"
#0 0x40078f74 in __pthread_sigsuspend () from /lib/i686/libpthread.so.0
#1 0x40077bf8 in __pthread_wait_for_restart_signal () from /lib/i686/libpthread.so.0
#2 0x4007a5cd in __pthread_alt_lock () from /lib/i686/libpthread.so.0
#3 0x400777a5 in pthread_mutex_lock () from /lib/i686/libpthread.so.0
#4 0x0805addb in jobq_add (jq=0x80c1ba0, jcr=0x84f6568) at jobq.c:240
#5 0x0805991a in run_job (jcr=0x84f6568) at job.c:140
#6 0x0804c386 in main (argc=3, argv=0xbffff504) at dird.c:241
/etc/bacula/btraceback.gdb:10: Error in sourced command file:
Cannot find new threads: generic error
Kern Sibbald wrote:
On Friday 01 April 2005 00:41, Michael Joyner wrote:Kern Sibbald wrote:Hello,
I've noticed a number of people reporting that the Director hangs, though I haven't followed this thread in detail. I've never seen this except if you are running /lib/tls, so you might:
1. Remove or rename /lib/tls if it exists on your system. 2. Restart all the bacula daemons.Doing:
cd /lib tar cvfz tls.tgz tls mv tls tls.CAUSES.BACULA-DIR.HANG /etc/init.d/bacula-dir restart /etc/init.d/bacula-fd restart /etc/init.d/bacula-sd restart /etc/init.d/mysql restart # "just in case"
changed max storage jobs to 10 running about 100+ jobs tonight, we'll see in the morning. :)
(System: SuSE 9.1, bacula & mysql from apt-get pre-built binaries)
Yes, this will be interesting.
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users