Bablosoft

Database

Support

  • R

    Can't select load from file, user input, database (F7)

    Moved Support
    0 Votes
    9 Posts
    1411 Views
    m4zuperM

    @romit
    I can't repeat it either. Maybe you could attach a project with such a problem?

  • E

    how to fix failed to run database

    Support
    0 Votes
    5 Posts
    1325 Views
    I

    Спасибо за ссылки на похожую тему, но к сожалению мне не помогло, возможно я, что то делаю не так. Удаление mongod.lock действительно убрало надпись вначале об ошибке, но базы не работают. Переустановка BAS тоже не решила проблему.

    @Fox said in Глюкнула БД прошу подсказать:

    @dobrok said in Глюкнула БД прошу подсказать:

    @UserTrue said in Глюкнула БД прошу подсказать:

    @dobrok я с таким не сталкивался

    Ни одна из БД не работает, даже новую создаю, после перезагрузки не коннект.

    Удалите файл C:\Users%USERNAME%\AppData\Local\BasDatabases\НАЗВАНИЕ БАЗЫ\current\mongod.lock Запустите mongod --dbpath C:/Users/%USERNAME%/AppData/Local/BasDatabases/НАЗВАНИЕ БАЗЫ/ --repair. mongod есть в папке с BAS.

    Данный метод сделал с помощью командной строки, получив вот это:

    PS C:\Users\ilyaa> C:\Users\ilyaa\AppData\Roaming\BrowserAutomationStudio\apps\24.7.1\mongod.exe --dbpath C:/Users/ilyaa/AppData/Local/BasDatabases/Database.nmarket/ --repair
    2022-03-14T17:45:25.775+0300 [initandlisten] MongoDB starting : pid=34756 port=27017 dbpath=C:/Users/ilyaa/AppData/Local/BasDatabases/Database.nmarket 64-bit host=DESKTOP-A70S6NA
    2022-03-14T17:45:25.775+0300 [initandlisten] targetMinOS: Windows 7/Windows Server 2008 R2
    2022-03-14T17:45:25.775+0300 [initandlisten] db version v2.6.6
    2022-03-14T17:45:25.775+0300 [initandlisten] git version: 608e8bc319627693b04cc7da29ecc300a5f45a1f
    2022-03-14T17:45:25.775+0300 [initandlisten] build info: windows sys.getwindowsversion(major=6, minor=1, build=7601, platform=2, service_pack='Service Pack 1') BOOST_LIB_VERSION=1_49
    2022-03-14T17:45:25.775+0300 [initandlisten] allocator: system
    2022-03-14T17:45:25.775+0300 [initandlisten] options: { repair: true, storage: { dbPath: "C:/Users/ilyaa/AppData/Local/BasDatabases/Database.nmarket/" } }
    2022-03-14T17:45:25.838+0300 [initandlisten] finished checking dbs
    2022-03-14T17:45:25.838+0300 [initandlisten] dbexit:
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: going to close listening sockets...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: going to flush diaglog...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: going to close sockets...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: waiting for fs preallocator...
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: closing all files...
    2022-03-14T17:45:25.838+0300 [initandlisten] closeAllFiles() finished
    2022-03-14T17:45:25.838+0300 [initandlisten] shutdown: removing fs lock...
    2022-03-14T17:45:25.838+0300 [initandlisten] dbexit: really exiting now
    PS C:\Users\ilyaa>

    Но базы не заработали. Если же просто запустить отдельно файл mongod.exe, то увидим:

    C:\Users\ilyaa\AppData\Roaming\BrowserAutomationStudio\apps\24.7.1\mongod.exe --help for help and startup options
    2022-03-14T18:02:16.828+0300 [initandlisten] MongoDB starting : pid=39768 port=27017 dbpath=\data\db\ 64-bit host=DESKTOP-A70S6NA
    2022-03-14T18:02:16.843+0300 [initandlisten] targetMinOS: Windows 7/Windows Server 2008 R2
    2022-03-14T18:02:16.843+0300 [initandlisten] db version v2.6.6
    2022-03-14T18:02:16.843+0300 [initandlisten] git version: 608e8bc319627693b04cc7da29ecc300a5f45a1f
    2022-03-14T18:02:16.843+0300 [initandlisten] build info: windows sys.getwindowsversion(major=6, minor=1, build=7601, platform=2, service_pack='Service Pack 1') BOOST_LIB_VERSION=1_49
    2022-03-14T18:02:16.854+0300 [initandlisten] allocator: system
    2022-03-14T18:02:16.863+0300 [initandlisten] options: {}
    2022-03-14T18:02:16.863+0300 [initandlisten] exception in initAndListen: 10296

    ERROR: dbpath (\data\db) does not exist.
    Create this directory or give existing directory in --dbpath.
    See http://dochub.mongodb.org/core/startingandstoppingmongo

    , terminating
    2022-03-14T18:02:16.863+0300 [initandlisten] dbexit:
    2022-03-14T18:02:16.863+0300 [initandlisten] shutdown: going to close listening sockets...
    2022-03-14T18:02:16.868+0300 [initandlisten] shutdown: going to flush diaglog...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: going to close sockets...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: waiting for fs preallocator...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: lock for final commit...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: final commit...
    2022-03-14T18:02:16.870+0300 [initandlisten] shutdown: closing all files...
    2022-03-14T18:02:16.870+0300 [initandlisten] closeAllFiles() finished
    2022-03-14T18:02:16.870+0300 [initandlisten] dbexit: really exiting now

    [процесс завершил работу с кодом 100 (0x00000064)]

  • Y

    solution for massive database data check other than select db by criteria (high I/O)?

    Support
    0 Votes
    2 Posts
    1177 Views
    AllisterA

    @yourfriendkarol said in solution for massive database data check other than select db by criteria (high I/O)?:

    What I do is:

    get some data select by criteria db action, it gives u list if length of that list > 0 it means record is in db already - continue. If its not there, then it adds.

    its good way to do it but i think with many threads my I/O is on max and it gets kinda slow, but maybe im wrong and its something else slowing me.
    i basically have such thing as i described above running 24/7 and cant speed it up for some reason nomatter how many threads I add.

    CPU, memory, disk, is all ok on low usage, only I/O high

    This all depends, is the data within the table long/a lot? 1million + with a high character rate?
    Have you tried other Database actions and/or filters to minimize the search criteria?
    Would an external MongoDB you set-up & configure yourself might change the I/O bottleneck?
    External DB: http://wiki.bablosoft.com/doku.php?id=how_to_setup_mongodb_server

  • Z

    Correct way to loop through all entries of a database resource?

    Support
    0 Votes
    5 Posts
    2248 Views
    ruzneR

    @andy231 said in Correct way to loop through all entries of a database resource?:

    линию в цикле или на запуск потока и отключить ресурс повторного использования, чтобы каждый раз, когд

    How about limiting the number of elements in the resource?

  • Y

    "database does not work"

    Support
    0 Votes
    1 Posts
    1174 Views
    No one has replied