Repairing MyISAM mySQL Tables/Databases: cd /var/lib/mysql/DBNAME #^ Please note that we assume your mySQL data directory is /var/lib/mysql myisamchk *.MYI In /var/lib/mysql/mysqld.log I find sessions.MYI had some problem.... So... 1)OTRS:/var/lib/mysql/otrs # myisamchk sessions.MYI Checking MyISAM file: sessions.MYI Data records: 6 Deleted blocks: 7 myisamchk: warning: Table is marked as crashed myisamchk: warning: 6 clients are using or haven't closed the table properly - check file-size - check record delete-chain myisamchk: error: Record at pos: 3652 is not remove-marked myisamchk: error: record delete-link-chain corrupted - check key delete-chain - check index reference - check data record references index: 1 myisamchk: error: Found 11 keys of 6 - check record links myisamchk: error: Wrong record length 89 of 1067 at 16060 MyISAM-table 'sessions.MYI' is corrupted Fix it using switch "-r" or "-o" REPAIR: 2)OTRS:/var/lib/mysql/otrs # myisamchk -r sessions.MYI - recovering (with sort) MyISAM-table 'sessions.MYI' Data records: 6 - Fixing index 1 Wrong block with wrong total length starting at 16060 Data records: 7 OTRS:/var/lib/mysql/otrs # reboot And everything goes fine. *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Paiusco Alessandro Infonet Srl _ (o)_ //\ V_/_ *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -----Messaggio originale----- Da: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Per conto di Alessandro Paiusco Inviato: mercoledì 10 gennaio 2007 16.01 A: otrs@otrs.org Oggetto: [otrs] Can't insert session id! after pc stops Priorità: Alta Hi, I get Software error: Can't insert session id! at /opt/otrs//Kernel/System/AuthSession/DB.pm line 204. after my otrs box has power done incorrectly after a power failure.... how can I correct this problem otrs version is 2.1.3 on SuSE 10.0 Thanks *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Paiusco Alessandro Infonet Srl _ (o)_ //\ V_/_ *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? =http://www.otrs.com/