when Database tries to create tables, getting the below error: "table insert failed for eventLog" any idea what is the reason, also I have these errors when I run manually, I gets these:
SQL error near line 2: table dbUpdateRegisterTbl already exists SQL error near line 17: table sqliteLock already exists SQL error near line 22: table ifDevEventTbl already exists SQL error near line 33: table tableValidation already exists SQL error near line 43: table tableDefaults already exists SQL error near line 54: table system already exists SQL error near line 65: table systemConfig already exists SQL error near line 72: table dbUpdateRegisterProgram already exists SQL error near line 84: table saveTables already exists SQL error near line 91: table environment already exists SQL error near line 99: table tableMaxRecords already exists SQL error near line 105: table stringsMap already exists SQL error near line 118: column stringId is not unique SQL error near line 119: column stringId is not unique SQL error near line 120: column stringId is not unique SQL error near line 121: table httpsMgmt already exists SQL error near line 131: columns tableName, columnName are not unique SQL error near line 132: table ethernet already exists SQL error near line 147: columns tableName, columnName are not unique SQL error near line 148: columns tableName, columnName are not unique SQL error near line 150: column stringId is not unique SQL error near line 151: column stringId is not unique SQL error near line 152: table vlan already exists SQL error near line 160: columns tableName, columnName are not unique SQL error near line 162: table networkInterface already exists SQL error near line 182: table networkInfo already exists SQL error near line 192: table logging already exists SQL error near line 200: table logConfig already exists SQL error near line 216: table compFacilityMap already exists SQL error near line 225: table sysLogInfo already exists SQL error near line 232: columns tableName, columnName are not unique SQL error near line 235: columns component, facilityId are not unique SQL error near line 236: columns component, facilityId are not unique SQL error near line 237: columns component, facilityId are not unique SQL error near line 238: columns component, facilityId are not unique SQL error near line 239: columns component, facilityId are not unique SQL error near line 240: columns component, facilityId are not unique SQL error near line 242: columns component, facilityId are not unique SQL error near line 243: columns component, facilityId are not unique SQL error near line 244: columns component, facilityId are not unique SQL error near line 245: columns component, facilityId are not unique SQL error near line 247: columns component, facilityId are not unique SQL error near line 250: table eventLog already exists SQL error near line 262: table emailLogs already exists SQL error near line 270: columns tableName, columnName are not unique SQL error near line 272: column stringId is not unique SQL error near line 273: column stringId is not unique SQL error near line 274: column stringId is not unique SQL error near line 275: column stringId is not unique SQL error near line 276: column stringId is not unique SQL error near line 277: column stringId is not unique SQL error near line 278: column stringId is not unique SQL error near line 279: column stringId is not unique SQL error near line 280: table loginSession already exists SQL error near line 294: column stringId is not unique SQL error near line 295: column stringId is not unique SQL error near line 296: column stringId is not unique SQL error near line 297: column stringId is not unique SQL error near line 298: table ntp already exists SQL error near line 311: table ntpDefServers already exists SQL error near line 321: column stringId is not unique SQL error near line 322: column stringId is not unique SQL error near line 324: table users already exists SQL error near line 338: columns tableName, columnName are not unique SQL error near line 339: table reboot already exists SQL error near line 348: table bootpc already exists SQL error near line 357: columns tableName, columnName are not unique SQL error near line 358: columns tableName, columnName are not unique SQL error near line 359: columns tableName, columnName are not unique SQL error near line 361: column stringId is not unique SQL error near line 362: column stringId is not unique SQL error near line 363: column stringId is not unique SQL error near line 364: column stringId is not unique SQL error near line 365: column stringId is not unique SQL error near line 366: column stringId is not unique SQL error near line 367: column stringId is not unique SQL error near line 368: table kdcConfig already exists SQL error near line 379: table cert already exists SQL error near line 397: table x509SelfCertReq already exists SQL error near line 414: table x509DbUpdateFlag already exists SQL error near line 422: column stringId is not unique SQL error near line 423: column stringId is not unique SQL error near line 424: column stringId is not unique SQL error near line 425: column stringId is not unique SQL error near line 426: column stringId is not unique SQL error near line 427: column stringId is not unique SQL error near line 428: column stringId is not unique SQL error near line 429: column stringId is not unique SQL error near line 430: column stringId is not unique SQL error near line 431: column stringId is not unique SQL error near line 432: column stringId is not unique SQL error near line 434: table x509Config already exists SQL error near line 441: table ldapConfig already exists SQL error near line 455: table networkScan already exists SQL error near line 484: table scanStatistics already exists SQL error near line 497: table cacReaderStatus already exists SQL error near line 507: columns tableName, columnName are not unique SQL error near line 508: columns tableName, columnName are not unique SQL error near line 510: table debug already exists SQL error near line 516: table dhcp already exists SQL error near line 531: column stringId is not unique SQL error near line 532: column stringId is not unique SQL error near line 533: table crontab already exists SQL error near line 543: columns tableName, columnName are not unique SQL error near line 544: columns tableName, columnName are not unique SQL error near line 545: columns tableName, columnName are not unique SQL error near line 546: columns tableName, columnName are not unique SQL error near line 547: columns tableName, columnName are not unique SQL error near line 548: columns tableName, columnName are not unique SQL error near line 551: column stringId is not unique SQL error near line 553: table smtpServer already exists SQL error near line 566: table route already exists SQL error near line 579: table natptTranslationTbl already exists SQL error near line 586: table tcpdump already exists SQL error near line 594: columns tableName, columnName are not unique SQL error near line 596: column stringId is not unique SQL error near line 598: table fearSecurityMethod already exists SQL error near line 604: table fearIntegrityMethod already exists SQL error near line 610: table fearSerialExtMethod already exists SQL error near line 616: table fearConfig already exists SQL error near line 636: table fearFeatureKeyed already exists SQL error near line 648: table fearFeatureKeyable already exists SQL error near line 656: columns tableName, columnName are not unique SQL error near line 657: columns tableName, columnName are not unique SQL error near line 658: columns tableName, columnName are not unique SQL error near line 659: columns tableName, columnName are not unique SQL error near line 660: columns tableName, columnName are not unique SQL error near line 661: columns tableName, columnName are not unique SQL error near line 662: columns tableName, columnName are not unique SQL error near line 663: columns tableName, columnName are not unique SQL error near line 664: columns tableName, columnName are not unique SQL error near line 665: columns tableName, columnName are not unique SQL error near line 666: columns tableName, columnName are not unique SQL error near line 667: columns tableName, columnName are not unique SQL error near line 689: column stringId is not unique SQL error near line 691: column tableName is not unique SQL error near line 692: column tableName is not unique SQL error near line 693: column tableName is not unique SQL error near line 694: column tableName is not unique SQL error near line 695: column tableName is not unique SQL error near line 696: column tableName is not unique SQL error near line 697: column tableName is not unique SQL error near line 698: column tableName is not unique SQL error near line 699: column tableName is not unique SQL error near line 700: column tableName is not unique SQL error near line 701: column tableName is not unique SQL error near line 702: column tableName is not unique SQL error near line 703: column tableName is not unique SQL error near line 704: column tableName is not unique sh: 1: unknown operand SQL error near line 705: column tableName is not unique SQL error near line 706: column tableName is not unique SQL error near line 707: column tableName is not unique SQL error near line 708: column tableName is not unique SQL error near line 709: column tableName is not unique SQL error near line 710: column tableName is not unique SQL error near line 711: column tableName is not unique SQL error near line 712: column tableName is not unique SQL error near line 713: column tableName is not unique SQL error near line 714: column tableName is not unique SQL error near line 715: column tableName is not unique SQL error near line 716: column tableName is not unique SQL error near line 718: column name is not unique SQL error near line 719: column name is not unique SQL error near line 720: column name is not unique SQL error near line 722: column name is not unique SQL error near line 724: column name is not unique SQL error near line 725: column name is not unique SQL error near line 726: column name is not unique SQL error near line 727: column name is not unique SQL error near line 728: column name is not unique SQL error near line 729: column name is not unique SQL error near line 730: column name is not unique SQL error near line 731: column name is not unique SQL error near line 732: column name is not unique SQL error near line 733: column name is not unique SQL error near line 734: column name is not unique SQL error near line 735: column name is not unique SQL error near line 736: column name is not unique SQL error near line 738: column name is not unique SQL error near line 739: column name is not unique SQL error near line 741: column name is not unique SQL error near line 742: column name is not unique SQL error near line 744: column name is not unique SQL error near line 745: column name is not unique SQL error near line 747: column name is not unique SQL error near line 748: column name is not unique SQL error near line 749: column name is not unique SQL error near line 750: column name is not unique SQL error near line 751: column name is not unique SQL error near line 752: column name is not unique SQL error near line 753: column name is not unique SQL error near line 754: column name is not unique SQL error near line 755: column name is not unique SQL error near line 756: column name is not unique SQL error near line 757: column name is not unique SQL error near line 758: column name is not unique SQL error near line 759: column name is not unique SQL error near line 800: column fiId is not unique conntrack v0.9.13 (conntrack-tools): connection tracking table has been emptied. SQL error near line 802: columns component, facilityId are not unique SQL error near line 812: database is locked SQL error near line 813: cannot start a transaction within a transaction SQL error near line 815: trigger "fk_ethernet_vlanId_ins_on_ethernet" already exists SQL error near line 821: trigger "fk_ethernet_vlanId_upd_on_ethernet" already exists SQL error near line 827: trigger "fk_ethernet_vlanId_del_on_vlan" already exists SQL error near line 833: trigger "fk_ethernet_vlanId_upd_on_vlan" already exists SQL error near line 840: trigger "fk_ethernet_interfaceName_ins_on_ethernet" already exists SQL error near line 846: trigger "fk_ethernet_interfaceName_upd_on_ethernet" already exists SQL error near line 852: trigger "fk_ethernet_interfaceName_del_on_networkInterface" already exists SQL error near line 858: trigger "fk_ethernet_interfaceName_upd_on_networkInterface" already exists SQL error near line 865: database is locked SQL error near line 866: cannot start a transaction within a transaction SQL error near line 868: trigger "fk_eventLog_component_ins_on_eventLog" already exists SQL error near line 874: trigger "fk_eventLog_component_upd_on_eventLog" already exists SQL error near line 880: trigger "fk_eventLog_component_del_on_compFacilityMap" already exists SQL error near line 886: trigger "fk_eventLog_component_upd_on_compFacilityMap" already exists SQL error near line 893: trigger "fk_eventLog_facilityId_ins_on_eventLog" already exists SQL error near line 899: trigger "fk_eventLog_facilityId_upd_on_eventLog" already exists SQL error near line 905: trigger "fk_eventLog_facilityId_del_on_compFacilityMap" already exists SQL error near line 911: trigger "fk_eventLog_facilityId_upd_on_compFacilityMap" already exists SQL error near line 921: trigger "fk_loginSession_username_ins_on_loginSession" already exists SQL error near line 927: trigger "fk_loginSession_username_upd_on_loginSession" already exists SQL error near line 933: trigger "fk_loginSession_username_del_on_users" already exists SQL error near line 939: trigger "fk_loginSession_username_upd_on_users" already exists table insert failed for eventLog _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
