FYI, I use Pressflow and Innodb tables. Any thoughts on the following warnings? The 192.168.185.10 address is me.

CentOS54[root@http ~]# grep httpbl /var/log/httpd/error_log
[Thu Feb 18 13:56:19 2010] [error] [client 66.240.231.154] PHP Warning: Duplicate entry '66.240.231.154' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('66.240.231.154', 0, 1266540979) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Thu Feb 18 13:56:19 2010] [error] [client 66.240.231.154] PHP Warning: Duplicate entry '66.240.231.154' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('66.240.231.154', 0, 1266540979) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Thu Feb 18 16:12:59 2010] [error] [client 192.168.185.10] PHP Warning: Duplicate entry '192.168.185.10' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('192.168.185.10', 0, 1266549179) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Thu Feb 18 16:12:59 2010] [error] [client 192.168.185.10] PHP Warning: Duplicate entry '192.168.185.10' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('192.168.185.10', 0, 1266549179) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Thu Feb 18 16:12:59 2010] [error] [client 192.168.185.10] PHP Warning: Duplicate entry '192.168.185.10' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('192.168.185.10', 0, 1266549179) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Thu Feb 18 16:12:59 2010] [error] [client 192.168.185.10] PHP Warning: Duplicate entry '192.168.185.10' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('192.168.185.10', 0, 1266549179) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Thu Feb 18 16:12:59 2010] [error] [client 192.168.185.10] PHP Warning: Duplicate entry '192.168.185.10' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('192.168.185.10', 0, 1266549179) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Sun Feb 21 17:05:17 2010] [error] [client 58.49.58.20] PHP Warning: Duplicate entry '58.49.58.20' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('58.49.58.20', 0, 1266811517) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Mon Feb 22 07:37:24 2010] [error] [client 61.183.15.9] PHP Warning: Duplicate entry '61.183.15.9' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('61.183.15.9', 0, 1266863844) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Mon Feb 22 07:37:24 2010] [error] [client 61.183.15.9] PHP Warning: Duplicate entry '61.183.15.9' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('61.183.15.9', 0, 1266863844) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Mon Feb 22 11:03:35 2010] [error] [client 221.192.199.35] PHP Warning: Duplicate entry '221.192.199.35' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('221.192.199.35', 0, 1266876215) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Mon Feb 22 11:03:35 2010] [error] [client 221.192.199.35] PHP Warning: Duplicate entry '221.192.199.35' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('221.192.199.35', 0, 1266876215) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Mon Feb 22 17:10:58 2010] [error] [client 190.144.99.11] PHP Warning: Duplicate entry '190.144.99.11' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('190.144.99.11', 0, 1266898258) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141
[Mon Feb 22 17:10:58 2010] [error] [client 190.144.99.11] PHP Warning: Duplicate entry '190.144.99.11' for key 1\nquery: INSERT INTO httpbl (hostname, status, expire) VALUES ('190.144.99.11', 0, 1266898258) in /var/www/pressflow-6.15.65/includes/database.mysqli.inc on line 141

Comments

David Strauss’s picture

David Strauss
he/him
CreditAttribution: David Strauss commented

I can say with good confidence that this has nothing to do with Pressflow or InnoDB and everything to do with http:BL violating constraints on its own tables. Switching to standard Drupal and MyISAM would not fix this.

praseodym’s picture

praseodym CreditAttribution: praseodym commented
Assigned: Unassigned » praseodym
praseodym’s picture

praseodym CreditAttribution: praseodym commented
Assigned: praseodym » Unassigned

Looks like this is a race condition, since the module does a DELETE first. Using INSERT … ON DUPLICATE KEY UPDATE should fix this, but only works for MySQL. If I break PostgreSQL compatibility, #424466: query does not work in PostgreSQL will have to be opened again…

johnthomas00’s picture

johnthomas00 CreditAttribution: johnthomas00 commented

Could I trouble you for a patch to make MySql work?

Also and at the risk of sounding presumptuous, I would suggest that:
1) the broken installations would be fewer and
2) a mutual solution more likely to come from anonymous helpers
IF the PostgreSQL were broken and MySql were working in the released or dev versions.

praseodym’s picture

praseodym CreditAttribution: praseodym commented
Assigned: Unassigned » praseodym
Status: Active » Fixed

Fix is committed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.