Bogdan-Andrei Iancu writes: > This does mean you encountered a deadlock. By the sounds of it, you're > likely to be using InnoDB.
bogdan, yes, because myisam is not good for drbd. that reminds me, why were all vachars changed to chars? > So, you should issue "SHOW INNODB STATUS" from the mysql command line. > > In that output, look for the "LATEST DETECTED DEADLOCK". There you will > see 2 transactions, (1) and (2). You can see the exact queries that > caused it and the table locks that each hold/trying to acquire. > > Just post it here to see what are the queries blocking one each > other. i'll post that privately, because there are real uris in the data. -- juha _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
