View Single Post
Old 31st August 2010, 22:03
scottrill2 scottrill2 is offline
HowtoForge Supporter
Join Date: Dec 2009
Posts: 93
Thanks: 21
Thanked 2 Times in 1 Post
Default A few more questions if I could.

Hello all,

I encountered an error on my slave. A few questions I would ask if possible:

1. Error was this:

Aug 31 12:11:16 server2 mysqld[1933]: 100831 12:11:16 [ERROR] Slave: Error 'Duplicate entry 'random data' for key 1' on query. Default database: 'web4db1'. Query: 'INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`clie nt_id` ) VALUES ( 'random data','random data','','0','1','0' )', Error_code: 1062

Aug 31 12:11:16 server2 mysqld[1933]: 100831 12:11:16 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000001' position 8683

I several sites installed on ISPConfig some playing around with Drupal, some with joomla etc etc. For instance web1db1 and web4db1 both are Joomla so both have a table "jos_session" since they are completely different databases that shouldn't be a problem correct? What usually causes this error and where should I investigate first?

2. While researching this error some sites have said to insert "slave-skip-errors = 1062" into config file for slave. Is this wise or just mearly a bandaid type of thing?

Thanks as always for the help folks,

Reply With Quote