Author:
jarendt
Subject: DB connect error
Posted: Wed Oct 15, 2008 4:10 pm (GMT 0)
I think this is the problem that is causing the scheduler to stop working:
2008-10-15 | 10:12:22 | INFO | 12716 | 714344 | n/a | knowledgetree | default | main | Scheduler - Task: Cleanup Temporary Directory
2008-10-15 | 10:12:22 | INFO | 12716 | 714346 | n/a | knowledgetree | default | main | Scheduler - Command: "/opt/ktdms/php/bin/php" "/opt/ktdms/knowledgeTree/search2/bin/cronCleanup.php"
2008-10-15 | 10:12:22 | INFO | 12716 | 714346 | n/a | knowledgetree | default | main | Scheduler - Output: [db_error: message="DB Error: connect failed" code=-24 mode=return level=notice prefix="" info=" [nativecode=Can't connect to local MySQL server through socket '/opt/ktdms/mysql/tmp/mysql.sock' (2)] ** Array"]
2008-10-15 | 10:12:22 | INFO | 12716 | 714347 | n/a | knowledgetree | default | main | Scheduler - Background tasks should not produce output. Please review why this is producing output.
2008-10-15 | 10:12:22 | ERROR | 12716 | 714349 | n/a | knowledgetree | sql | logQueryError | UPDATE scheduler_tasks SET run_time = '2008-10-15 10:13:22',previous_run_time = '2008-10-15 10:12:22',run_duration = '0.42' WHERE id = 7
2008-10-15 | 10:12:22 | ERROR | 12716 | 714349 | n/a | knowledgetree | default | logQueryError | Query error: DB Error: no database selected
2008-10-15 | 10:12:22 | ERROR | 13078 | 317 | n/a | knowledgetree | sql | logQueryError | SELECT h.classname, h.pathname, h.plugin FROM plugin_helper h
INNER JOIN plugins p ON (p.namespace = h.plugin)
WHERE p.disabled = 0 AND h.classtype='plugin' ORDER BY p.orderby
2008-10-15 | 10:12:22 | ERROR | 13078 | 329 | n/a | knowledgetree | default | logQueryError | Query error: DB Error: no database selected
2008-10-15 | 10:12:22 | INFO | 12716 | 714588 | n/a | knowledgetree | default | main | Scheduler - Task: Refresh Index Statistics
2008-10-15 | 10:12:22 | INFO | 12716 | 714589 | n/a | knowledgetree | default | main | Scheduler - Command: "/opt/ktdms/php/bin/php" "/opt/ktdms/knowledgeTree/search2/bin/cronIndexStats.php"
2008-10-15 | 10:12:22 | INFO | 12716 | 714589 | n/a | knowledgetree | default | main | Scheduler - Output: [db_error: message="DB Error: connect failed" code=-24 mode=return level=notice prefix="" info=" [nativecode=Can't connect to local MySQL server through socket '/opt/ktdms/mysql/tmp/mysql.sock' (2)] ** Array"]
2008-10-15 | 10:12:22 | INFO | 12716 | 714589 | n/a | knowledgetree | default | main | Scheduler - Background tasks should not produce output. Please review why this is producing output.
2008-10-15 | 10:12:22 | ERROR | 12716 | 714590 | n/a | knowledgetree | sql | logQueryError | UPDATE scheduler_tasks SET run_time = '2008-10-15 10:13:22',previous_run_time = '2008-10-15 10:12:22',run_duration = '0.24' WHERE id = 10
2008-10-15 | 10:12:22 | ERROR | 12716 | 714591 | n/a | knowledgetree | default | logQueryError | Query error: DB Error: no database selected
2008-10-15 | 10:12:22 | ERROR | 13078 | 394 | n/a | knowledgetree | sql | logQueryError | SELECT id, name FROM mime_extractors WHERE active=1
2008-10-15 | 10:12:22 | ERROR | 13078 | 394 | n/a | knowledgetree | default | logQueryError | Query error: DB Error: no database selected
2008-10-15 | 10:12:23 | INFO | 12716 | 714780 | n/a | knowledgetree | default | main | Scheduler - Task: Refresh Resource Dependancies
2008-10-15 | 10:12:23 | INFO | 12716 | 714781 | n/a | knowledgetree | default | main | Scheduler - Command: "/opt/ktdms/php/bin/php" "/opt/ktdms/knowledgeTree/search2/bin/cronResources.php"
2008-10-15 | 10:12:23 | INFO | 12716 | 714782 | n/a | knowledgetree | default | main | Scheduler - Output: [db_error: message="DB Error: connect failed" code=-24 mode=return level=notice prefix="" info=" [nativecode=Can't connect to local MySQL server through socket '/opt/ktdms/mysql/tmp/mysql.sock' (2)] ** Array"]
2008-10-15 | 10:12:23 | INFO | 12716 | 714782 | n/a | knowledgetree | default | main | Scheduler - Background tasks should not produce output. Please review why this is producing output.
2008-10-15 | 10:12:23 | ERROR | 12716 | 714783 | n/a | knowledgetree | sql | logQueryError | UPDATE scheduler_tasks SET run_time = '2008-10-15 10:13:22',previous_run_time = '2008-10-15 10:12:22',run_duration = '0.19' WHERE id = 11
2008-10-15 | 10:12:23 | ERROR | 12716 | 714784 | n/a | knowledgetree | default | logQueryError | Query error: DB Error: no database selected
If anyone can help would greatly appreciate it.
The install is a v3.5.3 stack install that was upgraded from v3.3.3 source.
If I restart using the command /opt/ktdms/dmsctl.sh restart, the indexer indexes for a while and then stops.