I have emailed my host because they suspended one of my site running drupal. I am in a dedicated server so switching this to become live again is not a problem. But for now my host told me to fix the error first to avoid problem in the future.
Here's the trace of the problem as what my host says:
Here is a trace of the section that repeats..
ead(5, "\n /**\n * Sets the fromQuery o"..., 8192) = 8192
read(5, "* The prepared statement.\n *"..., 8192) = 8192
read(5, ", so we process those first\n "..., 8192) = 8192
read(5, " method should only be called on"..., 8192) = 8192
read(5, "\n\n return $this;\n }\n\n /**\n "..., 8192) = 8051
read(5, "", 8192) = 0
brk(0x9d21000) = 0x9d21000
read(5, "", 8192) = 0
close(5) = 0
access("/home/scode/public_html/includes/database/mysql/query.inc", F_OK) = 0
time(NULL) = 1332224046
lstat64("/home", {st_mode=S_IFDIR|0711, st_size=4096, ...}) = 0
lstat64("/home/scode", {st_mode=S_IFDIR|0711, st_size=69632, ...}) = 0
lstat64("/home/scode/public_html", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
lstat64("/home/scode/public_html/includes", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat64("/home/scode/public_html/includes/database", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat64("/home/scode/public_html/includes/database/mysql", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat64("/home/scode/public_html/includes/database/mysql/query.inc", {st_mode=S_IFREG|0644, st_size=3410, ...}) = 0
time(NULL) = 1332224046
open("/home/scode/public_html/includes/database/mysql/query.inc", O_RDONLY) = 5
fstat64(5, {st_mode=S_IFREG|0644, st_size=3410, ...}) = 0
read(5, "<?php\n\n/**\n * @ingroup database\n"..., 8192) = 3410
read(5, "", 8192) = 0
read(5, "", 8192) = 0
close(5) = 0
gettimeofday({1332224046, 282375}, NULL) = 0
gettimeofday({1332224046, 282399}, NULL) = 0
gettimeofday({1332224046, 282428}, NULL) = 0
time(NULL) = 1332224046
gettimeofday({1332224046, 282510}, NULL) = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "z\0\0\0\3INSERT INTO semaphore (name"..., 126) = 126
read(4, "2\0\0\1\377&\4#23000Duplicate entry 'va"..., 16384) = 54
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "A\0\0\0\3SELECT expire, value FROM s"..., 69) = 69
read(4, "\1\0\0\1\2>\0\0\2\3def\nscode_scdb\tsemapho"..., 16384) = 153
gettimeofday({1332224046, 283065}, NULL) = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "z\0\0\0\3INSERT INTO semaphore (name"..., 126) = 126
read(4, "2\0\0\1\377&\4#23000Duplicate entry 'va"..., 16384) = 54
nanosleep({0, 25000000}, NULL) = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "A\0\0\0\3SELECT expire, value FROM s"..., 69) = 69
read(4, "\1\0\0\1\2>\0\0\2\3def\nscode_scdb\tsemapho"..., 16384) = 153
send(3, "get cache_bootstrap-variables\r\n", 31, MSG_DONTWAIT) = 31
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1000) = 1 ([{fd=3, revents=POLLIN}])
recv(3, "END\r\n", 32768, MSG_DONTWAIT) = 5
gettimeofday({1332224046, 309687}, NULL) = 0
gettimeofday({1332224046, 309730}, NULL) = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "z\0\0\0\3INSERT INTO semaphore (name"..., 126) = 126
read(4, "2\0\0\1\377&\4#23000Duplicate entry 'va"..., 16384) = 54
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "A\0\0\0\3SELECT expire, value FROM s"..., 69) = 69
read(4, "\1\0\0\1\2>\0\0\2\3def\nscode_scdb\tsemapho"..., 16384) = 153
gettimeofday({1332224046, 310220}, NULL) = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "z\0\0\0\3INSERT INTO semaphore (name"..., 126) = 126
read(4, "2\0\0\1\377&\4#23000Duplicate entry 'va"..., 16384) = 54
nanosleep({0, 25000000}, NULL) = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "A\0\0\0\3SELECT expire, value FROM s"..., 69) = 69
read(4, "\1\0\0\1\2>\0\0\2\3def\nscode_scdb\tsemapho"..., 16384) = 153
send(3, "get cache_bootstrap-variables\r\n", 31, MSG_DONTWAIT) = 31
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1000) = 1 ([{fd=3, revents=POLLIN}])
recv(3, "END\r\n", 32768, MSG_DONTWAIT) = 5
gettimeofday({1332224046, 336753}, NULL) = 0
gettimeofday({1332224046, 336804}, NULL) = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "z\0\0\0\3INSERT INTO semaphore (name"..., 126) = 126
read(4, "2\0\0\1\377&\4#23000Duplicate entry 'va"..., 16384) = 54
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "A\0\0\0\3SELECT expire, value FROM s"..., 69) = 69
read(4, "\1\0\0\1\2>\0\0\2\3def\nscode_scdb\tsemapho"..., 16384) = 153
gettimeofday({1332224046, 337293}, NULL) = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "z\0\0\0\3INSERT INTO semaphore (name"..., 126) = 126
read(4, "2\0\0\1\377&\4#23000Duplicate entry 'va"..., 16384) = 54
nanosleep({0, 25000000}, NULL) = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "A\0\0\0\3SELECT expire, value FROM s"..., 69) = 69
read(4, "\1\0\0\1\2>\0\0\2\3def\nscode_scdb\tsemapho"..., 16384) = 153
Sorry for the long post but I want you to read as much information that I have to fix this problem.
It seems the error is a duplicate entry. I don't know what table is it (may be "semaphore").
Please help.
Thank you