Arachni / arachni

Web Application Security Scanner Framework
http://www.arachni-scanner.com
Other
3.77k stars 761 forks source link

SQLite Message - Database is locked #465

Closed gmendoza closed 10 years ago

gmendoza commented 10 years ago

ActiveRecord::StatementInvalid:0x0e1aef38 attr_reader :original_exception = #

[ [ 0] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/sqlite3-1.3.9/lib/sqlite3/statement.rb:108:in step'", [ 1] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/sqlite3-1.3.9/lib/sqlite3/statement.rb:108:inblock in each'", [ 2] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/sqlite3-1.3.9/lib/sqlite3/statement.rb:107:in loop'", [ 3] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/sqlite3-1.3.9/lib/sqlite3/statement.rb:107:ineach'", [ 4] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:149:in map'", [ 5] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:149:inblock in execute'", [ 6] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:95:in prepare'", [ 7] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:134:inexecute'", [ 8] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:517:in commit'", [ 9] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:362:inblock in commit_db_transaction'", [10] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:373:in block in log'", [11] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activesupport-4.1.4/lib/active_support/notifications/instrumenter.rb:20:ininstrument'", [12] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:367:in log'", [13] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:362:incommit_db_transaction'", [14] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/connection_adapters/abstract/transaction.rb:180:in perform_commit'", [15] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/connection_adapters/abstract/transaction.rb:120:incommit'", [16] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in commit_transaction'", [17] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/connection_adapters/abstract/database_statements.rb:215:inwithin_new_transaction'", [18] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in transaction'", [19] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/transactions.rb:208:intransaction'", [20] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/transactions.rb:326:in with_transaction_returning_status'", [21] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/transactions.rb:268:inblock in save'", [22] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/transactions.rb:283:in rollback_active_record_state!'", [23] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/activerecord-4.1.4/lib/active_record/transactions.rb:267:insave'", [24] "/home/r00t/arachni-1.0.1-0.5.2/system/arachni-ui-web/app/models/scan.rb:596:in block in refresh'", [25] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-rpc-0.2.1.1/lib/arachni/rpc/proxy.rb:58:incall'", [26] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-rpc-0.2.1.1/lib/arachni/rpc/proxy.rb:58:in block (2 levels) in translate'", [27] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-rpc-0.2.1.1/lib/arachni/rpc/client/handler.rb:77:incall'", [28] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-rpc-0.2.1.1/lib/arachni/rpc/client/handler.rb:77:in receive_response'", [29] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-rpc-0.2.1.1/lib/arachni/rpc/client/handler.rb:137:inreceive_object'", [30] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-rpc-0.2.1.1/lib/arachni/rpc/protocol.rb:52:in on_read'", [31] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor/connection.rb:236:inblock in _read'", [32] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor/connection/error.rb:26:in call'", [33] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor/connection/error.rb:26:intranslate'", [34] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor/connection.rb:235:in _read'", [35] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor.rb:568:ineach'", [36] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor.rb:568:in block in process_connections'", [37] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor.rb:568:ineach'", [38] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor.rb:568:in process_connections'", [39] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor.rb:317:inblock in run'", [40] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor.rb:308:in loop'", [41] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor.rb:308:inrun'", [42] "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/arachni-reactor-0.1.0.beta5/lib/arachni/reactor.rb:350:in `block in run_in_thread'" ]

I am running tests on an internally accessible site and this message just flashed across the screen along with a long duration of scanning that has taken place. The status timer is still increasing but there isn't a change in currently auditing as well. I've let multiple scans with this type of result, scans run for hours and nothing is logged as an issue. I would say 98% of the scans are non-credential while my most recent is the only scan to utilize credentials.

2014-09-10 15:13:10 -0700 --------------------------------------------------------------------------------

ENV:

XDG_SESSION_ID: '8' GEM_HOME: "/home/r00t/arachni-1.0.1-0.5.2/system/gems" TERM: xterm SHELL: "/bin/bash" IRBRC: "/home/r00t/arachni-1.0.1-0.5.2/bin/../system/usr/lib/ruby/.irbrc" MY_RUBY_HOME: "/home/r00t/arachni-1.0.1-0.5.2/bin/../system/usr/lib/ruby" USER: root LD_LIBRARY_PATH: "/home/r00t/arachni-1.0.1-0.5.2/bin/../system/usr/lib" LSCOLORS: 'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.lzma=01;31:.tlz=01;31:.txz=01;31:.zip=01;31:.z=01;31:.Z=01;31:.dz=01;31:.gz=01;31:.lz=01;31:.xz=01;31:.bz2=01;31:.bz=01;31:.tbz=01;31:.tbz2=01;31:.tz=01;31:.deb=01;31:.rpm=01;31:.jar=01;31:.war=01;31:.ear=01;31:.sar=01;31:.rar=01;31:.ace=01;31:.zoo=01;31:.cpio=01;31:.7z=01;31:.rz=01;31:.jpg=01;35:.jpeg=01;35:.gif=01;35:.bmp=01;35:.pbm=01;35:.pgm=01;35:.ppm=01;35:.tga=01;35:.xbm=01;35:.xpm=01;35:.tif=01;35:.tiff=01;35:.png=01;35:.svg=01;35:.svgz=01;35:.mng=01;35:.pcx=01;35:.mov=01;35:.mpg=01;35:.mpeg=01;35:.m2v=01;35:.mkv=01;35:.webm=01;35:.ogm=01;35:.mp4=01;35:.m4v=01;35:.mp4v=01;35:.vob=01;35:.qt=01;35:.nuv=01;35:.wmv=01;35:.asf=01;35:.rm=01;35:.rmvb=01;35:.flc=01;35:.avi=01;35:.fli=01;35:.flv=01;35:.gl=01;35:.dl=01;35:.xcf=01;35:.xwd=01;35:.yuv=01;35:.cgm=01;35:.emf=01;35:.axv=01;35:.anx=01;35:.ogv=01;35:.ogx=01;35:.aac=00;36:.au=00;36:.flac=00;36:.mid=00;36:.midi=00;36:.mka=00;36:.mp3=00;36:.mpc=00;36:.ogg=00;36:.ra=00;36:.wav=00;36:.axa=00;36:.oga=00;36:.spx=00;36:_.xspf=00;36:' PATH: "/home/r00t/arachni-1.0.1-0.5.2/system/gems/bin:/home/r00t/arachni-1.0.1-0.5.2/bin/../system/../bin:/home/r00t/arachni-1.0.1-0.5.2/bin/../system/usr/bin:/home/r00t/arachni-1.0.1-0.5.2/bin/../system/gems/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" MAIL: "/var/mail/root" PWD: "/home/r00t/arachni-1.0.1-0.5.2/bin" ARACHNI_WEBUI_LOGDIR: "/home/r00t/arachni-1.0.1-0.5.2/bin/../system/logs/webui" LANG: en_US.UTF-8 ARACHNI_FRAMEWORK_LOGDIR: "/home/r00t/arachni-1.0.1-0.5.2/bin/../system/logs/framework" HOME: "/root" SHLVL: '1' RAILS_ENV: production DYLD_LIBRARY_PATH: "/home/r00t/arachni-1.0.1-0.5.2/bin/../system/usr/lib:" LOGNAME: root GEM_PATH: "/home/r00t/arachni-1.0.1-0.5.2/bin/../system/gems" LESSOPEN: "| /usr/bin/lesspipe %s" XDG_RUNTIME_DIR: "/run/user/1000" RUBYLIB: "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/bundler-1.7.2/lib:/home/r00t/arachni-1.0.1-0.5.2/bin/../system/usr/lib/ruby:/home/r00t/arachni-1.0.1-0.5.2/bin/../system/usr/lib/ruby/site_ruby/2.1.0:/home/r00t/arachni-1.0.1-0.5.2/bin/../system/usr/lib/ruby/2.1.0:/home/r00t/arachni-1.0.1-0.5.2/bin/../system/usr/lib/ruby/2.1.0/x86_64-linux:/home/r00t/arachni-1.0.1-0.5.2/bin/../system/usr/lib/ruby/site_ruby/2.1.0/x86_64-linux" RUBY_VERSION: ruby-2.1.1 LESSCLOSE: "/usr/bin/lesspipe %s %s" RACK_ENV: development BUNDLE_GEMFILE: "/home/r00t/arachni-1.0.1-0.5.2/system/arachni-ui-web/Gemfile" _ORIGINAL_GEM_PATH: "/home/r00t/arachni-1.0.1-0.5.2/bin/../system/gems" BUNDLE_BIN_PATH: "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/bundler-1.7.2/bin/bundle" RUBYOPT: "-rbundler/setup" MANPATH: "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/kramdown-1.4.1/man"

BUNDLE_ORIG_MANPATH: "/home/r00t/arachni-1.0.1-0.5.2/system/gems/gems/kramdown-1.4.1/man"

OPTIONS: --- !ruby/object:Arachni::Options browser_cluster: !ruby/object:Arachni::OptionGroups::BrowserCluster pool_size: 6 job_timeout: 120 worker_time_to_live: 100 ignore_images: false screen_width: 1600 screen_height: 1200 session: !ruby/object:Arachni::OptionGroups::Session {} scope: !ruby/object:Arachni::OptionGroups::Scope redundant_path_patterns: {} dom_depth_limit: 12 exclude_path_patterns: [] exclude_content_patterns: [] include_path_patterns: [] restrict_paths: [] extend_paths: [] url_rewrites: {} include_subdomains: false https_only: false dispatcher: !ruby/object:Arachni::OptionGroups::Dispatcher node_ping_interval: 60.0 instance_port_range:

Zapotek commented 10 years ago

Hey there,

As the welcome screen of the WebUI mentioned, SQLite3 is not sufficient for larger workloads. You can resolve this issue by switching to PostgreSQL: https://github.com/Arachni/arachni-ui-web/wiki/database#postgresql

Cheers